PageRenderTime 56ms CodeModel.GetById 18ms app.highlight 19ms RepoModel.GetById 2ms app.codeStats 1ms

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

#
text | 1643 lines | 1562 code | 81 blank | 0 comment | 0 complexity | f35ce9ad83432f4a617d4dbeff4c25bb MD5 | raw file

Large files files are truncated, but you can click here to view the full file

  1PREHOOK: query: DROP VIEW view1
  2PREHOOK: type: DROPVIEW
  3POSTHOOK: query: DROP VIEW view1
  4POSTHOOK: type: DROPVIEW
  5PREHOOK: query: DROP VIEW view2
  6PREHOOK: type: DROPVIEW
  7POSTHOOK: query: DROP VIEW view2
  8POSTHOOK: type: DROPVIEW
  9PREHOOK: query: DROP VIEW view3
 10PREHOOK: type: DROPVIEW
 11POSTHOOK: query: DROP VIEW view3
 12POSTHOOK: type: DROPVIEW
 13PREHOOK: query: DROP VIEW view4
 14PREHOOK: type: DROPVIEW
 15POSTHOOK: query: DROP VIEW view4
 16POSTHOOK: type: DROPVIEW
 17PREHOOK: query: DROP VIEW view5
 18PREHOOK: type: DROPVIEW
 19POSTHOOK: query: DROP VIEW view5
 20POSTHOOK: type: DROPVIEW
 21PREHOOK: query: DROP VIEW view6
 22PREHOOK: type: DROPVIEW
 23POSTHOOK: query: DROP VIEW view6
 24POSTHOOK: type: DROPVIEW
 25PREHOOK: query: DROP VIEW view7
 26PREHOOK: type: DROPVIEW
 27POSTHOOK: query: DROP VIEW view7
 28POSTHOOK: type: DROPVIEW
 29PREHOOK: query: DROP VIEW view8
 30PREHOOK: type: DROPVIEW
 31POSTHOOK: query: DROP VIEW view8
 32POSTHOOK: type: DROPVIEW
 33PREHOOK: query: DROP VIEW view9
 34PREHOOK: type: DROPVIEW
 35POSTHOOK: query: DROP VIEW view9
 36POSTHOOK: type: DROPVIEW
 37PREHOOK: query: DROP VIEW view10
 38PREHOOK: type: DROPVIEW
 39POSTHOOK: query: DROP VIEW view10
 40POSTHOOK: type: DROPVIEW
 41PREHOOK: query: DROP VIEW view11
 42PREHOOK: type: DROPVIEW
 43POSTHOOK: query: DROP VIEW view11
 44POSTHOOK: type: DROPVIEW
 45PREHOOK: query: DROP VIEW view12
 46PREHOOK: type: DROPVIEW
 47POSTHOOK: query: DROP VIEW view12
 48POSTHOOK: type: DROPVIEW
 49PREHOOK: query: DROP VIEW view13
 50PREHOOK: type: DROPVIEW
 51POSTHOOK: query: DROP VIEW view13
 52POSTHOOK: type: DROPVIEW
 53PREHOOK: query: DROP VIEW view14
 54PREHOOK: type: DROPVIEW
 55POSTHOOK: query: DROP VIEW view14
 56POSTHOOK: type: DROPVIEW
 57PREHOOK: query: DROP VIEW view15
 58PREHOOK: type: DROPVIEW
 59POSTHOOK: query: DROP VIEW view15
 60POSTHOOK: type: DROPVIEW
 61PREHOOK: query: DROP VIEW view16
 62PREHOOK: type: DROPVIEW
 63POSTHOOK: query: DROP VIEW view16
 64POSTHOOK: type: DROPVIEW
 65PREHOOK: query: DROP TEMPORARY FUNCTION test_translate
 66PREHOOK: type: DROPFUNCTION
 67POSTHOOK: query: DROP TEMPORARY FUNCTION test_translate
 68POSTHOOK: type: DROPFUNCTION
 69PREHOOK: query: DROP TEMPORARY FUNCTION test_max
 70PREHOOK: type: DROPFUNCTION
 71POSTHOOK: query: DROP TEMPORARY FUNCTION test_max
 72POSTHOOK: type: DROPFUNCTION
 73PREHOOK: query: DROP TEMPORARY FUNCTION test_explode
 74PREHOOK: type: DROPFUNCTION
 75POSTHOOK: query: DROP TEMPORARY FUNCTION test_explode
 76POSTHOOK: type: DROPFUNCTION
 77PREHOOK: query: SELECT * FROM src WHERE key=86
 78PREHOOK: type: QUERY
 79PREHOOK: Input: default@src
 80PREHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-04-26_16-16-12_021_1106810087376156794/-mr-10000
 81POSTHOOK: query: SELECT * FROM src WHERE key=86
 82POSTHOOK: type: QUERY
 83POSTHOOK: Input: default@src
 84POSTHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-04-26_16-16-12_021_1106810087376156794/-mr-10000
 8586	val_86
 86PREHOOK: query: CREATE VIEW view1 AS SELECT value FROM src WHERE key=86
 87PREHOOK: type: CREATEVIEW
 88PREHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-04-26_16-16-17_953_4875542405127030243/-mr-10000
 89POSTHOOK: query: CREATE VIEW view1 AS SELECT value FROM src WHERE key=86
 90POSTHOOK: type: CREATEVIEW
 91POSTHOOK: Output: default@view1
 92POSTHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-04-26_16-16-17_953_4875542405127030243/-mr-10000
 93PREHOOK: query: CREATE VIEW view2 AS SELECT * FROM src
 94PREHOOK: type: CREATEVIEW
 95PREHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-04-26_16-16-18_014_8438067548180434124/-mr-10000
 96POSTHOOK: query: CREATE VIEW view2 AS SELECT * FROM src
 97POSTHOOK: type: CREATEVIEW
 98POSTHOOK: Output: default@view2
 99POSTHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-04-26_16-16-18_014_8438067548180434124/-mr-10000
100PREHOOK: query: CREATE VIEW view3(valoo) 
101TBLPROPERTIES ("fear" = "factor")
102AS SELECT upper(value) FROM src WHERE key=86
103PREHOOK: type: CREATEVIEW
104PREHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-04-26_16-16-18_089_3958349172656455541/-mr-10000
105POSTHOOK: query: CREATE VIEW view3(valoo) 
106TBLPROPERTIES ("fear" = "factor")
107AS SELECT upper(value) FROM src WHERE key=86
108POSTHOOK: type: CREATEVIEW
109POSTHOOK: Output: default@view3
110POSTHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-04-26_16-16-18_089_3958349172656455541/-mr-10000
111PREHOOK: query: SELECT * from view1
112PREHOOK: type: QUERY
113PREHOOK: Input: default@src
114PREHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-04-26_16-16-18_142_1698516806922399028/-mr-10000
115POSTHOOK: query: SELECT * from view1
116POSTHOOK: type: QUERY
117POSTHOOK: Input: default@src
118POSTHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-04-26_16-16-18_142_1698516806922399028/-mr-10000
119val_86
120PREHOOK: query: SELECT * from view2 where key=18
121PREHOOK: type: QUERY
122PREHOOK: Input: default@src
123PREHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-04-26_16-16-23_360_248483194889563851/-mr-10000
124POSTHOOK: query: SELECT * from view2 where key=18
125POSTHOOK: type: QUERY
126POSTHOOK: Input: default@src
127POSTHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-04-26_16-16-23_360_248483194889563851/-mr-10000
12818	val_18
12918	val_18
130PREHOOK: query: SELECT * from view3
131PREHOOK: type: QUERY
132PREHOOK: Input: default@src
133PREHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-04-26_16-16-28_891_6412017417282399882/-mr-10000
134POSTHOOK: query: SELECT * from view3
135POSTHOOK: type: QUERY
136POSTHOOK: Input: default@src
137POSTHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-04-26_16-16-28_891_6412017417282399882/-mr-10000
138VAL_86
139PREHOOK: query: -- test EXPLAIN output for CREATE VIEW
140EXPLAIN
141CREATE VIEW view0(valoo) AS SELECT upper(value) FROM src WHERE key=86
142PREHOOK: type: CREATEVIEW
143POSTHOOK: query: -- test EXPLAIN output for CREATE VIEW
144EXPLAIN
145CREATE VIEW view0(valoo) AS SELECT upper(value) FROM src WHERE key=86
146POSTHOOK: type: CREATEVIEW
147ABSTRACT SYNTAX TREE:
148  (TOK_CREATEVIEW (TOK_TABNAME view0) (TOK_TABCOLNAME (TOK_TABCOL valoo TOK_NULL)) (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION upper (TOK_TABLE_OR_COL value)))) (TOK_WHERE (= (TOK_TABLE_OR_COL key) 86)))))
149
150STAGE DEPENDENCIES:
151  Stage-0 is a root stage
152
153STAGE PLANS:
154  Stage: Stage-0
155      Create View Operator:
156        Create View
157          if not exists: false
158          columns: valoo string
159          expanded text: SELECT `_c0` AS `valoo` FROM (SELECT upper(`src`.`value`) FROM `src` WHERE `src`.`key`=86) `view0`
160          name: view0
161          original text: SELECT upper(value) FROM src WHERE key=86
162
163
164PREHOOK: query: -- make sure EXPLAIN works with a query which references a view
165EXPLAIN
166SELECT * from view2 where key=18
167PREHOOK: type: QUERY
168POSTHOOK: query: -- make sure EXPLAIN works with a query which references a view
169EXPLAIN
170SELECT * from view2 where key=18
171POSTHOOK: type: QUERY
172ABSTRACT SYNTAX TREE:
173  (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME view2))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR TOK_ALLCOLREF)) (TOK_WHERE (= (TOK_TABLE_OR_COL key) 18))))
174
175STAGE DEPENDENCIES:
176  Stage-1 is a root stage
177  Stage-0 is a root stage
178
179STAGE PLANS:
180  Stage: Stage-1
181    Map Reduce
182      Alias -> Map Operator Tree:
183        view2:src 
184          TableScan
185            alias: src
186            Filter Operator
187              predicate:
188                  expr: (key = 18)
189                  type: boolean
190              Select Operator
191                expressions:
192                      expr: key
193                      type: string
194                      expr: value
195                      type: string
196                outputColumnNames: _col0, _col1
197                Select Operator
198                  expressions:
199                        expr: _col0
200                        type: string
201                        expr: _col1
202                        type: string
203                  outputColumnNames: _col0, _col1
204                  File Output Operator
205                    compressed: false
206                    GlobalTableId: 0
207                    table:
208                        input format: org.apache.hadoop.mapred.TextInputFormat
209                        output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
210
211  Stage: Stage-0
212    Fetch Operator
213      limit: -1
214
215
216PREHOOK: query: SHOW TABLES 'view.*'
217PREHOOK: type: SHOWTABLES
218POSTHOOK: query: SHOW TABLES 'view.*'
219POSTHOOK: type: SHOWTABLES
220view1
221view2
222view3
223PREHOOK: query: DESCRIBE view1
224PREHOOK: type: DESCTABLE
225POSTHOOK: query: DESCRIBE view1
226POSTHOOK: type: DESCTABLE
227value	string	
228PREHOOK: query: DESCRIBE EXTENDED view1
229PREHOOK: type: DESCTABLE
230POSTHOOK: query: DESCRIBE EXTENDED view1
231POSTHOOK: type: DESCTABLE
232value	string	
233	 	 
234Detailed Table Information	Table(tableName:view1, dbName:default, owner:jsichi, createTime:1303859777, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:value, type:string, comment:null)], location:null, inputFormat:org.apache.hadoop.mapred.SequenceFileInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:null, parameters:{}), bucketCols:[], sortCols:[], parameters:{}), partitionKeys:[], parameters:{transient_lastDdlTime=1303859777}, viewOriginalText:SELECT value FROM src WHERE key=86, viewExpandedText:SELECT `src`.`value` FROM `src` WHERE `src`.`key`=86, tableType:VIRTUAL_VIEW)	
235PREHOOK: query: DESCRIBE FORMATTED view1
236PREHOOK: type: DESCTABLE
237POSTHOOK: query: DESCRIBE FORMATTED view1
238POSTHOOK: type: DESCTABLE
239# col_name            	data_type           	comment             
240	 	 
241value               	string              	None                
242	 	 
243# Detailed Table Information	 	 
244Database:           	default             	 
245Owner:              	jsichi              	 
246CreateTime:         	Tue Apr 26 16:16:17 PDT 2011	 
247LastAccessTime:     	UNKNOWN             	 
248Protect Mode:       	None                	 
249Retention:          	0                   	 
250Table Type:         	VIRTUAL_VIEW        	 
251Table Parameters:	 	 
252	transient_lastDdlTime	1303859777          
253	 	 
254# Storage Information	 	 
255SerDe Library:      	null                	 
256InputFormat:        	org.apache.hadoop.mapred.SequenceFileInputFormat	 
257OutputFormat:       	org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat	 
258Compressed:         	No                  	 
259Num Buckets:        	-1                  	 
260Bucket Columns:     	[]                  	 
261Sort Columns:       	[]                  	 
262	 	 
263# View Information	 	 
264View Original Text: 	SELECT value FROM src WHERE key=86	 
265View Expanded Text: 	SELECT `src`.`value` FROM `src` WHERE `src`.`key`=86	 
266PREHOOK: query: DESCRIBE view2
267PREHOOK: type: DESCTABLE
268POSTHOOK: query: DESCRIBE view2
269POSTHOOK: type: DESCTABLE
270key	string	
271value	string	
272PREHOOK: query: DESCRIBE EXTENDED view2
273PREHOOK: type: DESCTABLE
274POSTHOOK: query: DESCRIBE EXTENDED view2
275POSTHOOK: type: DESCTABLE
276key	string	
277value	string	
278	 	 
279Detailed Table Information	Table(tableName:view2, dbName:default, owner:jsichi, createTime:1303859778, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:string, comment:null), FieldSchema(name:value, type:string, comment:null)], location:null, inputFormat:org.apache.hadoop.mapred.SequenceFileInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:null, parameters:{}), bucketCols:[], sortCols:[], parameters:{}), partitionKeys:[], parameters:{transient_lastDdlTime=1303859778}, viewOriginalText:SELECT * FROM src, viewExpandedText:SELECT `src`.`key`, `src`.`value` FROM `src`, tableType:VIRTUAL_VIEW)	
280PREHOOK: query: DESCRIBE FORMATTED view2
281PREHOOK: type: DESCTABLE
282POSTHOOK: query: DESCRIBE FORMATTED view2
283POSTHOOK: type: DESCTABLE
284# col_name            	data_type           	comment             
285	 	 
286key                 	string              	None                
287value               	string              	None                
288	 	 
289# Detailed Table Information	 	 
290Database:           	default             	 
291Owner:              	jsichi              	 
292CreateTime:         	Tue Apr 26 16:16:18 PDT 2011	 
293LastAccessTime:     	UNKNOWN             	 
294Protect Mode:       	None                	 
295Retention:          	0                   	 
296Table Type:         	VIRTUAL_VIEW        	 
297Table Parameters:	 	 
298	transient_lastDdlTime	1303859778          
299	 	 
300# Storage Information	 	 
301SerDe Library:      	null                	 
302InputFormat:        	org.apache.hadoop.mapred.SequenceFileInputFormat	 
303OutputFormat:       	org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat	 
304Compressed:         	No                  	 
305Num Buckets:        	-1                  	 
306Bucket Columns:     	[]                  	 
307Sort Columns:       	[]                  	 
308	 	 
309# View Information	 	 
310View Original Text: 	SELECT * FROM src   	 
311View Expanded Text: 	SELECT `src`.`key`, `src`.`value` FROM `src`	 
312PREHOOK: query: DESCRIBE view3
313PREHOOK: type: DESCTABLE
314POSTHOOK: query: DESCRIBE view3
315POSTHOOK: type: DESCTABLE
316valoo	string	
317PREHOOK: query: DESCRIBE EXTENDED view3
318PREHOOK: type: DESCTABLE
319POSTHOOK: query: DESCRIBE EXTENDED view3
320POSTHOOK: type: DESCTABLE
321valoo	string	
322	 	 
323Detailed Table Information	Table(tableName:view3, dbName:default, owner:jsichi, createTime:1303859778, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:valoo, type:string, comment:null)], location:null, inputFormat:org.apache.hadoop.mapred.SequenceFileInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:null, parameters:{}), bucketCols:[], sortCols:[], parameters:{}), partitionKeys:[], parameters:{transient_lastDdlTime=1303859778, fear=factor}, viewOriginalText:SELECT upper(value) FROM src WHERE key=86, viewExpandedText:SELECT `_c0` AS `valoo` FROM (SELECT upper(`src`.`value`) FROM `src` WHERE `src`.`key`=86) `view3`, tableType:VIRTUAL_VIEW)	
324PREHOOK: query: DESCRIBE FORMATTED view3
325PREHOOK: type: DESCTABLE
326POSTHOOK: query: DESCRIBE FORMATTED view3
327POSTHOOK: type: DESCTABLE
328# col_name            	data_type           	comment             
329	 	 
330valoo               	string              	None                
331	 	 
332# Detailed Table Information	 	 
333Database:           	default             	 
334Owner:              	jsichi              	 
335CreateTime:         	Tue Apr 26 16:16:18 PDT 2011	 
336LastAccessTime:     	UNKNOWN             	 
337Protect Mode:       	None                	 
338Retention:          	0                   	 
339Table Type:         	VIRTUAL_VIEW        	 
340Table Parameters:	 	 
341	fear                	factor              
342	transient_lastDdlTime	1303859778          
343	 	 
344# Storage Information	 	 
345SerDe Library:      	null                	 
346InputFormat:        	org.apache.hadoop.mapred.SequenceFileInputFormat	 
347OutputFormat:       	org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat	 
348Compressed:         	No                  	 
349Num Buckets:        	-1                  	 
350Bucket Columns:     	[]                  	 
351Sort Columns:       	[]                  	 
352	 	 
353# View Information	 	 
354View Original Text: 	SELECT upper(value) FROM src WHERE key=86	 
355View Expanded Text: 	SELECT `_c0` AS `valoo` FROM (SELECT upper(`src`.`value`) FROM `src` WHERE `src`.`key`=86) `view3`	 
356PREHOOK: query: ALTER VIEW view3 SET TBLPROPERTIES ("biggest" = "loser")
357PREHOOK: type: ALTERVIEW_PROPERTIES
358PREHOOK: Input: default@view3
359PREHOOK: Output: default@view3
360POSTHOOK: query: ALTER VIEW view3 SET TBLPROPERTIES ("biggest" = "loser")
361POSTHOOK: type: ALTERVIEW_PROPERTIES
362POSTHOOK: Input: default@view3
363POSTHOOK: Output: default@view3
364PREHOOK: query: DESCRIBE EXTENDED view3
365PREHOOK: type: DESCTABLE
366POSTHOOK: query: DESCRIBE EXTENDED view3
367POSTHOOK: type: DESCTABLE
368valoo	string	
369	 	 
370Detailed Table Information	Table(tableName:view3, dbName:default, owner:jsichi, createTime:1303859778, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:valoo, type:string, comment:null)], location:null, inputFormat:org.apache.hadoop.mapred.SequenceFileInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:null, parameters:{}), bucketCols:[], sortCols:[], parameters:{}), partitionKeys:[], parameters:{last_modified_by=jsichi, last_modified_time=1303859796, biggest=loser, transient_lastDdlTime=1303859796, fear=factor}, viewOriginalText:SELECT upper(value) FROM src WHERE key=86, viewExpandedText:SELECT `_c0` AS `valoo` FROM (SELECT upper(`src`.`value`) FROM `src` WHERE `src`.`key`=86) `view3`, tableType:VIRTUAL_VIEW)	
371PREHOOK: query: DESCRIBE FORMATTED view3
372PREHOOK: type: DESCTABLE
373POSTHOOK: query: DESCRIBE FORMATTED view3
374POSTHOOK: type: DESCTABLE
375# col_name            	data_type           	comment             
376	 	 
377valoo               	string              	None                
378	 	 
379# Detailed Table Information	 	 
380Database:           	default             	 
381Owner:              	jsichi              	 
382CreateTime:         	Tue Apr 26 16:16:18 PDT 2011	 
383LastAccessTime:     	UNKNOWN             	 
384Protect Mode:       	None                	 
385Retention:          	0                   	 
386Table Type:         	VIRTUAL_VIEW        	 
387Table Parameters:	 	 
388	biggest             	loser               
389	fear                	factor              
390	last_modified_by    	jsichi              
391	last_modified_time  	1303859796          
392	transient_lastDdlTime	1303859796          
393	 	 
394# Storage Information	 	 
395SerDe Library:      	null                	 
396InputFormat:        	org.apache.hadoop.mapred.SequenceFileInputFormat	 
397OutputFormat:       	org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat	 
398Compressed:         	No                  	 
399Num Buckets:        	-1                  	 
400Bucket Columns:     	[]                  	 
401Sort Columns:       	[]                  	 
402	 	 
403# View Information	 	 
404View Original Text: 	SELECT upper(value) FROM src WHERE key=86	 
405View Expanded Text: 	SELECT `_c0` AS `valoo` FROM (SELECT upper(`src`.`value`) FROM `src` WHERE `src`.`key`=86) `view3`	 
406PREHOOK: query: CREATE TABLE table1 (key int)
407PREHOOK: type: CREATETABLE
408POSTHOOK: query: CREATE TABLE table1 (key int)
409POSTHOOK: type: CREATETABLE
410POSTHOOK: Output: default@table1
411PREHOOK: query: -- use DESCRIBE EXTENDED on a base table and an external table as points
412-- of comparison for view descriptions
413DESCRIBE EXTENDED table1
414PREHOOK: type: DESCTABLE
415POSTHOOK: query: -- use DESCRIBE EXTENDED on a base table and an external table as points
416-- of comparison for view descriptions
417DESCRIBE EXTENDED table1
418POSTHOOK: type: DESCTABLE
419key	int	
420	 	 
421Detailed Table Information	Table(tableName:table1, dbName:default, owner:jsichi, createTime:1303859796, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:int, comment:null)], location:pfile:/Users/jsichi/open/hive-trunk/build/ql/test/data/warehouse/table1, inputFormat:org.apache.hadoop.mapred.TextInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, parameters:{serialization.format=1}), bucketCols:[], sortCols:[], parameters:{}), partitionKeys:[], parameters:{transient_lastDdlTime=1303859796}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)	
422PREHOOK: query: DESCRIBE EXTENDED src1
423PREHOOK: type: DESCTABLE
424POSTHOOK: query: DESCRIBE EXTENDED src1
425POSTHOOK: type: DESCTABLE
426key	string	default
427value	string	default
428	 	 
429Detailed Table Information	Table(tableName:src1, dbName:default, owner:null, createTime:1303859768, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:string, comment:default), FieldSchema(name:value, type:string, comment:default)], location:pfile:/Users/jsichi/open/hive-trunk/build/ql/test/data/warehouse/src1, inputFormat:org.apache.hadoop.mapred.TextInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, parameters:{serialization.format=1}), bucketCols:[], sortCols:[], parameters:{}), partitionKeys:[], parameters:{transient_lastDdlTime=1303859769}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)	
430PREHOOK: query: -- use DESCRIBE EXTENDED on a base table as a point of comparison for
431-- view descriptions
432DESCRIBE EXTENDED table1
433PREHOOK: type: DESCTABLE
434POSTHOOK: query: -- use DESCRIBE EXTENDED on a base table as a point of comparison for
435-- view descriptions
436DESCRIBE EXTENDED table1
437POSTHOOK: type: DESCTABLE
438key	int	
439	 	 
440Detailed Table Information	Table(tableName:table1, dbName:default, owner:jsichi, createTime:1303859796, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:int, comment:null)], location:pfile:/Users/jsichi/open/hive-trunk/build/ql/test/data/warehouse/table1, inputFormat:org.apache.hadoop.mapred.TextInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, parameters:{serialization.format=1}), bucketCols:[], sortCols:[], parameters:{}), partitionKeys:[], parameters:{transient_lastDdlTime=1303859796}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)	
441PREHOOK: query: INSERT OVERWRITE TABLE table1 SELECT key FROM src WHERE key = 86
442PREHOOK: type: QUERY
443PREHOOK: Input: default@src
444PREHOOK: Output: default@table1
445POSTHOOK: query: INSERT OVERWRITE TABLE table1 SELECT key FROM src WHERE key = 86
446POSTHOOK: type: QUERY
447POSTHOOK: Input: default@src
448POSTHOOK: Output: default@table1
449POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
450PREHOOK: query: SELECT * FROM table1
451PREHOOK: type: QUERY
452PREHOOK: Input: default@table1
453PREHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-04-26_16-16-45_947_2085561936927801936/-mr-10000
454POSTHOOK: query: SELECT * FROM table1
455POSTHOOK: type: QUERY
456POSTHOOK: Input: default@table1
457POSTHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-04-26_16-16-45_947_2085561936927801936/-mr-10000
458POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
45986
460PREHOOK: query: CREATE VIEW view4 AS SELECT * FROM table1
461PREHOOK: type: CREATEVIEW
462PREHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-04-26_16-16-46_138_7447815181838056815/-mr-10000
463POSTHOOK: query: CREATE VIEW view4 AS SELECT * FROM table1
464POSTHOOK: type: CREATEVIEW
465POSTHOOK: Output: default@view4
466POSTHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-04-26_16-16-46_138_7447815181838056815/-mr-10000
467POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
468PREHOOK: query: SELECT * FROM view4
469PREHOOK: type: QUERY
470PREHOOK: Input: default@table1
471PREHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-04-26_16-16-46_196_5105547280114080249/-mr-10000
472POSTHOOK: query: SELECT * FROM view4
473POSTHOOK: type: QUERY
474POSTHOOK: Input: default@table1
475POSTHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-04-26_16-16-46_196_5105547280114080249/-mr-10000
476POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
47786
478PREHOOK: query: DESCRIBE view4
479PREHOOK: type: DESCTABLE
480POSTHOOK: query: DESCRIBE view4
481POSTHOOK: type: DESCTABLE
482POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
483key	int	
484PREHOOK: query: ALTER TABLE table1 ADD COLUMNS (value STRING)
485PREHOOK: type: ALTERTABLE_ADDCOLS
486PREHOOK: Input: default@table1
487PREHOOK: Output: default@table1
488POSTHOOK: query: ALTER TABLE table1 ADD COLUMNS (value STRING)
489POSTHOOK: type: ALTERTABLE_ADDCOLS
490POSTHOOK: Input: default@table1
491POSTHOOK: Output: default@table1
492POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
493PREHOOK: query: SELECT * FROM table1
494PREHOOK: type: QUERY
495PREHOOK: Input: default@table1
496PREHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-04-26_16-16-51_573_8021843774469758715/-mr-10000
497POSTHOOK: query: SELECT * FROM table1
498POSTHOOK: type: QUERY
499POSTHOOK: Input: default@table1
500POSTHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-04-26_16-16-51_573_8021843774469758715/-mr-10000
501POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
50286	NULL
503PREHOOK: query: SELECT * FROM view4
504PREHOOK: type: QUERY
505PREHOOK: Input: default@table1
506PREHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-04-26_16-16-51_751_5422952837986050518/-mr-10000
507POSTHOOK: query: SELECT * FROM view4
508POSTHOOK: type: QUERY
509POSTHOOK: Input: default@table1
510POSTHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-04-26_16-16-51_751_5422952837986050518/-mr-10000
511POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
51286
513PREHOOK: query: DESCRIBE table1
514PREHOOK: type: DESCTABLE
515POSTHOOK: query: DESCRIBE table1
516POSTHOOK: type: DESCTABLE
517POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
518key	int	
519value	string	
520PREHOOK: query: DESCRIBE view4
521PREHOOK: type: DESCTABLE
522POSTHOOK: query: DESCRIBE view4
523POSTHOOK: type: DESCTABLE
524POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
525key	int	
526PREHOOK: query: CREATE VIEW view5 AS SELECT v1.key as key1, v2.key as key2
527FROM view4 v1 join view4 v2
528PREHOOK: type: CREATEVIEW
529PREHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-04-26_16-16-57_155_7569906550037001887/-mr-10000
530POSTHOOK: query: CREATE VIEW view5 AS SELECT v1.key as key1, v2.key as key2
531FROM view4 v1 join view4 v2
532POSTHOOK: type: CREATEVIEW
533POSTHOOK: Output: default@view5
534POSTHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-04-26_16-16-57_155_7569906550037001887/-mr-10000
535POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
536PREHOOK: query: SELECT * FROM view5
537PREHOOK: type: QUERY
538PREHOOK: Input: default@table1
539PREHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-04-26_16-16-57_237_2199423335065636496/-mr-10000
540POSTHOOK: query: SELECT * FROM view5
541POSTHOOK: type: QUERY
542POSTHOOK: Input: default@table1
543POSTHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-04-26_16-16-57_237_2199423335065636496/-mr-10000
544POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
54586	86
546PREHOOK: query: DESCRIBE view5
547PREHOOK: type: DESCTABLE
548POSTHOOK: query: DESCRIBE view5
549POSTHOOK: type: DESCTABLE
550POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
551key1	int	
552key2	int	
553PREHOOK: query: -- verify that column name and comment in DDL portion
554-- overrides column alias in SELECT
555CREATE VIEW view6(valoo COMMENT 'I cannot spell') AS
556SELECT upper(value) as blarg FROM src WHERE key=86
557PREHOOK: type: CREATEVIEW
558PREHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-04-26_16-17-03_839_7899860047026359445/-mr-10000
559POSTHOOK: query: -- verify that column name and comment in DDL portion
560-- overrides column alias in SELECT
561CREATE VIEW view6(valoo COMMENT 'I cannot spell') AS
562SELECT upper(value) as blarg FROM src WHERE key=86
563POSTHOOK: type: CREATEVIEW
564POSTHOOK: Output: default@view6
565POSTHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-04-26_16-17-03_839_7899860047026359445/-mr-10000
566POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
567PREHOOK: query: DESCRIBE view6
568PREHOOK: type: DESCTABLE
569POSTHOOK: query: DESCRIBE view6
570POSTHOOK: type: DESCTABLE
571POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
572valoo	string	I cannot spell
573PREHOOK: query: -- verify that ORDER BY and LIMIT are both supported in view def
574CREATE VIEW view7 AS
575SELECT * FROM src
576WHERE key > 80 AND key < 100
577ORDER BY key, value
578LIMIT 10
579PREHOOK: type: CREATEVIEW
580PREHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-04-26_16-17-03_964_2634118939893651146/-mr-10000
581POSTHOOK: query: -- verify that ORDER BY and LIMIT are both supported in view def
582CREATE VIEW view7 AS
583SELECT * FROM src
584WHERE key > 80 AND key < 100
585ORDER BY key, value
586LIMIT 10
587POSTHOOK: type: CREATEVIEW
588POSTHOOK: Output: default@view7
589POSTHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-04-26_16-17-03_964_2634118939893651146/-mr-10000
590POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
591PREHOOK: query: SELECT * FROM view7
592PREHOOK: type: QUERY
593PREHOOK: Input: default@src
594PREHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-04-26_16-17-04_060_9004942114636875404/-mr-10000
595POSTHOOK: query: SELECT * FROM view7
596POSTHOOK: type: QUERY
597POSTHOOK: Input: default@src
598POSTHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-04-26_16-17-04_060_9004942114636875404/-mr-10000
599POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
60082	val_82
60183	val_83
60283	val_83
60384	val_84
60484	val_84
60585	val_85
60686	val_86
60787	val_87
60890	val_90
60990	val_90
610PREHOOK: query: -- top-level ORDER BY should override the one inside the view
611-- (however, the inside ORDER BY should still influence the evaluation
612-- of the limit)
613SELECT * FROM view7 ORDER BY key DESC, value
614PREHOOK: type: QUERY
615PREHOOK: Input: default@src
616PREHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-04-26_16-17-10_678_5006662899774141111/-mr-10000
617POSTHOOK: query: -- top-level ORDER BY should override the one inside the view
618-- (however, the inside ORDER BY should still influence the evaluation
619-- of the limit)
620SELECT * FROM view7 ORDER BY key DESC, value
621POSTHOOK: type: QUERY
622POSTHOOK: Input: default@src
623POSTHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-04-26_16-17-10_678_5006662899774141111/-mr-10000
624POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
62590	val_90
62690	val_90
62787	val_87
62886	val_86
62985	val_85
63084	val_84
63184	val_84
63283	val_83
63383	val_83
63482	val_82
635PREHOOK: query: -- top-level LIMIT should override if lower
636SELECT * FROM view7 LIMIT 5
637PREHOOK: type: QUERY
638PREHOOK: Input: default@src
639PREHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-04-26_16-17-25_276_742038559388418902/-mr-10000
640POSTHOOK: query: -- top-level LIMIT should override if lower
641SELECT * FROM view7 LIMIT 5
642POSTHOOK: type: QUERY
643POSTHOOK: Input: default@src
644POSTHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-04-26_16-17-25_276_742038559388418902/-mr-10000
645POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
64682	val_82
64783	val_83
64883	val_83
64984	val_84
65084	val_84
651PREHOOK: query: -- but not if higher
652SELECT * FROM view7 LIMIT 20
653PREHOOK: type: QUERY
654PREHOOK: Input: default@src
655PREHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-04-26_16-17-32_922_7537536843995339809/-mr-10000
656POSTHOOK: query: -- but not if higher
657SELECT * FROM view7 LIMIT 20
658POSTHOOK: type: QUERY
659POSTHOOK: Input: default@src
660POSTHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-04-26_16-17-32_922_7537536843995339809/-mr-10000
661POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
66282	val_82
66383	val_83
66483	val_83
66584	val_84
66684	val_84
66785	val_85
66886	val_86
66987	val_87
67090	val_90
67190	val_90
672PREHOOK: query: -- test usage of a function within a view
673CREATE TEMPORARY FUNCTION test_translate AS
674'org.apache.hadoop.hive.ql.udf.generic.GenericUDFTestTranslate'
675PREHOOK: type: CREATEFUNCTION
676POSTHOOK: query: -- test usage of a function within a view
677CREATE TEMPORARY FUNCTION test_translate AS
678'org.apache.hadoop.hive.ql.udf.generic.GenericUDFTestTranslate'
679POSTHOOK: type: CREATEFUNCTION
680POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
681PREHOOK: query: CREATE VIEW view8(c) AS
682SELECT test_translate('abc', 'a', 'b')
683FROM table1
684PREHOOK: type: CREATEVIEW
685PREHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-04-26_16-17-39_332_7325117518490785843/-mr-10000
686POSTHOOK: query: CREATE VIEW view8(c) AS
687SELECT test_translate('abc', 'a', 'b')
688FROM table1
689POSTHOOK: type: CREATEVIEW
690POSTHOOK: Output: default@view8
691POSTHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-04-26_16-17-39_332_7325117518490785843/-mr-10000
692POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
693PREHOOK: query: DESCRIBE EXTENDED view8
694PREHOOK: type: DESCTABLE
695POSTHOOK: query: DESCRIBE EXTENDED view8
696POSTHOOK: type: DESCTABLE
697POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
698c	string	
699	 	 
700Detailed Table Information	Table(tableName:view8, dbName:default, owner:jsichi, createTime:1303859859, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:c, type:string, comment:null)], location:null, inputFormat:org.apache.hadoop.mapred.SequenceFileInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:null, parameters:{}), bucketCols:[], sortCols:[], parameters:{}), partitionKeys:[], parameters:{transient_lastDdlTime=1303859859}, viewOriginalText:SELECT test_translate('abc', 'a', 'b')	 
701FROM table1, viewExpandedText:SELECT `_c0` AS `c` FROM (SELECT `test_translate`('abc', 'a', 'b')	 	 
702FROM `table1`) `view8`, tableType:VIRTUAL_VIEW)		 
703PREHOOK: query: DESCRIBE FORMATTED view8
704PREHOOK: type: DESCTABLE
705POSTHOOK: query: DESCRIBE FORMATTED view8
706POSTHOOK: type: DESCTABLE
707POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
708# col_name            	data_type           	comment             
709	 	 
710c                   	string              	None                
711	 	 
712# Detailed Table Information	 	 
713Database:           	default             	 
714Owner:              	jsichi              	 
715CreateTime:         	Tue Apr 26 16:17:39 PDT 2011	 
716LastAccessTime:     	UNKNOWN             	 
717Protect Mode:       	None                	 
718Retention:          	0                   	 
719Table Type:         	VIRTUAL_VIEW        	 
720Table Parameters:	 	 
721	transient_lastDdlTime	1303859859          
722	 	 
723# Storage Information	 	 
724SerDe Library:      	null                	 
725InputFormat:        	org.apache.hadoop.mapred.SequenceFileInputFormat	 
726OutputFormat:       	org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat	 
727Compressed:         	No                  	 
728Num Buckets:        	-1                  	 
729Bucket Columns:     	[]                  	 
730Sort Columns:       	[]                  	 
731	 	 
732# View Information	 	 
733View Original Text: 	SELECT test_translate('abc', 'a', 'b')	 
734FROM table1	 	 
735View Expanded Text: 	SELECT `_c0` AS `c` FROM (SELECT `test_translate`('abc', 'a', 'b')	 
736FROM `table1`) `view8`	 	 
737PREHOOK: query: SELECT * FROM view8
738PREHOOK: type: QUERY
739PREHOOK: Input: default@table1
740PREHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-04-26_16-17-39_534_6753322851996532137/-mr-10000
741POSTHOOK: query: SELECT * FROM view8
742POSTHOOK: type: QUERY
743POSTHOOK: Input: default@table1
744POSTHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-04-26_16-17-39_534_6753322851996532137/-mr-10000
745POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
746bbc
747PREHOOK: query: -- test usage of a UDAF within a view
748CREATE TEMPORARY FUNCTION test_max AS
749'org.apache.hadoop.hive.ql.udf.UDAFTestMax'
750PREHOOK: type: CREATEFUNCTION
751POSTHOOK: query: -- test usage of a UDAF within a view
752CREATE TEMPORARY FUNCTION test_max AS
753'org.apache.hadoop.hive.ql.udf.UDAFTestMax'
754POSTHOOK: type: CREATEFUNCTION
755POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
756PREHOOK: query: CREATE VIEW view9(m) AS
757SELECT test_max(length(value))
758FROM src
759PREHOOK: type: CREATEVIEW
760PREHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-04-26_16-17-45_689_3977124058975857089/-mr-10000
761POSTHOOK: query: CREATE VIEW view9(m) AS
762SELECT test_max(length(value))
763FROM src
764POSTHOOK: type: CREATEVIEW
765POSTHOOK: Output: default@view9
766POSTHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-04-26_16-17-45_689_3977124058975857089/-mr-10000
767POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
768PREHOOK: query: DESCRIBE EXTENDED view9
769PREHOOK: type: DESCTABLE
770POSTHOOK: query: DESCRIBE EXTENDED view9
771POSTHOOK: type: DESCTABLE
772POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
773m	int	
774	 	 
775Detailed Table Information	Table(tableName:view9, dbName:default, owner:jsichi, createTime:1303859865, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:m, type:int, comment:null)], location:null, inputFormat:org.apache.hadoop.mapred.SequenceFileInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:null, parameters:{}), bucketCols:[], sortCols:[], parameters:{}), partitionKeys:[], parameters:{transient_lastDdlTime=1303859865}, viewOriginalText:SELECT test_max(length(value))	 
776FROM src, viewExpandedText:SELECT `_c0` AS `m` FROM (SELECT `test_max`(length(`src`.`value`))	 	 
777FROM `src`) `view9`, tableType:VIRTUAL_VIEW)		 
778PREHOOK: query: DESCRIBE FORMATTED view9
779PREHOOK: type: DESCTABLE
780POSTHOOK: query: DESCRIBE FORMATTED view9
781POSTHOOK: type: DESCTABLE
782POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
783# col_name            	data_type           	comment             
784	 	 
785m                   	int                 	None                
786	 	 
787# Detailed Table Information	 	 
788Database:           	default             	 
789Owner:              	jsichi              	 
790CreateTime:         	Tue Apr 26 16:17:45 PDT 2011	 
791LastAccessTime:     	UNKNOWN             	 
792Protect Mode:       	None                	 
793Retention:          	0                   	 
794Table Type:         	VIRTUAL_VIEW        	 
795Table Parameters:	 	 
796	transient_lastDdlTime	1303859865          
797	 	 
798# Storage Information	 	 
799SerDe Library:      	null                	 
800InputFormat:        	org.apache.hadoop.mapred.SequenceFileInputFormat	 
801OutputFormat:       	org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat	 
802Compressed:         	No                  	 
803Num Buckets:        	-1                  	 
804Bucket Columns:     	[]                  	 
805Sort Columns:       	[]                  	 
806	 	 
807# View Information	 	 
808View Original Text: 	SELECT test_max(length(value))	 
809FROM src	 	 
810View Expanded Text: 	SELECT `_c0` AS `m` FROM (SELECT `test_max`(length(`src`.`value`))	 
811FROM `src`) `view9`	 	 
812PREHOOK: query: SELECT * FROM view9
813PREHOOK: type: QUERY
814PREHOOK: Input: default@src
815PREHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-04-26_16-17-46_023_7400703264002927310/-mr-10000
816POSTHOOK: query: SELECT * FROM view9
817POSTHOOK: type: QUERY
818POSTHOOK: Input: default@src
819POSTHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-04-26_16-17-46_023_7400703264002927310/-mr-10000
820POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
8217
822PREHOOK: query: -- test usage of a subselect within a view
823CREATE VIEW view10 AS
824SELECT slurp.* FROM (SELECT * FROM src WHERE key=86) slurp
825PREHOOK: type: CREATEVIEW
826PREHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-04-26_16-17-53_993_5675089404876855300/-mr-10000
827POSTHOOK: query: -- test usage of a subselect within a view
828CREATE VIEW view10 AS
829SELECT slurp.* FROM (SELECT * FROM src WHERE key=86) slurp
830POSTHOOK: type: CREATEVIEW
831POSTHOOK: Output: default@view10
832POSTHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-04-26_16-17-53_993_5675089404876855300/-mr-10000
833POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
834PREHOOK: query: DESCRIBE EXTENDED view10
835PREHOOK: type: DESCTABLE
836POSTHOOK: query: DESCRIBE EXTENDED view10
837POSTHOOK: type: DESCTABLE
838POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
839key	string	
840value	string	
841	 	 
842Detailed Table Information	Table(tableName:view10, dbName:default, owner:jsichi, createTime:1303859874, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:string, comment:null), FieldSchema(name:value, type:string, comment:null)], location:null, inputFormat:org.apache.hadoop.mapred.SequenceFileInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:null, parameters:{}), bucketCols:[], sortCols:[], parameters:{}), partitionKeys:[], parameters:{transient_lastDdlTime=1303859874}, viewOriginalText:SELECT slurp.* FROM (SELECT * FROM src WHERE key=86) slurp, viewExpandedText:SELECT `slurp`.`key`, `slurp`.`value` FROM (SELECT `src`.`key`, `src`.`value` FROM `src` WHERE `src`.`key`=86) `slurp`, tableType:VIRTUAL_VIEW)	
843PREHOOK: query: DESCRIBE FORMATTED view10
844PREHOOK: type: DESCTABLE
845POSTHOOK: query: DESCRIBE FORMATTED view10
846POSTHOOK: type: DESCTABLE
847POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
848# col_name            	data_type           	comment             
849	 	 
850key                 	string              	None                
851value               	string              	None                
852	 	 
853# Detailed Table Information	 	 
854Database:           	default             	 
855Owner:              	jsichi              	 
856CreateTime:         	Tue Apr 26 16:17:54 PDT 2011	 
857LastAccessTime:     	UNKNOWN             	 
858Protect Mode:       	None                	 
859Retention:          	0                   	 
860Table Type:         	VIRTUAL_VIEW        	 
861Table Parameters:	 	 
862	transient_lastDdlTime	1303859874          
863	 	 
864# Storage Information	 	 
865SerDe Library:      	null                	 
866InputFormat:        	org.apache.hadoop.mapred.SequenceFileInputFormat	 
867OutputFormat:       	org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat	 
868Compressed:         	No                  	 
869Num Buckets:        	-1                  	 
870Bucket Columns:     	[]                  	 
871Sort Columns:       	[]                  	 
872	 	 
873# View Information	 	 
874View Original Text: 	SELECT slurp.* FROM (SELECT * FROM src WHERE key=86) slurp	 
875View Expanded Text: 	SELECT `slurp`.`key`, `slurp`.`value` FROM (SELECT `src`.`key`, `src`.`value` FROM `src` WHERE `src`.`key`=86) `slurp`	 
876PREHOOK: query: SELECT * FROM view10
877PREHOOK: type: QUERY
878PREHOOK: Input: default@src
879PREHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-04-26_16-17-54_194_1974090628625957857/-mr-10000
880POSTHOOK: query: SELECT * FROM view10
881POSTHOOK: type: QUERY
882POSTHOOK: Input: default@src
883POSTHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-04-26_16-17-54_194_1974090628625957857/-mr-10000
884POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
88586	val_86
886PREHOOK: query: -- test usage of a UDTF within a view
887CREATE TEMPORARY FUNCTION test_explode AS
888'org.apache.hadoop.hive.ql.udf.generic.GenericUDTFExplode'
889PREHOOK: type: CREATEFUNCTION
890POSTHOOK: query: -- test usage of a UDTF within a view
891CREATE TEMPORARY FUNCTION test_explode AS
892'org.apache.hadoop.hive.ql.udf.generic.GenericUDTFExplode'
893POSTHOOK: type: CREATEFUNCTION
894POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
895PREHOOK: query: CREATE VIEW view11 AS
896SELECT test_explode(array(1,2,3)) AS (boom)
897FROM table1
898PREHOOK: type: CREATEVIEW
899PREHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-04-26_16-17-59_492_3133189980222184516/-mr-10000
900POSTHOOK: query: CREATE VIEW view11 AS
901SELECT test_explode(array(1,2,3)) AS (boom)
902FROM table1
903POSTHOOK: type: CREATEVIEW
904POSTHOOK: Output: default@view11
905POSTHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-04-26_16-17-59_492_3133189980222184516/-mr-10000
906POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
907PREHOOK: query: DESCRIBE EXTENDED view11
908PREHOOK: type: DESCTABLE
909POSTHOOK: query: DESCRIBE EXTENDED view11
910POSTHOOK: type: DESCTABLE
911POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
912boom	int	
913	 	 
914Detailed Table Information	Table(tableName:view11, dbName:default, owner:jsichi, createTime:1303859879, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:boom, type:int, comment:null)], location:null, inputFormat:org.apache.hadoop.mapred.SequenceFileInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:null, parameters:{}), bucketCols:[], sortCols:[], parameters:{}), partitionKeys:[], parameters:{transient_lastDdlTime=1303859879}, viewOriginalText:SELECT test_explode(array(1,2,3)) AS (boom)	 
915FROM table1, viewExpandedText:SELECT `test_explode`(array(1,2,3)) AS (`boom`)	 	 
916FROM `table1`, tableType:VIRTUAL_VIEW)		 
917PREHOOK: query: DESCRIBE FORMATTED view11
918PREHOOK: type: DESCTABLE
919POSTHOOK: query: DESCRIBE FORMATTED view11
920POSTHOOK: type: DESCTABLE
921POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
922# col_name            	data_type           	comment             
923	 	 
924boom                	int                 	None                
925	 	 
926# Detailed Table Information	 	 
927Database:           	default             	 
928Owner:              	jsichi              	 
929CreateTime:         	Tue Apr 26 16:17:59 PDT 2011	 
930LastAccessTime:     	UNKNOWN             	 
931Protect Mode:       	None                	 
932Retention:          	0                   	 
933Table Type:         	VIRTUAL_VIEW        	 
934Table Parameters:	 	 
935	transient_lastDdlTime	1303859879          
936	 	 
937# Storage Information	 	 
938SerDe Library:      	null                	 
939InputFormat:        	org.apache.hadoop.mapred.SequenceFileInputFormat	 
940OutputFormat:       	org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat	 
941Compressed:         	No                  	 
942Num Buckets:        	-1                  	 
943Bucket Columns:     	[]                  	 
944Sort Columns:       	[]                  	 
945	 	 
946# View Information	 	 
947View Original Text: 	SELECT test_explode(array(1,2,3)) AS (boom)	 
948FROM table1	 	 
949View Expanded Text: 	SELECT `test_explode`(array(1,2,3)) AS (`boom`)	 
950FROM `table1`	 	 
951PREHOOK: query: SELECT * FROM view11
952PREHOOK: type: QUERY
953PREHOOK: Input: default@table1
954PREHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-04-26_16-17-59_691_3771989062499335212/-mr-10000
955POSTHOOK: query: SELECT * FROM view11
956POSTHOOK: type: QUERY
957POSTHOOK: Input: default@table1
958POSTHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-04-26_16-17-59_691_3771989062499335212/-mr-10000
959POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
9601
9612
9623
963PREHOOK: query: -- test usage of LATERAL within a view
964CREATE VIEW view12 AS
965SELECT * FROM src LATERAL VIEW explode(array(1,2,3)) myTable AS myCol
966PREHOOK: type: CREATEVIEW
967PREHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-04-26_16-18-06_109_548391492775178085/-mr-10000
968POSTHOOK: query: -- test usage of LATERAL within a view
969CREATE VIEW view12 AS
970SELECT * FROM src LATERAL VIEW explode(array(1,2,3)) myTable AS myCol
971POSTHOOK: type: CREATEVIEW
972POSTHOOK: Output: default@view12
973POSTHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-04-26_16-18-06_109_548391492775178085/-mr-10000
974POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:de…

Large files files are truncated, but you can click here to view the full file