PageRenderTime 20ms CodeModel.GetById 15ms app.highlight 2ms RepoModel.GetById 1ms app.codeStats 1ms

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

#
text | 548 lines | 544 code | 4 blank | 0 comment | 0 complexity | 33b93a51f3e1a8c6e9e38f3cd98beb71 MD5 | raw file
  1PREHOOK: query: EXPLAIN
  2CREATE TEMPORARY FUNCTION testlength AS 'org.apache.hadoop.hive.ql.udf.UDFTestLength'
  3PREHOOK: type: CREATEFUNCTION
  4POSTHOOK: query: EXPLAIN
  5CREATE TEMPORARY FUNCTION testlength AS 'org.apache.hadoop.hive.ql.udf.UDFTestLength'
  6POSTHOOK: type: CREATEFUNCTION
  7ABSTRACT SYNTAX TREE:
  8  (TOK_CREATEFUNCTION testlength 'org.apache.hadoop.hive.ql.udf.UDFTestLength')
  9
 10STAGE DEPENDENCIES:
 11  Stage-0 is a root stage
 12
 13STAGE PLANS:
 14  Stage: Stage-0
 15
 16
 17PREHOOK: query: CREATE TEMPORARY FUNCTION testlength AS 'org.apache.hadoop.hive.ql.udf.UDFTestLength'
 18PREHOOK: type: CREATEFUNCTION
 19POSTHOOK: query: CREATE TEMPORARY FUNCTION testlength AS 'org.apache.hadoop.hive.ql.udf.UDFTestLength'
 20POSTHOOK: type: CREATEFUNCTION
 21PREHOOK: query: CREATE TABLE dest1(len INT)
 22PREHOOK: type: CREATETABLE
 23POSTHOOK: query: CREATE TABLE dest1(len INT)
 24POSTHOOK: type: CREATETABLE
 25POSTHOOK: Output: default@dest1
 26PREHOOK: query: FROM src INSERT OVERWRITE TABLE dest1 SELECT testlength(src.value)
 27PREHOOK: type: QUERY
 28PREHOOK: Input: default@src
 29PREHOOK: Output: default@dest1
 30POSTHOOK: query: FROM src INSERT OVERWRITE TABLE dest1 SELECT testlength(src.value)
 31POSTHOOK: type: QUERY
 32POSTHOOK: Input: default@src
 33POSTHOOK: Output: default@dest1
 34POSTHOOK: Lineage: dest1.len EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 35PREHOOK: query: SELECT dest1.* FROM dest1
 36PREHOOK: type: QUERY
 37PREHOOK: Input: default@dest1
 38PREHOOK: Output: file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_1/build/ql/scratchdir/hive_2010-04-05_18-36-20_684_2066191954563590193/10000
 39POSTHOOK: query: SELECT dest1.* FROM dest1
 40POSTHOOK: type: QUERY
 41POSTHOOK: Input: default@dest1
 42POSTHOOK: Output: file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_1/build/ql/scratchdir/hive_2010-04-05_18-36-20_684_2066191954563590193/10000
 43POSTHOOK: Lineage: dest1.len EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 447
 456
 467
 476
 487
 497
 507
 517
 526
 537
 547
 557
 567
 577
 587
 597
 607
 616
 627
 637
 647
 657
 667
 677
 687
 697
 707
 717
 726
 737
 747
 757
 767
 776
 786
 797
 807
 817
 827
 837
 847
 857
 867
 877
 887
 897
 907
 917
 927
 937
 947
 957
 967
 977
 987
 997
1007
1017
1027
1037
1047
1057
1067
1077
1087
1097
1107
1117
1127
1137
1147
1157
1167
1177
1187
1197
1207
1216
1227
1237
1247
1257
1265
1277
1287
1297
1307
1316
1327
1337
1347
1357
1367
1377
1387
1396
1407
1417
1427
1437
1446
1457
1466
1476
1485
1497
1506
1517
1527
1537
1547
1557
1567
1577
1587
1597
1607
1617
1627
1637
1647
1657
1667
1676
1687
1696
1707
1717
1727
1737
1747
1757
1767
1777
1787
1797
1806
1817
1827
1837
1847
1857
1867
1876
1887
1897
1907
1916
1927
1937
1946
1957
1967
1977
1987
1997
2007
2017
2027
2037
2046
2057
2067
2076
2085
2097
2107
2117
2127
2136
2147
2157
2167
2177
2186
2197
2207
2217
2227
2235
2247
2257
2267
2277
2287
2297
2307
2317
2327
2337
2346
2356
2367
2377
2387
2397
2407
2417
2426
2437
2446
2457
2467
2477
2487
2497
2506
2517
2527
2537
2547
2556
2567
2577
2587
2597
2607
2617
2627
2637
2647
2657
2667
2677
2686
2696
2705
2717
2726
2737
2747
2757
2767
2777
2787
2797
2807
2817
2826
2837
2846
2856
2867
2876
2887
2896
2907
2917
2927
2937
2947
2957
2967
2977
2987
2997
3007
3017
3027
3037
3047
3057
3067
3075
3087
3097
3107
3117
3127
3136
3146
3157
3166
3176
3187
3196
3207
3217
3227
3237
3247
3257
3267
3277
3286
3297
3307
3317
3327
3337
3346
3356
3366
3377
3387
3397
3407
3417
3427
3437
3447
3456
3467
3476
3487
3496
3506
3517
3526
3537
3546
3557
3567
3577
3587
3597
3607
3617
3627
3637
3647
3657
3667
3677
3687
3697
3707
3716
3727
3737
3747
3757
3767
3775
3787
3797
3807
3817
3827
3837
3847
3857
3867
3877
3887
3895
3906
3917
3927
3937
3946
3956
3967
3977
3987
3997
4007
4017
4027
4037
4047
4056
4067
4077
4087
4097
4107
4117
4127
4137
4147
4156
4167
4177
4187
4197
4206
4217
4227
4237
4247
4257
4267
4277
4287
4297
4307
4317
4327
4337
4347
4355
4366
4377
4387
4397
4406
4417
4427
4437
4446
4457
4467
4477
4487
4497
4507
4517
4527
4537
4547
4557
4567
4577
4587
4597
4607
4617
4627
4637
4647
4657
4667
4677
4687
4697
4707
4717
4727
4737
4747
4757
4767
4777
4787
4797
4806
4817
4827
4837
4847
4857
4867
4877
4887
4897
4907
4917
4927
4937
4947
4957
4967
4977
4986
4997
5006
5017
5027
5036
5047
5057
5067
5077
5085
5097
5107
5117
5127
5137
5147
5157
5167
5177
5186
5197
5207
5217
5227
5236
5247
5257
5266
5276
5286
5297
5307
5317
5327
5337
5347
5357
5367
5377
5386
5397
5407
5417
5427
5436
544PREHOOK: query: DROP TEMPORARY FUNCTION testlength
545PREHOOK: type: DROPFUNCTION
546POSTHOOK: query: DROP TEMPORARY FUNCTION testlength
547POSTHOOK: type: DROPFUNCTION
548POSTHOOK: Lineage: dest1.len EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]