PageRenderTime 39ms CodeModel.GetById 25ms app.highlight 7ms RepoModel.GetById 1ms app.codeStats 0ms

/tags/release-0.2.0-rc0/hive/external/ql/src/test/results/clientpositive/alter_concatenate_indexed_table.q.out

#
text | 243 lines | 239 code | 4 blank | 0 comment | 0 complexity | b8bc2568fcb98598632d2dfddc023c66 MD5 | raw file
  1PREHOOK: query: create table src_rc_concatenate_test(key int, value string) stored as rcfile
  2PREHOOK: type: CREATETABLE
  3POSTHOOK: query: create table src_rc_concatenate_test(key int, value string) stored as rcfile
  4POSTHOOK: type: CREATETABLE
  5POSTHOOK: Output: default@src_rc_concatenate_test
  6PREHOOK: query: load data local inpath '../data/files/smbbucket_1.rc' into table src_rc_concatenate_test
  7PREHOOK: type: LOAD
  8PREHOOK: Output: default@src_rc_concatenate_test
  9POSTHOOK: query: load data local inpath '../data/files/smbbucket_1.rc' into table src_rc_concatenate_test
 10POSTHOOK: type: LOAD
 11POSTHOOK: Output: default@src_rc_concatenate_test
 12PREHOOK: query: load data local inpath '../data/files/smbbucket_2.rc' into table src_rc_concatenate_test
 13PREHOOK: type: LOAD
 14PREHOOK: Output: default@src_rc_concatenate_test
 15POSTHOOK: query: load data local inpath '../data/files/smbbucket_2.rc' into table src_rc_concatenate_test
 16POSTHOOK: type: LOAD
 17POSTHOOK: Output: default@src_rc_concatenate_test
 18PREHOOK: query: load data local inpath '../data/files/smbbucket_3.rc' into table src_rc_concatenate_test
 19PREHOOK: type: LOAD
 20PREHOOK: Output: default@src_rc_concatenate_test
 21POSTHOOK: query: load data local inpath '../data/files/smbbucket_3.rc' into table src_rc_concatenate_test
 22POSTHOOK: type: LOAD
 23POSTHOOK: Output: default@src_rc_concatenate_test
 24PREHOOK: query: show table extended like `src_rc_concatenate_test`
 25PREHOOK: type: SHOW_TABLESTATUS
 26POSTHOOK: query: show table extended like `src_rc_concatenate_test`
 27POSTHOOK: type: SHOW_TABLESTATUS
 28tableName:src_rc_concatenate_test
 29owner:heyongqiang
 30location:pfile:/Users/heyongqiang/Documents/workspace/Hive-3/build/ql/test/data/warehouse/src_rc_concatenate_test
 31inputformat:org.apache.hadoop.hive.ql.io.RCFileInputFormat
 32outputformat:org.apache.hadoop.hive.ql.io.RCFileOutputFormat
 33columns:struct columns { i32 key, string value}
 34partitioned:false
 35partitionColumns:
 36totalNumberFiles:3
 37totalFileSize:636
 38maxFileSize:222
 39minFileSize:206
 40lastAccessTime:0
 41lastUpdateTime:1303856093000
 42
 43PREHOOK: query: select count(1) from src_rc_concatenate_test
 44PREHOOK: type: QUERY
 45PREHOOK: Input: default@src_rc_concatenate_test
 46PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2011-04-26_15-14-54_116_5056538740056177435/-mr-10000
 47POSTHOOK: query: select count(1) from src_rc_concatenate_test
 48POSTHOOK: type: QUERY
 49POSTHOOK: Input: default@src_rc_concatenate_test
 50POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2011-04-26_15-14-54_116_5056538740056177435/-mr-10000
 5115
 52PREHOOK: query: select sum(hash(key)), sum(hash(value)) from src_rc_concatenate_test
 53PREHOOK: type: QUERY
 54PREHOOK: Input: default@src_rc_concatenate_test
 55PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2011-04-26_15-15-01_971_2647514620376325946/-mr-10000
 56POSTHOOK: query: select sum(hash(key)), sum(hash(value)) from src_rc_concatenate_test
 57POSTHOOK: type: QUERY
 58POSTHOOK: Input: default@src_rc_concatenate_test
 59POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2011-04-26_15-15-01_971_2647514620376325946/-mr-10000
 60214	-7678496319
 61PREHOOK: query: create index src_rc_concatenate_test_index on table src_rc_concatenate_test(key) as 'compact' WITH DEFERRED REBUILD IDXPROPERTIES ("prop1"="val1", "prop2"="val2")
 62PREHOOK: type: CREATEINDEX
 63POSTHOOK: query: create index src_rc_concatenate_test_index on table src_rc_concatenate_test(key) as 'compact' WITH DEFERRED REBUILD IDXPROPERTIES ("prop1"="val1", "prop2"="val2")
 64POSTHOOK: type: CREATEINDEX
 65PREHOOK: query: show indexes on src_rc_concatenate_test
 66PREHOOK: type: SHOWINDEXES
 67POSTHOOK: query: show indexes on src_rc_concatenate_test
 68POSTHOOK: type: SHOWINDEXES
 69src_rc_concatenate_test_index	src_rc_concatenate_test	key                 	default__src_rc_concatenate_test_src_rc_concatenate_test_index__	compact             	
 70PREHOOK: query: alter table src_rc_concatenate_test concatenate
 71PREHOOK: type: ALTER_TABLE_MERGE
 72PREHOOK: Input: default@src_rc_concatenate_test
 73PREHOOK: Output: default@src_rc_concatenate_test
 74POSTHOOK: query: alter table src_rc_concatenate_test concatenate
 75POSTHOOK: type: ALTER_TABLE_MERGE
 76POSTHOOK: Input: default@src_rc_concatenate_test
 77POSTHOOK: Output: default@src_rc_concatenate_test
 78PREHOOK: query: show table extended like `src_rc_concatenate_test`
 79PREHOOK: type: SHOW_TABLESTATUS
 80POSTHOOK: query: show table extended like `src_rc_concatenate_test`
 81POSTHOOK: type: SHOW_TABLESTATUS
 82tableName:src_rc_concatenate_test
 83owner:heyongqiang
 84location:pfile:/Users/heyongqiang/Documents/workspace/Hive-3/build/ql/test/data/warehouse/src_rc_concatenate_test
 85inputformat:org.apache.hadoop.hive.ql.io.RCFileInputFormat
 86outputformat:org.apache.hadoop.hive.ql.io.RCFileOutputFormat
 87columns:struct columns { i32 key, string value}
 88partitioned:false
 89partitionColumns:
 90totalNumberFiles:1
 91totalFileSize:334
 92maxFileSize:334
 93minFileSize:334
 94lastAccessTime:0
 95lastUpdateTime:1303856111000
 96
 97PREHOOK: query: select count(1) from src_rc_concatenate_test
 98PREHOOK: type: QUERY
 99PREHOOK: Input: default@src_rc_concatenate_test
100PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2011-04-26_15-15-12_232_1765943327509437357/-mr-10000
101POSTHOOK: query: select count(1) from src_rc_concatenate_test
102POSTHOOK: type: QUERY
103POSTHOOK: Input: default@src_rc_concatenate_test
104POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2011-04-26_15-15-12_232_1765943327509437357/-mr-10000
10515
106PREHOOK: query: select sum(hash(key)), sum(hash(value)) from src_rc_concatenate_test
107PREHOOK: type: QUERY
108PREHOOK: Input: default@src_rc_concatenate_test
109PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2011-04-26_15-15-18_738_6289595467011155110/-mr-10000
110POSTHOOK: query: select sum(hash(key)), sum(hash(value)) from src_rc_concatenate_test
111POSTHOOK: type: QUERY
112POSTHOOK: Input: default@src_rc_concatenate_test
113POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2011-04-26_15-15-18_738_6289595467011155110/-mr-10000
114214	-7678496319
115PREHOOK: query: drop index src_rc_concatenate_test_index on src_rc_concatenate_test
116PREHOOK: type: DROPINDEX
117POSTHOOK: query: drop index src_rc_concatenate_test_index on src_rc_concatenate_test
118POSTHOOK: type: DROPINDEX
119PREHOOK: query: create table src_rc_concatenate_test_part(key int, value string) partitioned by (ds string) stored as rcfile
120PREHOOK: type: CREATETABLE
121POSTHOOK: query: create table src_rc_concatenate_test_part(key int, value string) partitioned by (ds string) stored as rcfile
122POSTHOOK: type: CREATETABLE
123POSTHOOK: Output: default@src_rc_concatenate_test_part
124PREHOOK: query: alter table src_rc_concatenate_test_part add partition (ds='2011')
125PREHOOK: type: ALTERTABLE_ADDPARTS
126PREHOOK: Input: default@src_rc_concatenate_test_part
127POSTHOOK: query: alter table src_rc_concatenate_test_part add partition (ds='2011')
128POSTHOOK: type: ALTERTABLE_ADDPARTS
129POSTHOOK: Input: default@src_rc_concatenate_test_part
130POSTHOOK: Output: default@src_rc_concatenate_test_part@ds=2011
131PREHOOK: query: load data local inpath '../data/files/smbbucket_1.rc' into table src_rc_concatenate_test_part partition (ds='2011')
132PREHOOK: type: LOAD
133PREHOOK: Output: default@src_rc_concatenate_test_part@ds=2011
134POSTHOOK: query: load data local inpath '../data/files/smbbucket_1.rc' into table src_rc_concatenate_test_part partition (ds='2011')
135POSTHOOK: type: LOAD
136POSTHOOK: Output: default@src_rc_concatenate_test_part@ds=2011
137PREHOOK: query: load data local inpath '../data/files/smbbucket_2.rc' into table src_rc_concatenate_test_part partition (ds='2011')
138PREHOOK: type: LOAD
139PREHOOK: Output: default@src_rc_concatenate_test_part@ds=2011
140POSTHOOK: query: load data local inpath '../data/files/smbbucket_2.rc' into table src_rc_concatenate_test_part partition (ds='2011')
141POSTHOOK: type: LOAD
142POSTHOOK: Output: default@src_rc_concatenate_test_part@ds=2011
143PREHOOK: query: load data local inpath '../data/files/smbbucket_3.rc' into table src_rc_concatenate_test_part partition (ds='2011')
144PREHOOK: type: LOAD
145PREHOOK: Output: default@src_rc_concatenate_test_part@ds=2011
146POSTHOOK: query: load data local inpath '../data/files/smbbucket_3.rc' into table src_rc_concatenate_test_part partition (ds='2011')
147POSTHOOK: type: LOAD
148POSTHOOK: Output: default@src_rc_concatenate_test_part@ds=2011
149PREHOOK: query: show table extended like `src_rc_concatenate_test_part` partition (ds='2011')
150PREHOOK: type: SHOW_TABLESTATUS
151POSTHOOK: query: show table extended like `src_rc_concatenate_test_part` partition (ds='2011')
152POSTHOOK: type: SHOW_TABLESTATUS
153tableName:src_rc_concatenate_test_part
154owner:heyongqiang
155location:pfile:/Users/heyongqiang/Documents/workspace/Hive-3/build/ql/test/data/warehouse/src_rc_concatenate_test_part/ds=2011
156inputformat:org.apache.hadoop.hive.ql.io.RCFileInputFormat
157outputformat:org.apache.hadoop.hive.ql.io.RCFileOutputFormat
158columns:struct columns { i32 key, string value}
159partitioned:true
160partitionColumns:struct partition_columns { string ds}
161totalNumberFiles:3
162totalFileSize:636
163maxFileSize:222
164minFileSize:206
165lastAccessTime:0
166lastUpdateTime:1303856128000
167
168PREHOOK: query: select count(1) from src_rc_concatenate_test_part
169PREHOOK: type: QUERY
170PREHOOK: Input: default@src_rc_concatenate_test_part@ds=2011
171PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2011-04-26_15-15-28_709_6508379632697292274/-mr-10000
172POSTHOOK: query: select count(1) from src_rc_concatenate_test_part
173POSTHOOK: type: QUERY
174POSTHOOK: Input: default@src_rc_concatenate_test_part@ds=2011
175POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2011-04-26_15-15-28_709_6508379632697292274/-mr-10000
17615
177PREHOOK: query: select sum(hash(key)), sum(hash(value)) from src_rc_concatenate_test_part
178PREHOOK: type: QUERY
179PREHOOK: Input: default@src_rc_concatenate_test_part@ds=2011
180PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2011-04-26_15-15-35_496_4356530739014843487/-mr-10000
181POSTHOOK: query: select sum(hash(key)), sum(hash(value)) from src_rc_concatenate_test_part
182POSTHOOK: type: QUERY
183POSTHOOK: Input: default@src_rc_concatenate_test_part@ds=2011
184POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2011-04-26_15-15-35_496_4356530739014843487/-mr-10000
185214	-7678496319
186PREHOOK: query: create index src_rc_concatenate_test_part_index on table src_rc_concatenate_test_part(key) as 'compact' WITH DEFERRED REBUILD IDXPROPERTIES ("prop1"="val1", "prop2"="val2")
187PREHOOK: type: CREATEINDEX
188POSTHOOK: query: create index src_rc_concatenate_test_part_index on table src_rc_concatenate_test_part(key) as 'compact' WITH DEFERRED REBUILD IDXPROPERTIES ("prop1"="val1", "prop2"="val2")
189POSTHOOK: type: CREATEINDEX
190PREHOOK: query: show indexes on src_rc_concatenate_test_part
191PREHOOK: type: SHOWINDEXES
192POSTHOOK: query: show indexes on src_rc_concatenate_test_part
193POSTHOOK: type: SHOWINDEXES
194src_rc_concatenate_test_part_index	src_rc_concatenate_test_part	key                 	default__src_rc_concatenate_test_part_src_rc_concatenate_test_part_index__	compact             	
195PREHOOK: query: alter table src_rc_concatenate_test_part partition (ds='2011') concatenate
196PREHOOK: type: ALTER_PARTITION_MERGE
197PREHOOK: Input: default@src_rc_concatenate_test_part
198PREHOOK: Output: default@src_rc_concatenate_test_part@ds=2011
199POSTHOOK: query: alter table src_rc_concatenate_test_part partition (ds='2011') concatenate
200POSTHOOK: type: ALTER_PARTITION_MERGE
201POSTHOOK: Input: default@src_rc_concatenate_test_part
202POSTHOOK: Output: default@src_rc_concatenate_test_part@ds=2011
203PREHOOK: query: show table extended like `src_rc_concatenate_test_part` partition (ds='2011')
204PREHOOK: type: SHOW_TABLESTATUS
205POSTHOOK: query: show table extended like `src_rc_concatenate_test_part` partition (ds='2011')
206POSTHOOK: type: SHOW_TABLESTATUS
207tableName:src_rc_concatenate_test_part
208owner:heyongqiang
209location:pfile:/Users/heyongqiang/Documents/workspace/Hive-3/build/ql/test/data/warehouse/src_rc_concatenate_test_part/ds=2011
210inputformat:org.apache.hadoop.hive.ql.io.RCFileInputFormat
211outputformat:org.apache.hadoop.hive.ql.io.RCFileOutputFormat
212columns:struct columns { i32 key, string value}
213partitioned:true
214partitionColumns:struct partition_columns { string ds}
215totalNumberFiles:1
216totalFileSize:334
217maxFileSize:334
218minFileSize:334
219lastAccessTime:0
220lastUpdateTime:1303856144000
221
222PREHOOK: query: select count(1) from src_rc_concatenate_test_part
223PREHOOK: type: QUERY
224PREHOOK: Input: default@src_rc_concatenate_test_part@ds=2011
225PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2011-04-26_15-15-45_308_2380163877365308340/-mr-10000
226POSTHOOK: query: select count(1) from src_rc_concatenate_test_part
227POSTHOOK: type: QUERY
228POSTHOOK: Input: default@src_rc_concatenate_test_part@ds=2011
229POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2011-04-26_15-15-45_308_2380163877365308340/-mr-10000
23015
231PREHOOK: query: select sum(hash(key)), sum(hash(value)) from src_rc_concatenate_test_part
232PREHOOK: type: QUERY
233PREHOOK: Input: default@src_rc_concatenate_test_part@ds=2011
234PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2011-04-26_15-15-51_822_7148108227690658912/-mr-10000
235POSTHOOK: query: select sum(hash(key)), sum(hash(value)) from src_rc_concatenate_test_part
236POSTHOOK: type: QUERY
237POSTHOOK: Input: default@src_rc_concatenate_test_part@ds=2011
238POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2011-04-26_15-15-51_822_7148108227690658912/-mr-10000
239214	-7678496319
240PREHOOK: query: drop index src_rc_concatenate_test_part_index on src_rc_concatenate_test_part
241PREHOOK: type: DROPINDEX
242POSTHOOK: query: drop index src_rc_concatenate_test_part_index on src_rc_concatenate_test_part
243POSTHOOK: type: DROPINDEX