Welcome to the Cloudera Community

Announcements
Celebrating as our community reaches 100,000 members! Thank you!

Who agreed with this topic

Character Limit for Impala Column

avatar
Champion Alumni

Hello,

I am trying to create a table in impala (cdh 5.5)  but it fails with the below error message.The parquet file has many struct data types which is more than 4000 characters long.I did not face this issue when using hive but suprisingly came up for Impala.I would appreciate any  solution.


[quickstart.cloudera:21000] > CREATE TABLE columns_from LIKE PARQUET '/projects/dps/test/parquet/test.parquet' STORED AS PARQUET;
Query: create TABLE columns_from LIKE PARQUET '/projects/dps/test/parquet/test.parquet' STORED AS PARQUET
ERROR: AnalysisException: Type of column 'segment1' exceeds maximum type length of 4000 characters:

Who agreed with this topic