hadoop-hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Shyam Sundar Sarkar (JIRA)" <j...@apache.org>
Subject [jira] Commented: (HIVE-192) Cannot create table with timestamp type column
Date Fri, 24 Apr 2009 13:13:30 GMT

    [ https://issues.apache.org/jira/browse/HIVE-192?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12702362#action_12702362

Shyam Sundar Sarkar commented on HIVE-192:


I was debugging Hive SQL.  I found that Hive talks to Thrift software layer. From the documentation
it is clear that there is no
TIMESTAMP type in thrift type system. 

I am curious if we need to add TIMESTAMP type to Thrift as a basic type. TIMESTAMP type is
there in almost all software systems.
If we do not add TIMESTAMP type to Thrift, should we map it to long Integer or a struct type?

Any suggestions?


> Cannot create table with timestamp type column
> ----------------------------------------------
>                 Key: HIVE-192
>                 URL: https://issues.apache.org/jira/browse/HIVE-192
>             Project: Hadoop Hive
>          Issue Type: Bug
>          Components: Query Processor
>    Affects Versions: 0.2.0
>            Reporter: Johan Oskarsson
>             Fix For: 0.4.0
>         Attachments: create_2.q.txt, TIMESTAMP_specification.txt
> create table something2 (test timestamp);
> ERROR: DDL specifying type timestamp which has not been defined
> java.lang.RuntimeException: specifying type timestamp which has not been defined
> 	at org.apache.hadoop.hive.serde2.dynamic_type.thrift_grammar.FieldType(thrift_grammar.java:1879)
> 	at org.apache.hadoop.hive.serde2.dynamic_type.thrift_grammar.Field(thrift_grammar.java:1545)
> 	at org.apache.hadoop.hive.serde2.dynamic_type.thrift_grammar.FieldList(thrift_grammar.java:1501)
> 	at org.apache.hadoop.hive.serde2.dynamic_type.thrift_grammar.Struct(thrift_grammar.java:1171)
> 	at org.apache.hadoop.hive.serde2.dynamic_type.thrift_grammar.TypeDefinition(thrift_grammar.java:497)
> 	at org.apache.hadoop.hive.serde2.dynamic_type.thrift_grammar.Definition(thrift_grammar.java:439)
> 	at org.apache.hadoop.hive.serde2.dynamic_type.thrift_grammar.Start(thrift_grammar.java:101)
> 	at org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe.initialize(DynamicSerDe.java:97)
> 	at org.apache.hadoop.hive.metastore.MetaStoreUtils.getDeserializer(MetaStoreUtils.java:180)
> 	at org.apache.hadoop.hive.ql.metadata.Table.initSerDe(Table.java:141)
> 	at org.apache.hadoop.hive.ql.metadata.Hive.createTable(Hive.java:202)
> 	at org.apache.hadoop.hive.ql.exec.DDLTask.createTable(DDLTask.java:641)
> 	at org.apache.hadoop.hive.ql.exec.DDLTask.execute(DDLTask.java:98)
> 	at org.apache.hadoop.hive.ql.Driver.run(Driver.java:215)
> 	at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:174)
> 	at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:207)
> 	at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:305)

This message is automatically generated by JIRA.
You can reply to this email to add a comment to the issue online.

View raw message