Saving all output to "!!{outputDirectory}!!/create_like2.q.raw". Enter "record" with no arguments to stop it.
>>>  !run !!{qFileDirectory}!!/create_like2.q
>>>  -- Tests the copying over of Table Parameters according to a HiveConf setting
>>>  -- when doing a CREATE TABLE LIKE.
>>>  
>>>  CREATE TABLE table1(a INT, b STRING);
No rows affected 
>>>  ALTER TABLE table1 SET TBLPROPERTIES ('a'='1', 'b'='2', 'c'='3', 'd' = '4');
No rows affected 
>>>  
>>>  SET hive.ddl.createtablelike.properties.whitelist=a,c,D;
No rows affected 
>>>  CREATE TABLE table2 LIKE table1;
No rows affected 
>>>  DESC FORMATTED table2;
'col_name','data_type','comment'
'# col_name            ','data_type           ','comment             '
'','',''
'a                   ','int                 ','None                '
'b                   ','string              ','None                '
'','',''
'# Detailed Table Information','',''
'Database:           ','create_like2        ',''
'Owner:              ','!!{user.name}!!                ',''
'CreateTime:         ','!!TIMESTAMP!!',''
'LastAccessTime:     ','UNKNOWN             ',''
'Protect Mode:       ','None                ',''
'Retention:          ','0                   ',''
'Location:           ','!!{hive.metastore.warehouse.dir}!!/create_like2.db/table2',''
'Table Type:         ','MANAGED_TABLE       ',''
'Table Parameters:','',''
'','a                   ','1                   '
'','c                   ','3                   '
'','transient_lastDdlTime','!!UNIXTIME!!          '
'','',''
'# Storage Information','',''
'SerDe Library:      ','org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe',''
'InputFormat:        ','org.apache.hadoop.mapred.TextInputFormat',''
'OutputFormat:       ','org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat',''
'Compressed:         ','No                  ',''
'Num Buckets:        ','-1                  ',''
'Bucket Columns:     ','[]                  ',''
'Sort Columns:       ','[]                  ',''
'Storage Desc Params:','',''
'','serialization.format','1                   '
29 rows selected 
>>>  !record