PageRenderTime 88ms CodeModel.GetById 23ms RepoModel.GetById 0ms app.codeStats 0ms

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

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

  1. PREHOOK: query: EXPLAIN SELECT null + 7, 1.0 - null, null + null,
    2. 

  2.                CAST(21 AS BIGINT) % CAST(5 AS TINYINT),
    3. 

  3.                CAST(21 AS BIGINT) % CAST(21 AS BIGINT),
    4. 

  4.                9 % "3" FROM src LIMIT 1
    5. 

  5. PREHOOK: type: QUERY
    6. 

  6. POSTHOOK: query: EXPLAIN SELECT null + 7, 1.0 - null, null + null,
    7. 

  7.                CAST(21 AS BIGINT) % CAST(5 AS TINYINT),
    8. 

  8.                CAST(21 AS BIGINT) % CAST(21 AS BIGINT),
    9. 

  9.                9 % "3" FROM src LIMIT 1
    10. 

  10. POSTHOOK: type: QUERY
    11. 

  11. ABSTRACT SYNTAX TREE:
    12. 

  12.   (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (+ TOK_NULL 7)) (TOK_SELEXPR (- 1.0 TOK_NULL)) (TOK_SELEXPR (+ TOK_NULL TOK_NULL)) (TOK_SELEXPR (% (TOK_FUNCTION TOK_BIGINT 21) (TOK_FUNCTION TOK_TINYINT 5))) (TOK_SELEXPR (% (TOK_FUNCTION TOK_BIGINT 21) (TOK_FUNCTION TOK_BIGINT 21))) (TOK_SELEXPR (% 9 "3"))) (TOK_LIMIT 1)))
    13. 

  13. 

  14. STAGE DEPENDENCIES:
    15. 

  15.   Stage-1 is a root stage
    16. 

  16.   Stage-0 is a root stage
    17. 

  17. 

  18. STAGE PLANS:
    19. 

  19.   Stage: Stage-1
    20. 

  20.     Map Reduce
    21. 

  21.       Alias -> Map Operator Tree:
    22. 

  22.         src 
    23. 

  23.           TableScan
    24. 

  24.             alias: src
    25. 

  25.             Select Operator
    26. 

  26.               expressions:
    27. 

  27.                     expr: (null + 7)
    28. 

  28.                     type: int
    29. 

  29.                     expr: (1.0 - null)
    30. 

  30.                     type: double
    31. 

  31.                     expr: (null + null)
    32. 

  32.                     type: tinyint
    33. 

  33.                     expr: (UDFToLong(21) % UDFToByte(5))
    34. 

  34.                     type: bigint
    35. 

  35.                     expr: (UDFToLong(21) % UDFToLong(21))
    36. 

  36.                     type: bigint
    37. 

  37.                     expr: (9 % '3')
    38. 

  38.                     type: double
    39. 

  39.               outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
    40. 

  40.               Limit
    41. 

  41.                 File Output Operator
    42. 

  42.                   compressed: false
    43. 

  43.                   GlobalTableId: 0
    44. 

  44.                   table:
    45. 

  45.                       input format: org.apache.hadoop.mapred.TextInputFormat
    46. 

  46.                       output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
    47. 

  47. 

  48.   Stage: Stage-0
    49. 

  49.     Fetch Operator
    50. 

  50.       limit: 1
    51. 

  51. 

  52. 

  53. PREHOOK: query: SELECT null + 7, 1.0 - null, null + null,
    54. 

  54.        CAST(21 AS BIGINT) % CAST(5 AS TINYINT),
    55. 

  55.        CAST(21 AS BIGINT) % CAST(21 AS BIGINT),
    56. 

  56.        9 % "3" FROM src LIMIT 1
    57. 

  57. PREHOOK: type: QUERY
    58. 

  58. PREHOOK: Input: default@src
    59. 

  59. PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_16-48-55_797_7464570094193374274/-mr-10000
    60. 

  60. POSTHOOK: query: SELECT null + 7, 1.0 - null, null + null,
    61. 

  61.        CAST(21 AS BIGINT) % CAST(5 AS TINYINT),
    62. 

  62.        CAST(21 AS BIGINT) % CAST(21 AS BIGINT),
    63. 

  63.        9 % "3" FROM src LIMIT 1
    64. 

  64. POSTHOOK: type: QUERY
    65. 

  65. POSTHOOK: Input: default@src
    66. 

  66. POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_16-48-55_797_7464570094193374274/-mr-10000
    67. 

  67. NULL	NULL	NULL	1	0	0.0
    68. 

  68.