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

Shyam Sundar Sarkar commented on HIVE-192:
------------------------------------------

Ok. After lot of inspection over the MySQL 6.0 spec and Hive grammar, I decided 
to implement TIMESTAMP as
a primitive type which will be stored and retrived as a string of characters.  
Also we have to implement one
UDF to retrieve TIMESTAMP in certain formats from stored data. We have to 
implement eventually something 
called TimeZone inside Hive server for storage and retrieval of UTC time.  
Right now we can use system time.


> 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
>            Priority: Blocker
>             Fix For: 0.2.0
>
>         Attachments: 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.

Reply via email to