AnsweredAssumed Answered

Error while creating hive external Table with Parquet data file format

Question asked by ssat_bi on Mar 29, 2016
Latest reply on Apr 11, 2016 by ssat_bi

I have few files in MapRFS as parquet file format. I am trying to create an external table referencing those files and I receive the following error.

FAILED: SemanticException [Error 10055]: Output Format must implement HiveOutputFormat, otherwise it should be either IgnoreKeyTextOutputFormat or SequenceFileOutputFormat

 

Here is the hive external table create statement

 

create external table XYZ_INBOUND (ROW_NUMBER STRING, FILE_FORMAT STRING, UPLOAD_FILENAME STRING) ROW FORMAT SERDE 'parquet.hive.serde.ParquetHiveSerDe' STORED AS INPUTFORMAT "parquet.hive.DeprecatedParquetInputFormat" OUTPUTFORMAT "parquet.hive.DeprecatedParquetOutputFormat" LOCATION '/user/uname/XYZ/B2B';

 

Can you please help me resolve the issue?

Outcomes