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

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

#
text | 150 lines | 143 code | 7 blank | 0 comment | 0 complexity | e2a0591696eaef7e53dd02f2e969f96a MD5 | raw file
Possible License(s): Apache-2.0, BSD-3-Clause, JSON, CPL-1.0 
    

  1. PREHOOK: query: DESCRIBE FUNCTION reflect
    2. 

  2. PREHOOK: type: DESCFUNCTION
    3. 

  3. POSTHOOK: query: DESCRIBE FUNCTION reflect
    4. 

  4. POSTHOOK: type: DESCFUNCTION
    5. 

  5. reflect(class,method[,arg1[,arg2..]]) calls method with reflection
    6. 

  6. PREHOOK: query: DESCRIBE FUNCTION EXTENDED reflect
    7. 

  7. PREHOOK: type: DESCFUNCTION
    8. 

  8. POSTHOOK: query: DESCRIBE FUNCTION EXTENDED reflect
    9. 

  9. POSTHOOK: type: DESCFUNCTION
    10. 

  10. reflect(class,method[,arg1[,arg2..]]) calls method with reflection
    11. 

  11. Use this UDF to call Java methods by matching the argument signature
    12. 

  12. 

  13. PREHOOK: query: EXPLAIN EXTENDED
    14. 

  14. SELECT reflect("java.lang.String", "valueOf", 1),
    15. 

  15.        reflect("java.lang.String", "isEmpty"),
    16. 

  16.        reflect("java.lang.Math", "max", 2, 3),
    17. 

  17.        reflect("java.lang.Math", "min", 2, 3),
    18. 

  18.        reflect("java.lang.Math", "round", 2.5),
    19. 

  19.        reflect("java.lang.Math", "exp", 1.0),
    20. 

  20.        reflect("java.lang.Math", "floor", 1.9)
    21. 

  21. FROM src LIMIT 1
    22. 

  22. PREHOOK: type: QUERY
    23. 

  23. POSTHOOK: query: EXPLAIN EXTENDED
    24. 

  24. SELECT reflect("java.lang.String", "valueOf", 1),
    25. 

  25.        reflect("java.lang.String", "isEmpty"),
    26. 

  26.        reflect("java.lang.Math", "max", 2, 3),
    27. 

  27.        reflect("java.lang.Math", "min", 2, 3),
    28. 

  28.        reflect("java.lang.Math", "round", 2.5),
    29. 

  29.        reflect("java.lang.Math", "exp", 1.0),
    30. 

  30.        reflect("java.lang.Math", "floor", 1.9)
    31. 

  31. FROM src LIMIT 1
    32. 

  32. POSTHOOK: type: QUERY
    33. 

  33. ABSTRACT SYNTAX TREE:
    34. 

  34.   (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION reflect "java.lang.String" "valueOf" 1)) (TOK_SELEXPR (TOK_FUNCTION reflect "java.lang.String" "isEmpty")) (TOK_SELEXPR (TOK_FUNCTION reflect "java.lang.Math" "max" 2 3)) (TOK_SELEXPR (TOK_FUNCTION reflect "java.lang.Math" "min" 2 3)) (TOK_SELEXPR (TOK_FUNCTION reflect "java.lang.Math" "round" 2.5)) (TOK_SELEXPR (TOK_FUNCTION reflect "java.lang.Math" "exp" 1.0)) (TOK_SELEXPR (TOK_FUNCTION reflect "java.lang.Math" "floor" 1.9))) (TOK_LIMIT 1)))
    35. 

  35. 

  36. STAGE DEPENDENCIES:
    37. 

  37.   Stage-1 is a root stage
    38. 

  38.   Stage-0 is a root stage
    39. 

  39. 

  40. STAGE PLANS:
    41. 

  41.   Stage: Stage-1
    42. 

  42.     Map Reduce
    43. 

  43.       Alias -> Map Operator Tree:
    44. 

  44.         src 
    45. 

  45.           TableScan
    46. 

  46.             alias: src
    47. 

  47.             GatherStats: false
    48. 

  48.             Select Operator
    49. 

  49.               expressions:
    50. 

  50.                     expr: reflect('java.lang.String','valueOf',1)
    51. 

  51.                     type: string
    52. 

  52.                     expr: reflect('java.lang.String','isEmpty')
    53. 

  53.                     type: string
    54. 

  54.                     expr: reflect('java.lang.Math','max',2,3)
    55. 

  55.                     type: string
    56. 

  56.                     expr: reflect('java.lang.Math','min',2,3)
    57. 

  57.                     type: string
    58. 

  58.                     expr: reflect('java.lang.Math','round',2.5)
    59. 

  59.                     type: string
    60. 

  60.                     expr: reflect('java.lang.Math','exp',1.0)
    61. 

  61.                     type: string
    62. 

  62.                     expr: reflect('java.lang.Math','floor',1.9)
    63. 

  63.                     type: string
    64. 

  64.               outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6
    65. 

  65.               Limit
    66. 

  66.                 File Output Operator
    67. 

  67.                   compressed: false
    68. 

  68.                   GlobalTableId: 0
    69. 

  69.                   directory: file:/tmp/sdong/hive_2011-02-10_17-39-58_293_2781390290372198499/-ext-10001
    70. 

  70.                   NumFilesPerFileSink: 1
    71. 

  71.                   Stats Publishing Key Prefix: file:/tmp/sdong/hive_2011-02-10_17-39-58_293_2781390290372198499/-ext-10001/
    72. 

  72.                   table:
    73. 

  73.                       input format: org.apache.hadoop.mapred.TextInputFormat
    74. 

  74.                       output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
    75. 

  75.                       properties:
    76. 

  76.                         columns _col0,_col1,_col2,_col3,_col4,_col5,_col6
    77. 

  77.                         columns.types string:string:string:string:string:string:string
    78. 

  78.                         serialization.format 1
    79. 

  79.                   TotalFiles: 1
    80. 

  80.                   GatherStats: false
    81. 

  81.                   MultiFileSpray: false
    82. 

  82.       Needs Tagging: false
    83. 

  83.       Path -> Alias:
    84. 

  84.         pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src [src]
    85. 

  85.       Path -> Partition:
    86. 

  86.         pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src 
    87. 

  87.           Partition
    88. 

  88.             base file name: src
    89. 

  89.             input format: org.apache.hadoop.mapred.TextInputFormat
    90. 

  90.             output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
    91. 

  91.             properties:
    92. 

  92.               bucket_count -1
    93. 

  93.               columns key,value
    94. 

  94.               columns.types string:string
    95. 

  95.               file.inputformat org.apache.hadoop.mapred.TextInputFormat
    96. 

  96.               file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
    97. 

  97.               location pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src
    98. 

  98.               name default.src
    99. 

  99.               serialization.ddl struct src { string key, string value}
    100. 

  100.               serialization.format 1
    101. 

  101.               serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
    102. 

  102.               transient_lastDdlTime 1297378968
    103. 

  103.             serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
    104. 

  104.           
    105. 

  105.               input format: org.apache.hadoop.mapred.TextInputFormat
    106. 

  106.               output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
    107. 

  107.               properties:
    108. 

  108.                 bucket_count -1
    109. 

  109.                 columns key,value
    110. 

  110.                 columns.types string:string
    111. 

  111.                 file.inputformat org.apache.hadoop.mapred.TextInputFormat
    112. 

  112.                 file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
    113. 

  113.                 location pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src
    114. 

  114.                 name default.src
    115. 

  115.                 serialization.ddl struct src { string key, string value}
    116. 

  116.                 serialization.format 1
    117. 

  117.                 serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
    118. 

  118.                 transient_lastDdlTime 1297378968
    119. 

  119.               serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
    120. 

  120.               name: default.src
    121. 

  121.             name: default.src
    122. 

  122. 

  123.   Stage: Stage-0
    124. 

  124.     Fetch Operator
    125. 

  125.       limit: 1
    126. 

  126. 

  127. 

  128. PREHOOK: query: SELECT reflect("java.lang.String", "valueOf", 1),
    129. 

  129.        reflect("java.lang.String", "isEmpty"),
    130. 

  130.        reflect("java.lang.Math", "max", 2, 3),
    131. 

  131.        reflect("java.lang.Math", "min", 2, 3),
    132. 

  132.        reflect("java.lang.Math", "round", 2.5),
    133. 

  133.        reflect("java.lang.Math", "exp", 1.0),
    134. 

  134.        reflect("java.lang.Math", "floor", 1.9)
    135. 

  135. FROM src LIMIT 1
    136. 

  136. PREHOOK: type: QUERY
    137. 

  137. PREHOOK: Input: default@src
    138. 

  138. PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-39-58_382_6716753430415370105/-mr-10000
    139. 

  139. POSTHOOK: query: SELECT reflect("java.lang.String", "valueOf", 1),
    140. 

  140.        reflect("java.lang.String", "isEmpty"),
    141. 

  141.        reflect("java.lang.Math", "max", 2, 3),
    142. 

  142.        reflect("java.lang.Math", "min", 2, 3),
    143. 

  143.        reflect("java.lang.Math", "round", 2.5),
    144. 

  144.        reflect("java.lang.Math", "exp", 1.0),
    145. 

  145.        reflect("java.lang.Math", "floor", 1.9)
    146. 

  146. FROM src LIMIT 1
    147. 

  147. POSTHOOK: type: QUERY
    148. 

  148. POSTHOOK: Input: default@src
    149. 

  149. POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-39-58_382_6716753430415370105/-mr-10000
    150. 

  150. 1	true	3	2	3	2.7182818284590455	1.0
    151. 

  151.