Change input and output format of existing hive table

[#1]

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

[#2 · Accepted solution]

@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';

[#3]

@smruti - thank you for the response