PageRenderTime 39ms CodeModel.GetById 13ms RepoModel.GetById 0ms app.codeStats 0ms

/tags/release-0.0.0-rc0/hive/external/contrib/src/test/results/clientpositive/udaf_example_avg.q.out

#
text | 92 lines | 87 code | 5 blank | 0 comment | 0 complexity | 9c958e8216cb447c048022e8c54ea11a MD5 | raw file
Possible License(s): Apache-2.0, BSD-3-Clause, JSON, CPL-1.0 
    

  1. PREHOOK: query: CREATE TEMPORARY FUNCTION example_avg AS 'org.apache.hadoop.hive.contrib.udaf.example.UDAFExampleAvg'
    2. 

  2. PREHOOK: type: CREATEFUNCTION
    3. 

  3. POSTHOOK: query: CREATE TEMPORARY FUNCTION example_avg AS 'org.apache.hadoop.hive.contrib.udaf.example.UDAFExampleAvg'
    4. 

  4. POSTHOOK: type: CREATEFUNCTION
    5. 

  5. PREHOOK: query: EXPLAIN
    6. 

  6. SELECT example_avg(substr(value,5)),
    7. 

  7.        example_avg(IF(substr(value,5) > 250, NULL, substr(value,5)))
    8. 

  8. FROM src
    9. 

  9. PREHOOK: type: QUERY
    10. 

  10. POSTHOOK: query: EXPLAIN
    11. 

  11. SELECT example_avg(substr(value,5)),
    12. 

  12.        example_avg(IF(substr(value,5) > 250, NULL, substr(value,5)))
    13. 

  13. FROM src
    14. 

  14. POSTHOOK: type: QUERY
    15. 

  15. ABSTRACT SYNTAX TREE:
    16. 

  16.   (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION example_avg (TOK_FUNCTION substr (TOK_TABLE_OR_COL value) 5))) (TOK_SELEXPR (TOK_FUNCTION example_avg (TOK_FUNCTION IF (> (TOK_FUNCTION substr (TOK_TABLE_OR_COL value) 5) 250) TOK_NULL (TOK_FUNCTION substr (TOK_TABLE_OR_COL value) 5)))))))
    17. 

  17. 

  18. STAGE DEPENDENCIES:
    19. 

  19.   Stage-1 is a root stage
    20. 

  20.   Stage-0 is a root stage
    21. 

  21. 

  22. STAGE PLANS:
    23. 

  23.   Stage: Stage-1
    24. 

  24.     Map Reduce
    25. 

  25.       Alias -> Map Operator Tree:
    26. 

  26.         src 
    27. 

  27.           TableScan
    28. 

  28.             alias: src
    29. 

  29.             Select Operator
    30. 

  30.               expressions:
    31. 

  31.                     expr: value
    32. 

  32.                     type: string
    33. 

  33.               outputColumnNames: value
    34. 

  34.               Group By Operator
    35. 

  35.                 aggregations:
    36. 

  36.                       expr: example_avg(substr(value, 5))
    37. 

  37.                       expr: example_avg(if((substr(value, 5) > 250), null, substr(value, 5)))
    38. 

  38.                 bucketGroup: false
    39. 

  39.                 mode: hash
    40. 

  40.                 outputColumnNames: _col0, _col1
    41. 

  41.                 Reduce Output Operator
    42. 

  42.                   sort order: 
    43. 

  43.                   tag: -1
    44. 

  44.                   value expressions:
    45. 

  45.                         expr: _col0
    46. 

  46.                         type: struct<mcount:bigint,msum:double>
    47. 

  47.                         expr: _col1
    48. 

  48.                         type: struct<mcount:bigint,msum:double>
    49. 

  49.       Reduce Operator Tree:
    50. 

  50.         Group By Operator
    51. 

  51.           aggregations:
    52. 

  52.                 expr: example_avg(VALUE._col0)
    53. 

  53.                 expr: example_avg(VALUE._col1)
    54. 

  54.           bucketGroup: false
    55. 

  55.           mode: mergepartial
    56. 

  56.           outputColumnNames: _col0, _col1
    57. 

  57.           Select Operator
    58. 

  58.             expressions:
    59. 

  59.                   expr: _col0
    60. 

  60.                   type: double
    61. 

  61.                   expr: _col1
    62. 

  62.                   type: double
    63. 

  63.             outputColumnNames: _col0, _col1
    64. 

  64.             File Output Operator
    65. 

  65.               compressed: false
    66. 

  66.               GlobalTableId: 0
    67. 

  67.               table:
    68. 

  68.                   input format: org.apache.hadoop.mapred.TextInputFormat
    69. 

  69.                   output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
    70. 

  70. 

  71.   Stage: Stage-0
    72. 

  72.     Fetch Operator
    73. 

  73.       limit: -1
    74. 

  74. 

  75. 

  76. PREHOOK: query: SELECT example_avg(substr(value,5)),
    77. 

  77.        example_avg(IF(substr(value,5) > 250, NULL, substr(value,5)))
    78. 

  78. FROM src
    79. 

  79. PREHOOK: type: QUERY
    80. 

  80. PREHOOK: Input: default@src
    81. 

  81. PREHOOK: Output: file:/tmp/sdong/hive_2011-02-16_20-10-40_935_934094548612608112/-mr-10000
    82. 

  82. POSTHOOK: query: SELECT example_avg(substr(value,5)),
    83. 

  83.        example_avg(IF(substr(value,5) > 250, NULL, substr(value,5)))
    84. 

  84. FROM src
    85. 

  85. POSTHOOK: type: QUERY
    86. 

  86. POSTHOOK: Input: default@src
    87. 

  87. POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-16_20-10-40_935_934094548612608112/-mr-10000
    88. 

  88. 260.182	134.82926829268294
    89. 

  89. PREHOOK: query: DROP TEMPORARY FUNCTION example_avg
    90. 

  90. PREHOOK: type: DROPFUNCTION
    91. 

  91. POSTHOOK: query: DROP TEMPORARY FUNCTION example_avg
    92. 

  92. POSTHOOK: type: DROPFUNCTION
    93. 

  93.