hdfs dfs -ls /user/admin/demo/emp/
---rw-r--r--   3 admin admin      39169 2021-01-17 17:42 /user/admin/demo/emp/employee_metadata.csv

CREATE DATABASE demo LOCATION '/data/warehouse/demo.db';

CREATE TABLE `demo.employee_metadata`(`factory_id` string,
                                `employee_id` string,
                                `gender` string,
                                `email` string,
                                `occupation` string,
                                `birthdate` string,
                                `salary` DOUBLE) 
ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe' 
WITH SERDEPROPERTIES ('colelction.delim'='�','field.delim'=',','mapkey.delim'='�','serialization.format'=',') 
STORED AS INPUTFORMAT 'org.apache.hadoop.mapred.TextInputFormat' 
OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat' 
LOCATION 'hdfs://cdh-master-01.poc.yits.com:8020/data/warehouse/demo.db/employee_metadata' 
TBLPROPERTIES ('skip.header.line.count'='1');

LOAD DATA INPATH '/user/admin/demo/emp/*' OVERWRITE INTO TABLE demo.employee_metadata;
LOAD DATA INPATH '/user/admin/demo/emp/*' INTO TABLE demo.employee_metadata;

SELECT * FROM demo.employee_metadata where factory_id = 9 LIMIT 100;
SELECT COUNT(*) from demo.employee_metadata;

CREATE TABLE `demo.employee_metadata_orc1`(`factory_id` string,
                                `employee_id` string,
                                `gender` string,
                                `email` string,
                                `occupation` string,
                                `birthdate` string,
                                `salary` DOUBLE) 
STORED AS ORC
LOCATION 'hdfs://cdh-master-01.poc.yits.com:8020/data/warehouse/demo.db/employee_metadata_orc1';

INSERT OVERWRITE TABLE demo.employee_metadata_orc1 SELECT * FROM demo.employee_metadata;