You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Namit Jain (JIRA)" <ji...@apache.org> on 2009/03/10 19:34:50 UTC
[jira] Commented: (HIVE-192) Cannot create table with timestamp
type column
[ https://issues.apache.org/jira/browse/HIVE-192?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12680575#action_12680575 ]
Namit Jain commented on HIVE-192:
---------------------------------
For the first cut, we dont need so much flexibility. Let us only support one default format.
We can have a to_timestamp() function which takes in the format, that function can be enhanced to support more formats on demand.
> 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.