hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ashish Thusoo (JIRA)" <>
Subject [jira] Commented: (HIVE-192) Cannot create table with timestamp type column
Date Tue, 10 Mar 2009 21:16:50 GMT


Ashish Thusoo commented on HIVE-192:

I went through the write up and it looks quite comprehensive from the DDL point of view. Here
are a few comments:

1. I think we can drop ON UPDATE all together as we do not support UPDATE in Hive at this
2. auto increment is a nice to have feature since it can be achieved with by providing a now()
UDF in hive, it is definitely a good feature to have though.
3. Would be great if you could also add the UDFs that could be added to timestamps. Mysql
has a bunch of these. Some that directly come to mind are day(ts), month(ts), year(ts) etc,
and to_timestamp function as namit pointed out.

As far as storage is concerned, that would depend on the serde in question...

> Cannot create table with timestamp type column
> ----------------------------------------------
>                 Key: HIVE-192
>                 URL:
>             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(
> 	at org.apache.hadoop.hive.serde2.dynamic_type.thrift_grammar.Field(
> 	at org.apache.hadoop.hive.serde2.dynamic_type.thrift_grammar.FieldList(
> 	at org.apache.hadoop.hive.serde2.dynamic_type.thrift_grammar.Struct(
> 	at org.apache.hadoop.hive.serde2.dynamic_type.thrift_grammar.TypeDefinition(
> 	at org.apache.hadoop.hive.serde2.dynamic_type.thrift_grammar.Definition(
> 	at org.apache.hadoop.hive.serde2.dynamic_type.thrift_grammar.Start(
> 	at org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe.initialize(
> 	at org.apache.hadoop.hive.metastore.MetaStoreUtils.getDeserializer(
> 	at org.apache.hadoop.hive.ql.metadata.Table.initSerDe(
> 	at org.apache.hadoop.hive.ql.metadata.Hive.createTable(
> 	at org.apache.hadoop.hive.ql.exec.DDLTask.createTable(
> 	at org.apache.hadoop.hive.ql.exec.DDLTask.execute(
> 	at
> 	at org.apache.hadoop.hive.cli.CliDriver.processCmd(
> 	at org.apache.hadoop.hive.cli.CliDriver.processLine(
> 	at org.apache.hadoop.hive.cli.CliDriver.main(

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

View raw message