/tags/release-0.2.0-rc0/hive/external/ql/src/test/results/clientnegative/protectmode_part1.q.out
text | 80 lines | 78 code | 2 blank | 0 comment | 0 complexity | 2e5d42294a5cd8ff2df1984a24d6ce1d MD5 | raw file
Possible License(s): Apache-2.0, BSD-3-Clause, JSON, CPL-1.0
- PREHOOK: query: -- protect mode: syntax to change protect mode works and queries are not blocked if a table or partition is not in protect mode
- drop table tbl_protectmode5
- PREHOOK: type: DROPTABLE
- POSTHOOK: query: -- protect mode: syntax to change protect mode works and queries are not blocked if a table or partition is not in protect mode
- drop table tbl_protectmode5
- POSTHOOK: type: DROPTABLE
- PREHOOK: query: create table tbl_protectmode5_1 (col string)
- PREHOOK: type: CREATETABLE
- POSTHOOK: query: create table tbl_protectmode5_1 (col string)
- POSTHOOK: type: CREATETABLE
- POSTHOOK: Output: default@tbl_protectmode5_1
- PREHOOK: query: create table tbl_protectmode5 (col string) partitioned by (p string)
- PREHOOK: type: CREATETABLE
- POSTHOOK: query: create table tbl_protectmode5 (col string) partitioned by (p string)
- POSTHOOK: type: CREATETABLE
- POSTHOOK: Output: default@tbl_protectmode5
- PREHOOK: query: alter table tbl_protectmode5 add partition (p='p1')
- PREHOOK: type: ALTERTABLE_ADDPARTS
- PREHOOK: Input: default@tbl_protectmode5
- POSTHOOK: query: alter table tbl_protectmode5 add partition (p='p1')
- POSTHOOK: type: ALTERTABLE_ADDPARTS
- POSTHOOK: Input: default@tbl_protectmode5
- POSTHOOK: Output: default@tbl_protectmode5@p=p1
- PREHOOK: query: alter table tbl_protectmode5 add partition (p='p2')
- PREHOOK: type: ALTERTABLE_ADDPARTS
- PREHOOK: Input: default@tbl_protectmode5
- POSTHOOK: query: alter table tbl_protectmode5 add partition (p='p2')
- POSTHOOK: type: ALTERTABLE_ADDPARTS
- POSTHOOK: Input: default@tbl_protectmode5
- POSTHOOK: Output: default@tbl_protectmode5@p=p2
- PREHOOK: query: insert overwrite table tbl_protectmode5_1
- select col from tbl_protectmode5 where p='p1'
- PREHOOK: type: QUERY
- PREHOOK: Input: default@tbl_protectmode5@p=p1
- PREHOOK: Output: default@tbl_protectmode5_1
- POSTHOOK: query: insert overwrite table tbl_protectmode5_1
- select col from tbl_protectmode5 where p='p1'
- POSTHOOK: type: QUERY
- POSTHOOK: Input: default@tbl_protectmode5@p=p1
- POSTHOOK: Output: default@tbl_protectmode5_1
- POSTHOOK: Lineage: tbl_protectmode5_1.col SIMPLE [(tbl_protectmode5)tbl_protectmode5.FieldSchema(name:col, type:string, comment:null), ]
- PREHOOK: query: insert overwrite table tbl_protectmode5_1
- select col from tbl_protectmode5 where p='p2'
- PREHOOK: type: QUERY
- PREHOOK: Input: default@tbl_protectmode5@p=p2
- PREHOOK: Output: default@tbl_protectmode5_1
- POSTHOOK: query: insert overwrite table tbl_protectmode5_1
- select col from tbl_protectmode5 where p='p2'
- POSTHOOK: type: QUERY
- POSTHOOK: Input: default@tbl_protectmode5@p=p2
- POSTHOOK: Output: default@tbl_protectmode5_1
- POSTHOOK: Lineage: tbl_protectmode5_1.col SIMPLE [(tbl_protectmode5)tbl_protectmode5.FieldSchema(name:col, type:string, comment:null), ]
- POSTHOOK: Lineage: tbl_protectmode5_1.col SIMPLE [(tbl_protectmode5)tbl_protectmode5.FieldSchema(name:col, type:string, comment:null), ]
- PREHOOK: query: alter table tbl_protectmode5 partition (p='p1') enable offline
- PREHOOK: type: ALTERPARTITION_PROTECTMODE
- PREHOOK: Input: default@tbl_protectmode5
- PREHOOK: Output: default@tbl_protectmode5@p=p1
- POSTHOOK: query: alter table tbl_protectmode5 partition (p='p1') enable offline
- POSTHOOK: type: ALTERPARTITION_PROTECTMODE
- POSTHOOK: Input: default@tbl_protectmode5
- POSTHOOK: Input: default@tbl_protectmode5@p=p1
- POSTHOOK: Output: default@tbl_protectmode5@p=p1
- POSTHOOK: Lineage: tbl_protectmode5_1.col SIMPLE [(tbl_protectmode5)tbl_protectmode5.FieldSchema(name:col, type:string, comment:null), ]
- POSTHOOK: Lineage: tbl_protectmode5_1.col SIMPLE [(tbl_protectmode5)tbl_protectmode5.FieldSchema(name:col, type:string, comment:null), ]
- PREHOOK: query: insert overwrite table tbl_protectmode5_1
- select col from tbl_protectmode5 where p='p2'
- PREHOOK: type: QUERY
- PREHOOK: Input: default@tbl_protectmode5@p=p2
- PREHOOK: Output: default@tbl_protectmode5_1
- POSTHOOK: query: insert overwrite table tbl_protectmode5_1
- select col from tbl_protectmode5 where p='p2'
- POSTHOOK: type: QUERY
- POSTHOOK: Input: default@tbl_protectmode5@p=p2
- POSTHOOK: Output: default@tbl_protectmode5_1
- POSTHOOK: Lineage: tbl_protectmode5_1.col SIMPLE [(tbl_protectmode5)tbl_protectmode5.FieldSchema(name:col, type:string, comment:null), ]
- POSTHOOK: Lineage: tbl_protectmode5_1.col SIMPLE [(tbl_protectmode5)tbl_protectmode5.FieldSchema(name:col, type:string, comment:null), ]
- POSTHOOK: Lineage: tbl_protectmode5_1.col SIMPLE [(tbl_protectmode5)tbl_protectmode5.FieldSchema(name:col, type:string, comment:null), ]
- FAILED: Error in semantic analysis: Query against an offline table or partition Table tbl_protectmode5 Partition p=p1