hadoop-hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Yang Yang (JIRA)" <j...@apache.org>
Subject [jira] Commented: (HIVE-777) CREATE TABLE with STRUCT type
Date Fri, 25 Jun 2010 09:09:56 GMT

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

Yang Yang commented on HIVE-777:
--------------------------------

I see that creating a table with struct works, and I can select the struct field.

but GROUP BY on a struct field is not supported now. (see following msg)

is there a plan to support this?

Thanks
Yang


java.lang.RuntimeException: Error while closing operators
	at org.apache.hadoop.hive.ql.exec.ExecMapper.close(ExecMapper.java:232)
	at org.apache.hadoop.mapred.MapRunner.run(MapRunner.java:57)
	at org.apache.hadoop.mapred.MapTask.runOldMapper(MapTask.java:356)
	at org.apache.hadoop.mapred.MapTask.run(MapTask.java:305)
	at org.apache.hadoop.mapred.Child.main(Child.java:170)
Caused by: org.apache.hadoop.hive.ql.metadata.HiveException: java.lang.RuntimeException: Hash
code on complex types not supported yet.
	at org.apache.hadoop.hive.ql.exec.GroupByOperator.closeOp(GroupByOperator.java:799)
	at org.apache.hadoop.hive.ql.exec.Operator.close(Operator.java:462)
	at org.apache.hadoop.hive.ql.exec.Operator.close(Operator.java:470)
	at org.apache.hadoop.hive.ql.exec.Operator.close(Operator.java:470)
	at org.apache.hadoop.hive.ql.exec.Operator.close(Operator.java:470)
	at org.apache.hadoop.hive.ql.exec.ExecMapper.close(ExecMapper.java:211)
	... 4 more
Caused by: java.lang.RuntimeException: Hash code on complex types not supported yet.
	at org.apache.hadoop.hive.serde2.objectinspector.ObjectInspectorUtils.hashCode(ObjectInspectorUtils.java:348)
	at org.apache.hadoop.hive.ql.exec.ReduceSinkOperator.processOp(ReduceSinkOperator.java:187)
	at org.apache.hadoop.hive.ql.exec.Operator.process(Operator.java:386)
	at org.apache.hadoop.hive.ql.exec.Operator.forward(Operator.java:598)
	at org.apache.hadoop.hive.ql.exec.GroupByOperator.forward(GroupByOperator.java:746)
	at org.apache.hadoop.hive.ql.exec.GroupByOperator.closeOp(GroupByOperator.java:780)
	... 9 more

> CREATE TABLE with STRUCT type
> -----------------------------
>
>                 Key: HIVE-777
>                 URL: https://issues.apache.org/jira/browse/HIVE-777
>             Project: Hadoop Hive
>          Issue Type: New Feature
>          Components: Query Processor
>            Reporter: Zheng Shao
>            Assignee: He Yongqiang
>             Fix For: 0.5.0
>
>         Attachments: hive-777-2009-8-21-2.patch, hive-777-2009-8-21.patch, hive-777-2009-8-29.patch
>
>
> Currently we only support map/array in type definition.
> We should support STRUCT as well.
> {code}
> CREATE TABLE abc (
>   pageid INT,
>   ads STRUCT<adid:INT,location:STRING>,
>   userid INT
> );
> {code}

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


Mime
View raw message