Saving all output to "!!{outputDirectory}!!/loadpart1.q.raw". Enter "record" with no arguments to stop it.
>>>  !run !!{qFileDirectory}!!/loadpart1.q
>>>  
>>>  
>>>  
>>>  create table hive_test_src ( col1 string ) stored as textfile ;
No rows affected 
>>>  load data local inpath '../data/files/test.dat' overwrite into table hive_test_src ;
No rows affected 
>>>  
>>>  create table hive_test_dst ( col1 string ) partitioned by ( pcol1 string , pcol2 string) stored as sequencefile;
No rows affected 
>>>  insert overwrite table hive_test_dst partition ( pcol1='test_part', pCol2='test_Part') select col1 from hive_test_src ;
'col1'
No rows selected 
>>>  select * from hive_test_dst where pcol1='test_part' and pcol2='test_Part';
'col1','pcol1','pcol2'
'1','test_part','test_Part'
'2','test_part','test_Part'
'3','test_part','test_Part'
'4','test_part','test_Part'
'5','test_part','test_Part'
'6','test_part','test_Part'
6 rows selected 
>>>  
>>>  insert overwrite table hive_test_dst partition ( pCol1='test_part', pcol2='test_Part') select col1 from hive_test_src ;
'col1'
No rows selected 
>>>  select * from hive_test_dst where pcol1='test_part' and pcol2='test_part';
'col1','pcol1','pcol2'
No rows selected 
>>>  
>>>  select * from hive_test_dst where pcol1='test_part';
'col1','pcol1','pcol2'
'1','test_part','test_Part'
'2','test_part','test_Part'
'3','test_part','test_Part'
'4','test_part','test_Part'
'5','test_part','test_Part'
'6','test_part','test_Part'
6 rows selected 
>>>  select * from hive_test_dst where pcol1='test_part' and pcol2='test_part';
'col1','pcol1','pcol2'
No rows selected 
>>>  select * from hive_test_dst where pcol1='test_Part';
'col1','pcol1','pcol2'
No rows selected 
>>>  
>>>  
>>>  
>>>  !record