Hello, I got the following error when creating a table with a column that has an ARRAY of STRUCTS with many fields. It appears that there is a 128 character limit on the column definition.
FAILED: Error in metadata: javax.jdo.JDODataStoreException: Add request failed : INSERT INTO COLUMNS (SD_ID,COMMENT,"COLUMN_NAME",TYPE_NAME,INTEGER_IDX) VALUES (?,?,?,?,?) NestedThrowables: java.sql.BatchUpdateException: A truncation error was encountered trying to shrink VARCHAR 'array<struct<id:int,fld1:bigint,fld2:int,fld3&' to length 128. FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask I was able to get table create working after changing 128 to 256 in /metastore/src/model/package.jdo. Does anyone know if there are any adverse side-effects of doing so? Dilip
