PageRenderTime 34ms CodeModel.GetById 11ms RepoModel.GetById 0ms app.codeStats 0ms

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

#
text | 140 lines | 128 code | 12 blank | 0 comment | 0 complexity | 622f49aa7955e8e8f333bda3a6b010a6 MD5 | raw file
Possible License(s): Apache-2.0, BSD-3-Clause, JSON, CPL-1.0 
    

  1. PREHOOK: query: explain 
    2. 

  2. select radians(57.2958) FROM src LIMIT 1
    3. 

  3. PREHOOK: type: QUERY
    4. 

  4. POSTHOOK: query: explain 
    5. 

  5. select radians(57.2958) FROM src LIMIT 1
    6. 

  6. POSTHOOK: type: QUERY
    7. 

  7. ABSTRACT SYNTAX TREE:
    8. 

  8.   (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION radians 57.2958))) (TOK_LIMIT 1)))
    9. 

  9. 

  10. STAGE DEPENDENCIES:
    11. 

  11.   Stage-1 is a root stage
    12. 

  12.   Stage-0 is a root stage
    13. 

  13. 

  14. STAGE PLANS:
    15. 

  15.   Stage: Stage-1
    16. 

  16.     Map Reduce
    17. 

  17.       Alias -> Map Operator Tree:
    18. 

  18.         src 
    19. 

  19.           TableScan
    20. 

  20.             alias: src
    21. 

  21.             Select Operator
    22. 

  22.               expressions:
    23. 

  23.                     expr: radians(57.2958)
    24. 

  24.                     type: double
    25. 

  25.               outputColumnNames: _col0
    26. 

  26.               Limit
    27. 

  27.                 File Output Operator
    28. 

  28.                   compressed: false
    29. 

  29.                   GlobalTableId: 0
    30. 

  30.                   table:
    31. 

  31.                       input format: org.apache.hadoop.mapred.TextInputFormat
    32. 

  32.                       output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
    33. 

  33. 

  34.   Stage: Stage-0
    35. 

  35.     Fetch Operator
    36. 

  36.       limit: 1
    37. 

  37. 

  38. 

  39. PREHOOK: query: select radians(57.2958) FROM src LIMIT 1
    40. 

  40. PREHOOK: type: QUERY
    41. 

  41. PREHOOK: Input: default@src
    42. 

  42. PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-39-44_078_9109783333773553444/-mr-10000
    43. 

  43. POSTHOOK: query: select radians(57.2958) FROM src LIMIT 1
    44. 

  44. POSTHOOK: type: QUERY
    45. 

  45. POSTHOOK: Input: default@src
    46. 

  46. POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-39-44_078_9109783333773553444/-mr-10000
    47. 

  47. 1.000000357564167
    48. 

  48. PREHOOK: query: select radians(143.2394) FROM src LIMIT 1
    49. 

  49. PREHOOK: type: QUERY
    50. 

  50. PREHOOK: Input: default@src
    51. 

  51. PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-39-47_306_1941990909459019781/-mr-10000
    52. 

  52. POSTHOOK: query: select radians(143.2394) FROM src LIMIT 1
    53. 

  53. POSTHOOK: type: QUERY
    54. 

  54. POSTHOOK: Input: default@src
    55. 

  55. POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-39-47_306_1941990909459019781/-mr-10000
    56. 

  56. 2.4999991485811655
    57. 

  57. PREHOOK: query: DESCRIBE FUNCTION radians
    58. 

  58. PREHOOK: type: DESCFUNCTION
    59. 

  59. POSTHOOK: query: DESCRIBE FUNCTION radians
    60. 

  60. POSTHOOK: type: DESCFUNCTION
    61. 

  61. radians(x) - Converts degrees to radians
    62. 

  62. PREHOOK: query: DESCRIBE FUNCTION EXTENDED radians
    63. 

  63. PREHOOK: type: DESCFUNCTION
    64. 

  64. POSTHOOK: query: DESCRIBE FUNCTION EXTENDED radians
    65. 

  65. POSTHOOK: type: DESCFUNCTION
    66. 

  66. radians(x) - Converts degrees to radians
    67. 

  67. Example:
    68. 

  68.   > SELECT radians(90) FROM src LIMIT 1;
    69. 

  69.   1.5707963267949mo
    70. 

  70. 

  71. PREHOOK: query: explain 
    72. 

  72. select radians(57.2958) FROM src LIMIT 1
    73. 

  73. PREHOOK: type: QUERY
    74. 

  74. POSTHOOK: query: explain 
    75. 

  75. select radians(57.2958) FROM src LIMIT 1
    76. 

  76. POSTHOOK: type: QUERY
    77. 

  77. ABSTRACT SYNTAX TREE:
    78. 

  78.   (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION radians 57.2958))) (TOK_LIMIT 1)))
    79. 

  79. 

  80. STAGE DEPENDENCIES:
    81. 

  81.   Stage-1 is a root stage
    82. 

  82.   Stage-0 is a root stage
    83. 

  83. 

  84. STAGE PLANS:
    85. 

  85.   Stage: Stage-1
    86. 

  86.     Map Reduce
    87. 

  87.       Alias -> Map Operator Tree:
    88. 

  88.         src 
    89. 

  89.           TableScan
    90. 

  90.             alias: src
    91. 

  91.             Select Operator
    92. 

  92.               expressions:
    93. 

  93.                     expr: radians(57.2958)
    94. 

  94.                     type: double
    95. 

  95.               outputColumnNames: _col0
    96. 

  96.               Limit
    97. 

  97.                 File Output Operator
    98. 

  98.                   compressed: false
    99. 

  99.                   GlobalTableId: 0
    100. 

  100.                   table:
    101. 

  101.                       input format: org.apache.hadoop.mapred.TextInputFormat
    102. 

  102.                       output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
    103. 

  103. 

  104.   Stage: Stage-0
    105. 

  105.     Fetch Operator
    106. 

  106.       limit: 1
    107. 

  107. 

  108. 

  109. PREHOOK: query: select radians(57.2958) FROM src LIMIT 1
    110. 

  110. PREHOOK: type: QUERY
    111. 

  111. PREHOOK: Input: default@src
    112. 

  112. PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-39-50_816_7653095422070360785/-mr-10000
    113. 

  113. POSTHOOK: query: select radians(57.2958) FROM src LIMIT 1
    114. 

  114. POSTHOOK: type: QUERY
    115. 

  115. POSTHOOK: Input: default@src
    116. 

  116. POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-39-50_816_7653095422070360785/-mr-10000
    117. 

  117. 1.000000357564167
    118. 

  118. PREHOOK: query: select radians(143.2394) FROM src LIMIT 1
    119. 

  119. PREHOOK: type: QUERY
    120. 

  120. PREHOOK: Input: default@src
    121. 

  121. PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-39-54_090_7082105358146623132/-mr-10000
    122. 

  122. POSTHOOK: query: select radians(143.2394) FROM src LIMIT 1
    123. 

  123. POSTHOOK: type: QUERY
    124. 

  124. POSTHOOK: Input: default@src
    125. 

  125. POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-39-54_090_7082105358146623132/-mr-10000
    126. 

  126. 2.4999991485811655
    127. 

  127. PREHOOK: query: DESCRIBE FUNCTION radians
    128. 

  128. PREHOOK: type: DESCFUNCTION
    129. 

  129. POSTHOOK: query: DESCRIBE FUNCTION radians
    130. 

  130. POSTHOOK: type: DESCFUNCTION
    131. 

  131. radians(x) - Converts degrees to radians
    132. 

  132. PREHOOK: query: DESCRIBE FUNCTION EXTENDED radians
    133. 

  133. PREHOOK: type: DESCFUNCTION
    134. 

  134. POSTHOOK: query: DESCRIBE FUNCTION EXTENDED radians
    135. 

  135. POSTHOOK: type: DESCFUNCTION
    136. 

  136. radians(x) - Converts degrees to radians
    137. 

  137. Example:
    138. 

  138.   > SELECT radians(90) FROM src LIMIT 1;
    139. 

  139.   1.5707963267949mo
    140. 

  140. 

  141.