Hive / HCatalog Forum
Data Truncation in PARAM VALUE column on SERDE_PARAMS
I have HDP 2 installed.
My HIVE view creation on the Hbase table (5300 columns – 25 column families) is failing with the below error.
Its working fine, if i limit the columns in the view.
I believe there is a limit of 4000 Char for column PARAM_VALUE in SERDE_PARAMS.
Caused by: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column ‘PARAM_VALUE’ at row 1
Is there is way to increase it. if so what should I do?
Support from the Experts
A HDP Support Subscription connects you experts with deep experience running Apache Hadoop in production, at-scale on the most demanding workloads.
Become HDP Certified
Real world training designed by the core architects of Hadoop. Scenario-based training courses are available in-classroom or online from anywhere in the world