You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by ha...@apache.org on 2014/03/21 05:15:27 UTC
svn commit: r1579876 [5/16] - in /hive/trunk:
common/src/java/org/apache/hadoop/hive/conf/
contrib/src/test/results/clientpositive/
hbase-handler/src/test/results/positive/
itests/test-serde/src/main/java/org/apache/hadoop/hive/serde2/
metastore/src/ja...
Modified: hive/trunk/ql/src/test/results/clientpositive/create_like.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/create_like.q.out?rev=1579876&r1=1579875&r2=1579876&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/create_like.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/create_like.q.out Fri Mar 21 04:15:18 2014
@@ -11,8 +11,8 @@ POSTHOOK: query: DESCRIBE FORMATTED tabl
POSTHOOK: type: DESCTABLE
# col_name data_type comment
-a string None
-b string None
+a string
+b string
# Detailed Table Information
Database: default
@@ -47,8 +47,8 @@ POSTHOOK: query: DESCRIBE FORMATTED tabl
POSTHOOK: type: DESCTABLE
# col_name data_type comment
-a string None
-b string None
+a string
+b string
# Detailed Table Information
Database: default
@@ -91,8 +91,8 @@ POSTHOOK: query: DESCRIBE FORMATTED tabl
POSTHOOK: type: DESCTABLE
# col_name data_type comment
-a string None
-b string None
+a string
+b string
# Detailed Table Information
Database: default
Modified: hive/trunk/ql/src/test/results/clientpositive/create_like2.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/create_like2.q.out?rev=1579876&r1=1579875&r2=1579876&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/create_like2.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/create_like2.q.out Fri Mar 21 04:15:18 2014
@@ -32,8 +32,8 @@ POSTHOOK: query: DESC FORMATTED table2
POSTHOOK: type: DESCTABLE
# col_name data_type comment
-a int None
-b string None
+a int
+b string
# Detailed Table Information
Database: default
Modified: hive/trunk/ql/src/test/results/clientpositive/create_like_tbl_props.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/create_like_tbl_props.q.out?rev=1579876&r1=1579875&r2=1579876&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/create_like_tbl_props.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/create_like_tbl_props.q.out Fri Mar 21 04:15:18 2014
@@ -188,8 +188,8 @@ POSTHOOK: query: DESC FORMATTED test_tab
POSTHOOK: type: DESCTABLE
# col_name data_type comment
-key string None
-value string None
+key string
+value string
# Detailed Table Information
Database: default
Modified: hive/trunk/ql/src/test/results/clientpositive/create_like_view.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/create_like_view.q.out?rev=1579876&r1=1579875&r2=1579876&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/create_like_view.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/create_like_view.q.out Fri Mar 21 04:15:18 2014
@@ -25,16 +25,16 @@ PREHOOK: query: DESCRIBE table1
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE table1
POSTHOOK: type: DESCTABLE
-a string None
-b string None
+a string
+b string
PREHOOK: query: DESCRIBE FORMATTED table1
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE FORMATTED table1
POSTHOOK: type: DESCTABLE
# col_name data_type comment
-a string None
-b string None
+a string
+b string
# Detailed Table Information
Database: default
@@ -74,16 +74,16 @@ PREHOOK: query: DESCRIBE table2
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE table2
POSTHOOK: type: DESCTABLE
-a string None
-b string None
+a string
+b string
PREHOOK: query: DESCRIBE FORMATTED table2
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE FORMATTED table2
POSTHOOK: type: DESCTABLE
# col_name data_type comment
-a string None
-b string None
+a string
+b string
# Detailed Table Information
Database: default
@@ -124,16 +124,16 @@ PREHOOK: query: DESCRIBE table3
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE table3
POSTHOOK: type: DESCTABLE
-a string None
-b string None
+a string
+b string
PREHOOK: query: DESCRIBE FORMATTED table3
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE FORMATTED table3
POSTHOOK: type: DESCTABLE
# col_name data_type comment
-a string None
-b string None
+a string
+b string
# Detailed Table Information
Database: default
@@ -275,14 +275,14 @@ POSTHOOK: Lineage: table2.a SIMPLE [(src
POSTHOOK: Lineage: table2.b SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
# col_name data_type comment
-key string None
-value string None
+key string
+value string
# Partition Information
# col_name data_type comment
-ds string None
-hr string None
+ds string
+hr string
# Detailed Table Information
Database: default
Modified: hive/trunk/ql/src/test/results/clientpositive/create_nested_type.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/create_nested_type.q.out?rev=1579876&r1=1579875&r2=1579876&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/create_nested_type.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/create_nested_type.q.out Fri Mar 21 04:15:18 2014
@@ -19,18 +19,18 @@ PREHOOK: query: DESCRIBE table1
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE table1
POSTHOOK: type: DESCTABLE
-a string None
-b array<string> None
-c array<map<string,string>> None
-d map<string,array<string>> None
+a string
+b array<string>
+c array<map<string,string>>
+d map<string,array<string>>
PREHOOK: query: DESCRIBE EXTENDED table1
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE EXTENDED table1
POSTHOOK: type: DESCTABLE
-a string None
-b array<string> None
-c array<map<string,string>> None
-d map<string,array<string>> None
+a string
+b array<string>
+c array<map<string,string>>
+d map<string,array<string>>
#### A masked pattern was here ####
PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/create_nested_type.txt' OVERWRITE INTO TABLE table1
Modified: hive/trunk/ql/src/test/results/clientpositive/create_or_replace_view.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/create_or_replace_view.q.out?rev=1579876&r1=1579875&r2=1579876&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/create_or_replace_view.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/create_or_replace_view.q.out Fri Mar 21 04:15:18 2014
@@ -15,10 +15,10 @@ POSTHOOK: query: describe formatted v
POSTHOOK: type: DESCTABLE
# col_name data_type comment
-key string None
-value string None
-ds string None
-hr string None
+key string
+value string
+ds string
+hr string
# Detailed Table Information
Database: default
@@ -97,14 +97,14 @@ POSTHOOK: query: describe formatted v
POSTHOOK: type: DESCTABLE
# col_name data_type comment
-key string None
-value string None
+key string
+value string
# Partition Information
# col_name data_type comment
-ds string None
-hr string None
+ds string
+hr string
# Detailed Table Information
Database: default
@@ -163,13 +163,13 @@ POSTHOOK: query: describe formatted v
POSTHOOK: type: DESCTABLE
# col_name data_type comment
-value string None
+value string
# Partition Information
# col_name data_type comment
-ds string None
-hr string None
+ds string
+hr string
# Detailed Table Information
Database: default
@@ -228,14 +228,14 @@ POSTHOOK: query: describe formatted v
POSTHOOK: type: DESCTABLE
# col_name data_type comment
-key string None
-value string None
+key string
+value string
# Partition Information
# col_name data_type comment
-ds string None
-hr string None
+ds string
+hr string
# Detailed Table Information
Database: default
@@ -311,14 +311,14 @@ POSTHOOK: query: describe formatted v
POSTHOOK: type: DESCTABLE
# col_name data_type comment
-key string None
-value string None
+key string
+value string
# Partition Information
# col_name data_type comment
-ds string None
-hr string None
+ds string
+hr string
# Detailed Table Information
Database: default
Modified: hive/trunk/ql/src/test/results/clientpositive/create_skewed_table1.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/create_skewed_table1.q.out?rev=1579876&r1=1579875&r2=1579876&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/create_skewed_table1.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/create_skewed_table1.q.out Fri Mar 21 04:15:18 2014
@@ -25,8 +25,8 @@ POSTHOOK: query: describe formatted list
POSTHOOK: type: DESCTABLE
# col_name data_type comment
-key string None
-value string None
+key string
+value string
# Detailed Table Information
Database: default
@@ -56,8 +56,8 @@ POSTHOOK: query: describe formatted list
POSTHOOK: type: DESCTABLE
# col_name data_type comment
-key string None
-value string None
+key string
+value string
# Detailed Table Information
Database: default
@@ -87,9 +87,9 @@ POSTHOOK: query: describe formatted list
POSTHOOK: type: DESCTABLE
# col_name data_type comment
-col1 string None
-col2 int None
-col3 string None
+col1 string
+col2 int
+col3 string
# Detailed Table Information
Database: default
Modified: hive/trunk/ql/src/test/results/clientpositive/create_view.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/create_view.q.out?rev=1579876&r1=1579875&r2=1579876&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/create_view.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/create_view.q.out Fri Mar 21 04:15:18 2014
@@ -212,12 +212,12 @@ PREHOOK: query: DESCRIBE view1
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE view1
POSTHOOK: type: DESCTABLE
-value string None
+value string
PREHOOK: query: DESCRIBE EXTENDED view1
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE EXTENDED view1
POSTHOOK: type: DESCTABLE
-value string None
+value string
#### A masked pattern was here ####
PREHOOK: query: DESCRIBE FORMATTED view1
@@ -226,7 +226,7 @@ POSTHOOK: query: DESCRIBE FORMATTED view
POSTHOOK: type: DESCTABLE
# col_name data_type comment
-value string None
+value string
# Detailed Table Information
Database: default
@@ -253,14 +253,14 @@ PREHOOK: query: DESCRIBE view2
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE view2
POSTHOOK: type: DESCTABLE
-key string None
-value string None
+key string
+value string
PREHOOK: query: DESCRIBE EXTENDED view2
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE EXTENDED view2
POSTHOOK: type: DESCTABLE
-key string None
-value string None
+key string
+value string
#### A masked pattern was here ####
PREHOOK: query: DESCRIBE FORMATTED view2
@@ -269,8 +269,8 @@ POSTHOOK: query: DESCRIBE FORMATTED view
POSTHOOK: type: DESCTABLE
# col_name data_type comment
-key string None
-value string None
+key string
+value string
# Detailed Table Information
Database: default
@@ -297,12 +297,12 @@ PREHOOK: query: DESCRIBE view3
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE view3
POSTHOOK: type: DESCTABLE
-valoo string None
+valoo string
PREHOOK: query: DESCRIBE EXTENDED view3
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE EXTENDED view3
POSTHOOK: type: DESCTABLE
-valoo string None
+valoo string
#### A masked pattern was here ####
PREHOOK: query: DESCRIBE FORMATTED view3
@@ -311,7 +311,7 @@ POSTHOOK: query: DESCRIBE FORMATTED view
POSTHOOK: type: DESCTABLE
# col_name data_type comment
-valoo string None
+valoo string
# Detailed Table Information
Database: default
@@ -347,7 +347,7 @@ PREHOOK: query: DESCRIBE EXTENDED view3
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE EXTENDED view3
POSTHOOK: type: DESCTABLE
-valoo string None
+valoo string
#### A masked pattern was here ####
PREHOOK: query: DESCRIBE FORMATTED view3
@@ -356,7 +356,7 @@ POSTHOOK: query: DESCRIBE FORMATTED view
POSTHOOK: type: DESCTABLE
# col_name data_type comment
-valoo string None
+valoo string
# Detailed Table Information
Database: default
@@ -396,7 +396,7 @@ POSTHOOK: query: -- use DESCRIBE EXTENDE
-- of comparison for view descriptions
DESCRIBE EXTENDED table1
POSTHOOK: type: DESCTABLE
-key int None
+key int
#### A masked pattern was here ####
PREHOOK: query: DESCRIBE EXTENDED src1
@@ -415,7 +415,7 @@ POSTHOOK: query: -- use DESCRIBE EXTENDE
-- view descriptions
DESCRIBE EXTENDED table1
POSTHOOK: type: DESCTABLE
-key int None
+key int
#### A masked pattern was here ####
PREHOOK: query: INSERT OVERWRITE TABLE table1 SELECT key FROM src WHERE key = 86
@@ -462,7 +462,7 @@ PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE view4
POSTHOOK: type: DESCTABLE
POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
-key int None
+key int
PREHOOK: query: ALTER TABLE table1 ADD COLUMNS (value STRING)
PREHOOK: type: ALTERTABLE_ADDCOLS
PREHOOK: Input: default@table1
@@ -499,14 +499,14 @@ PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE table1
POSTHOOK: type: DESCTABLE
POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
-key int None
-value string None
+key int
+value string
PREHOOK: query: DESCRIBE view4
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE view4
POSTHOOK: type: DESCTABLE
POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
-key int None
+key int
PREHOOK: query: CREATE VIEW view5 AS SELECT v1.key as key1, v2.key as key2
FROM view4 v1 join view4 v2
PREHOOK: type: CREATEVIEW
@@ -538,8 +538,8 @@ PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE view5
POSTHOOK: type: DESCTABLE
POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
-key1 int None
-key2 int None
+key1 int
+key2 int
PREHOOK: query: -- verify that column name and comment in DDL portion
-- overrides column alias in SELECT
CREATE VIEW view6(valoo COMMENT 'I cannot spell') AS
@@ -695,7 +695,7 @@ 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), ]
-c string None
+c string
#### A masked pattern was here ####
FROM table1, viewExpandedText:SELECT `_c0` AS `c` FROM (SELECT `test_translate`('abc', 'a', 'b')
@@ -707,7 +707,7 @@ 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
+c string
# Detailed Table Information
Database: default
@@ -774,7 +774,7 @@ 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), ]
-m int None
+m int
#### A masked pattern was here ####
FROM src, viewExpandedText:SELECT `_c0` AS `m` FROM (SELECT `test_max`(length(`src`.`value`))
@@ -786,7 +786,7 @@ 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
+m int
# Detailed Table Information
Database: default
@@ -851,7 +851,7 @@ 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), ]
-m int None
+m int
#### A masked pattern was here ####
FROM src, viewExpandedText:SELECT `_c0` AS `m` FROM (SELECT `test_max`(length(`src`.`value`))
@@ -863,7 +863,7 @@ 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
+m int
# Detailed Table Information
Database: default
@@ -917,8 +917,8 @@ 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), ]
-key string None
-value string None
+key string
+value string
#### A masked pattern was here ####
PREHOOK: query: DESCRIBE FORMATTED view10
@@ -928,8 +928,8 @@ 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
+key string
+value string
# Detailed Table Information
Database: default
@@ -992,7 +992,7 @@ 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), ]
-boom int None
+boom int
#### A masked pattern was here ####
FROM table1, viewExpandedText:SELECT `test_explode`(array(1,2,3)) AS (`boom`)
@@ -1004,7 +1004,7 @@ 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
+boom int
# Detailed Table Information
Database: default
@@ -1060,9 +1060,9 @@ 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), ]
-key string None
-value string None
-mycol int None
+key string
+value string
+mycol int
#### A masked pattern was here ####
PREHOOK: query: DESCRIBE FORMATTED view12
@@ -1072,9 +1072,9 @@ 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
+key string
+value string
+mycol int
# Detailed Table Information
Database: default
@@ -1146,7 +1146,7 @@ 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), ]
-key int None
+key int
#### A masked pattern was here ####
FROM srcbucket TABLESAMPLE (BUCKET 1 OUT OF 5 ON key) s, viewExpandedText:SELECT `s`.`key`
@@ -1158,7 +1158,7 @@ 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
+key int
# Detailed Table Information
Database: default
@@ -1243,10 +1243,10 @@ 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), ]
-k1 string None
-v1 string None
-k2 string None
-v2 string None
+k1 string
+v1 string
+k2 string
+v2 string
#### A masked pattern was here ####
unionsrc2.key as k2, unionsrc2.value as v2
@@ -1274,10 +1274,10 @@ 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
-v2 string None
+k1 string
+v1 string
+k2 string
+v2 string
# Detailed Table Information
Database: default
@@ -1375,8 +1375,8 @@ 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), ]
-key string None
-value_count bigint None
+key string
+value_count bigint
#### A masked pattern was here ####
FROM src
@@ -1390,8 +1390,8 @@ 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
+key string
+value_count bigint
# Detailed Table Information
Database: default
@@ -1462,7 +1462,7 @@ 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), ]
-value string None
+value string
#### A masked pattern was here ####
FROM src, viewExpandedText:SELECT DISTINCT `src`.`value`
@@ -1474,7 +1474,7 @@ 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
+value string
# Detailed Table Information
Database: default
@@ -1540,7 +1540,7 @@ PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE view16
POSTHOOK: type: DESCTABLE
POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
-value string None
+value string
PREHOOK: query: -- Likewise, DROP VIEW IF EXISTS should ignore a matching table name
DROP VIEW IF EXISTS table1
PREHOOK: type: DROPVIEW
@@ -1557,8 +1557,8 @@ PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE table1
POSTHOOK: type: DESCTABLE
POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
-key int None
-value string None
+key int
+value string
PREHOOK: query: -- this should work since currently we don't track view->table
-- dependencies for implementing RESTRICT
Modified: hive/trunk/ql/src/test/results/clientpositive/create_view_partitioned.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/create_view_partitioned.q.out?rev=1579876&r1=1579875&r2=1579876&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/create_view_partitioned.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/create_view_partitioned.q.out Fri Mar 21 04:15:18 2014
@@ -35,13 +35,13 @@ PREHOOK: query: DESCRIBE EXTENDED vp1
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE EXTENDED vp1
POSTHOOK: type: DESCTABLE
-key string None
-value string None
+key string
+value string
# Partition Information
# col_name data_type comment
-value string None
+value string
#### A masked pattern was here ####
FROM src
@@ -54,12 +54,12 @@ POSTHOOK: query: DESCRIBE FORMATTED vp1
POSTHOOK: type: DESCTABLE
# col_name data_type comment
-key string None
+key string
# Partition Information
# col_name data_type comment
-value string None
+value string
# Detailed Table Information
Database: default
@@ -249,14 +249,14 @@ POSTHOOK: query: DESCRIBE FORMATTED vp2
POSTHOOK: type: DESCTABLE
# col_name data_type comment
-key string None
-value string None
-ds string None
+key string
+value string
+ds string
# Partition Information
# col_name data_type comment
-hr string None
+hr string
# Detailed Table Information
Database: default
@@ -360,12 +360,12 @@ POSTHOOK: query: DESCRIBE FORMATTED vp3
POSTHOOK: type: DESCTABLE
# col_name data_type comment
-k string None
+k string
# Partition Information
# col_name data_type comment
-v string None
+v string
# Detailed Table Information
Database: default
Modified: hive/trunk/ql/src/test/results/clientpositive/create_view_translate.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/create_view_translate.q.out?rev=1579876&r1=1579875&r2=1579876&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/create_view_translate.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/create_view_translate.q.out Fri Mar 21 04:15:18 2014
@@ -19,7 +19,7 @@ POSTHOOK: query: describe formatted v
POSTHOOK: type: DESCTABLE
# col_name data_type comment
-key string None
+key string
# Detailed Table Information
Database: default
@@ -59,8 +59,8 @@ POSTHOOK: query: describe formatted w
POSTHOOK: type: DESCTABLE
# col_name data_type comment
-key string None
-value string None
+key string
+value string
# Detailed Table Information
Database: default
Modified: hive/trunk/ql/src/test/results/clientpositive/ctas.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/ctas.q.out?rev=1579876&r1=1579875&r2=1579876&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/ctas.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/ctas.q.out Fri Mar 21 04:15:18 2014
@@ -2,10 +2,12 @@ PREHOOK: query: -- EXCLUDE_HADOOP_MAJOR_
create table nzhang_Tmp(a int, b string)
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: -- EXCLUDE_HADOOP_MAJOR_VERSIONS(0.20, 0.20S)
create table nzhang_Tmp(a int, b string)
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@nzhang_Tmp
PREHOOK: query: select * from nzhang_Tmp
PREHOOK: type: QUERY
@@ -127,8 +129,8 @@ POSTHOOK: query: describe formatted nzha
POSTHOOK: type: DESCTABLE
# col_name data_type comment
-k string None
-value string None
+k string
+value string
# Detailed Table Information
Database: default
@@ -267,8 +269,8 @@ POSTHOOK: query: describe formatted nzha
POSTHOOK: type: DESCTABLE
# col_name data_type comment
-key string None
-value string None
+key string
+value string
# Detailed Table Information
Database: default
@@ -408,8 +410,8 @@ POSTHOOK: query: describe formatted nzha
POSTHOOK: type: DESCTABLE
# col_name data_type comment
-half_key double None
-conb string None
+half_key double
+conb string
# Detailed Table Information
Database: default
@@ -471,8 +473,8 @@ POSTHOOK: query: describe formatted nzha
POSTHOOK: type: DESCTABLE
# col_name data_type comment
-half_key double None
-conb string None
+half_key double
+conb string
# Detailed Table Information
Database: default
@@ -612,8 +614,8 @@ POSTHOOK: query: describe formatted nzha
POSTHOOK: type: DESCTABLE
# col_name data_type comment
-key string None
-value string None
+key string
+value string
# Detailed Table Information
Database: default
@@ -722,6 +724,7 @@ STAGE PLANS:
COLUMN_STATS_ACCURATE true
bucket_count -1
columns key,value
+ columns.comments default default
columns.types string:string
#### A masked pattern was here ####
name default.src
@@ -741,6 +744,7 @@ STAGE PLANS:
COLUMN_STATS_ACCURATE true
bucket_count -1
columns key,value
+ columns.comments default default
columns.types string:string
#### A masked pattern was here ####
name default.src
@@ -880,8 +884,10 @@ POSTHOOK: Input: default@src
POSTHOOK: Output: default@nzhang_ctas5
PREHOOK: query: create table nzhang_ctas6 (key string, `to` string)
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: create table nzhang_ctas6 (key string, `to` string)
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@nzhang_ctas6
PREHOOK: query: insert overwrite table nzhang_ctas6 select key, value from src tablesample (10 rows)
PREHOOK: type: QUERY
Modified: hive/trunk/ql/src/test/results/clientpositive/ctas_colname.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/ctas_colname.q.out?rev=1579876&r1=1579875&r2=1579876&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/ctas_colname.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/ctas_colname.q.out Fri Mar 21 04:15:18 2014
@@ -87,10 +87,10 @@ POSTHOOK: query: describe formatted summ
POSTHOOK: type: DESCTABLE
# col_name data_type comment
-_col0 double None
-_col1 bigint None
-_c1 double None
-_c2 bigint None
+_col0 double
+_col1 bigint
+_c1 double
+_c2 bigint
# Detailed Table Information
Database: default
@@ -201,9 +201,9 @@ POSTHOOK: query: describe formatted x4
POSTHOOK: type: DESCTABLE
# col_name data_type comment
-key string None
-value string None
-rr int None
+key string
+value string
+rr int
# Detailed Table Information
Database: default
@@ -361,9 +361,9 @@ POSTHOOK: query: describe formatted x5
POSTHOOK: type: DESCTABLE
# col_name data_type comment
-key string None
-value string None
-lead1 string None
+key string
+value string
+lead1 string
# Detailed Table Information
Database: default
@@ -501,8 +501,8 @@ POSTHOOK: query: describe formatted x6
POSTHOOK: type: DESCTABLE
# col_name data_type comment
-_col0 string None
-_c1 string None
+_col0 string
+_c1 string
# Detailed Table Information
Database: default
@@ -620,7 +620,7 @@ POSTHOOK: query: describe formatted x7
POSTHOOK: type: DESCTABLE
# col_name data_type comment
-_col0 string None
+_col0 string
# Detailed Table Information
Database: default
@@ -1049,7 +1049,7 @@ POSTHOOK: query: describe formatted x8
POSTHOOK: type: DESCTABLE
# col_name data_type comment
-_col0 string None
+_col0 string
# Detailed Table Information
Database: default
@@ -1180,8 +1180,8 @@ POSTHOOK: query: describe formatted x9
POSTHOOK: type: DESCTABLE
# col_name data_type comment
-_c0 string None
-key string None
+_c0 string
+key string
# Detailed Table Information
Database: default
Modified: hive/trunk/ql/src/test/results/clientpositive/ctas_hadoop20.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/ctas_hadoop20.q.out?rev=1579876&r1=1579875&r2=1579876&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/ctas_hadoop20.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/ctas_hadoop20.q.out Fri Mar 21 04:15:18 2014
@@ -129,8 +129,8 @@ POSTHOOK: query: describe formatted nzha
POSTHOOK: type: DESCTABLE
# col_name data_type comment
-k string None
-value string None
+k string
+value string
# Detailed Table Information
Database: default
@@ -269,8 +269,8 @@ POSTHOOK: query: describe formatted nzha
POSTHOOK: type: DESCTABLE
# col_name data_type comment
-key string None
-value string None
+key string
+value string
# Detailed Table Information
Database: default
@@ -410,8 +410,8 @@ POSTHOOK: query: describe formatted nzha
POSTHOOK: type: DESCTABLE
# col_name data_type comment
-half_key double None
-conb string None
+half_key double
+conb string
# Detailed Table Information
Database: default
@@ -473,8 +473,8 @@ POSTHOOK: query: describe formatted nzha
POSTHOOK: type: DESCTABLE
# col_name data_type comment
-half_key double None
-conb string None
+half_key double
+conb string
# Detailed Table Information
Database: default
@@ -614,8 +614,8 @@ POSTHOOK: query: describe formatted nzha
POSTHOOK: type: DESCTABLE
# col_name data_type comment
-key string None
-value string None
+key string
+value string
# Detailed Table Information
Database: default
@@ -724,6 +724,7 @@ STAGE PLANS:
COLUMN_STATS_ACCURATE true
bucket_count -1
columns key,value
+ columns.comments default default
columns.types string:string
#### A masked pattern was here ####
name default.src
@@ -743,6 +744,7 @@ STAGE PLANS:
COLUMN_STATS_ACCURATE true
bucket_count -1
columns key,value
+ columns.comments default default
columns.types string:string
#### A masked pattern was here ####
name default.src
@@ -921,7 +923,7 @@ POSTHOOK: query: desc nzhang_ctas8
POSTHOOK: type: DESCTABLE
POSTHOOK: Lineage: nzhang_ctas6.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: nzhang_ctas6.to SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-_c0 decimal(3,2) None
+_c0 decimal(3,2)
PREHOOK: query: drop table nzhang_ctas8
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@nzhang_ctas8
Modified: hive/trunk/ql/src/test/results/clientpositive/ctas_uses_database_location.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/ctas_uses_database_location.q.out?rev=1579876&r1=1579875&r2=1579876&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/ctas_uses_database_location.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/ctas_uses_database_location.q.out Fri Mar 21 04:15:18 2014
@@ -122,8 +122,8 @@ POSTHOOK: query: DESCRIBE FORMATTED tabl
POSTHOOK: type: DESCTABLE
# col_name data_type comment
-key string None
-value string None
+key string
+value string
# Detailed Table Information
Database: db1
Modified: hive/trunk/ql/src/test/results/clientpositive/custom_input_output_format.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/custom_input_output_format.q.out?rev=1579876&r1=1579875&r2=1579876&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/custom_input_output_format.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/custom_input_output_format.q.out Fri Mar 21 04:15:18 2014
@@ -13,8 +13,8 @@ PREHOOK: query: DESCRIBE EXTENDED src1_r
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE EXTENDED src1_rot13_iof
POSTHOOK: type: DESCTABLE
-key string None
-value string None
+key string
+value string
#### A masked pattern was here ####
PREHOOK: query: SELECT * FROM src1 ORDER BY key, value
Modified: hive/trunk/ql/src/test/results/clientpositive/database.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/database.q.out?rev=1579876&r1=1579875&r2=1579876&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/database.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/database.q.out Fri Mar 21 04:15:18 2014
@@ -139,14 +139,14 @@ PREHOOK: type: DESCTABLE
POSTHOOK: query: -- DESCRIBE table in non-default DB
DESCRIBE test_table
POSTHOOK: type: DESCTABLE
-col1 string None
+col1 string
PREHOOK: query: -- DESCRIBE EXTENDED in non-default DB
DESCRIBE EXTENDED test_table
PREHOOK: type: DESCTABLE
POSTHOOK: query: -- DESCRIBE EXTENDED in non-default DB
DESCRIBE EXTENDED test_table
POSTHOOK: type: DESCTABLE
-col1 string None
+col1 string
#### A masked pattern was here ####
PREHOOK: query: -- CREATE LIKE in non-default DB
@@ -168,7 +168,7 @@ PREHOOK: query: DESCRIBE EXTENDED test_t
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE EXTENDED test_table_like
POSTHOOK: type: DESCTABLE
-col1 string None
+col1 string
#### A masked pattern was here ####
PREHOOK: query: -- LOAD and SELECT
Modified: hive/trunk/ql/src/test/results/clientpositive/database_location.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/database_location.q.out?rev=1579876&r1=1579875&r2=1579876&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/database_location.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/database_location.q.out Fri Mar 21 04:15:18 2014
@@ -24,8 +24,8 @@ POSTHOOK: query: DESCRIBE FORMATTED tabl
POSTHOOK: type: DESCTABLE
# col_name data_type comment
-name string None
-value int None
+name string
+value int
# Detailed Table Information
Database: db1
@@ -84,8 +84,8 @@ POSTHOOK: query: DESCRIBE FORMATTED tabl
POSTHOOK: type: DESCTABLE
# col_name data_type comment
-name string None
-value int None
+name string
+value int
# Detailed Table Information
Database: db2