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

Post a Comment

Popular posts from this blog

android - How to save instance state of selected radiobutton on menu -

i have options menu in toolbar radibutton item : <item android:id="@+id/map_menu" android:icon="@drawable/ic_layer" android:orderincategory="102" app:showasaction="always" android:title="@string/action_settings"> <menu> <group android:id="@+id/map_types_group" android:checkablebehavior="single" > <item android:id="@+id/map_terrain" android:orderincategory="1" app:showasaction="ifroom" android:title="@string/map_terrain"/> <item android:id="@+id/map_normal" android:orderincategory="2" android:checked="true" app:showasaction="ifroom" android:title="@string/map_normal"/> ...
Read more

python 3 IndexError: list index out of range -

my problem average value on won't show returns error traceback (most recent call last): (file location), line 29, in <module> average_score = [[x[8],x[0]] x in a_list] (file location), line 29, in <listcomp> average_score = [[x[8],x[0]] x in a_list] indexerror: list index out of range the code import csv class_a = open('class_a.txt') csv_a = csv.reader(class_a) a_list = [] row in csv_a: row[3] = int(row[3]) row[4] = int(row[4]) row[5] = int(row[5]) minimum = min(row[3:5]) row.append(minimum) maximum = max(row[3:5]) row.append(maximum) average = sum(row[3:5])//3 row.append(average) a_list.append(row[0:8]) print(row[8]) this works when test out values 0 7 ,even if change location of avarage sum still error when call a_list.append(row[0:8]) you're appending array using indexes 0, 1, 2, 3, 4, 5, 6, , 7 row . means when later iterate a_list , x variable has indexes 7, , you're trying a...
Read more

IF statement in MySQL trigger -

this query code in mysql trigger. if 1=2 select 'yes'; else select 'no'; end if; but has following error: if '1'='2' select 'yes' error code: 1064. have error in sql syntax; check manual corresponds mysql server version right syntax use near 'if '1'='2' select 'yes'' @ line 1 0.000 sec what solution?
Read more