Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

Change input and output format of existing hive table

avatar
Expert Contributor

Hi,

 

How do we change the InputFormat and OutputFormat of an existing Hive table?

 

I tried below, but got an error:

alter table <table name> SET InputFormat "org.apache.hadoop.hive.ql.io.parquet.MapredParquetInputFormat";

 

Error:

Cannot recognize input near 'SET' 'InputFormat' 'org.apache.hadoop.hive.ql.io.parquet.MapredParquetInputFormat'

 

Kindly suggest

1 ACCEPTED SOLUTION

avatar
Master Collaborator

@snm1523 It should be SET FILEFORMAT INPUTFORMAT... Please try it as follows.

ALTER TABLE alter_file_format_test SET FILEFORMAT INPUTFORMAT 'org.apache.hadoop.hive.ql.io.parquet.MapredParquetInputFormat' OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.parquet.MapredParquetOutputFormat' SERDE 'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe';

View solution in original post

2 REPLIES 2

avatar
Master Collaborator

@snm1523 It should be SET FILEFORMAT INPUTFORMAT... Please try it as follows.

ALTER TABLE alter_file_format_test SET FILEFORMAT INPUTFORMAT 'org.apache.hadoop.hive.ql.io.parquet.MapredParquetInputFormat' OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.parquet.MapredParquetOutputFormat' SERDE 'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe';

avatar
Expert Contributor

@smruti - thank you for the response