PageRenderTime 41ms CodeModel.GetById 32ms app.highlight 4ms RepoModel.GetById 1ms app.codeStats 0ms

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

#
text | 190 lines | 184 code | 6 blank | 0 comment | 0 complexity | 64b6d84ba49597321103016d09c81e77 MD5 | raw file
  1PREHOOK: query: CREATE TABLE dest1(dummy STRING, key INT, value DOUBLE) STORED AS TEXTFILE
  2PREHOOK: type: CREATETABLE
  3POSTHOOK: query: CREATE TABLE dest1(dummy STRING, key INT, value DOUBLE) STORED AS TEXTFILE
  4POSTHOOK: type: CREATETABLE
  5POSTHOOK: Output: default@dest1
  6PREHOOK: query: EXPLAIN
  7FROM src
  8INSERT OVERWRITE TABLE dest1 SELECT '1234', src.key, count(1) WHERE key < 100 group by src.key
  9PREHOOK: type: QUERY
 10POSTHOOK: query: EXPLAIN
 11FROM src
 12INSERT OVERWRITE TABLE dest1 SELECT '1234', src.key, count(1) WHERE key < 100 group by src.key
 13POSTHOOK: type: QUERY
 14ABSTRACT SYNTAX TREE:
 15  (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src))) (TOK_INSERT (TOK_DESTINATION (TOK_TAB (TOK_TABNAME dest1))) (TOK_SELECT (TOK_SELEXPR '1234') (TOK_SELEXPR (. (TOK_TABLE_OR_COL src) key)) (TOK_SELEXPR (TOK_FUNCTION count 1))) (TOK_WHERE (< (TOK_TABLE_OR_COL key) 100)) (TOK_GROUPBY (. (TOK_TABLE_OR_COL src) key))))
 16
 17STAGE DEPENDENCIES:
 18  Stage-1 is a root stage
 19  Stage-0 depends on stages: Stage-1
 20  Stage-2 depends on stages: Stage-0
 21
 22STAGE PLANS:
 23  Stage: Stage-1
 24    Map Reduce
 25      Alias -> Map Operator Tree:
 26        src 
 27          TableScan
 28            alias: src
 29            Filter Operator
 30              predicate:
 31                  expr: (key < 100)
 32                  type: boolean
 33              Select Operator
 34                expressions:
 35                      expr: key
 36                      type: string
 37                outputColumnNames: key
 38                Group By Operator
 39                  aggregations:
 40                        expr: count(1)
 41                  bucketGroup: false
 42                  keys:
 43                        expr: key
 44                        type: string
 45                  mode: hash
 46                  outputColumnNames: _col0, _col1
 47                  Reduce Output Operator
 48                    key expressions:
 49                          expr: _col0
 50                          type: string
 51                    sort order: +
 52                    Map-reduce partition columns:
 53                          expr: _col0
 54                          type: string
 55                    tag: -1
 56                    value expressions:
 57                          expr: _col1
 58                          type: bigint
 59      Reduce Operator Tree:
 60        Group By Operator
 61          aggregations:
 62                expr: count(VALUE._col0)
 63          bucketGroup: false
 64          keys:
 65                expr: KEY._col0
 66                type: string
 67          mode: mergepartial
 68          outputColumnNames: _col0, _col1
 69          Select Operator
 70            expressions:
 71                  expr: '1234'
 72                  type: string
 73                  expr: _col0
 74                  type: string
 75                  expr: _col1
 76                  type: bigint
 77            outputColumnNames: _col0, _col1, _col2
 78            Select Operator
 79              expressions:
 80                    expr: _col0
 81                    type: string
 82                    expr: UDFToInteger(_col1)
 83                    type: int
 84                    expr: UDFToDouble(_col2)
 85                    type: double
 86              outputColumnNames: _col0, _col1, _col2
 87              File Output Operator
 88                compressed: false
 89                GlobalTableId: 1
 90                table:
 91                    input format: org.apache.hadoop.mapred.TextInputFormat
 92                    output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 93                    serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
 94                    name: default.dest1
 95
 96  Stage: Stage-0
 97    Move Operator
 98      tables:
 99          replace: true
100          table:
101              input format: org.apache.hadoop.mapred.TextInputFormat
102              output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
103              serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
104              name: default.dest1
105
106  Stage: Stage-2
107    Stats-Aggr Operator
108
109
110PREHOOK: query: FROM src
111INSERT OVERWRITE TABLE dest1 SELECT '1234', src.key, count(1) WHERE key < 100 group by src.key
112PREHOOK: type: QUERY
113PREHOOK: Input: default@src
114PREHOOK: Output: default@dest1
115POSTHOOK: query: FROM src
116INSERT OVERWRITE TABLE dest1 SELECT '1234', src.key, count(1) WHERE key < 100 group by src.key
117POSTHOOK: type: QUERY
118POSTHOOK: Input: default@src
119POSTHOOK: Output: default@dest1
120POSTHOOK: Lineage: dest1.dummy SIMPLE []
121POSTHOOK: Lineage: dest1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
122POSTHOOK: Lineage: dest1.value EXPRESSION [(src)src.null, ]
123PREHOOK: query: SELECT dest1.* FROM dest1
124PREHOOK: type: QUERY
125PREHOOK: Input: default@dest1
126PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_16-46-42_892_8229387239834597089/-mr-10000
127POSTHOOK: query: SELECT dest1.* FROM dest1
128POSTHOOK: type: QUERY
129POSTHOOK: Input: default@dest1
130POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_16-46-42_892_8229387239834597089/-mr-10000
131POSTHOOK: Lineage: dest1.dummy SIMPLE []
132POSTHOOK: Lineage: dest1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
133POSTHOOK: Lineage: dest1.value EXPRESSION [(src)src.null, ]
1341234	0	3.0
1351234	10	1.0
1361234	11	1.0
1371234	12	2.0
1381234	15	2.0
1391234	17	1.0
1401234	18	2.0
1411234	19	1.0
1421234	2	1.0
1431234	20	1.0
1441234	24	2.0
1451234	26	2.0
1461234	27	1.0
1471234	28	1.0
1481234	30	1.0
1491234	33	1.0
1501234	34	1.0
1511234	35	3.0
1521234	37	2.0
1531234	4	1.0
1541234	41	1.0
1551234	42	2.0
1561234	43	1.0
1571234	44	1.0
1581234	47	1.0
1591234	5	3.0
1601234	51	2.0
1611234	53	1.0
1621234	54	1.0
1631234	57	1.0
1641234	58	2.0
1651234	64	1.0
1661234	65	1.0
1671234	66	1.0
1681234	67	2.0
1691234	69	1.0
1701234	70	3.0
1711234	72	2.0
1721234	74	1.0
1731234	76	2.0
1741234	77	1.0
1751234	78	1.0
1761234	8	1.0
1771234	80	1.0
1781234	82	1.0
1791234	83	2.0
1801234	84	2.0
1811234	85	1.0
1821234	86	1.0
1831234	87	1.0
1841234	9	1.0
1851234	90	3.0
1861234	92	1.0
1871234	95	2.0
1881234	96	1.0
1891234	97	2.0
1901234	98	2.0