PageRenderTime 42ms CodeModel.GetById 17ms RepoModel.GetById 0ms app.codeStats 0ms

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

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

  1. PREHOOK: query: CREATE TABLE src_null(a STRING, b STRING, c STRING, d STRING) STORED AS TEXTFILE
    2. 

  2. PREHOOK: type: CREATETABLE
    3. 

  3. POSTHOOK: query: CREATE TABLE src_null(a STRING, b STRING, c STRING, d STRING) STORED AS TEXTFILE
    4. 

  4. POSTHOOK: type: CREATETABLE
    5. 

  5. POSTHOOK: Output: default@src_null
    6. 

  6. PREHOOK: query: LOAD DATA LOCAL INPATH '../data/files/null.txt' INTO TABLE src_null
    7. 

  7. PREHOOK: type: LOAD
    8. 

  8. PREHOOK: Output: default@src_null
    9. 

  9. POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/null.txt' INTO TABLE src_null
    10. 

  10. POSTHOOK: type: LOAD
    11. 

  11. POSTHOOK: Output: default@src_null
    12. 

  12. PREHOOK: query: EXPLAIN SELECT * FROM src_null DISTRIBUTE BY c SORT BY d
    13. 

  13. PREHOOK: type: QUERY
    14. 

  14. POSTHOOK: query: EXPLAIN SELECT * FROM src_null DISTRIBUTE BY c SORT BY d
    15. 

  15. POSTHOOK: type: QUERY
    16. 

  16. ABSTRACT SYNTAX TREE:
    17. 

  17.   (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src_null))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR TOK_ALLCOLREF)) (TOK_DISTRIBUTEBY (TOK_TABLE_OR_COL c)) (TOK_SORTBY (TOK_TABSORTCOLNAMEASC (TOK_TABLE_OR_COL d)))))
    18. 

  18. 

  19. STAGE DEPENDENCIES:
    20. 

  20.   Stage-1 is a root stage
    21. 

  21.   Stage-0 is a root stage
    22. 

  22. 

  23. STAGE PLANS:
    24. 

  24.   Stage: Stage-1
    25. 

  25.     Map Reduce
    26. 

  26.       Alias -> Map Operator Tree:
    27. 

  27.         src_null 
    28. 

  28.           TableScan
    29. 

  29.             alias: src_null
    30. 

  30.             Select Operator
    31. 

  31.               expressions:
    32. 

  32.                     expr: a
    33. 

  33.                     type: string
    34. 

  34.                     expr: b
    35. 

  35.                     type: string
    36. 

  36.                     expr: c
    37. 

  37.                     type: string
    38. 

  38.                     expr: d
    39. 

  39.                     type: string
    40. 

  40.               outputColumnNames: _col0, _col1, _col2, _col3
    41. 

  41.               Reduce Output Operator
    42. 

  42.                 key expressions:
    43. 

  43.                       expr: _col3
    44. 

  44.                       type: string
    45. 

  45.                 sort order: +
    46. 

  46.                 Map-reduce partition columns:
    47. 

  47.                       expr: _col2
    48. 

  48.                       type: string
    49. 

  49.                 tag: -1
    50. 

  50.                 value expressions:
    51. 

  51.                       expr: _col0
    52. 

  52.                       type: string
    53. 

  53.                       expr: _col1
    54. 

  54.                       type: string
    55. 

  55.                       expr: _col2
    56. 

  56.                       type: string
    57. 

  57.                       expr: _col3
    58. 

  58.                       type: string
    59. 

  59.       Reduce Operator Tree:
    60. 

  60.         Extract
    61. 

  61.           File Output Operator
    62. 

  62.             compressed: false
    63. 

  63.             GlobalTableId: 0
    64. 

  64.             table:
    65. 

  65.                 input format: org.apache.hadoop.mapred.TextInputFormat
    66. 

  66.                 output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
    67. 

  67. 

  68.   Stage: Stage-0
    69. 

  69.     Fetch Operator
    70. 

  70.       limit: -1
    71. 

  71. 

  72. 

  73. PREHOOK: query: SELECT * FROM src_null DISTRIBUTE BY c SORT BY d
    74. 

  74. PREHOOK: type: QUERY
    75. 

  75. PREHOOK: Input: default@src_null
    76. 

  76. PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_23-43-04_093_3744625047385355137/-mr-10000
    77. 

  77. POSTHOOK: query: SELECT * FROM src_null DISTRIBUTE BY c SORT BY d
    78. 

  78. POSTHOOK: type: QUERY
    79. 

  79. POSTHOOK: Input: default@src_null
    80. 

  80. POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_23-43-04_093_3744625047385355137/-mr-10000
    81. 

  81. 1.0	1	same	0
    82. 

  82. 1.0	1	same	1
    83. 

  83. 1.0	1	same	2
    84. 

  84. 1.0	1	same	3
    85. 

  85. 1.0	1	same	4
    86. 

  86. NULL	1	same	5
    87. 

  87. NULL	NULL	same	6
    88. 

  88. 1.0	NULL	same	7
    89. 

  89. 1.0	1	same	8
    90. 

  90. 1.0	1	same	9
    91. 

  91.