Write data into hive table in a parquet

Question

I want to write data into hive table in a parquet format from an external file. How can I achieve this?

Answer 1

Below is an example query which you can execute to create a hive external table to load a parquet file:

create external table parquet_table_name (x INT, y STRING)  
ROW FORMAT SERDE 'parquet.hive.serde.ParquetHiveSerDe'  
STORED AS     
INPUTFORMAT "parquet.hive.DeprecatedParquetInputFormat"    
OUTPUTFORMAT "parquet.hive.DeprecatedParquetOutputFormat"    
LOCATION '/test-warehouse/tinytable';

To know more, It's recommended to join Big Data Online Course today.