PageRenderTime 23ms CodeModel.GetById 15ms app.highlight 2ms RepoModel.GetById 2ms app.codeStats 0ms

/tags/release-0.2.0-rc0/hive/external/ql/src/test/results/clientnegative/protectmode_part.q.out

#
text | 61 lines | 59 code | 2 blank | 0 comment | 0 complexity | 23c70bfc976c516f389e9045a7162a2a 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_protectmode3
 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_protectmode3
 8POSTHOOK: type: DROPTABLE
 9PREHOOK: query: create table tbl_protectmode3  (col string) partitioned by (p string)
10PREHOOK: type: CREATETABLE
11POSTHOOK: query: create table tbl_protectmode3  (col string) partitioned by (p string)
12POSTHOOK: type: CREATETABLE
13POSTHOOK: Output: default@tbl_protectmode3
14PREHOOK: query: alter table tbl_protectmode3 add partition (p='p1')
15PREHOOK: type: ALTERTABLE_ADDPARTS
16PREHOOK: Input: default@tbl_protectmode3
17POSTHOOK: query: alter table tbl_protectmode3 add partition (p='p1')
18POSTHOOK: type: ALTERTABLE_ADDPARTS
19POSTHOOK: Input: default@tbl_protectmode3
20POSTHOOK: Output: default@tbl_protectmode3@p=p1
21PREHOOK: query: alter table tbl_protectmode3 add partition (p='p2')
22PREHOOK: type: ALTERTABLE_ADDPARTS
23PREHOOK: Input: default@tbl_protectmode3
24POSTHOOK: query: alter table tbl_protectmode3 add partition (p='p2')
25POSTHOOK: type: ALTERTABLE_ADDPARTS
26POSTHOOK: Input: default@tbl_protectmode3
27POSTHOOK: Output: default@tbl_protectmode3@p=p2
28PREHOOK: query: select * from tbl_protectmode3 where p='p1'
29PREHOOK: type: QUERY
30PREHOOK: Input: default@tbl_protectmode3@p=p1
31PREHOOK: Output: file:/tmp/njain/hive_2010-11-16_18-47-37_899_8567164411727057325/-mr-10000
32POSTHOOK: query: select * from tbl_protectmode3 where p='p1'
33POSTHOOK: type: QUERY
34POSTHOOK: Input: default@tbl_protectmode3@p=p1
35POSTHOOK: Output: file:/tmp/njain/hive_2010-11-16_18-47-37_899_8567164411727057325/-mr-10000
36PREHOOK: query: select * from tbl_protectmode3 where p='p2'
37PREHOOK: type: QUERY
38PREHOOK: Input: default@tbl_protectmode3@p=p2
39PREHOOK: Output: file:/tmp/njain/hive_2010-11-16_18-47-38_124_6078196023007251883/-mr-10000
40POSTHOOK: query: select * from tbl_protectmode3 where p='p2'
41POSTHOOK: type: QUERY
42POSTHOOK: Input: default@tbl_protectmode3@p=p2
43POSTHOOK: Output: file:/tmp/njain/hive_2010-11-16_18-47-38_124_6078196023007251883/-mr-10000
44PREHOOK: query: alter table tbl_protectmode3 partition (p='p1') enable offline
45PREHOOK: type: ALTERPARTITION_PROTECTMODE
46PREHOOK: Input: default@tbl_protectmode3
47PREHOOK: Output: default@tbl_protectmode3@p=p1
48POSTHOOK: query: alter table tbl_protectmode3 partition (p='p1') enable offline
49POSTHOOK: type: ALTERPARTITION_PROTECTMODE
50POSTHOOK: Input: default@tbl_protectmode3
51POSTHOOK: Input: default@tbl_protectmode3@p=p1
52POSTHOOK: Output: default@tbl_protectmode3@p=p1
53PREHOOK: query: select * from tbl_protectmode3 where p='p2'
54PREHOOK: type: QUERY
55PREHOOK: Input: default@tbl_protectmode3@p=p2
56PREHOOK: Output: file:/tmp/njain/hive_2010-11-16_18-47-38_569_2255610848316200687/-mr-10000
57POSTHOOK: query: select * from tbl_protectmode3 where p='p2'
58POSTHOOK: type: QUERY
59POSTHOOK: Input: default@tbl_protectmode3@p=p2
60POSTHOOK: Output: file:/tmp/njain/hive_2010-11-16_18-47-38_569_2255610848316200687/-mr-10000
61FAILED: Error in semantic analysis: Query against an offline table or partition Table tbl_protectmode3 Partition p=p1