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

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

#
text | 80 lines | 75 code | 5 blank | 0 comment | 0 complexity | 78b3791197f08ca094255e5ba630cb59 MD5 | raw file
Possible License(s): Apache-2.0, BSD-3-Clause, JSON, CPL-1.0
  1. PREHOOK: query: DESCRIBE FUNCTION rpad
  2. PREHOOK: type: DESCFUNCTION
  3. POSTHOOK: query: DESCRIBE FUNCTION rpad
  4. POSTHOOK: type: DESCFUNCTION
  5. rpad(str, len, pad) - Returns str, right-padded with pad to a length of len
  6. PREHOOK: query: DESCRIBE FUNCTION EXTENDED rpad
  7. PREHOOK: type: DESCFUNCTION
  8. POSTHOOK: query: DESCRIBE FUNCTION EXTENDED rpad
  9. POSTHOOK: type: DESCFUNCTION
  10. rpad(str, len, pad) - Returns str, right-padded with pad to a length of len
  11. If str is longer than len, the return value is shortened to len characters.
  12. Example:
  13. > SELECT rpad('hi', 5, '??') FROM src LIMIT 1;
  14. 'hi???' > SELECT rpad('hi', 1, '??') FROM src LIMIT 1;
  15. 'h'
  16. PREHOOK: query: EXPLAIN SELECT
  17. rpad('hi', 1, '?'),
  18. rpad('hi', 5, '.'),
  19. rpad('hi', 6, '123')
  20. FROM src LIMIT 1
  21. PREHOOK: type: QUERY
  22. POSTHOOK: query: EXPLAIN SELECT
  23. rpad('hi', 1, '?'),
  24. rpad('hi', 5, '.'),
  25. rpad('hi', 6, '123')
  26. FROM src LIMIT 1
  27. POSTHOOK: type: QUERY
  28. ABSTRACT SYNTAX TREE:
  29. (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION rpad 'hi' 1 '?')) (TOK_SELEXPR (TOK_FUNCTION rpad 'hi' 5 '.')) (TOK_SELEXPR (TOK_FUNCTION rpad 'hi' 6 '123'))) (TOK_LIMIT 1)))
  30. STAGE DEPENDENCIES:
  31. Stage-1 is a root stage
  32. Stage-0 is a root stage
  33. STAGE PLANS:
  34. Stage: Stage-1
  35. Map Reduce
  36. Alias -> Map Operator Tree:
  37. src
  38. TableScan
  39. alias: src
  40. Select Operator
  41. expressions:
  42. expr: rpad('hi', 1, '?')
  43. type: string
  44. expr: rpad('hi', 5, '.')
  45. type: string
  46. expr: rpad('hi', 6, '123')
  47. type: string
  48. outputColumnNames: _col0, _col1, _col2
  49. Limit
  50. File Output Operator
  51. compressed: false
  52. GlobalTableId: 0
  53. table:
  54. input format: org.apache.hadoop.mapred.TextInputFormat
  55. output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
  56. Stage: Stage-0
  57. Fetch Operator
  58. limit: 1
  59. PREHOOK: query: SELECT
  60. rpad('hi', 1, '?'),
  61. rpad('hi', 5, '.'),
  62. rpad('hi', 6, '123')
  63. FROM src LIMIT 1
  64. PREHOOK: type: QUERY
  65. PREHOOK: Input: default@src
  66. PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-40-39_701_3392999608689301227/-mr-10000
  67. POSTHOOK: query: SELECT
  68. rpad('hi', 1, '?'),
  69. rpad('hi', 5, '.'),
  70. rpad('hi', 6, '123')
  71. FROM src LIMIT 1
  72. POSTHOOK: type: QUERY
  73. POSTHOOK: Input: default@src
  74. POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-40-39_701_3392999608689301227/-mr-10000
  75. h hi... hi1231