You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by vg...@apache.org on 2018/04/11 18:18:23 UTC
hive git commit: HIVE-19166: TestMiniLlapLocalCliDriver sysdb
failure(Vineet Garg, reviewed by Zoltan Haindrich)
Repository: hive
Updated Branches:
refs/heads/master f8a671d8c -> 8777125b3
HIVE-19166: TestMiniLlapLocalCliDriver sysdb failure(Vineet Garg,reviewed by Zoltan Haindrich)
Project: http://git-wip-us.apache.org/repos/asf/hive/repo
Commit: http://git-wip-us.apache.org/repos/asf/hive/commit/8777125b
Tree: http://git-wip-us.apache.org/repos/asf/hive/tree/8777125b
Diff: http://git-wip-us.apache.org/repos/asf/hive/diff/8777125b
Branch: refs/heads/master
Commit: 8777125b3d9dfcea7b7ce31f6535c5e64780bfbd
Parents: f8a671d
Author: Vineet Garg <vg...@apache.org>
Authored: Wed Apr 11 11:17:36 2018 -0700
Committer: Vineet Garg <vg...@apache.org>
Committed: Wed Apr 11 11:18:06 2018 -0700
----------------------------------------------------------------------
ql/src/test/queries/clientpositive/sysdb.q | 5 +-
.../results/clientpositive/llap/sysdb.q.out | 140 ++-----------------
2 files changed, 12 insertions(+), 133 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/hive/blob/8777125b/ql/src/test/queries/clientpositive/sysdb.q
----------------------------------------------------------------------
diff --git a/ql/src/test/queries/clientpositive/sysdb.q b/ql/src/test/queries/clientpositive/sysdb.q
index 36d80e2..399c3ce 100644
--- a/ql/src/test/queries/clientpositive/sysdb.q
+++ b/ql/src/test/queries/clientpositive/sysdb.q
@@ -3,6 +3,7 @@ set hive.strict.checks.cartesian.product=false;
set hive.compute.query.using.stats=false;
set hive.support.concurrency=true;
+set hive.txn.manager=org.apache.hadoop.hive.ql.lockmgr.DbTxnManager;
set hive.cbo.enable=false;
@@ -42,10 +43,6 @@ select grantor, principal_name from db_privs order by grantor, principal_name li
select grantor, principal_name from global_privs order by grantor, principal_name limit 5;
-select index_name, index_handler_class from idxs order by index_name limit 5;
-
-select param_key, param_value from index_params order by param_key, param_value limit 5;
-
select part_name from partitions order by part_name limit 5;
select pkey_name, pkey_type from partition_keys order by pkey_name limit 5;
http://git-wip-us.apache.org/repos/asf/hive/blob/8777125b/ql/src/test/results/clientpositive/llap/sysdb.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/sysdb.q.out b/ql/src/test/results/clientpositive/llap/sysdb.q.out
index 73c5077..7d977d3 100644
--- a/ql/src/test/results/clientpositive/llap/sysdb.q.out
+++ b/ql/src/test/results/clientpositive/llap/sysdb.q.out
@@ -482,110 +482,6 @@ FROM
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: SYS@GLOBAL_PRIVS
POSTHOOK: Output: database:sys
-PREHOOK: query: CREATE TABLE IF NOT EXISTS `IDXS` (
- `INDEX_ID` bigint,
- `CREATE_TIME` int,
- `DEFERRED_REBUILD` boolean,
- `INDEX_HANDLER_CLASS` string,
- `INDEX_NAME` string,
- `INDEX_TBL_ID` bigint,
- `LAST_ACCESS_TIME` int,
- `ORIG_TBL_ID` bigint,
- `SD_ID` bigint,
- CONSTRAINT `SYS_PK_IDXS` PRIMARY KEY (`INDEX_ID`) DISABLE
-)
-STORED BY 'org.apache.hive.storage.jdbc.JdbcStorageHandler'
-TBLPROPERTIES (
-"hive.sql.database.type" = "METASTORE",
-"hive.sql.query" =
-"SELECT
- \"INDEX_ID\",
- \"CREATE_TIME\",
- \"DEFERRED_REBUILD\",
- \"INDEX_HANDLER_CLASS\",
- \"INDEX_NAME\",
- \"INDEX_TBL_ID\",
- \"LAST_ACCESS_TIME\",
- \"ORIG_TBL_ID\",
- \"SD_ID\"
-FROM
- \"IDXS\""
-)
-PREHOOK: type: CREATETABLE
-PREHOOK: Output: SYS@IDXS
-PREHOOK: Output: database:sys
-POSTHOOK: query: CREATE TABLE IF NOT EXISTS `IDXS` (
- `INDEX_ID` bigint,
- `CREATE_TIME` int,
- `DEFERRED_REBUILD` boolean,
- `INDEX_HANDLER_CLASS` string,
- `INDEX_NAME` string,
- `INDEX_TBL_ID` bigint,
- `LAST_ACCESS_TIME` int,
- `ORIG_TBL_ID` bigint,
- `SD_ID` bigint,
- CONSTRAINT `SYS_PK_IDXS` PRIMARY KEY (`INDEX_ID`) DISABLE
-)
-STORED BY 'org.apache.hive.storage.jdbc.JdbcStorageHandler'
-TBLPROPERTIES (
-"hive.sql.database.type" = "METASTORE",
-"hive.sql.query" =
-"SELECT
- \"INDEX_ID\",
- \"CREATE_TIME\",
- \"DEFERRED_REBUILD\",
- \"INDEX_HANDLER_CLASS\",
- \"INDEX_NAME\",
- \"INDEX_TBL_ID\",
- \"LAST_ACCESS_TIME\",
- \"ORIG_TBL_ID\",
- \"SD_ID\"
-FROM
- \"IDXS\""
-)
-POSTHOOK: type: CREATETABLE
-POSTHOOK: Output: SYS@IDXS
-POSTHOOK: Output: database:sys
-PREHOOK: query: CREATE TABLE IF NOT EXISTS `INDEX_PARAMS` (
- `INDEX_ID` bigint,
- `PARAM_KEY` string,
- `PARAM_VALUE` string,
- CONSTRAINT `SYS_PK_INDEX_PARAMS` PRIMARY KEY (`INDEX_ID`,`PARAM_KEY`) DISABLE
-)
-STORED BY 'org.apache.hive.storage.jdbc.JdbcStorageHandler'
-TBLPROPERTIES (
-"hive.sql.database.type" = "METASTORE",
-"hive.sql.query" =
-"SELECT
- \"INDEX_ID\",
- \"PARAM_KEY\",
- \"PARAM_VALUE\"
-FROM
- \"INDEX_PARAMS\""
-)
-PREHOOK: type: CREATETABLE
-PREHOOK: Output: SYS@INDEX_PARAMS
-PREHOOK: Output: database:sys
-POSTHOOK: query: CREATE TABLE IF NOT EXISTS `INDEX_PARAMS` (
- `INDEX_ID` bigint,
- `PARAM_KEY` string,
- `PARAM_VALUE` string,
- CONSTRAINT `SYS_PK_INDEX_PARAMS` PRIMARY KEY (`INDEX_ID`,`PARAM_KEY`) DISABLE
-)
-STORED BY 'org.apache.hive.storage.jdbc.JdbcStorageHandler'
-TBLPROPERTIES (
-"hive.sql.database.type" = "METASTORE",
-"hive.sql.query" =
-"SELECT
- \"INDEX_ID\",
- \"PARAM_KEY\",
- \"PARAM_VALUE\"
-FROM
- \"INDEX_PARAMS\""
-)
-POSTHOOK: type: CREATETABLE
-POSTHOOK: Output: SYS@INDEX_PARAMS
-POSTHOOK: Output: database:sys
PREHOOK: query: CREATE TABLE IF NOT EXISTS `PARTITIONS` (
`PART_ID` bigint,
`CREATE_TIME` int,
@@ -2133,6 +2029,7 @@ PREHOOK: query: CREATE TABLE IF NOT EXISTS `KEY_CONSTRAINTS`
`UPDATE_RULE` string,
`DELETE_RULE` string,
`ENABLE_VALIDATE_RELY` int,
+ `DEFAULT_VALUE` string,
CONSTRAINT `SYS_PK_KEY_CONSTRAINTS` PRIMARY KEY (`CONSTRAINT_NAME`, `POSITION`) DISABLE
)
STORED BY 'org.apache.hive.storage.jdbc.JdbcStorageHandler'
@@ -2151,7 +2048,8 @@ TBLPROPERTIES (
\"CONSTRAINT_TYPE\",
\"UPDATE_RULE\",
\"DELETE_RULE\",
- \"ENABLE_VALIDATE_RELY\"
+ \"ENABLE_VALIDATE_RELY\",
+ \"DEFAULT_VALUE\"
FROM
\"KEY_CONSTRAINTS\""
)
@@ -2172,6 +2070,7 @@ POSTHOOK: query: CREATE TABLE IF NOT EXISTS `KEY_CONSTRAINTS`
`UPDATE_RULE` string,
`DELETE_RULE` string,
`ENABLE_VALIDATE_RELY` int,
+ `DEFAULT_VALUE` string,
CONSTRAINT `SYS_PK_KEY_CONSTRAINTS` PRIMARY KEY (`CONSTRAINT_NAME`, `POSITION`) DISABLE
)
STORED BY 'org.apache.hive.storage.jdbc.JdbcStorageHandler'
@@ -2190,7 +2089,8 @@ TBLPROPERTIES (
\"CONSTRAINT_TYPE\",
\"UPDATE_RULE\",
\"DELETE_RULE\",
- \"ENABLE_VALIDATE_RELY\"
+ \"ENABLE_VALIDATE_RELY\",
+ \"DEFAULT_VALUE\"
FROM
\"KEY_CONSTRAINTS\""
)
@@ -3303,7 +3203,7 @@ POSTHOOK: query: select count(*) from cds
POSTHOOK: type: QUERY
POSTHOOK: Input: sys@cds
#### A masked pattern was here ####
-73
+71
PREHOOK: query: select column_name, type_name, integer_idx from columns_v2 order by column_name, integer_idx limit 5
PREHOOK: type: QUERY
PREHOOK: Input: sys@columns_v2
@@ -3348,22 +3248,6 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: sys@global_privs
#### A masked pattern was here ####
admin admin
-PREHOOK: query: select index_name, index_handler_class from idxs order by index_name limit 5
-PREHOOK: type: QUERY
-PREHOOK: Input: sys@idxs
-#### A masked pattern was here ####
-POSTHOOK: query: select index_name, index_handler_class from idxs order by index_name limit 5
-POSTHOOK: type: QUERY
-POSTHOOK: Input: sys@idxs
-#### A masked pattern was here ####
-PREHOOK: query: select param_key, param_value from index_params order by param_key, param_value limit 5
-PREHOOK: type: QUERY
-PREHOOK: Input: sys@index_params
-#### A masked pattern was here ####
-POSTHOOK: query: select param_key, param_value from index_params order by param_key, param_value limit 5
-POSTHOOK: type: QUERY
-POSTHOOK: Input: sys@index_params
-#### A masked pattern was here ####
PREHOOK: query: select part_name from partitions order by part_name limit 5
PREHOOK: type: QUERY
PREHOOK: Input: sys@partitions
@@ -3457,7 +3341,7 @@ POSTHOOK: query: select count(*) from sds
POSTHOOK: type: QUERY
POSTHOOK: Input: sys@sds
#### A masked pattern was here ####
-79
+77
PREHOOK: query: select param_key, param_value from sd_params order by param_key, param_value limit 5
PREHOOK: type: QUERY
PREHOOK: Input: sys@sd_params
@@ -3474,11 +3358,11 @@ POSTHOOK: query: select sequence_name from sequence_table order by sequence_name
POSTHOOK: type: QUERY
POSTHOOK: Input: sys@sequence_table
#### A masked pattern was here ####
+org.apache.hadoop.hive.metastore.model.MCatalog
org.apache.hadoop.hive.metastore.model.MColumnDescriptor
org.apache.hadoop.hive.metastore.model.MDatabase
org.apache.hadoop.hive.metastore.model.MFunction
org.apache.hadoop.hive.metastore.model.MGlobalPrivilege
-org.apache.hadoop.hive.metastore.model.MPartition
PREHOOK: query: select name, slib from serdes order by name, slib limit 5
PREHOOK: type: QUERY
PREHOOK: Input: sys@serdes
@@ -3683,8 +3567,8 @@ POSTHOOK: Input: sys@table_params
POSTHOOK: Input: sys@table_stats_view
#### A masked pattern was here ####
{"BASIC_STATS":"true","COLUMN_STATS":{"key":"true"}} 0 0 0 0
-{"BASIC_STATS":"true","COLUMN_STATS":{"alloc_fraction":"true","path":"true","query_parallelism":"true","rp_name":"true","scheduling_policy":"true"}} 0 0 0 0
-{"BASIC_STATS":"true","COLUMN_STATS":{"name":"true","serde_id":"true","slib":"true"}} 0 0 0 0
+{"BASIC_STATS":"true","COLUMN_STATS":{"entity_name":"true","entity_type":"true","ordering":"true","pool_path":"true","rp_name":"true"}} 0 0 0 0
+{"BASIC_STATS":"true","COLUMN_STATS":{"integer_idx":"true","sd_id":"true","skewed_col_name":"true"}} 0 0 0 0
#### A masked pattern was here ####
{"BASIC_STATS":"true","COLUMN_STATS":{"db_id":"true","param_key":"true","param_value":"true"}} 0 0 0 0
PREHOOK: query: select COLUMN_STATS_ACCURATE, NUM_FILES, NUM_ROWS, RAW_DATA_SIZE, TOTAL_SIZE FROM PARTITION_STATS_VIEW where COLUMN_STATS_ACCURATE is not null order by NUM_FILES, NUM_ROWS, RAW_DATA_SIZE limit 5
@@ -3858,8 +3742,6 @@ default sys db_version BASE_TABLE NULL NULL NULL NULL NULL YES NO NULL
default sys dbs BASE_TABLE NULL NULL NULL NULL NULL YES NO NULL
default sys funcs BASE_TABLE NULL NULL NULL NULL NULL YES NO NULL
default sys global_privs BASE_TABLE NULL NULL NULL NULL NULL YES NO NULL
-default sys idxs BASE_TABLE NULL NULL NULL NULL NULL YES NO NULL
-default sys index_params BASE_TABLE NULL NULL NULL NULL NULL YES NO NULL
default sys key_constraints BASE_TABLE NULL NULL NULL NULL NULL YES NO NULL
default sys mv_creation_metadata BASE_TABLE NULL NULL NULL NULL NULL YES NO NULL
default sys mv_tables_used BASE_TABLE NULL NULL NULL NULL NULL YES NO NULL