PageRenderTime 45ms CodeModel.GetById 17ms RepoModel.GetById 1ms app.codeStats 0ms

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

#
text | 130 lines | 125 code | 5 blank | 0 comment | 0 complexity | d1062a74a49959a5615ce54f067566b0 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. PREHOOK: type: CREATETABLE
  3. POSTHOOK: query: CREATE TABLE dest1(c1 STRING) STORED AS TEXTFILE
  4. POSTHOOK: type: CREATETABLE
  5. POSTHOOK: Output: default@dest1
  6. PREHOOK: query: FROM src INSERT OVERWRITE TABLE dest1 SELECT ' abc ' WHERE src.key = 86
  7. PREHOOK: type: QUERY
  8. PREHOOK: Input: default@src
  9. PREHOOK: Output: default@dest1
  10. POSTHOOK: query: FROM src INSERT OVERWRITE TABLE dest1 SELECT ' abc ' WHERE src.key = 86
  11. POSTHOOK: type: QUERY
  12. POSTHOOK: Input: default@src
  13. POSTHOOK: Output: default@dest1
  14. POSTHOOK: Lineage: dest1.c1 SIMPLE []
  15. PREHOOK: query: EXPLAIN
  16. SELECT ROUND(LN(3.0),12), LN(0.0), LN(-1), ROUND(LOG(3.0),12), LOG(0.0),
  17. LOG(-1), ROUND(LOG2(3.0),12), LOG2(0.0), LOG2(-1),
  18. ROUND(LOG10(3.0),12), LOG10(0.0), LOG10(-1), ROUND(LOG(2, 3.0),12),
  19. LOG(2, 0.0), LOG(2, -1), LOG(0.5, 2), LOG(2, 0.5), ROUND(EXP(2.0),12),
  20. POW(2,3), POWER(2,3), POWER(2,-3), POWER(0.5, -3), POWER(4, 0.5),
  21. POWER(-1, 0.5), POWER(-1, 2) FROM dest1
  22. PREHOOK: type: QUERY
  23. POSTHOOK: query: EXPLAIN
  24. SELECT ROUND(LN(3.0),12), LN(0.0), LN(-1), ROUND(LOG(3.0),12), LOG(0.0),
  25. LOG(-1), ROUND(LOG2(3.0),12), LOG2(0.0), LOG2(-1),
  26. ROUND(LOG10(3.0),12), LOG10(0.0), LOG10(-1), ROUND(LOG(2, 3.0),12),
  27. LOG(2, 0.0), LOG(2, -1), LOG(0.5, 2), LOG(2, 0.5), ROUND(EXP(2.0),12),
  28. POW(2,3), POWER(2,3), POWER(2,-3), POWER(0.5, -3), POWER(4, 0.5),
  29. POWER(-1, 0.5), POWER(-1, 2) FROM dest1
  30. POSTHOOK: type: QUERY
  31. POSTHOOK: Lineage: dest1.c1 SIMPLE []
  32. ABSTRACT SYNTAX TREE:
  33. (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 (TOK_FUNCTION LN 3.0) 12)) (TOK_SELEXPR (TOK_FUNCTION LN 0.0)) (TOK_SELEXPR (TOK_FUNCTION LN (- 1))) (TOK_SELEXPR (TOK_FUNCTION ROUND (TOK_FUNCTION LOG 3.0) 12)) (TOK_SELEXPR (TOK_FUNCTION LOG 0.0)) (TOK_SELEXPR (TOK_FUNCTION LOG (- 1))) (TOK_SELEXPR (TOK_FUNCTION ROUND (TOK_FUNCTION LOG2 3.0) 12)) (TOK_SELEXPR (TOK_FUNCTION LOG2 0.0)) (TOK_SELEXPR (TOK_FUNCTION LOG2 (- 1))) (TOK_SELEXPR (TOK_FUNCTION ROUND (TOK_FUNCTION LOG10 3.0) 12)) (TOK_SELEXPR (TOK_FUNCTION LOG10 0.0)) (TOK_SELEXPR (TOK_FUNCTION LOG10 (- 1))) (TOK_SELEXPR (TOK_FUNCTION ROUND (TOK_FUNCTION LOG 2 3.0) 12)) (TOK_SELEXPR (TOK_FUNCTION LOG 2 0.0)) (TOK_SELEXPR (TOK_FUNCTION LOG 2 (- 1))) (TOK_SELEXPR (TOK_FUNCTION LOG 0.5 2)) (TOK_SELEXPR (TOK_FUNCTION LOG 2 0.5)) (TOK_SELEXPR (TOK_FUNCTION ROUND (TOK_FUNCTION EXP 2.0) 12)) (TOK_SELEXPR (TOK_FUNCTION POW 2 3)) (TOK_SELEXPR (TOK_FUNCTION POWER 2 3)) (TOK_SELEXPR (TOK_FUNCTION POWER 2 (- 3))) (TOK_SELEXPR (TOK_FUNCTION POWER 0.5 (- 3))) (TOK_SELEXPR (TOK_FUNCTION POWER 4 0.5)) (TOK_SELEXPR (TOK_FUNCTION POWER (- 1) 0.5)) (TOK_SELEXPR (TOK_FUNCTION POWER (- 1) 2)))))
  34. STAGE DEPENDENCIES:
  35. Stage-1 is a root stage
  36. Stage-0 is a root stage
  37. STAGE PLANS:
  38. Stage: Stage-1
  39. Map Reduce
  40. Alias -> Map Operator Tree:
  41. dest1
  42. TableScan
  43. alias: dest1
  44. Select Operator
  45. expressions:
  46. expr: round(ln(3.0), 12)
  47. type: double
  48. expr: ln(0.0)
  49. type: double
  50. expr: ln((- 1))
  51. type: double
  52. expr: round(log(3.0), 12)
  53. type: double
  54. expr: log(0.0)
  55. type: double
  56. expr: log((- 1))
  57. type: double
  58. expr: round(log2(3.0), 12)
  59. type: double
  60. expr: log2(0.0)
  61. type: double
  62. expr: log2((- 1))
  63. type: double
  64. expr: round(log10(3.0), 12)
  65. type: double
  66. expr: log10(0.0)
  67. type: double
  68. expr: log10((- 1))
  69. type: double
  70. expr: round(log(2, 3.0), 12)
  71. type: double
  72. expr: log(2, 0.0)
  73. type: double
  74. expr: log(2, (- 1))
  75. type: double
  76. expr: log(0.5, 2)
  77. type: double
  78. expr: log(2, 0.5)
  79. type: double
  80. expr: round(exp(2.0), 12)
  81. type: double
  82. expr: pow(2, 3)
  83. type: double
  84. expr: power(2, 3)
  85. type: double
  86. expr: power(2, (- 3))
  87. type: double
  88. expr: power(0.5, (- 3))
  89. type: double
  90. expr: power(4, 0.5)
  91. type: double
  92. expr: power((- 1), 0.5)
  93. type: double
  94. expr: power((- 1), 2)
  95. type: double
  96. outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12, _col13, _col14, _col15, _col16, _col17, _col18, _col19, _col20, _col21, _col22, _col23, _col24
  97. File Output Operator
  98. compressed: false
  99. GlobalTableId: 0
  100. table:
  101. input format: org.apache.hadoop.mapred.TextInputFormat
  102. output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
  103. Stage: Stage-0
  104. Fetch Operator
  105. limit: -1
  106. PREHOOK: query: SELECT ROUND(LN(3.0),12), LN(0.0), LN(-1), ROUND(LOG(3.0),12), LOG(0.0),
  107. LOG(-1), ROUND(LOG2(3.0),12), LOG2(0.0), LOG2(-1),
  108. ROUND(LOG10(3.0),12), LOG10(0.0), LOG10(-1), ROUND(LOG(2, 3.0),12),
  109. LOG(2, 0.0), LOG(2, -1), LOG(0.5, 2), LOG(2, 0.5), ROUND(EXP(2.0),12),
  110. POW(2,3), POWER(2,3), POWER(2,-3), POWER(0.5, -3), POWER(4, 0.5),
  111. POWER(-1, 0.5), POWER(-1, 2) FROM dest1
  112. PREHOOK: type: QUERY
  113. PREHOOK: Input: default@dest1
  114. PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-29-10_985_284171380044338731/-mr-10000
  115. POSTHOOK: query: SELECT ROUND(LN(3.0),12), LN(0.0), LN(-1), ROUND(LOG(3.0),12), LOG(0.0),
  116. LOG(-1), ROUND(LOG2(3.0),12), LOG2(0.0), LOG2(-1),
  117. ROUND(LOG10(3.0),12), LOG10(0.0), LOG10(-1), ROUND(LOG(2, 3.0),12),
  118. LOG(2, 0.0), LOG(2, -1), LOG(0.5, 2), LOG(2, 0.5), ROUND(EXP(2.0),12),
  119. POW(2,3), POWER(2,3), POWER(2,-3), POWER(0.5, -3), POWER(4, 0.5),
  120. POWER(-1, 0.5), POWER(-1, 2) FROM dest1
  121. POSTHOOK: type: QUERY
  122. POSTHOOK: Input: default@dest1
  123. POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-29-10_985_284171380044338731/-mr-10000
  124. POSTHOOK: Lineage: dest1.c1 SIMPLE []
  125. 1.098612288668 NULL NULL 1.098612288668 NULL NULL 1.584962500721 NULL NULL 0.47712125472 NULL NULL 1.584962500721 NULL NULL NULL -1.0 7.389056098931 8.0 8.0 0.125 8.0 2.0 NaN 1.0