You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by gu...@apache.org on 2013/11/05 08:01:58 UTC
svn commit: r1538880 [24/46] - in /hive/branches/tez: ./ ant/
ant/src/org/apache/hadoop/hive/ant/ beeline/
beeline/src/java/org/apache/hive/beeline/ beeline/src/main/
beeline/src/test/org/apache/hive/beeline/src/test/ cli/ common/
common/src/java/conf/...
Modified: hive/branches/tez/ql/src/test/results/clientpositive/database_drop.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/database_drop.q.out?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/database_drop.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/database_drop.q.out Tue Nov 5 07:01:32 2013
@@ -32,10 +32,10 @@ POSTHOOK: query: -- add a table, index a
CREATE TABLE temp_tbl (id INT, name STRING)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: db5@temp_tbl
-PREHOOK: query: LOAD DATA LOCAL INPATH '../data/files/kv1.txt' INTO TABLE temp_tbl
+PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/kv1.txt' INTO TABLE temp_tbl
PREHOOK: type: LOAD
PREHOOK: Output: db5@temp_tbl
-POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/kv1.txt' INTO TABLE temp_tbl
+POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/kv1.txt' INTO TABLE temp_tbl
POSTHOOK: type: LOAD
POSTHOOK: Output: db5@temp_tbl
PREHOOK: query: CREATE VIEW temp_tbl_view AS SELECT * FROM temp_tbl
@@ -69,10 +69,10 @@ POSTHOOK: Output: db5@temp_tbl2
POSTHOOK: Lineage: db5__temp_tbl_idx1__._bucketname SIMPLE [(temp_tbl)temp_tbl.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
POSTHOOK: Lineage: db5__temp_tbl_idx1__._offsets EXPRESSION [(temp_tbl)temp_tbl.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), ]
POSTHOOK: Lineage: db5__temp_tbl_idx1__.id SIMPLE [(temp_tbl)temp_tbl.FieldSchema(name:id, type:int, comment:null), ]
-PREHOOK: query: LOAD DATA LOCAL INPATH '../data/files/kv1.txt' into table temp_tbl2
+PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/kv1.txt' into table temp_tbl2
PREHOOK: type: LOAD
PREHOOK: Output: db5@temp_tbl2
-POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/kv1.txt' into table temp_tbl2
+POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/kv1.txt' into table temp_tbl2
POSTHOOK: type: LOAD
POSTHOOK: Output: db5@temp_tbl2
POSTHOOK: Lineage: db5__temp_tbl_idx1__._bucketname SIMPLE [(temp_tbl)temp_tbl.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
@@ -121,10 +121,10 @@ POSTHOOK: Lineage: db5__temp_tbl2_idx2__
POSTHOOK: Lineage: db5__temp_tbl_idx1__._bucketname SIMPLE [(temp_tbl)temp_tbl.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
POSTHOOK: Lineage: db5__temp_tbl_idx1__._offsets EXPRESSION [(temp_tbl)temp_tbl.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), ]
POSTHOOK: Lineage: db5__temp_tbl_idx1__.id SIMPLE [(temp_tbl)temp_tbl.FieldSchema(name:id, type:int, comment:null), ]
-PREHOOK: query: LOAD DATA LOCAL INPATH '../data/files/kv1.txt' INTO TABLE part_tab PARTITION (ds='2008-04-09')
+PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/kv1.txt' INTO TABLE part_tab PARTITION (ds='2008-04-09')
PREHOOK: type: LOAD
PREHOOK: Output: db5@part_tab
-POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/kv1.txt' INTO TABLE part_tab PARTITION (ds='2008-04-09')
+POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/kv1.txt' INTO TABLE part_tab PARTITION (ds='2008-04-09')
POSTHOOK: type: LOAD
POSTHOOK: Output: db5@part_tab
POSTHOOK: Output: db5@part_tab@ds=2008-04-09
@@ -134,10 +134,10 @@ POSTHOOK: Lineage: db5__temp_tbl2_idx2__
POSTHOOK: Lineage: db5__temp_tbl_idx1__._bucketname SIMPLE [(temp_tbl)temp_tbl.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
POSTHOOK: Lineage: db5__temp_tbl_idx1__._offsets EXPRESSION [(temp_tbl)temp_tbl.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), ]
POSTHOOK: Lineage: db5__temp_tbl_idx1__.id SIMPLE [(temp_tbl)temp_tbl.FieldSchema(name:id, type:int, comment:null), ]
-PREHOOK: query: LOAD DATA LOCAL INPATH '../data/files/kv1.txt' INTO TABLE part_tab PARTITION (ds='2009-04-09')
+PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/kv1.txt' INTO TABLE part_tab PARTITION (ds='2009-04-09')
PREHOOK: type: LOAD
PREHOOK: Output: db5@part_tab
-POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/kv1.txt' INTO TABLE part_tab PARTITION (ds='2009-04-09')
+POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/kv1.txt' INTO TABLE part_tab PARTITION (ds='2009-04-09')
POSTHOOK: type: LOAD
POSTHOOK: Output: db5@part_tab
POSTHOOK: Output: db5@part_tab@ds=2009-04-09
@@ -220,10 +220,10 @@ POSTHOOK: Lineage: db5__temp_tbl2_idx2__
POSTHOOK: Lineage: db5__temp_tbl_idx1__._bucketname SIMPLE [(temp_tbl)temp_tbl.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
POSTHOOK: Lineage: db5__temp_tbl_idx1__._offsets EXPRESSION [(temp_tbl)temp_tbl.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), ]
POSTHOOK: Lineage: db5__temp_tbl_idx1__.id SIMPLE [(temp_tbl)temp_tbl.FieldSchema(name:id, type:int, comment:null), ]
-PREHOOK: query: LOAD DATA LOCAL INPATH '../data/files/kv1.txt' INTO TABLE part_tab2 PARTITION (ds='2008-04-09')
+PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/kv1.txt' INTO TABLE part_tab2 PARTITION (ds='2008-04-09')
PREHOOK: type: LOAD
PREHOOK: Output: db5@part_tab2
-POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/kv1.txt' INTO TABLE part_tab2 PARTITION (ds='2008-04-09')
+POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/kv1.txt' INTO TABLE part_tab2 PARTITION (ds='2008-04-09')
POSTHOOK: type: LOAD
POSTHOOK: Output: db5@part_tab2
POSTHOOK: Output: db5@part_tab2@ds=2008-04-09
@@ -239,10 +239,10 @@ POSTHOOK: Lineage: db5__temp_tbl2_idx2__
POSTHOOK: Lineage: db5__temp_tbl_idx1__._bucketname SIMPLE [(temp_tbl)temp_tbl.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
POSTHOOK: Lineage: db5__temp_tbl_idx1__._offsets EXPRESSION [(temp_tbl)temp_tbl.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), ]
POSTHOOK: Lineage: db5__temp_tbl_idx1__.id SIMPLE [(temp_tbl)temp_tbl.FieldSchema(name:id, type:int, comment:null), ]
-PREHOOK: query: LOAD DATA LOCAL INPATH '../data/files/kv1.txt' INTO TABLE part_tab2 PARTITION (ds='2009-04-09')
+PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/kv1.txt' INTO TABLE part_tab2 PARTITION (ds='2009-04-09')
PREHOOK: type: LOAD
PREHOOK: Output: db5@part_tab2
-POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/kv1.txt' INTO TABLE part_tab2 PARTITION (ds='2009-04-09')
+POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/kv1.txt' INTO TABLE part_tab2 PARTITION (ds='2009-04-09')
POSTHOOK: type: LOAD
POSTHOOK: Output: db5@part_tab2
POSTHOOK: Output: db5@part_tab2@ds=2009-04-09
@@ -382,10 +382,10 @@ POSTHOOK: Lineage: db5__temp_tbl2_idx2__
POSTHOOK: Lineage: db5__temp_tbl_idx1__._bucketname SIMPLE [(temp_tbl)temp_tbl.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
POSTHOOK: Lineage: db5__temp_tbl_idx1__._offsets EXPRESSION [(temp_tbl)temp_tbl.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), ]
POSTHOOK: Lineage: db5__temp_tbl_idx1__.id SIMPLE [(temp_tbl)temp_tbl.FieldSchema(name:id, type:int, comment:null), ]
-PREHOOK: query: LOAD DATA LOCAL INPATH '../data/files/kv1.txt' INTO TABLE part_tab3 PARTITION (ds='2008-04-09')
+PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/kv1.txt' INTO TABLE part_tab3 PARTITION (ds='2008-04-09')
PREHOOK: type: LOAD
PREHOOK: Output: db5@part_tab3
-POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/kv1.txt' INTO TABLE part_tab3 PARTITION (ds='2008-04-09')
+POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/kv1.txt' INTO TABLE part_tab3 PARTITION (ds='2008-04-09')
POSTHOOK: type: LOAD
POSTHOOK: Output: db5@part_tab3
POSTHOOK: Output: db5@part_tab3@ds=2008-04-09
@@ -407,10 +407,10 @@ POSTHOOK: Lineage: db5__temp_tbl2_idx2__
POSTHOOK: Lineage: db5__temp_tbl_idx1__._bucketname SIMPLE [(temp_tbl)temp_tbl.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
POSTHOOK: Lineage: db5__temp_tbl_idx1__._offsets EXPRESSION [(temp_tbl)temp_tbl.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), ]
POSTHOOK: Lineage: db5__temp_tbl_idx1__.id SIMPLE [(temp_tbl)temp_tbl.FieldSchema(name:id, type:int, comment:null), ]
-PREHOOK: query: LOAD DATA LOCAL INPATH '../data/files/kv1.txt' INTO TABLE part_tab3 PARTITION (ds='2009-04-09')
+PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/kv1.txt' INTO TABLE part_tab3 PARTITION (ds='2009-04-09')
PREHOOK: type: LOAD
PREHOOK: Output: db5@part_tab3
-POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/kv1.txt' INTO TABLE part_tab3 PARTITION (ds='2009-04-09')
+POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/kv1.txt' INTO TABLE part_tab3 PARTITION (ds='2009-04-09')
POSTHOOK: type: LOAD
POSTHOOK: Output: db5@part_tab3
POSTHOOK: Output: db5@part_tab3@ds=2009-04-09
Modified: hive/branches/tez/ql/src/test/results/clientpositive/date_1.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/date_1.q.out?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/date_1.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/date_1.q.out Tue Nov 5 07:01:32 2013
@@ -8,12 +8,12 @@ POSTHOOK: query: create table date_1 (d
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@date_1
PREHOOK: query: insert overwrite table date_1
- select cast('2011-01-01' as date) from src limit 1
+ select cast('2011-01-01' as date) from src tablesample (1 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
PREHOOK: Output: default@date_1
POSTHOOK: query: insert overwrite table date_1
- select cast('2011-01-01' as date) from src limit 1
+ select cast('2011-01-01' as date) from src tablesample (1 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Output: default@date_1
@@ -39,12 +39,12 @@ POSTHOOK: Input: default@date_1
POSTHOOK: Lineage: date_1.d EXPRESSION []
2011-01-01 1
PREHOOK: query: insert overwrite table date_1
- select date '2011-01-01' from src limit 1
+ select date '2011-01-01' from src tablesample (1 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
PREHOOK: Output: default@date_1
POSTHOOK: query: insert overwrite table date_1
- select date '2011-01-01' from src limit 1
+ select date '2011-01-01' from src tablesample (1 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Output: default@date_1
@@ -73,12 +73,12 @@ POSTHOOK: Lineage: date_1.d EXPRESSION [
POSTHOOK: Lineage: date_1.d SIMPLE []
2011-01-01 1
PREHOOK: query: insert overwrite table date_1
- select cast(cast('2011-01-01 00:00:00' as timestamp) as date) from src limit 1
+ select cast(cast('2011-01-01 00:00:00' as timestamp) as date) from src tablesample (1 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
PREHOOK: Output: default@date_1
POSTHOOK: query: insert overwrite table date_1
- select cast(cast('2011-01-01 00:00:00' as timestamp) as date) from src limit 1
+ select cast(cast('2011-01-01 00:00:00' as timestamp) as date) from src tablesample (1 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Output: default@date_1
Modified: hive/branches/tez/ql/src/test/results/clientpositive/date_2.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/date_2.q.out?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/date_2.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/date_2.q.out Tue Nov 5 07:01:32 2013
@@ -19,10 +19,10 @@ POSTHOOK: query: create table date_2 (
)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@date_2
-PREHOOK: query: LOAD DATA LOCAL INPATH '../data/files/flights_tiny.txt.1' OVERWRITE INTO TABLE date_2
+PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/flights_tiny.txt.1' OVERWRITE INTO TABLE date_2
PREHOOK: type: LOAD
PREHOOK: Output: default@date_2
-POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/flights_tiny.txt.1' OVERWRITE INTO TABLE date_2
+POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/flights_tiny.txt.1' OVERWRITE INTO TABLE date_2
POSTHOOK: type: LOAD
POSTHOOK: Output: default@date_2
PREHOOK: query: select fl_date, fl_num from date_2 order by fl_date asc, fl_num desc
Modified: hive/branches/tez/ql/src/test/results/clientpositive/date_3.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/date_3.q.out?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/date_3.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/date_3.q.out Tue Nov 5 07:01:32 2013
@@ -20,12 +20,12 @@ POSTHOOK: type: ALTERTABLE_ADDCOLS
POSTHOOK: Input: default@date_3
POSTHOOK: Output: default@date_3
PREHOOK: query: insert overwrite table date_3
- select 1, cast(cast('2011-01-01 00:00:00' as timestamp) as date) from src limit 1
+ select 1, cast(cast('2011-01-01 00:00:00' as timestamp) as date) from src tablesample (1 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
PREHOOK: Output: default@date_3
POSTHOOK: query: insert overwrite table date_3
- select 1, cast(cast('2011-01-01 00:00:00' as timestamp) as date) from src limit 1
+ select 1, cast(cast('2011-01-01 00:00:00' as timestamp) as date) from src tablesample (1 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Output: default@date_3
Modified: hive/branches/tez/ql/src/test/results/clientpositive/date_4.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/date_4.q.out?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/date_4.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/date_4.q.out Tue Nov 5 07:01:32 2013
@@ -17,13 +17,13 @@ POSTHOOK: Input: default@date_4
POSTHOOK: Output: default@date_4
PREHOOK: query: -- Test date literal syntax
insert overwrite table date_4
- select date '2011-01-01' from src limit 1
+ select date '2011-01-01' from src tablesample (1 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
PREHOOK: Output: default@date_4
POSTHOOK: query: -- Test date literal syntax
insert overwrite table date_4
- select date '2011-01-01' from src limit 1
+ select date '2011-01-01' from src tablesample (1 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Output: default@date_4
Modified: hive/branches/tez/ql/src/test/results/clientpositive/date_join1.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/date_join1.q.out?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/date_join1.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/date_join1.q.out Tue Nov 5 07:01:32 2013
@@ -19,10 +19,10 @@ POSTHOOK: query: create table date_join1
)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@date_join1
-PREHOOK: query: LOAD DATA LOCAL INPATH '../data/files/flights_join.txt' OVERWRITE INTO TABLE date_join1
+PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/flights_join.txt' OVERWRITE INTO TABLE date_join1
PREHOOK: type: LOAD
PREHOOK: Output: default@date_join1
-POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/flights_join.txt' OVERWRITE INTO TABLE date_join1
+POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/flights_join.txt' OVERWRITE INTO TABLE date_join1
POSTHOOK: type: LOAD
POSTHOOK: Output: default@date_join1
PREHOOK: query: -- Note that there are 2 rows with date 2000-11-28, so we should expect 4 rows with that date in the join results
Modified: hive/branches/tez/ql/src/test/results/clientpositive/date_serde.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/date_serde.q.out?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/date_serde.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/date_serde.q.out Tue Nov 5 07:01:32 2013
@@ -55,10 +55,10 @@ with serdeproperties (
stored as textfile
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@date_serde_regex
-PREHOOK: query: load data local inpath '../data/files/flights_tiny.txt.1' overwrite into table date_serde_regex
+PREHOOK: query: load data local inpath '../../data/files/flights_tiny.txt.1' overwrite into table date_serde_regex
PREHOOK: type: LOAD
PREHOOK: Output: default@date_serde_regex
-POSTHOOK: query: load data local inpath '../data/files/flights_tiny.txt.1' overwrite into table date_serde_regex
+POSTHOOK: query: load data local inpath '../../data/files/flights_tiny.txt.1' overwrite into table date_serde_regex
POSTHOOK: type: LOAD
POSTHOOK: Output: default@date_serde_regex
PREHOOK: query: select * from date_serde_regex
Modified: hive/branches/tez/ql/src/test/results/clientpositive/date_udf.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/date_udf.q.out?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/date_udf.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/date_udf.q.out Tue Nov 5 07:01:32 2013
@@ -59,10 +59,10 @@ POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@date_udf_flight
POSTHOOK: Lineage: date_udf.d EXPRESSION []
POSTHOOK: Lineage: date_udf_string.d SIMPLE []
-PREHOOK: query: LOAD DATA LOCAL INPATH '../data/files/flights_tiny.txt.1' OVERWRITE INTO TABLE date_udf_flight
+PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/flights_tiny.txt.1' OVERWRITE INTO TABLE date_udf_flight
PREHOOK: type: LOAD
PREHOOK: Output: default@date_udf_flight
-POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/flights_tiny.txt.1' OVERWRITE INTO TABLE date_udf_flight
+POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/flights_tiny.txt.1' OVERWRITE INTO TABLE date_udf_flight
POSTHOOK: type: LOAD
POSTHOOK: Output: default@date_udf_flight
POSTHOOK: Lineage: date_udf.d EXPRESSION []
Modified: hive/branches/tez/ql/src/test/results/clientpositive/decimal_1.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/decimal_1.q.out?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/decimal_1.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/decimal_1.q.out Tue Nov 5 07:01:32 2013
@@ -16,101 +16,101 @@ POSTHOOK: type: ALTERTABLE_SERIALIZER
POSTHOOK: Input: default@decimal_1
POSTHOOK: Output: default@decimal_1
PREHOOK: query: insert overwrite table decimal_1
- select cast('17.29' as decimal(4,2)) from src limit 1
+ select cast('17.29' as decimal(4,2)) from src tablesample (1 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
PREHOOK: Output: default@decimal_1
POSTHOOK: query: insert overwrite table decimal_1
- select cast('17.29' as decimal(4,2)) from src limit 1
+ select cast('17.29' as decimal(4,2)) from src tablesample (1 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Output: default@decimal_1
POSTHOOK: Lineage: decimal_1.t EXPRESSION []
-PREHOOK: query: select cast(t as boolean) from decimal_1 limit 1
+PREHOOK: query: select cast(t as boolean) from decimal_1
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_1
#### A masked pattern was here ####
-POSTHOOK: query: select cast(t as boolean) from decimal_1 limit 1
+POSTHOOK: query: select cast(t as boolean) from decimal_1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_1
#### A masked pattern was here ####
POSTHOOK: Lineage: decimal_1.t EXPRESSION []
true
-PREHOOK: query: select cast(t as tinyint) from decimal_1 limit 1
+PREHOOK: query: select cast(t as tinyint) from decimal_1
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_1
#### A masked pattern was here ####
-POSTHOOK: query: select cast(t as tinyint) from decimal_1 limit 1
+POSTHOOK: query: select cast(t as tinyint) from decimal_1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_1
#### A masked pattern was here ####
POSTHOOK: Lineage: decimal_1.t EXPRESSION []
17
-PREHOOK: query: select cast(t as smallint) from decimal_1 limit 1
+PREHOOK: query: select cast(t as smallint) from decimal_1
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_1
#### A masked pattern was here ####
-POSTHOOK: query: select cast(t as smallint) from decimal_1 limit 1
+POSTHOOK: query: select cast(t as smallint) from decimal_1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_1
#### A masked pattern was here ####
POSTHOOK: Lineage: decimal_1.t EXPRESSION []
17
-PREHOOK: query: select cast(t as int) from decimal_1 limit 1
+PREHOOK: query: select cast(t as int) from decimal_1
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_1
#### A masked pattern was here ####
-POSTHOOK: query: select cast(t as int) from decimal_1 limit 1
+POSTHOOK: query: select cast(t as int) from decimal_1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_1
#### A masked pattern was here ####
POSTHOOK: Lineage: decimal_1.t EXPRESSION []
17
-PREHOOK: query: select cast(t as bigint) from decimal_1 limit 1
+PREHOOK: query: select cast(t as bigint) from decimal_1
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_1
#### A masked pattern was here ####
-POSTHOOK: query: select cast(t as bigint) from decimal_1 limit 1
+POSTHOOK: query: select cast(t as bigint) from decimal_1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_1
#### A masked pattern was here ####
POSTHOOK: Lineage: decimal_1.t EXPRESSION []
17
-PREHOOK: query: select cast(t as float) from decimal_1 limit 1
+PREHOOK: query: select cast(t as float) from decimal_1
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_1
#### A masked pattern was here ####
-POSTHOOK: query: select cast(t as float) from decimal_1 limit 1
+POSTHOOK: query: select cast(t as float) from decimal_1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_1
#### A masked pattern was here ####
POSTHOOK: Lineage: decimal_1.t EXPRESSION []
17.29
-PREHOOK: query: select cast(t as double) from decimal_1 limit 1
+PREHOOK: query: select cast(t as double) from decimal_1
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_1
#### A masked pattern was here ####
-POSTHOOK: query: select cast(t as double) from decimal_1 limit 1
+POSTHOOK: query: select cast(t as double) from decimal_1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_1
#### A masked pattern was here ####
POSTHOOK: Lineage: decimal_1.t EXPRESSION []
17.29
-PREHOOK: query: select cast(t as string) from decimal_1 limit 1
+PREHOOK: query: select cast(t as string) from decimal_1
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_1
#### A masked pattern was here ####
-POSTHOOK: query: select cast(t as string) from decimal_1 limit 1
+POSTHOOK: query: select cast(t as string) from decimal_1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_1
#### A masked pattern was here ####
POSTHOOK: Lineage: decimal_1.t EXPRESSION []
17.29
-PREHOOK: query: select cast(t as timestamp) from decimal_1 limit 1
+PREHOOK: query: select cast(t as timestamp) from decimal_1
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_1
#### A masked pattern was here ####
-POSTHOOK: query: select cast(t as timestamp) from decimal_1 limit 1
+POSTHOOK: query: select cast(t as timestamp) from decimal_1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_1
#### A masked pattern was here ####
Modified: hive/branches/tez/ql/src/test/results/clientpositive/decimal_2.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/decimal_2.q.out?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/decimal_2.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/decimal_2.q.out Tue Nov 5 07:01:32 2013
@@ -16,300 +16,300 @@ POSTHOOK: type: ALTERTABLE_SERIALIZER
POSTHOOK: Input: default@decimal_2
POSTHOOK: Output: default@decimal_2
PREHOOK: query: insert overwrite table decimal_2
- select cast('17.29' as decimal(4,2)) from src limit 1
+ select cast('17.29' as decimal(4,2)) from src tablesample (1 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
PREHOOK: Output: default@decimal_2
POSTHOOK: query: insert overwrite table decimal_2
- select cast('17.29' as decimal(4,2)) from src limit 1
+ select cast('17.29' as decimal(4,2)) from src tablesample (1 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Output: default@decimal_2
POSTHOOK: Lineage: decimal_2.t EXPRESSION []
-PREHOOK: query: select cast(t as boolean) from decimal_2 limit 1
+PREHOOK: query: select cast(t as boolean) from decimal_2
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_2
#### A masked pattern was here ####
-POSTHOOK: query: select cast(t as boolean) from decimal_2 limit 1
+POSTHOOK: query: select cast(t as boolean) from decimal_2
POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_2
#### A masked pattern was here ####
POSTHOOK: Lineage: decimal_2.t EXPRESSION []
true
-PREHOOK: query: select cast(t as tinyint) from decimal_2 limit 1
+PREHOOK: query: select cast(t as tinyint) from decimal_2
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_2
#### A masked pattern was here ####
-POSTHOOK: query: select cast(t as tinyint) from decimal_2 limit 1
+POSTHOOK: query: select cast(t as tinyint) from decimal_2
POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_2
#### A masked pattern was here ####
POSTHOOK: Lineage: decimal_2.t EXPRESSION []
17
-PREHOOK: query: select cast(t as smallint) from decimal_2 limit 1
+PREHOOK: query: select cast(t as smallint) from decimal_2
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_2
#### A masked pattern was here ####
-POSTHOOK: query: select cast(t as smallint) from decimal_2 limit 1
+POSTHOOK: query: select cast(t as smallint) from decimal_2
POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_2
#### A masked pattern was here ####
POSTHOOK: Lineage: decimal_2.t EXPRESSION []
17
-PREHOOK: query: select cast(t as int) from decimal_2 limit 1
+PREHOOK: query: select cast(t as int) from decimal_2
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_2
#### A masked pattern was here ####
-POSTHOOK: query: select cast(t as int) from decimal_2 limit 1
+POSTHOOK: query: select cast(t as int) from decimal_2
POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_2
#### A masked pattern was here ####
POSTHOOK: Lineage: decimal_2.t EXPRESSION []
17
-PREHOOK: query: select cast(t as bigint) from decimal_2 limit 1
+PREHOOK: query: select cast(t as bigint) from decimal_2
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_2
#### A masked pattern was here ####
-POSTHOOK: query: select cast(t as bigint) from decimal_2 limit 1
+POSTHOOK: query: select cast(t as bigint) from decimal_2
POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_2
#### A masked pattern was here ####
POSTHOOK: Lineage: decimal_2.t EXPRESSION []
17
-PREHOOK: query: select cast(t as float) from decimal_2 limit 1
+PREHOOK: query: select cast(t as float) from decimal_2
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_2
#### A masked pattern was here ####
-POSTHOOK: query: select cast(t as float) from decimal_2 limit 1
+POSTHOOK: query: select cast(t as float) from decimal_2
POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_2
#### A masked pattern was here ####
POSTHOOK: Lineage: decimal_2.t EXPRESSION []
17.29
-PREHOOK: query: select cast(t as double) from decimal_2 limit 1
+PREHOOK: query: select cast(t as double) from decimal_2
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_2
#### A masked pattern was here ####
-POSTHOOK: query: select cast(t as double) from decimal_2 limit 1
+POSTHOOK: query: select cast(t as double) from decimal_2
POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_2
#### A masked pattern was here ####
POSTHOOK: Lineage: decimal_2.t EXPRESSION []
17.29
-PREHOOK: query: select cast(t as string) from decimal_2 limit 1
+PREHOOK: query: select cast(t as string) from decimal_2
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_2
#### A masked pattern was here ####
-POSTHOOK: query: select cast(t as string) from decimal_2 limit 1
+POSTHOOK: query: select cast(t as string) from decimal_2
POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_2
#### A masked pattern was here ####
POSTHOOK: Lineage: decimal_2.t EXPRESSION []
17.29
PREHOOK: query: insert overwrite table decimal_2
- select cast('3404045.5044003' as decimal(18,9)) from src limit 1
+ select cast('3404045.5044003' as decimal(18,9)) from src tablesample (1 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
PREHOOK: Output: default@decimal_2
POSTHOOK: query: insert overwrite table decimal_2
- select cast('3404045.5044003' as decimal(18,9)) from src limit 1
+ select cast('3404045.5044003' as decimal(18,9)) from src tablesample (1 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Output: default@decimal_2
POSTHOOK: Lineage: decimal_2.t EXPRESSION []
POSTHOOK: Lineage: decimal_2.t EXPRESSION []
-PREHOOK: query: select cast(t as boolean) from decimal_2 limit 1
+PREHOOK: query: select cast(t as boolean) from decimal_2
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_2
#### A masked pattern was here ####
-POSTHOOK: query: select cast(t as boolean) from decimal_2 limit 1
+POSTHOOK: query: select cast(t as boolean) from decimal_2
POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_2
#### A masked pattern was here ####
POSTHOOK: Lineage: decimal_2.t EXPRESSION []
POSTHOOK: Lineage: decimal_2.t EXPRESSION []
true
-PREHOOK: query: select cast(t as tinyint) from decimal_2 limit 1
+PREHOOK: query: select cast(t as tinyint) from decimal_2
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_2
#### A masked pattern was here ####
-POSTHOOK: query: select cast(t as tinyint) from decimal_2 limit 1
+POSTHOOK: query: select cast(t as tinyint) from decimal_2
POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_2
#### A masked pattern was here ####
POSTHOOK: Lineage: decimal_2.t EXPRESSION []
POSTHOOK: Lineage: decimal_2.t EXPRESSION []
13
-PREHOOK: query: select cast(t as smallint) from decimal_2 limit 1
+PREHOOK: query: select cast(t as smallint) from decimal_2
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_2
#### A masked pattern was here ####
-POSTHOOK: query: select cast(t as smallint) from decimal_2 limit 1
+POSTHOOK: query: select cast(t as smallint) from decimal_2
POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_2
#### A masked pattern was here ####
POSTHOOK: Lineage: decimal_2.t EXPRESSION []
POSTHOOK: Lineage: decimal_2.t EXPRESSION []
-3827
-PREHOOK: query: select cast(t as int) from decimal_2 limit 1
+PREHOOK: query: select cast(t as int) from decimal_2
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_2
#### A masked pattern was here ####
-POSTHOOK: query: select cast(t as int) from decimal_2 limit 1
+POSTHOOK: query: select cast(t as int) from decimal_2
POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_2
#### A masked pattern was here ####
POSTHOOK: Lineage: decimal_2.t EXPRESSION []
POSTHOOK: Lineage: decimal_2.t EXPRESSION []
3404045
-PREHOOK: query: select cast(t as bigint) from decimal_2 limit 1
+PREHOOK: query: select cast(t as bigint) from decimal_2
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_2
#### A masked pattern was here ####
-POSTHOOK: query: select cast(t as bigint) from decimal_2 limit 1
+POSTHOOK: query: select cast(t as bigint) from decimal_2
POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_2
#### A masked pattern was here ####
POSTHOOK: Lineage: decimal_2.t EXPRESSION []
POSTHOOK: Lineage: decimal_2.t EXPRESSION []
3404045
-PREHOOK: query: select cast(t as float) from decimal_2 limit 1
+PREHOOK: query: select cast(t as float) from decimal_2
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_2
#### A masked pattern was here ####
-POSTHOOK: query: select cast(t as float) from decimal_2 limit 1
+POSTHOOK: query: select cast(t as float) from decimal_2
POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_2
#### A masked pattern was here ####
POSTHOOK: Lineage: decimal_2.t EXPRESSION []
POSTHOOK: Lineage: decimal_2.t EXPRESSION []
3404045.5
-PREHOOK: query: select cast(t as double) from decimal_2 limit 1
+PREHOOK: query: select cast(t as double) from decimal_2
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_2
#### A masked pattern was here ####
-POSTHOOK: query: select cast(t as double) from decimal_2 limit 1
+POSTHOOK: query: select cast(t as double) from decimal_2
POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_2
#### A masked pattern was here ####
POSTHOOK: Lineage: decimal_2.t EXPRESSION []
POSTHOOK: Lineage: decimal_2.t EXPRESSION []
3404045.5044003
-PREHOOK: query: select cast(t as string) from decimal_2 limit 1
+PREHOOK: query: select cast(t as string) from decimal_2
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_2
#### A masked pattern was here ####
-POSTHOOK: query: select cast(t as string) from decimal_2 limit 1
+POSTHOOK: query: select cast(t as string) from decimal_2
POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_2
#### A masked pattern was here ####
POSTHOOK: Lineage: decimal_2.t EXPRESSION []
POSTHOOK: Lineage: decimal_2.t EXPRESSION []
3404045.5044003
-PREHOOK: query: select cast(3.14 as decimal(4,2)) from decimal_2 limit 1
+PREHOOK: query: select cast(3.14 as decimal(4,2)) from decimal_2
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_2
#### A masked pattern was here ####
-POSTHOOK: query: select cast(3.14 as decimal(4,2)) from decimal_2 limit 1
+POSTHOOK: query: select cast(3.14 as decimal(4,2)) from decimal_2
POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_2
#### A masked pattern was here ####
POSTHOOK: Lineage: decimal_2.t EXPRESSION []
POSTHOOK: Lineage: decimal_2.t EXPRESSION []
3.14
-PREHOOK: query: select cast(cast(3.14 as float) as decimal(4,2)) from decimal_2 limit 1
+PREHOOK: query: select cast(cast(3.14 as float) as decimal(4,2)) from decimal_2
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_2
#### A masked pattern was here ####
-POSTHOOK: query: select cast(cast(3.14 as float) as decimal(4,2)) from decimal_2 limit 1
+POSTHOOK: query: select cast(cast(3.14 as float) as decimal(4,2)) from decimal_2
POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_2
#### A masked pattern was here ####
POSTHOOK: Lineage: decimal_2.t EXPRESSION []
POSTHOOK: Lineage: decimal_2.t EXPRESSION []
3.14
-PREHOOK: query: select cast(cast('2012-12-19 11:12:19.1234567' as timestamp) as decimal(30,8)) from decimal_2 limit 1
+PREHOOK: query: select cast(cast('2012-12-19 11:12:19.1234567' as timestamp) as decimal(30,8)) from decimal_2
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_2
#### A masked pattern was here ####
-POSTHOOK: query: select cast(cast('2012-12-19 11:12:19.1234567' as timestamp) as decimal(30,8)) from decimal_2 limit 1
+POSTHOOK: query: select cast(cast('2012-12-19 11:12:19.1234567' as timestamp) as decimal(30,8)) from decimal_2
POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_2
#### A masked pattern was here ####
POSTHOOK: Lineage: decimal_2.t EXPRESSION []
POSTHOOK: Lineage: decimal_2.t EXPRESSION []
1355944339.1234567
-PREHOOK: query: select cast(true as decimal) from decimal_2 limit 1
+PREHOOK: query: select cast(true as decimal) from decimal_2
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_2
#### A masked pattern was here ####
-POSTHOOK: query: select cast(true as decimal) from decimal_2 limit 1
+POSTHOOK: query: select cast(true as decimal) from decimal_2
POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_2
#### A masked pattern was here ####
POSTHOOK: Lineage: decimal_2.t EXPRESSION []
POSTHOOK: Lineage: decimal_2.t EXPRESSION []
1
-PREHOOK: query: select cast(3Y as decimal) from decimal_2 limit 1
+PREHOOK: query: select cast(3Y as decimal) from decimal_2
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_2
#### A masked pattern was here ####
-POSTHOOK: query: select cast(3Y as decimal) from decimal_2 limit 1
+POSTHOOK: query: select cast(3Y as decimal) from decimal_2
POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_2
#### A masked pattern was here ####
POSTHOOK: Lineage: decimal_2.t EXPRESSION []
POSTHOOK: Lineage: decimal_2.t EXPRESSION []
3
-PREHOOK: query: select cast(3S as decimal) from decimal_2 limit 1
+PREHOOK: query: select cast(3S as decimal) from decimal_2
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_2
#### A masked pattern was here ####
-POSTHOOK: query: select cast(3S as decimal) from decimal_2 limit 1
+POSTHOOK: query: select cast(3S as decimal) from decimal_2
POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_2
#### A masked pattern was here ####
POSTHOOK: Lineage: decimal_2.t EXPRESSION []
POSTHOOK: Lineage: decimal_2.t EXPRESSION []
3
-PREHOOK: query: select cast(cast(3 as int) as decimal) from decimal_2 limit 1
+PREHOOK: query: select cast(cast(3 as int) as decimal) from decimal_2
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_2
#### A masked pattern was here ####
-POSTHOOK: query: select cast(cast(3 as int) as decimal) from decimal_2 limit 1
+POSTHOOK: query: select cast(cast(3 as int) as decimal) from decimal_2
POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_2
#### A masked pattern was here ####
POSTHOOK: Lineage: decimal_2.t EXPRESSION []
POSTHOOK: Lineage: decimal_2.t EXPRESSION []
3
-PREHOOK: query: select cast(3L as decimal) from decimal_2 limit 1
+PREHOOK: query: select cast(3L as decimal) from decimal_2
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_2
#### A masked pattern was here ####
-POSTHOOK: query: select cast(3L as decimal) from decimal_2 limit 1
+POSTHOOK: query: select cast(3L as decimal) from decimal_2
POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_2
#### A masked pattern was here ####
POSTHOOK: Lineage: decimal_2.t EXPRESSION []
POSTHOOK: Lineage: decimal_2.t EXPRESSION []
3
-PREHOOK: query: select cast(0.99999999999999999999 as decimal(20,19)) from decimal_2 limit 1
+PREHOOK: query: select cast(0.99999999999999999999 as decimal(20,19)) from decimal_2
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_2
#### A masked pattern was here ####
-POSTHOOK: query: select cast(0.99999999999999999999 as decimal(20,19)) from decimal_2 limit 1
+POSTHOOK: query: select cast(0.99999999999999999999 as decimal(20,19)) from decimal_2
POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_2
#### A masked pattern was here ####
POSTHOOK: Lineage: decimal_2.t EXPRESSION []
POSTHOOK: Lineage: decimal_2.t EXPRESSION []
1
-PREHOOK: query: select cast('0.99999999999999999999' as decimal(20,20)) from decimal_2 limit 1
+PREHOOK: query: select cast('0.99999999999999999999' as decimal(20,20)) from decimal_2
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_2
#### A masked pattern was here ####
-POSTHOOK: query: select cast('0.99999999999999999999' as decimal(20,20)) from decimal_2 limit 1
+POSTHOOK: query: select cast('0.99999999999999999999' as decimal(20,20)) from decimal_2
POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_2
#### A masked pattern was here ####
Modified: hive/branches/tez/ql/src/test/results/clientpositive/decimal_3.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/decimal_3.q.out?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/decimal_3.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/decimal_3.q.out Tue Nov 5 07:01:32 2013
@@ -13,10 +13,10 @@ ROW FORMAT DELIMITED
STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@DECIMAL_3
-PREHOOK: query: LOAD DATA LOCAL INPATH '../data/files/kv7.txt' INTO TABLE DECIMAL_3
+PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/kv7.txt' INTO TABLE DECIMAL_3
PREHOOK: type: LOAD
PREHOOK: Output: default@decimal_3
-POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/kv7.txt' INTO TABLE DECIMAL_3
+POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/kv7.txt' INTO TABLE DECIMAL_3
POSTHOOK: type: LOAD
POSTHOOK: Output: default@decimal_3
PREHOOK: query: SELECT * FROM DECIMAL_3 ORDER BY key, value
Modified: hive/branches/tez/ql/src/test/results/clientpositive/decimal_4.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/decimal_4.q.out?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/decimal_4.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/decimal_4.q.out Tue Nov 5 07:01:32 2013
@@ -24,10 +24,10 @@ POSTHOOK: query: CREATE TABLE DECIMAL_4_
STORED AS ORC
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@DECIMAL_4_2
-PREHOOK: query: LOAD DATA LOCAL INPATH '../data/files/kv7.txt' INTO TABLE DECIMAL_4_1
+PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/kv7.txt' INTO TABLE DECIMAL_4_1
PREHOOK: type: LOAD
PREHOOK: Output: default@decimal_4_1
-POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/kv7.txt' INTO TABLE DECIMAL_4_1
+POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/kv7.txt' INTO TABLE DECIMAL_4_1
POSTHOOK: type: LOAD
POSTHOOK: Output: default@decimal_4_1
PREHOOK: query: INSERT OVERWRITE TABLE DECIMAL_4_2 SELECT key, key * 3 FROM DECIMAL_4_1
Modified: hive/branches/tez/ql/src/test/results/clientpositive/decimal_5.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/decimal_5.q.out?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/decimal_5.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/decimal_5.q.out Tue Nov 5 07:01:32 2013
@@ -13,10 +13,10 @@ ROW FORMAT DELIMITED
STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@DECIMAL_5
-PREHOOK: query: LOAD DATA LOCAL INPATH '../data/files/kv7.txt' INTO TABLE DECIMAL_5
+PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/kv7.txt' INTO TABLE DECIMAL_5
PREHOOK: type: LOAD
PREHOOK: Output: default@decimal_5
-POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/kv7.txt' INTO TABLE DECIMAL_5
+POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/kv7.txt' INTO TABLE DECIMAL_5
POSTHOOK: type: LOAD
POSTHOOK: Output: default@decimal_5
PREHOOK: query: SELECT key FROM DECIMAL_5 ORDER BY key
Modified: hive/branches/tez/ql/src/test/results/clientpositive/decimal_6.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/decimal_6.q.out?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/decimal_6.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/decimal_6.q.out Tue Nov 5 07:01:32 2013
@@ -32,16 +32,16 @@ ROW FORMAT DELIMITED
STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@DECIMAL_6_2
-PREHOOK: query: LOAD DATA LOCAL INPATH '../data/files/kv9.txt' INTO TABLE DECIMAL_6_1
+PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/kv9.txt' INTO TABLE DECIMAL_6_1
PREHOOK: type: LOAD
PREHOOK: Output: default@decimal_6_1
-POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/kv9.txt' INTO TABLE DECIMAL_6_1
+POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/kv9.txt' INTO TABLE DECIMAL_6_1
POSTHOOK: type: LOAD
POSTHOOK: Output: default@decimal_6_1
-PREHOOK: query: LOAD DATA LOCAL INPATH '../data/files/kv9.txt' INTO TABLE DECIMAL_6_2
+PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/kv9.txt' INTO TABLE DECIMAL_6_2
PREHOOK: type: LOAD
PREHOOK: Output: default@decimal_6_2
-POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/kv9.txt' INTO TABLE DECIMAL_6_2
+POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/kv9.txt' INTO TABLE DECIMAL_6_2
POSTHOOK: type: LOAD
POSTHOOK: Output: default@decimal_6_2
PREHOOK: query: SELECT T.key from (
Modified: hive/branches/tez/ql/src/test/results/clientpositive/decimal_join.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/decimal_join.q.out?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/decimal_join.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/decimal_join.q.out Tue Nov 5 07:01:32 2013
@@ -7,10 +7,10 @@ POSTHOOK: query: -- HIVE-5292 Join on de
create table src_dec (key decimal(3,0), value string)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@src_dec
-PREHOOK: query: load data local inpath '../data/files/kv1.txt' into table src_dec
+PREHOOK: query: load data local inpath '../../data/files/kv1.txt' into table src_dec
PREHOOK: type: LOAD
PREHOOK: Output: default@src_dec
-POSTHOOK: query: load data local inpath '../data/files/kv1.txt' into table src_dec
+POSTHOOK: query: load data local inpath '../../data/files/kv1.txt' into table src_dec
POSTHOOK: type: LOAD
POSTHOOK: Output: default@src_dec
PREHOOK: query: select * from src_dec a join src_dec b on a.key=b.key+450
Modified: hive/branches/tez/ql/src/test/results/clientpositive/decimal_precision.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/decimal_precision.q.out?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/decimal_precision.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/decimal_precision.q.out Tue Nov 5 07:01:32 2013
@@ -13,10 +13,10 @@ ROW FORMAT DELIMITED
STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@DECIMAL_PRECISION
-PREHOOK: query: LOAD DATA LOCAL INPATH '../data/files/kv8.txt' INTO TABLE DECIMAL_PRECISION
+PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/kv8.txt' INTO TABLE DECIMAL_PRECISION
PREHOOK: type: LOAD
PREHOOK: Output: default@decimal_precision
-POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/kv8.txt' INTO TABLE DECIMAL_PRECISION
+POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/kv8.txt' INTO TABLE DECIMAL_PRECISION
POSTHOOK: type: LOAD
POSTHOOK: Output: default@decimal_precision
PREHOOK: query: SELECT * FROM DECIMAL_PRECISION ORDER BY dec
Modified: hive/branches/tez/ql/src/test/results/clientpositive/decimal_serde.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/decimal_serde.q.out?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/decimal_serde.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/decimal_serde.q.out Tue Nov 5 07:01:32 2013
@@ -25,10 +25,10 @@ ROW FORMAT DELIMITED
STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@DECIMAL_TEXT
-PREHOOK: query: LOAD DATA LOCAL INPATH '../data/files/kv7.txt' INTO TABLE DECIMAL_TEXT
+PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/kv7.txt' INTO TABLE DECIMAL_TEXT
PREHOOK: type: LOAD
PREHOOK: Output: default@decimal_text
-POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/kv7.txt' INTO TABLE DECIMAL_TEXT
+POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/kv7.txt' INTO TABLE DECIMAL_TEXT
POSTHOOK: type: LOAD
POSTHOOK: Output: default@decimal_text
PREHOOK: query: SELECT * FROM DECIMAL_TEXT ORDER BY key, value
Modified: hive/branches/tez/ql/src/test/results/clientpositive/decimal_udf.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/decimal_udf.q.out?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/decimal_udf.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/decimal_udf.q.out Tue Nov 5 07:01:32 2013
@@ -13,10 +13,10 @@ ROW FORMAT DELIMITED
STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@DECIMAL_UDF
-PREHOOK: query: LOAD DATA LOCAL INPATH '../data/files/kv7.txt' INTO TABLE DECIMAL_UDF
+PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/kv7.txt' INTO TABLE DECIMAL_UDF
PREHOOK: type: LOAD
PREHOOK: Output: default@decimal_udf
-POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/kv7.txt' INTO TABLE DECIMAL_UDF
+POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/kv7.txt' INTO TABLE DECIMAL_UDF
POSTHOOK: type: LOAD
POSTHOOK: Output: default@decimal_udf
PREHOOK: query: -- addition
@@ -29,32 +29,21 @@ ABSTRACT SYNTAX TREE:
(TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME DECIMAL_UDF))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (+ (TOK_TABLE_OR_COL key) (TOK_TABLE_OR_COL key))))))
STAGE DEPENDENCIES:
- Stage-1 is a root stage
Stage-0 is a root stage
STAGE PLANS:
- Stage: Stage-1
- Map Reduce
- Alias -> Map Operator Tree:
- decimal_udf
- TableScan
- alias: decimal_udf
- Select Operator
- expressions:
- expr: (key + key)
- type: decimal(65,30)
- outputColumnNames: _col0
- 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
-
Stage: Stage-0
Fetch Operator
limit: -1
+ Processor Tree:
+ TableScan
+ alias: decimal_udf
+ Select Operator
+ expressions:
+ expr: (key + key)
+ type: decimal(65,30)
+ outputColumnNames: _col0
+ ListSink
PREHOOK: query: SELECT key + key FROM DECIMAL_UDF
@@ -111,32 +100,21 @@ ABSTRACT SYNTAX TREE:
(TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME DECIMAL_UDF))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (+ (TOK_TABLE_OR_COL key) (TOK_TABLE_OR_COL value))))))
STAGE DEPENDENCIES:
- Stage-1 is a root stage
Stage-0 is a root stage
STAGE PLANS:
- Stage: Stage-1
- Map Reduce
- Alias -> Map Operator Tree:
- decimal_udf
- TableScan
- alias: decimal_udf
- Select Operator
- expressions:
- expr: (key + value)
- type: decimal(65,30)
- outputColumnNames: _col0
- 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
-
Stage: Stage-0
Fetch Operator
limit: -1
+ Processor Tree:
+ TableScan
+ alias: decimal_udf
+ Select Operator
+ expressions:
+ expr: (key + value)
+ type: decimal(65,30)
+ outputColumnNames: _col0
+ ListSink
PREHOOK: query: SELECT key + value FROM DECIMAL_UDF
@@ -193,32 +171,21 @@ ABSTRACT SYNTAX TREE:
(TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME DECIMAL_UDF))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (+ (TOK_TABLE_OR_COL key) (/ (TOK_TABLE_OR_COL value) 2))))))
STAGE DEPENDENCIES:
- Stage-1 is a root stage
Stage-0 is a root stage
STAGE PLANS:
- Stage: Stage-1
- Map Reduce
- Alias -> Map Operator Tree:
- decimal_udf
- TableScan
- alias: decimal_udf
- Select Operator
- expressions:
- expr: (key + (value / 2))
- type: decimal(65,30)
- outputColumnNames: _col0
- 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
-
Stage: Stage-0
Fetch Operator
limit: -1
+ Processor Tree:
+ TableScan
+ alias: decimal_udf
+ Select Operator
+ expressions:
+ expr: (key + (value / 2))
+ type: decimal(65,30)
+ outputColumnNames: _col0
+ ListSink
PREHOOK: query: SELECT key + (value/2) FROM DECIMAL_UDF
@@ -275,32 +242,21 @@ ABSTRACT SYNTAX TREE:
(TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME DECIMAL_UDF))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (+ (TOK_TABLE_OR_COL key) '1.0')))))
STAGE DEPENDENCIES:
- Stage-1 is a root stage
Stage-0 is a root stage
STAGE PLANS:
- Stage: Stage-1
- Map Reduce
- Alias -> Map Operator Tree:
- decimal_udf
- TableScan
- alias: decimal_udf
- Select Operator
- expressions:
- expr: (key + '1.0')
- type: decimal(65,30)
- outputColumnNames: _col0
- 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
-
Stage: Stage-0
Fetch Operator
limit: -1
+ Processor Tree:
+ TableScan
+ alias: decimal_udf
+ Select Operator
+ expressions:
+ expr: (key + '1.0')
+ type: decimal(65,30)
+ outputColumnNames: _col0
+ ListSink
PREHOOK: query: SELECT key + '1.0' FROM DECIMAL_UDF
@@ -359,32 +315,21 @@ ABSTRACT SYNTAX TREE:
(TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME DECIMAL_UDF))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (- (TOK_TABLE_OR_COL key) (TOK_TABLE_OR_COL key))))))
STAGE DEPENDENCIES:
- Stage-1 is a root stage
Stage-0 is a root stage
STAGE PLANS:
- Stage: Stage-1
- Map Reduce
- Alias -> Map Operator Tree:
- decimal_udf
- TableScan
- alias: decimal_udf
- Select Operator
- expressions:
- expr: (key - key)
- type: decimal(65,30)
- outputColumnNames: _col0
- 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
-
Stage: Stage-0
Fetch Operator
limit: -1
+ Processor Tree:
+ TableScan
+ alias: decimal_udf
+ Select Operator
+ expressions:
+ expr: (key - key)
+ type: decimal(65,30)
+ outputColumnNames: _col0
+ ListSink
PREHOOK: query: SELECT key - key FROM DECIMAL_UDF
@@ -441,32 +386,21 @@ ABSTRACT SYNTAX TREE:
(TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME DECIMAL_UDF))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (- (TOK_TABLE_OR_COL key) (TOK_TABLE_OR_COL value))))))
STAGE DEPENDENCIES:
- Stage-1 is a root stage
Stage-0 is a root stage
STAGE PLANS:
- Stage: Stage-1
- Map Reduce
- Alias -> Map Operator Tree:
- decimal_udf
- TableScan
- alias: decimal_udf
- Select Operator
- expressions:
- expr: (key - value)
- type: decimal(65,30)
- outputColumnNames: _col0
- 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
-
Stage: Stage-0
Fetch Operator
limit: -1
+ Processor Tree:
+ TableScan
+ alias: decimal_udf
+ Select Operator
+ expressions:
+ expr: (key - value)
+ type: decimal(65,30)
+ outputColumnNames: _col0
+ ListSink
PREHOOK: query: SELECT key - value FROM DECIMAL_UDF
@@ -523,32 +457,21 @@ ABSTRACT SYNTAX TREE:
(TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME DECIMAL_UDF))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (- (TOK_TABLE_OR_COL key) (/ (TOK_TABLE_OR_COL value) 2))))))
STAGE DEPENDENCIES:
- Stage-1 is a root stage
Stage-0 is a root stage
STAGE PLANS:
- Stage: Stage-1
- Map Reduce
- Alias -> Map Operator Tree:
- decimal_udf
- TableScan
- alias: decimal_udf
- Select Operator
- expressions:
- expr: (key - (value / 2))
- type: decimal(65,30)
- outputColumnNames: _col0
- 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
-
Stage: Stage-0
Fetch Operator
limit: -1
+ Processor Tree:
+ TableScan
+ alias: decimal_udf
+ Select Operator
+ expressions:
+ expr: (key - (value / 2))
+ type: decimal(65,30)
+ outputColumnNames: _col0
+ ListSink
PREHOOK: query: SELECT key - (value/2) FROM DECIMAL_UDF
@@ -605,32 +528,21 @@ ABSTRACT SYNTAX TREE:
(TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME DECIMAL_UDF))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (- (TOK_TABLE_OR_COL key) '1.0')))))
STAGE DEPENDENCIES:
- Stage-1 is a root stage
Stage-0 is a root stage
STAGE PLANS:
- Stage: Stage-1
- Map Reduce
- Alias -> Map Operator Tree:
- decimal_udf
- TableScan
- alias: decimal_udf
- Select Operator
- expressions:
- expr: (key - '1.0')
- type: decimal(65,30)
- outputColumnNames: _col0
- 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
-
Stage: Stage-0
Fetch Operator
limit: -1
+ Processor Tree:
+ TableScan
+ alias: decimal_udf
+ Select Operator
+ expressions:
+ expr: (key - '1.0')
+ type: decimal(65,30)
+ outputColumnNames: _col0
+ ListSink
PREHOOK: query: SELECT key - '1.0' FROM DECIMAL_UDF
@@ -689,32 +601,21 @@ ABSTRACT SYNTAX TREE:
(TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME DECIMAL_UDF))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (* (TOK_TABLE_OR_COL key) (TOK_TABLE_OR_COL key))))))
STAGE DEPENDENCIES:
- Stage-1 is a root stage
Stage-0 is a root stage
STAGE PLANS:
- Stage: Stage-1
- Map Reduce
- Alias -> Map Operator Tree:
- decimal_udf
- TableScan
- alias: decimal_udf
- Select Operator
- expressions:
- expr: (key * key)
- type: decimal(65,30)
- outputColumnNames: _col0
- 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
-
Stage: Stage-0
Fetch Operator
limit: -1
+ Processor Tree:
+ TableScan
+ alias: decimal_udf
+ Select Operator
+ expressions:
+ expr: (key * key)
+ type: decimal(65,30)
+ outputColumnNames: _col0
+ ListSink
PREHOOK: query: SELECT key * key FROM DECIMAL_UDF
@@ -771,32 +672,21 @@ ABSTRACT SYNTAX TREE:
(TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME DECIMAL_UDF))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (* (TOK_TABLE_OR_COL key) (TOK_TABLE_OR_COL value))))))
STAGE DEPENDENCIES:
- Stage-1 is a root stage
Stage-0 is a root stage
STAGE PLANS:
- Stage: Stage-1
- Map Reduce
- Alias -> Map Operator Tree:
- decimal_udf
- TableScan
- alias: decimal_udf
- Select Operator
- expressions:
- expr: (key * value)
- type: decimal(65,30)
- outputColumnNames: _col0
- 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
-
Stage: Stage-0
Fetch Operator
limit: -1
+ Processor Tree:
+ TableScan
+ alias: decimal_udf
+ Select Operator
+ expressions:
+ expr: (key * value)
+ type: decimal(65,30)
+ outputColumnNames: _col0
+ ListSink
PREHOOK: query: SELECT key * value FROM DECIMAL_UDF
@@ -853,32 +743,21 @@ ABSTRACT SYNTAX TREE:
(TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME DECIMAL_UDF))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (* (TOK_TABLE_OR_COL key) (/ (TOK_TABLE_OR_COL value) 2))))))
STAGE DEPENDENCIES:
- Stage-1 is a root stage
Stage-0 is a root stage
STAGE PLANS:
- Stage: Stage-1
- Map Reduce
- Alias -> Map Operator Tree:
- decimal_udf
- TableScan
- alias: decimal_udf
- Select Operator
- expressions:
- expr: (key * (value / 2))
- type: decimal(65,30)
- outputColumnNames: _col0
- 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
-
Stage: Stage-0
Fetch Operator
limit: -1
+ Processor Tree:
+ TableScan
+ alias: decimal_udf
+ Select Operator
+ expressions:
+ expr: (key * (value / 2))
+ type: decimal(65,30)
+ outputColumnNames: _col0
+ ListSink
PREHOOK: query: SELECT key * (value/2) FROM DECIMAL_UDF
@@ -935,32 +814,21 @@ ABSTRACT SYNTAX TREE:
(TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME DECIMAL_UDF))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (* (TOK_TABLE_OR_COL key) '2.0')))))
STAGE DEPENDENCIES:
- Stage-1 is a root stage
Stage-0 is a root stage
STAGE PLANS:
- Stage: Stage-1
- Map Reduce
- Alias -> Map Operator Tree:
- decimal_udf
- TableScan
- alias: decimal_udf
- Select Operator
- expressions:
- expr: (key * '2.0')
- type: decimal(65,30)
- outputColumnNames: _col0
- 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
-
Stage: Stage-0
Fetch Operator
limit: -1
+ Processor Tree:
+ TableScan
+ alias: decimal_udf
+ Select Operator
+ expressions:
+ expr: (key * '2.0')
+ type: decimal(65,30)
+ outputColumnNames: _col0
+ ListSink
PREHOOK: query: SELECT key * '2.0' FROM DECIMAL_UDF
@@ -1019,33 +887,22 @@ ABSTRACT SYNTAX TREE:
(TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME DECIMAL_UDF))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (/ (TOK_TABLE_OR_COL key) 0))) (TOK_LIMIT 1)))
STAGE DEPENDENCIES:
- Stage-1 is a root stage
Stage-0 is a root stage
STAGE PLANS:
- Stage: Stage-1
- Map Reduce
- Alias -> Map Operator Tree:
- decimal_udf
- TableScan
- alias: decimal_udf
- Select Operator
- expressions:
- expr: (key / 0)
- type: decimal(65,30)
- outputColumnNames: _col0
- Limit
- 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
-
Stage: Stage-0
Fetch Operator
limit: 1
+ Processor Tree:
+ TableScan
+ alias: decimal_udf
+ Select Operator
+ expressions:
+ expr: (key / 0)
+ type: decimal(65,30)
+ outputColumnNames: _col0
+ Limit
+ ListSink
PREHOOK: query: SELECT key / 0 FROM DECIMAL_UDF limit 1
@@ -1065,33 +922,22 @@ ABSTRACT SYNTAX TREE:
(TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME DECIMAL_UDF))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (/ (TOK_TABLE_OR_COL key) TOK_NULL))) (TOK_LIMIT 1)))
STAGE DEPENDENCIES:
- Stage-1 is a root stage
Stage-0 is a root stage
STAGE PLANS:
- Stage: Stage-1
- Map Reduce
- Alias -> Map Operator Tree:
- decimal_udf
- TableScan
- alias: decimal_udf
- Select Operator
- expressions:
- expr: (key / null)
- type: decimal(65,30)
- outputColumnNames: _col0
- Limit
- 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
-
Stage: Stage-0
Fetch Operator
limit: 1
+ Processor Tree:
+ TableScan
+ alias: decimal_udf
+ Select Operator
+ expressions:
+ expr: (key / null)
+ type: decimal(65,30)
+ outputColumnNames: _col0
+ Limit
+ ListSink
PREHOOK: query: SELECT key / NULL FROM DECIMAL_UDF limit 1
@@ -1111,36 +957,25 @@ ABSTRACT SYNTAX TREE:
(TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME DECIMAL_UDF))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (/ (TOK_TABLE_OR_COL key) (TOK_TABLE_OR_COL key)))) (TOK_WHERE (and (TOK_FUNCTION TOK_ISNOTNULL (TOK_TABLE_OR_COL key)) (<> (TOK_TABLE_OR_COL key) 0)))))
STAGE DEPENDENCIES:
- Stage-1 is a root stage
Stage-0 is a root stage
STAGE PLANS:
- Stage: Stage-1
- Map Reduce
- Alias -> Map Operator Tree:
- decimal_udf
- TableScan
- alias: decimal_udf
- Filter Operator
- predicate:
- expr: (key is not null and (key <> 0))
- type: boolean
- Select Operator
- expressions:
- expr: (key / key)
- type: decimal(65,30)
- outputColumnNames: _col0
- 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
-
Stage: Stage-0
Fetch Operator
limit: -1
+ Processor Tree:
+ TableScan
+ alias: decimal_udf
+ Filter Operator
+ predicate:
+ expr: (key is not null and (key <> 0))
+ type: boolean
+ Select Operator
+ expressions:
+ expr: (key / key)
+ type: decimal(65,30)
+ outputColumnNames: _col0
+ ListSink
PREHOOK: query: SELECT key / key FROM DECIMAL_UDF WHERE key is not null and key <> 0
@@ -1193,36 +1028,25 @@ ABSTRACT SYNTAX TREE:
(TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME DECIMAL_UDF))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (/ (TOK_TABLE_OR_COL key) (TOK_TABLE_OR_COL value)))) (TOK_WHERE (and (TOK_FUNCTION TOK_ISNOTNULL (TOK_TABLE_OR_COL value)) (<> (TOK_TABLE_OR_COL value) 0)))))
STAGE DEPENDENCIES:
- Stage-1 is a root stage
Stage-0 is a root stage
STAGE PLANS:
- Stage: Stage-1
- Map Reduce
- Alias -> Map Operator Tree:
- decimal_udf
- TableScan
- alias: decimal_udf
- Filter Operator
- predicate:
- expr: (value is not null and (value <> 0))
- type: boolean
- Select Operator
- expressions:
- expr: (key / value)
- type: decimal(65,30)
- outputColumnNames: _col0
- 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
-
Stage: Stage-0
Fetch Operator
limit: -1
+ Processor Tree:
+ TableScan
+ alias: decimal_udf
+ Filter Operator
+ predicate:
+ expr: (value is not null and (value <> 0))
+ type: boolean
+ Select Operator
+ expressions:
+ expr: (key / value)
+ type: decimal(65,30)
+ outputColumnNames: _col0
+ ListSink
PREHOOK: query: SELECT key / value FROM DECIMAL_UDF WHERE value is not null and value <> 0
@@ -1265,36 +1089,25 @@ ABSTRACT SYNTAX TREE:
(TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME DECIMAL_UDF))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (/ (TOK_TABLE_OR_COL key) (/ (TOK_TABLE_OR_COL value) 2)))) (TOK_WHERE (and (TOK_FUNCTION TOK_ISNOTNULL (TOK_TABLE_OR_COL value)) (<> (TOK_TABLE_OR_COL value) 0)))))
STAGE DEPENDENCIES:
- Stage-1 is a root stage
Stage-0 is a root stage
STAGE PLANS:
- Stage: Stage-1
- Map Reduce
- Alias -> Map Operator Tree:
- decimal_udf
- TableScan
- alias: decimal_udf
- Filter Operator
- predicate:
- expr: (value is not null and (value <> 0))
- type: boolean
- Select Operator
- expressions:
- expr: (key / (value / 2))
- type: decimal(65,30)
- outputColumnNames: _col0
- 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
-
Stage: Stage-0
Fetch Operator
limit: -1
+ Processor Tree:
+ TableScan
+ alias: decimal_udf
+ Filter Operator
+ predicate:
+ expr: (value is not null and (value <> 0))
+ type: boolean
+ Select Operator
+ expressions:
+ expr: (key / (value / 2))
+ type: decimal(65,30)
+ outputColumnNames: _col0
+ ListSink
PREHOOK: query: SELECT key / (value/2) FROM DECIMAL_UDF WHERE value is not null and value <> 0
@@ -1337,32 +1150,21 @@ ABSTRACT SYNTAX TREE:
(TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME DECIMAL_UDF))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (/ (TOK_TABLE_OR_COL key) '2.0')))))
STAGE DEPENDENCIES:
- Stage-1 is a root stage
Stage-0 is a root stage
STAGE PLANS:
- Stage: Stage-1
- Map Reduce
- Alias -> Map Operator Tree:
- decimal_udf
- TableScan
- alias: decimal_udf
- Select Operator
- expressions:
- expr: (key / '2.0')
- type: decimal(65,30)
- outputColumnNames: _col0
- 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
-
Stage: Stage-0
Fetch Operator
limit: -1
+ Processor Tree:
+ TableScan
+ alias: decimal_udf
+ Select Operator
+ expressions:
+ expr: (key / '2.0')
+ type: decimal(65,30)
+ outputColumnNames: _col0
+ ListSink
PREHOOK: query: SELECT key / '2.0' FROM DECIMAL_UDF
@@ -1421,32 +1223,21 @@ ABSTRACT SYNTAX TREE:
(TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME DECIMAL_UDF))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION abs (TOK_TABLE_OR_COL key))))))
STAGE DEPENDENCIES:
- Stage-1 is a root stage
Stage-0 is a root stage
STAGE PLANS:
- Stage: Stage-1
- Map Reduce
- Alias -> Map Operator Tree:
- decimal_udf
- TableScan
- alias: decimal_udf
- Select Operator
- expressions:
- expr: abs(key)
- type: decimal(65,30)
- outputColumnNames: _col0
- 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
-
Stage: Stage-0
Fetch Operator
limit: -1
+ Processor Tree:
+ TableScan
+ alias: decimal_udf
+ Select Operator
+ expressions:
+ expr: abs(key)
+ type: decimal(65,30)
+ outputColumnNames: _col0
+ ListSink
PREHOOK: query: SELECT abs(key) FROM DECIMAL_UDF
@@ -1647,32 +1438,21 @@ ABSTRACT SYNTAX TREE:
(TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME DECIMAL_UDF))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (- (TOK_TABLE_OR_COL key))))))
STAGE DEPENDENCIES:
- Stage-1 is a root stage
Stage-0 is a root stage
STAGE PLANS:
- Stage: Stage-1
- Map Reduce
- Alias -> Map Operator Tree:
- decimal_udf
- TableScan
- alias: decimal_udf
- Select Operator
- expressions:
- expr: (- key)
- type: decimal(65,30)
- outputColumnNames: _col0
- 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
-
Stage: Stage-0
Fetch Operator
limit: -1
+ Processor Tree:
+ TableScan
+ alias: decimal_udf
+ Select Operator
+ expressions:
+ expr: (- key)
+ type: decimal(65,30)
+ outputColumnNames: _col0
+ ListSink
PREHOOK: query: SELECT -key FROM DECIMAL_UDF
@@ -1731,32 +1511,21 @@ ABSTRACT SYNTAX TREE:
(TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME DECIMAL_UDF))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (+ (TOK_TABLE_OR_COL key))))))
STAGE DEPENDENCIES:
- Stage-1 is a root stage
Stage-0 is a root stage
STAGE PLANS:
- Stage: Stage-1
- Map Reduce
- Alias -> Map Operator Tree:
- decimal_udf
- TableScan
- alias: decimal_udf
- Select Operator
- expressions:
- expr: key
- type: decimal(65,30)
- outputColumnNames: _col0
- 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
-
Stage: Stage-0
Fetch Operator
limit: -1
+ Processor Tree:
+ TableScan
+ alias: decimal_udf
+ Select Operator
+ expressions:
+ expr: key
+ type: decimal(65,30)
+ outputColumnNames: _col0
+ ListSink
PREHOOK: query: SELECT +key FROM DECIMAL_UDF
@@ -1815,32 +1584,21 @@ ABSTRACT SYNTAX TREE:
(TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME DECIMAL_UDF))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION CEIL (TOK_TABLE_OR_COL key))))))
STAGE DEPENDENCIES:
- Stage-1 is a root stage
Stage-0 is a root stage
STAGE PLANS:
- Stage: Stage-1
- Map Reduce
- Alias -> Map Operator Tree:
- decimal_udf
- TableScan
- alias: decimal_udf
- Select Operator
- expressions:
- expr: ceil(key)
- type: decimal(65,30)
- outputColumnNames: _col0
- 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
-
Stage: Stage-0
Fetch Operator
limit: -1
+ Processor Tree:
+ TableScan
+ alias: decimal_udf
+ Select Operator
+ expressions:
+ expr: ceil(key)
+ type: decimal(65,30)
+ outputColumnNames: _col0
+ ListSink
PREHOOK: query: SELECT CEIL(key) FROM DECIMAL_UDF
@@ -1899,32 +1657,21 @@ ABSTRACT SYNTAX TREE:
(TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME DECIMAL_UDF))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION FLOOR (TOK_TABLE_OR_COL key))))))
STAGE DEPENDENCIES:
- Stage-1 is a root stage
Stage-0 is a root stage
STAGE PLANS:
- Stage: Stage-1
- Map Reduce
- Alias -> Map Operator Tree:
- decimal_udf
- TableScan
- alias: decimal_udf
- Select Operator
- expressions:
- expr: floor(key)
- type: decimal(65,30)
- outputColumnNames: _col0
- 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
-
Stage: Stage-0
Fetch Operator
limit: -1
+ Processor Tree:
+ TableScan
+ alias: decimal_udf
+ Select Operator
+ expressions:
+ expr: floor(key)
+ type: decimal(65,30)
+ outputColumnNames: _col0
+ ListSink
PREHOOK: query: SELECT FLOOR(key) FROM DECIMAL_UDF
@@ -1983,32 +1730,21 @@ ABSTRACT SYNTAX TREE:
(TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME DECIMAL_UDF))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION ROUND (TOK_TABLE_OR_COL key) 2)))))
STAGE DEPENDENCIES:
- Stage-1 is a root stage
Stage-0 is a root stage
STAGE PLANS:
- Stage: Stage-1
- Map Reduce
- Alias -> Map Operator Tree:
- decimal_udf
- TableScan
- alias: decimal_udf
- Select Operator
- expressions:
- expr: round(key, 2)
- type: decimal(65,30)
- outputColumnNames: _col0
- 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
-
Stage: Stage-0
Fetch Operator
limit: -1
+ Processor Tree:
+ TableScan
+ alias: decimal_udf
+ Select Operator
+ expressions:
+ expr: round(key, 2)
+ type: decimal(65,30)
+ outputColumnNames: _col0
+ ListSink
PREHOOK: query: SELECT ROUND(key, 2) FROM DECIMAL_UDF
@@ -2067,32 +1803,21 @@ ABSTRACT SYNTAX TREE:
(TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME DECIMAL_UDF))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION POWER (TOK_TABLE_OR_COL key) 2)))))
STAGE DEPENDENCIES:
- Stage-1 is a root stage
Stage-0 is a root stage
STAGE PLANS:
- Stage: Stage-1
- Map Reduce
- Alias -> Map Operator Tree:
- decimal_udf
- TableScan
- alias: decimal_udf
- Select Operator
- expressions:
- expr: power(key, 2)
- type: decimal(65,30)
- outputColumnNames: _col0
- 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
-
Stage: Stage-0
Fetch Operator
limit: -1
+ Processor Tree:
+ TableScan
+ alias: decimal_udf
+ Select Operator
+ expressions:
+ expr: power(key, 2)
+ type: decimal(65,30)
+ outputColumnNames: _col0
+ ListSink
PREHOOK: query: SELECT POWER(key, 2) FROM DECIMAL_UDF
@@ -2151,32 +1876,21 @@ ABSTRACT SYNTAX TREE:
(TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME DECIMAL_UDF))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (% (+ (TOK_TABLE_OR_COL key) 1) (/ (TOK_TABLE_OR_COL key) 2))))))
STAGE DEPENDENCIES:
- Stage-1 is a root stage
Stage-0 is a root stage
STAGE PLANS:
- Stage: Stage-1
- Map Reduce
- Alias -> Map Operator Tree:
- decimal_udf
- TableScan
- alias: decimal_udf
- Select Operator
- expressions:
- expr: ((key + 1) % (key / 2))
- type: decimal(65,30)
- outputColumnNames: _col0
- 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
-
Stage: Stage-0
Fetch Operator
limit: -1
+ Processor Tree:
+ TableScan
+ alias: decimal_udf
+ Select Operator
+ expressions:
+ expr: ((key + 1) % (key / 2))
+ type: decimal(65,30)
+ outputColumnNames: _col0
+ ListSink
PREHOOK: query: SELECT (key + 1) % (key / 2) FROM DECIMAL_UDF
Modified: hive/branches/tez/ql/src/test/results/clientpositive/delimiter.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/delimiter.q.out?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/delimiter.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/delimiter.q.out Tue Nov 5 07:01:32 2013
@@ -11,10 +11,10 @@ lines terminated by '\n'
stored as textfile
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@impressions
-PREHOOK: query: LOAD DATA LOCAL INPATH '../data/files/in7.txt' INTO TABLE impressions
+PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/in7.txt' INTO TABLE impressions
PREHOOK: type: LOAD
PREHOOK: Output: default@impressions
-POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/in7.txt' INTO TABLE impressions
+POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/in7.txt' INTO TABLE impressions
POSTHOOK: type: LOAD
POSTHOOK: Output: default@impressions
PREHOOK: query: select * from impressions