You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by am...@apache.org on 2013/04/17 09:29:46 UTC
svn commit: r1468783 [10/16] - in /hive/branches/HIVE-4115: ./
beeline/src/java/org/apache/hive/beeline/ beeline/src/test/org/
beeline/src/test/org/apache/ beeline/src/test/org/apache/hive/
beeline/src/test/org/apache/hive/beeline/ beeline/src/test/org...
Modified: hive/branches/HIVE-4115/ql/src/test/results/clientpositive/create_or_replace_view.q.out
URL: http://svn.apache.org/viewvc/hive/branches/HIVE-4115/ql/src/test/results/clientpositive/create_or_replace_view.q.out?rev=1468783&r1=1468782&r2=1468783&view=diff
==============================================================================
--- hive/branches/HIVE-4115/ql/src/test/results/clientpositive/create_or_replace_view.q.out (original)
+++ hive/branches/HIVE-4115/ql/src/test/results/clientpositive/create_or_replace_view.q.out Wed Apr 17 07:29:38 2013
@@ -4,11 +4,9 @@ POSTHOOK: query: drop view v
POSTHOOK: type: DROPVIEW
PREHOOK: query: create view v as select * from srcpart
PREHOOK: type: CREATEVIEW
-#### A masked pattern was here ####
POSTHOOK: query: create view v as select * from srcpart
POSTHOOK: type: CREATEVIEW
POSTHOOK: Output: default@v
-#### A masked pattern was here ####
PREHOOK: query: describe formatted v
PREHOOK: type: DESCTABLE
POSTHOOK: query: describe formatted v
@@ -44,12 +42,10 @@ View Expanded Text: select `srcpart`.`k
PREHOOK: query: -- modifying definition of unpartitioned view
create or replace view v partitioned on (ds, hr) as select * from srcpart
PREHOOK: type: CREATEVIEW
-#### A masked pattern was here ####
POSTHOOK: query: -- modifying definition of unpartitioned view
create or replace view v partitioned on (ds, hr) as select * from srcpart
POSTHOOK: type: CREATEVIEW
POSTHOOK: Output: default@v
-#### A masked pattern was here ####
PREHOOK: query: alter view v add partition (ds='2008-04-08',hr='11')
PREHOOK: type: ALTERTABLE_ADDPARTS
PREHOOK: Input: default@srcpart
@@ -132,12 +128,10 @@ ds=2008-04-08/hr=12
PREHOOK: query: -- altering partitioned view 1
create or replace view v partitioned on (ds, hr) as select value, ds, hr from srcpart
PREHOOK: type: CREATEVIEW
-#### A masked pattern was here ####
POSTHOOK: query: -- altering partitioned view 1
create or replace view v partitioned on (ds, hr) as select value, ds, hr from srcpart
POSTHOOK: type: CREATEVIEW
POSTHOOK: Output: default@v
-#### A masked pattern was here ####
PREHOOK: query: select * from v where value='val_409' and ds='2008-04-08' and hr='11'
PREHOOK: type: QUERY
PREHOOK: Input: default@srcpart
@@ -197,12 +191,10 @@ ds=2008-04-08/hr=12
PREHOOK: query: -- altering partitioned view 2
create or replace view v partitioned on (ds, hr) as select key, value, ds, hr from srcpart
PREHOOK: type: CREATEVIEW
-#### A masked pattern was here ####
POSTHOOK: query: -- altering partitioned view 2
create or replace view v partitioned on (ds, hr) as select key, value, ds, hr from srcpart
POSTHOOK: type: CREATEVIEW
POSTHOOK: Output: default@v
-#### A masked pattern was here ####
PREHOOK: query: select * from v where value='val_409' and ds='2008-04-08' and hr='11'
PREHOOK: type: QUERY
PREHOOK: Input: default@srcpart
@@ -277,11 +269,9 @@ POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@srcpart_temp
PREHOOK: query: create view v partitioned on (ds, hr) as select * from srcpart_temp
PREHOOK: type: CREATEVIEW
-#### A masked pattern was here ####
POSTHOOK: query: create view v partitioned on (ds, hr) as select * from srcpart_temp
POSTHOOK: type: CREATEVIEW
POSTHOOK: Output: default@v
-#### A masked pattern was here ####
PREHOOK: query: drop table srcpart_temp
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@srcpart_temp
@@ -293,12 +283,10 @@ POSTHOOK: Output: default@srcpart_temp
PREHOOK: query: -- v is now invalid
create or replace view v partitioned on (ds, hr) as select * from srcpart
PREHOOK: type: CREATEVIEW
-#### A masked pattern was here ####
POSTHOOK: query: -- v is now invalid
create or replace view v partitioned on (ds, hr) as select * from srcpart
POSTHOOK: type: CREATEVIEW
POSTHOOK: Output: default@v
-#### A masked pattern was here ####
PREHOOK: query: describe formatted v
PREHOOK: type: DESCTABLE
POSTHOOK: query: describe formatted v
Modified: hive/branches/HIVE-4115/ql/src/test/results/clientpositive/create_view.q.out
URL: http://svn.apache.org/viewvc/hive/branches/HIVE-4115/ql/src/test/results/clientpositive/create_view.q.out?rev=1468783&r1=1468782&r2=1468783&view=diff
==============================================================================
--- hive/branches/HIVE-4115/ql/src/test/results/clientpositive/create_view.q.out (original)
+++ hive/branches/HIVE-4115/ql/src/test/results/clientpositive/create_view.q.out Wed Apr 17 07:29:38 2013
@@ -85,29 +85,23 @@ POSTHOOK: Input: default@src
86 val_86
PREHOOK: query: CREATE VIEW view1 AS SELECT value FROM src WHERE key=86
PREHOOK: type: CREATEVIEW
-#### A masked pattern was here ####
POSTHOOK: query: CREATE VIEW view1 AS SELECT value FROM src WHERE key=86
POSTHOOK: type: CREATEVIEW
POSTHOOK: Output: default@view1
-#### A masked pattern was here ####
PREHOOK: query: CREATE VIEW view2 AS SELECT * FROM src
PREHOOK: type: CREATEVIEW
-#### A masked pattern was here ####
POSTHOOK: query: CREATE VIEW view2 AS SELECT * FROM src
POSTHOOK: type: CREATEVIEW
POSTHOOK: Output: default@view2
-#### A masked pattern was here ####
PREHOOK: query: CREATE VIEW view3(valoo)
TBLPROPERTIES ("fear" = "factor")
AS SELECT upper(value) FROM src WHERE key=86
PREHOOK: type: CREATEVIEW
-#### A masked pattern was here ####
POSTHOOK: query: CREATE VIEW view3(valoo)
TBLPROPERTIES ("fear" = "factor")
AS SELECT upper(value) FROM src WHERE key=86
POSTHOOK: type: CREATEVIEW
POSTHOOK: Output: default@view3
-#### A masked pattern was here ####
PREHOOK: query: SELECT * from view1
PREHOOK: type: QUERY
PREHOOK: Input: default@src
@@ -225,15 +219,11 @@ PREHOOK: query: DESCRIBE view1
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE view1
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
value string None
PREHOOK: query: DESCRIBE EXTENDED view1
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE EXTENDED view1
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
value string None
#### A masked pattern was here ####
@@ -270,16 +260,12 @@ PREHOOK: query: DESCRIBE view2
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE view2
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
key string None
value string None
PREHOOK: query: DESCRIBE EXTENDED view2
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE EXTENDED view2
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
key string None
value string None
@@ -318,15 +304,11 @@ PREHOOK: query: DESCRIBE view3
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE view3
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
valoo string None
PREHOOK: query: DESCRIBE EXTENDED view3
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE EXTENDED view3
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
valoo string None
#### A masked pattern was here ####
@@ -372,8 +354,6 @@ PREHOOK: query: DESCRIBE EXTENDED view3
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE EXTENDED view3
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
valoo string None
#### A masked pattern was here ####
@@ -421,8 +401,6 @@ POSTHOOK: query: -- use DESCRIBE EXTENDE
-- of comparison for view descriptions
DESCRIBE EXTENDED table1
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
key int None
#### A masked pattern was here ####
@@ -430,8 +408,6 @@ PREHOOK: query: DESCRIBE EXTENDED src1
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE EXTENDED src1
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
key string default
value string default
@@ -444,8 +420,6 @@ POSTHOOK: query: -- use DESCRIBE EXTENDE
-- view descriptions
DESCRIBE EXTENDED table1
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
key int None
#### A masked pattern was here ####
@@ -470,11 +444,9 @@ POSTHOOK: Lineage: table1.key EXPRESSION
86
PREHOOK: query: CREATE VIEW view4 AS SELECT * FROM table1
PREHOOK: type: CREATEVIEW
-#### A masked pattern was here ####
POSTHOOK: query: CREATE VIEW view4 AS SELECT * FROM table1
POSTHOOK: type: CREATEVIEW
POSTHOOK: Output: default@view4
-#### A masked pattern was here ####
POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
PREHOOK: query: SELECT * FROM view4
PREHOOK: type: QUERY
@@ -493,8 +465,6 @@ PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE view4
POSTHOOK: type: DESCTABLE
POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
-# col_name data_type comment
-
key int None
PREHOOK: query: ALTER TABLE table1 ADD COLUMNS (value STRING)
PREHOOK: type: ALTERTABLE_ADDCOLS
@@ -532,8 +502,6 @@ PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE table1
POSTHOOK: type: DESCTABLE
POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
-# col_name data_type comment
-
key int None
value string None
PREHOOK: query: DESCRIBE view4
@@ -541,20 +509,16 @@ PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE view4
POSTHOOK: type: DESCTABLE
POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
-# col_name data_type comment
-
key int None
PREHOOK: query: CREATE VIEW view5 AS SELECT v1.key as key1, v2.key as key2
FROM view4 v1 join view4 v2
PREHOOK: type: CREATEVIEW
PREHOOK: Input: default@view4
-#### A masked pattern was here ####
POSTHOOK: query: CREATE VIEW view5 AS SELECT v1.key as key1, v2.key as key2
FROM view4 v1 join view4 v2
POSTHOOK: type: CREATEVIEW
POSTHOOK: Input: default@view4
POSTHOOK: Output: default@view5
-#### A masked pattern was here ####
POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
PREHOOK: query: SELECT * FROM view5
PREHOOK: type: QUERY
@@ -575,8 +539,6 @@ PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE view5
POSTHOOK: type: DESCTABLE
POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
-# col_name data_type comment
-
key1 int None
key2 int None
PREHOOK: query: -- verify that column name and comment in DDL portion
@@ -584,22 +546,18 @@ PREHOOK: query: -- verify that column na
CREATE VIEW view6(valoo COMMENT 'I cannot spell') AS
SELECT upper(value) as blarg FROM src WHERE key=86
PREHOOK: type: CREATEVIEW
-#### A masked pattern was here ####
POSTHOOK: query: -- verify that column name and comment in DDL portion
-- overrides column alias in SELECT
CREATE VIEW view6(valoo COMMENT 'I cannot spell') AS
SELECT upper(value) as blarg FROM src WHERE key=86
POSTHOOK: type: CREATEVIEW
POSTHOOK: Output: default@view6
-#### A masked pattern was here ####
POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
PREHOOK: query: DESCRIBE view6
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE view6
POSTHOOK: type: DESCTABLE
POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
-# col_name data_type comment
-
valoo string I cannot spell
PREHOOK: query: -- verify that ORDER BY and LIMIT are both supported in view def
CREATE VIEW view7 AS
@@ -608,7 +566,6 @@ WHERE key > 80 AND key < 100
ORDER BY key, value
LIMIT 10
PREHOOK: type: CREATEVIEW
-#### A masked pattern was here ####
POSTHOOK: query: -- verify that ORDER BY and LIMIT are both supported in view def
CREATE VIEW view7 AS
SELECT * FROM src
@@ -617,7 +574,6 @@ ORDER BY key, value
LIMIT 10
POSTHOOK: type: CREATEVIEW
POSTHOOK: Output: default@view7
-#### A masked pattern was here ####
POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
PREHOOK: query: SELECT * FROM view7
PREHOOK: type: QUERY
@@ -721,21 +677,17 @@ PREHOOK: query: CREATE VIEW view8(c) AS
SELECT test_translate('abc', 'a', 'b')
FROM table1
PREHOOK: type: CREATEVIEW
-#### A masked pattern was here ####
POSTHOOK: query: CREATE VIEW view8(c) AS
SELECT test_translate('abc', 'a', 'b')
FROM table1
POSTHOOK: type: CREATEVIEW
POSTHOOK: Output: default@view8
-#### A masked pattern was here ####
POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
PREHOOK: query: DESCRIBE EXTENDED view8
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE EXTENDED view8
POSTHOOK: type: DESCTABLE
POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
-# col_name data_type comment
-
c string None
#### A masked pattern was here ####
@@ -799,22 +751,18 @@ CREATE VIEW view9(m) AS
SELECT test_max(length(value))
FROM src
PREHOOK: type: CREATEVIEW
-#### A masked pattern was here ####
POSTHOOK: query: -- disable map-side aggregation
CREATE VIEW view9(m) AS
SELECT test_max(length(value))
FROM src
POSTHOOK: type: CREATEVIEW
POSTHOOK: Output: default@view9
-#### A masked pattern was here ####
POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
PREHOOK: query: DESCRIBE EXTENDED view9
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE EXTENDED view9
POSTHOOK: type: DESCTABLE
POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
-# col_name data_type comment
-
m int None
#### A masked pattern was here ####
@@ -878,22 +826,18 @@ CREATE VIEW view9(m) AS
SELECT test_max(length(value))
FROM src
PREHOOK: type: CREATEVIEW
-#### A masked pattern was here ####
POSTHOOK: query: -- enable map-side aggregation
CREATE VIEW view9(m) AS
SELECT test_max(length(value))
FROM src
POSTHOOK: type: CREATEVIEW
POSTHOOK: Output: default@view9
-#### A masked pattern was here ####
POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
PREHOOK: query: DESCRIBE EXTENDED view9
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE EXTENDED view9
POSTHOOK: type: DESCTABLE
POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
-# col_name data_type comment
-
m int None
#### A masked pattern was here ####
@@ -947,21 +891,17 @@ PREHOOK: query: -- test usage of a subse
CREATE VIEW view10 AS
SELECT slurp.* FROM (SELECT * FROM src WHERE key=86) slurp
PREHOOK: type: CREATEVIEW
-#### A masked pattern was here ####
POSTHOOK: query: -- test usage of a subselect within a view
CREATE VIEW view10 AS
SELECT slurp.* FROM (SELECT * FROM src WHERE key=86) slurp
POSTHOOK: type: CREATEVIEW
POSTHOOK: Output: default@view10
-#### A masked pattern was here ####
POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
PREHOOK: query: DESCRIBE EXTENDED view10
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE EXTENDED view10
POSTHOOK: type: DESCTABLE
POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
-# col_name data_type comment
-
key string None
value string None
@@ -1022,21 +962,17 @@ PREHOOK: query: CREATE VIEW view11 AS
SELECT test_explode(array(1,2,3)) AS (boom)
FROM table1
PREHOOK: type: CREATEVIEW
-#### A masked pattern was here ####
POSTHOOK: query: CREATE VIEW view11 AS
SELECT test_explode(array(1,2,3)) AS (boom)
FROM table1
POSTHOOK: type: CREATEVIEW
POSTHOOK: Output: default@view11
-#### A masked pattern was here ####
POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
PREHOOK: query: DESCRIBE EXTENDED view11
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE EXTENDED view11
POSTHOOK: type: DESCTABLE
POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
-# col_name data_type comment
-
boom int None
#### A masked pattern was here ####
@@ -1092,21 +1028,17 @@ PREHOOK: query: -- test usage of LATERAL
CREATE VIEW view12 AS
SELECT * FROM src LATERAL VIEW explode(array(1,2,3)) myTable AS myCol
PREHOOK: type: CREATEVIEW
-#### A masked pattern was here ####
POSTHOOK: query: -- test usage of LATERAL within a view
CREATE VIEW view12 AS
SELECT * FROM src LATERAL VIEW explode(array(1,2,3)) myTable AS myCol
POSTHOOK: type: CREATEVIEW
POSTHOOK: Output: default@view12
-#### A masked pattern was here ####
POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
PREHOOK: query: DESCRIBE EXTENDED view12
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE EXTENDED view12
POSTHOOK: type: DESCTABLE
POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
-# col_name data_type comment
-
key string None
value string None
mycol int None
@@ -1179,22 +1111,18 @@ CREATE VIEW view13 AS
SELECT s.key
FROM srcbucket TABLESAMPLE (BUCKET 1 OUT OF 5 ON key) s
PREHOOK: type: CREATEVIEW
-#### A masked pattern was here ####
POSTHOOK: query: -- test usage of TABLESAMPLE within a view
CREATE VIEW view13 AS
SELECT s.key
FROM srcbucket TABLESAMPLE (BUCKET 1 OUT OF 5 ON key) s
POSTHOOK: type: CREATEVIEW
POSTHOOK: Output: default@view13
-#### A masked pattern was here ####
POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
PREHOOK: query: DESCRIBE EXTENDED view13
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE EXTENDED view13
POSTHOOK: type: DESCTABLE
POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
-# col_name data_type comment
-
key int None
#### A masked pattern was here ####
@@ -1270,7 +1198,6 @@ JOIN
select s4.key as key, s4.value as value from src s4 where s4.key < 10) unionsrc2
ON (unionsrc1.key = unionsrc2.key)
PREHOOK: type: CREATEVIEW
-#### A masked pattern was here ####
POSTHOOK: query: -- test usage of JOIN+UNION+AGG all within same view
CREATE VIEW view14 AS
SELECT unionsrc1.key as k1, unionsrc1.value as v1,
@@ -1285,15 +1212,12 @@ JOIN
ON (unionsrc1.key = unionsrc2.key)
POSTHOOK: type: CREATEVIEW
POSTHOOK: Output: default@view14
-#### A masked pattern was here ####
POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
PREHOOK: query: DESCRIBE EXTENDED view14
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE EXTENDED view14
POSTHOOK: type: DESCTABLE
POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
-# col_name data_type comment
-
k1 string None
v1 string None
k2 string None
@@ -1411,7 +1335,6 @@ SELECT key,COUNT(value) AS value_count
FROM src
GROUP BY key
PREHOOK: type: CREATEVIEW
-#### A masked pattern was here ####
POSTHOOK: query: -- test usage of GROUP BY within view
CREATE VIEW view15 AS
SELECT key,COUNT(value) AS value_count
@@ -1419,15 +1342,12 @@ FROM src
GROUP BY key
POSTHOOK: type: CREATEVIEW
POSTHOOK: Output: default@view15
-#### A masked pattern was here ####
POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
PREHOOK: query: DESCRIBE EXTENDED view15
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE EXTENDED view15
POSTHOOK: type: DESCTABLE
POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
-# col_name data_type comment
-
key string None
value_count bigint None
@@ -1501,22 +1421,18 @@ CREATE VIEW view16 AS
SELECT DISTINCT value
FROM src
PREHOOK: type: CREATEVIEW
-#### A masked pattern was here ####
POSTHOOK: query: -- test usage of DISTINCT within view
CREATE VIEW view16 AS
SELECT DISTINCT value
FROM src
POSTHOOK: type: CREATEVIEW
POSTHOOK: Output: default@view16
-#### A masked pattern was here ####
POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
PREHOOK: query: DESCRIBE EXTENDED view16
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE EXTENDED view16
POSTHOOK: type: DESCTABLE
POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
-# col_name data_type comment
-
value string None
#### A masked pattern was here ####
@@ -1595,8 +1511,6 @@ PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE view16
POSTHOOK: type: DESCTABLE
POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
-# col_name data_type comment
-
value string None
PREHOOK: query: -- Likewise, DROP VIEW IF EXISTS should ignore a matching table name
DROP VIEW IF EXISTS table1
@@ -1614,8 +1528,6 @@ PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE table1
POSTHOOK: type: DESCTABLE
POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
-# col_name data_type comment
-
key int None
value string None
PREHOOK: query: -- this should work since currently we don't track view->table
Modified: hive/branches/HIVE-4115/ql/src/test/results/clientpositive/create_view_partitioned.q.out
URL: http://svn.apache.org/viewvc/hive/branches/HIVE-4115/ql/src/test/results/clientpositive/create_view_partitioned.q.out?rev=1468783&r1=1468782&r2=1468783&view=diff
==============================================================================
--- hive/branches/HIVE-4115/ql/src/test/results/clientpositive/create_view_partitioned.q.out (original)
+++ hive/branches/HIVE-4115/ql/src/test/results/clientpositive/create_view_partitioned.q.out Wed Apr 17 07:29:38 2013
@@ -19,7 +19,6 @@ SELECT key, value
FROM src
WHERE key=86
PREHOOK: type: CREATEVIEW
-#### A masked pattern was here ####
POSTHOOK: query: -- test partitioned view definition
-- (underlying table is not actually partitioned)
CREATE VIEW vp1
@@ -30,13 +29,10 @@ FROM src
WHERE key=86
POSTHOOK: type: CREATEVIEW
POSTHOOK: Output: default@vp1
-#### A masked pattern was here ####
PREHOOK: query: DESCRIBE EXTENDED vp1
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE EXTENDED vp1
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
key string None
value string None
@@ -234,7 +230,6 @@ CREATE VIEW vp2
PARTITIONED ON (hr)
AS SELECT * FROM srcpart WHERE key < 10
PREHOOK: type: CREATEVIEW
-#### A masked pattern was here ####
POSTHOOK: query: -- test a partitioned view on top of an underlying partitioned table,
-- but with only a suffix of the partitioning columns
CREATE VIEW vp2
@@ -242,7 +237,6 @@ PARTITIONED ON (hr)
AS SELECT * FROM srcpart WHERE key < 10
POSTHOOK: type: CREATEVIEW
POSTHOOK: Output: default@vp2
-#### A masked pattern was here ####
PREHOOK: query: DESCRIBE FORMATTED vp2
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE FORMATTED vp2
@@ -340,7 +334,6 @@ SELECT key, value
FROM src
WHERE key=86
PREHOOK: type: CREATEVIEW
-#### A masked pattern was here ####
POSTHOOK: query: -- test a partitioned view where the PARTITIONED ON clause references
-- an imposed column name
CREATE VIEW vp3(k,v)
@@ -351,7 +344,6 @@ FROM src
WHERE key=86
POSTHOOK: type: CREATEVIEW
POSTHOOK: Output: default@vp3
-#### A masked pattern was here ####
PREHOOK: query: DESCRIBE FORMATTED vp3
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE FORMATTED vp3
Modified: hive/branches/HIVE-4115/ql/src/test/results/clientpositive/ctas.q.out
URL: http://svn.apache.org/viewvc/hive/branches/HIVE-4115/ql/src/test/results/clientpositive/ctas.q.out?rev=1468783&r1=1468782&r2=1468783&view=diff
==============================================================================
--- hive/branches/HIVE-4115/ql/src/test/results/clientpositive/ctas.q.out (original)
+++ hive/branches/HIVE-4115/ql/src/test/results/clientpositive/ctas.q.out Wed Apr 17 07:29:38 2013
@@ -1,8 +1,8 @@
-PREHOOK: query: -- EXCLUDE_HADOOP_MAJOR_VERSIONS(0.20)
+PREHOOK: query: -- EXCLUDE_HADOOP_MAJOR_VERSIONS(0.20, 0.20S)
create table nzhang_Tmp(a int, b string)
PREHOOK: type: CREATETABLE
-POSTHOOK: query: -- EXCLUDE_HADOOP_MAJOR_VERSIONS(0.20)
+POSTHOOK: query: -- EXCLUDE_HADOOP_MAJOR_VERSIONS(0.20, 0.20S)
create table nzhang_Tmp(a int, b string)
POSTHOOK: type: CREATETABLE
@@ -827,8 +827,6 @@ STAGE PLANS:
TotalFiles: 1
GatherStats: false
MultiFileSpray: false
- Path -> Sorted Columns:
-#### A masked pattern was here ####
Truncated Path -> Alias:
/src [src]
@@ -893,8 +891,6 @@ STAGE PLANS:
TotalFiles: 1
GatherStats: true
MultiFileSpray: false
- Path -> Sorted Columns:
-#### A masked pattern was here ####
Truncated Path -> Alias:
#### A masked pattern was here ####
Modified: hive/branches/HIVE-4115/ql/src/test/results/clientpositive/database.q.out
URL: http://svn.apache.org/viewvc/hive/branches/HIVE-4115/ql/src/test/results/clientpositive/database.q.out?rev=1468783&r1=1468782&r2=1468783&view=diff
==============================================================================
--- hive/branches/HIVE-4115/ql/src/test/results/clientpositive/database.q.out (original)
+++ hive/branches/HIVE-4115/ql/src/test/results/clientpositive/database.q.out Wed Apr 17 07:29:38 2013
@@ -129,8 +129,6 @@ PREHOOK: type: DESCTABLE
POSTHOOK: query: -- DESCRIBE table in non-default DB
DESCRIBE test_table
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
col1 string None
PREHOOK: query: -- DESCRIBE EXTENDED in non-default DB
DESCRIBE EXTENDED test_table
@@ -138,8 +136,6 @@ PREHOOK: type: DESCTABLE
POSTHOOK: query: -- DESCRIBE EXTENDED in non-default DB
DESCRIBE EXTENDED test_table
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
col1 string None
#### A masked pattern was here ####
@@ -160,8 +156,6 @@ PREHOOK: query: DESCRIBE EXTENDED test_t
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE EXTENDED test_table_like
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
col1 string None
#### A masked pattern was here ####
@@ -1344,8 +1338,6 @@ POSTHOOK: type: DESCTABLE
POSTHOOK: Lineage: bucketized_src.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: bucketized_src.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: temp_tbl2.c EXPRESSION [(temp_tbl)temp_tbl.null, ]
-# col_name data_type comment
-
key string default
value string default
Modified: hive/branches/HIVE-4115/ql/src/test/results/clientpositive/database_drop.q.out
URL: http://svn.apache.org/viewvc/hive/branches/HIVE-4115/ql/src/test/results/clientpositive/database_drop.q.out?rev=1468783&r1=1468782&r2=1468783&view=diff
==============================================================================
--- hive/branches/HIVE-4115/ql/src/test/results/clientpositive/database_drop.q.out (original)
+++ hive/branches/HIVE-4115/ql/src/test/results/clientpositive/database_drop.q.out Wed Apr 17 07:29:38 2013
@@ -40,11 +40,9 @@ POSTHOOK: type: LOAD
POSTHOOK: Output: db5@temp_tbl
PREHOOK: query: CREATE VIEW temp_tbl_view AS SELECT * FROM temp_tbl
PREHOOK: type: CREATEVIEW
-#### A masked pattern was here ####
POSTHOOK: query: CREATE VIEW temp_tbl_view AS SELECT * FROM temp_tbl
POSTHOOK: type: CREATEVIEW
POSTHOOK: Output: db5@temp_tbl_view
-#### A masked pattern was here ####
PREHOOK: query: CREATE INDEX idx1 ON TABLE temp_tbl(id) AS 'COMPACT' with DEFERRED REBUILD
PREHOOK: type: CREATEINDEX
POSTHOOK: query: CREATE INDEX idx1 ON TABLE temp_tbl(id) AS 'COMPACT' with DEFERRED REBUILD
@@ -82,11 +80,9 @@ POSTHOOK: Lineage: db5__temp_tbl_idx1__.
POSTHOOK: Lineage: db5__temp_tbl_idx1__.id SIMPLE [(temp_tbl)temp_tbl.FieldSchema(name:id, type:int, comment:null), ]
PREHOOK: query: CREATE VIEW temp_tbl2_view AS SELECT * FROM temp_tbl2
PREHOOK: type: CREATEVIEW
-#### A masked pattern was here ####
POSTHOOK: query: CREATE VIEW temp_tbl2_view AS SELECT * FROM temp_tbl2
POSTHOOK: type: CREATEVIEW
POSTHOOK: Output: db5@temp_tbl2_view
-#### A masked pattern was here ####
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), ]
Modified: hive/branches/HIVE-4115/ql/src/test/results/clientpositive/ddltime.q.out
URL: http://svn.apache.org/viewvc/hive/branches/HIVE-4115/ql/src/test/results/clientpositive/ddltime.q.out?rev=1468783&r1=1468782&r2=1468783&view=diff
==============================================================================
--- hive/branches/HIVE-4115/ql/src/test/results/clientpositive/ddltime.q.out (original)
+++ hive/branches/HIVE-4115/ql/src/test/results/clientpositive/ddltime.q.out Wed Apr 17 07:29:38 2013
@@ -7,8 +7,6 @@ PREHOOK: query: desc extended T1
PREHOOK: type: DESCTABLE
POSTHOOK: query: desc extended T1
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
key string default
value string default
@@ -29,8 +27,6 @@ POSTHOOK: query: desc extended T1
POSTHOOK: type: DESCTABLE
POSTHOOK: Lineage: t1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: t1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-# col_name data_type comment
-
key string default
value string default
@@ -55,8 +51,6 @@ POSTHOOK: Lineage: t1.key SIMPLE [(src)s
POSTHOOK: Lineage: t1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: t1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: t1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-# col_name data_type comment
-
key string default
value string default
@@ -85,8 +79,6 @@ POSTHOOK: Lineage: t1.key SIMPLE [(src)s
POSTHOOK: Lineage: t1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: t1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: t1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-# col_name data_type comment
-
key string default
value string default
@@ -112,8 +104,6 @@ POSTHOOK: Lineage: t1.key SIMPLE [(src)s
POSTHOOK: Lineage: t1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: t1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: t1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-# col_name data_type comment
-
key string default
value string default
ds string None
@@ -154,8 +144,6 @@ POSTHOOK: Lineage: t1.value SIMPLE [(src
POSTHOOK: Lineage: t1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: t2 PARTITION(ds=2010-06-21,hr=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: t2 PARTITION(ds=2010-06-21,hr=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-# col_name data_type comment
-
key string default
value string default
ds string None
@@ -200,8 +188,6 @@ POSTHOOK: Lineage: t2 PARTITION(ds=2010-
POSTHOOK: Lineage: t2 PARTITION(ds=2010-06-21,hr=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: t2 PARTITION(ds=2010-06-21,hr=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: t2 PARTITION(ds=2010-06-21,hr=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-# col_name data_type comment
-
key string default
value string default
ds string None
@@ -250,8 +236,6 @@ POSTHOOK: Lineage: t2 PARTITION(ds=2010-
POSTHOOK: Lineage: t2 PARTITION(ds=2010-06-21,hr=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: t2 PARTITION(ds=2010-06-21,hr=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: t2 PARTITION(ds=2010-06-21,hr=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-# col_name data_type comment
-
key string default
value string default
ds string None
Modified: hive/branches/HIVE-4115/ql/src/test/results/clientpositive/decimal_3.q.out
URL: http://svn.apache.org/viewvc/hive/branches/HIVE-4115/ql/src/test/results/clientpositive/decimal_3.q.out?rev=1468783&r1=1468782&r2=1468783&view=diff
==============================================================================
--- hive/branches/HIVE-4115/ql/src/test/results/clientpositive/decimal_3.q.out (original)
+++ hive/branches/HIVE-4115/ql/src/test/results/clientpositive/decimal_3.q.out Wed Apr 17 07:29:38 2013
@@ -27,8 +27,10 @@ POSTHOOK: query: SELECT * FROM DECIMAL_3
POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_3
#### A masked pattern was here ####
+NULL 0
+NULL 0
-1234567890.123456789 -1234567890
--4.4E+3 4400
+-4400 4400
-1255.49 -1255
-1.122 -11
-1.12 -1
@@ -38,7 +40,6 @@ POSTHOOK: Input: default@decimal_3
-0.3 0
0 0
0 0
-1E-99 0
0.01 0
0.02 0
0.1 0
@@ -57,14 +58,13 @@ POSTHOOK: Input: default@decimal_3
3.14 3
3.14 3
3.14 4
-1E+1 10
-2E+1 20
-1E+2 100
+10 10
+20 20
+100 100
124 124
125.2 125
-2E+2 200
+200 200
1234567890.12345678 1234567890
-1E+99 0
PREHOOK: query: SELECT * FROM DECIMAL_3 ORDER BY key DESC, value DESC
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_3
@@ -73,14 +73,13 @@ POSTHOOK: query: SELECT * FROM DECIMAL_3
POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_3
#### A masked pattern was here ####
-1E+99 0
1234567890.12345678 1234567890
-2E+2 200
+200 200
125.2 125
124 124
-1E+2 100
-2E+1 20
-1E+1 10
+100 100
+20 20
+10 10
3.14 4
3.14 3
3.14 3
@@ -99,7 +98,6 @@ POSTHOOK: Input: default@decimal_3
0.1 0
0.02 0
0.01 0
-1E-99 0
0 0
0 0
-0.3 0
@@ -109,8 +107,10 @@ POSTHOOK: Input: default@decimal_3
-1.12 -1
-1.122 -11
-1255.49 -1255
--4.4E+3 4400
+-4400 4400
-1234567890.123456789 -1234567890
+NULL 0
+NULL 0
PREHOOK: query: SELECT * FROM DECIMAL_3 ORDER BY key, value
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_3
@@ -119,8 +119,10 @@ POSTHOOK: query: SELECT * FROM DECIMAL_3
POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_3
#### A masked pattern was here ####
+NULL 0
+NULL 0
-1234567890.123456789 -1234567890
--4.4E+3 4400
+-4400 4400
-1255.49 -1255
-1.122 -11
-1.12 -1
@@ -130,7 +132,6 @@ POSTHOOK: Input: default@decimal_3
-0.3 0
0 0
0 0
-1E-99 0
0.01 0
0.02 0
0.1 0
@@ -149,14 +150,13 @@ POSTHOOK: Input: default@decimal_3
3.14 3
3.14 3
3.14 4
-1E+1 10
-2E+1 20
-1E+2 100
+10 10
+20 20
+100 100
124 124
125.2 125
-2E+2 200
+200 200
1234567890.12345678 1234567890
-1E+99 0
PREHOOK: query: SELECT DISTINCT key FROM DECIMAL_3 ORDER BY key
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_3
@@ -165,8 +165,9 @@ POSTHOOK: query: SELECT DISTINCT key FRO
POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_3
#### A masked pattern was here ####
+NULL
-1234567890.123456789
--4.4E+3
+-4400
-1255.49
-1.122
-1.12
@@ -174,7 +175,6 @@ POSTHOOK: Input: default@decimal_3
-0.33
-0.3
0
-1E-99
0.01
0.02
0.1
@@ -188,14 +188,13 @@ POSTHOOK: Input: default@decimal_3
1.122
2
3.14
-1E+1
-2E+1
-1E+2
+10
+20
+100
124
125.2
-2E+2
+200
1234567890.12345678
-1E+99
PREHOOK: query: SELECT key, sum(value) FROM DECIMAL_3 GROUP BY key ORDER BY key
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_3
@@ -204,8 +203,9 @@ POSTHOOK: query: SELECT key, sum(value)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_3
#### A masked pattern was here ####
+NULL 0
-1234567890.123456789 -1234567890
--4.4E+3 4400
+-4400 4400
-1255.49 -1255
-1.122 -11
-1.12 -2
@@ -213,7 +213,6 @@ POSTHOOK: Input: default@decimal_3
-0.33 0
-0.3 0
0 0
-1E-99 0
0.01 0
0.02 0
0.1 0
@@ -227,14 +226,13 @@ POSTHOOK: Input: default@decimal_3
1.122 1
2 4
3.14 13
-1E+1 10
-2E+1 20
-1E+2 100
+10 10
+20 20
+100 100
124 124
125.2 125
-2E+2 200
+200 200
1234567890.12345678 1234567890
-1E+99 0
PREHOOK: query: SELECT value, sum(key) FROM DECIMAL_3 GROUP BY value ORDER BY value
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_3
@@ -247,18 +245,18 @@ POSTHOOK: Input: default@decimal_3
-1255 -1255.49
-11 -1.122
-1 -2.24
-0 1000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.330000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001
+0 0.33
1 5.2419999999999999999999999
2 4
3 9.42
4 3.14
-10 1E+1
-20 2E+1
-100 1E+2
+10 10
+20 20
+100 100
124 124
125 125.2
-200 2E+2
-4400 -4.4E+3
+200 200
+4400 -4400
1234567890 1234567890.12345678
PREHOOK: query: SELECT * FROM DECIMAL_3 a JOIN DECIMAL_3 b ON (a.key = b.key) ORDER BY a.key, a.value, b.value
PREHOOK: type: QUERY
@@ -269,7 +267,7 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_3
#### A masked pattern was here ####
-1234567890.123456789 -1234567890 -1234567890.123456789 -1234567890
--4.4E+3 4400 -4.4E+3 4400
+-4400 4400 -4400 4400
-1255.49 -1255 -1255.49 -1255
-1.122 -11 -1.122 -11
-1.12 -1 -1.12 -1
@@ -283,7 +281,6 @@ POSTHOOK: Input: default@decimal_3
0 0 0 0
0 0 0 0
0 0 0 0
-1E-99 0 1E-99 0
0.01 0 0.01 0
0.02 0 0.02 0
0.1 0 0.1 0
@@ -318,14 +315,13 @@ POSTHOOK: Input: default@decimal_3
3.14 4 3.14 3
3.14 4 3.14 3
3.14 4 3.14 4
-1E+1 10 1E+1 10
-2E+1 20 2E+1 20
-1E+2 100 1E+2 100
+10 10 10 10
+20 20 20 20
+100 100 100 100
124 124 124 124
125.2 125 125.2 125
-2E+2 200 2E+2 200
+200 200 200 200
1234567890.12345678 1234567890 1234567890.12345678 1234567890
-1E+99 0 1E+99 0
PREHOOK: query: SELECT * FROM DECIMAL_3 WHERE key=3.14 ORDER BY key, value
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_3
Modified: hive/branches/HIVE-4115/ql/src/test/results/clientpositive/decimal_serde.q.out
URL: http://svn.apache.org/viewvc/hive/branches/HIVE-4115/ql/src/test/results/clientpositive/decimal_serde.q.out?rev=1468783&r1=1468782&r2=1468783&view=diff
==============================================================================
--- hive/branches/HIVE-4115/ql/src/test/results/clientpositive/decimal_serde.q.out (original)
+++ hive/branches/HIVE-4115/ql/src/test/results/clientpositive/decimal_serde.q.out Wed Apr 17 07:29:38 2013
@@ -39,8 +39,10 @@ POSTHOOK: query: SELECT * FROM DECIMAL_T
POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_text
#### A masked pattern was here ####
+NULL 0
+NULL 0
-1234567890.123456789 -1234567890
--4.4E+3 4400
+-4400 4400
-1255.49 -1255
-1.122 -11
-1.12 -1
@@ -50,7 +52,6 @@ POSTHOOK: Input: default@decimal_text
-0.3 0
0 0
0 0
-1E-99 0
0.01 0
0.02 0
0.1 0
@@ -69,14 +70,13 @@ POSTHOOK: Input: default@decimal_text
3.14 3
3.14 3
3.14 4
-1E+1 10
-2E+1 20
-1E+2 100
+10 10
+20 20
+100 100
124 124
125.2 125
-2E+2 200
+200 200
1234567890.12345678 1234567890
-1E+99 0
PREHOOK: query: CREATE TABLE DECIMAL_RC
STORED AS RCFile AS
SELECT * FROM DECIMAL_TEXT
@@ -128,8 +128,10 @@ POSTHOOK: query: SELECT * FROM DECIMAL_S
POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_sequence
#### A masked pattern was here ####
+NULL 0
+NULL 0
-1234567890.123456789 -1234567890
--4.4E+3 4400
+-4400 4400
-1255.49 -1255
-1.122 -11
-1.12 -1
@@ -139,7 +141,6 @@ POSTHOOK: Input: default@decimal_sequenc
-0.3 0
0 0
0 0
-1E-99 0
0.01 0
0.02 0
0.1 0
@@ -158,14 +159,13 @@ POSTHOOK: Input: default@decimal_sequenc
3.14 3
3.14 3
3.14 4
-1E+1 10
-2E+1 20
-1E+2 100
+10 10
+20 20
+100 100
124 124
125.2 125
-2E+2 200
+200 200
1234567890.12345678 1234567890
-1E+99 0
PREHOOK: query: DROP TABLE IF EXISTS DECIMAL_TEXT
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@decimal_text
Modified: hive/branches/HIVE-4115/ql/src/test/results/clientpositive/decimal_udf.q.out
URL: http://svn.apache.org/viewvc/hive/branches/HIVE-4115/ql/src/test/results/clientpositive/decimal_udf.q.out?rev=1468783&r1=1468782&r2=1468783&view=diff
==============================================================================
--- hive/branches/HIVE-4115/ql/src/test/results/clientpositive/decimal_udf.q.out (original)
+++ hive/branches/HIVE-4115/ql/src/test/results/clientpositive/decimal_udf.q.out Wed Apr 17 07:29:38 2013
@@ -64,17 +64,17 @@ POSTHOOK: query: SELECT key + key FROM D
POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_udf
#### A masked pattern was here ####
--8.8E+3
-2E+99
-2E-99
+-8800
+NULL
+NULL
0
-2E+2
-2E+1
+200
+20
2
0.2
0.02
-4E+2
-4E+1
+400
+40
4
0
0.4
@@ -146,16 +146,16 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_udf
#### A masked pattern was here ####
0
-1E+99
-1E-99
+NULL
+NULL
0
-2E+2
-2E+1
+200
+20
2
0.1
0.01
-4E+2
-4E+1
+400
+40
4
0
0.2
@@ -226,17 +226,17 @@ POSTHOOK: query: SELECT key + (value/2)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_udf
#### A masked pattern was here ####
--2.2E+3
-1E+99
-1E-99
+-2200
+NULL
+NULL
0
-1.5E+2
+150
15
1.5
0.1
0.01
-3E+2
-3E+1
+300
+30
3
0
0.2
@@ -308,8 +308,8 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_udf
#### A masked pattern was here ####
-4399
-1000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001
-1.000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001
+NULL
+NULL
1
101
11
@@ -391,8 +391,8 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_udf
#### A masked pattern was here ####
0
-0
-0
+NULL
+NULL
0
0
0
@@ -471,9 +471,9 @@ POSTHOOK: query: SELECT key - value FROM
POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_udf
#### A masked pattern was here ####
--8.8E+3
-1E+99
-1E-99
+-8800
+NULL
+NULL
0
0
0
@@ -506,7 +506,7 @@ POSTHOOK: Input: default@decimal_udf
0.14
0.14
-0.86
--1E-25
+-0.0000000000000000000000001
-0.123456789
0.12345678
PREHOOK: query: EXPLAIN SELECT key - (value/2) FROM DECIMAL_UDF
@@ -552,17 +552,17 @@ POSTHOOK: query: SELECT key - (value/2)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_udf
#### A masked pattern was here ####
--6.6E+3
-1E+99
-1E-99
+-6600
+NULL
+NULL
0
-5E+1
+50
5
0.5
0.1
0.01
-1E+2
-1E+1
+100
+10
1
0
0.2
@@ -634,8 +634,8 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_udf
#### A masked pattern was here ####
-4401
-999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999
--0.999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999
+NULL
+NULL
-1
99
9
@@ -668,7 +668,7 @@ POSTHOOK: Input: default@decimal_udf
2.14
2.14
2.14
--1E-25
+-0.0000000000000000000000001
-1234567891.123456789
1234567889.12345678
PREHOOK: query: -- multiplication
@@ -716,17 +716,17 @@ POSTHOOK: query: SELECT key * key FROM D
POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_udf
#### A masked pattern was here ####
-1.936E+7
-1E+198
-1E-198
+19360000
+NULL
+NULL
0
-1E+4
-1E+2
+10000
+100
1
0.01
0.0001
-4E+4
-4E+2
+40000
+400
4
0
0.04
@@ -751,7 +751,7 @@ POSTHOOK: Input: default@decimal_udf
9.8596
9.8596
9.8596
-0.99999999999999999999999980000000000000000000000001
+NULL
1524157875323883675.019051998750190521
1524157875323883652.7968299765279684
PREHOOK: query: EXPLAIN SELECT key * value FROM DECIMAL_UDF
@@ -797,17 +797,17 @@ POSTHOOK: query: SELECT key * value FROM
POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_udf
#### A masked pattern was here ####
--1.936E+7
-0
-0
+-19360000
+NULL
+NULL
0
-1E+4
-1E+2
+10000
+100
1
0
0
-4E+4
-4E+2
+40000
+400
4
0
0
@@ -827,7 +827,7 @@ POSTHOOK: Input: default@decimal_udf
1.12
1.122
15376
-1.565E+4
+15650
1575639.95
9.42
9.42
@@ -878,17 +878,17 @@ POSTHOOK: query: SELECT key * (value/2)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_udf
#### A masked pattern was here ####
--9.68E+6
-0
-0
+-9680000
+NULL
+NULL
0
-5E+3
-5E+1
+5000
+50
0.5
0
0
-2E+4
-2E+2
+20000
+200
2
0
0
@@ -959,17 +959,17 @@ POSTHOOK: query: SELECT key * '2.0' FROM
POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_udf
#### A masked pattern was here ####
--8.8E+3
-2E+99
-2E-99
+-8800
+NULL
+NULL
0
-2E+2
-2E+1
+200
+20
2
0.2
0.02
-4E+2
-4E+1
+400
+40
4
0
0.4
@@ -1170,8 +1170,6 @@ POSTHOOK: Input: default@decimal_udf
1
1
1
-1
-1
PREHOOK: query: EXPLAIN SELECT key / value FROM DECIMAL_UDF WHERE value is not null and value <> 0
PREHOOK: type: QUERY
POSTHOOK: query: EXPLAIN SELECT key / value FROM DECIMAL_UDF WHERE value is not null and value <> 0
@@ -1228,7 +1226,7 @@ POSTHOOK: Input: default@decimal_udf
1
1
1
-1.04666666666666666666666666666666666666666666666666666666666666667
+1.0466666666666666666666666666666666667
1.12
1.12
0.102
@@ -1236,13 +1234,13 @@ POSTHOOK: Input: default@decimal_udf
1.122
1
1.0016
-1.00039043824701195219123505976095617529880478087649402390438247012
-1.04666666666666666666666666666666666666666666666666666666666666667
-1.04666666666666666666666666666666666666666666666666666666666666667
+1.0003904382470119521912350597609561753
+1.0466666666666666666666666666666666667
+1.0466666666666666666666666666666666667
0.785
0.9999999999999999999999999
1.0000000001
-1.00000000009999999270999993366099939631509450646736000885297608056
+1.0000000000999999927099999336609993963
PREHOOK: query: EXPLAIN SELECT key / (value/2) FROM DECIMAL_UDF WHERE value is not null and value <> 0
PREHOOK: type: QUERY
POSTHOOK: query: EXPLAIN SELECT key / (value/2) FROM DECIMAL_UDF WHERE value is not null and value <> 0
@@ -1299,7 +1297,7 @@ POSTHOOK: Input: default@decimal_udf
2
2
2
-2.09333333333333333333333333333333333333333333333333333333333333333
+2.0933333333333333333333333333333333333
2.24
2.24
0.204
@@ -1307,13 +1305,13 @@ POSTHOOK: Input: default@decimal_udf
2.244
2
2.0032
-2.00078087649402390438247011952191235059760956175298804780876494024
-2.09333333333333333333333333333333333333333333333333333333333333333
-2.09333333333333333333333333333333333333333333333333333333333333333
+2.0007808764940239043824701195219123506
+2.0933333333333333333333333333333333333
+2.0933333333333333333333333333333333333
1.57
1.9999999999999999999999998
2.0000000002
-2.00000000019999998541999986732199879263018901293472001770595216112
+2.0000000001999999854199998673219987926
PREHOOK: query: EXPLAIN SELECT key / '2.0' FROM DECIMAL_UDF
PREHOOK: type: QUERY
POSTHOOK: query: EXPLAIN SELECT key / '2.0' FROM DECIMAL_UDF
@@ -1357,17 +1355,17 @@ POSTHOOK: query: SELECT key / '2.0' FROM
POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_udf
#### A masked pattern was here ####
--2.2E+3
-5E+98
-0
+-2200
+NULL
+NULL
0
-5E+1
+50
5
0.5
0.05
0.005
-1E+2
-1E+1
+100
+10
1
0
0.1
@@ -1440,17 +1438,17 @@ POSTHOOK: query: SELECT abs(key) FROM DE
POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_udf
#### A masked pattern was here ####
-4.4E+3
-1E+99
-1E-99
+4400
+NULL
+NULL
0
-1E+2
-1E+1
+100
+10
1
0.1
0.01
-2E+2
-2E+1
+200
+20
2
0
0.2
@@ -1478,6 +1476,145 @@ POSTHOOK: Input: default@decimal_udf
0.9999999999999999999999999
1234567890.123456789
1234567890.12345678
+PREHOOK: query: -- avg
+EXPLAIN SELECT value, sum(key) / count(key), avg(key) FROM DECIMAL_UDF GROUP BY value ORDER BY value
+PREHOOK: type: QUERY
+POSTHOOK: query: -- avg
+EXPLAIN SELECT value, sum(key) / count(key), avg(key) FROM DECIMAL_UDF GROUP BY value ORDER BY value
+POSTHOOK: type: QUERY
+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 value)) (TOK_SELEXPR (/ (TOK_FUNCTION sum (TOK_TABLE_OR_COL key)) (TOK_FUNCTION count (TOK_TABLE_OR_COL key)))) (TOK_SELEXPR (TOK_FUNCTION avg (TOK_TABLE_OR_COL key)))) (TOK_GROUPBY (TOK_TABLE_OR_COL value)) (TOK_ORDERBY (TOK_TABSORTCOLNAMEASC (TOK_TABLE_OR_COL value)))))
+
+STAGE DEPENDENCIES:
+ Stage-1 is a root stage
+ Stage-2 depends on stages: Stage-1
+ 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: value
+ type: int
+ expr: key
+ type: decimal
+ outputColumnNames: value, key
+ Group By Operator
+ aggregations:
+ expr: sum(key)
+ expr: count(key)
+ expr: avg(key)
+ bucketGroup: false
+ keys:
+ expr: value
+ type: int
+ mode: hash
+ outputColumnNames: _col0, _col1, _col2, _col3
+ Reduce Output Operator
+ key expressions:
+ expr: _col0
+ type: int
+ sort order: +
+ Map-reduce partition columns:
+ expr: _col0
+ type: int
+ tag: -1
+ value expressions:
+ expr: _col1
+ type: decimal
+ expr: _col2
+ type: bigint
+ expr: _col3
+ type: struct<count:bigint,sum:decimal>
+ Reduce Operator Tree:
+ Group By Operator
+ aggregations:
+ expr: sum(VALUE._col0)
+ expr: count(VALUE._col1)
+ expr: avg(VALUE._col2)
+ bucketGroup: false
+ keys:
+ expr: KEY._col0
+ type: int
+ mode: mergepartial
+ outputColumnNames: _col0, _col1, _col2, _col3
+ Select Operator
+ expressions:
+ expr: _col0
+ type: int
+ expr: (_col1 / _col2)
+ type: decimal
+ expr: _col3
+ type: decimal
+ outputColumnNames: _col0, _col1, _col2
+ File Output Operator
+ compressed: false
+ GlobalTableId: 0
+ table:
+ input format: org.apache.hadoop.mapred.SequenceFileInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
+
+ Stage: Stage-2
+ Map Reduce
+ Alias -> Map Operator Tree:
+#### A masked pattern was here ####
+ Reduce Output Operator
+ key expressions:
+ expr: _col0
+ type: int
+ sort order: +
+ tag: -1
+ value expressions:
+ expr: _col0
+ type: int
+ expr: _col1
+ type: decimal
+ expr: _col2
+ type: decimal
+ Reduce Operator Tree:
+ Extract
+ File Output Operator
+ compressed: false
+ GlobalTableId: 0
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+
+ Stage: Stage-0
+ Fetch Operator
+ limit: -1
+
+
+PREHOOK: query: SELECT value, sum(key) / count(key), avg(key) FROM DECIMAL_UDF GROUP BY value ORDER BY value
+PREHOOK: type: QUERY
+PREHOOK: Input: default@decimal_udf
+#### A masked pattern was here ####
+POSTHOOK: query: SELECT value, sum(key) / count(key), avg(key) FROM DECIMAL_UDF GROUP BY value ORDER BY value
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@decimal_udf
+#### A masked pattern was here ####
+-1234567890 -1234567890.123456789 -1234567890.123456789
+-1255 -1255.49 -1255.49
+-11 -1.122 -1.122
+-1 -1.12 -1.12
+0 0.0275 0.0275
+1 1.04839999999999999999999998 1.04839999999999999999999998
+2 2 2
+3 3.14 3.14
+4 3.14 3.14
+10 10 10
+20 20 20
+100 100 100
+124 124 124
+125 125.2 125.2
+200 200 200
+4400 -4400 -4400
+1234567890 1234567890.12345678 1234567890.12345678
PREHOOK: query: -- negative
EXPLAIN SELECT -key FROM DECIMAL_UDF
PREHOOK: type: QUERY
@@ -1523,17 +1660,17 @@ POSTHOOK: query: SELECT -key FROM DECIMA
POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_udf
#### A masked pattern was here ####
-4.4E+3
--1E+99
--1E-99
+4400
+NULL
+NULL
0
--1E+2
--1E+1
+-100
+-10
-1
-0.1
-0.01
--2E+2
--2E+1
+-200
+-20
-2
0
-0.2
@@ -1606,17 +1743,17 @@ POSTHOOK: query: SELECT +key FROM DECIMA
POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_udf
#### A masked pattern was here ####
--4.4E+3
-1E+99
-1E-99
+-4400
+NULL
+NULL
0
-1E+2
-1E+1
+100
+10
1
0.1
0.01
-2E+2
-2E+1
+200
+20
2
0
0.2
@@ -1689,17 +1826,17 @@ POSTHOOK: query: SELECT CEIL(key) FROM D
POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_udf
#### A masked pattern was here ####
--4.4E+3
-1E+99
-1
+-4400
+NULL
+NULL
0
-1E+2
-1E+1
+100
+10
1
1
1
-2E+2
-2E+1
+200
+20
2
0
1
@@ -1725,7 +1862,7 @@ POSTHOOK: Input: default@decimal_udf
4
4
1
--1.23456789E+9
+-1234567890
1234567891
PREHOOK: query: -- floor
EXPLAIN SELECT FLOOR(key) FROM DECIMAL_UDF
@@ -1772,17 +1909,17 @@ POSTHOOK: query: SELECT FLOOR(key) FROM
POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_udf
#### A masked pattern was here ####
--4.4E+3
-1E+99
-0
+-4400
+NULL
+NULL
0
-1E+2
-1E+1
+100
+10
1
0
0
-2E+2
-2E+1
+200
+20
2
0
0
@@ -1809,7 +1946,7 @@ POSTHOOK: Input: default@decimal_udf
3
0
-1234567891
-1.23456789E+9
+1234567890
PREHOOK: query: -- round
EXPLAIN SELECT ROUND(key, 2) FROM DECIMAL_UDF
PREHOOK: type: QUERY
@@ -1855,17 +1992,17 @@ POSTHOOK: query: SELECT ROUND(key, 2) FR
POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_udf
#### A masked pattern was here ####
--4.4E+3
-1E+99
-0
+-4400
+NULL
+NULL
0
-1E+2
-1E+1
+100
+10
1
0.1
0.01
-2E+2
-2E+1
+200
+20
2
0
0.2
@@ -1938,17 +2075,17 @@ POSTHOOK: query: SELECT POWER(key, 2) FR
POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_udf
#### A masked pattern was here ####
-1.936E+7
-1E+198
-1E-198
+19360000
+NULL
+NULL
0
-1E+4
-1E+2
+10000
+100
1
0.01
0.0001
-4E+4
-4E+2
+40000
+400
4
0
0.04
@@ -1973,7 +2110,7 @@ POSTHOOK: Input: default@decimal_udf
9.8596
9.8596
9.8596
-0.99999999999999999999999980000000000000000000000001
+NULL
1524157875323883675.019051998750190521
1524157875323883652.7968299765279684
PREHOOK: query: -- modulo
@@ -2022,7 +2159,7 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_udf
#### A masked pattern was here ####
-2199
-1
+NULL
NULL
NULL
1
@@ -2056,7 +2193,7 @@ NULL
1
1
1
-1E-25
+0.0000000000000000000000001
-617283944.0617283945
1
PREHOOK: query: -- stddev, var
@@ -2154,7 +2291,7 @@ POSTHOOK: Input: default@decimal_udf
-1255 0.0 0.0
-11 0.0 0.0
-1 0.0 0.0
-0 2.5753937681885636E98 6.632653061224489E196
+0 0.23469892060538614 0.055083583333333345
1 0.05928102563215321 0.0035142400000000066
2 0.0 0.0
3 0.0 0.0
@@ -2262,7 +2399,7 @@ POSTHOOK: Input: default@decimal_udf
-1255 0.0 0.0
-11 0.0 0.0
-1 0.0 0.0
-0 2.6726124191242437E98 7.142857142857142E196
+0 0.24513502772590828 0.06009118181818183
1 0.06627820154470102 0.004392800000000008
2 0.0 0.0
3 0.0 0.0
@@ -2344,7 +2481,217 @@ POSTHOOK: query: SELECT histogram_numeri
POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_udf
#### A masked pattern was here ####
-[{"x":-3.429369299009602E7,"y":36.0},{"x":1.2345678901234567E9,"y":1.0},{"x":1.0E99,"y":1.0}]
+[{"x":-1.2345678901234567E9,"y":1.0},{"x":-148.75058823529412,"y":34.0},{"x":1.2345678901234567E9,"y":1.0}]
+PREHOOK: query: -- min
+EXPLAIN SELECT MIN(key) FROM DECIMAL_UDF
+PREHOOK: type: QUERY
+POSTHOOK: query: -- min
+EXPLAIN SELECT MIN(key) FROM DECIMAL_UDF
+POSTHOOK: type: QUERY
+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 MIN (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
+ outputColumnNames: key
+ Group By Operator
+ aggregations:
+ expr: min(key)
+ bucketGroup: false
+ mode: hash
+ outputColumnNames: _col0
+ Reduce Output Operator
+ sort order:
+ tag: -1
+ value expressions:
+ expr: _col0
+ type: decimal
+ Reduce Operator Tree:
+ Group By Operator
+ aggregations:
+ expr: min(VALUE._col0)
+ bucketGroup: false
+ mode: mergepartial
+ outputColumnNames: _col0
+ Select Operator
+ expressions:
+ expr: _col0
+ type: decimal
+ 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
+
+ Stage: Stage-0
+ Fetch Operator
+ limit: -1
+
+
+PREHOOK: query: SELECT MIN(key) FROM DECIMAL_UDF
+PREHOOK: type: QUERY
+PREHOOK: Input: default@decimal_udf
+#### A masked pattern was here ####
+POSTHOOK: query: SELECT MIN(key) FROM DECIMAL_UDF
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@decimal_udf
+#### A masked pattern was here ####
+-1234567890.123456789
+PREHOOK: query: -- max
+EXPLAIN SELECT MAX(key) FROM DECIMAL_UDF
+PREHOOK: type: QUERY
+POSTHOOK: query: -- max
+EXPLAIN SELECT MAX(key) FROM DECIMAL_UDF
+POSTHOOK: type: QUERY
+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 MAX (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
+ outputColumnNames: key
+ Group By Operator
+ aggregations:
+ expr: max(key)
+ bucketGroup: false
+ mode: hash
+ outputColumnNames: _col0
+ Reduce Output Operator
+ sort order:
+ tag: -1
+ value expressions:
+ expr: _col0
+ type: decimal
+ Reduce Operator Tree:
+ Group By Operator
+ aggregations:
+ expr: max(VALUE._col0)
+ bucketGroup: false
+ mode: mergepartial
+ outputColumnNames: _col0
+ Select Operator
+ expressions:
+ expr: _col0
+ type: decimal
+ 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
+
+ Stage: Stage-0
+ Fetch Operator
+ limit: -1
+
+
+PREHOOK: query: SELECT MAX(key) FROM DECIMAL_UDF
+PREHOOK: type: QUERY
+PREHOOK: Input: default@decimal_udf
+#### A masked pattern was here ####
+POSTHOOK: query: SELECT MAX(key) FROM DECIMAL_UDF
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@decimal_udf
+#### A masked pattern was here ####
+1234567890.12345678
+PREHOOK: query: -- count
+EXPLAIN SELECT COUNT(key) FROM DECIMAL_UDF
+PREHOOK: type: QUERY
+POSTHOOK: query: -- count
+EXPLAIN SELECT COUNT(key) FROM DECIMAL_UDF
+POSTHOOK: type: QUERY
+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 COUNT (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
+ outputColumnNames: key
+ Group By Operator
+ aggregations:
+ expr: count(key)
+ bucketGroup: false
+ mode: hash
+ outputColumnNames: _col0
+ Reduce Output Operator
+ sort order:
+ tag: -1
+ value expressions:
+ expr: _col0
+ type: bigint
+ Reduce Operator Tree:
+ Group By Operator
+ aggregations:
+ expr: count(VALUE._col0)
+ bucketGroup: false
+ mode: mergepartial
+ outputColumnNames: _col0
+ Select Operator
+ expressions:
+ expr: _col0
+ type: bigint
+ 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
+
+ Stage: Stage-0
+ Fetch Operator
+ limit: -1
+
+
+PREHOOK: query: SELECT COUNT(key) FROM DECIMAL_UDF
+PREHOOK: type: QUERY
+PREHOOK: Input: default@decimal_udf
+#### A masked pattern was here ####
+POSTHOOK: query: SELECT COUNT(key) FROM DECIMAL_UDF
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@decimal_udf
+#### A masked pattern was here ####
+36
PREHOOK: query: DROP TABLE IF EXISTS DECIMAL_UDF
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@decimal_udf
Modified: hive/branches/HIVE-4115/ql/src/test/results/clientpositive/describe_comment_indent.q.out
URL: http://svn.apache.org/viewvc/hive/branches/HIVE-4115/ql/src/test/results/clientpositive/describe_comment_indent.q.out?rev=1468783&r1=1468782&r2=1468783&view=diff
==============================================================================
--- hive/branches/HIVE-4115/ql/src/test/results/clientpositive/describe_comment_indent.q.out (original)
+++ hive/branches/HIVE-4115/ql/src/test/results/clientpositive/describe_comment_indent.q.out Wed Apr 17 07:29:38 2013
@@ -27,8 +27,6 @@ PREHOOK: query: DESCRIBE test_table
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE test_table
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
col1 int col1 one line comment
col2 string col2
two lines comment
Modified: hive/branches/HIVE-4115/ql/src/test/results/clientpositive/describe_formatted_view_partitioned.q.out
URL: http://svn.apache.org/viewvc/hive/branches/HIVE-4115/ql/src/test/results/clientpositive/describe_formatted_view_partitioned.q.out?rev=1468783&r1=1468782&r2=1468783&view=diff
==============================================================================
--- hive/branches/HIVE-4115/ql/src/test/results/clientpositive/describe_formatted_view_partitioned.q.out (original)
+++ hive/branches/HIVE-4115/ql/src/test/results/clientpositive/describe_formatted_view_partitioned.q.out Wed Apr 17 07:29:38 2013
@@ -9,7 +9,6 @@ SELECT key, value
FROM src
WHERE key=86
PREHOOK: type: CREATEVIEW
-#### A masked pattern was here ####
POSTHOOK: query: CREATE VIEW view_partitioned
PARTITIONED ON (value)
AS
@@ -18,7 +17,6 @@ FROM src
WHERE key=86
POSTHOOK: type: CREATEVIEW
POSTHOOK: Output: default@view_partitioned
-#### A masked pattern was here ####
PREHOOK: query: ALTER VIEW view_partitioned
ADD PARTITION (value='val_86')
PREHOOK: type: ALTERTABLE_ADDPARTS
Modified: hive/branches/HIVE-4115/ql/src/test/results/clientpositive/describe_formatted_view_partitioned_json.q.out
URL: http://svn.apache.org/viewvc/hive/branches/HIVE-4115/ql/src/test/results/clientpositive/describe_formatted_view_partitioned_json.q.out?rev=1468783&r1=1468782&r2=1468783&view=diff
==============================================================================
--- hive/branches/HIVE-4115/ql/src/test/results/clientpositive/describe_formatted_view_partitioned_json.q.out (original)
+++ hive/branches/HIVE-4115/ql/src/test/results/clientpositive/describe_formatted_view_partitioned_json.q.out Wed Apr 17 07:29:38 2013
@@ -9,7 +9,6 @@ SELECT key, value
FROM src
WHERE key=86
PREHOOK: type: CREATEVIEW
-#### A masked pattern was here ####
POSTHOOK: query: CREATE VIEW view_partitioned
PARTITIONED ON (value)
AS
@@ -18,7 +17,6 @@ FROM src
WHERE key=86
POSTHOOK: type: CREATEVIEW
POSTHOOK: Output: default@view_partitioned
-#### A masked pattern was here ####
PREHOOK: query: ALTER VIEW view_partitioned
ADD PARTITION (value='val_86')
PREHOOK: type: ALTERTABLE_ADDPARTS
Modified: hive/branches/HIVE-4115/ql/src/test/results/clientpositive/describe_syntax.q.out
URL: http://svn.apache.org/viewvc/hive/branches/HIVE-4115/ql/src/test/results/clientpositive/describe_syntax.q.out?rev=1468783&r1=1468782&r2=1468783&view=diff
==============================================================================
--- hive/branches/HIVE-4115/ql/src/test/results/clientpositive/describe_syntax.q.out (original)
+++ hive/branches/HIVE-4115/ql/src/test/results/clientpositive/describe_syntax.q.out Wed Apr 17 07:29:38 2013
@@ -38,8 +38,6 @@ PREHOOK: type: DESCTABLE
POSTHOOK: query: -- describe table
DESCRIBE t1
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
key1 int None
value1 string None
ds string None
@@ -54,8 +52,6 @@ PREHOOK: query: DESCRIBE EXTENDED t1
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE EXTENDED t1
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
key1 int None
value1 string None
ds string None
@@ -109,8 +105,6 @@ PREHOOK: type: DESCTABLE
POSTHOOK: query: -- describe database.table
DESCRIBE db1.t1
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
key1 int None
value1 string None
ds string None
@@ -125,8 +119,6 @@ PREHOOK: query: DESCRIBE EXTENDED db1.t1
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE EXTENDED db1.t1
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
key1 int None
value1 string None
ds string None
@@ -180,15 +172,11 @@ PREHOOK: type: DESCTABLE
POSTHOOK: query: -- describe table column
DESCRIBE t1 key1
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
key1 int from deserializer
PREHOOK: query: DESCRIBE EXTENDED t1 key1
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE EXTENDED t1 key1
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
key1 int from deserializer
PREHOOK: query: DESCRIBE FORMATTED t1 key1
PREHOOK: type: DESCTABLE
@@ -203,15 +191,11 @@ PREHOOK: type: DESCTABLE
POSTHOOK: query: -- describe database.tabe column
DESCRIBE db1.t1 key1
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
key1 int from deserializer
PREHOOK: query: DESCRIBE EXTENDED db1.t1 key1
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE EXTENDED db1.t1 key1
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
key1 int from deserializer
PREHOOK: query: DESCRIBE FORMATTED db1.t1 key1
PREHOOK: type: DESCTABLE
@@ -230,15 +214,11 @@ POSTHOOK: query: -- describe table.colum
-- fall back to the old syntax table.column
DESCRIBE t1.key1
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
key1 int from deserializer
PREHOOK: query: DESCRIBE EXTENDED t1.key1
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE EXTENDED t1.key1
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
key1 int from deserializer
PREHOOK: query: DESCRIBE FORMATTED t1.key1
PREHOOK: type: DESCTABLE
@@ -253,8 +233,6 @@ PREHOOK: type: DESCTABLE
POSTHOOK: query: -- describe table partition
DESCRIBE t1 PARTITION(ds='4', part='5')
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
key1 int None
value1 string None
ds string None
@@ -269,8 +247,6 @@ PREHOOK: query: DESCRIBE EXTENDED t1 PAR
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE EXTENDED t1 PARTITION(ds='4', part='5')
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
key1 int None
value1 string None
ds string None
@@ -324,8 +300,6 @@ PREHOOK: type: DESCTABLE
POSTHOOK: query: -- describe database.table partition
DESCRIBE db1.t1 PARTITION(ds='4', part='5')
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
key1 int None
value1 string None
ds string None
@@ -340,8 +314,6 @@ PREHOOK: query: DESCRIBE EXTENDED db1.t1
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE EXTENDED db1.t1 PARTITION(ds='4', part='5')
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
key1 int None
value1 string None
ds string None
Modified: hive/branches/HIVE-4115/ql/src/test/results/clientpositive/describe_table.q.out
URL: http://svn.apache.org/viewvc/hive/branches/HIVE-4115/ql/src/test/results/clientpositive/describe_table.q.out?rev=1468783&r1=1468782&r2=1468783&view=diff
==============================================================================
--- hive/branches/HIVE-4115/ql/src/test/results/clientpositive/describe_table.q.out (original)
+++ hive/branches/HIVE-4115/ql/src/test/results/clientpositive/describe_table.q.out Wed Apr 17 07:29:38 2013
@@ -2,8 +2,6 @@ PREHOOK: query: describe srcpart
PREHOOK: type: DESCTABLE
POSTHOOK: query: describe srcpart
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
key string default
value string default
ds string None
@@ -18,15 +16,11 @@ PREHOOK: query: describe srcpart.key
PREHOOK: type: DESCTABLE
POSTHOOK: query: describe srcpart.key
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
key string from deserializer
PREHOOK: query: describe srcpart PARTITION(ds='2008-04-08', hr='12')
PREHOOK: type: DESCTABLE
POSTHOOK: query: describe srcpart PARTITION(ds='2008-04-08', hr='12')
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
key string default
value string default
ds string None
@@ -41,8 +35,6 @@ PREHOOK: query: describe extended srcpar
PREHOOK: type: DESCTABLE
POSTHOOK: query: describe extended srcpart
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
key string default
value string default
ds string None
@@ -59,15 +51,11 @@ PREHOOK: query: describe extended srcpar
PREHOOK: type: DESCTABLE
POSTHOOK: query: describe extended srcpart.key
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
key string from deserializer
PREHOOK: query: describe extended srcpart PARTITION(ds='2008-04-08', hr='12')
PREHOOK: type: DESCTABLE
POSTHOOK: query: describe extended srcpart PARTITION(ds='2008-04-08', hr='12')
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
key string default
value string default
ds string None
Modified: hive/branches/HIVE-4115/ql/src/test/results/clientpositive/describe_xpath.q.out
URL: http://svn.apache.org/viewvc/hive/branches/HIVE-4115/ql/src/test/results/clientpositive/describe_xpath.q.out?rev=1468783&r1=1468782&r2=1468783&view=diff
==============================================================================
--- hive/branches/HIVE-4115/ql/src/test/results/clientpositive/describe_xpath.q.out (original)
+++ hive/branches/HIVE-4115/ql/src/test/results/clientpositive/describe_xpath.q.out Wed Apr 17 07:29:38 2013
@@ -4,8 +4,6 @@ PREHOOK: type: DESCTABLE
POSTHOOK: query: -- Describe a list structure in a thrift table
describe src_thrift.lint
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
lint array<int> from deserializer
PREHOOK: query: -- Describe the element of a list
describe src_thrift.lint.$elem$
@@ -13,8 +11,6 @@ PREHOOK: type: DESCTABLE
POSTHOOK: query: -- Describe the element of a list
describe src_thrift.lint.$elem$
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
$elem$ int from deserializer
PREHOOK: query: -- Describe the key of a map
describe src_thrift.mStringString.$key$
@@ -22,8 +18,6 @@ PREHOOK: type: DESCTABLE
POSTHOOK: query: -- Describe the key of a map
describe src_thrift.mStringString.$key$
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
$key$ string from deserializer
PREHOOK: query: -- Describe the value of a map
describe src_thrift.mStringString.$value$
@@ -31,8 +25,6 @@ PREHOOK: type: DESCTABLE
POSTHOOK: query: -- Describe the value of a map
describe src_thrift.mStringString.$value$
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
$value$ string from deserializer
PREHOOK: query: -- Describe a complex element of a list
describe src_thrift.lintString.$elem$
@@ -40,8 +32,6 @@ PREHOOK: type: DESCTABLE
POSTHOOK: query: -- Describe a complex element of a list
describe src_thrift.lintString.$elem$
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
myint int from deserializer
mystring string from deserializer
underscore_int int from deserializer
@@ -51,6 +41,4 @@ PREHOOK: type: DESCTABLE
POSTHOOK: query: -- Describe a member of an element of a list
describe src_thrift.lintString.$elem$.myint
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
myint int from deserializer
Modified: hive/branches/HIVE-4115/ql/src/test/results/clientpositive/drop_partitions_filter.q.out
URL: http://svn.apache.org/viewvc/hive/branches/HIVE-4115/ql/src/test/results/clientpositive/drop_partitions_filter.q.out?rev=1468783&r1=1468782&r2=1468783&view=diff
==============================================================================
--- hive/branches/HIVE-4115/ql/src/test/results/clientpositive/drop_partitions_filter.q.out (original)
+++ hive/branches/HIVE-4115/ql/src/test/results/clientpositive/drop_partitions_filter.q.out Wed Apr 17 07:29:38 2013
@@ -7,8 +7,6 @@ PREHOOK: query: describe ptestfilter
PREHOOK: type: DESCTABLE
POSTHOOK: query: describe ptestfilter
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
a string None
b int None
c string None
Modified: hive/branches/HIVE-4115/ql/src/test/results/clientpositive/drop_partitions_filter2.q.out
URL: http://svn.apache.org/viewvc/hive/branches/HIVE-4115/ql/src/test/results/clientpositive/drop_partitions_filter2.q.out?rev=1468783&r1=1468782&r2=1468783&view=diff
==============================================================================
--- hive/branches/HIVE-4115/ql/src/test/results/clientpositive/drop_partitions_filter2.q.out (original)
+++ hive/branches/HIVE-4115/ql/src/test/results/clientpositive/drop_partitions_filter2.q.out Wed Apr 17 07:29:38 2013
@@ -7,8 +7,6 @@ PREHOOK: query: describe ptestfilter
PREHOOK: type: DESCTABLE
POSTHOOK: query: describe ptestfilter
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
a string None
b int None
c int None
Modified: hive/branches/HIVE-4115/ql/src/test/results/clientpositive/drop_partitions_filter3.q.out
URL: http://svn.apache.org/viewvc/hive/branches/HIVE-4115/ql/src/test/results/clientpositive/drop_partitions_filter3.q.out?rev=1468783&r1=1468782&r2=1468783&view=diff
==============================================================================
--- hive/branches/HIVE-4115/ql/src/test/results/clientpositive/drop_partitions_filter3.q.out (original)
+++ hive/branches/HIVE-4115/ql/src/test/results/clientpositive/drop_partitions_filter3.q.out Wed Apr 17 07:29:38 2013
@@ -7,8 +7,6 @@ PREHOOK: query: describe ptestfilter
PREHOOK: type: DESCTABLE
POSTHOOK: query: describe ptestfilter
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
a string None
b int None
c string None
Modified: hive/branches/HIVE-4115/ql/src/test/results/clientpositive/drop_partitions_ignore_protection.q.out
URL: http://svn.apache.org/viewvc/hive/branches/HIVE-4115/ql/src/test/results/clientpositive/drop_partitions_ignore_protection.q.out?rev=1468783&r1=1468782&r2=1468783&view=diff
==============================================================================
--- hive/branches/HIVE-4115/ql/src/test/results/clientpositive/drop_partitions_ignore_protection.q.out (original)
+++ hive/branches/HIVE-4115/ql/src/test/results/clientpositive/drop_partitions_ignore_protection.q.out Wed Apr 17 07:29:38 2013
@@ -23,8 +23,6 @@ PREHOOK: query: desc extended tbl_protec
PREHOOK: type: DESCTABLE
POSTHOOK: query: desc extended tbl_protectmode_no_drop partition (p='p1')
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
c1 string None
c2 string None
p string None
Modified: hive/branches/HIVE-4115/ql/src/test/results/clientpositive/exim_00_nonpart_empty.q.out
URL: http://svn.apache.org/viewvc/hive/branches/HIVE-4115/ql/src/test/results/clientpositive/exim_00_nonpart_empty.q.out?rev=1468783&r1=1468782&r2=1468783&view=diff
==============================================================================
--- hive/branches/HIVE-4115/ql/src/test/results/clientpositive/exim_00_nonpart_empty.q.out (original)
+++ hive/branches/HIVE-4115/ql/src/test/results/clientpositive/exim_00_nonpart_empty.q.out Wed Apr 17 07:29:38 2013
@@ -41,8 +41,6 @@ PREHOOK: query: describe extended exim_d
PREHOOK: type: DESCTABLE
POSTHOOK: query: describe extended exim_department
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
dep_id int department id
#### A masked pattern was here ####
Modified: hive/branches/HIVE-4115/ql/src/test/results/clientpositive/exim_01_nonpart.q.out
URL: http://svn.apache.org/viewvc/hive/branches/HIVE-4115/ql/src/test/results/clientpositive/exim_01_nonpart.q.out?rev=1468783&r1=1468782&r2=1468783&view=diff
==============================================================================
--- hive/branches/HIVE-4115/ql/src/test/results/clientpositive/exim_01_nonpart.q.out (original)
+++ hive/branches/HIVE-4115/ql/src/test/results/clientpositive/exim_01_nonpart.q.out Wed Apr 17 07:29:38 2013
@@ -47,8 +47,6 @@ PREHOOK: query: describe extended exim_d
PREHOOK: type: DESCTABLE
POSTHOOK: query: describe extended exim_department
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
dep_id int department id
#### A masked pattern was here ####
Modified: hive/branches/HIVE-4115/ql/src/test/results/clientpositive/exim_02_00_part_empty.q.out
URL: http://svn.apache.org/viewvc/hive/branches/HIVE-4115/ql/src/test/results/clientpositive/exim_02_00_part_empty.q.out?rev=1468783&r1=1468782&r2=1468783&view=diff
==============================================================================
--- hive/branches/HIVE-4115/ql/src/test/results/clientpositive/exim_02_00_part_empty.q.out (original)
+++ hive/branches/HIVE-4115/ql/src/test/results/clientpositive/exim_02_00_part_empty.q.out Wed Apr 17 07:29:38 2013
@@ -43,8 +43,6 @@ PREHOOK: query: describe extended exim_e
PREHOOK: type: DESCTABLE
POSTHOOK: query: describe extended exim_employee
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
emp_id int employee id
emp_country string two char iso code
emp_state string free text
Modified: hive/branches/HIVE-4115/ql/src/test/results/clientpositive/exim_02_part.q.out
URL: http://svn.apache.org/viewvc/hive/branches/HIVE-4115/ql/src/test/results/clientpositive/exim_02_part.q.out?rev=1468783&r1=1468782&r2=1468783&view=diff
==============================================================================
--- hive/branches/HIVE-4115/ql/src/test/results/clientpositive/exim_02_part.q.out (original)
+++ hive/branches/HIVE-4115/ql/src/test/results/clientpositive/exim_02_part.q.out Wed Apr 17 07:29:38 2013
@@ -55,8 +55,6 @@ PREHOOK: query: describe extended exim_e
PREHOOK: type: DESCTABLE
POSTHOOK: query: describe extended exim_employee
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
emp_id int employee id
emp_country string two char iso code
emp_state string free text