PageRenderTime 47ms CodeModel.GetById 19ms RepoModel.GetById 0ms app.codeStats 0ms

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

#
text | 120 lines | 111 code | 9 blank | 0 comment | 0 complexity | ef5dc6818e5901ce73fd7175ce417f9c MD5 | raw file
Possible License(s): Apache-2.0, BSD-3-Clause, JSON, CPL-1.0 
    

  1. PREHOOK: query: CREATE TABLE dest1(key INT, value STRING, mapvalue STRING) STORED AS TEXTFILE
    2. 

  2. PREHOOK: type: CREATETABLE
    3. 

  3. POSTHOOK: query: CREATE TABLE dest1(key INT, value STRING, mapvalue STRING) STORED AS TEXTFILE
    4. 

  4. POSTHOOK: type: CREATETABLE
    5. 

  5. POSTHOOK: Output: default@dest1
    6. 

  6. PREHOOK: query: EXPLAIN
    7. 

  7. FROM src_thrift
    8. 

  8. INSERT OVERWRITE TABLE dest1 SELECT src_thrift.lint[1], src_thrift.lintstring[0].mystring, src_thrift.mstringstring['key_2']
    9. 

  9. PREHOOK: type: QUERY
    10. 

  10. POSTHOOK: query: EXPLAIN
    11. 

  11. FROM src_thrift
    12. 

  12. INSERT OVERWRITE TABLE dest1 SELECT src_thrift.lint[1], src_thrift.lintstring[0].mystring, src_thrift.mstringstring['key_2']
    13. 

  13. POSTHOOK: type: QUERY
    14. 

  14. ABSTRACT SYNTAX TREE:
    15. 

  15.   (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src_thrift))) (TOK_INSERT (TOK_DESTINATION (TOK_TAB (TOK_TABNAME dest1))) (TOK_SELECT (TOK_SELEXPR ([ (. (TOK_TABLE_OR_COL src_thrift) lint) 1)) (TOK_SELEXPR (. ([ (. (TOK_TABLE_OR_COL src_thrift) lintstring) 0) mystring)) (TOK_SELEXPR ([ (. (TOK_TABLE_OR_COL src_thrift) mstringstring) 'key_2')))))
    16. 

  16. 

  17. STAGE DEPENDENCIES:
    18. 

  18.   Stage-1 is a root stage
    19. 

  19.   Stage-5 depends on stages: Stage-1 , consists of Stage-4, Stage-3
    20. 

  20.   Stage-4
    21. 

  21.   Stage-0 depends on stages: Stage-4, Stage-3
    22. 

  22.   Stage-2 depends on stages: Stage-0
    23. 

  23.   Stage-3
    24. 

  24. 

  25. STAGE PLANS:
    26. 

  26.   Stage: Stage-1
    27. 

  27.     Map Reduce
    28. 

  28.       Alias -> Map Operator Tree:
    29. 

  29.         src_thrift 
    30. 

  30.           TableScan
    31. 

  31.             alias: src_thrift
    32. 

  32.             Select Operator
    33. 

  33.               expressions:
    34. 

  34.                     expr: lint[1]
    35. 

  35.                     type: int
    36. 

  36.                     expr: lintstring[0].mystring
    37. 

  37.                     type: string
    38. 

  38.                     expr: mstringstring['key_2']
    39. 

  39.                     type: string
    40. 

  40.               outputColumnNames: _col0, _col1, _col2
    41. 

  41.               File Output Operator
    42. 

  42.                 compressed: false
    43. 

  43.                 GlobalTableId: 1
    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.                     serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
    48. 

  48.                     name: default.dest1
    49. 

  49. 

  50.   Stage: Stage-5
    51. 

  51.     Conditional Operator
    52. 

  52. 

  53.   Stage: Stage-4
    54. 

  54.     Move Operator
    55. 

  55.       files:
    56. 

  56.           hdfs directory: true
    57. 

  57.           destination: pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_16-00-46_704_4766549513524517865/-ext-10000
    58. 

  58. 

  59.   Stage: Stage-0
    60. 

  60.     Move Operator
    61. 

  61.       tables:
    62. 

  62.           replace: true
    63. 

  63.           table:
    64. 

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

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

  66.               serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
    67. 

  67.               name: default.dest1
    68. 

  68. 

  69.   Stage: Stage-2
    70. 

  70.     Stats-Aggr Operator
    71. 

  71. 

  72.   Stage: Stage-3
    73. 

  73.     Map Reduce
    74. 

  74.       Alias -> Map Operator Tree:
    75. 

  75.         pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_16-00-46_704_4766549513524517865/-ext-10002 
    76. 

  76.             File Output Operator
    77. 

  77.               compressed: false
    78. 

  78.               GlobalTableId: 0
    79. 

  79.               table:
    80. 

  80.                   input format: org.apache.hadoop.mapred.TextInputFormat
    81. 

  81.                   output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
    82. 

  82.                   serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
    83. 

  83.                   name: default.dest1
    84. 

  84. 

  85. 

  86. PREHOOK: query: FROM src_thrift
    87. 

  87. INSERT OVERWRITE TABLE dest1 SELECT src_thrift.lint[1], src_thrift.lintstring[0].mystring, src_thrift.mstringstring['key_2']
    88. 

  88. PREHOOK: type: QUERY
    89. 

  89. PREHOOK: Input: default@src_thrift
    90. 

  90. PREHOOK: Output: default@dest1
    91. 

  91. POSTHOOK: query: FROM src_thrift
    92. 

  92. INSERT OVERWRITE TABLE dest1 SELECT src_thrift.lint[1], src_thrift.lintstring[0].mystring, src_thrift.mstringstring['key_2']
    93. 

  93. POSTHOOK: type: QUERY
    94. 

  94. POSTHOOK: Input: default@src_thrift
    95. 

  95. POSTHOOK: Output: default@dest1
    96. 

  96. POSTHOOK: Lineage: dest1.key EXPRESSION [(src_thrift)src_thrift.FieldSchema(name:lint, type:array<int>, comment:from deserializer), ]
    97. 

  97. POSTHOOK: Lineage: dest1.mapvalue EXPRESSION [(src_thrift)src_thrift.FieldSchema(name:mstringstring, type:map<string,string>, comment:from deserializer), ]
    98. 

  98. POSTHOOK: Lineage: dest1.value EXPRESSION [(src_thrift)src_thrift.FieldSchema(name:lintstring, type:array<org.apache.hadoop.hive.serde2.thrift.test.IntString>, comment:from deserializer), ]
    99. 

  99. PREHOOK: query: SELECT dest1.* FROM dest1
    100. 

  100. PREHOOK: type: QUERY
    101. 

  101. PREHOOK: Input: default@dest1
    102. 

  102. PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_16-00-51_408_1129725040190996164/-mr-10000
    103. 

  103. POSTHOOK: query: SELECT dest1.* FROM dest1
    104. 

  104. POSTHOOK: type: QUERY
    105. 

  105. POSTHOOK: Input: default@dest1
    106. 

  106. POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_16-00-51_408_1129725040190996164/-mr-10000
    107. 

  107. POSTHOOK: Lineage: dest1.key EXPRESSION [(src_thrift)src_thrift.FieldSchema(name:lint, type:array<int>, comment:from deserializer), ]
    108. 

  108. POSTHOOK: Lineage: dest1.mapvalue EXPRESSION [(src_thrift)src_thrift.FieldSchema(name:mstringstring, type:map<string,string>, comment:from deserializer), ]
    109. 

  109. POSTHOOK: Lineage: dest1.value EXPRESSION [(src_thrift)src_thrift.FieldSchema(name:lintstring, type:array<org.apache.hadoop.hive.serde2.thrift.test.IntString>, comment:from deserializer), ]
    110. 

  110. 0	0	NULL
    111. 

  111. 2	1	NULL
    112. 

  112. 4	8	value_2
    113. 

  113. 6	27	NULL
    114. 

  114. 8	64	NULL
    115. 

  115. 10	125	NULL
    116. 

  116. 12	216	NULL
    117. 

  117. 14	343	NULL
    118. 

  118. 16	512	NULL
    119. 

  119. 18	729	NULL
    120. 

  120. NULL	NULL	NULL
    121. 

  121.