Convert file types using hive

hive file type conversion.sql

-- create a avro table
create table t_avro (col1 Int) stored as AVRO;
insert into table t_avro values (1),(2),(3),(4);

-- *INFO* If we want to create avro with custom schema file (avsc) do the following
--Option1: create table t_avro (col1 Int) stored as AVRO tblproperties('avro.schema.url'='/user/hive/schemas/t_avro/t_avro.avsc')
--Option2: create table t_avro (col1 Int) stored as AVRO tblproperties('avro.schema.literal'='{
--            "name": "t_avro_schema",
--            "type": "record",
--            "fields": [ { "col1":"Int" }]
--          }');
--

-- create parquet table from existing table
create table t_parquet stored as parquet as select * from t_avro;

-- create orc table from existing table
create table t_orc stored as orc as select * from t_parquet;

--verify schema of parquet data files created by hive
hdfs dfs -get /user/hive/warehouse/t_parquet/* /home/cloudera/t_parquet/;
parquet-tools schema <file>;