PageRenderTime 53ms CodeModel.GetById 25ms RepoModel.GetById 0ms 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
Possible License(s): Apache-2.0, BSD-3-Clause, JSON, CPL-1.0 
    

  1. PREHOOK: query: EXPLAIN
    2. 

  2. CREATE TEMPORARY FUNCTION test_translate AS 'org.apache.hadoop.hive.ql.udf.generic.GenericUDFTestTranslate'
    3. 

  3. PREHOOK: type: CREATEFUNCTION
    4. 

  4. POSTHOOK: query: EXPLAIN
    5. 

  5. CREATE TEMPORARY FUNCTION test_translate AS 'org.apache.hadoop.hive.ql.udf.generic.GenericUDFTestTranslate'
    6. 

  6. POSTHOOK: type: CREATEFUNCTION
    7. 

  7. ABSTRACT SYNTAX TREE:
    8. 

  8.   (TOK_CREATEFUNCTION test_translate 'org.apache.hadoop.hive.ql.udf.generic.GenericUDFTestTranslate')
    9. 

  9. 

  10. STAGE DEPENDENCIES:
    11. 

  11.   Stage-0 is a root stage
    12. 

  12. 

  13. STAGE PLANS:
    14. 

  14.   Stage: Stage-0
    15. 

  15. 

  16. 

  17. PREHOOK: query: CREATE TEMPORARY FUNCTION test_translate AS 'org.apache.hadoop.hive.ql.udf.generic.GenericUDFTestTranslate'
    18. 

  18. PREHOOK: type: CREATEFUNCTION
    19. 

  19. POSTHOOK: query: CREATE TEMPORARY FUNCTION test_translate AS 'org.apache.hadoop.hive.ql.udf.generic.GenericUDFTestTranslate'
    20. 

  20. POSTHOOK: type: CREATEFUNCTION
    21. 

  21. PREHOOK: query: CREATE TABLE dest1(c1 STRING, c2 STRING, c3 STRING, c4 STRING, c5 STRING, c6 STRING, c7 STRING)
    22. 

  22. PREHOOK: type: CREATETABLE
    23. 

  23. POSTHOOK: query: CREATE TABLE dest1(c1 STRING, c2 STRING, c3 STRING, c4 STRING, c5 STRING, c6 STRING, c7 STRING)
    24. 

  24. POSTHOOK: type: CREATETABLE
    25. 

  25. POSTHOOK: Output: default@dest1
    26. 

  26. PREHOOK: query: FROM src 
    27. 

  27. INSERT OVERWRITE TABLE dest1 
    28. 

  28. SELECT 
    29. 

  29.     test_translate('abc', 'a', 'b'),
    30. 

  30.     test_translate('abc', 'ab', 'bc'),
    31. 

  31.     test_translate(NULL, 'a', 'b'),
    32. 

  32.     test_translate('a', NULL, 'b'),
    33. 

  33.     test_translate('a', 'a', NULL),
    34. 

  34.     test_translate('abc', 'ab', 'b'),
    35. 

  35.     test_translate('abc', 'a', 'ab')
    36. 

  36. PREHOOK: type: QUERY
    37. 

  37. PREHOOK: Input: default@src
    38. 

  38. PREHOOK: Output: default@dest1
    39. 

  39. POSTHOOK: query: FROM src 
    40. 

  40. INSERT OVERWRITE TABLE dest1 
    41. 

  41. SELECT 
    42. 

  42.     test_translate('abc', 'a', 'b'),
    43. 

  43.     test_translate('abc', 'ab', 'bc'),
    44. 

  44.     test_translate(NULL, 'a', 'b'),
    45. 

  45.     test_translate('a', NULL, 'b'),
    46. 

  46.     test_translate('a', 'a', NULL),
    47. 

  47.     test_translate('abc', 'ab', 'b'),
    48. 

  48.     test_translate('abc', 'a', 'ab')
    49. 

  49. POSTHOOK: type: QUERY
    50. 

  50. POSTHOOK: Input: default@src
    51. 

  51. POSTHOOK: Output: default@dest1
    52. 

  52. POSTHOOK: Lineage: dest1.c1 EXPRESSION []
    53. 

  53. POSTHOOK: Lineage: dest1.c2 EXPRESSION []
    54. 

  54. POSTHOOK: Lineage: dest1.c3 EXPRESSION []
    55. 

  55. POSTHOOK: Lineage: dest1.c4 EXPRESSION []
    56. 

  56. POSTHOOK: Lineage: dest1.c5 EXPRESSION []
    57. 

  57. POSTHOOK: Lineage: dest1.c6 EXPRESSION []
    58. 

  58. POSTHOOK: Lineage: dest1.c7 EXPRESSION []
    59. 

  59. PREHOOK: query: SELECT dest1.* FROM dest1 LIMIT 1
    60. 

  60. PREHOOK: type: QUERY
    61. 

  61. PREHOOK: Input: default@dest1
    62. 

  62. PREHOOK: 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
    63. 

  63. POSTHOOK: query: SELECT dest1.* FROM dest1 LIMIT 1
    64. 

  64. POSTHOOK: type: QUERY
    65. 

  65. POSTHOOK: Input: default@dest1
    66. 

  66. POSTHOOK: 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
    67. 

  67. POSTHOOK: Lineage: dest1.c1 EXPRESSION []
    68. 

  68. POSTHOOK: Lineage: dest1.c2 EXPRESSION []
    69. 

  69. POSTHOOK: Lineage: dest1.c3 EXPRESSION []
    70. 

  70. POSTHOOK: Lineage: dest1.c4 EXPRESSION []
    71. 

  71. POSTHOOK: Lineage: dest1.c5 EXPRESSION []
    72. 

  72. POSTHOOK: Lineage: dest1.c6 EXPRESSION []
    73. 

  73. POSTHOOK: Lineage: dest1.c7 EXPRESSION []
    74. 

  74. bbc	bcc	NULL	NULL	NULL	bc	abc
    75. 

  75. PREHOOK: query: DROP TEMPORARY FUNCTION test_translate
    76. 

  76. PREHOOK: type: DROPFUNCTION
    77. 

  77. POSTHOOK: query: DROP TEMPORARY FUNCTION test_translate
    78. 

  78. POSTHOOK: type: DROPFUNCTION
    79. 

  79. POSTHOOK: Lineage: dest1.c1 EXPRESSION []
    80. 

  80. POSTHOOK: Lineage: dest1.c2 EXPRESSION []
    81. 

  81. POSTHOOK: Lineage: dest1.c3 EXPRESSION []
    82. 

  82. POSTHOOK: Lineage: dest1.c4 EXPRESSION []
    83. 

  83. POSTHOOK: Lineage: dest1.c5 EXPRESSION []
    84. 

  84. POSTHOOK: Lineage: dest1.c6 EXPRESSION []
    85. 

  85. POSTHOOK: Lineage: dest1.c7 EXPRESSION []
    86. 

  86.