How to create hive meta store table in parquet with snappy?


#1

When i create a hive meta store table in spark, it was getting created the table and the file default format is text.

Is there anyway we can create the hive meta store table in parquet with snappy format?

Thanks.


#2

@sbklog2018 Can you share the command and output file screenshot ?


#3

Hi,
The command is pretty straight forward right.
sqlContext.sql(“create table result_db.result1 as select * from temp_tab”);

When you look in hive the table looks in below format
STORED AS INPUTFORMAT
‘org.apache.hadoop.mapred.TextInputFormat’
OUTPUTFORMAT
‘org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat’
LOCATION
'hdfs://quickstart.cloudera:8020/user/hive/warehouse/result_db.db/result1

Is there a way we can create them with snappy & parquet while creating a table?


#4

@sbklog2018 I hope this discussion will help you.