5YF66Bf2

1create external table demo_project_data(data string) PARTITIONED BY (business_date string, src_sys_file_nm string, prd_typ_cd string) 
2ROW FORMAT DELIMITED FIELDS TERMINATED BY '|'
3LINES TERMINATED BY 'n'
4LOCATION '/user/hive/warehouse/demo/project/data';
5
6
7hadoop fs -mkdir -p /user/hive/warehouse/demo/project/data/business_date='20180707'/src_sys_file_nm='a_b_c_20180707_1.dat.gz'/prd_typ_cd='abcd'
8
9
10echo "ALTER TABLE brie_wave2.brie_ach_fotp ADD IF NOT EXISTS PARTITION(business_date='20180707',src_sys_file_nm='ach_ach_fotp_20180707_1.dat.gz',prd_typ_cd='ach')
11LOCATION '/user/hive/warehouse/demo/project/data/business_date='20180707'/src_sys_file_nm='a_b_c_20180707_1.dat.gz'/prd_typ_cd='abcd';"|hive
12
13hadoop fs -cp /apps/tdi/data/a_b_c_20180707_1.dat.gz /user/hive/warehouse/demo/project/data/business_date='20180707'/src_sys_file_nm='a_b_c_20180707_1.dat.gz'/prd_typ_cd='abcd'
14
15echo "INSERT OVERWRITE DIRECTORY '/user/20180707'  select *,'~karthick~kb~demo' from demo_project_data where src_sys_file_nm='a_b_c_20180707_1.dat.gz' and business_date='20180707' and prd_typ_cd='abcd';"|hive