You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by xu...@apache.org on 2017/11/30 03:17:56 UTC
[28/32] hive git commit: HIVE-17528 : Add more q-tests for
Hive-on-Spark with Parquet vectorized reader (Ferdinand Xu,
reviewed by Vihang Karajgaonkar)
http://git-wip-us.apache.org/repos/asf/hive/blob/029e48b7/ql/src/test/results/clientpositive/authorization_show_grant.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/authorization_show_grant.q.out b/ql/src/test/results/clientpositive/authorization_show_grant.q.out
index d0fed81..b4dab78 100644
--- a/ql/src/test/results/clientpositive/authorization_show_grant.q.out
+++ b/ql/src/test/results/clientpositive/authorization_show_grant.q.out
@@ -107,6 +107,10 @@ default alltypesorc hive_test_user USER DELETE true -1 hive_test_user
default alltypesorc hive_test_user USER INSERT true -1 hive_test_user
default alltypesorc hive_test_user USER SELECT true -1 hive_test_user
default alltypesorc hive_test_user USER UPDATE true -1 hive_test_user
+default alltypesparquet hive_test_user USER DELETE true -1 hive_test_user
+default alltypesparquet hive_test_user USER INSERT true -1 hive_test_user
+default alltypesparquet hive_test_user USER SELECT true -1 hive_test_user
+default alltypesparquet hive_test_user USER UPDATE true -1 hive_test_user
default cbo_t1 hive_test_user USER DELETE true -1 hive_test_user
default cbo_t1 hive_test_user USER INSERT true -1 hive_test_user
default cbo_t1 hive_test_user USER SELECT true -1 hive_test_user
http://git-wip-us.apache.org/repos/asf/hive/blob/029e48b7/ql/src/test/results/clientpositive/cte_5.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/cte_5.q.out b/ql/src/test/results/clientpositive/cte_5.q.out
index ac0dac0..3d7b324 100644
--- a/ql/src/test/results/clientpositive/cte_5.q.out
+++ b/ql/src/test/results/clientpositive/cte_5.q.out
@@ -47,6 +47,7 @@ POSTHOOK: query: show tables
POSTHOOK: type: SHOWTABLES
POSTHOOK: Input: database:default
alltypesorc
+alltypesparquet
cbo_t1
cbo_t2
cbo_t3
http://git-wip-us.apache.org/repos/asf/hive/blob/029e48b7/ql/src/test/results/clientpositive/cte_mat_4.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/cte_mat_4.q.out b/ql/src/test/results/clientpositive/cte_mat_4.q.out
index bc92f14..572bbf2 100644
--- a/ql/src/test/results/clientpositive/cte_mat_4.q.out
+++ b/ql/src/test/results/clientpositive/cte_mat_4.q.out
@@ -21,6 +21,7 @@ POSTHOOK: query: show tables
POSTHOOK: type: SHOWTABLES
POSTHOOK: Input: database:default
alltypesorc
+alltypesparquet
cbo_t1
cbo_t2
cbo_t3
@@ -220,6 +221,7 @@ POSTHOOK: query: show tables
POSTHOOK: type: SHOWTABLES
POSTHOOK: Input: database:default
alltypesorc
+alltypesparquet
cbo_t1
cbo_t2
cbo_t3
@@ -260,6 +262,7 @@ POSTHOOK: query: show tables
POSTHOOK: type: SHOWTABLES
POSTHOOK: Input: database:default
alltypesorc
+alltypesparquet
cbo_t1
cbo_t2
cbo_t3
@@ -458,6 +461,7 @@ POSTHOOK: query: show tables
POSTHOOK: type: SHOWTABLES
POSTHOOK: Input: database:default
alltypesorc
+alltypesparquet
cbo_t1
cbo_t2
cbo_t3
http://git-wip-us.apache.org/repos/asf/hive/blob/029e48b7/ql/src/test/results/clientpositive/cte_mat_5.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/cte_mat_5.q.out b/ql/src/test/results/clientpositive/cte_mat_5.q.out
index 3747cec..ca44108 100644
--- a/ql/src/test/results/clientpositive/cte_mat_5.q.out
+++ b/ql/src/test/results/clientpositive/cte_mat_5.q.out
@@ -47,6 +47,7 @@ POSTHOOK: query: show tables
POSTHOOK: type: SHOWTABLES
POSTHOOK: Input: database:default
alltypesorc
+alltypesparquet
cbo_t1
cbo_t2
cbo_t3
http://git-wip-us.apache.org/repos/asf/hive/blob/029e48b7/ql/src/test/results/clientpositive/describe_table_json.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/describe_table_json.q.out b/ql/src/test/results/clientpositive/describe_table_json.q.out
index ebf15ac..3fc950f 100644
--- a/ql/src/test/results/clientpositive/describe_table_json.q.out
+++ b/ql/src/test/results/clientpositive/describe_table_json.q.out
@@ -12,7 +12,7 @@ PREHOOK: Input: database:default
POSTHOOK: query: SHOW TABLES
POSTHOOK: type: SHOWTABLES
POSTHOOK: Input: database:default
-{"tables":["alltypesorc","cbo_t1","cbo_t2","cbo_t3","jsontable","lineitem","part","src","src1","src_cbo","src_json","src_sequencefile","src_thrift","srcbucket","srcbucket2","srcpart"]}
+{"tables":["alltypesorc","alltypesparquet","cbo_t1","cbo_t2","cbo_t3","jsontable","lineitem","part","src","src1","src_cbo","src_json","src_sequencefile","src_thrift","srcbucket","srcbucket2","srcpart"]}
PREHOOK: query: SHOW TABLES LIKE 'json*'
PREHOOK: type: SHOWTABLES
PREHOOK: Input: database:default
http://git-wip-us.apache.org/repos/asf/hive/blob/029e48b7/ql/src/test/results/clientpositive/drop_table_with_index.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/drop_table_with_index.q.out b/ql/src/test/results/clientpositive/drop_table_with_index.q.out
index 87c6978..7f8d7ae 100644
--- a/ql/src/test/results/clientpositive/drop_table_with_index.q.out
+++ b/ql/src/test/results/clientpositive/drop_table_with_index.q.out
@@ -79,6 +79,7 @@ POSTHOOK: type: SHOWTABLES
POSTHOOK: Input: database:default
aa
alltypesorc
+alltypesparquet
cbo_t1
cbo_t2
cbo_t3
http://git-wip-us.apache.org/repos/asf/hive/blob/029e48b7/ql/src/test/results/clientpositive/index_creation.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/index_creation.q.out b/ql/src/test/results/clientpositive/index_creation.q.out
index ca113ef..49b3f11 100644
--- a/ql/src/test/results/clientpositive/index_creation.q.out
+++ b/ql/src/test/results/clientpositive/index_creation.q.out
@@ -304,6 +304,7 @@ POSTHOOK: query: show tables
POSTHOOK: type: SHOWTABLES
POSTHOOK: Input: database:default
alltypesorc
+alltypesparquet
cbo_t1
cbo_t2
cbo_t3
http://git-wip-us.apache.org/repos/asf/hive/blob/029e48b7/ql/src/test/results/clientpositive/input2.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/input2.q.out b/ql/src/test/results/clientpositive/input2.q.out
index 4dac88a..9693131 100644
--- a/ql/src/test/results/clientpositive/input2.q.out
+++ b/ql/src/test/results/clientpositive/input2.q.out
@@ -46,6 +46,7 @@ POSTHOOK: query: SHOW TABLES
POSTHOOK: type: SHOWTABLES
POSTHOOK: Input: database:default
alltypesorc
+alltypesparquet
cbo_t1
cbo_t2
cbo_t3
@@ -77,6 +78,7 @@ POSTHOOK: query: SHOW TABLES
POSTHOOK: type: SHOWTABLES
POSTHOOK: Input: database:default
alltypesorc
+alltypesparquet
cbo_t1
cbo_t2
cbo_t3
http://git-wip-us.apache.org/repos/asf/hive/blob/029e48b7/ql/src/test/results/clientpositive/input3.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/input3.q.out b/ql/src/test/results/clientpositive/input3.q.out
index 8316a46..db30111 100644
--- a/ql/src/test/results/clientpositive/input3.q.out
+++ b/ql/src/test/results/clientpositive/input3.q.out
@@ -38,6 +38,7 @@ POSTHOOK: query: SHOW TABLES
POSTHOOK: type: SHOWTABLES
POSTHOOK: Input: database:default
alltypesorc
+alltypesparquet
cbo_t1
cbo_t2
cbo_t3
@@ -132,6 +133,7 @@ POSTHOOK: query: SHOW TABLES
POSTHOOK: type: SHOWTABLES
POSTHOOK: Input: database:default
alltypesorc
+alltypesparquet
cbo_t1
cbo_t2
cbo_t3
http://git-wip-us.apache.org/repos/asf/hive/blob/029e48b7/ql/src/test/results/clientpositive/llap/cte_5.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/cte_5.q.out b/ql/src/test/results/clientpositive/llap/cte_5.q.out
index 58a963b..717efd0 100644
--- a/ql/src/test/results/clientpositive/llap/cte_5.q.out
+++ b/ql/src/test/results/clientpositive/llap/cte_5.q.out
@@ -47,6 +47,7 @@ POSTHOOK: query: show tables
POSTHOOK: type: SHOWTABLES
POSTHOOK: Input: database:default
alltypesorc
+alltypesparquet
cbo_t1
cbo_t2
cbo_t3
http://git-wip-us.apache.org/repos/asf/hive/blob/029e48b7/ql/src/test/results/clientpositive/llap/cte_mat_4.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/cte_mat_4.q.out b/ql/src/test/results/clientpositive/llap/cte_mat_4.q.out
index 1c5be08..292c467 100644
--- a/ql/src/test/results/clientpositive/llap/cte_mat_4.q.out
+++ b/ql/src/test/results/clientpositive/llap/cte_mat_4.q.out
@@ -21,6 +21,7 @@ POSTHOOK: query: show tables
POSTHOOK: type: SHOWTABLES
POSTHOOK: Input: database:default
alltypesorc
+alltypesparquet
cbo_t1
cbo_t2
cbo_t3
@@ -132,6 +133,7 @@ POSTHOOK: query: show tables
POSTHOOK: type: SHOWTABLES
POSTHOOK: Input: database:default
alltypesorc
+alltypesparquet
cbo_t1
cbo_t2
cbo_t3
@@ -172,6 +174,7 @@ POSTHOOK: query: show tables
POSTHOOK: type: SHOWTABLES
POSTHOOK: Input: database:default
alltypesorc
+alltypesparquet
cbo_t1
cbo_t2
cbo_t3
@@ -282,6 +285,7 @@ POSTHOOK: query: show tables
POSTHOOK: type: SHOWTABLES
POSTHOOK: Input: database:default
alltypesorc
+alltypesparquet
cbo_t1
cbo_t2
cbo_t3
http://git-wip-us.apache.org/repos/asf/hive/blob/029e48b7/ql/src/test/results/clientpositive/llap/cte_mat_5.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/cte_mat_5.q.out b/ql/src/test/results/clientpositive/llap/cte_mat_5.q.out
index 0c22b72..f62c5b7 100644
--- a/ql/src/test/results/clientpositive/llap/cte_mat_5.q.out
+++ b/ql/src/test/results/clientpositive/llap/cte_mat_5.q.out
@@ -47,6 +47,7 @@ POSTHOOK: query: show tables
POSTHOOK: type: SHOWTABLES
POSTHOOK: Input: database:default
alltypesorc
+alltypesparquet
cbo_t1
cbo_t2
cbo_t3
http://git-wip-us.apache.org/repos/asf/hive/blob/029e48b7/ql/src/test/results/clientpositive/llap/jdbc_handler.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/jdbc_handler.q.out b/ql/src/test/results/clientpositive/llap/jdbc_handler.q.out
index 74bd60b..7c5f9b5 100644
--- a/ql/src/test/results/clientpositive/llap/jdbc_handler.q.out
+++ b/ql/src/test/results/clientpositive/llap/jdbc_handler.q.out
@@ -85,6 +85,7 @@ POSTHOOK: Input: default@dbs
POSTHOOK: Input: default@tables
#### A masked pattern was here ####
alltypesorc default MANAGED_TABLE
+alltypesparquet default MANAGED_TABLE
cbo_t1 default MANAGED_TABLE
cbo_t2 default MANAGED_TABLE
cbo_t3 default MANAGED_TABLE
@@ -251,6 +252,7 @@ POSTHOOK: Input: default@src
POSTHOOK: Input: default@tables
#### A masked pattern was here ####
alltypesorc 2
+alltypesparquet 2
cbo_t1 2
cbo_t2 2
cbo_t3 2
@@ -274,6 +276,7 @@ POSTHOOK: query: show tables
POSTHOOK: type: SHOWTABLES
POSTHOOK: Input: database:default
alltypesorc
+alltypesparquet
cbo_t1
cbo_t2
cbo_t3
http://git-wip-us.apache.org/repos/asf/hive/blob/029e48b7/ql/src/test/results/clientpositive/llap/temp_table.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/temp_table.q.out b/ql/src/test/results/clientpositive/llap/temp_table.q.out
index e97b3dd..5a2f77f 100644
--- a/ql/src/test/results/clientpositive/llap/temp_table.q.out
+++ b/ql/src/test/results/clientpositive/llap/temp_table.q.out
@@ -400,6 +400,7 @@ POSTHOOK: query: SHOW TABLES
POSTHOOK: type: SHOWTABLES
POSTHOOK: Input: database:default
alltypesorc
+alltypesparquet
bar
bay
baz
http://git-wip-us.apache.org/repos/asf/hive/blob/029e48b7/ql/src/test/results/clientpositive/parquet_read_backward_compatible_files.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/parquet_read_backward_compatible_files.q.out b/ql/src/test/results/clientpositive/parquet_read_backward_compatible_files.q.out
index 22a050a..48e1852 100644
--- a/ql/src/test/results/clientpositive/parquet_read_backward_compatible_files.q.out
+++ b/ql/src/test/results/clientpositive/parquet_read_backward_compatible_files.q.out
@@ -1,4 +1,4 @@
-PREHOOK: query: CREATE TABLE alltypesparquet (
+PREHOOK: query: CREATE TABLE alltypesparquet_old (
bo1 boolean,
ti1 tinyint,
si1 smallint,
@@ -13,8 +13,8 @@ PREHOOK: query: CREATE TABLE alltypesparquet (
) STORED AS PARQUET
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
-PREHOOK: Output: default@alltypesparquet
-POSTHOOK: query: CREATE TABLE alltypesparquet (
+PREHOOK: Output: default@alltypesparquet_old
+POSTHOOK: query: CREATE TABLE alltypesparquet_old (
bo1 boolean,
ti1 tinyint,
si1 smallint,
@@ -29,21 +29,21 @@ POSTHOOK: query: CREATE TABLE alltypesparquet (
) STORED AS PARQUET
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
-POSTHOOK: Output: default@alltypesparquet
-PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/alltypesparquet' OVERWRITE INTO TABLE alltypesparquet
+POSTHOOK: Output: default@alltypesparquet_old
+PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/alltypesparquet' OVERWRITE INTO TABLE alltypesparquet_old
PREHOOK: type: LOAD
#### A masked pattern was here ####
-PREHOOK: Output: default@alltypesparquet
-POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/alltypesparquet' OVERWRITE INTO TABLE alltypesparquet
+PREHOOK: Output: default@alltypesparquet_old
+POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/alltypesparquet' OVERWRITE INTO TABLE alltypesparquet_old
POSTHOOK: type: LOAD
#### A masked pattern was here ####
-POSTHOOK: Output: default@alltypesparquet
-PREHOOK: query: SELECT * FROM alltypesparquet
+POSTHOOK: Output: default@alltypesparquet_old
+PREHOOK: query: SELECT * FROM alltypesparquet_old
PREHOOK: type: QUERY
-PREHOOK: Input: default@alltypesparquet
+PREHOOK: Input: default@alltypesparquet_old
#### A masked pattern was here ####
-POSTHOOK: query: SELECT * FROM alltypesparquet
+POSTHOOK: query: SELECT * FROM alltypesparquet_old
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@alltypesparquet
+POSTHOOK: Input: default@alltypesparquet_old
#### A masked pattern was here ####
true 10 100 1000 10000 4.0 20.0 hello {"k1":"v1"} [100,200] {"c1":10,"c2":"foo"}