[jira] Commented: (HIVE-777) CREATE TABLE with STRUCT type

[Yang Yang (JIRA)]

    [ 
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.