Repository: hive
Updated Branches:
  refs/heads/master 92aaed243 -> ba8de3077


http://git-wip-us.apache.org/repos/asf/hive/blob/ba8de307/ql/src/test/results/clientpositive/beeline/escape_comments.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/beeline/escape_comments.q.out 
b/ql/src/test/results/clientpositive/beeline/escape_comments.q.out
new file mode 100644
index 0000000..0cbc8d6
--- /dev/null
+++ b/ql/src/test/results/clientpositive/beeline/escape_comments.q.out
@@ -0,0 +1,416 @@
+>>>  !run !!{qFileDirectory}!!/escape_comments.q
+>>>  create database escape_comments_db comment 'a\nb';
+Acquired the compile lock.
+Compiling commandqueryId=(!!{queryId}!!): create database escape_comments_db 
comment 'a\nb'
+Semantic Analysis Completed
+Returning Hive schema: Schema(fieldSchemas:null, properties:null)
+Completed compiling commandqueryId=(!!{queryId}!!); Time taken: !!ELIDED!! 
seconds
+Executing commandqueryId=(!!{queryId}!!): create database escape_comments_db 
comment 'a\nb'
+PREHOOK: query: create database escape_comments_db comment 'a\nb'
+PREHOOK: type: CREATEDATABASE
+PREHOOK: Output: database:escape_comments_db
+Starting task [Stage-0:DDL] in serial mode
+POSTHOOK: query: create database escape_comments_db comment 'a\nb'
+POSTHOOK: type: CREATEDATABASE
+POSTHOOK: Output: database:escape_comments_db
+Completed executing commandqueryId=(!!{queryId}!!); Time taken: !!ELIDED!! 
seconds
+OK
+Shutting down query create database escape_comments_db comment 'a\nb'
+No rows affected 
+>>>  use escape_comments_db;
+Acquired the compile lock.
+Compiling commandqueryId=(!!{queryId}!!): use escape_comments_db
+Semantic Analysis Completed
+Returning Hive schema: Schema(fieldSchemas:null, properties:null)
+Completed compiling commandqueryId=(!!{queryId}!!); Time taken: !!ELIDED!! 
seconds
+Executing commandqueryId=(!!{queryId}!!): use escape_comments_db
+PREHOOK: query: use escape_comments_db
+PREHOOK: type: SWITCHDATABASE
+PREHOOK: Input: database:escape_comments_db
+Starting task [Stage-0:DDL] in serial mode
+POSTHOOK: query: use escape_comments_db
+POSTHOOK: type: SWITCHDATABASE
+POSTHOOK: Input: database:escape_comments_db
+Completed executing commandqueryId=(!!{queryId}!!); Time taken: !!ELIDED!! 
seconds
+OK
+Shutting down query use escape_comments_db
+No rows affected 
+>>>  create table escape_comments_tbl1 
+(col1 string comment 'a\nb\'\;') comment 'a\nb' 
+partitioned by (p1 string comment 'a\nb');
+Acquired the compile lock.
+Compiling commandqueryId=(!!{queryId}!!): create table escape_comments_tbl1 
+(col1 string comment 'a\nb\'\;') comment 'a\nb' 
+partitioned by (p1 string comment 'a\nb')
+Semantic Analysis Completed
+Returning Hive schema: Schema(fieldSchemas:null, properties:null)
+Completed compiling commandqueryId=(!!{queryId}!!); Time taken: !!ELIDED!! 
seconds
+Executing commandqueryId=(!!{queryId}!!): create table escape_comments_tbl1 
+(col1 string comment 'a\nb\'\;') comment 'a\nb' 
+partitioned by (p1 string comment 'a\nb')
+PREHOOK: query: create table escape_comments_tbl1 
+(col1 string comment 'a\nb\'\;') comment 'a\nb' 
+partitioned by (p1 string comment 'a\nb')
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:escape_comments_db
+PREHOOK: Output: escape_comments_db@escape_comments_tbl1
+Starting task [Stage-0:DDL] in serial mode
+POSTHOOK: query: create table escape_comments_tbl1 
+(col1 string comment 'a\nb\'\;') comment 'a\nb' 
+partitioned by (p1 string comment 'a\nb')
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:escape_comments_db
+POSTHOOK: Output: escape_comments_db@escape_comments_tbl1
+Completed executing commandqueryId=(!!{queryId}!!); Time taken: !!ELIDED!! 
seconds
+OK
+Shutting down query create table escape_comments_tbl1 
+(col1 string comment 'a\nb\'\;') comment 'a\nb' 
+partitioned by (p1 string comment 'a\nb')
+No rows affected 
+>>>  create view escape_comments_view1 (col1 comment 'a\nb') comment 'a\nb' 
+as select col1 from escape_comments_tbl1;
+Acquired the compile lock.
+Compiling commandqueryId=(!!{queryId}!!): create view escape_comments_view1 
(col1 comment 'a\nb') comment 'a\nb' 
+as select col1 from escape_comments_tbl1
+Semantic Analysis Completed
+Returning Hive schema: Schema(fieldSchemas:[FieldSchema(name:col1, 
type:string, comment:null)], properties:null)
+Completed compiling commandqueryId=(!!{queryId}!!); Time taken: !!ELIDED!! 
seconds
+Executing commandqueryId=(!!{queryId}!!): create view escape_comments_view1 
(col1 comment 'a\nb') comment 'a\nb' 
+as select col1 from escape_comments_tbl1
+PREHOOK: query: create view escape_comments_view1 (col1 comment 'a\nb') 
comment 'a\nb' 
+as select col1 from escape_comments_tbl1
+PREHOOK: type: CREATEVIEW
+PREHOOK: Input: escape_comments_db@escape_comments_tbl1
+PREHOOK: Output: database:escape_comments_db
+PREHOOK: Output: escape_comments_db@escape_comments_view1
+Starting task [Stage-1:DDL] in serial mode
+POSTHOOK: query: create view escape_comments_view1 (col1 comment 'a\nb') 
comment 'a\nb' 
+as select col1 from escape_comments_tbl1
+POSTHOOK: type: CREATEVIEW
+POSTHOOK: Input: escape_comments_db@escape_comments_tbl1
+POSTHOOK: Output: database:escape_comments_db
+POSTHOOK: Output: escape_comments_db@escape_comments_view1
+POSTHOOK: Lineage: escape_comments_view1.col1 SIMPLE 
[(escape_comments_tbl1)escape_comments_tbl1.FieldSchema(name:col1, type:string, 
comment:a
+b';), ]
+Completed executing commandqueryId=(!!{queryId}!!); Time taken: !!ELIDED!! 
seconds
+OK
+Shutting down query create view escape_comments_view1 (col1 comment 'a\nb') 
comment 'a\nb' 
+as select col1 from escape_comments_tbl1
+No rows affected 
+>>>  create index index2 on table escape_comments_tbl1(col1) as 'COMPACT' with 
deferred rebuild comment 'a\nb';
+Acquired the compile lock.
+Compiling commandqueryId=(!!{queryId}!!): create index index2 on table 
escape_comments_tbl1(col1) as 'COMPACT' with deferred rebuild comment 'a\nb'
+Semantic Analysis Completed
+Returning Hive schema: Schema(fieldSchemas:null, properties:null)
+Completed compiling commandqueryId=(!!{queryId}!!); Time taken: !!ELIDED!! 
seconds
+Executing commandqueryId=(!!{queryId}!!): create index index2 on table 
escape_comments_tbl1(col1) as 'COMPACT' with deferred rebuild comment 'a\nb'
+PREHOOK: query: create index index2 on table escape_comments_tbl1(col1) as 
'COMPACT' with deferred rebuild comment 'a\nb'
+PREHOOK: type: CREATEINDEX
+PREHOOK: Input: escape_comments_db@escape_comments_tbl1
+Starting task [Stage-0:DDL] in serial mode
+POSTHOOK: query: create index index2 on table escape_comments_tbl1(col1) as 
'COMPACT' with deferred rebuild comment 'a\nb'
+POSTHOOK: type: CREATEINDEX
+POSTHOOK: Input: escape_comments_db@escape_comments_tbl1
+POSTHOOK: Output: 
escape_comments_db@escape_comments_db__escape_comments_tbl1_index2__
+Completed executing commandqueryId=(!!{queryId}!!); Time taken: !!ELIDED!! 
seconds
+OK
+Shutting down query create index index2 on table escape_comments_tbl1(col1) as 
'COMPACT' with deferred rebuild comment 'a\nb'
+No rows affected 
+>>>  
+>>>  describe database extended escape_comments_db;
+Acquired the compile lock.
+Compiling commandqueryId=(!!{queryId}!!): describe database extended 
escape_comments_db
+Semantic Analysis Completed
+Returning Hive schema: Schema(fieldSchemas:[FieldSchema(name:db_name, 
type:string, comment:from deserializer), FieldSchema(name:comment, type:string, 
comment:from deserializer), FieldSchema(name:location, type:string, 
comment:from deserializer), FieldSchema(name:owner_name, type:string, 
comment:from deserializer), FieldSchema(name:owner_type, type:string, 
comment:from deserializer), FieldSchema(name:parameters, type:string, 
comment:from deserializer)], properties:null)
+Completed compiling commandqueryId=(!!{queryId}!!); Time taken: !!ELIDED!! 
seconds
+Executing commandqueryId=(!!{queryId}!!): describe database extended 
escape_comments_db
+PREHOOK: query: describe database extended escape_comments_db
+PREHOOK: type: DESCDATABASE
+PREHOOK: Input: database:escape_comments_db
+Starting task [Stage-0:DDL] in serial mode
+POSTHOOK: query: describe database extended escape_comments_db
+POSTHOOK: type: DESCDATABASE
+POSTHOOK: Input: database:escape_comments_db
+Completed executing commandqueryId=(!!{queryId}!!); Time taken: !!ELIDED!! 
seconds
+OK
+Shutting down query describe database extended escape_comments_db
+'db_name','comment','location','owner_name','owner_type','parameters'
+'escape_comments_db','a\nb','location/in/test','user','USER',''
+1 row selected 
+>>>  describe database escape_comments_db;
+Acquired the compile lock.
+Compiling commandqueryId=(!!{queryId}!!): describe database escape_comments_db
+Semantic Analysis Completed
+Returning Hive schema: Schema(fieldSchemas:[FieldSchema(name:db_name, 
type:string, comment:from deserializer), FieldSchema(name:comment, type:string, 
comment:from deserializer), FieldSchema(name:location, type:string, 
comment:from deserializer), FieldSchema(name:owner_name, type:string, 
comment:from deserializer), FieldSchema(name:owner_type, type:string, 
comment:from deserializer), FieldSchema(name:parameters, type:string, 
comment:from deserializer)], properties:null)
+Completed compiling commandqueryId=(!!{queryId}!!); Time taken: !!ELIDED!! 
seconds
+Executing commandqueryId=(!!{queryId}!!): describe database escape_comments_db
+PREHOOK: query: describe database escape_comments_db
+PREHOOK: type: DESCDATABASE
+PREHOOK: Input: database:escape_comments_db
+Starting task [Stage-0:DDL] in serial mode
+POSTHOOK: query: describe database escape_comments_db
+POSTHOOK: type: DESCDATABASE
+POSTHOOK: Input: database:escape_comments_db
+Completed executing commandqueryId=(!!{queryId}!!); Time taken: !!ELIDED!! 
seconds
+OK
+Shutting down query describe database escape_comments_db
+'db_name','comment','location','owner_name','owner_type','parameters'
+'escape_comments_db','a\nb','location/in/test','user','USER',''
+1 row selected 
+>>>  show create table escape_comments_tbl1;
+Acquired the compile lock.
+Compiling commandqueryId=(!!{queryId}!!): show create table 
escape_comments_tbl1
+Semantic Analysis Completed
+Returning Hive schema: Schema(fieldSchemas:[FieldSchema(name:createtab_stmt, 
type:string, comment:from deserializer)], properties:null)
+Completed compiling commandqueryId=(!!{queryId}!!); Time taken: !!ELIDED!! 
seconds
+Executing commandqueryId=(!!{queryId}!!): show create table 
escape_comments_tbl1
+PREHOOK: query: show create table escape_comments_tbl1
+PREHOOK: type: SHOW_CREATETABLE
+PREHOOK: Input: escape_comments_db@escape_comments_tbl1
+Starting task [Stage-0:DDL] in serial mode
+POSTHOOK: query: show create table escape_comments_tbl1
+POSTHOOK: type: SHOW_CREATETABLE
+POSTHOOK: Input: escape_comments_db@escape_comments_tbl1
+Completed executing commandqueryId=(!!{queryId}!!); Time taken: !!ELIDED!! 
seconds
+OK
+Shutting down query show create table escape_comments_tbl1
+'createtab_stmt'
+'CREATE TABLE `escape_comments_tbl1`('
+'  `col1` string COMMENT 'a\nb\'\;')'
+'COMMENT 'a\nb''
+'PARTITIONED BY ( '
+'  `p1` string COMMENT 'a\nb')'
+'ROW FORMAT SERDE '
+'  'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe' '
+'STORED AS INPUTFORMAT '
+'  'org.apache.hadoop.mapred.TextInputFormat' '
+'OUTPUTFORMAT '
+'  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat''
+'LOCATION'
+'  
'!!{hive.metastore.warehouse.dir}!!/escape_comments_db.db/escape_comments_tbl1''
+'TBLPROPERTIES ('
+'  'transient_lastDdlTime'='!!UNIXTIME!!')'
+15 rows selected 
+>>>  describe formatted escape_comments_tbl1;
+Acquired the compile lock.
+Compiling commandqueryId=(!!{queryId}!!): describe formatted 
escape_comments_tbl1
+Semantic Analysis Completed
+Returning Hive schema: Schema(fieldSchemas:[FieldSchema(name:col_name, 
type:string, comment:from deserializer), FieldSchema(name:data_type, 
type:string, comment:from deserializer), FieldSchema(name:comment, type:string, 
comment:from deserializer)], properties:null)
+Completed compiling commandqueryId=(!!{queryId}!!); Time taken: !!ELIDED!! 
seconds
+Executing commandqueryId=(!!{queryId}!!): describe formatted 
escape_comments_tbl1
+PREHOOK: query: describe formatted escape_comments_tbl1
+PREHOOK: type: DESCTABLE
+PREHOOK: Input: escape_comments_db@escape_comments_tbl1
+Starting task [Stage-0:DDL] in serial mode
+POSTHOOK: query: describe formatted escape_comments_tbl1
+POSTHOOK: type: DESCTABLE
+POSTHOOK: Input: escape_comments_db@escape_comments_tbl1
+Completed executing commandqueryId=(!!{queryId}!!); Time taken: !!ELIDED!! 
seconds
+OK
+Shutting down query describe formatted escape_comments_tbl1
+'col_name','data_type','comment'
+'# col_name            ','data_type           ','comment             '
+'','NULL','NULL'
+'col1','string','a\nb';'
+'','NULL','NULL'
+'# Partition Information','NULL','NULL'
+'# col_name            ','data_type           ','comment             '
+'','NULL','NULL'
+'p1','string','a\nb'
+'','NULL','NULL'
+'# Detailed Table Information','NULL','NULL'
+'Database:           ','escape_comments_db  ','NULL'
+'Owner:              ','user                ','NULL'
+'CreateTime:         ','!!TIMESTAMP!!','NULL'
+'LastAccessTime:     ','UNKNOWN             ','NULL'
+'Retention:          ','0                   ','NULL'
+'Location:           
','!!{hive.metastore.warehouse.dir}!!/escape_comments_db.db/escape_comments_tbl1','NULL'
+'Table Type:         ','MANAGED_TABLE       ','NULL'
+'Table Parameters:','NULL','NULL'
+'','comment             ','a\nb                '
+'','transient_lastDdlTime','!!UNIXTIME!!          '
+'','NULL','NULL'
+'# Storage Information','NULL','NULL'
+'SerDe Library:      
','org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe','NULL'
+'InputFormat:        ','org.apache.hadoop.mapred.TextInputFormat','NULL'
+'OutputFormat:       
','org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat','NULL'
+'Compressed:         ','No                  ','NULL'
+'Num Buckets:        ','-1                  ','NULL'
+'Bucket Columns:     ','[]                  ','NULL'
+'Sort Columns:       ','[]                  ','NULL'
+'Storage Desc Params:','NULL','NULL'
+'','serialization.format','1                   '
+31 rows selected 
+>>>  describe pretty escape_comments_tbl1;
+Acquired the compile lock.
+Compiling commandqueryId=(!!{queryId}!!): describe pretty escape_comments_tbl1
+Semantic Analysis Completed
+Returning Hive schema: Schema(fieldSchemas:[FieldSchema(name:col_name, 
type:string, comment:from deserializer), FieldSchema(name:data_type, 
type:string, comment:from deserializer), FieldSchema(name:comment, type:string, 
comment:from deserializer)], properties:null)
+Completed compiling commandqueryId=(!!{queryId}!!); Time taken: !!ELIDED!! 
seconds
+Executing commandqueryId=(!!{queryId}!!): describe pretty escape_comments_tbl1
+PREHOOK: query: describe pretty escape_comments_tbl1
+PREHOOK: type: DESCTABLE
+PREHOOK: Input: escape_comments_db@escape_comments_tbl1
+Starting task [Stage-0:DDL] in serial mode
+POSTHOOK: query: describe pretty escape_comments_tbl1
+POSTHOOK: type: DESCTABLE
+POSTHOOK: Input: escape_comments_db@escape_comments_tbl1
+Completed executing commandqueryId=(!!{queryId}!!); Time taken: !!ELIDED!! 
seconds
+OK
+Shutting down query describe pretty escape_comments_tbl1
+'col_name','data_type','comment'
+'col_name ','data_type     ','comment'
+'','',''
+'col1     ','string        ','a'
+'         ','              ','b';'
+'p1       ','string        ','a'
+'         ','              ','b'
+'','NULL','NULL'
+'# Partition Information','NULL','NULL'
+'col_name ','data_type     ','comment'
+'','',''
+'p1       ','string        ','a'
+'         ','              ','b'
+12 rows selected 
+>>>  describe escape_comments_tbl1;
+Acquired the compile lock.
+Compiling commandqueryId=(!!{queryId}!!): describe escape_comments_tbl1
+Semantic Analysis Completed
+Returning Hive schema: Schema(fieldSchemas:[FieldSchema(name:col_name, 
type:string, comment:from deserializer), FieldSchema(name:data_type, 
type:string, comment:from deserializer), FieldSchema(name:comment, type:string, 
comment:from deserializer)], properties:null)
+Completed compiling commandqueryId=(!!{queryId}!!); Time taken: !!ELIDED!! 
seconds
+Executing commandqueryId=(!!{queryId}!!): describe escape_comments_tbl1
+PREHOOK: query: describe escape_comments_tbl1
+PREHOOK: type: DESCTABLE
+PREHOOK: Input: escape_comments_db@escape_comments_tbl1
+Starting task [Stage-0:DDL] in serial mode
+POSTHOOK: query: describe escape_comments_tbl1
+POSTHOOK: type: DESCTABLE
+POSTHOOK: Input: escape_comments_db@escape_comments_tbl1
+Completed executing commandqueryId=(!!{queryId}!!); Time taken: !!ELIDED!! 
seconds
+OK
+Shutting down query describe escape_comments_tbl1
+'col_name','data_type','comment'
+'col1','string','a\nb';'
+'p1','string','a\nb'
+'','NULL','NULL'
+'# Partition Information','NULL','NULL'
+'# col_name            ','data_type           ','comment             '
+'','NULL','NULL'
+'p1','string','a\nb'
+7 rows selected 
+>>>  show create table escape_comments_view1;
+Acquired the compile lock.
+Compiling commandqueryId=(!!{queryId}!!): show create table 
escape_comments_view1
+Semantic Analysis Completed
+Returning Hive schema: Schema(fieldSchemas:[FieldSchema(name:createtab_stmt, 
type:string, comment:from deserializer)], properties:null)
+Completed compiling commandqueryId=(!!{queryId}!!); Time taken: !!ELIDED!! 
seconds
+Executing commandqueryId=(!!{queryId}!!): show create table 
escape_comments_view1
+PREHOOK: query: show create table escape_comments_view1
+PREHOOK: type: SHOW_CREATETABLE
+PREHOOK: Input: escape_comments_db@escape_comments_view1
+Starting task [Stage-0:DDL] in serial mode
+POSTHOOK: query: show create table escape_comments_view1
+POSTHOOK: type: SHOW_CREATETABLE
+POSTHOOK: Input: escape_comments_db@escape_comments_view1
+Completed executing commandqueryId=(!!{queryId}!!); Time taken: !!ELIDED!! 
seconds
+OK
+Shutting down query show create table escape_comments_view1
+'createtab_stmt'
+'CREATE VIEW `escape_comments_view1` AS SELECT `col1` AS `col1` FROM (select 
`escape_comments_tbl1`.`col1` from `escape_comments_db`.`escape_comments_tbl1`) 
`escape_comments_db.escape_comments_view1`'
+1 row selected 
+>>>  describe formatted escape_comments_view1;
+Acquired the compile lock.
+Compiling commandqueryId=(!!{queryId}!!): describe formatted 
escape_comments_view1
+Semantic Analysis Completed
+Returning Hive schema: Schema(fieldSchemas:[FieldSchema(name:col_name, 
type:string, comment:from deserializer), FieldSchema(name:data_type, 
type:string, comment:from deserializer), FieldSchema(name:comment, type:string, 
comment:from deserializer)], properties:null)
+Completed compiling commandqueryId=(!!{queryId}!!); Time taken: !!ELIDED!! 
seconds
+Executing commandqueryId=(!!{queryId}!!): describe formatted 
escape_comments_view1
+PREHOOK: query: describe formatted escape_comments_view1
+PREHOOK: type: DESCTABLE
+PREHOOK: Input: escape_comments_db@escape_comments_view1
+Starting task [Stage-0:DDL] in serial mode
+POSTHOOK: query: describe formatted escape_comments_view1
+POSTHOOK: type: DESCTABLE
+POSTHOOK: Input: escape_comments_db@escape_comments_view1
+Completed executing commandqueryId=(!!{queryId}!!); Time taken: !!ELIDED!! 
seconds
+OK
+Shutting down query describe formatted escape_comments_view1
+'col_name','data_type','comment'
+'# col_name            ','data_type           ','comment             '
+'','NULL','NULL'
+'col1','string','a\nb'
+'','NULL','NULL'
+'# Detailed Table Information','NULL','NULL'
+'Database:           ','escape_comments_db  ','NULL'
+'Owner:              ','user                ','NULL'
+'CreateTime:         ','!!TIMESTAMP!!','NULL'
+'LastAccessTime:     ','UNKNOWN             ','NULL'
+'Retention:          ','0                   ','NULL'
+'Table Type:         ','VIRTUAL_VIEW        ','NULL'
+'Table Parameters:','NULL','NULL'
+'','comment             ','a\nb                '
+'','transient_lastDdlTime','!!UNIXTIME!!          '
+'','NULL','NULL'
+'# Storage Information','NULL','NULL'
+'SerDe Library:      ','null                ','NULL'
+'InputFormat:        ','org.apache.hadoop.mapred.TextInputFormat','NULL'
+'OutputFormat:       
','org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat','NULL'
+'Compressed:         ','No                  ','NULL'
+'Num Buckets:        ','-1                  ','NULL'
+'Bucket Columns:     ','[]                  ','NULL'
+'Sort Columns:       ','[]                  ','NULL'
+'','NULL','NULL'
+'# View Information','NULL','NULL'
+'View Original Text: ','select col1 from escape_comments_tbl1','NULL'
+'View Expanded Text: ','SELECT `col1` AS `col1` FROM (select 
`escape_comments_tbl1`.`col1` from `escape_comments_db`.`escape_comments_tbl1`) 
`escape_comments_db.escape_comments_view1`','NULL'
+'View Rewrite Enabled:','No                  ','NULL'
+28 rows selected 
+>>>  show formatted index on escape_comments_tbl1;
+Acquired the compile lock.
+Compiling commandqueryId=(!!{queryId}!!): show formatted index on 
escape_comments_tbl1
+Semantic Analysis Completed
+Returning Hive schema: Schema(fieldSchemas:[FieldSchema(name:idx_name, 
type:string, comment:from deserializer), FieldSchema(name:tab_name, 
type:string, comment:from deserializer), FieldSchema(name:col_names, 
type:string, comment:from deserializer), FieldSchema(name:idx_tab_name, 
type:string, comment:from deserializer), FieldSchema(name:idx_type, 
type:string, comment:from deserializer), FieldSchema(name:comment, type:string, 
comment:from deserializer)], properties:null)
+Completed compiling commandqueryId=(!!{queryId}!!); Time taken: !!ELIDED!! 
seconds
+Executing commandqueryId=(!!{queryId}!!): show formatted index on 
escape_comments_tbl1
+PREHOOK: query: show formatted index on escape_comments_tbl1
+PREHOOK: type: SHOWINDEXES
+Starting task [Stage-0:DDL] in serial mode
+POSTHOOK: query: show formatted index on escape_comments_tbl1
+POSTHOOK: type: SHOWINDEXES
+Completed executing commandqueryId=(!!{queryId}!!); Time taken: !!ELIDED!! 
seconds
+OK
+Shutting down query show formatted index on escape_comments_tbl1
+'idx_name','tab_name','col_names','idx_tab_name','idx_type','comment'
+'idx_name            ','tab_name            ','col_names           
','idx_tab_name        ','idx_type            ','comment             '
+'','NULL','NULL','NULL','NULL','NULL'
+'','NULL','NULL','NULL','NULL','NULL'
+'index2              ','escape_comments_tbl1','col1                
','escape_comments_db__escape_comments_tbl1_index2__','compact             
','a\nb                '
+4 rows selected 
+>>>  
+>>>  drop database escape_comments_db cascade;
+Acquired the compile lock.
+Compiling commandqueryId=(!!{queryId}!!): drop database escape_comments_db 
cascade
+Semantic Analysis Completed
+Returning Hive schema: Schema(fieldSchemas:null, properties:null)
+Completed compiling commandqueryId=(!!{queryId}!!); Time taken: !!ELIDED!! 
seconds
+Executing commandqueryId=(!!{queryId}!!): drop database escape_comments_db 
cascade
+PREHOOK: query: drop database escape_comments_db cascade
+PREHOOK: type: DROPDATABASE
+PREHOOK: Input: database:escape_comments_db
+PREHOOK: Output: database:escape_comments_db
+PREHOOK: Output: 
escape_comments_db@escape_comments_db__escape_comments_tbl1_index2__
+PREHOOK: Output: escape_comments_db@escape_comments_tbl1
+PREHOOK: Output: escape_comments_db@escape_comments_view1
+Starting task [Stage-0:DDL] in serial mode
+POSTHOOK: query: drop database escape_comments_db cascade
+POSTHOOK: type: DROPDATABASE
+POSTHOOK: Input: database:escape_comments_db
+POSTHOOK: Output: database:escape_comments_db
+POSTHOOK: Output: 
escape_comments_db@escape_comments_db__escape_comments_tbl1_index2__
+POSTHOOK: Output: escape_comments_db@escape_comments_tbl1
+POSTHOOK: Output: escape_comments_db@escape_comments_view1
+Completed executing commandqueryId=(!!{queryId}!!); Time taken: !!ELIDED!! 
seconds
+OK
+Shutting down query drop database escape_comments_db cascade
+No rows affected 
+>>>  !record

Reply via email to