My Oracle Support Banner

On Oracle Big Data Applaince , Hive Select on Table with Large Schema Fails (Doc ID 2128208.1)

Last updated on NOVEMBER 05, 2018

Applies to:

Big Data Appliance Integrated Software - Version 4.1.0 to 4.4.0 [Release 4.1 to 4.4]
Linux x86-64


On Oracle Big Data Appliance selecting from a Hive table with a large avsc file fails with error.

hive> select * from eligibility;
FAILED: SemanticException java.lang.IllegalArgumentException: Error: name expected at the position 50 of 'string:str

Originally create table statement failed which is resolved by increasing TYPE_NAME column size in COLUMNS_V2 table as stated in

CREATE external TABLE eligibility ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.avro.AvroSerDe' STORED as INPUTFORMAT '' OUTPUTFORMAT '' location '/user/oracle' TBLPROPERTIES ('avro.schema.url'='hdfs:///user/oracle/kelg.avsc');
Error: Error while processing statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. MetaException(message:javax.jdo.JDODataStoreException: Add request failed : INSERT INTO `COLUMNS_V2` (`CD_ID`,`COMMENT`,`COLUMN_NAME`,`TYPE_NAME`,`INTEGER_IDX`) VALUES (?,?,?,?,?)
java.sql.BatchUpdateException: Data truncation: Data too long for column 'TYPE_NAME' at row 1
Caused by: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'TYPE_NAME' at row 1



To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.