Convert CSV to Parquet in favor to Cloudera Impala

convert_data_type_in_HIVE.hql

-- From CSV to Parquet in favor to Cloudera Impala
CREATE EXTERNAL TABLE IF NOT EXISTS [from_table] (
		schema DATA_TYPE,
    ...
	)
	COMMENT 'A sample of vehicle infomation'
	ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.OpenCSVSerde'
	WITH SERDEPROPERTIES (
	   "separatorChar" = ",",
	   "quoteChar"     = "\""
	)  
	LOCATION '/user/cloudera/path/to/source.csv'
  tblproperties ("skip.header.line.count"="1");

-- Conversion
CREATE EXTERNAL TABLE IF NOT EXISTS [target_table] (
		same_schema DATA_TYPE,
    ...
	)
	STORED AS PARQUET
  LOCATION '/user/cloudera/path/to/target';

INSERT overwrite TABLE [target_table] SELECT * FROM [from_table];