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

["Satyajit varma (JIRA)" <ji...@apache.org>]

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

Satyajit varma commented on HIVE-777:
-------------------------------------

Hi ,

Would like to know, if there is any kind of restriction with the number of fields to be used in the STRUCT type, as i am having issues with having more than 266 fields inside a STRUCT type.

i was able to create the Table with no issues, but SHOW CREATE TABLE doesnt show fields are 266 field and queries fail with the same error.

PFB Jira link,_https://issues.apache.org/jira/browse/HIVE-13203.

Please reply in case there is any workaround to accept more fields.

Thank you.

> CREATE TABLE with STRUCT type
> -----------------------------
>
>                 Key: HIVE-777
>                 URL: https://issues.apache.org/jira/browse/HIVE-777
>             Project: 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 was sent by Atlassian JIRA
(v6.3.4#6332)