PageRenderTime 18ms CodeModel.GetById 11ms app.highlight 2ms RepoModel.GetById 1ms app.codeStats 0ms

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

#
text | 46 lines | 46 code | 0 blank | 0 comment | 0 complexity | 4b9dc2f4ea15347242704cc756b9d00b MD5 | raw file
 1PREHOOK: query: CREATE TABLE dest1(key INT, value STRING)
 2PREHOOK: type: CREATETABLE
 3POSTHOOK: query: CREATE TABLE dest1(key INT, value STRING)
 4POSTHOOK: type: CREATETABLE
 5POSTHOOK: Output: default@dest1
 6PREHOOK: query: FROM (
 7  FROM src
 8  SELECT TRANSFORM(src.key, src.value)
 9         USING 'testgrep' AS (tkey, tvalue)
10  CLUSTER BY tkey
11) tmap
12INSERT OVERWRITE TABLE dest1 SELECT tmap.tkey, tmap.tvalue
13PREHOOK: type: QUERY
14PREHOOK: Input: default@src
15PREHOOK: Output: default@dest1
16POSTHOOK: query: FROM (
17  FROM src
18  SELECT TRANSFORM(src.key, src.value)
19         USING 'testgrep' AS (tkey, tvalue)
20  CLUSTER BY tkey
21) tmap
22INSERT OVERWRITE TABLE dest1 SELECT tmap.tkey, tmap.tvalue
23POSTHOOK: type: QUERY
24POSTHOOK: Input: default@src
25POSTHOOK: Output: default@dest1
26POSTHOOK: Lineage: dest1.key SCRIPT [(src)src.FieldSchema(name:key, type:string, comment:default), (src)src.FieldSchema(name:value, type:string, comment:default), ]
27POSTHOOK: Lineage: dest1.value SCRIPT [(src)src.FieldSchema(name:key, type:string, comment:default), (src)src.FieldSchema(name:value, type:string, comment:default), ]
28PREHOOK: query: SELECT dest1.* FROM dest1
29PREHOOK: type: QUERY
30PREHOOK: Input: default@dest1
31PREHOOK: Output: hdfs://localhost.localdomain:39190/data/users/njain/hive_commit1/build/ql/scratchdir/hive_2011-02-03_10-52-59_555_6132352806731305883/-mr-10000
32POSTHOOK: query: SELECT dest1.* FROM dest1
33POSTHOOK: type: QUERY
34POSTHOOK: Input: default@dest1
35POSTHOOK: Output: hdfs://localhost.localdomain:39190/data/users/njain/hive_commit1/build/ql/scratchdir/hive_2011-02-03_10-52-59_555_6132352806731305883/-mr-10000
36POSTHOOK: Lineage: dest1.key SCRIPT [(src)src.FieldSchema(name:key, type:string, comment:default), (src)src.FieldSchema(name:value, type:string, comment:default), ]
37POSTHOOK: Lineage: dest1.value SCRIPT [(src)src.FieldSchema(name:key, type:string, comment:default), (src)src.FieldSchema(name:value, type:string, comment:default), ]
3810	val_10
39100	val_100
40100	val_100
41103	val_103
42103	val_103
43104	val_104
44104	val_104
45105	val_105
46310	val_310