/tags/release-0.2.0-rc0/hive/external/ql/src/test/results/clientpositive/input8.q.out
text | 143 lines | 134 code | 9 blank | 0 comment | 0 complexity | 27923fe7c46ecbbfce4a19ed996938c6 MD5 | raw file
Possible License(s): Apache-2.0, BSD-3-Clause, JSON, CPL-1.0
- PREHOOK: query: CREATE TABLE dest1(c1 STRING, c2 INT, c3 DOUBLE) STORED AS TEXTFILE
- PREHOOK: type: CREATETABLE
- POSTHOOK: query: CREATE TABLE dest1(c1 STRING, c2 INT, c3 DOUBLE) STORED AS TEXTFILE
- POSTHOOK: type: CREATETABLE
- POSTHOOK: Output: default@dest1
- PREHOOK: query: EXPLAIN
- FROM src1
- INSERT OVERWRITE TABLE dest1 SELECT 4 + NULL, src1.key - NULL, NULL + NULL
- PREHOOK: type: QUERY
- POSTHOOK: query: EXPLAIN
- FROM src1
- INSERT OVERWRITE TABLE dest1 SELECT 4 + NULL, src1.key - NULL, NULL + NULL
- POSTHOOK: type: QUERY
- ABSTRACT SYNTAX TREE:
- (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src1))) (TOK_INSERT (TOK_DESTINATION (TOK_TAB (TOK_TABNAME dest1))) (TOK_SELECT (TOK_SELEXPR (+ 4 TOK_NULL)) (TOK_SELEXPR (- (. (TOK_TABLE_OR_COL src1) key) TOK_NULL)) (TOK_SELEXPR (+ TOK_NULL TOK_NULL)))))
- STAGE DEPENDENCIES:
- Stage-1 is a root stage
- Stage-5 depends on stages: Stage-1 , consists of Stage-4, Stage-3
- Stage-4
- Stage-0 depends on stages: Stage-4, Stage-3
- Stage-2 depends on stages: Stage-0
- Stage-3
- STAGE PLANS:
- Stage: Stage-1
- Map Reduce
- Alias -> Map Operator Tree:
- src1
- TableScan
- alias: src1
- Select Operator
- expressions:
- expr: (4 + null)
- type: int
- expr: (key - null)
- type: double
- expr: (null + null)
- type: tinyint
- outputColumnNames: _col0, _col1, _col2
- Select Operator
- expressions:
- expr: _col0
- type: int
- expr: UDFToInteger(_col1)
- type: int
- expr: UDFToDouble(_col2)
- type: double
- outputColumnNames: _col0, _col1, _col2
- File Output Operator
- compressed: false
- GlobalTableId: 1
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- name: default.dest1
- Stage: Stage-5
- Conditional Operator
- Stage: Stage-4
- Move Operator
- files:
- hdfs directory: true
- destination: pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_15-58-29_945_2393196627067798243/-ext-10000
- Stage: Stage-0
- Move Operator
- tables:
- replace: true
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- name: default.dest1
- Stage: Stage-2
- Stats-Aggr Operator
- Stage: Stage-3
- Map Reduce
- Alias -> Map Operator Tree:
- pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_15-58-29_945_2393196627067798243/-ext-10002
- File Output Operator
- compressed: false
- GlobalTableId: 0
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- name: default.dest1
- PREHOOK: query: FROM src1
- INSERT OVERWRITE TABLE dest1 SELECT 4 + NULL, src1.key - NULL, NULL + NULL
- PREHOOK: type: QUERY
- PREHOOK: Input: default@src1
- PREHOOK: Output: default@dest1
- POSTHOOK: query: FROM src1
- INSERT OVERWRITE TABLE dest1 SELECT 4 + NULL, src1.key - NULL, NULL + NULL
- POSTHOOK: type: QUERY
- POSTHOOK: Input: default@src1
- POSTHOOK: Output: default@dest1
- POSTHOOK: Lineage: dest1.c1 EXPRESSION []
- POSTHOOK: Lineage: dest1.c2 EXPRESSION [(src1)src1.FieldSchema(name:key, type:string, comment:default), ]
- POSTHOOK: Lineage: dest1.c3 EXPRESSION []
- PREHOOK: query: SELECT dest1.* FROM dest1
- PREHOOK: type: QUERY
- PREHOOK: Input: default@dest1
- PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_15-58-34_679_4447149587092293479/-mr-10000
- POSTHOOK: query: SELECT dest1.* FROM dest1
- POSTHOOK: type: QUERY
- POSTHOOK: Input: default@dest1
- POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_15-58-34_679_4447149587092293479/-mr-10000
- POSTHOOK: Lineage: dest1.c1 EXPRESSION []
- POSTHOOK: Lineage: dest1.c2 EXPRESSION [(src1)src1.FieldSchema(name:key, type:string, comment:default), ]
- POSTHOOK: Lineage: dest1.c3 EXPRESSION []
- NULL NULL NULL
- NULL NULL NULL
- NULL NULL NULL
- NULL NULL NULL
- NULL NULL NULL
- NULL NULL NULL
- NULL NULL NULL
- NULL NULL NULL
- NULL NULL NULL
- NULL NULL NULL
- NULL NULL NULL
- NULL NULL NULL
- NULL NULL NULL
- NULL NULL NULL
- NULL NULL NULL
- NULL NULL NULL
- NULL NULL NULL
- NULL NULL NULL
- NULL NULL NULL
- NULL NULL NULL
- NULL NULL NULL
- NULL NULL NULL
- NULL NULL NULL
- NULL NULL NULL
- NULL NULL NULL