hadoop - Unable to create a parquet hive table with a column data type 'STRING' -


i using hive-0.12. created parquet table using below query.

hive> create table ptest1 (a int, b double)  row format serde 'parquet.hive.serde.parquethiveserde'  stored inputformat 'parquet.hive.deprecatedparquetinputformat' outputformat 'parquet.hive.deprecatedparquetoutputformat'; ok time taken: 0.124 seconds 

but when using 'string' column data type failing.

hive> create table ptest1 (a int, b string)  row format serde 'parquet.hive.serde.parquethiveserde'  stored inputformat 'parquet.hive.deprecatedparquetinputformat'  outputformat 'parquet.hive.deprecatedparquetoutputformat';  failed: execution error, return code 1 org.apache.hadoop.hive.ql.exec.ddltask.  not initialize class org.apache.hadoop.hive.ql.io.parquet.serde.primitive.parquetprimitiveinspectorfactory 

pls suggest might wrong here.

thank you.

i solved problem of mine adding below few jars hive.

add jar parquet-avro-1.2.5.jar; add jar parquet-cascading-1.2.5.jar; add jar parquet-column-1.2.5.jar; add jar parquet-common-1.2.5.jar; add jar parquet-encoding-1.2.5.jar; add jar parquet-generator-1.2.5.jar; add jar parquet-hadoop-1.2.5.jar; add jar parquet-hive-1.2.5.jar; add jar parquet-pig-1.2.5.jar; add jar parquet-scrooge-1.2.5.jar; add jar parquet-test-hadoop2-1.2.5.jar; add jar parquet-thrift-1.2.5.jar; add jar parquet-format-1.0.0.jar; 

now working fine. thank you.


Comments

Popular posts from this blog

IF statement in MySQL trigger -

c++ - What does MSC in "// appease MSC" comments mean? -

javascript - Blogger related post gadget image Resize s72-c [ Need Expert Help ] -