PageRenderTime 40ms CodeModel.GetById 19ms RepoModel.GetById 1ms app.codeStats 0ms

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

#
text | 98 lines | 93 code | 5 blank | 0 comment | 0 complexity | 1baf682cc1a4c2a6ad10e20f6884b6f3 MD5 | raw file
Possible License(s): Apache-2.0, BSD-3-Clause, JSON, CPL-1.0 
    

  1. PREHOOK: query: CREATE TABLE dest1(c1 STRING) STORED AS TEXTFILE
    2. 

  2. PREHOOK: type: CREATETABLE
    3. 

  3. POSTHOOK: query: CREATE TABLE dest1(c1 STRING) STORED AS TEXTFILE
    4. 

  4. POSTHOOK: type: CREATETABLE
    5. 

  5. POSTHOOK: Output: default@dest1
    6. 

  6. PREHOOK: query: FROM src INSERT OVERWRITE TABLE dest1 SELECT '  abc  ' WHERE src.key = 86
    7. 

  7. PREHOOK: type: QUERY
    8. 

  8. PREHOOK: Input: default@src
    9. 

  9. PREHOOK: Output: default@dest1
    10. 

  10. POSTHOOK: query: FROM src INSERT OVERWRITE TABLE dest1 SELECT '  abc  ' WHERE src.key = 86
    11. 

  11. POSTHOOK: type: QUERY
    12. 

  12. POSTHOOK: Input: default@src
    13. 

  13. POSTHOOK: Output: default@dest1
    14. 

  14. POSTHOOK: Lineage: dest1.c1 SIMPLE []
    15. 

  15. PREHOOK: query: EXPLAIN
    16. 

  16. SELECT round(1.0), round(1.5), round(-1.5), floor(1.0), floor(1.5), floor(-1.5), sqrt(1.0), sqrt(-1.0), sqrt(0.0), ceil(1.0), ceil(1.5), ceil(-1.5), ceiling(1.0), rand(3), +3, -3, 1++2, 1+-2, ~1 FROM dest1
    17. 

  17. PREHOOK: type: QUERY
    18. 

  18. POSTHOOK: query: EXPLAIN
    19. 

  19. SELECT round(1.0), round(1.5), round(-1.5), floor(1.0), floor(1.5), floor(-1.5), sqrt(1.0), sqrt(-1.0), sqrt(0.0), ceil(1.0), ceil(1.5), ceil(-1.5), ceiling(1.0), rand(3), +3, -3, 1++2, 1+-2, ~1 FROM dest1
    20. 

  20. POSTHOOK: type: QUERY
    21. 

  21. POSTHOOK: Lineage: dest1.c1 SIMPLE []
    22. 

  22. ABSTRACT SYNTAX TREE:
    23. 

  23.   (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME dest1))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION round 1.0)) (TOK_SELEXPR (TOK_FUNCTION round 1.5)) (TOK_SELEXPR (TOK_FUNCTION round (- 1.5))) (TOK_SELEXPR (TOK_FUNCTION floor 1.0)) (TOK_SELEXPR (TOK_FUNCTION floor 1.5)) (TOK_SELEXPR (TOK_FUNCTION floor (- 1.5))) (TOK_SELEXPR (TOK_FUNCTION sqrt 1.0)) (TOK_SELEXPR (TOK_FUNCTION sqrt (- 1.0))) (TOK_SELEXPR (TOK_FUNCTION sqrt 0.0)) (TOK_SELEXPR (TOK_FUNCTION ceil 1.0)) (TOK_SELEXPR (TOK_FUNCTION ceil 1.5)) (TOK_SELEXPR (TOK_FUNCTION ceil (- 1.5))) (TOK_SELEXPR (TOK_FUNCTION ceiling 1.0)) (TOK_SELEXPR (TOK_FUNCTION rand 3)) (TOK_SELEXPR (+ 3)) (TOK_SELEXPR (- 3)) (TOK_SELEXPR (+ 1 (+ 2))) (TOK_SELEXPR (+ 1 (- 2))) (TOK_SELEXPR (~ 1)))))
    24. 

  24. 

  25. STAGE DEPENDENCIES:
    26. 

  26.   Stage-1 is a root stage
    27. 

  27.   Stage-0 is a root stage
    28. 

  28. 

  29. STAGE PLANS:
    30. 

  30.   Stage: Stage-1
    31. 

  31.     Map Reduce
    32. 

  32.       Alias -> Map Operator Tree:
    33. 

  33.         dest1 
    34. 

  34.           TableScan
    35. 

  35.             alias: dest1
    36. 

  36.             Select Operator
    37. 

  37.               expressions:
    38. 

  38.                     expr: round(1.0)
    39. 

  39.                     type: bigint
    40. 

  40.                     expr: round(1.5)
    41. 

  41.                     type: bigint
    42. 

  42.                     expr: round((- 1.5))
    43. 

  43.                     type: bigint
    44. 

  44.                     expr: floor(1.0)
    45. 

  45.                     type: bigint
    46. 

  46.                     expr: floor(1.5)
    47. 

  47.                     type: bigint
    48. 

  48.                     expr: floor((- 1.5))
    49. 

  49.                     type: bigint
    50. 

  50.                     expr: sqrt(1.0)
    51. 

  51.                     type: double
    52. 

  52.                     expr: sqrt((- 1.0))
    53. 

  53.                     type: double
    54. 

  54.                     expr: sqrt(0.0)
    55. 

  55.                     type: double
    56. 

  56.                     expr: ceil(1.0)
    57. 

  57.                     type: bigint
    58. 

  58.                     expr: ceil(1.5)
    59. 

  59.                     type: bigint
    60. 

  60.                     expr: ceil((- 1.5))
    61. 

  61.                     type: bigint
    62. 

  62.                     expr: ceiling(1.0)
    63. 

  63.                     type: bigint
    64. 

  64.                     expr: rand(3)
    65. 

  65.                     type: double
    66. 

  66.                     expr: 3
    67. 

  67.                     type: int
    68. 

  68.                     expr: (- 3)
    69. 

  69.                     type: int
    70. 

  70.                     expr: (1 + 2)
    71. 

  71.                     type: int
    72. 

  72.                     expr: (1 + (- 2))
    73. 

  73.                     type: int
    74. 

  74.                     expr: (~ 1)
    75. 

  75.                     type: int
    76. 

  76.               outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12, _col13, _col14, _col15, _col16, _col17, _col18
    77. 

  77.               File Output Operator
    78. 

  78.                 compressed: false
    79. 

  79.                 GlobalTableId: 0
    80. 

  80.                 table:
    81. 

  81.                     input format: org.apache.hadoop.mapred.TextInputFormat
    82. 

  82.                     output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
    83. 

  83. 

  84.   Stage: Stage-0
    85. 

  85.     Fetch Operator
    86. 

  86.       limit: -1
    87. 

  87. 

  88. 

  89. PREHOOK: query: SELECT round(1.0), round(1.5), round(-1.5), floor(1.0), floor(1.5), floor(-1.5), sqrt(1.0), sqrt(-1.0), sqrt(0.0), ceil(1.0), ceil(1.5), ceil(-1.5), ceiling(1.0), rand(3), +3, -3, 1++2, 1+-2, ~1 FROM dest1
    90. 

  90. PREHOOK: type: QUERY
    91. 

  91. PREHOOK: Input: default@dest1
    92. 

  92. PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-28-37_861_8652505512736578305/-mr-10000
    93. 

  93. POSTHOOK: query: SELECT round(1.0), round(1.5), round(-1.5), floor(1.0), floor(1.5), floor(-1.5), sqrt(1.0), sqrt(-1.0), sqrt(0.0), ceil(1.0), ceil(1.5), ceil(-1.5), ceiling(1.0), rand(3), +3, -3, 1++2, 1+-2, ~1 FROM dest1
    94. 

  94. POSTHOOK: type: QUERY
    95. 

  95. POSTHOOK: Input: default@dest1
    96. 

  96. POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-28-37_861_8652505512736578305/-mr-10000
    97. 

  97. POSTHOOK: Lineage: dest1.c1 SIMPLE []
    98. 

  98. 1	2	-2	1	1	-2	1.0	NULL	0.0	1	2	-1	1	0.731057369148862	3	-3	3	-1	-2
    99. 

  99.