dropbox / dropbox/PyHive

create hive table and get 'timestamp is not supported'

Open
#220 0 comments 3 reactions 0 assignees View on GitHub
Dominant language
Python
Stars
1.7k
Forks
545
PR merge metrics
No merged PRs in 30d

Description

**I have used HiveDate and HiveTimestamp but still get the error:**
TExecuteStatementResp(status=TStatus(statusCode=3, infoMessages=['*org.apache.hive.service.cli.HiveSQLException:Error while processing statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask.
**My code is:**
`cols=[]
cols.append(Column('t_int', sqlalchemy.INT))
cols.append(Column('t_decimal', HiveDecimal))
cols.append(Column('t_boolean', sqlalchemy.BOOLEAN))
cols.append(Column('t_smallint', sqlalchemy.SMALLINT))
cols.append(Column('t_date', HiveDate))
cols.append(Column('t_timestamp', HiveTimestamp))
table = Table('gyy_test_table', MetaData(bind=engine), *cols, schema='default')
table.drop(checkfirst=True)
table.create()`

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.