[HIVE-192] DUPLICATE: Add TIMESTAMP column type for thrift dynamic_type

• Type: New Feature
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.8.0
• Component/s: Query Processor
• Labels: SQL
• Assignee: Shyam Sundar Sarkar
• Reporter: Johan Oskarsson
• Created: 22/Dec/08 17:42
• Updated: 01/Mar/12 22:09
• Resolved: 23/Oct/11 20:25

Description

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)

Issue Links

• is required by: HIVE-1386 HiveQL SQL Compliance (Umbrella)
• relates to: HIVE-1269 Support Date/Datetime/Time/Timestamp Primitive Types