PageRenderTime 68ms CodeModel.GetById 24ms RepoModel.GetById 0ms app.codeStats 0ms

/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
Possible License(s): Apache-2.0, BSD-3-Clause, JSON, CPL-1.0 
    

  1. PREHOOK: query: DROP VIEW view1
    2. 

  2. PREHOOK: type: DROPVIEW
    3. 

  3. POSTHOOK: query: DROP VIEW view1
    4. 

  4. POSTHOOK: type: DROPVIEW
    5. 

  5. PREHOOK: query: DROP VIEW view2
    6. 

  6. PREHOOK: type: DROPVIEW
    7. 

  7. POSTHOOK: query: DROP VIEW view2
    8. 

  8. POSTHOOK: type: DROPVIEW
    9. 

  9. PREHOOK: query: DROP VIEW view3
    10. 

  10. PREHOOK: type: DROPVIEW
    11. 

  11. POSTHOOK: query: DROP VIEW view3
    12. 

  12. POSTHOOK: type: DROPVIEW
    13. 

  13. PREHOOK: query: DROP VIEW view4
    14. 

  14. PREHOOK: type: DROPVIEW
    15. 

  15. POSTHOOK: query: DROP VIEW view4
    16. 

  16. POSTHOOK: type: DROPVIEW
    17. 

  17. PREHOOK: query: DROP VIEW view5
    18. 

  18. PREHOOK: type: DROPVIEW
    19. 

  19. POSTHOOK: query: DROP VIEW view5
    20. 

  20. POSTHOOK: type: DROPVIEW
    21. 

  21. PREHOOK: query: DROP VIEW view6
    22. 

  22. PREHOOK: type: DROPVIEW
    23. 

  23. POSTHOOK: query: DROP VIEW view6
    24. 

  24. POSTHOOK: type: DROPVIEW
    25. 

  25. PREHOOK: query: DROP VIEW view7
    26. 

  26. PREHOOK: type: DROPVIEW
    27. 

  27. POSTHOOK: query: DROP VIEW view7
    28. 

  28. POSTHOOK: type: DROPVIEW
    29. 

  29. PREHOOK: query: DROP VIEW view8
    30. 

  30. PREHOOK: type: DROPVIEW
    31. 

  31. POSTHOOK: query: DROP VIEW view8
    32. 

  32. POSTHOOK: type: DROPVIEW
    33. 

  33. PREHOOK: query: DROP VIEW view9
    34. 

  34. PREHOOK: type: DROPVIEW
    35. 

  35. POSTHOOK: query: DROP VIEW view9
    36. 

  36. POSTHOOK: type: DROPVIEW
    37. 

  37. PREHOOK: query: DROP VIEW view10
    38. 

  38. PREHOOK: type: DROPVIEW
    39. 

  39. POSTHOOK: query: DROP VIEW view10
    40. 

  40. POSTHOOK: type: DROPVIEW
    41. 

  41. PREHOOK: query: DROP VIEW view11
    42. 

  42. PREHOOK: type: DROPVIEW
    43. 

  43. POSTHOOK: query: DROP VIEW view11
    44. 

  44. POSTHOOK: type: DROPVIEW
    45. 

  45. PREHOOK: query: DROP VIEW view12
    46. 

  46. PREHOOK: type: DROPVIEW
    47. 

  47. POSTHOOK: query: DROP VIEW view12
    48. 

  48. POSTHOOK: type: DROPVIEW
    49. 

  49. PREHOOK: query: DROP VIEW view13
    50. 

  50. PREHOOK: type: DROPVIEW
    51. 

  51. POSTHOOK: query: DROP VIEW view13
    52. 

  52. POSTHOOK: type: DROPVIEW
    53. 

  53. PREHOOK: query: DROP VIEW view14
    54. 

  54. PREHOOK: type: DROPVIEW
    55. 

  55. POSTHOOK: query: DROP VIEW view14
    56. 

  56. POSTHOOK: type: DROPVIEW
    57. 

  57. PREHOOK: query: DROP VIEW view15
    58. 

  58. PREHOOK: type: DROPVIEW
    59. 

  59. POSTHOOK: query: DROP VIEW view15
    60. 

  60. POSTHOOK: type: DROPVIEW
    61. 

  61. PREHOOK: query: DROP VIEW view16
    62. 

  62. PREHOOK: type: DROPVIEW
    63. 

  63. POSTHOOK: query: DROP VIEW view16
    64. 

  64. POSTHOOK: type: DROPVIEW
    65. 

  65. PREHOOK: query: DROP TEMPORARY FUNCTION test_translate
    66. 

  66. PREHOOK: type: DROPFUNCTION
    67. 

  67. POSTHOOK: query: DROP TEMPORARY FUNCTION test_translate
    68. 

  68. POSTHOOK: type: DROPFUNCTION
    69. 

  69. PREHOOK: query: DROP TEMPORARY FUNCTION test_max
    70. 

  70. PREHOOK: type: DROPFUNCTION
    71. 

  71. POSTHOOK: query: DROP TEMPORARY FUNCTION test_max
    72. 

  72. POSTHOOK: type: DROPFUNCTION
    73. 

  73. PREHOOK: query: DROP TEMPORARY FUNCTION test_explode
    74. 

  74. PREHOOK: type: DROPFUNCTION
    75. 

  75. POSTHOOK: query: DROP TEMPORARY FUNCTION test_explode
    76. 

  76. POSTHOOK: type: DROPFUNCTION
    77. 

  77. PREHOOK: query: SELECT * FROM src WHERE key=86
    78. 

  78. PREHOOK: type: QUERY
    79. 

  79. PREHOOK: Input: default@src
    80. 

  80. PREHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-04-26_16-16-12_021_1106810087376156794/-mr-10000
    81. 

  81. POSTHOOK: query: SELECT * FROM src WHERE key=86
    82. 

  82. POSTHOOK: type: QUERY
    83. 

  83. POSTHOOK: Input: default@src
    84. 

  84. POSTHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-04-26_16-16-12_021_1106810087376156794/-mr-10000
    85. 

  85. 86	val_86
    86. 

  86. PREHOOK: query: CREATE VIEW view1 AS SELECT value FROM src WHERE key=86
    87. 

  87. PREHOOK: type: CREATEVIEW
    88. 

  88. PREHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-04-26_16-16-17_953_4875542405127030243/-mr-10000
    89. 

  89. POSTHOOK: query: CREATE VIEW view1 AS SELECT value FROM src WHERE key=86
    90. 

  90. POSTHOOK: type: CREATEVIEW
    91. 

  91. POSTHOOK: Output: default@view1
    92. 

  92. POSTHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-04-26_16-16-17_953_4875542405127030243/-mr-10000
    93. 

  93. PREHOOK: query: CREATE VIEW view2 AS SELECT * FROM src
    94. 

  94. PREHOOK: type: CREATEVIEW
    95. 

  95. PREHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-04-26_16-16-18_014_8438067548180434124/-mr-10000
    96. 

  96. POSTHOOK: query: CREATE VIEW view2 AS SELECT * FROM src
    97. 

  97. POSTHOOK: type: CREATEVIEW
    98. 

  98. POSTHOOK: Output: default@view2
    99. 

  99. POSTHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-04-26_16-16-18_014_8438067548180434124/-mr-10000
    100. 

  100. PREHOOK: query: CREATE VIEW view3(valoo) 
    101. 

  101. TBLPROPERTIES ("fear" = "factor")
    102. 

  102. AS SELECT upper(value) FROM src WHERE key=86
    103. 

  103. PREHOOK: type: CREATEVIEW
    104. 

  104. PREHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-04-26_16-16-18_089_3958349172656455541/-mr-10000
    105. 

  105. POSTHOOK: query: CREATE VIEW view3(valoo) 
    106. 

  106. TBLPROPERTIES ("fear" = "factor")
    107. 

  107. AS SELECT upper(value) FROM src WHERE key=86
    108. 

  108. POSTHOOK: type: CREATEVIEW
    109. 

  109. POSTHOOK: Output: default@view3
    110. 

  110. POSTHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-04-26_16-16-18_089_3958349172656455541/-mr-10000
    111. 

  111. PREHOOK: query: SELECT * from view1
    112. 

  112. PREHOOK: type: QUERY
    113. 

  113. PREHOOK: Input: default@src
    114. 

  114. PREHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-04-26_16-16-18_142_1698516806922399028/-mr-10000
    115. 

  115. POSTHOOK: query: SELECT * from view1
    116. 

  116. POSTHOOK: type: QUERY
    117. 

  117. POSTHOOK: Input: default@src
    118. 

  118. POSTHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-04-26_16-16-18_142_1698516806922399028/-mr-10000
    119. 

  119. val_86
    120. 

  120. PREHOOK: query: SELECT * from view2 where key=18
    121. 

  121. PREHOOK: type: QUERY
    122. 

  122. PREHOOK: Input: default@src
    123. 

  123. PREHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-04-26_16-16-23_360_248483194889563851/-mr-10000
    124. 

  124. POSTHOOK: query: SELECT * from view2 where key=18
    125. 

  125. POSTHOOK: type: QUERY
    126. 

  126. POSTHOOK: Input: default@src
    127. 

  127. POSTHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-04-26_16-16-23_360_248483194889563851/-mr-10000
    128. 

  128. 18	val_18
    129. 

  129. 18	val_18
    130. 

  130. PREHOOK: query: SELECT * from view3
    131. 

  131. PREHOOK: type: QUERY
    132. 

  132. PREHOOK: Input: default@src
    133. 

  133. PREHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-04-26_16-16-28_891_6412017417282399882/-mr-10000
    134. 

  134. POSTHOOK: query: SELECT * from view3
    135. 

  135. POSTHOOK: type: QUERY
    136. 

  136. POSTHOOK: Input: default@src
    137. 

  137. POSTHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-04-26_16-16-28_891_6412017417282399882/-mr-10000
    138. 

  138. VAL_86
    139. 

  139. PREHOOK: query: -- test EXPLAIN output for CREATE VIEW
    140. 

  140. EXPLAIN
    141. 

  141. CREATE VIEW view0(valoo) AS SELECT upper(value) FROM src WHERE key=86
    142. 

  142. PREHOOK: type: CREATEVIEW
    143. 

  143. POSTHOOK: query: -- test EXPLAIN output for CREATE VIEW
    144. 

  144. EXPLAIN
    145. 

  145. CREATE VIEW view0(valoo) AS SELECT upper(value) FROM src WHERE key=86
    146. 

  146. POSTHOOK: type: CREATEVIEW
    147. 

  147. ABSTRACT SYNTAX TREE:
    148. 

  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. 

  149. 

  150. STAGE DEPENDENCIES:
    151. 

  151.   Stage-0 is a root stage
    152. 

  152. 

  153. STAGE PLANS:
    154. 

  154.   Stage: Stage-0
    155. 

  155.       Create View Operator:
    156. 

  156.         Create View
    157. 

  157.           if not exists: false
    158. 

  158.           columns: valoo string
    159. 

  159.           expanded text: SELECT `_c0` AS `valoo` FROM (SELECT upper(`src`.`value`) FROM `src` WHERE `src`.`key`=86) `view0`
    160. 

  160.           name: view0
    161. 

  161.           original text: SELECT upper(value) FROM src WHERE key=86
    162. 

  162. 

  163. 

  164. PREHOOK: query: -- make sure EXPLAIN works with a query which references a view
    165. 

  165. EXPLAIN
    166. 

  166. SELECT * from view2 where key=18
    167. 

  167. PREHOOK: type: QUERY
    168. 

  168. POSTHOOK: query: -- make sure EXPLAIN works with a query which references a view
    169. 

  169. EXPLAIN
    170. 

  170. SELECT * from view2 where key=18
    171. 

  171. POSTHOOK: type: QUERY
    172. 

  172. ABSTRACT SYNTAX TREE:
    173. 

  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. 

  174. 

  175. STAGE DEPENDENCIES:
    176. 

  176.   Stage-1 is a root stage
    177. 

  177.   Stage-0 is a root stage
    178. 

  178. 

  179. STAGE PLANS:
    180. 

  180.   Stage: Stage-1
    181. 

  181.     Map Reduce
    182. 

  182.       Alias -> Map Operator Tree:
    183. 

  183.         view2:src 
    184. 

  184.           TableScan
    185. 

  185.             alias: src
    186. 

  186.             Filter Operator
    187. 

  187.               predicate:
    188. 

  188.                   expr: (key = 18)
    189. 

  189.                   type: boolean
    190. 

  190.               Select Operator
    191. 

  191.                 expressions:
    192. 

  192.                       expr: key
    193. 

  193.                       type: string
    194. 

  194.                       expr: value
    195. 

  195.                       type: string
    196. 

  196.                 outputColumnNames: _col0, _col1
    197. 

  197.                 Select Operator
    198. 

  198.                   expressions:
    199. 

  199.                         expr: _col0
    200. 

  200.                         type: string
    201. 

  201.                         expr: _col1
    202. 

  202.                         type: string
    203. 

  203.                   outputColumnNames: _col0, _col1
    204. 

  204.                   File Output Operator
    205. 

  205.                     compressed: false
    206. 

  206.                     GlobalTableId: 0
    207. 

  207.                     table:
    208. 

  208.                         input format: org.apache.hadoop.mapred.TextInputFormat
    209. 

  209.                         output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
    210. 

  210. 

  211.   Stage: Stage-0
    212. 

  212.     Fetch Operator
    213. 

  213.       limit: -1
    214. 

  214. 

  215. 

  216. PREHOOK: query: SHOW TABLES 'view.*'
    217. 

  217. PREHOOK: type: SHOWTABLES
    218. 

  218. POSTHOOK: query: SHOW TABLES 'view.*'
    219. 

  219. POSTHOOK: type: SHOWTABLES
    220. 

  220. view1
    221. 

  221. view2
    222. 

  222. view3
    223. 

  223. PREHOOK: query: DESCRIBE view1
    224. 

  224. PREHOOK: type: DESCTABLE
    225. 

  225. POSTHOOK: query: DESCRIBE view1
    226. 

  226. POSTHOOK: type: DESCTABLE
    227. 

  227. value	string	
    228. 

  228. PREHOOK: query: DESCRIBE EXTENDED view1
    229. 

  229. PREHOOK: type: DESCTABLE
    230. 

  230. POSTHOOK: query: DESCRIBE EXTENDED view1
    231. 

  231. POSTHOOK: type: DESCTABLE
    232. 

  232. value	string	
    233. 

  233. 	 	 
    234. 

  234. Detailed 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)	
    235. 

  235. PREHOOK: query: DESCRIBE FORMATTED view1
    236. 

  236. PREHOOK: type: DESCTABLE
    237. 

  237. POSTHOOK: query: DESCRIBE FORMATTED view1
    238. 

  238. POSTHOOK: type: DESCTABLE
    239. 

  239. # col_name            	data_type           	comment             
    240. 

  240. 	 	 
    241. 

  241. value               	string              	None                
    242. 

  242. 	 	 
    243. 

  243. # Detailed Table Information	 	 
    244. 

  244. Database:           	default             	 
    245. 

  245. Owner:              	jsichi              	 
    246. 

  246. CreateTime:         	Tue Apr 26 16:16:17 PDT 2011	 
    247. 

  247. LastAccessTime:     	UNKNOWN             	 
    248. 

  248. Protect Mode:       	None                	 
    249. 

  249. Retention:          	0                   	 
    250. 

  250. Table Type:         	VIRTUAL_VIEW        	 
    251. 

  251. Table Parameters:	 	 
    252. 

  252. 	transient_lastDdlTime	1303859777          
    253. 

  253. 	 	 
    254. 

  254. # Storage Information	 	 
    255. 

  255. SerDe Library:      	null                	 
    256. 

  256. InputFormat:        	org.apache.hadoop.mapred.SequenceFileInputFormat	 
    257. 

  257. OutputFormat:       	org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat	 
    258. 

  258. Compressed:         	No                  	 
    259. 

  259. Num Buckets:        	-1                  	 
    260. 

  260. Bucket Columns:     	[]                  	 
    261. 

  261. Sort Columns:       	[]                  	 
    262. 

  262. 	 	 
    263. 

  263. # View Information	 	 
    264. 

  264. View Original Text: 	SELECT value FROM src WHERE key=86	 
    265. 

  265. View Expanded Text: 	SELECT `src`.`value` FROM `src` WHERE `src`.`key`=86	 
    266. 

  266. PREHOOK: query: DESCRIBE view2
    267. 

  267. PREHOOK: type: DESCTABLE
    268. 

  268. POSTHOOK: query: DESCRIBE view2
    269. 

  269. POSTHOOK: type: DESCTABLE
    270. 

  270. key	string	
    271. 

  271. value	string	
    272. 

  272. PREHOOK: query: DESCRIBE EXTENDED view2
    273. 

  273. PREHOOK: type: DESCTABLE
    274. 

  274. POSTHOOK: query: DESCRIBE EXTENDED view2
    275. 

  275. POSTHOOK: type: DESCTABLE
    276. 

  276. key	string	
    277. 

  277. value	string	
    278. 

  278. 	 	 
    279. 

  279. Detailed 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)	
    280. 

  280. PREHOOK: query: DESCRIBE FORMATTED view2
    281. 

  281. PREHOOK: type: DESCTABLE
    282. 

  282. POSTHOOK: query: DESCRIBE FORMATTED view2
    283. 

  283. POSTHOOK: type: DESCTABLE
    284. 

  284. # col_name            	data_type           	comment             
    285. 

  285. 	 	 
    286. 

  286. key                 	string              	None                
    287. 

  287. value               	string              	None                
    288. 

  288. 	 	 
    289. 

  289. # Detailed Table Information	 	 
    290. 

  290. Database:           	default             	 
    291. 

  291. Owner:              	jsichi              	 
    292. 

  292. CreateTime:         	Tue Apr 26 16:16:18 PDT 2011	 
    293. 

  293. LastAccessTime:     	UNKNOWN             	 
    294. 

  294. Protect Mode:       	None                	 
    295. 

  295. Retention:          	0                   	 
    296. 

  296. Table Type:         	VIRTUAL_VIEW        	 
    297. 

  297. Table Parameters:	 	 
    298. 

  298. 	transient_lastDdlTime	1303859778          
    299. 

  299. 	 	 
    300. 

  300. # Storage Information	 	 
    301. 

  301. SerDe Library:      	null                	 
    302. 

  302. InputFormat:        	org.apache.hadoop.mapred.SequenceFileInputFormat	 
    303. 

  303. OutputFormat:       	org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat	 
    304. 

  304. Compressed:         	No                  	 
    305. 

  305. Num Buckets:        	-1                  	 
    306. 

  306. Bucket Columns:     	[]                  	 
    307. 

  307. Sort Columns:       	[]                  	 
    308. 

  308. 	 	 
    309. 

  309. # View Information	 	 
    310. 

  310. View Original Text: 	SELECT * FROM src   	 
    311. 

  311. View Expanded Text: 	SELECT `src`.`key`, `src`.`value` FROM `src`	 
    312. 

  312. PREHOOK: query: DESCRIBE view3
    313. 

  313. PREHOOK: type: DESCTABLE
    314. 

  314. POSTHOOK: query: DESCRIBE view3
    315. 

  315. POSTHOOK: type: DESCTABLE
    316. 

  316. valoo	string	
    317. 

  317. PREHOOK: query: DESCRIBE EXTENDED view3
    318. 

  318. PREHOOK: type: DESCTABLE
    319. 

  319. POSTHOOK: query: DESCRIBE EXTENDED view3
    320. 

  320. POSTHOOK: type: DESCTABLE
    321. 

  321. valoo	string	
    322. 

  322. 	 	 
    323. 

  323. Detailed 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)	
    324. 

  324. PREHOOK: query: DESCRIBE FORMATTED view3
    325. 

  325. PREHOOK: type: DESCTABLE
    326. 

  326. POSTHOOK: query: DESCRIBE FORMATTED view3
    327. 

  327. POSTHOOK: type: DESCTABLE
    328. 

  328. # col_name            	data_type           	comment             
    329. 

  329. 	 	 
    330. 

  330. valoo               	string              	None                
    331. 

  331. 	 	 
    332. 

  332. # Detailed Table Information	 	 
    333. 

  333. Database:           	default             	 
    334. 

  334. Owner:              	jsichi              	 
    335. 

  335. CreateTime:         	Tue Apr 26 16:16:18 PDT 2011	 
    336. 

  336. LastAccessTime:     	UNKNOWN             	 
    337. 

  337. Protect Mode:       	None                	 
    338. 

  338. Retention:          	0                   	 
    339. 

  339. Table Type:         	VIRTUAL_VIEW        	 
    340. 

  340. Table Parameters:	 	 
    341. 

  341. 	fear                	factor              
    342. 

  342. 	transient_lastDdlTime	1303859778          
    343. 

  343. 	 	 
    344. 

  344. # Storage Information	 	 
    345. 

  345. SerDe Library:      	null                	 
    346. 

  346. InputFormat:        	org.apache.hadoop.mapred.SequenceFileInputFormat	 
    347. 

  347. OutputFormat:       	org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat	 
    348. 

  348. Compressed:         	No                  	 
    349. 

  349. Num Buckets:        	-1                  	 
    350. 

  350. Bucket Columns:     	[]                  	 
    351. 

  351. Sort Columns:       	[]                  	 
    352. 

  352. 	 	 
    353. 

  353. # View Information	 	 
    354. 

  354. View Original Text: 	SELECT upper(value) FROM src WHERE key=86	 
    355. 

  355. View Expanded Text: 	SELECT `_c0` AS `valoo` FROM (SELECT upper(`src`.`value`) FROM `src` WHERE `src`.`key`=86) `view3`	 
    356. 

  356. PREHOOK: query: ALTER VIEW view3 SET TBLPROPERTIES ("biggest" = "loser")
    357. 

  357. PREHOOK: type: ALTERVIEW_PROPERTIES
    358. 

  358. PREHOOK: Input: default@view3
    359. 

  359. PREHOOK: Output: default@view3
    360. 

  360. POSTHOOK: query: ALTER VIEW view3 SET TBLPROPERTIES ("biggest" = "loser")
    361. 

  361. POSTHOOK: type: ALTERVIEW_PROPERTIES
    362. 

  362. POSTHOOK: Input: default@view3
    363. 

  363. POSTHOOK: Output: default@view3
    364. 

  364. PREHOOK: query: DESCRIBE EXTENDED view3
    365. 

  365. PREHOOK: type: DESCTABLE
    366. 

  366. POSTHOOK: query: DESCRIBE EXTENDED view3
    367. 

  367. POSTHOOK: type: DESCTABLE
    368. 

  368. valoo	string	
    369. 

  369. 	 	 
    370. 

  370. Detailed 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)	
    371. 

  371. PREHOOK: query: DESCRIBE FORMATTED view3
    372. 

  372. PREHOOK: type: DESCTABLE
    373. 

  373. POSTHOOK: query: DESCRIBE FORMATTED view3
    374. 

  374. POSTHOOK: type: DESCTABLE
    375. 

  375. # col_name            	data_type           	comment             
    376. 

  376. 	 	 
    377. 

  377. valoo               	string              	None                
    378. 

  378. 	 	 
    379. 

  379. # Detailed Table Information	 	 
    380. 

  380. Database:           	default             	 
    381. 

  381. Owner:              	jsichi              	 
    382. 

  382. CreateTime:         	Tue Apr 26 16:16:18 PDT 2011	 
    383. 

  383. LastAccessTime:     	UNKNOWN             	 
    384. 

  384. Protect Mode:       	None                	 
    385. 

  385. Retention:          	0                   	 
    386. 

  386. Table Type:         	VIRTUAL_VIEW        	 
    387. 

  387. Table Parameters:	 	 
    388. 

  388. 	biggest             	loser               
    389. 

  389. 	fear                	factor              
    390. 

  390. 	last_modified_by    	jsichi              
    391. 

  391. 	last_modified_time  	1303859796          
    392. 

  392. 	transient_lastDdlTime	1303859796          
    393. 

  393. 	 	 
    394. 

  394. # Storage Information	 	 
    395. 

  395. SerDe Library:      	null                	 
    396. 

  396. InputFormat:        	org.apache.hadoop.mapred.SequenceFileInputFormat	 
    397. 

  397. OutputFormat:       	org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat	 
    398. 

  398. Compressed:         	No                  	 
    399. 

  399. Num Buckets:        	-1                  	 
    400. 

  400. Bucket Columns:     	[]                  	 
    401. 

  401. Sort Columns:       	[]                  	 
    402. 

  402. 	 	 
    403. 

  403. # View Information	 	 
    404. 

  404. View Original Text: 	SELECT upper(value) FROM src WHERE key=86	 
    405. 

  405. View Expanded Text: 	SELECT `_c0` AS `valoo` FROM (SELECT upper(`src`.`value`) FROM `src` WHERE `src`.`key`=86) `view3`	 
    406. 

  406. PREHOOK: query: CREATE TABLE table1 (key int)
    407. 

  407. PREHOOK: type: CREATETABLE
    408. 

  408. POSTHOOK: query: CREATE TABLE table1 (key int)
    409. 

  409. POSTHOOK: type: CREATETABLE
    410. 

  410. POSTHOOK: Output: default@table1
    411. 

  411. PREHOOK: query: -- use DESCRIBE EXTENDED on a base table and an external table as points
    412. 

  412. -- of comparison for view descriptions
    413. 

  413. DESCRIBE EXTENDED table1
    414. 

  414. PREHOOK: type: DESCTABLE
    415. 

  415. POSTHOOK: query: -- use DESCRIBE EXTENDED on a base table and an external table as points
    416. 

  416. -- of comparison for view descriptions
    417. 

  417. DESCRIBE EXTENDED table1
    418. 

  418. POSTHOOK: type: DESCTABLE
    419. 

  419. key	int	
    420. 

  420. 	 	 
    421. 

  421. Detailed 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)	
    422. 

  422. PREHOOK: query: DESCRIBE EXTENDED src1
    423. 

  423. PREHOOK: type: DESCTABLE
    424. 

  424. POSTHOOK: query: DESCRIBE EXTENDED src1
    425. 

  425. POSTHOOK: type: DESCTABLE
    426. 

  426. key	string	default
    427. 

  427. value	string	default
    428. 

  428. 	 	 
    429. 

  429. Detailed 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)	
    430. 

  430. PREHOOK: query: -- use DESCRIBE EXTENDED on a base table as a point of comparison for
    431. 

  431. -- view descriptions
    432. 

  432. DESCRIBE EXTENDED table1
    433. 

  433. PREHOOK: type: DESCTABLE
    434. 

  434. POSTHOOK: query: -- use DESCRIBE EXTENDED on a base table as a point of comparison for
    435. 

  435. -- view descriptions
    436. 

  436. DESCRIBE EXTENDED table1
    437. 

  437. POSTHOOK: type: DESCTABLE
    438. 

  438. key	int	
    439. 

  439. 	 	 
    440. 

  440. Detailed 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)	
    441. 

  441. PREHOOK: query: INSERT OVERWRITE TABLE table1 SELECT key FROM src WHERE key = 86
    442. 

  442. PREHOOK: type: QUERY
    443. 

  443. PREHOOK: Input: default@src
    444. 

  444. PREHOOK: Output: default@table1
    445. 

  445. POSTHOOK: query: INSERT OVERWRITE TABLE table1 SELECT key FROM src WHERE key = 86
    446. 

  446. POSTHOOK: type: QUERY
    447. 

  447. POSTHOOK: Input: default@src
    448. 

  448. POSTHOOK: Output: default@table1
    449. 

  449. POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    450. 

  450. PREHOOK: query: SELECT * FROM table1
    451. 

  451. PREHOOK: type: QUERY
    452. 

  452. PREHOOK: Input: default@table1
    453. 

  453. PREHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-04-26_16-16-45_947_2085561936927801936/-mr-10000
    454. 

  454. POSTHOOK: query: SELECT * FROM table1
    455. 

  455. POSTHOOK: type: QUERY
    456. 

  456. POSTHOOK: Input: default@table1
    457. 

  457. POSTHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-04-26_16-16-45_947_2085561936927801936/-mr-10000
    458. 

  458. POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    459. 

  459. 86
    460. 

  460. PREHOOK: query: CREATE VIEW view4 AS SELECT * FROM table1
    461. 

  461. PREHOOK: type: CREATEVIEW
    462. 

  462. PREHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-04-26_16-16-46_138_7447815181838056815/-mr-10000
    463. 

  463. POSTHOOK: query: CREATE VIEW view4 AS SELECT * FROM table1
    464. 

  464. POSTHOOK: type: CREATEVIEW
    465. 

  465. POSTHOOK: Output: default@view4
    466. 

  466. POSTHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-04-26_16-16-46_138_7447815181838056815/-mr-10000
    467. 

  467. POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    468. 

  468. PREHOOK: query: SELECT * FROM view4
    469. 

  469. PREHOOK: type: QUERY
    470. 

  470. PREHOOK: Input: default@table1
    471. 

  471. PREHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-04-26_16-16-46_196_5105547280114080249/-mr-10000
    472. 

  472. POSTHOOK: query: SELECT * FROM view4
    473. 

  473. POSTHOOK: type: QUERY
    474. 

  474. POSTHOOK: Input: default@table1
    475. 

  475. POSTHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-04-26_16-16-46_196_5105547280114080249/-mr-10000
    476. 

  476. POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    477. 

  477. 86
    478. 

  478. PREHOOK: query: DESCRIBE view4
    479. 

  479. PREHOOK: type: DESCTABLE
    480. 

  480. POSTHOOK: query: DESCRIBE view4
    481. 

  481. POSTHOOK: type: DESCTABLE
    482. 

  482. POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    483. 

  483. key	int	
    484. 

  484. PREHOOK: query: ALTER TABLE table1 ADD COLUMNS (value STRING)
    485. 

  485. PREHOOK: type: ALTERTABLE_ADDCOLS
    486. 

  486. PREHOOK: Input: default@table1
    487. 

  487. PREHOOK: Output: default@table1
    488. 

  488. POSTHOOK: query: ALTER TABLE table1 ADD COLUMNS (value STRING)
    489. 

  489. POSTHOOK: type: ALTERTABLE_ADDCOLS
    490. 

  490. POSTHOOK: Input: default@table1
    491. 

  491. POSTHOOK: Output: default@table1
    492. 

  492. POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    493. 

  493. PREHOOK: query: SELECT * FROM table1
    494. 

  494. PREHOOK: type: QUERY
    495. 

  495. PREHOOK: Input: default@table1
    496. 

  496. PREHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-04-26_16-16-51_573_8021843774469758715/-mr-10000
    497. 

  497. POSTHOOK: query: SELECT * FROM table1
    498. 

  498. POSTHOOK: type: QUERY
    499. 

  499. POSTHOOK: Input: default@table1
    500. 

  500. POSTHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-04-26_16-16-51_573_8021843774469758715/-mr-10000
    501. 

  501. POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    502. 

  502. 86	NULL
    503. 

  503. PREHOOK: query: SELECT * FROM view4
    504. 

  504. PREHOOK: type: QUERY
    505. 

  505. PREHOOK: Input: default@table1
    506. 

  506. PREHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-04-26_16-16-51_751_5422952837986050518/-mr-10000
    507. 

  507. POSTHOOK: query: SELECT * FROM view4
    508. 

  508. POSTHOOK: type: QUERY
    509. 

  509. POSTHOOK: Input: default@table1
    510. 

  510. POSTHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-04-26_16-16-51_751_5422952837986050518/-mr-10000
    511. 

  511. POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    512. 

  512. 86
    513. 

  513. PREHOOK: query: DESCRIBE table1
    514. 

  514. PREHOOK: type: DESCTABLE
    515. 

  515. POSTHOOK: query: DESCRIBE table1
    516. 

  516. POSTHOOK: type: DESCTABLE
    517. 

  517. POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    518. 

  518. key	int	
    519. 

  519. value	string	
    520. 

  520. PREHOOK: query: DESCRIBE view4
    521. 

  521. PREHOOK: type: DESCTABLE
    522. 

  522. POSTHOOK: query: DESCRIBE view4
    523. 

  523. POSTHOOK: type: DESCTABLE
    524. 

  524. POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    525. 

  525. key	int	
    526. 

  526. PREHOOK: query: CREATE VIEW view5 AS SELECT v1.key as key1, v2.key as key2
    527. 

  527. FROM view4 v1 join view4 v2
    528. 

  528. PREHOOK: type: CREATEVIEW
    529. 

  529. PREHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-04-26_16-16-57_155_7569906550037001887/-mr-10000
    530. 

  530. POSTHOOK: query: CREATE VIEW view5 AS SELECT v1.key as key1, v2.key as key2
    531. 

  531. FROM view4 v1 join view4 v2
    532. 

  532. POSTHOOK: type: CREATEVIEW
    533. 

  533. POSTHOOK: Output: default@view5
    534. 

  534. POSTHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-04-26_16-16-57_155_7569906550037001887/-mr-10000
    535. 

  535. POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    536. 

  536. PREHOOK: query: SELECT * FROM view5
    537. 

  537. PREHOOK: type: QUERY
    538. 

  538. PREHOOK: Input: default@table1
    539. 

  539. PREHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-04-26_16-16-57_237_2199423335065636496/-mr-10000
    540. 

  540. POSTHOOK: query: SELECT * FROM view5
    541. 

  541. POSTHOOK: type: QUERY
    542. 

  542. POSTHOOK: Input: default@table1
    543. 

  543. POSTHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-04-26_16-16-57_237_2199423335065636496/-mr-10000
    544. 

  544. POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    545. 

  545. 86	86
    546. 

  546. PREHOOK: query: DESCRIBE view5
    547. 

  547. PREHOOK: type: DESCTABLE
    548. 

  548. POSTHOOK: query: DESCRIBE view5
    549. 

  549. POSTHOOK: type: DESCTABLE
    550. 

  550. POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    551. 

  551. key1	int	
    552. 

  552. key2	int	
    553. 

  553. PREHOOK: query: -- verify that column name and comment in DDL portion
    554. 

  554. -- overrides column alias in SELECT
    555. 

  555. CREATE VIEW view6(valoo COMMENT 'I cannot spell') AS
    556. 

  556. SELECT upper(value) as blarg FROM src WHERE key=86
    557. 

  557. PREHOOK: type: CREATEVIEW
    558. 

  558. PREHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-04-26_16-17-03_839_7899860047026359445/-mr-10000
    559. 

  559. POSTHOOK: query: -- verify that column name and comment in DDL portion
    560. 

  560. -- overrides column alias in SELECT
    561. 

  561. CREATE VIEW view6(valoo COMMENT 'I cannot spell') AS
    562. 

  562. SELECT upper(value) as blarg FROM src WHERE key=86
    563. 

  563. POSTHOOK: type: CREATEVIEW
    564. 

  564. POSTHOOK: Output: default@view6
    565. 

  565. POSTHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-04-26_16-17-03_839_7899860047026359445/-mr-10000
    566. 

  566. POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    567. 

  567. PREHOOK: query: DESCRIBE view6
    568. 

  568. PREHOOK: type: DESCTABLE
    569. 

  569. POSTHOOK: query: DESCRIBE view6
    570. 

  570. POSTHOOK: type: DESCTABLE
    571. 

  571. POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    572. 

  572. valoo	string	I cannot spell
    573. 

  573. PREHOOK: query: -- verify that ORDER BY and LIMIT are both supported in view def
    574. 

  574. CREATE VIEW view7 AS
    575. 

  575. SELECT * FROM src
    576. 

  576. WHERE key > 80 AND key < 100
    577. 

  577. ORDER BY key, value
    578. 

  578. LIMIT 10
    579. 

  579. PREHOOK: type: CREATEVIEW
    580. 

  580. PREHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-04-26_16-17-03_964_2634118939893651146/-mr-10000
    581. 

  581. POSTHOOK: query: -- verify that ORDER BY and LIMIT are both supported in view def
    582. 

  582. CREATE VIEW view7 AS
    583. 

  583. SELECT * FROM src
    584. 

  584. WHERE key > 80 AND key < 100
    585. 

  585. ORDER BY key, value
    586. 

  586. LIMIT 10
    587. 

  587. POSTHOOK: type: CREATEVIEW
    588. 

  588. POSTHOOK: Output: default@view7
    589. 

  589. POSTHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-04-26_16-17-03_964_2634118939893651146/-mr-10000
    590. 

  590. POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    591. 

  591. PREHOOK: query: SELECT * FROM view7
    592. 

  592. PREHOOK: type: QUERY
    593. 

  593. PREHOOK: Input: default@src
    594. 

  594. PREHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-04-26_16-17-04_060_9004942114636875404/-mr-10000
    595. 

  595. POSTHOOK: query: SELECT * FROM view7
    596. 

  596. POSTHOOK: type: QUERY
    597. 

  597. POSTHOOK: Input: default@src
    598. 

  598. POSTHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-04-26_16-17-04_060_9004942114636875404/-mr-10000
    599. 

  599. POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    600. 

  600. 82	val_82
    601. 

  601. 83	val_83
    602. 

  602. 83	val_83
    603. 

  603. 84	val_84
    604. 

  604. 84	val_84
    605. 

  605. 85	val_85
    606. 

  606. 86	val_86
    607. 

  607. 87	val_87
    608. 

  608. 90	val_90
    609. 

  609. 90	val_90
    610. 

  610. PREHOOK: query: -- top-level ORDER BY should override the one inside the view
    611. 

  611. -- (however, the inside ORDER BY should still influence the evaluation
    612. 

  612. -- of the limit)
    613. 

  613. SELECT * FROM view7 ORDER BY key DESC, value
    614. 

  614. PREHOOK: type: QUERY
    615. 

  615. PREHOOK: Input: default@src
    616. 

  616. PREHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-04-26_16-17-10_678_5006662899774141111/-mr-10000
    617. 

  617. POSTHOOK: query: -- top-level ORDER BY should override the one inside the view
    618. 

  618. -- (however, the inside ORDER BY should still influence the evaluation
    619. 

  619. -- of the limit)
    620. 

  620. SELECT * FROM view7 ORDER BY key DESC, value
    621. 

  621. POSTHOOK: type: QUERY
    622. 

  622. POSTHOOK: Input: default@src
    623. 

  623. POSTHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-04-26_16-17-10_678_5006662899774141111/-mr-10000
    624. 

  624. POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    625. 

  625. 90	val_90
    626. 

  626. 90	val_90
    627. 

  627. 87	val_87
    628. 

  628. 86	val_86
    629. 

  629. 85	val_85
    630. 

  630. 84	val_84
    631. 

  631. 84	val_84
    632. 

  632. 83	val_83
    633. 

  633. 83	val_83
    634. 

  634. 82	val_82
    635. 

  635. PREHOOK: query: -- top-level LIMIT should override if lower
    636. 

  636. SELECT * FROM view7 LIMIT 5
    637. 

  637. PREHOOK: type: QUERY
    638. 

  638. PREHOOK: Input: default@src
    639. 

  639. PREHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-04-26_16-17-25_276_742038559388418902/-mr-10000
    640. 

  640. POSTHOOK: query: -- top-level LIMIT should override if lower
    641. 

  641. SELECT * FROM view7 LIMIT 5
    642. 

  642. POSTHOOK: type: QUERY
    643. 

  643. POSTHOOK: Input: default@src
    644. 

  644. POSTHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-04-26_16-17-25_276_742038559388418902/-mr-10000
    645. 

  645. POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    646. 

  646. 82	val_82
    647. 

  647. 83	val_83
    648. 

  648. 83	val_83
    649. 

  649. 84	val_84
    650. 

  650. 84	val_84
    651. 

  651. PREHOOK: query: -- but not if higher
    652. 

  652. SELECT * FROM view7 LIMIT 20
    653. 

  653. PREHOOK: type: QUERY
    654. 

  654. PREHOOK: Input: default@src
    655. 

  655. PREHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-04-26_16-17-32_922_7537536843995339809/-mr-10000
    656. 

  656. POSTHOOK: query: -- but not if higher
    657. 

  657. SELECT * FROM view7 LIMIT 20
    658. 

  658. POSTHOOK: type: QUERY
    659. 

  659. POSTHOOK: Input: default@src
    660. 

  660. POSTHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-04-26_16-17-32_922_7537536843995339809/-mr-10000
    661. 

  661. POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    662. 

  662. 82	val_82
    663. 

  663. 83	val_83
    664. 

  664. 83	val_83
    665. 

  665. 84	val_84
    666. 

  666. 84	val_84
    667. 

  667. 85	val_85
    668. 

  668. 86	val_86
    669. 

  669. 87	val_87
    670. 

  670. 90	val_90
    671. 

  671. 90	val_90
    672. 

  672. PREHOOK: query: -- test usage of a function within a view
    673. 

  673. CREATE TEMPORARY FUNCTION test_translate AS
    674. 

  674. 'org.apache.hadoop.hive.ql.udf.generic.GenericUDFTestTranslate'
    675. 

  675. PREHOOK: type: CREATEFUNCTION
    676. 

  676. POSTHOOK: query: -- test usage of a function within a view
    677. 

  677. CREATE TEMPORARY FUNCTION test_translate AS
    678. 

  678. 'org.apache.hadoop.hive.ql.udf.generic.GenericUDFTestTranslate'
    679. 

  679. POSTHOOK: type: CREATEFUNCTION
    680. 

  680. POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    681. 

  681. PREHOOK: query: CREATE VIEW view8(c) AS
    682. 

  682. SELECT test_translate('abc', 'a', 'b')
    683. 

  683. FROM table1
    684. 

  684. PREHOOK: type: CREATEVIEW
    685. 

  685. PREHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-04-26_16-17-39_332_7325117518490785843/-mr-10000
    686. 

  686. POSTHOOK: query: CREATE VIEW view8(c) AS
    687. 

  687. SELECT test_translate('abc', 'a', 'b')
    688. 

  688. FROM table1
    689. 

  689. POSTHOOK: type: CREATEVIEW
    690. 

  690. POSTHOOK: Output: default@view8
    691. 

  691. POSTHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-04-26_16-17-39_332_7325117518490785843/-mr-10000
    692. 

  692. POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    693. 

  693. PREHOOK: query: DESCRIBE EXTENDED view8
    694. 

  694. PREHOOK: type: DESCTABLE
    695. 

  695. POSTHOOK: query: DESCRIBE EXTENDED view8
    696. 

  696. POSTHOOK: type: DESCTABLE
    697. 

  697. POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    698. 

  698. c	string	
    699. 

  699. 	 	 
    700. 

  700. Detailed 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')	 
    701. 

  701. FROM table1, viewExpandedText:SELECT `_c0` AS `c` FROM (SELECT `test_translate`('abc', 'a', 'b')	 	 
    702. 

  702. FROM `table1`) `view8`, tableType:VIRTUAL_VIEW)		 
    703. 

  703. PREHOOK: query: DESCRIBE FORMATTED view8
    704. 

  704. PREHOOK: type: DESCTABLE
    705. 

  705. POSTHOOK: query: DESCRIBE FORMATTED view8
    706. 

  706. POSTHOOK: type: DESCTABLE
    707. 

  707. POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    708. 

  708. # col_name            	data_type           	comment             
    709. 

  709. 	 	 
    710. 

  710. c                   	string              	None                
    711. 

  711. 	 	 
    712. 

  712. # Detailed Table Information	 	 
    713. 

  713. Database:           	default             	 
    714. 

  714. Owner:              	jsichi              	 
    715. 

  715. CreateTime:         	Tue Apr 26 16:17:39 PDT 2011	 
    716. 

  716. LastAccessTime:     	UNKNOWN             	 
    717. 

  717. Protect Mode:       	None                	 
    718. 

  718. Retention:          	0                   	 
    719. 

  719. Table Type:         	VIRTUAL_VIEW        	 
    720. 

  720. Table Parameters:	 	 
    721. 

  721. 	transient_lastDdlTime	1303859859          
    722. 

  722. 	 	 
    723. 

  723. # Storage Information	 	 
    724. 

  724. SerDe Library:      	null                	 
    725. 

  725. InputFormat:        	org.apache.hadoop.mapred.SequenceFileInputFormat	 
    726. 

  726. OutputFormat:       	org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat	 
    727. 

  727. Compressed:         	No                  	 
    728. 

  728. Num Buckets:        	-1                  	 
    729. 

  729. Bucket Columns:     	[]                  	 
    730. 

  730. Sort Columns:       	[]                  	 
    731. 

  731. 	 	 
    732. 

  732. # View Information	 	 
    733. 

  733. View Original Text: 	SELECT test_translate('abc', 'a', 'b')	 
    734. 

  734. FROM table1	 	 
    735. 

  735. View Expanded Text: 	SELECT `_c0` AS `c` FROM (SELECT `test_translate`('abc', 'a', 'b')	 
    736. 

  736. FROM `table1`) `view8`	 	 
    737. 

  737. PREHOOK: query: SELECT * FROM view8
    738. 

  738. PREHOOK: type: QUERY
    739. 

  739. PREHOOK: Input: default@table1
    740. 

  740. PREHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-04-26_16-17-39_534_6753322851996532137/-mr-10000
    741. 

  741. POSTHOOK: query: SELECT * FROM view8
    742. 

  742. POSTHOOK: type: QUERY
    743. 

  743. POSTHOOK: Input: default@table1
    744. 

  744. POSTHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-04-26_16-17-39_534_6753322851996532137/-mr-10000
    745. 

  745. POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    746. 

  746. bbc
    747. 

  747. PREHOOK: query: -- test usage of a UDAF within a view
    748. 

  748. CREATE TEMPORARY FUNCTION test_max AS
    749. 

  749. 'org.apache.hadoop.hive.ql.udf.UDAFTestMax'
    750. 

  750. PREHOOK: type: CREATEFUNCTION
    751. 

  751. POSTHOOK: query: -- test usage of a UDAF within a view
    752. 

  752. CREATE TEMPORARY FUNCTION test_max AS
    753. 

  753. 'org.apache.hadoop.hive.ql.udf.UDAFTestMax'
    754. 

  754. POSTHOOK: type: CREATEFUNCTION
    755. 

  755. POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    756. 

  756. PREHOOK: query: CREATE VIEW view9(m) AS
    757. 

  757. SELECT test_max(length(value))
    758. 

  758. FROM src
    759. 

  759. PREHOOK: type: CREATEVIEW
    760. 

  760. PREHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-04-26_16-17-45_689_3977124058975857089/-mr-10000
    761. 

  761. POSTHOOK: query: CREATE VIEW view9(m) AS
    762. 

  762. SELECT test_max(length(value))
    763. 

  763. FROM src
    764. 

  764. POSTHOOK: type: CREATEVIEW
    765. 

  765. POSTHOOK: Output: default@view9
    766. 

  766. POSTHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-04-26_16-17-45_689_3977124058975857089/-mr-10000
    767. 

  767. POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    768. 

  768. PREHOOK: query: DESCRIBE EXTENDED view9
    769. 

  769. PREHOOK: type: DESCTABLE
    770. 

  770. POSTHOOK: query: DESCRIBE EXTENDED view9
    771. 

  771. POSTHOOK: type: DESCTABLE
    772. 

  772. POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    773. 

  773. m	int	
    774. 

  774. 	 	 
    775. 

  775. Detailed 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))	 
    776. 

  776. FROM src, viewExpandedText:SELECT `_c0` AS `m` FROM (SELECT `test_max`(length(`src`.`value`))	 	 
    777. 

  777. FROM `src`) `view9`, tableType:VIRTUAL_VIEW)		 
    778. 

  778. PREHOOK: query: DESCRIBE FORMATTED view9
    779. 

  779. PREHOOK: type: DESCTABLE
    780. 

  780. POSTHOOK: query: DESCRIBE FORMATTED view9
    781. 

  781. POSTHOOK: type: DESCTABLE
    782. 

  782. POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    783. 

  783. # col_name            	data_type           	comment             
    784. 

  784. 	 	 
    785. 

  785. m                   	int                 	None                
    786. 

  786. 	 	 
    787. 

  787. # Detailed Table Information	 	 
    788. 

  788. Database:           	default             	 
    789. 

  789. Owner:              	jsichi              	 
    790. 

  790. CreateTime:         	Tue Apr 26 16:17:45 PDT 2011	 
    791. 

  791. LastAccessTime:     	UNKNOWN             	 
    792. 

  792. Protect Mode:       	None                	 
    793. 

  793. Retention:          	0                   	 
    794. 

  794. Table Type:         	VIRTUAL_VIEW        	 
    795. 

  795. Table Parameters:	 	 
    796. 

  796. 	transient_lastDdlTime	1303859865          
    797. 

  797. 	 	 
    798. 

  798. # Storage Information	 	 
    799. 

  799. SerDe Library:      	null                	 
    800. 

  800. InputFormat:        	org.apache.hadoop.mapred.SequenceFileInputFormat	 
    801. 

  801. OutputFormat:       	org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat	 
    802. 

  802. Compressed:         	No                  	 
    803. 

  803. Num Buckets:        	-1                  	 
    804. 

  804. Bucket Columns:     	[]                  	 
    805. 

  805. Sort Columns:       	[]                  	 
    806. 

  806. 	 	 
    807. 

  807. # View Information	 	 
    808. 

  808. View Original Text: 	SELECT test_max(length(value))	 
    809. 

  809. FROM src	 	 
    810. 

  810. View Expanded Text: 	SELECT `_c0` AS `m` FROM (SELECT `test_max`(length(`src`.`value`))	 
    811. 

  811. FROM `src`) `view9`	 	 
    812. 

  812. PREHOOK: query: SELECT * FROM view9
    813. 

  813. PREHOOK: type: QUERY
    814. 

  814. PREHOOK: Input: default@src
    815. 

  815. PREHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-04-26_16-17-46_023_7400703264002927310/-mr-10000
    816. 

  816. POSTHOOK: query: SELECT * FROM view9
    817. 

  817. POSTHOOK: type: QUERY
    818. 

  818. POSTHOOK: Input: default@src
    819. 

  819. POSTHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-04-26_16-17-46_023_7400703264002927310/-mr-10000
    820. 

  820. POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    821. 

  821. 7
    822. 

  822. PREHOOK: query: -- test usage of a subselect within a view
    823. 

  823. CREATE VIEW view10 AS
    824. 

  824. SELECT slurp.* FROM (SELECT * FROM src WHERE key=86) slurp
    825. 

  825. PREHOOK: type: CREATEVIEW
    826. 

  826. PREHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-04-26_16-17-53_993_5675089404876855300/-mr-10000
    827. 

  827. POSTHOOK: query: -- test usage of a subselect within a view
    828. 

  828. CREATE VIEW view10 AS
    829. 

  829. SELECT slurp.* FROM (SELECT * FROM src WHERE key=86) slurp
    830. 

  830. POSTHOOK: type: CREATEVIEW
    831. 

  831. POSTHOOK: Output: default@view10
    832. 

  832. POSTHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-04-26_16-17-53_993_5675089404876855300/-mr-10000
    833. 

  833. POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    834. 

  834. PREHOOK: query: DESCRIBE EXTENDED view10
    835. 

  835. PREHOOK: type: DESCTABLE
    836. 

  836. POSTHOOK: query: DESCRIBE EXTENDED view10
    837. 

  837. POSTHOOK: type: DESCTABLE
    838. 

  838. POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    839. 

  839. key	string	
    840. 

  840. value	string	
    841. 

  841. 	 	 
    842. 

  842. Detailed 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)	
    843. 

  843. PREHOOK: query: DESCRIBE FORMATTED view10
    844. 

  844. PREHOOK: type: DESCTABLE
    845. 

  845. POSTHOOK: query: DESCRIBE FORMATTED view10
    846. 

  846. POSTHOOK: type: DESCTABLE
    847. 

  847. POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    848. 

  848. # col_name            	data_type           	comment             
    849. 

  849. 	 	 
    850. 

  850. key                 	string              	None                
    851. 

  851. value               	string              	None                
    852. 

  852. 	 	 
    853. 

  853. # Detailed Table Information	 	 
    854. 

  854. Database:           	default             	 
    855. 

  855. Owner:              	jsichi              	 
    856. 

  856. CreateTime:         	Tue Apr 26 16:17:54 PDT 2011	 
    857. 

  857. LastAccessTime:     	UNKNOWN             	 
    858. 

  858. Protect Mode:       	None                	 
    859. 

  859. Retention:          	0                   	 
    860. 

  860. Table Type:         	VIRTUAL_VIEW        	 
    861. 

  861. Table Parameters:	 	 
    862. 

  862. 	transient_lastDdlTime	1303859874          
    863. 

  863. 	 	 
    864. 

  864. # Storage Information	 	 
    865. 

  865. SerDe Library:      	null                	 
    866. 

  866. InputFormat:        	org.apache.hadoop.mapred.SequenceFileInputFormat	 
    867. 

  867. OutputFormat:       	org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat	 
    868. 

  868. Compressed:         	No                  	 
    869. 

  869. Num Buckets:        	-1                  	 
    870. 

  870. Bucket Columns:     	[]                  	 
    871. 

  871. Sort Columns:       	[]                  	 
    872. 

  872. 	 	 
    873. 

  873. # View Information	 	 
    874. 

  874. View Original Text: 	SELECT slurp.* FROM (SELECT * FROM src WHERE key=86) slurp	 
    875. 

  875. View Expanded Text: 	SELECT `slurp`.`key`, `slurp`.`value` FROM (SELECT `src`.`key`, `src`.`value` FROM `src` WHERE `src`.`key`=86) `slurp`	 
    876. 

  876. PREHOOK: query: SELECT * FROM view10
    877. 

  877. PREHOOK: type: QUERY
    878. 

  878. PREHOOK: Input: default@src
    879. 

  879. PREHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-04-26_16-17-54_194_1974090628625957857/-mr-10000
    880. 

  880. POSTHOOK: query: SELECT * FROM view10
    881. 

  881. POSTHOOK: type: QUERY
    882. 

  882. POSTHOOK: Input: default@src
    883. 

  883. POSTHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-04-26_16-17-54_194_1974090628625957857/-mr-10000
    884. 

  884. POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    885. 

  885. 86	val_86
    886. 

  886. PREHOOK: query: -- test usage of a UDTF within a view
    887. 

  887. CREATE TEMPORARY FUNCTION test_explode AS
    888. 

  888. 'org.apache.hadoop.hive.ql.udf.generic.GenericUDTFExplode'
    889. 

  889. PREHOOK: type: CREATEFUNCTION
    890. 

  890. POSTHOOK: query: -- test usage of a UDTF within a view
    891. 

  891. CREATE TEMPORARY FUNCTION test_explode AS
    892. 

  892. 'org.apache.hadoop.hive.ql.udf.generic.GenericUDTFExplode'
    893. 

  893. POSTHOOK: type: CREATEFUNCTION
    894. 

  894. POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    895. 

  895. PREHOOK: query: CREATE VIEW view11 AS
    896. 

  896. SELECT test_explode(array(1,2,3)) AS (boom)
    897. 

  897. FROM table1
    898. 

  898. PREHOOK: type: CREATEVIEW
    899. 

  899. PREHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-04-26_16-17-59_492_3133189980222184516/-mr-10000
    900. 

  900. POSTHOOK: query: CREATE VIEW view11 AS
    901. 

  901. SELECT test_explode(array(1,2,3)) AS (boom)
    902. 

  902. FROM table1
    903. 

  903. POSTHOOK: type: CREATEVIEW
    904. 

  904. POSTHOOK: Output: default@view11
    905. 

  905. POSTHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-04-26_16-17-59_492_3133189980222184516/-mr-10000
    906. 

  906. POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    907. 

  907. PREHOOK: query: DESCRIBE EXTENDED view11
    908. 

  908. PREHOOK: type: DESCTABLE
    909. 

  909. POSTHOOK: query: DESCRIBE EXTENDED view11
    910. 

  910. POSTHOOK: type: DESCTABLE
    911. 

  911. POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    912. 

  912. boom	int	
    913. 

  913. 	 	 
    914. 

  914. Detailed 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)	 
    915. 

  915. FROM table1, viewExpandedText:SELECT `test_explode`(array(1,2,3)) AS (`boom`)	 	 
    916. 

  916. FROM `table1`, tableType:VIRTUAL_VIEW)		 
    917. 

  917. PREHOOK: query: DESCRIBE FORMATTED view11
    918. 

  918. PREHOOK: type: DESCTABLE
    919. 

  919. POSTHOOK: query: DESCRIBE FORMATTED view11
    920. 

  920. POSTHOOK: type: DESCTABLE
    921. 

  921. POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    922. 

  922. # col_name            	data_type           	comment             
    923. 

  923. 	 	 
    924. 

  924. boom                	int                 	None                
    925. 

  925. 	 	 
    926. 

  926. # Detailed Table Information	 	 
    927. 

  927. Database:           	default             	 
    928. 

  928. Owner:              	jsichi              	 
    929. 

  929. CreateTime:         	Tue Apr 26 16:17:59 PDT 2011	 
    930. 

  930. LastAccessTime:     	UNKNOWN             	 
    931. 

  931. Protect Mode:       	None                	 
    932. 

  932. Retention:          	0                   	 
    933. 

  933. Table Type:         	VIRTUAL_VIEW        	 
    934. 

  934. Table Parameters:	 	 
    935. 

  935. 	transient_lastDdlTime	1303859879          
    936. 

  936. 	 	 
    937. 

  937. # Storage Information	 	 
    938. 

  938. SerDe Library:      	null                	 
    939. 

  939. InputFormat:        	org.apache.hadoop.mapred.SequenceFileInputFormat	 
    940. 

  940. OutputFormat:       	org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat	 
    941. 

  941. Compressed:         	No                  	 
    942. 

  942. Num Buckets:        	-1                  	 
    943. 

  943. Bucket Columns:     	[]                  	 
    944. 

  944. Sort Columns:       	[]                  	 
    945. 

  945. 	 	 
    946. 

  946. # View Information	 	 
    947. 

  947. View Original Text: 	SELECT test_explode(array(1,2,3)) AS (boom)	 
    948. 

  948. FROM table1	 	 
    949. 

  949. View Expanded Text: 	SELECT `test_explode`(array(1,2,3)) AS (`boom`)	 
    950. 

  950. FROM `table1`	 	 
    951. 

  951. PREHOOK: query: SELECT * FROM view11
    952. 

  952. PREHOOK: type: QUERY
    953. 

  953. PREHOOK: Input: default@table1
    954. 

  954. PREHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-04-26_16-17-59_691_3771989062499335212/-mr-10000
    955. 

  955. POSTHOOK: query: SELECT * FROM view11
    956. 

  956. POSTHOOK: type: QUERY
    957. 

  957. POSTHOOK: Input: default@table1
    958. 

  958. POSTHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-04-26_16-17-59_691_3771989062499335212/-mr-10000
    959. 

  959. POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    960. 

  960. 1
    961. 

  961. 2
    962. 

  962. 3
    963. 

  963. PREHOOK: query: -- test usage of LATERAL within a view
    964. 

  964. CREATE VIEW view12 AS
    965. 

  965. SELECT * FROM src LATERAL VIEW explode(array(1,2,3)) myTable AS myCol
    966. 

  966. PREHOOK: type: CREATEVIEW
    967. 

  967. PREHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-04-26_16-18-06_109_548391492775178085/-mr-10000
    968. 

  968. POSTHOOK: query: -- test usage of LATERAL within a view
    969. 

  969. CREATE VIEW view12 AS
    970. 

  970. SELECT * FROM src LATERAL VIEW explode(array(1,2,3)) myTable AS myCol
    971. 

  971. POSTHOOK: type: CREATEVIEW
    972. 

  972. POSTHOOK: Output: default@view12
    973. 

  973. POSTHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-04-26_16-18-06_109_548391492775178085/-mr-10000
    974. 

  974. POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    975. 

  975. PREHOOK: query: DESCRIBE EXTENDED view12
    976. 

  976. PREHOOK: type: DESCTABLE
    977. 

  977. POSTHOOK: query: DESCRIBE EXTENDED view12
    978. 

  978. POSTHOOK: type: DESCTABLE
    979. 

  979. POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    980. 

  980. key	string	
    981. 

  981. value	string	
    982. 

  982. mycol	int	
    983. 

  983. 	 	 
    984. 

  984. Detailed Table Information	Table(tableName:view12, dbName:default, owner:jsichi, createTime:1303859886, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:string, comment:null), FieldSchema(name:value, type:string, comment:null), FieldSchema(name:mycol, 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=1303859886}, viewOriginalText:SELECT * FROM src LATERAL VIEW explode(array(1,2,3)) myTable AS myCol, viewExpandedText:SELECT `src`.`key`, `src`.`value`, `mytable`.`mycol` FROM `src` LATERAL VIEW explode(array(1,2,3)) `myTable` AS `myCol`, tableType:VIRTUAL_VIEW)	
    985. 

  985. PREHOOK: query: DESCRIBE FORMATTED view12
    986. 

  986. PREHOOK: type: DESCTABLE
    987. 

  987. POSTHOOK: query: DESCRIBE FORMATTED view12
    988. 

  988. POSTHOOK: type: DESCTABLE
    989. 

  989. POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    990. 

  990. # col_name            	data_type           	comment             
    991. 

  991. 	 	 
    992. 

  992. key                 	string              	None                
    993. 

  993. value               	string              	None                
    994. 

  994. mycol               	int                 	None                
    995. 

  995. 	 	 
    996. 

  996. # Detailed Table Information	 	 
    997. 

  997. Database:           	default             	 
    998. 

  998. Owner:              	jsichi              	 
    999. 

  999. CreateTime:         	Tue Apr 26 16:18:06 PDT 2011	 
    1000. 

  1000. LastAccessTime:     	UNKNOWN             	 
    1001. 

  1001. Protect Mode:       	None                	 
    1002. 

  1002. Retention:          	0                   	 
    1003. 

  1003. Table Type:         	VIRTUAL_VIEW        	 
    1004. 

  1004. Table Parameters:	 	 
    1005. 

  1005. 	transient_lastDdlTime	1303859886          
    1006. 

  1006. 	 	 
    1007. 

  1007. # Storage Information	 	 
    1008. 

  1008. SerDe Library:      	null                	 
    1009. 

  1009. InputFormat:        	org.apache.hadoop.mapred.SequenceFileInputFormat	 
    1010. 

  1010. OutputFormat:       	org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat	 
    1011. 

  1011. Compressed:         	No                  	 
    1012. 

  1012. Num Buckets:        	-1                  	 
    1013. 

  1013. Bucket Columns:     	[]                  	 
    1014. 

  1014. Sort Columns:       	[]                  	 
    1015. 

  1015. 	 	 
    1016. 

  1016. # View Information	 	 
    1017. 

  1017. View Original Text: 	SELECT * FROM src LATERAL VIEW explode(array(1,2,3)) myTable AS myCol	 
    1018. 

  1018. View Expanded Text: 	SELECT `src`.`key`, `src`.`value`, `mytable`.`mycol` FROM `src` LATERAL VIEW explode(array(1,2,3)) `myTable` AS `myCol`	 
    1019. 

  1019. PREHOOK: query: SELECT * FROM view12
    1020. 

  1020. ORDER BY key ASC, myCol ASC LIMIT 1
    1021. 

  1021. PREHOOK: type: QUERY
    1022. 

  1022. PREHOOK: Input: default@src
    1023. 

  1023. PREHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-04-26_16-18-06_310_5500742342561403707/-mr-10000
    1024. 

  1024. POSTHOOK: query: SELECT * FROM view12
    1025. 

  1025. ORDER BY key ASC, myCol ASC LIMIT 1
    1026. 

  1026. POSTHOOK: type: QUERY
    1027. 

  1027. POSTHOOK: Input: default@src
    1028. 

  1028. POSTHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-04-26_16-18-06_310_5500742342561403707/-mr-10000
    1029. 

  1029. POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    1030. 

  1030. 0	val_0	1
    1031. 

  1031. PREHOOK: query: -- test usage of LATERAL with a view as the LHS
    1032. 

  1032. SELECT * FROM view2 LATERAL VIEW explode(array(1,2,3)) myTable AS myCol
    1033. 

  1033. ORDER BY key ASC, myCol ASC LIMIT 1
    1034. 

  1034. PREHOOK: type: QUERY
    1035. 

  1035. PREHOOK: Input: default@src
    1036. 

  1036. PREHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-04-26_16-18-13_420_6475556823361950057/-mr-10000
    1037. 

  1037. POSTHOOK: query: -- test usage of LATERAL with a view as the LHS
    1038. 

  1038. SELECT * FROM view2 LATERAL VIEW explode(array(1,2,3)) myTable AS myCol
    1039. 

  1039. ORDER BY key ASC, myCol ASC LIMIT 1
    1040. 

  1040. POSTHOOK: type: QUERY
    1041. 

  1041. POSTHOOK: Input: default@src
    1042. 

  1042. POSTHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-04-26_16-18-13_420_6475556823361950057/-mr-10000
    1043. 

  1043. POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    1044. 

  1044. 0	val_0	1
    1045. 

  1045. PREHOOK: query: -- test usage of TABLESAMPLE within a view
    1046. 

  1046. CREATE VIEW view13 AS
    1047. 

  1047. SELECT s.key
    1048. 

  1048. FROM srcbucket TABLESAMPLE (BUCKET 1 OUT OF 5 ON key) s
    1049. 

  1049. PREHOOK: type: CREATEVIEW
    1050. 

  1050. PREHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-04-26_16-18-22_358_5917280716174612087/-mr-10000
    1051. 

  1051. POSTHOOK: query: -- test usage of TABLESAMPLE within a view
    1052. 

  1052. CREATE VIEW view13 AS
    1053. 

  1053. SELECT s.key
    1054. 

  1054. FROM srcbucket TABLESAMPLE (BUCKET 1 OUT OF 5 ON key) s
    1055. 

  1055. POSTHOOK: type: CREATEVIEW
    1056. 

  1056. POSTHOOK: Output: default@view13
    1057. 

  1057. POSTHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-04-26_16-18-22_358_5917280716174612087/-mr-10000
    1058. 

  1058. POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    1059. 

  1059. PREHOOK: query: DESCRIBE EXTENDED view13
    1060. 

  1060. PREHOOK: type: DESCTABLE
    1061. 

  1061. POSTHOOK: query: DESCRIBE EXTENDED view13
    1062. 

  1062. POSTHOOK: type: DESCTABLE
    1063. 

  1063. POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    1064. 

  1064. key	int	
    1065. 

  1065. 	 	 
    1066. 

  1066. Detailed Table Information	Table(tableName:view13, dbName:default, owner:jsichi, createTime:1303859902, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, 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=1303859902}, viewOriginalText:SELECT s.key	 
    1067. 

  1067. FROM srcbucket TABLESAMPLE (BUCKET 1 OUT OF 5 ON key) s, viewExpandedText:SELECT `s`.`key`	 	 
    1068. 

  1068. FROM `srcbucket` TABLESAMPLE (BUCKET 1 OUT OF 5 ON `key`) `s`, tableType:VIRTUAL_VIEW)		 
    1069. 

  1069. PREHOOK: query: DESCRIBE FORMATTED view13
    1070. 

  1070. PREHOOK: type: DESCTABLE
    1071. 

  1071. POSTHOOK: query: DESCRIBE FORMATTED view13
    1072. 

  1072. POSTHOOK: type: DESCTABLE
    1073. 

  1073. POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    1074. 

  1074. # col_name            	data_type           	comment             
    1075. 

  1075. 	 	 
    1076. 

  1076. key                 	int                 	None                
    1077. 

  1077. 	 	 
    1078. 

  1078. # Detailed Table Information	 	 
    1079. 

  1079. Database:           	default             	 
    1080. 

  1080. Owner:              	jsichi              	 
    1081. 

  1081. CreateTime:         	Tue Apr 26 16:18:22 PDT 2011	 
    1082. 

  1082. LastAccessTime:     	UNKNOWN             	 
    1083. 

  1083. Protect Mode:       	None                	 
    1084. 

  1084. Retention:          	0                   	 
    1085. 

  1085. Table Type:         	VIRTUAL_VIEW        	 
    1086. 

  1086. Table Parameters:	 	 
    1087. 

  1087. 	transient_lastDdlTime	1303859902          
    1088. 

  1088. 	 	 
    1089. 

  1089. # Storage Information	 	 
    1090. 

  1090. SerDe Library:      	null                	 
    1091. 

  1091. InputFormat:        	org.apache.hadoop.mapred.SequenceFileInputFormat	 
    1092. 

  1092. OutputFormat:       	org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat	 
    1093. 

  1093. Compressed:         	No                  	 
    1094. 

  1094. Num Buckets:        	-1                  	 
    1095. 

  1095. Bucket Columns:     	[]                  	 
    1096. 

  1096. Sort Columns:       	[]                  	 
    1097. 

  1097. 	 	 
    1098. 

  1098. # View Information	 	 
    1099. 

  1099. View Original Text: 	SELECT s.key	 
    1100. 

  1100. FROM srcbucket TABLESAMPLE (BUCKET 1 OUT OF 5 ON key) s	 	 
    1101. 

  1101. View Expanded Text: 	SELECT `s`.`key`	 
    1102. 

  1102. FROM `srcbucket` TABLESAMPLE (BUCKET 1 OUT OF 5 ON `key`) `s`	 	 
    1103. 

  1103. PREHOOK: query: SELECT * FROM view13
    1104. 

  1104. ORDER BY key LIMIT 12
    1105. 

  1105. PREHOOK: type: QUERY
    1106. 

  1106. PREHOOK: Input: default@srcbucket
    1107. 

  1107. PREHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-04-26_16-18-22_585_440904445744239811/-mr-10000
    1108. 

  1108. POSTHOOK: query: SELECT * FROM view13
    1109. 

  1109. ORDER BY key LIMIT 12
    1110. 

  1110. POSTHOOK: type: QUERY
    1111. 

  1111. POSTHOOK: Input: default@srcbucket
    1112. 

  1112. POSTHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-04-26_16-18-22_585_440904445744239811/-mr-10000
    1113. 

  1113. POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    1114. 

  1114. 0
    1115. 

  1115. 0
    1116. 

  1116. 0
    1117. 

  1117. 0
    1118. 

  1118. 0
    1119. 

  1119. 5
    1120. 

  1120. 5
    1121. 

  1121. 5
    1122. 

  1122. 5
    1123. 

  1123. 10
    1124. 

  1124. 10
    1125. 

  1125. 15
    1126. 

  1126. PREHOOK: query: -- test usage of JOIN+UNION+AGG all within same view
    1127. 

  1127. CREATE VIEW view14 AS
    1128. 

  1128. SELECT unionsrc1.key as k1, unionsrc1.value as v1,
    1129. 

  1129.        unionsrc2.key as k2, unionsrc2.value as v2
    1130. 

  1130. FROM (select 'tst1' as key, cast(count(1) as string) as value from src s1
    1131. 

  1131.                          UNION  ALL
    1132. 

  1132.       select s2.key as key, s2.value as value from src s2 where s2.key < 10) unionsrc1
    1133. 

  1133. JOIN
    1134. 

  1134.      (select 'tst1' as key, cast(count(1) as string) as value from src s3
    1135. 

  1135.                          UNION  ALL
    1136. 

  1136.       select s4.key as key, s4.value as value from src s4 where s4.key < 10) unionsrc2
    1137. 

  1137. ON (unionsrc1.key = unionsrc2.key)
    1138. 

  1138. PREHOOK: type: CREATEVIEW
    1139. 

  1139. PREHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-04-26_16-18-30_587_4457344289831150429/-mr-10000
    1140. 

  1140. POSTHOOK: query: -- test usage of JOIN+UNION+AGG all within same view
    1141. 

  1141. CREATE VIEW view14 AS
    1142. 

  1142. SELECT unionsrc1.key as k1, unionsrc1.value as v1,
    1143. 

  1143.        unionsrc2.key as k2, unionsrc2.value as v2
    1144. 

  1144. FROM (select 'tst1' as key, cast(count(1) as string) as value from src s1
    1145. 

  1145.                          UNION  ALL
    1146. 

  1146.       select s2.key as key, s2.value as value from src s2 where s2.key < 10) unionsrc1
    1147. 

  1147. JOIN
    1148. 

  1148.      (select 'tst1' as key, cast(count(1) as string) as value from src s3
    1149. 

  1149.                          UNION  ALL
    1150. 

  1150.       select s4.key as key, s4.value as value from src s4 where s4.key < 10) unionsrc2
    1151. 

  1151. ON (unionsrc1.key = unionsrc2.key)
    1152. 

  1152. POSTHOOK: type: CREATEVIEW
    1153. 

  1153. POSTHOOK: Output: default@view14
    1154. 

  1154. POSTHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-04-26_16-18-30_587_4457344289831150429/-mr-10000
    1155. 

  1155. POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    1156. 

  1156. PREHOOK: query: DESCRIBE EXTENDED view14
    1157. 

  1157. PREHOOK: type: DESCTABLE
    1158. 

  1158. POSTHOOK: query: DESCRIBE EXTENDED view14
    1159. 

  1159. POSTHOOK: type: DESCTABLE
    1160. 

  1160. POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    1161. 

  1161. k1	string	
    1162. 

  1162. v1	string	
    1163. 

  1163. k2	string	
    1164. 

  1164. v2	string	
    1165. 

  1165. 	 	 
    1166. 

  1166. Detailed Table Information	Table(tableName:view14, dbName:default, owner:jsichi, createTime:1303859910, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:k1, type:string, comment:null), FieldSchema(name:v1, type:string, comment:null), FieldSchema(name:k2, type:string, comment:null), FieldSchema(name:v2, 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=1303859910}, viewOriginalText:SELECT unionsrc1.key as k1, unionsrc1.value as v1,	 
    1167. 

  1167.        unionsrc2.key as k2, unionsrc2.value as v2	 	 
    1168. 

  1168. FROM (select 'tst1' as key, cast(count(1) as string) as value from src s1	 	 
    1169. 

  1169.                          UNION  ALL	 	 
    1170. 

  1170.       select s2.key as key, s2.value as value from src s2 where s2.key < 10) unionsrc1	 	 
    1171. 

  1171. JOIN	 	 
    1172. 

  1172.      (select 'tst1' as key, cast(count(1) as string) as value from src s3	 	 
    1173. 

  1173.                          UNION  ALL	 	 
    1174. 

  1174.       select s4.key as key, s4.value as value from src s4 where s4.key < 10) unionsrc2	 	 
    1175. 

  1175. ON (unionsrc1.key = unionsrc2.key), viewExpandedText:SELECT `unionsrc1`.`key` as `k1`, `unionsrc1`.`value` as `v1`,	 	 
    1176. 

  1176.        `unionsrc2`.`key` as `k2`, `unionsrc2`.`value` as `v2`	 	 
    1177. 

  1177. FROM (select 'tst1' as `key`, cast(count(1) as string) as `value` from `src` `s1`	 	 
    1178. 

  1178.                          UNION  ALL	 	 
    1179. 

  1179.       select `s2`.`key` as `key`, `s2`.`value` as `value` from `src` `s2` where `s2`.`key` < 10) `unionsrc1`	 	 
    1180. 

  1180. JOIN	 	 
    1181. 

  1181.      (select 'tst1' as `key`, cast(count(1) as string) as `value` from `src` `s3`	 	 
    1182. 

  1182.                          UNION  ALL	 	 
    1183. 

  1183.       select `s4`.`key` as `key`, `s4`.`value` as `value` from `src` `s4` where `s4`.`key` < 10) `unionsrc2`	 	 
    1184. 

  1184. ON (`unionsrc1`.`key` = `unionsrc2`.`key`), tableType:VIRTUAL_VIEW)		 
    1185. 

  1185. PREHOOK: query: DESCRIBE FORMATTED view14
    1186. 

  1186. PREHOOK: type: DESCTABLE
    1187. 

  1187. POSTHOOK: query: DESCRIBE FORMATTED view14
    1188. 

  1188. POSTHOOK: type: DESCTABLE
    1189. 

  1189. POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    1190. 

  1190. # col_name            	data_type           	comment             
    1191. 

  1191. 	 	 
    1192. 

  1192. k1                  	string              	None                
    1193. 

  1193. v1                  	string              	None                
    1194. 

  1194. k2                  	string              	None                
    1195. 

  1195. v2                  	string              	None                
    1196. 

  1196. 	 	 
    1197. 

  1197. # Detailed Table Information	 	 
    1198. 

  1198. Database:           	default             	 
    1199. 

  1199. Owner:              	jsichi              	 
    1200. 

  1200. CreateTime:         	Tue Apr 26 16:18:30 PDT 2011	 
    1201. 

  1201. LastAccessTime:     	UNKNOWN             	 
    1202. 

  1202. Protect Mode:       	None                	 
    1203. 

  1203. Retention:          	0                   	 
    1204. 

  1204. Table Type:         	VIRTUAL_VIEW        	 
    1205. 

  1205. Table Parameters:	 	 
    1206. 

  1206. 	transient_lastDdlTime	1303859910          
    1207. 

  1207. 	 	 
    1208. 

  1208. # Storage Information	 	 
    1209. 

  1209. SerDe Library:      	null                	 
    1210. 

  1210. InputFormat:        	org.apache.hadoop.mapred.SequenceFileInputFormat	 
    1211. 

  1211. OutputFormat:       	org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat	 
    1212. 

  1212. Compressed:         	No                  	 
    1213. 

  1213. Num Buckets:        	-1                  	 
    1214. 

  1214. Bucket Columns:     	[]                  	 
    1215. 

  1215. Sort Columns:       	[]                  	 
    1216. 

  1216. 	 	 
    1217. 

  1217. # View Information	 	 
    1218. 

  1218. View Original Text: 	SELECT unionsrc1.key as k1, unionsrc1.value as v1,	 
    1219. 

  1219.        unionsrc2.key as k2, unionsrc2.value as v2	 	 
    1220. 

  1220. FROM (select 'tst1' as key, cast(count(1) as string) as value from src s1	 	 
    1221. 

  1221.                          UNION  ALL	 	 
    1222. 

  1222.       select s2.key as key, s2.value as value from src s2 where s2.key < 10) unionsrc1	 	 
    1223. 

  1223. JOIN	 	 
    1224. 

  1224.      (select 'tst1' as key, cast(count(1) as string) as value from src s3	 	 
    1225. 

  1225.                          UNION  ALL	 	 
    1226. 

  1226.       select s4.key as key, s4.value as value from src s4 where s4.key < 10) unionsrc2	 	 
    1227. 

  1227. ON (unionsrc1.key = unionsrc2.key)	 	 
    1228. 

  1228. View Expanded Text: 	SELECT `unionsrc1`.`key` as `k1`, `unionsrc1`.`value` as `v1`,	 
    1229. 

  1229.        `unionsrc2`.`key` as `k2`, `unionsrc2`.`value` as `v2`	 	 
    1230. 

  1230. FROM (select 'tst1' as `key`, cast(count(1) as string) as `value` from `src` `s1`	 	 
    1231. 

  1231.                          UNION  ALL	 	 
    1232. 

  1232.       select `s2`.`key` as `key`, `s2`.`value` as `value` from `src` `s2` where `s2`.`key` < 10) `unionsrc1`	 	 
    1233. 

  1233. JOIN	 	 
    1234. 

  1234.      (select 'tst1' as `key`, cast(count(1) as string) as `value` from `src` `s3`	 	 
    1235. 

  1235.                          UNION  ALL	 	 
    1236. 

  1236.       select `s4`.`key` as `key`, `s4`.`value` as `value` from `src` `s4` where `s4`.`key` < 10) `unionsrc2`	 	 
    1237. 

  1237. ON (`unionsrc1`.`key` = `unionsrc2`.`key`)	 	 
    1238. 

  1238. PREHOOK: query: SELECT * FROM view14
    1239. 

  1239. ORDER BY k1
    1240. 

  1240. PREHOOK: type: QUERY
    1241. 

  1241. PREHOOK: Input: default@src
    1242. 

  1242. PREHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-04-26_16-18-30_846_7907769103886828508/-mr-10000
    1243. 

  1243. POSTHOOK: query: SELECT * FROM view14
    1244. 

  1244. ORDER BY k1
    1245. 

  1245. POSTHOOK: type: QUERY
    1246. 

  1246. POSTHOOK: Input: default@src
    1247. 

  1247. POSTHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-04-26_16-18-30_846_7907769103886828508/-mr-10000
    1248. 

  1248. POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    1249. 

  1249. 0	val_0	0	val_0
    1250. 

  1250. 0	val_0	0	val_0
    1251. 

  1251. 0	val_0	0	val_0
    1252. 

  1252. 0	val_0	0	val_0
    1253. 

  1253. 0	val_0	0	val_0
    1254. 

  1254. 0	val_0	0	val_0
    1255. 

  1255. 0	val_0	0	val_0
    1256. 

  1256. 0	val_0	0	val_0
    1257. 

  1257. 0	val_0	0	val_0
    1258. 

  1258. 2	val_2	2	val_2
    1259. 

  1259. 4	val_4	4	val_4
    1260. 

  1260. 5	val_5	5	val_5
    1261. 

  1261. 5	val_5	5	val_5
    1262. 

  1262. 5	val_5	5	val_5
    1263. 

  1263. 5	val_5	5	val_5
    1264. 

  1264. 5	val_5	5	val_5
    1265. 

  1265. 5	val_5	5	val_5
    1266. 

  1266. 5	val_5	5	val_5
    1267. 

  1267. 5	val_5	5	val_5
    1268. 

  1268. 5	val_5	5	val_5
    1269. 

  1269. 8	val_8	8	val_8
    1270. 

  1270. 9	val_9	9	val_9
    1271. 

  1271. tst1	500	tst1	500
    1272. 

  1272. PREHOOK: query: -- test usage of GROUP BY within view
    1273. 

  1273. CREATE VIEW view15 AS
    1274. 

  1274. SELECT key,COUNT(value) AS value_count
    1275. 

  1275. FROM src
    1276. 

  1276. GROUP BY key
    1277. 

  1277. PREHOOK: type: CREATEVIEW
    1278. 

  1278. PREHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-04-26_16-19-19_193_3801608063658494364/-mr-10000
    1279. 

  1279. POSTHOOK: query: -- test usage of GROUP BY within view
    1280. 

  1280. CREATE VIEW view15 AS
    1281. 

  1281. SELECT key,COUNT(value) AS value_count
    1282. 

  1282. FROM src
    1283. 

  1283. GROUP BY key
    1284. 

  1284. POSTHOOK: type: CREATEVIEW
    1285. 

  1285. POSTHOOK: Output: default@view15
    1286. 

  1286. POSTHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-04-26_16-19-19_193_3801608063658494364/-mr-10000
    1287. 

  1287. POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    1288. 

  1288. PREHOOK: query: DESCRIBE EXTENDED view15
    1289. 

  1289. PREHOOK: type: DESCTABLE
    1290. 

  1290. POSTHOOK: query: DESCRIBE EXTENDED view15
    1291. 

  1291. POSTHOOK: type: DESCTABLE
    1292. 

  1292. POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    1293. 

  1293. key	string	
    1294. 

  1294. value_count	bigint	
    1295. 

  1295. 	 	 
    1296. 

  1296. Detailed Table Information	Table(tableName:view15, dbName:default, owner:jsichi, createTime:1303859959, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:string, comment:null), FieldSchema(name:value_count, type:bigint, 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=1303859959}, viewOriginalText:SELECT key,COUNT(value) AS value_count	 
    1297. 

  1297. FROM src	 	 
    1298. 

  1298. GROUP BY key, viewExpandedText:SELECT `src`.`key`,COUNT(`src`.`value`) AS `value_count`	 	 
    1299. 

  1299. FROM `src`	 	 
    1300. 

  1300. GROUP BY `src`.`key`, tableType:VIRTUAL_VIEW)		 
    1301. 

  1301. PREHOOK: query: DESCRIBE FORMATTED view15
    1302. 

  1302. PREHOOK: type: DESCTABLE
    1303. 

  1303. POSTHOOK: query: DESCRIBE FORMATTED view15
    1304. 

  1304. POSTHOOK: type: DESCTABLE
    1305. 

  1305. POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    1306. 

  1306. # col_name            	data_type           	comment             
    1307. 

  1307. 	 	 
    1308. 

  1308. key                 	string              	None                
    1309. 

  1309. value_count         	bigint              	None                
    1310. 

  1310. 	 	 
    1311. 

  1311. # Detailed Table Information	 	 
    1312. 

  1312. Database:           	default             	 
    1313. 

  1313. Owner:              	jsichi              	 
    1314. 

  1314. CreateTime:         	Tue Apr 26 16:19:19 PDT 2011	 
    1315. 

  1315. LastAccessTime:     	UNKNOWN             	 
    1316. 

  1316. Protect Mode:       	None                	 
    1317. 

  1317. Retention:          	0                   	 
    1318. 

  1318. Table Type:         	VIRTUAL_VIEW        	 
    1319. 

  1319. Table Parameters:	 	 
    1320. 

  1320. 	transient_lastDdlTime	1303859959          
    1321. 

  1321. 	 	 
    1322. 

  1322. # Storage Information	 	 
    1323. 

  1323. SerDe Library:      	null                	 
    1324. 

  1324. InputFormat:        	org.apache.hadoop.mapred.SequenceFileInputFormat	 
    1325. 

  1325. OutputFormat:       	org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat	 
    1326. 

  1326. Compressed:         	No                  	 
    1327. 

  1327. Num Buckets:        	-1                  	 
    1328. 

  1328. Bucket Columns:     	[]                  	 
    1329. 

  1329. Sort Columns:       	[]                  	 
    1330. 

  1330. 	 	 
    1331. 

  1331. # View Information	 	 
    1332. 

  1332. View Original Text: 	SELECT key,COUNT(value) AS value_count	 
    1333. 

  1333. FROM src	 	 
    1334. 

  1334. GROUP BY key	 	 
    1335. 

  1335. View Expanded Text: 	SELECT `src`.`key`,COUNT(`src`.`value`) AS `value_count`	 
    1336. 

  1336. FROM `src`	 	 
    1337. 

  1337. GROUP BY `src`.`key`	 	 
    1338. 

  1338. PREHOOK: query: SELECT * FROM view15
    1339. 

  1339. ORDER BY value_count DESC, key
    1340. 

  1340. LIMIT 10
    1341. 

  1341. PREHOOK: type: QUERY
    1342. 

  1342. PREHOOK: Input: default@src
    1343. 

  1343. PREHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-04-26_16-19-19_397_2376450087074757337/-mr-10000
    1344. 

  1344. POSTHOOK: query: SELECT * FROM view15
    1345. 

  1345. ORDER BY value_count DESC, key
    1346. 

  1346. LIMIT 10
    1347. 

  1347. POSTHOOK: type: QUERY
    1348. 

  1348. POSTHOOK: Input: default@src
    1349. 

  1349. POSTHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-04-26_16-19-19_397_2376450087074757337/-mr-10000
    1350. 

  1350. POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    1351. 

  1351. 230	5
    1352. 

  1352. 348	5
    1353. 

  1353. 401	5
    1354. 

  1354. 469	5
    1355. 

  1355. 138	4
    1356. 

  1356. 169	4
    1357. 

  1357. 277	4
    1358. 

  1358. 406	4
    1359. 

  1359. 468	4
    1360. 

  1360. 489	4
    1361. 

  1361. PREHOOK: query: -- test usage of DISTINCT within view
    1362. 

  1362. CREATE VIEW view16 AS
    1363. 

  1363. SELECT DISTINCT value
    1364. 

  1364. FROM src
    1365. 

  1365. PREHOOK: type: CREATEVIEW
    1366. 

  1366. PREHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-04-26_16-19-33_408_878408003919286313/-mr-10000
    1367. 

  1367. POSTHOOK: query: -- test usage of DISTINCT within view
    1368. 

  1368. CREATE VIEW view16 AS
    1369. 

  1369. SELECT DISTINCT value
    1370. 

  1370. FROM src
    1371. 

  1371. POSTHOOK: type: CREATEVIEW
    1372. 

  1372. POSTHOOK: Output: default@view16
    1373. 

  1373. POSTHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-04-26_16-19-33_408_878408003919286313/-mr-10000
    1374. 

  1374. POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    1375. 

  1375. PREHOOK: query: DESCRIBE EXTENDED view16
    1376. 

  1376. PREHOOK: type: DESCTABLE
    1377. 

  1377. POSTHOOK: query: DESCRIBE EXTENDED view16
    1378. 

  1378. POSTHOOK: type: DESCTABLE
    1379. 

  1379. POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    1380. 

  1380. value	string	
    1381. 

  1381. 	 	 
    1382. 

  1382. Detailed Table Information	Table(tableName:view16, dbName:default, owner:jsichi, createTime:1303859973, 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=1303859973}, viewOriginalText:SELECT DISTINCT value	 
    1383. 

  1383. FROM src, viewExpandedText:SELECT DISTINCT `src`.`value`	 	 
    1384. 

  1384. FROM `src`, tableType:VIRTUAL_VIEW)		 
    1385. 

  1385. PREHOOK: query: DESCRIBE FORMATTED view16
    1386. 

  1386. PREHOOK: type: DESCTABLE
    1387. 

  1387. POSTHOOK: query: DESCRIBE FORMATTED view16
    1388. 

  1388. POSTHOOK: type: DESCTABLE
    1389. 

  1389. POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    1390. 

  1390. # col_name            	data_type           	comment             
    1391. 

  1391. 	 	 
    1392. 

  1392. value               	string              	None                
    1393. 

  1393. 	 	 
    1394. 

  1394. # Detailed Table Information	 	 
    1395. 

  1395. Database:           	default             	 
    1396. 

  1396. Owner:              	jsichi              	 
    1397. 

  1397. CreateTime:         	Tue Apr 26 16:19:33 PDT 2011	 
    1398. 

  1398. LastAccessTime:     	UNKNOWN             	 
    1399. 

  1399. Protect Mode:       	None                	 
    1400. 

  1400. Retention:          	0                   	 
    1401. 

  1401. Table Type:         	VIRTUAL_VIEW        	 
    1402. 

  1402. Table Parameters:	 	 
    1403. 

  1403. 	transient_lastDdlTime	1303859973          
    1404. 

  1404. 	 	 
    1405. 

  1405. # Storage Information	 	 
    1406. 

  1406. SerDe Library:      	null                	 
    1407. 

  1407. InputFormat:        	org.apache.hadoop.mapred.SequenceFileInputFormat	 
    1408. 

  1408. OutputFormat:       	org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat	 
    1409. 

  1409. Compressed:         	No                  	 
    1410. 

  1410. Num Buckets:        	-1                  	 
    1411. 

  1411. Bucket Columns:     	[]                  	 
    1412. 

  1412. Sort Columns:       	[]                  	 
    1413. 

  1413. 	 	 
    1414. 

  1414. # View Information	 	 
    1415. 

  1415. View Original Text: 	SELECT DISTINCT value	 
    1416. 

  1416. FROM src	 	 
    1417. 

  1417. View Expanded Text: 	SELECT DISTINCT `src`.`value`	 
    1418. 

  1418. FROM `src`	 	 
    1419. 

  1419. PREHOOK: query: SELECT * FROM view16
    1420. 

  1420. ORDER BY value
    1421. 

  1421. LIMIT 10
    1422. 

  1422. PREHOOK: type: QUERY
    1423. 

  1423. PREHOOK: Input: default@src
    1424. 

  1424. PREHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-04-26_16-19-33_613_5811919160586296092/-mr-10000
    1425. 

  1425. POSTHOOK: query: SELECT * FROM view16
    1426. 

  1426. ORDER BY value
    1427. 

  1427. LIMIT 10
    1428. 

  1428. POSTHOOK: type: QUERY
    1429. 

  1429. POSTHOOK: Input: default@src
    1430. 

  1430. POSTHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-04-26_16-19-33_613_5811919160586296092/-mr-10000
    1431. 

  1431. POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    1432. 

  1432. val_0
    1433. 

  1433. val_10
    1434. 

  1434. val_100
    1435. 

  1435. val_103
    1436. 

  1436. val_104
    1437. 

  1437. val_105
    1438. 

  1438. val_11
    1439. 

  1439. val_111
    1440. 

  1440. val_113
    1441. 

  1441. val_114
    1442. 

  1442. PREHOOK: query: -- HIVE-2133:  DROP TABLE IF EXISTS should ignore a matching view name
    1443. 

  1443. DROP TABLE IF EXISTS view16
    1444. 

  1444. PREHOOK: type: DROPTABLE
    1445. 

  1445. PREHOOK: Input: default@view16
    1446. 

  1446. PREHOOK: Output: default@view16
    1447. 

  1447. POSTHOOK: query: -- HIVE-2133:  DROP TABLE IF EXISTS should ignore a matching view name
    1448. 

  1448. DROP TABLE IF EXISTS view16
    1449. 

  1449. POSTHOOK: type: DROPTABLE
    1450. 

  1450. POSTHOOK: Input: default@view16
    1451. 

  1451. POSTHOOK: Output: default@view16
    1452. 

  1452. POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    1453. 

  1453. PREHOOK: query: DESCRIBE view16
    1454. 

  1454. PREHOOK: type: DESCTABLE
    1455. 

  1455. POSTHOOK: query: DESCRIBE view16
    1456. 

  1456. POSTHOOK: type: DESCTABLE
    1457. 

  1457. POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    1458. 

  1458. value	string	
    1459. 

  1459. PREHOOK: query: -- Likewise, DROP VIEW IF EXISTS should ignore a matching table name
    1460. 

  1460. DROP VIEW IF EXISTS table1
    1461. 

  1461. PREHOOK: type: DROPVIEW
    1462. 

  1462. PREHOOK: Input: default@table1
    1463. 

  1463. PREHOOK: Output: default@table1
    1464. 

  1464. POSTHOOK: query: -- Likewise, DROP VIEW IF EXISTS should ignore a matching table name
    1465. 

  1465. DROP VIEW IF EXISTS table1
    1466. 

  1466. POSTHOOK: type: DROPVIEW
    1467. 

  1467. POSTHOOK: Input: default@table1
    1468. 

  1468. POSTHOOK: Output: default@table1
    1469. 

  1469. POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    1470. 

  1470. PREHOOK: query: DESCRIBE table1
    1471. 

  1471. PREHOOK: type: DESCTABLE
    1472. 

  1472. POSTHOOK: query: DESCRIBE table1
    1473. 

  1473. POSTHOOK: type: DESCTABLE
    1474. 

  1474. POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    1475. 

  1475. key	int	
    1476. 

  1476. value	string	
    1477. 

  1477. PREHOOK: query: -- this should work since currently we don't track view->table
    1478. 

  1478. -- dependencies for implementing RESTRICT
    1479. 

  1479. 

  1480. 

  1481. DROP VIEW view1
    1482. 

  1482. PREHOOK: type: DROPVIEW
    1483. 

  1483. PREHOOK: Input: default@view1
    1484. 

  1484. PREHOOK: Output: default@view1
    1485. 

  1485. POSTHOOK: query: -- this should work since currently we don't track view->table
    1486. 

  1486. -- dependencies for implementing RESTRICT
    1487. 

  1487. 

  1488. 

  1489. DROP VIEW view1
    1490. 

  1490. POSTHOOK: type: DROPVIEW
    1491. 

  1491. POSTHOOK: Input: default@view1
    1492. 

  1492. POSTHOOK: Output: default@view1
    1493. 

  1493. POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    1494. 

  1494. PREHOOK: query: DROP VIEW view2
    1495. 

  1495. PREHOOK: type: DROPVIEW
    1496. 

  1496. PREHOOK: Input: default@view2
    1497. 

  1497. PREHOOK: Output: default@view2
    1498. 

  1498. POSTHOOK: query: DROP VIEW view2
    1499. 

  1499. POSTHOOK: type: DROPVIEW
    1500. 

  1500. POSTHOOK: Input: default@view2
    1501. 

  1501. POSTHOOK: Output: default@view2
    1502. 

  1502. POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    1503. 

  1503. PREHOOK: query: DROP VIEW view3
    1504. 

  1504. PREHOOK: type: DROPVIEW
    1505. 

  1505. PREHOOK: Input: default@view3
    1506. 

  1506. PREHOOK: Output: default@view3
    1507. 

  1507. POSTHOOK: query: DROP VIEW view3
    1508. 

  1508. POSTHOOK: type: DROPVIEW
    1509. 

  1509. POSTHOOK: Input: default@view3
    1510. 

  1510. POSTHOOK: Output: default@view3
    1511. 

  1511. POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    1512. 

  1512. PREHOOK: query: DROP VIEW view4
    1513. 

  1513. PREHOOK: type: DROPVIEW
    1514. 

  1514. PREHOOK: Input: default@view4
    1515. 

  1515. PREHOOK: Output: default@view4
    1516. 

  1516. POSTHOOK: query: DROP VIEW view4
    1517. 

  1517. POSTHOOK: type: DROPVIEW
    1518. 

  1518. POSTHOOK: Input: default@view4
    1519. 

  1519. POSTHOOK: Output: default@view4
    1520. 

  1520. POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    1521. 

  1521. PREHOOK: query: DROP VIEW view5
    1522. 

  1522. PREHOOK: type: DROPVIEW
    1523. 

  1523. PREHOOK: Input: default@view5
    1524. 

  1524. PREHOOK: Output: default@view5
    1525. 

  1525. POSTHOOK: query: DROP VIEW view5
    1526. 

  1526. POSTHOOK: type: DROPVIEW
    1527. 

  1527. POSTHOOK: Input: default@view5
    1528. 

  1528. POSTHOOK: Output: default@view5
    1529. 

  1529. POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    1530. 

  1530. PREHOOK: query: DROP VIEW view6
    1531. 

  1531. PREHOOK: type: DROPVIEW
    1532. 

  1532. PREHOOK: Input: default@view6
    1533. 

  1533. PREHOOK: Output: default@view6
    1534. 

  1534. POSTHOOK: query: DROP VIEW view6
    1535. 

  1535. POSTHOOK: type: DROPVIEW
    1536. 

  1536. POSTHOOK: Input: default@view6
    1537. 

  1537. POSTHOOK: Output: default@view6
    1538. 

  1538. POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    1539. 

  1539. PREHOOK: query: DROP VIEW view7
    1540. 

  1540. PREHOOK: type: DROPVIEW
    1541. 

  1541. PREHOOK: Input: default@view7
    1542. 

  1542. PREHOOK: Output: default@view7
    1543. 

  1543. POSTHOOK: query: DROP VIEW view7
    1544. 

  1544. POSTHOOK: type: DROPVIEW
    1545. 

  1545. POSTHOOK: Input: default@view7
    1546. 

  1546. POSTHOOK: Output: default@view7
    1547. 

  1547. POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    1548. 

  1548. PREHOOK: query: DROP VIEW view8
    1549. 

  1549. PREHOOK: type: DROPVIEW
    1550. 

  1550. PREHOOK: Input: default@view8
    1551. 

  1551. PREHOOK: Output: default@view8
    1552. 

  1552. POSTHOOK: query: DROP VIEW view8
    1553. 

  1553. POSTHOOK: type: DROPVIEW
    1554. 

  1554. POSTHOOK: Input: default@view8
    1555. 

  1555. POSTHOOK: Output: default@view8
    1556. 

  1556. POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    1557. 

  1557. PREHOOK: query: DROP VIEW view9
    1558. 

  1558. PREHOOK: type: DROPVIEW
    1559. 

  1559. PREHOOK: Input: default@view9
    1560. 

  1560. PREHOOK: Output: default@view9
    1561. 

  1561. POSTHOOK: query: DROP VIEW view9
    1562. 

  1562. POSTHOOK: type: DROPVIEW
    1563. 

  1563. POSTHOOK: Input: default@view9
    1564. 

  1564. POSTHOOK: Output: default@view9
    1565. 

  1565. POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    1566. 

  1566. PREHOOK: query: DROP VIEW view10
    1567. 

  1567. PREHOOK: type: DROPVIEW
    1568. 

  1568. PREHOOK: Input: default@view10
    1569. 

  1569. PREHOOK: Output: default@view10
    1570. 

  1570. POSTHOOK: query: DROP VIEW view10
    1571. 

  1571. POSTHOOK: type: DROPVIEW
    1572. 

  1572. POSTHOOK: Input: default@view10
    1573. 

  1573. POSTHOOK: Output: default@view10
    1574. 

  1574. POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    1575. 

  1575. PREHOOK: query: DROP VIEW view11
    1576. 

  1576. PREHOOK: type: DROPVIEW
    1577. 

  1577. PREHOOK: Input: default@view11
    1578. 

  1578. PREHOOK: Output: default@view11
    1579. 

  1579. POSTHOOK: query: DROP VIEW view11
    1580. 

  1580. POSTHOOK: type: DROPVIEW
    1581. 

  1581. POSTHOOK: Input: default@view11
    1582. 

  1582. POSTHOOK: Output: default@view11
    1583. 

  1583. POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    1584. 

  1584. PREHOOK: query: DROP VIEW view12
    1585. 

  1585. PREHOOK: type: DROPVIEW
    1586. 

  1586. PREHOOK: Input: default@view12
    1587. 

  1587. PREHOOK: Output: default@view12
    1588. 

  1588. POSTHOOK: query: DROP VIEW view12
    1589. 

  1589. POSTHOOK: type: DROPVIEW
    1590. 

  1590. POSTHOOK: Input: default@view12
    1591. 

  1591. POSTHOOK: Output: default@view12
    1592. 

  1592. POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    1593. 

  1593. PREHOOK: query: DROP VIEW view13
    1594. 

  1594. PREHOOK: type: DROPVIEW
    1595. 

  1595. PREHOOK: Input: default@view13
    1596. 

  1596. PREHOOK: Output: default@view13
    1597. 

  1597. POSTHOOK: query: DROP VIEW view13
    1598. 

  1598. POSTHOOK: type: DROPVIEW
    1599. 

  1599. POSTHOOK: Input: default@view13
    1600. 

  1600. POSTHOOK: Output: default@view13
    1601. 

  1601. POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    1602. 

  1602. PREHOOK: query: DROP VIEW view14
    1603. 

  1603. PREHOOK: type: DROPVIEW
    1604. 

  1604. PREHOOK: Input: default@view14
    1605. 

  1605. PREHOOK: Output: default@view14
    1606. 

  1606. POSTHOOK: query: DROP VIEW view14
    1607. 

  1607. POSTHOOK: type: DROPVIEW
    1608. 

  1608. POSTHOOK: Input: default@view14
    1609. 

  1609. POSTHOOK: Output: default@view14
    1610. 

  1610. POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    1611. 

  1611. PREHOOK: query: DROP VIEW view15
    1612. 

  1612. PREHOOK: type: DROPVIEW
    1613. 

  1613. PREHOOK: Input: default@view15
    1614. 

  1614. PREHOOK: Output: default@view15
    1615. 

  1615. POSTHOOK: query: DROP VIEW view15
    1616. 

  1616. POSTHOOK: type: DROPVIEW
    1617. 

  1617. POSTHOOK: Input: default@view15
    1618. 

  1618. POSTHOOK: Output: default@view15
    1619. 

  1619. POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    1620. 

  1620. PREHOOK: query: DROP VIEW view16
    1621. 

  1621. PREHOOK: type: DROPVIEW
    1622. 

  1622. PREHOOK: Input: default@view16
    1623. 

  1623. PREHOOK: Output: default@view16
    1624. 

  1624. POSTHOOK: query: DROP VIEW view16
    1625. 

  1625. POSTHOOK: type: DROPVIEW
    1626. 

  1626. POSTHOOK: Input: default@view16
    1627. 

  1627. POSTHOOK: Output: default@view16
    1628. 

  1628. POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    1629. 

  1629. PREHOOK: query: DROP TEMPORARY FUNCTION test_translate
    1630. 

  1630. PREHOOK: type: DROPFUNCTION
    1631. 

  1631. POSTHOOK: query: DROP TEMPORARY FUNCTION test_translate
    1632. 

  1632. POSTHOOK: type: DROPFUNCTION
    1633. 

  1633. POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    1634. 

  1634. PREHOOK: query: DROP TEMPORARY FUNCTION test_max
    1635. 

  1635. PREHOOK: type: DROPFUNCTION
    1636. 

  1636. POSTHOOK: query: DROP TEMPORARY FUNCTION test_max
    1637. 

  1637. POSTHOOK: type: DROPFUNCTION
    1638. 

  1638. POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    1639. 

  1639. PREHOOK: query: DROP TEMPORARY FUNCTION test_explode
    1640. 

  1640. PREHOOK: type: DROPFUNCTION
    1641. 

  1641. POSTHOOK: query: DROP TEMPORARY FUNCTION test_explode
    1642. 

  1642. POSTHOOK: type: DROPFUNCTION
    1643. 

  1643. POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    1644. 

  1644.