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

Ashutosh Chauhan commented on HCATALOG-71:
------------------------------------------

I can't reproduce this. This exact command succeeded for me. 
{code}
$ hcat -e "create table test1(id STRING, props STRUCT<obj_field1 : STRING, 
obj_field2 : STRING, obj_field3 : STRING, obj_field4 : STRING, obj_field5 : 
STRING, obj_field6 : STRING, obj_f7 : STRING>) stored as RCFILE location 
'/user/hcat/my table';"
OK
$ hcat -e "describe   test111;"
id      string  from deserializer
props   
struct<obj_field1:string,obj_field2:string,obj_field3:string,obj_field4:string,obj_field5:string,obj_field6:string,obj_f7:string>
       from deserializer
{code}  

I tried with longer ones, even they succeeded.
{code}
hcat -e "create table test212(id STRING, props STRUCT<obj_field1 : STRING, 
obj_field2 : STRING, obj_field3 : STRING, obj_field4 : STRING, obj_field5 : 
STRING, obj_field6 : STRING, obj_f7 : STRING, obj_field12 : int, obj_field11 : 
string>) stored as RCFILE location '/user/hcat/my table';"
OK
$ hcat -e "describe   test212;"
OK
id      string  from deserializer
props   
struct<obj_field1:string,obj_field2:string,obj_field3:string,obj_field4:string,obj_field5:string,obj_field6:string,obj_f7:string,obj_field12:int,obj_field11:string>
    from deserializer

{code}

> Limit on schema size for create table
> -------------------------------------
>
>                 Key: HCATALOG-71
>                 URL: https://issues.apache.org/jira/browse/HCATALOG-71
>             Project: HCatalog
>          Issue Type: Bug
>    Affects Versions: 0.1
>            Reporter: Olga Natkovich
>
> We have encountered an error while trying to create table with schema that is 
> 128 bytes or longer. Is this a known limitation on size of a field?
> The following command fails.
> hcat -e "create table test1(id STRING, props STRUCT<obj_field1 : STRING, 
> obj_field2 : STRING, obj_field3 : STRING, obj_field4 : STRING, obj_field5 : 
> STRING, obj_field6 : STRING, obj_f7 : STRING>) stored as RCFILE location 
> '/mylocation/my table';"
> Error:
> FAILED: Error in metadata: org.apache.thrift.TApplicationException: Internal 
> error processing create_table
> FAILED: Execution Error, return code 1 from 
> org.apache.hadoop.hive.ql.exec.DDLTask
> The same command with a single char reduced succeeds.

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

Reply via email to