PageRenderTime 49ms CodeModel.GetById 25ms RepoModel.GetById 0ms app.codeStats 0ms

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

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

  1. PREHOOK: query: CREATE TABLE dest1(lint_size INT, lintstring_size INT, mstringstring_size INT) STORED AS TEXTFILE
    2. 

  2. PREHOOK: type: CREATETABLE
    3. 

  3. POSTHOOK: query: CREATE TABLE dest1(lint_size INT, lintstring_size INT, mstringstring_size INT) 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 size(src_thrift.lint), size(src_thrift.lintstring), size(src_thrift.mstringstring) where src_thrift.lint IS NOT NULL AND NOT (src_thrift.mstringstring IS NULL)
    9. 

  9. PREHOOK: type: QUERY
    10. 

  10. POSTHOOK: query: EXPLAIN
    11. 

  11. FROM src_thrift
    12. 

  12. INSERT OVERWRITE TABLE dest1 SELECT size(src_thrift.lint), size(src_thrift.lintstring), size(src_thrift.mstringstring) where src_thrift.lint IS NOT NULL AND NOT (src_thrift.mstringstring IS NULL)
    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_FUNCTION size (. (TOK_TABLE_OR_COL src_thrift) lint))) (TOK_SELEXPR (TOK_FUNCTION size (. (TOK_TABLE_OR_COL src_thrift) lintstring))) (TOK_SELEXPR (TOK_FUNCTION size (. (TOK_TABLE_OR_COL src_thrift) mstringstring)))) (TOK_WHERE (AND (TOK_FUNCTION TOK_ISNOTNULL (. (TOK_TABLE_OR_COL src_thrift) lint)) (NOT (TOK_FUNCTION TOK_ISNULL (. (TOK_TABLE_OR_COL src_thrift) mstringstring)))))))
    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.             Filter Operator
    33. 

  33.               predicate:
    34. 

  34.                   expr: (lint is not null and (not mstringstring is null))
    35. 

  35.                   type: boolean
    36. 

  36.               Filter Operator
    37. 

  37.                 predicate:
    38. 

  38.                     expr: (lint is not null and (not mstringstring is null))
    39. 

  39.                     type: boolean
    40. 

  40.                 Select Operator
    41. 

  41.                   expressions:
    42. 

  42.                         expr: size(lint)
    43. 

  43.                         type: int
    44. 

  44.                         expr: size(lintstring)
    45. 

  45.                         type: int
    46. 

  46.                         expr: size(mstringstring)
    47. 

  47.                         type: int
    48. 

  48.                   outputColumnNames: _col0, _col1, _col2
    49. 

  49.                   File Output Operator
    50. 

  50.                     compressed: false
    51. 

  51.                     GlobalTableId: 1
    52. 

  52.                     table:
    53. 

  53.                         input format: org.apache.hadoop.mapred.TextInputFormat
    54. 

  54.                         output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
    55. 

  55.                         serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
    56. 

  56.                         name: default.dest1
    57. 

  57. 

  58.   Stage: Stage-5
    59. 

  59.     Conditional Operator
    60. 

  60. 

  61.   Stage: Stage-4
    62. 

  62.     Move Operator
    63. 

  63.       files:
    64. 

  64.           hdfs directory: true
    65. 

  65.           destination: pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_16-00-52_022_1356599412846277755/-ext-10000
    66. 

  66. 

  67.   Stage: Stage-0
    68. 

  68.     Move Operator
    69. 

  69.       tables:
    70. 

  70.           replace: true
    71. 

  71.           table:
    72. 

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

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

  74.               serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
    75. 

  75.               name: default.dest1
    76. 

  76. 

  77.   Stage: Stage-2
    78. 

  78.     Stats-Aggr Operator
    79. 

  79. 

  80.   Stage: Stage-3
    81. 

  81.     Map Reduce
    82. 

  82.       Alias -> Map Operator Tree:
    83. 

  83.         pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_16-00-52_022_1356599412846277755/-ext-10002 
    84. 

  84.             File Output Operator
    85. 

  85.               compressed: false
    86. 

  86.               GlobalTableId: 0
    87. 

  87.               table:
    88. 

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

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

  90.                   serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
    91. 

  91.                   name: default.dest1
    92. 

  92. 

  93. 

  94. PREHOOK: query: FROM src_thrift
    95. 

  95. INSERT OVERWRITE TABLE dest1 SELECT size(src_thrift.lint), size(src_thrift.lintstring), size(src_thrift.mstringstring) where src_thrift.lint IS NOT NULL AND NOT (src_thrift.mstringstring IS NULL)
    96. 

  96. PREHOOK: type: QUERY
    97. 

  97. PREHOOK: Input: default@src_thrift
    98. 

  98. PREHOOK: Output: default@dest1
    99. 

  99. POSTHOOK: query: FROM src_thrift
    100. 

  100. INSERT OVERWRITE TABLE dest1 SELECT size(src_thrift.lint), size(src_thrift.lintstring), size(src_thrift.mstringstring) where src_thrift.lint IS NOT NULL AND NOT (src_thrift.mstringstring IS NULL)
    101. 

  101. POSTHOOK: type: QUERY
    102. 

  102. POSTHOOK: Input: default@src_thrift
    103. 

  103. POSTHOOK: Output: default@dest1
    104. 

  104. POSTHOOK: Lineage: dest1.lint_size EXPRESSION [(src_thrift)src_thrift.FieldSchema(name:lint, type:array<int>, comment:from deserializer), ]
    105. 

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

  106. POSTHOOK: Lineage: dest1.mstringstring_size EXPRESSION [(src_thrift)src_thrift.FieldSchema(name:mstringstring, type:map<string,string>, comment:from deserializer), ]
    107. 

  107. PREHOOK: query: SELECT dest1.* FROM dest1
    108. 

  108. PREHOOK: type: QUERY
    109. 

  109. PREHOOK: Input: default@dest1
    110. 

  110. PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_16-00-56_761_7597331630264632053/-mr-10000
    111. 

  111. POSTHOOK: query: SELECT dest1.* FROM dest1
    112. 

  112. POSTHOOK: type: QUERY
    113. 

  113. POSTHOOK: Input: default@dest1
    114. 

  114. POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_16-00-56_761_7597331630264632053/-mr-10000
    115. 

  115. POSTHOOK: Lineage: dest1.lint_size EXPRESSION [(src_thrift)src_thrift.FieldSchema(name:lint, type:array<int>, comment:from deserializer), ]
    116. 

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

  117. POSTHOOK: Lineage: dest1.mstringstring_size EXPRESSION [(src_thrift)src_thrift.FieldSchema(name:mstringstring, type:map<string,string>, comment:from deserializer), ]
    118. 

  118. 3	1	1
    119. 

  119. 3	1	1
    120. 

  120. 3	1	1
    121. 

  121. 3	1	1
    122. 

  122. 3	1	1
    123. 

  123. 3	1	1
    124. 

  124. 3	1	1
    125. 

  125. 3	1	1
    126. 

  126. 3	1	1
    127. 

  127. 3	1	1
    128. 

  128.