Saving all output to "!!{outputDirectory}!!/create_escape.q.raw". Enter "record" with no arguments to stop it. >>> !run !!{qFileDirectory}!!/create_escape.q >>> CREATE TABLE table1 (a STRING, b STRING) ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t' ESCAPED BY '\\' STORED AS TEXTFILE; No rows affected >>> >>> DESCRIBE table1; 'col_name','data_type','comment' 'a','string','' 'b','string','' 2 rows selected >>> DESCRIBE EXTENDED table1; 'col_name','data_type','comment' 'a','string','' 'b','string','' '','','' 'Detailed Table Information','Table(tableName:table1, dbName:create_escape, owner:!!{user.name}!!, createTime:!!UNIXTIME!!, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:a, type:string, comment:null), FieldSchema(name:b, type:string, comment:null)], location:!!{hive.metastore.warehouse.dir}!!/create_escape.db/table1, inputFormat:org.apache.hadoop.mapred.TextInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, parameters:{escape.delim=\, serialization.format=',', field.delim=' 4 rows selected >>> >>> INSERT OVERWRITE TABLE table1 SELECT key, '\\\t\\' FROM src WHERE key = 86; 'key','_c1' No rows selected >>> >>> SELECT * FROM table1; 'a','b' '86','\ \' 1 row selected >>> !record