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

/tags/release-0.0.0-rc0/hive/external/ql/src/test/results/clientpositive/rcfile_lazydecompress.q.out

#
text | 123 lines | 123 code | 0 blank | 0 comment | 0 complexity | a954a4cc521335c04cef8ec6340b9a5f MD5 | raw file
  1PREHOOK: query: CREATE table rcfileTableLazyDecompress (key STRING, value STRING) STORED AS RCFile
  2PREHOOK: type: CREATETABLE
  3POSTHOOK: query: CREATE table rcfileTableLazyDecompress (key STRING, value STRING) STORED AS RCFile
  4POSTHOOK: type: CREATETABLE
  5POSTHOOK: Output: default@rcfileTableLazyDecompress
  6PREHOOK: query: FROM src
  7INSERT OVERWRITE TABLE rcfileTableLazyDecompress SELECT src.key, src.value LIMIT 10
  8PREHOOK: type: QUERY
  9PREHOOK: Input: default@src
 10PREHOOK: Output: default@rcfiletablelazydecompress
 11POSTHOOK: query: FROM src
 12INSERT OVERWRITE TABLE rcfileTableLazyDecompress SELECT src.key, src.value LIMIT 10
 13POSTHOOK: type: QUERY
 14POSTHOOK: Input: default@src
 15POSTHOOK: Output: default@rcfiletablelazydecompress
 16POSTHOOK: Lineage: rcfiletablelazydecompress.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 17POSTHOOK: Lineage: rcfiletablelazydecompress.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 18PREHOOK: query: SELECT key, value FROM rcfileTableLazyDecompress where key > 238
 19PREHOOK: type: QUERY
 20PREHOOK: Input: default@rcfiletablelazydecompress
 21PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-48-26_308_5035766417306203353/10000
 22POSTHOOK: query: SELECT key, value FROM rcfileTableLazyDecompress where key > 238
 23POSTHOOK: type: QUERY
 24POSTHOOK: Input: default@rcfiletablelazydecompress
 25POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-48-26_308_5035766417306203353/10000
 26POSTHOOK: Lineage: rcfiletablelazydecompress.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 27POSTHOOK: Lineage: rcfiletablelazydecompress.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 28311	val_311
 29409	val_409
 30255	val_255
 31278	val_278
 32484	val_484
 33PREHOOK: query: SELECT key, value FROM rcfileTableLazyDecompress where key > 238 and key < 400
 34PREHOOK: type: QUERY
 35PREHOOK: Input: default@rcfiletablelazydecompress
 36PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-48-28_826_2664555248442666518/10000
 37POSTHOOK: query: SELECT key, value FROM rcfileTableLazyDecompress where key > 238 and key < 400
 38POSTHOOK: type: QUERY
 39POSTHOOK: Input: default@rcfiletablelazydecompress
 40POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-48-28_826_2664555248442666518/10000
 41POSTHOOK: Lineage: rcfiletablelazydecompress.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 42POSTHOOK: Lineage: rcfiletablelazydecompress.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 43311	val_311
 44255	val_255
 45278	val_278
 46PREHOOK: query: SELECT key, count(1) FROM rcfileTableLazyDecompress where key > 238 group by key
 47PREHOOK: type: QUERY
 48PREHOOK: Input: default@rcfiletablelazydecompress
 49PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-48-31_347_4980542755724589562/10000
 50POSTHOOK: query: SELECT key, count(1) FROM rcfileTableLazyDecompress where key > 238 group by key
 51POSTHOOK: type: QUERY
 52POSTHOOK: Input: default@rcfiletablelazydecompress
 53POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-48-31_347_4980542755724589562/10000
 54POSTHOOK: Lineage: rcfiletablelazydecompress.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 55POSTHOOK: Lineage: rcfiletablelazydecompress.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 56255	1
 57278	1
 58311	1
 59409	1
 60484	1
 61PREHOOK: query: FROM src
 62INSERT OVERWRITE TABLE rcfileTableLazyDecompress SELECT src.key, src.value LIMIT 10
 63PREHOOK: type: QUERY
 64PREHOOK: Input: default@src
 65PREHOOK: Output: default@rcfiletablelazydecompress
 66POSTHOOK: query: FROM src
 67INSERT OVERWRITE TABLE rcfileTableLazyDecompress SELECT src.key, src.value LIMIT 10
 68POSTHOOK: type: QUERY
 69POSTHOOK: Input: default@src
 70POSTHOOK: Output: default@rcfiletablelazydecompress
 71POSTHOOK: Lineage: rcfiletablelazydecompress.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 72POSTHOOK: Lineage: rcfiletablelazydecompress.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 73POSTHOOK: Lineage: rcfiletablelazydecompress.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 74POSTHOOK: Lineage: rcfiletablelazydecompress.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 75PREHOOK: query: SELECT key, value FROM rcfileTableLazyDecompress where key > 238
 76PREHOOK: type: QUERY
 77PREHOOK: Input: default@rcfiletablelazydecompress
 78PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-48-36_558_7043959496739147343/10000
 79POSTHOOK: query: SELECT key, value FROM rcfileTableLazyDecompress where key > 238
 80POSTHOOK: type: QUERY
 81POSTHOOK: Input: default@rcfiletablelazydecompress
 82POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-48-36_558_7043959496739147343/10000
 83POSTHOOK: Lineage: rcfiletablelazydecompress.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 84POSTHOOK: Lineage: rcfiletablelazydecompress.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 85POSTHOOK: Lineage: rcfiletablelazydecompress.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 86POSTHOOK: Lineage: rcfiletablelazydecompress.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 87311	val_311
 88409	val_409
 89255	val_255
 90278	val_278
 91484	val_484
 92PREHOOK: query: SELECT key, value FROM rcfileTableLazyDecompress where key > 238 and key < 400
 93PREHOOK: type: QUERY
 94PREHOOK: Input: default@rcfiletablelazydecompress
 95PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-48-39_022_510504722430321903/10000
 96POSTHOOK: query: SELECT key, value FROM rcfileTableLazyDecompress where key > 238 and key < 400
 97POSTHOOK: type: QUERY
 98POSTHOOK: Input: default@rcfiletablelazydecompress
 99POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-48-39_022_510504722430321903/10000
100POSTHOOK: Lineage: rcfiletablelazydecompress.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
101POSTHOOK: Lineage: rcfiletablelazydecompress.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
102POSTHOOK: Lineage: rcfiletablelazydecompress.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
103POSTHOOK: Lineage: rcfiletablelazydecompress.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
104311	val_311
105255	val_255
106278	val_278
107PREHOOK: query: SELECT key, count(1) FROM rcfileTableLazyDecompress where key > 238 group by key
108PREHOOK: type: QUERY
109PREHOOK: Input: default@rcfiletablelazydecompress
110PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-48-41_564_865533805813240026/10000
111POSTHOOK: query: SELECT key, count(1) FROM rcfileTableLazyDecompress where key > 238 group by key
112POSTHOOK: type: QUERY
113POSTHOOK: Input: default@rcfiletablelazydecompress
114POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-48-41_564_865533805813240026/10000
115POSTHOOK: Lineage: rcfiletablelazydecompress.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
116POSTHOOK: Lineage: rcfiletablelazydecompress.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
117POSTHOOK: Lineage: rcfiletablelazydecompress.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
118POSTHOOK: Lineage: rcfiletablelazydecompress.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
119255	1
120278	1
121311	1
122409	1
123484	1