PREHOOK: query: -- Test SHOW CREATE TABLE on a table with delimiters, stored format, and location.

CREATE TABLE tmp_showcrt1 (key int, value string, newvalue bigint)
ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' COLLECTION ITEMS TERMINATED BY '|' MAP KEYS TERMINATED BY '\045' LINES TERMINATED BY '\n'
STORED AS textfile
#### A masked pattern was here ####
PREHOOK: type: CREATETABLE
#### A masked pattern was here ####
PREHOOK: Output: database:default
PREHOOK: Output: default@tmp_showcrt1
POSTHOOK: query: -- Test SHOW CREATE TABLE on a table with delimiters, stored format, and location.

CREATE TABLE tmp_showcrt1 (key int, value string, newvalue bigint)
ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' COLLECTION ITEMS TERMINATED BY '|' MAP KEYS TERMINATED BY '\045' LINES TERMINATED BY '\n'
STORED AS textfile
#### A masked pattern was here ####
POSTHOOK: type: CREATETABLE
#### A masked pattern was here ####
POSTHOOK: Output: database:default
POSTHOOK: Output: default@tmp_showcrt1
PREHOOK: query: SHOW CREATE TABLE tmp_showcrt1
PREHOOK: type: SHOW_CREATETABLE
PREHOOK: Input: default@tmp_showcrt1
POSTHOOK: query: SHOW CREATE TABLE tmp_showcrt1
POSTHOOK: type: SHOW_CREATETABLE
POSTHOOK: Input: default@tmp_showcrt1
CREATE TABLE `tmp_showcrt1`(
  `key` int, 
  `value` string, 
  `newvalue` bigint)
ROW FORMAT DELIMITED 
  FIELDS TERMINATED BY ',' 
  COLLECTION ITEMS TERMINATED BY '|' 
  MAP KEYS TERMINATED BY '%' 
  LINES TERMINATED BY '\n' 
STORED AS INPUTFORMAT 
  'org.apache.hadoop.mapred.TextInputFormat' 
OUTPUTFORMAT 
  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'
LOCATION
#### A masked pattern was here ####
TBLPROPERTIES (
#### A masked pattern was here ####
PREHOOK: query: DROP TABLE tmp_showcrt1
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@tmp_showcrt1
PREHOOK: Output: default@tmp_showcrt1
POSTHOOK: query: DROP TABLE tmp_showcrt1
POSTHOOK: type: DROPTABLE
POSTHOOK: Input: default@tmp_showcrt1
POSTHOOK: Output: default@tmp_showcrt1