PageRenderTime 23ms CodeModel.GetById 14ms app.highlight 4ms RepoModel.GetById 1ms app.codeStats 0ms

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

#
text | 126 lines | 116 code | 10 blank | 0 comment | 0 complexity | 564e2fc4ca305b33c15a81dd8ebdf32b MD5 | raw file
  1PREHOOK: query: CREATE TABLE dest1(c1 STRING) STORED AS TEXTFILE
  2PREHOOK: type: CREATETABLE
  3POSTHOOK: query: CREATE TABLE dest1(c1 STRING) STORED AS TEXTFILE
  4POSTHOOK: type: CREATETABLE
  5POSTHOOK: Output: default@dest1
  6PREHOOK: query: FROM src INSERT OVERWRITE TABLE dest1 SELECT '  abc  ' WHERE src.key = 86
  7PREHOOK: type: QUERY
  8PREHOOK: Input: default@src
  9PREHOOK: Output: default@dest1
 10POSTHOOK: query: FROM src INSERT OVERWRITE TABLE dest1 SELECT '  abc  ' WHERE src.key = 86
 11POSTHOOK: type: QUERY
 12POSTHOOK: Input: default@src
 13POSTHOOK: Output: default@dest1
 14POSTHOOK: Lineage: dest1.c1 SIMPLE []
 15PREHOOK: query: EXPLAIN
 16SELECT from_unixtime(1226446340), to_date(from_unixtime(1226446340)), day('2008-11-01'), month('2008-11-01'), year('2008-11-01'), day('2008-11-01 15:32:20'), month('2008-11-01 15:32:20'), year('2008-11-01 15:32:20') FROM dest1
 17PREHOOK: type: QUERY
 18POSTHOOK: query: EXPLAIN
 19SELECT from_unixtime(1226446340), to_date(from_unixtime(1226446340)), day('2008-11-01'), month('2008-11-01'), year('2008-11-01'), day('2008-11-01 15:32:20'), month('2008-11-01 15:32:20'), year('2008-11-01 15:32:20') FROM dest1
 20POSTHOOK: type: QUERY
 21POSTHOOK: Lineage: dest1.c1 SIMPLE []
 22ABSTRACT SYNTAX TREE:
 23  (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME dest1))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION from_unixtime 1226446340)) (TOK_SELEXPR (TOK_FUNCTION to_date (TOK_FUNCTION from_unixtime 1226446340))) (TOK_SELEXPR (TOK_FUNCTION day '2008-11-01')) (TOK_SELEXPR (TOK_FUNCTION month '2008-11-01')) (TOK_SELEXPR (TOK_FUNCTION year '2008-11-01')) (TOK_SELEXPR (TOK_FUNCTION day '2008-11-01 15:32:20')) (TOK_SELEXPR (TOK_FUNCTION month '2008-11-01 15:32:20')) (TOK_SELEXPR (TOK_FUNCTION year '2008-11-01 15:32:20')))))
 24
 25STAGE DEPENDENCIES:
 26  Stage-1 is a root stage
 27  Stage-0 is a root stage
 28
 29STAGE PLANS:
 30  Stage: Stage-1
 31    Map Reduce
 32      Alias -> Map Operator Tree:
 33        dest1 
 34          TableScan
 35            alias: dest1
 36            Select Operator
 37              expressions:
 38                    expr: from_unixtime(1226446340)
 39                    type: string
 40                    expr: to_date(from_unixtime(1226446340))
 41                    type: string
 42                    expr: day('2008-11-01')
 43                    type: int
 44                    expr: month('2008-11-01')
 45                    type: int
 46                    expr: year('2008-11-01')
 47                    type: int
 48                    expr: day('2008-11-01 15:32:20')
 49                    type: int
 50                    expr: month('2008-11-01 15:32:20')
 51                    type: int
 52                    expr: year('2008-11-01 15:32:20')
 53                    type: int
 54              outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7
 55              File Output Operator
 56                compressed: false
 57                GlobalTableId: 0
 58                table:
 59                    input format: org.apache.hadoop.mapred.TextInputFormat
 60                    output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 61
 62  Stage: Stage-0
 63    Fetch Operator
 64      limit: -1
 65
 66
 67PREHOOK: query: SELECT from_unixtime(1226446340), to_date(from_unixtime(1226446340)), day('2008-11-01'), month('2008-11-01'), year('2008-11-01'), day('2008-11-01 15:32:20'), month('2008-11-01 15:32:20'), year('2008-11-01 15:32:20') FROM dest1
 68PREHOOK: type: QUERY
 69PREHOOK: Input: default@dest1
 70PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-28-46_328_8485702647424685538/-mr-10000
 71POSTHOOK: query: SELECT from_unixtime(1226446340), to_date(from_unixtime(1226446340)), day('2008-11-01'), month('2008-11-01'), year('2008-11-01'), day('2008-11-01 15:32:20'), month('2008-11-01 15:32:20'), year('2008-11-01 15:32:20') FROM dest1
 72POSTHOOK: type: QUERY
 73POSTHOOK: Input: default@dest1
 74POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-28-46_328_8485702647424685538/-mr-10000
 75POSTHOOK: Lineage: dest1.c1 SIMPLE []
 762008-11-11 15:32:20	2008-11-11	1	11	2008	1	11	2008
 77PREHOOK: query: EXPLAIN
 78SELECT from_unixtime(unix_timestamp('2010-01-13 11:57:40', 'yyyy-MM-dd HH:mm:ss'), 'MM/dd/yy HH:mm:ss'), from_unixtime(unix_timestamp('2010-01-13 11:57:40')) from dest1
 79PREHOOK: type: QUERY
 80POSTHOOK: query: EXPLAIN
 81SELECT from_unixtime(unix_timestamp('2010-01-13 11:57:40', 'yyyy-MM-dd HH:mm:ss'), 'MM/dd/yy HH:mm:ss'), from_unixtime(unix_timestamp('2010-01-13 11:57:40')) from dest1
 82POSTHOOK: type: QUERY
 83POSTHOOK: Lineage: dest1.c1 SIMPLE []
 84ABSTRACT SYNTAX TREE:
 85  (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME dest1))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION from_unixtime (TOK_FUNCTION unix_timestamp '2010-01-13 11:57:40' 'yyyy-MM-dd HH:mm:ss') 'MM/dd/yy HH:mm:ss')) (TOK_SELEXPR (TOK_FUNCTION from_unixtime (TOK_FUNCTION unix_timestamp '2010-01-13 11:57:40'))))))
 86
 87STAGE DEPENDENCIES:
 88  Stage-1 is a root stage
 89  Stage-0 is a root stage
 90
 91STAGE PLANS:
 92  Stage: Stage-1
 93    Map Reduce
 94      Alias -> Map Operator Tree:
 95        dest1 
 96          TableScan
 97            alias: dest1
 98            Select Operator
 99              expressions:
100                    expr: from_unixtime(unix_timestamp('2010-01-13 11:57:40', 'yyyy-MM-dd HH:mm:ss'), 'MM/dd/yy HH:mm:ss')
101                    type: string
102                    expr: from_unixtime(unix_timestamp('2010-01-13 11:57:40'))
103                    type: string
104              outputColumnNames: _col0, _col1
105              File Output Operator
106                compressed: false
107                GlobalTableId: 0
108                table:
109                    input format: org.apache.hadoop.mapred.TextInputFormat
110                    output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
111
112  Stage: Stage-0
113    Fetch Operator
114      limit: -1
115
116
117PREHOOK: query: SELECT from_unixtime(unix_timestamp('2010-01-13 11:57:40', 'yyyy-MM-dd HH:mm:ss'), 'MM/dd/yy HH:mm:ss'), from_unixtime(unix_timestamp('2010-01-13 11:57:40')) from dest1
118PREHOOK: type: QUERY
119PREHOOK: Input: default@dest1
120PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-28-49_797_825160708761917842/-mr-10000
121POSTHOOK: query: SELECT from_unixtime(unix_timestamp('2010-01-13 11:57:40', 'yyyy-MM-dd HH:mm:ss'), 'MM/dd/yy HH:mm:ss'), from_unixtime(unix_timestamp('2010-01-13 11:57:40')) from dest1
122POSTHOOK: type: QUERY
123POSTHOOK: Input: default@dest1
124POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-28-49_797_825160708761917842/-mr-10000
125POSTHOOK: Lineage: dest1.c1 SIMPLE []
12601/13/10 11:57:40	2010-01-13 11:57:40