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

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

#
text | 85 lines | 81 code | 4 blank | 0 comment | 0 complexity | 64f05f4c29922c094bb0cc86e10c4e5d MD5 | raw file
 1PREHOOK: query: EXPLAIN
 2CREATE TEMPORARY FUNCTION test_translate AS 'org.apache.hadoop.hive.ql.udf.generic.GenericUDFTestTranslate'
 3PREHOOK: type: CREATEFUNCTION
 4POSTHOOK: query: EXPLAIN
 5CREATE TEMPORARY FUNCTION test_translate AS 'org.apache.hadoop.hive.ql.udf.generic.GenericUDFTestTranslate'
 6POSTHOOK: type: CREATEFUNCTION
 7ABSTRACT SYNTAX TREE:
 8  (TOK_CREATEFUNCTION test_translate 'org.apache.hadoop.hive.ql.udf.generic.GenericUDFTestTranslate')
 9
10STAGE DEPENDENCIES:
11  Stage-0 is a root stage
12
13STAGE PLANS:
14  Stage: Stage-0
15
16
17PREHOOK: query: CREATE TEMPORARY FUNCTION test_translate AS 'org.apache.hadoop.hive.ql.udf.generic.GenericUDFTestTranslate'
18PREHOOK: type: CREATEFUNCTION
19POSTHOOK: query: CREATE TEMPORARY FUNCTION test_translate AS 'org.apache.hadoop.hive.ql.udf.generic.GenericUDFTestTranslate'
20POSTHOOK: type: CREATEFUNCTION
21PREHOOK: query: CREATE TABLE dest1(c1 STRING, c2 STRING, c3 STRING, c4 STRING, c5 STRING, c6 STRING, c7 STRING)
22PREHOOK: type: CREATETABLE
23POSTHOOK: query: CREATE TABLE dest1(c1 STRING, c2 STRING, c3 STRING, c4 STRING, c5 STRING, c6 STRING, c7 STRING)
24POSTHOOK: type: CREATETABLE
25POSTHOOK: Output: default@dest1
26PREHOOK: query: FROM src 
27INSERT OVERWRITE TABLE dest1 
28SELECT 
29    test_translate('abc', 'a', 'b'),
30    test_translate('abc', 'ab', 'bc'),
31    test_translate(NULL, 'a', 'b'),
32    test_translate('a', NULL, 'b'),
33    test_translate('a', 'a', NULL),
34    test_translate('abc', 'ab', 'b'),
35    test_translate('abc', 'a', 'ab')
36PREHOOK: type: QUERY
37PREHOOK: Input: default@src
38PREHOOK: Output: default@dest1
39POSTHOOK: query: FROM src 
40INSERT OVERWRITE TABLE dest1 
41SELECT 
42    test_translate('abc', 'a', 'b'),
43    test_translate('abc', 'ab', 'bc'),
44    test_translate(NULL, 'a', 'b'),
45    test_translate('a', NULL, 'b'),
46    test_translate('a', 'a', NULL),
47    test_translate('abc', 'ab', 'b'),
48    test_translate('abc', 'a', 'ab')
49POSTHOOK: type: QUERY
50POSTHOOK: Input: default@src
51POSTHOOK: Output: default@dest1
52POSTHOOK: Lineage: dest1.c1 EXPRESSION []
53POSTHOOK: Lineage: dest1.c2 EXPRESSION []
54POSTHOOK: Lineage: dest1.c3 EXPRESSION []
55POSTHOOK: Lineage: dest1.c4 EXPRESSION []
56POSTHOOK: Lineage: dest1.c5 EXPRESSION []
57POSTHOOK: Lineage: dest1.c6 EXPRESSION []
58POSTHOOK: Lineage: dest1.c7 EXPRESSION []
59PREHOOK: query: SELECT dest1.* FROM dest1 LIMIT 1
60PREHOOK: type: QUERY
61PREHOOK: Input: default@dest1
62PREHOOK: Output: file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_1/build/ql/scratchdir/hive_2010-04-05_18-07-45_069_5108835452683223960/10000
63POSTHOOK: query: SELECT dest1.* FROM dest1 LIMIT 1
64POSTHOOK: type: QUERY
65POSTHOOK: Input: default@dest1
66POSTHOOK: Output: file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_1/build/ql/scratchdir/hive_2010-04-05_18-07-45_069_5108835452683223960/10000
67POSTHOOK: Lineage: dest1.c1 EXPRESSION []
68POSTHOOK: Lineage: dest1.c2 EXPRESSION []
69POSTHOOK: Lineage: dest1.c3 EXPRESSION []
70POSTHOOK: Lineage: dest1.c4 EXPRESSION []
71POSTHOOK: Lineage: dest1.c5 EXPRESSION []
72POSTHOOK: Lineage: dest1.c6 EXPRESSION []
73POSTHOOK: Lineage: dest1.c7 EXPRESSION []
74bbc	bcc	NULL	NULL	NULL	bc	abc
75PREHOOK: query: DROP TEMPORARY FUNCTION test_translate
76PREHOOK: type: DROPFUNCTION
77POSTHOOK: query: DROP TEMPORARY FUNCTION test_translate
78POSTHOOK: type: DROPFUNCTION
79POSTHOOK: Lineage: dest1.c1 EXPRESSION []
80POSTHOOK: Lineage: dest1.c2 EXPRESSION []
81POSTHOOK: Lineage: dest1.c3 EXPRESSION []
82POSTHOOK: Lineage: dest1.c4 EXPRESSION []
83POSTHOOK: Lineage: dest1.c5 EXPRESSION []
84POSTHOOK: Lineage: dest1.c6 EXPRESSION []
85POSTHOOK: Lineage: dest1.c7 EXPRESSION []