PageRenderTime 4ms CodeModel.GetById 2ms app.highlight 0ms RepoModel.GetById 1ms app.codeStats 0ms

/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
 1PREHOOK: query: -- protect mode: syntax to change protect mode works and queries are not blocked if a table or partition is not in protect mode
 2
 3drop table tbl_protectmode5
 4PREHOOK: type: DROPTABLE
 5POSTHOOK: query: -- protect mode: syntax to change protect mode works and queries are not blocked if a table or partition is not in protect mode
 6
 7drop table tbl_protectmode5
 8POSTHOOK: type: DROPTABLE
 9PREHOOK: query: create table tbl_protectmode5_1 (col string)
10PREHOOK: type: CREATETABLE
11POSTHOOK: query: create table tbl_protectmode5_1 (col string)
12POSTHOOK: type: CREATETABLE
13POSTHOOK: Output: default@tbl_protectmode5_1
14PREHOOK: query: create table tbl_protectmode5  (col string) partitioned by (p string)
15PREHOOK: type: CREATETABLE
16POSTHOOK: query: create table tbl_protectmode5  (col string) partitioned by (p string)
17POSTHOOK: type: CREATETABLE
18POSTHOOK: Output: default@tbl_protectmode5
19PREHOOK: query: alter table tbl_protectmode5 add partition (p='p1')
20PREHOOK: type: ALTERTABLE_ADDPARTS
21PREHOOK: Input: default@tbl_protectmode5
22POSTHOOK: query: alter table tbl_protectmode5 add partition (p='p1')
23POSTHOOK: type: ALTERTABLE_ADDPARTS
24POSTHOOK: Input: default@tbl_protectmode5
25POSTHOOK: Output: default@tbl_protectmode5@p=p1
26PREHOOK: query: alter table tbl_protectmode5 add partition (p='p2')
27PREHOOK: type: ALTERTABLE_ADDPARTS
28PREHOOK: Input: default@tbl_protectmode5
29POSTHOOK: query: alter table tbl_protectmode5 add partition (p='p2')
30POSTHOOK: type: ALTERTABLE_ADDPARTS
31POSTHOOK: Input: default@tbl_protectmode5
32POSTHOOK: Output: default@tbl_protectmode5@p=p2
33PREHOOK: query: insert overwrite table tbl_protectmode5_1
34select col from tbl_protectmode5 where p='p1'
35PREHOOK: type: QUERY
36PREHOOK: Input: default@tbl_protectmode5@p=p1
37PREHOOK: Output: default@tbl_protectmode5_1
38POSTHOOK: query: insert overwrite table tbl_protectmode5_1
39select col from tbl_protectmode5 where p='p1'
40POSTHOOK: type: QUERY
41POSTHOOK: Input: default@tbl_protectmode5@p=p1
42POSTHOOK: Output: default@tbl_protectmode5_1
43POSTHOOK: Lineage: tbl_protectmode5_1.col SIMPLE [(tbl_protectmode5)tbl_protectmode5.FieldSchema(name:col, type:string, comment:null), ]
44PREHOOK: query: insert overwrite table tbl_protectmode5_1
45select col from tbl_protectmode5 where p='p2'
46PREHOOK: type: QUERY
47PREHOOK: Input: default@tbl_protectmode5@p=p2
48PREHOOK: Output: default@tbl_protectmode5_1
49POSTHOOK: query: insert overwrite table tbl_protectmode5_1
50select col from tbl_protectmode5 where p='p2'
51POSTHOOK: type: QUERY
52POSTHOOK: Input: default@tbl_protectmode5@p=p2
53POSTHOOK: Output: default@tbl_protectmode5_1
54POSTHOOK: Lineage: tbl_protectmode5_1.col SIMPLE [(tbl_protectmode5)tbl_protectmode5.FieldSchema(name:col, type:string, comment:null), ]
55POSTHOOK: Lineage: tbl_protectmode5_1.col SIMPLE [(tbl_protectmode5)tbl_protectmode5.FieldSchema(name:col, type:string, comment:null), ]
56PREHOOK: query: alter table tbl_protectmode5 partition (p='p1') enable offline
57PREHOOK: type: ALTERPARTITION_PROTECTMODE
58PREHOOK: Input: default@tbl_protectmode5
59PREHOOK: Output: default@tbl_protectmode5@p=p1
60POSTHOOK: query: alter table tbl_protectmode5 partition (p='p1') enable offline
61POSTHOOK: type: ALTERPARTITION_PROTECTMODE
62POSTHOOK: Input: default@tbl_protectmode5
63POSTHOOK: Input: default@tbl_protectmode5@p=p1
64POSTHOOK: Output: default@tbl_protectmode5@p=p1
65POSTHOOK: Lineage: tbl_protectmode5_1.col SIMPLE [(tbl_protectmode5)tbl_protectmode5.FieldSchema(name:col, type:string, comment:null), ]
66POSTHOOK: Lineage: tbl_protectmode5_1.col SIMPLE [(tbl_protectmode5)tbl_protectmode5.FieldSchema(name:col, type:string, comment:null), ]
67PREHOOK: query: insert overwrite table tbl_protectmode5_1
68select col from tbl_protectmode5 where p='p2'
69PREHOOK: type: QUERY
70PREHOOK: Input: default@tbl_protectmode5@p=p2
71PREHOOK: Output: default@tbl_protectmode5_1
72POSTHOOK: query: insert overwrite table tbl_protectmode5_1
73select col from tbl_protectmode5 where p='p2'
74POSTHOOK: type: QUERY
75POSTHOOK: Input: default@tbl_protectmode5@p=p2
76POSTHOOK: Output: default@tbl_protectmode5_1
77POSTHOOK: Lineage: tbl_protectmode5_1.col SIMPLE [(tbl_protectmode5)tbl_protectmode5.FieldSchema(name:col, type:string, comment:null), ]
78POSTHOOK: Lineage: tbl_protectmode5_1.col SIMPLE [(tbl_protectmode5)tbl_protectmode5.FieldSchema(name:col, type:string, comment:null), ]
79POSTHOOK: Lineage: tbl_protectmode5_1.col SIMPLE [(tbl_protectmode5)tbl_protectmode5.FieldSchema(name:col, type:string, comment:null), ]
80FAILED: Error in semantic analysis: Query against an offline table or partition Table tbl_protectmode5 Partition p=p1