Hive : Either list of columns or a custom serializer should be specified

hive
#1

Hi Everyone ,

I am not sure why i am not able to create a parquet table. Kindly help.

create table orders_parq
> stored as parquet
> tblproperties (‘avro.schema.url’=’/user/cloudera/parquet/.metadata/schema.avsc’);
FAILED: SemanticException [Error 10043]: Either list of columns or a custom serializer should be specified
hive> create table orders_parq
> stored as parquet
> tblproperties (‘avro.schema.url’=‘hdfs://localhost/user/cloudera/parquet/.metadata/schema.avsc’);
FAILED: SemanticException [Error 10043]: Either list of columns or a custom serializer should be specified
hive> create table orders_parq
> stored as
> parquet
> tblproperties (‘avro.schema.url’=‘hdfs://localhost/user/cloudera/parquet/.metadata/schema.avsc’);
FAILED: SemanticException [Error 10043]: Either list of columns or a custom serializer should be specified

Thanks
sPradeep

0 Likes

#2

I have also tried
hive> create table orders_parq
> row format delimited fields terminated by ‘,’
> stored as parquet
> location = ‘/user/cloudera/parquet’
> tblproperties(‘avro.schema.url’="/user/cloudera/parquet/schema.avsc");
FAILED: ParseException line 4:9 extraneous input ‘=’ expecting StringLiteral near ‘’

0 Likes