This is an automated email from the ASF dual-hosted git repository.
dengzh pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/hive.git
The following commit(s) were added to refs/heads/master by this push:
new 4d96bfe2a5b HIVE-28636: partition_explain_ddl.q is flaky (#5555)
4d96bfe2a5b is described below
commit 4d96bfe2a5b410ea2895ac3369056e79749bf81b
Author: okumin <[email protected]>
AuthorDate: Wed Nov 27 15:04:10 2024 +0900
HIVE-28636: partition_explain_ddl.q is flaky (#5555)
---
.../apache/hadoop/hive/ql/exec/DDLPlanUtils.java | 20 +-
.../apache/hadoop/hive/ql/exec/ExplainTask.java | 4 +-
.../queries/clientpositive/partition_explain_ddl.q | 1 -
.../llap/constraints_explain_ddl.q.out | 622 ++++++++++-----------
.../llap/explain_ddl_nested_part.q.out | 112 ++--
.../llap/partition_explain_ddl.q.out | 116 ++--
.../clientpositive/llap/views_explain_ddl.q.out | 12 +-
7 files changed, 443 insertions(+), 444 deletions(-)
diff --git a/ql/src/java/org/apache/hadoop/hive/ql/exec/DDLPlanUtils.java
b/ql/src/java/org/apache/hadoop/hive/ql/exec/DDLPlanUtils.java
index d3163bee95b..e64b2a99892 100644
--- a/ql/src/java/org/apache/hadoop/hive/ql/exec/DDLPlanUtils.java
+++ b/ql/src/java/org/apache/hadoop/hive/ql/exec/DDLPlanUtils.java
@@ -24,6 +24,7 @@ import static
org.apache.hadoop.hive.metastore.api.hive_metastoreConstants.CTAS_
import com.google.common.base.Joiner;
import com.google.common.collect.ImmutableSet;
import com.google.common.collect.Sets;
+import java.util.Comparator;
import org.apache.commons.lang3.StringUtils;
import org.apache.hadoop.hive.common.StatsSetupConst;
import org.apache.hadoop.hive.metastore.TableType;
@@ -589,8 +590,8 @@ public class DDLPlanUtils {
String ptName,
String dbName) {
List<String> alterTableStmt = new ArrayList<>();
- ColumnStatisticsObj[] columnStatisticsObj =
columnStatisticsObjList.toArray(new ColumnStatisticsObj[0]);
- for (ColumnStatisticsObj statisticsObj : columnStatisticsObj) {
+ final Comparator<ColumnStatisticsObj> colNameComparator =
Comparator.comparing(ColumnStatisticsObj::getColName);
+
columnStatisticsObjList.stream().sorted(colNameComparator).forEach(statisticsObj
-> {
alterTableStmt.add(getAlterTableStmtPartitionColStat(
statisticsObj.getStatsData(), statisticsObj.getColName(), tblName,
ptName, dbName));
String base64BitVectors = checkBitVectors(statisticsObj.getStatsData());
@@ -613,7 +614,7 @@ public class DDLPlanUtils {
command.add(BASE_64_VALUE, base64Histogram);
alterTableStmt.add(command.render());
}
- }
+ });
return alterTableStmt;
}
@@ -650,7 +651,7 @@ public class DDLPlanUtils {
public List<String> getDDLPlanForPartitionWithStats(Table table,
Map<String,
List<Partition>> tableToPartitionList
- ) throws MetaException, HiveException {
+ ) throws HiveException {
List<String> alterTableStmt = new ArrayList<String>();
String tableName = table.getTableName();
for (Partition pt : tableToPartitionList.get(tableName)) {
@@ -661,19 +662,18 @@ public class DDLPlanUtils {
List<String> partNames = new ArrayList<String>();
//TODO : Check if only Accessed Column Statistics Can be Retrieved From
the HMS.
List<String> columnNames = getTableColumnNames(table);
- tableToPartitionList.get(tableName).stream().forEach(p ->
partNames.add(p.getName()));
+ tableToPartitionList.get(tableName).forEach(p ->
partNames.add(p.getName()));
Map<String, List<ColumnStatisticsObj>> partitionColStats =
Hive.get().getPartitionColumnStatistics(databaseName,
tableName, partNames, columnNames,
true);
Map<String, String> partitionToActualName = new HashMap<>();
- tableToPartitionList.get(tableName).stream().forEach(p ->
partitionToActualName.put(p.getName(),
- getPartitionActualName(p)));
- for (String partitionName : partitionColStats.keySet()) {
+ tableToPartitionList.get(tableName).forEach(p ->
partitionToActualName.put(p.getName(), getPartitionActualName(p)));
+ partitionColStats.keySet().stream().sorted().forEach(partitionName ->
alterTableStmt.addAll(getAlterTableStmtPartitionStatsColsAll(partitionColStats.get(partitionName),
tableName, partitionToActualName.get(partitionName),
- databaseName));
- }
+ databaseName))
+ );
return alterTableStmt;
}
diff --git a/ql/src/java/org/apache/hadoop/hive/ql/exec/ExplainTask.java
b/ql/src/java/org/apache/hadoop/hive/ql/exec/ExplainTask.java
index ea6dff1becf..5baa5c09920 100644
--- a/ql/src/java/org/apache/hadoop/hive/ql/exec/ExplainTask.java
+++ b/ql/src/java/org/apache/hadoop/hive/ql/exec/ExplainTask.java
@@ -42,6 +42,7 @@ import java.util.Set;
import java.util.TreeMap;
import com.google.common.base.Joiner;
+import java.util.stream.Collectors;
import org.apache.commons.lang3.tuple.ImmutablePair;
import org.apache.hadoop.fs.Path;
import org.apache.hadoop.hive.common.jsonexplain.JsonParser;
@@ -515,11 +516,10 @@ public class ExplainTask extends Task<ExplainWork>
implements Serializable {
//process the databases
List<String> createDatabaseStmt =
ddlPlanUtils.getCreateDatabaseStmt(createDatabase);
//process the tables
- for (String tableName : tableMap.keySet()) {
+ for (String tableName :
tableMap.keySet().stream().sorted().collect(Collectors.toList())) {
Table table = tableMap.get(tableName);
if (table.isView()) {
createViewList.add(ddlPlanUtils.getCreateViewStmt(table));
- continue;
} else {
addCreateTableStatement(table, tableCreateStmt, ddlPlanUtils);
addPKandBasicStats(table, tableBasicDef, ddlPlanUtils);
diff --git a/ql/src/test/queries/clientpositive/partition_explain_ddl.q
b/ql/src/test/queries/clientpositive/partition_explain_ddl.q
index 38181128e5f..23a40d872d4 100644
--- a/ql/src/test/queries/clientpositive/partition_explain_ddl.q
+++ b/ql/src/test/queries/clientpositive/partition_explain_ddl.q
@@ -1,4 +1,3 @@
---! qt:disabled:HIVE-28640
set hive.cbo.enable = True;
set hive.vectorized.execution.enabled = True;
diff --git
a/ql/src/test/results/clientpositive/llap/constraints_explain_ddl.q.out
b/ql/src/test/results/clientpositive/llap/constraints_explain_ddl.q.out
index 6c01f90cdcb..7d28167c8fe 100644
--- a/ql/src/test/results/clientpositive/llap/constraints_explain_ddl.q.out
+++ b/ql/src/test/results/clientpositive/llap/constraints_explain_ddl.q.out
@@ -3638,6 +3638,36 @@ POSTHOOK: Input: default@customer
POSTHOOK: Input: default@store_sales
#### A masked pattern was here ####
+CREATE TABLE `default`.`customer`(
+ `c_customer_sk` int,
+ `c_customer_id` string,
+ `c_current_cdemo_sk` int,
+ `c_current_hdemo_sk` int,
+ `c_current_addr_sk` int,
+ `c_first_shipto_date_sk` int,
+ `c_first_sales_date_sk` int,
+ `c_salutation` string,
+ `c_first_name` string,
+ `c_last_name` string,
+ `c_preferred_cust_flag` string,
+ `c_birth_day` int,
+ `c_birth_month` int,
+ `c_birth_year` int,
+ `c_birth_country` string,
+ `c_login` string,
+ `c_email_address` string,
+ `c_last_review_date` string)
+ROW FORMAT SERDE
+ 'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'
+STORED AS INPUTFORMAT
+ 'org.apache.hadoop.mapred.TextInputFormat'
+OUTPUTFORMAT
+ 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'
+LOCATION
+#### A masked pattern was here ####
+TBLPROPERTIES (
+ 'bucketing_version'='2',
+#### A masked pattern was here ####
CREATE TABLE `default`.`store_sales`(
`ss_sold_date_sk` int,
`ss_sold_time_sk` int,
@@ -3673,43 +3703,13 @@ LOCATION
TBLPROPERTIES (
'bucketing_version'='2',
#### A masked pattern was here ####
-CREATE TABLE `default`.`customer`(
- `c_customer_sk` int,
- `c_customer_id` string,
- `c_current_cdemo_sk` int,
- `c_current_hdemo_sk` int,
- `c_current_addr_sk` int,
- `c_first_shipto_date_sk` int,
- `c_first_sales_date_sk` int,
- `c_salutation` string,
- `c_first_name` string,
- `c_last_name` string,
- `c_preferred_cust_flag` string,
- `c_birth_day` int,
- `c_birth_month` int,
- `c_birth_year` int,
- `c_birth_country` string,
- `c_login` string,
- `c_email_address` string,
- `c_last_review_date` string)
-ROW FORMAT SERDE
- 'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'
-STORED AS INPUTFORMAT
- 'org.apache.hadoop.mapred.TextInputFormat'
-OUTPUTFORMAT
- 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'
-LOCATION
-#### A masked pattern was here ####
-TBLPROPERTIES (
- 'bucketing_version'='2',
-#### A masked pattern was here ####
-ALTER TABLE `default`.`store_sales` ADD CONSTRAINT `pk_ss` PRIMARY KEY
(`ss_item_sk`,`ss_ticket_number`) DISABLE NOVALIDATE RELY;
-ALTER TABLE `default`.`store_sales` UPDATE STATISTICS
SET('numRows'='0','rawDataSize'='0' );
ALTER TABLE `default`.`customer` ADD CONSTRAINT `pk_c` PRIMARY KEY
(`c_customer_sk`) DISABLE NOVALIDATE RELY;
ALTER TABLE `default`.`customer` UPDATE STATISTICS
SET('numRows'='0','rawDataSize'='0' );
-ALTER TABLE `default`.`store_sales` ADD CONSTRAINT `ss_c` FOREIGN KEY
(`ss_customer_sk`) REFERENCES `default`.`customer`(`c_customer_sk`) DISABLE
NOVALIDATE RELY;
+ALTER TABLE `default`.`store_sales` ADD CONSTRAINT `pk_ss` PRIMARY KEY
(`ss_item_sk`,`ss_ticket_number`) DISABLE NOVALIDATE RELY;
+ALTER TABLE `default`.`store_sales` UPDATE STATISTICS
SET('numRows'='0','rawDataSize'='0' );
ALTER TABLE `default`.`customer` ADD CONSTRAINT `uk1` UNIQUE (`c_customer_id`)
DISABLE NOVALIDATE RELY;
ALTER TABLE `default`.`customer` CHANGE COLUMN `c_customer_id` `c_customer_id`
string CONSTRAINT `cid_nn` NOT NULL DISABLE NOVALIDATE RELY;
+ALTER TABLE `default`.`store_sales` ADD CONSTRAINT `ss_c` FOREIGN KEY
(`ss_customer_sk`) REFERENCES `default`.`customer`(`c_customer_sk`) DISABLE
NOVALIDATE RELY;
@@ -3922,6 +3922,36 @@ POSTHOOK: Input: default@customer
POSTHOOK: Input: default@store_sales
#### A masked pattern was here ####
+CREATE TABLE `default`.`customer`(
+ `c_customer_sk` int,
+ `c_customer_id` string,
+ `c_current_cdemo_sk` int,
+ `c_current_hdemo_sk` int,
+ `c_current_addr_sk` int,
+ `c_first_shipto_date_sk` int,
+ `c_first_sales_date_sk` int,
+ `c_salutation` string,
+ `c_first_name` string,
+ `c_last_name` string,
+ `c_preferred_cust_flag` string,
+ `c_birth_day` int,
+ `c_birth_month` int,
+ `c_birth_year` int,
+ `c_birth_country` string,
+ `c_login` string,
+ `c_email_address` string,
+ `c_last_review_date` string)
+ROW FORMAT SERDE
+ 'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'
+STORED AS INPUTFORMAT
+ 'org.apache.hadoop.mapred.TextInputFormat'
+OUTPUTFORMAT
+ 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'
+LOCATION
+#### A masked pattern was here ####
+TBLPROPERTIES (
+ 'bucketing_version'='2',
+#### A masked pattern was here ####
CREATE TABLE `default`.`store_sales`(
`ss_sold_date_sk` int,
`ss_sold_time_sk` int,
@@ -3957,43 +3987,13 @@ LOCATION
TBLPROPERTIES (
'bucketing_version'='2',
#### A masked pattern was here ####
-CREATE TABLE `default`.`customer`(
- `c_customer_sk` int,
- `c_customer_id` string,
- `c_current_cdemo_sk` int,
- `c_current_hdemo_sk` int,
- `c_current_addr_sk` int,
- `c_first_shipto_date_sk` int,
- `c_first_sales_date_sk` int,
- `c_salutation` string,
- `c_first_name` string,
- `c_last_name` string,
- `c_preferred_cust_flag` string,
- `c_birth_day` int,
- `c_birth_month` int,
- `c_birth_year` int,
- `c_birth_country` string,
- `c_login` string,
- `c_email_address` string,
- `c_last_review_date` string)
-ROW FORMAT SERDE
- 'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'
-STORED AS INPUTFORMAT
- 'org.apache.hadoop.mapred.TextInputFormat'
-OUTPUTFORMAT
- 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'
-LOCATION
-#### A masked pattern was here ####
-TBLPROPERTIES (
- 'bucketing_version'='2',
-#### A masked pattern was here ####
-ALTER TABLE `default`.`store_sales` ADD CONSTRAINT `pk_ss` PRIMARY KEY
(`ss_item_sk`,`ss_ticket_number`) DISABLE NOVALIDATE RELY;
-ALTER TABLE `default`.`store_sales` UPDATE STATISTICS
SET('numRows'='0','rawDataSize'='0' );
ALTER TABLE `default`.`customer` ADD CONSTRAINT `pk_c` PRIMARY KEY
(`c_customer_sk`) DISABLE NOVALIDATE RELY;
ALTER TABLE `default`.`customer` UPDATE STATISTICS
SET('numRows'='0','rawDataSize'='0' );
-ALTER TABLE `default`.`store_sales` ADD CONSTRAINT `ss_c` FOREIGN KEY
(`ss_customer_sk`) REFERENCES `default`.`customer`(`c_customer_sk`) DISABLE
NOVALIDATE RELY;
+ALTER TABLE `default`.`store_sales` ADD CONSTRAINT `pk_ss` PRIMARY KEY
(`ss_item_sk`,`ss_ticket_number`) DISABLE NOVALIDATE RELY;
+ALTER TABLE `default`.`store_sales` UPDATE STATISTICS
SET('numRows'='0','rawDataSize'='0' );
ALTER TABLE `default`.`customer` ADD CONSTRAINT `uk1` UNIQUE (`c_customer_id`)
DISABLE NOVALIDATE RELY;
ALTER TABLE `default`.`customer` CHANGE COLUMN `c_customer_id` `c_customer_id`
string CONSTRAINT `cid_nn` NOT NULL DISABLE NOVALIDATE RELY;
+ALTER TABLE `default`.`store_sales` ADD CONSTRAINT `ss_c` FOREIGN KEY
(`ss_customer_sk`) REFERENCES `default`.`customer`(`c_customer_sk`) DISABLE
NOVALIDATE RELY;
@@ -4236,6 +4236,36 @@ POSTHOOK: Input: default@customer
POSTHOOK: Input: default@store_sales
#### A masked pattern was here ####
+CREATE TABLE `default`.`customer`(
+ `c_customer_sk` int,
+ `c_customer_id` string,
+ `c_current_cdemo_sk` int,
+ `c_current_hdemo_sk` int,
+ `c_current_addr_sk` int,
+ `c_first_shipto_date_sk` int,
+ `c_first_sales_date_sk` int,
+ `c_salutation` string,
+ `c_first_name` string,
+ `c_last_name` string,
+ `c_preferred_cust_flag` string,
+ `c_birth_day` int,
+ `c_birth_month` int,
+ `c_birth_year` int,
+ `c_birth_country` string,
+ `c_login` string,
+ `c_email_address` string,
+ `c_last_review_date` string)
+ROW FORMAT SERDE
+ 'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'
+STORED AS INPUTFORMAT
+ 'org.apache.hadoop.mapred.TextInputFormat'
+OUTPUTFORMAT
+ 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'
+LOCATION
+#### A masked pattern was here ####
+TBLPROPERTIES (
+ 'bucketing_version'='2',
+#### A masked pattern was here ####
CREATE TABLE `default`.`store_sales`(
`ss_sold_date_sk` int,
`ss_sold_time_sk` int,
@@ -4271,43 +4301,13 @@ LOCATION
TBLPROPERTIES (
'bucketing_version'='2',
#### A masked pattern was here ####
-CREATE TABLE `default`.`customer`(
- `c_customer_sk` int,
- `c_customer_id` string,
- `c_current_cdemo_sk` int,
- `c_current_hdemo_sk` int,
- `c_current_addr_sk` int,
- `c_first_shipto_date_sk` int,
- `c_first_sales_date_sk` int,
- `c_salutation` string,
- `c_first_name` string,
- `c_last_name` string,
- `c_preferred_cust_flag` string,
- `c_birth_day` int,
- `c_birth_month` int,
- `c_birth_year` int,
- `c_birth_country` string,
- `c_login` string,
- `c_email_address` string,
- `c_last_review_date` string)
-ROW FORMAT SERDE
- 'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'
-STORED AS INPUTFORMAT
- 'org.apache.hadoop.mapred.TextInputFormat'
-OUTPUTFORMAT
- 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'
-LOCATION
-#### A masked pattern was here ####
-TBLPROPERTIES (
- 'bucketing_version'='2',
-#### A masked pattern was here ####
-ALTER TABLE `default`.`store_sales` ADD CONSTRAINT `pk_ss` PRIMARY KEY
(`ss_item_sk`,`ss_ticket_number`) DISABLE NOVALIDATE RELY;
-ALTER TABLE `default`.`store_sales` UPDATE STATISTICS
SET('numRows'='0','rawDataSize'='0' );
ALTER TABLE `default`.`customer` ADD CONSTRAINT `pk_c` PRIMARY KEY
(`c_customer_sk`) DISABLE NOVALIDATE RELY;
ALTER TABLE `default`.`customer` UPDATE STATISTICS
SET('numRows'='0','rawDataSize'='0' );
-ALTER TABLE `default`.`store_sales` ADD CONSTRAINT `ss_c` FOREIGN KEY
(`ss_customer_sk`) REFERENCES `default`.`customer`(`c_customer_sk`) DISABLE
NOVALIDATE RELY;
+ALTER TABLE `default`.`store_sales` ADD CONSTRAINT `pk_ss` PRIMARY KEY
(`ss_item_sk`,`ss_ticket_number`) DISABLE NOVALIDATE RELY;
+ALTER TABLE `default`.`store_sales` UPDATE STATISTICS
SET('numRows'='0','rawDataSize'='0' );
ALTER TABLE `default`.`customer` ADD CONSTRAINT `uk1` UNIQUE (`c_customer_id`)
DISABLE NOVALIDATE RELY;
ALTER TABLE `default`.`customer` CHANGE COLUMN `c_customer_id` `c_customer_id`
string CONSTRAINT `cid_nn` NOT NULL DISABLE NOVALIDATE RELY;
+ALTER TABLE `default`.`store_sales` ADD CONSTRAINT `ss_c` FOREIGN KEY
(`ss_customer_sk`) REFERENCES `default`.`customer`(`c_customer_sk`) DISABLE
NOVALIDATE RELY;
@@ -4631,6 +4631,36 @@ POSTHOOK: Input: default@customer
POSTHOOK: Input: default@store_sales
#### A masked pattern was here ####
+CREATE TABLE `default`.`customer`(
+ `c_customer_sk` int,
+ `c_customer_id` string,
+ `c_current_cdemo_sk` int,
+ `c_current_hdemo_sk` int,
+ `c_current_addr_sk` int,
+ `c_first_shipto_date_sk` int,
+ `c_first_sales_date_sk` int,
+ `c_salutation` string,
+ `c_first_name` string,
+ `c_last_name` string,
+ `c_preferred_cust_flag` string,
+ `c_birth_day` int,
+ `c_birth_month` int,
+ `c_birth_year` int,
+ `c_birth_country` string,
+ `c_login` string,
+ `c_email_address` string,
+ `c_last_review_date` string)
+ROW FORMAT SERDE
+ 'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'
+STORED AS INPUTFORMAT
+ 'org.apache.hadoop.mapred.TextInputFormat'
+OUTPUTFORMAT
+ 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'
+LOCATION
+#### A masked pattern was here ####
+TBLPROPERTIES (
+ 'bucketing_version'='2',
+#### A masked pattern was here ####
CREATE TABLE `default`.`store_sales`(
`ss_sold_date_sk` int,
`ss_sold_time_sk` int,
@@ -4666,43 +4696,13 @@ LOCATION
TBLPROPERTIES (
'bucketing_version'='2',
#### A masked pattern was here ####
-CREATE TABLE `default`.`customer`(
- `c_customer_sk` int,
- `c_customer_id` string,
- `c_current_cdemo_sk` int,
- `c_current_hdemo_sk` int,
- `c_current_addr_sk` int,
- `c_first_shipto_date_sk` int,
- `c_first_sales_date_sk` int,
- `c_salutation` string,
- `c_first_name` string,
- `c_last_name` string,
- `c_preferred_cust_flag` string,
- `c_birth_day` int,
- `c_birth_month` int,
- `c_birth_year` int,
- `c_birth_country` string,
- `c_login` string,
- `c_email_address` string,
- `c_last_review_date` string)
-ROW FORMAT SERDE
- 'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'
-STORED AS INPUTFORMAT
- 'org.apache.hadoop.mapred.TextInputFormat'
-OUTPUTFORMAT
- 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'
-LOCATION
-#### A masked pattern was here ####
-TBLPROPERTIES (
- 'bucketing_version'='2',
-#### A masked pattern was here ####
-ALTER TABLE `default`.`store_sales` ADD CONSTRAINT `pk_ss` PRIMARY KEY
(`ss_item_sk`,`ss_ticket_number`) DISABLE NOVALIDATE RELY;
-ALTER TABLE `default`.`store_sales` UPDATE STATISTICS
SET('numRows'='0','rawDataSize'='0' );
ALTER TABLE `default`.`customer` ADD CONSTRAINT `pk_c` PRIMARY KEY
(`c_customer_sk`) DISABLE NOVALIDATE RELY;
ALTER TABLE `default`.`customer` UPDATE STATISTICS
SET('numRows'='0','rawDataSize'='0' );
-ALTER TABLE `default`.`store_sales` ADD CONSTRAINT `ss_c` FOREIGN KEY
(`ss_customer_sk`) REFERENCES `default`.`customer`(`c_customer_sk`) DISABLE
NOVALIDATE RELY;
+ALTER TABLE `default`.`store_sales` ADD CONSTRAINT `pk_ss` PRIMARY KEY
(`ss_item_sk`,`ss_ticket_number`) DISABLE NOVALIDATE RELY;
+ALTER TABLE `default`.`store_sales` UPDATE STATISTICS
SET('numRows'='0','rawDataSize'='0' );
ALTER TABLE `default`.`customer` ADD CONSTRAINT `uk1` UNIQUE (`c_customer_id`)
DISABLE NOVALIDATE RELY;
ALTER TABLE `default`.`customer` CHANGE COLUMN `c_customer_id` `c_customer_id`
string CONSTRAINT `cid_nn` NOT NULL DISABLE NOVALIDATE RELY;
+ALTER TABLE `default`.`store_sales` ADD CONSTRAINT `ss_c` FOREIGN KEY
(`ss_customer_sk`) REFERENCES `default`.`customer`(`c_customer_sk`) DISABLE
NOVALIDATE RELY;
@@ -5113,30 +5113,25 @@ POSTHOOK: Input: default@date_dim
POSTHOOK: Input: default@store_sales
#### A masked pattern was here ####
-CREATE TABLE `default`.`store_sales`(
- `ss_sold_date_sk` int,
- `ss_sold_time_sk` int,
- `ss_item_sk` int,
- `ss_customer_sk` int,
- `ss_cdemo_sk` int,
- `ss_hdemo_sk` int,
- `ss_addr_sk` int,
- `ss_store_sk` int,
- `ss_promo_sk` int,
- `ss_ticket_number` int,
- `ss_quantity` int,
- `ss_wholesale_cost` decimal(7,2),
- `ss_list_price` decimal(7,2),
- `ss_sales_price` decimal(7,2),
- `ss_ext_discount_amt` decimal(7,2),
- `ss_ext_sales_price` decimal(7,2),
- `ss_ext_wholesale_cost` decimal(7,2),
- `ss_ext_list_price` decimal(7,2),
- `ss_ext_tax` decimal(7,2),
- `ss_coupon_amt` decimal(7,2),
- `ss_net_paid` decimal(7,2),
- `ss_net_paid_inc_tax` decimal(7,2),
- `ss_net_profit` decimal(7,2))
+CREATE TABLE `default`.`customer`(
+ `c_customer_sk` int,
+ `c_customer_id` string,
+ `c_current_cdemo_sk` int,
+ `c_current_hdemo_sk` int,
+ `c_current_addr_sk` int,
+ `c_first_shipto_date_sk` int,
+ `c_first_sales_date_sk` int,
+ `c_salutation` string,
+ `c_first_name` string,
+ `c_last_name` string,
+ `c_preferred_cust_flag` string,
+ `c_birth_day` int,
+ `c_birth_month` int,
+ `c_birth_year` int,
+ `c_birth_country` string,
+ `c_login` string,
+ `c_email_address` string,
+ `c_last_review_date` string)
ROW FORMAT SERDE
'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'
STORED AS INPUTFORMAT
@@ -5188,25 +5183,30 @@ LOCATION
TBLPROPERTIES (
'bucketing_version'='2',
#### A masked pattern was here ####
-CREATE TABLE `default`.`customer`(
- `c_customer_sk` int,
- `c_customer_id` string,
- `c_current_cdemo_sk` int,
- `c_current_hdemo_sk` int,
- `c_current_addr_sk` int,
- `c_first_shipto_date_sk` int,
- `c_first_sales_date_sk` int,
- `c_salutation` string,
- `c_first_name` string,
- `c_last_name` string,
- `c_preferred_cust_flag` string,
- `c_birth_day` int,
- `c_birth_month` int,
- `c_birth_year` int,
- `c_birth_country` string,
- `c_login` string,
- `c_email_address` string,
- `c_last_review_date` string)
+CREATE TABLE `default`.`store_sales`(
+ `ss_sold_date_sk` int,
+ `ss_sold_time_sk` int,
+ `ss_item_sk` int,
+ `ss_customer_sk` int,
+ `ss_cdemo_sk` int,
+ `ss_hdemo_sk` int,
+ `ss_addr_sk` int,
+ `ss_store_sk` int,
+ `ss_promo_sk` int,
+ `ss_ticket_number` int,
+ `ss_quantity` int,
+ `ss_wholesale_cost` decimal(7,2),
+ `ss_list_price` decimal(7,2),
+ `ss_sales_price` decimal(7,2),
+ `ss_ext_discount_amt` decimal(7,2),
+ `ss_ext_sales_price` decimal(7,2),
+ `ss_ext_wholesale_cost` decimal(7,2),
+ `ss_ext_list_price` decimal(7,2),
+ `ss_ext_tax` decimal(7,2),
+ `ss_coupon_amt` decimal(7,2),
+ `ss_net_paid` decimal(7,2),
+ `ss_net_paid_inc_tax` decimal(7,2),
+ `ss_net_profit` decimal(7,2))
ROW FORMAT SERDE
'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'
STORED AS INPUTFORMAT
@@ -5218,14 +5218,14 @@ LOCATION
TBLPROPERTIES (
'bucketing_version'='2',
#### A masked pattern was here ####
-ALTER TABLE `default`.`store_sales` ADD CONSTRAINT `pk_ss` PRIMARY KEY
(`ss_item_sk`,`ss_ticket_number`) DISABLE NOVALIDATE RELY;
-ALTER TABLE `default`.`store_sales` UPDATE STATISTICS
SET('numRows'='0','rawDataSize'='0' );
-ALTER TABLE `default`.`date_dim` UPDATE STATISTICS
SET('numRows'='0','rawDataSize'='0' );
ALTER TABLE `default`.`customer` ADD CONSTRAINT `pk_c` PRIMARY KEY
(`c_customer_sk`) DISABLE NOVALIDATE RELY;
ALTER TABLE `default`.`customer` UPDATE STATISTICS
SET('numRows'='0','rawDataSize'='0' );
-ALTER TABLE `default`.`store_sales` ADD CONSTRAINT `ss_c` FOREIGN KEY
(`ss_customer_sk`) REFERENCES `default`.`customer`(`c_customer_sk`) DISABLE
NOVALIDATE RELY;
+ALTER TABLE `default`.`date_dim` UPDATE STATISTICS
SET('numRows'='0','rawDataSize'='0' );
+ALTER TABLE `default`.`store_sales` ADD CONSTRAINT `pk_ss` PRIMARY KEY
(`ss_item_sk`,`ss_ticket_number`) DISABLE NOVALIDATE RELY;
+ALTER TABLE `default`.`store_sales` UPDATE STATISTICS
SET('numRows'='0','rawDataSize'='0' );
ALTER TABLE `default`.`customer` ADD CONSTRAINT `uk1` UNIQUE (`c_customer_id`)
DISABLE NOVALIDATE RELY;
ALTER TABLE `default`.`customer` CHANGE COLUMN `c_customer_id` `c_customer_id`
string CONSTRAINT `cid_nn` NOT NULL DISABLE NOVALIDATE RELY;
+ALTER TABLE `default`.`store_sales` ADD CONSTRAINT `ss_c` FOREIGN KEY
(`ss_customer_sk`) REFERENCES `default`.`customer`(`c_customer_sk`) DISABLE
NOVALIDATE RELY;
@@ -5765,6 +5765,36 @@ POSTHOOK: Input: default@customer
POSTHOOK: Input: default@store_sales
#### A masked pattern was here ####
+CREATE TABLE `default`.`customer`(
+ `c_customer_sk` int,
+ `c_customer_id` string,
+ `c_current_cdemo_sk` int,
+ `c_current_hdemo_sk` int,
+ `c_current_addr_sk` int,
+ `c_first_shipto_date_sk` int,
+ `c_first_sales_date_sk` int,
+ `c_salutation` string,
+ `c_first_name` string,
+ `c_last_name` string,
+ `c_preferred_cust_flag` string,
+ `c_birth_day` int,
+ `c_birth_month` int,
+ `c_birth_year` int,
+ `c_birth_country` string,
+ `c_login` string,
+ `c_email_address` string,
+ `c_last_review_date` string)
+ROW FORMAT SERDE
+ 'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'
+STORED AS INPUTFORMAT
+ 'org.apache.hadoop.mapred.TextInputFormat'
+OUTPUTFORMAT
+ 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'
+LOCATION
+#### A masked pattern was here ####
+TBLPROPERTIES (
+ 'bucketing_version'='2',
+#### A masked pattern was here ####
CREATE TABLE `default`.`store_sales`(
`ss_sold_date_sk` int,
`ss_sold_time_sk` int,
@@ -5800,43 +5830,13 @@ LOCATION
TBLPROPERTIES (
'bucketing_version'='2',
#### A masked pattern was here ####
-CREATE TABLE `default`.`customer`(
- `c_customer_sk` int,
- `c_customer_id` string,
- `c_current_cdemo_sk` int,
- `c_current_hdemo_sk` int,
- `c_current_addr_sk` int,
- `c_first_shipto_date_sk` int,
- `c_first_sales_date_sk` int,
- `c_salutation` string,
- `c_first_name` string,
- `c_last_name` string,
- `c_preferred_cust_flag` string,
- `c_birth_day` int,
- `c_birth_month` int,
- `c_birth_year` int,
- `c_birth_country` string,
- `c_login` string,
- `c_email_address` string,
- `c_last_review_date` string)
-ROW FORMAT SERDE
- 'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'
-STORED AS INPUTFORMAT
- 'org.apache.hadoop.mapred.TextInputFormat'
-OUTPUTFORMAT
- 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'
-LOCATION
-#### A masked pattern was here ####
-TBLPROPERTIES (
- 'bucketing_version'='2',
-#### A masked pattern was here ####
-ALTER TABLE `default`.`store_sales` ADD CONSTRAINT `pk_ss` PRIMARY KEY
(`ss_item_sk`,`ss_ticket_number`) DISABLE NOVALIDATE RELY;
-ALTER TABLE `default`.`store_sales` UPDATE STATISTICS
SET('numRows'='0','rawDataSize'='0' );
ALTER TABLE `default`.`customer` ADD CONSTRAINT `pk_c` PRIMARY KEY
(`c_customer_sk`) DISABLE NOVALIDATE RELY;
ALTER TABLE `default`.`customer` UPDATE STATISTICS
SET('numRows'='0','rawDataSize'='0' );
-ALTER TABLE `default`.`store_sales` ADD CONSTRAINT `ss_c` FOREIGN KEY
(`ss_customer_sk`) REFERENCES `default`.`customer`(`c_customer_sk`) DISABLE
NOVALIDATE RELY;
+ALTER TABLE `default`.`store_sales` ADD CONSTRAINT `pk_ss` PRIMARY KEY
(`ss_item_sk`,`ss_ticket_number`) DISABLE NOVALIDATE RELY;
+ALTER TABLE `default`.`store_sales` UPDATE STATISTICS
SET('numRows'='0','rawDataSize'='0' );
ALTER TABLE `default`.`customer` ADD CONSTRAINT `uk1` UNIQUE (`c_customer_id`)
DISABLE NOVALIDATE RELY;
ALTER TABLE `default`.`customer` CHANGE COLUMN `c_customer_id` `c_customer_id`
string CONSTRAINT `cid_nn` NOT NULL DISABLE NOVALIDATE RELY;
+ALTER TABLE `default`.`store_sales` ADD CONSTRAINT `ss_c` FOREIGN KEY
(`ss_customer_sk`) REFERENCES `default`.`customer`(`c_customer_sk`) DISABLE
NOVALIDATE RELY;
@@ -6057,6 +6057,36 @@ POSTHOOK: Input: default@customer
POSTHOOK: Input: default@store_sales
#### A masked pattern was here ####
+CREATE TABLE `default`.`customer`(
+ `c_customer_sk` int,
+ `c_customer_id` string,
+ `c_current_cdemo_sk` int,
+ `c_current_hdemo_sk` int,
+ `c_current_addr_sk` int,
+ `c_first_shipto_date_sk` int,
+ `c_first_sales_date_sk` int,
+ `c_salutation` string,
+ `c_first_name` string,
+ `c_last_name` string,
+ `c_preferred_cust_flag` string,
+ `c_birth_day` int,
+ `c_birth_month` int,
+ `c_birth_year` int,
+ `c_birth_country` string,
+ `c_login` string,
+ `c_email_address` string,
+ `c_last_review_date` string)
+ROW FORMAT SERDE
+ 'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'
+STORED AS INPUTFORMAT
+ 'org.apache.hadoop.mapred.TextInputFormat'
+OUTPUTFORMAT
+ 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'
+LOCATION
+#### A masked pattern was here ####
+TBLPROPERTIES (
+ 'bucketing_version'='2',
+#### A masked pattern was here ####
CREATE TABLE `default`.`store_sales`(
`ss_sold_date_sk` int,
`ss_sold_time_sk` int,
@@ -6092,43 +6122,13 @@ LOCATION
TBLPROPERTIES (
'bucketing_version'='2',
#### A masked pattern was here ####
-CREATE TABLE `default`.`customer`(
- `c_customer_sk` int,
- `c_customer_id` string,
- `c_current_cdemo_sk` int,
- `c_current_hdemo_sk` int,
- `c_current_addr_sk` int,
- `c_first_shipto_date_sk` int,
- `c_first_sales_date_sk` int,
- `c_salutation` string,
- `c_first_name` string,
- `c_last_name` string,
- `c_preferred_cust_flag` string,
- `c_birth_day` int,
- `c_birth_month` int,
- `c_birth_year` int,
- `c_birth_country` string,
- `c_login` string,
- `c_email_address` string,
- `c_last_review_date` string)
-ROW FORMAT SERDE
- 'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'
-STORED AS INPUTFORMAT
- 'org.apache.hadoop.mapred.TextInputFormat'
-OUTPUTFORMAT
- 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'
-LOCATION
-#### A masked pattern was here ####
-TBLPROPERTIES (
- 'bucketing_version'='2',
-#### A masked pattern was here ####
-ALTER TABLE `default`.`store_sales` ADD CONSTRAINT `pk_ss` PRIMARY KEY
(`ss_item_sk`,`ss_ticket_number`) DISABLE NOVALIDATE RELY;
-ALTER TABLE `default`.`store_sales` UPDATE STATISTICS
SET('numRows'='0','rawDataSize'='0' );
ALTER TABLE `default`.`customer` ADD CONSTRAINT `pk_c` PRIMARY KEY
(`c_customer_sk`) DISABLE NOVALIDATE RELY;
ALTER TABLE `default`.`customer` UPDATE STATISTICS
SET('numRows'='0','rawDataSize'='0' );
-ALTER TABLE `default`.`store_sales` ADD CONSTRAINT `ss_c` FOREIGN KEY
(`ss_customer_sk`) REFERENCES `default`.`customer`(`c_customer_sk`) DISABLE
NOVALIDATE RELY;
+ALTER TABLE `default`.`store_sales` ADD CONSTRAINT `pk_ss` PRIMARY KEY
(`ss_item_sk`,`ss_ticket_number`) DISABLE NOVALIDATE RELY;
+ALTER TABLE `default`.`store_sales` UPDATE STATISTICS
SET('numRows'='0','rawDataSize'='0' );
ALTER TABLE `default`.`customer` ADD CONSTRAINT `uk1` UNIQUE (`c_customer_id`)
DISABLE NOVALIDATE RELY;
ALTER TABLE `default`.`customer` CHANGE COLUMN `c_customer_id` `c_customer_id`
string CONSTRAINT `cid_nn` NOT NULL DISABLE NOVALIDATE RELY;
+ALTER TABLE `default`.`store_sales` ADD CONSTRAINT `ss_c` FOREIGN KEY
(`ss_customer_sk`) REFERENCES `default`.`customer`(`c_customer_sk`) DISABLE
NOVALIDATE RELY;
@@ -6384,6 +6384,36 @@ POSTHOOK: Input: default@customer
POSTHOOK: Input: default@store_sales
#### A masked pattern was here ####
+CREATE TABLE `default`.`customer`(
+ `c_customer_sk` int,
+ `c_customer_id` string,
+ `c_current_cdemo_sk` int,
+ `c_current_hdemo_sk` int,
+ `c_current_addr_sk` int,
+ `c_first_shipto_date_sk` int,
+ `c_first_sales_date_sk` int,
+ `c_salutation` string,
+ `c_first_name` string,
+ `c_last_name` string,
+ `c_preferred_cust_flag` string,
+ `c_birth_day` int,
+ `c_birth_month` int,
+ `c_birth_year` int,
+ `c_birth_country` string,
+ `c_login` string,
+ `c_email_address` string,
+ `c_last_review_date` string)
+ROW FORMAT SERDE
+ 'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'
+STORED AS INPUTFORMAT
+ 'org.apache.hadoop.mapred.TextInputFormat'
+OUTPUTFORMAT
+ 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'
+LOCATION
+#### A masked pattern was here ####
+TBLPROPERTIES (
+ 'bucketing_version'='2',
+#### A masked pattern was here ####
CREATE TABLE `default`.`store_sales`(
`ss_sold_date_sk` int,
`ss_sold_time_sk` int,
@@ -6419,43 +6449,13 @@ LOCATION
TBLPROPERTIES (
'bucketing_version'='2',
#### A masked pattern was here ####
-CREATE TABLE `default`.`customer`(
- `c_customer_sk` int,
- `c_customer_id` string,
- `c_current_cdemo_sk` int,
- `c_current_hdemo_sk` int,
- `c_current_addr_sk` int,
- `c_first_shipto_date_sk` int,
- `c_first_sales_date_sk` int,
- `c_salutation` string,
- `c_first_name` string,
- `c_last_name` string,
- `c_preferred_cust_flag` string,
- `c_birth_day` int,
- `c_birth_month` int,
- `c_birth_year` int,
- `c_birth_country` string,
- `c_login` string,
- `c_email_address` string,
- `c_last_review_date` string)
-ROW FORMAT SERDE
- 'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'
-STORED AS INPUTFORMAT
- 'org.apache.hadoop.mapred.TextInputFormat'
-OUTPUTFORMAT
- 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'
-LOCATION
-#### A masked pattern was here ####
-TBLPROPERTIES (
- 'bucketing_version'='2',
-#### A masked pattern was here ####
-ALTER TABLE `default`.`store_sales` ADD CONSTRAINT `pk_ss` PRIMARY KEY
(`ss_item_sk`,`ss_ticket_number`) DISABLE NOVALIDATE RELY;
-ALTER TABLE `default`.`store_sales` UPDATE STATISTICS
SET('numRows'='0','rawDataSize'='0' );
ALTER TABLE `default`.`customer` ADD CONSTRAINT `pk_c` PRIMARY KEY
(`c_customer_sk`) DISABLE NOVALIDATE RELY;
ALTER TABLE `default`.`customer` UPDATE STATISTICS
SET('numRows'='0','rawDataSize'='0' );
-ALTER TABLE `default`.`store_sales` ADD CONSTRAINT `ss_c` FOREIGN KEY
(`ss_customer_sk`) REFERENCES `default`.`customer`(`c_customer_sk`) DISABLE
NOVALIDATE RELY;
+ALTER TABLE `default`.`store_sales` ADD CONSTRAINT `pk_ss` PRIMARY KEY
(`ss_item_sk`,`ss_ticket_number`) DISABLE NOVALIDATE RELY;
+ALTER TABLE `default`.`store_sales` UPDATE STATISTICS
SET('numRows'='0','rawDataSize'='0' );
ALTER TABLE `default`.`customer` ADD CONSTRAINT `uk1` UNIQUE (`c_customer_id`)
DISABLE NOVALIDATE RELY;
ALTER TABLE `default`.`customer` CHANGE COLUMN `c_customer_id` `c_customer_id`
string CONSTRAINT `cid_nn` NOT NULL DISABLE NOVALIDATE RELY;
+ALTER TABLE `default`.`store_sales` ADD CONSTRAINT `ss_c` FOREIGN KEY
(`ss_customer_sk`) REFERENCES `default`.`customer`(`c_customer_sk`) DISABLE
NOVALIDATE RELY;
@@ -6708,6 +6708,36 @@ POSTHOOK: Input: default@customer
POSTHOOK: Input: default@store_sales
#### A masked pattern was here ####
+CREATE TABLE `default`.`customer`(
+ `c_customer_sk` int,
+ `c_customer_id` string,
+ `c_current_cdemo_sk` int,
+ `c_current_hdemo_sk` int,
+ `c_current_addr_sk` int,
+ `c_first_shipto_date_sk` int,
+ `c_first_sales_date_sk` int,
+ `c_salutation` string,
+ `c_first_name` string,
+ `c_last_name` string,
+ `c_preferred_cust_flag` string,
+ `c_birth_day` int,
+ `c_birth_month` int,
+ `c_birth_year` int,
+ `c_birth_country` string,
+ `c_login` string,
+ `c_email_address` string,
+ `c_last_review_date` string)
+ROW FORMAT SERDE
+ 'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'
+STORED AS INPUTFORMAT
+ 'org.apache.hadoop.mapred.TextInputFormat'
+OUTPUTFORMAT
+ 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'
+LOCATION
+#### A masked pattern was here ####
+TBLPROPERTIES (
+ 'bucketing_version'='2',
+#### A masked pattern was here ####
CREATE TABLE `default`.`store_sales`(
`ss_sold_date_sk` int,
`ss_sold_time_sk` int,
@@ -6743,43 +6773,13 @@ LOCATION
TBLPROPERTIES (
'bucketing_version'='2',
#### A masked pattern was here ####
-CREATE TABLE `default`.`customer`(
- `c_customer_sk` int,
- `c_customer_id` string,
- `c_current_cdemo_sk` int,
- `c_current_hdemo_sk` int,
- `c_current_addr_sk` int,
- `c_first_shipto_date_sk` int,
- `c_first_sales_date_sk` int,
- `c_salutation` string,
- `c_first_name` string,
- `c_last_name` string,
- `c_preferred_cust_flag` string,
- `c_birth_day` int,
- `c_birth_month` int,
- `c_birth_year` int,
- `c_birth_country` string,
- `c_login` string,
- `c_email_address` string,
- `c_last_review_date` string)
-ROW FORMAT SERDE
- 'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'
-STORED AS INPUTFORMAT
- 'org.apache.hadoop.mapred.TextInputFormat'
-OUTPUTFORMAT
- 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'
-LOCATION
-#### A masked pattern was here ####
-TBLPROPERTIES (
- 'bucketing_version'='2',
-#### A masked pattern was here ####
-ALTER TABLE `default`.`store_sales` ADD CONSTRAINT `pk_ss` PRIMARY KEY
(`ss_item_sk`,`ss_ticket_number`) DISABLE NOVALIDATE RELY;
-ALTER TABLE `default`.`store_sales` UPDATE STATISTICS
SET('numRows'='0','rawDataSize'='0' );
ALTER TABLE `default`.`customer` ADD CONSTRAINT `pk_c` PRIMARY KEY
(`c_customer_sk`) DISABLE NOVALIDATE RELY;
ALTER TABLE `default`.`customer` UPDATE STATISTICS
SET('numRows'='0','rawDataSize'='0' );
-ALTER TABLE `default`.`store_sales` ADD CONSTRAINT `ss_c` FOREIGN KEY
(`ss_customer_sk`) REFERENCES `default`.`customer`(`c_customer_sk`) DISABLE
NOVALIDATE RELY;
+ALTER TABLE `default`.`store_sales` ADD CONSTRAINT `pk_ss` PRIMARY KEY
(`ss_item_sk`,`ss_ticket_number`) DISABLE NOVALIDATE RELY;
+ALTER TABLE `default`.`store_sales` UPDATE STATISTICS
SET('numRows'='0','rawDataSize'='0' );
ALTER TABLE `default`.`customer` ADD CONSTRAINT `uk1` UNIQUE (`c_customer_id`)
DISABLE NOVALIDATE RELY;
ALTER TABLE `default`.`customer` CHANGE COLUMN `c_customer_id` `c_customer_id`
string CONSTRAINT `cid_nn` NOT NULL DISABLE NOVALIDATE RELY;
+ALTER TABLE `default`.`store_sales` ADD CONSTRAINT `ss_c` FOREIGN KEY
(`ss_customer_sk`) REFERENCES `default`.`customer`(`c_customer_sk`) DISABLE
NOVALIDATE RELY;
diff --git
a/ql/src/test/results/clientpositive/llap/explain_ddl_nested_part.q.out
b/ql/src/test/results/clientpositive/llap/explain_ddl_nested_part.q.out
index 69624f11a27..b96b865ede4 100644
--- a/ql/src/test/results/clientpositive/llap/explain_ddl_nested_part.q.out
+++ b/ql/src/test/results/clientpositive/llap/explain_ddl_nested_part.q.out
@@ -99,12 +99,12 @@ ALTER TABLE `default`.`test` PARTITION (`i`=1,`j`=1) UPDATE
STATISTICS FOR COLUM
-- BIT VECTORS PRESENT FOR `default`.`test` PARTITION `i`=1,`j`=1 FOR COLUMN
`foo` BUT THEY ARE NOT SUPPORTED YET. THE BASE64 VALUE FOR THE BITVECTOR IS
SExMoAEBwfO+SA==
ALTER TABLE `default`.`test` PARTITION (`i`=2,`j`=2) UPDATE STATISTICS FOR
COLUMN `foo` SET('lowValue'='2','highValue'='2','numNulls'='0','numDVs'='1' );
-- BIT VECTORS PRESENT FOR `default`.`test` PARTITION `i`=2,`j`=2 FOR COLUMN
`foo` BUT THEY ARE NOT SUPPORTED YET. THE BASE64 VALUE FOR THE BITVECTOR IS
SExMoAEBxIHguQQ=
-ALTER TABLE `default`.`test` PARTITION (`i`=5,`j`=5) UPDATE STATISTICS FOR
COLUMN `foo` SET('lowValue'='5','highValue'='5','numNulls'='0','numDVs'='1' );
--- BIT VECTORS PRESENT FOR `default`.`test` PARTITION `i`=5,`j`=5 FOR COLUMN
`foo` BUT THEY ARE NOT SUPPORTED YET. THE BASE64 VALUE FOR THE BITVECTOR IS
SExMoAEBwaPu+AE=
ALTER TABLE `default`.`test` PARTITION (`i`=3,`j`=3) UPDATE STATISTICS FOR
COLUMN `foo` SET('lowValue'='3','highValue'='3','numNulls'='0','numDVs'='1' );
-- BIT VECTORS PRESENT FOR `default`.`test` PARTITION `i`=3,`j`=3 FOR COLUMN
`foo` BUT THEY ARE NOT SUPPORTED YET. THE BASE64 VALUE FOR THE BITVECTOR IS
SExMoAEBgq/rqgE=
ALTER TABLE `default`.`test` PARTITION (`i`=4,`j`=4) UPDATE STATISTICS FOR
COLUMN `foo` SET('lowValue'='4','highValue'='4','numNulls'='0','numDVs'='1' );
-- BIT VECTORS PRESENT FOR `default`.`test` PARTITION `i`=4,`j`=4 FOR COLUMN
`foo` BUT THEY ARE NOT SUPPORTED YET. THE BASE64 VALUE FOR THE BITVECTOR IS
SExMoAEBhJHj9wE=
+ALTER TABLE `default`.`test` PARTITION (`i`=5,`j`=5) UPDATE STATISTICS FOR
COLUMN `foo` SET('lowValue'='5','highValue'='5','numNulls'='0','numDVs'='1' );
+-- BIT VECTORS PRESENT FOR `default`.`test` PARTITION `i`=5,`j`=5 FOR COLUMN
`foo` BUT THEY ARE NOT SUPPORTED YET. THE BASE64 VALUE FOR THE BITVECTOR IS
SExMoAEBwaPu+AE=
-- ALTER TABLE `default`.`test` PARTITION
(`i`=__HIVE_DEFAULT_PARTITION__,`j`=__HIVE_DEFAULT_PARTITION__) UPDATE
STATISTICS FOR COLUMN `foo`
SET('lowValue'='0','highValue'='0','numNulls'='2','numDVs'='0' );
@@ -452,84 +452,84 @@ ALTER TABLE `default`.`test2` PARTITION
(`i`=9805326,`j`=9805326,`s`='9805326',`
-- ALTER TABLE `default`.`test2` PARTITION
(`i`=__HIVE_DEFAULT_PARTITION__,`j`=__HIVE_DEFAULT_PARTITION__,`s`='3',`t`='3')
UPDATE STATISTICS SET('numRows'='1','rawDataSize'='2' );
-- ALTER TABLE `default`.`test2` ADD IF NOT EXISTS PARTITION
(`i`=__HIVE_DEFAULT_PARTITION__,`j`=__HIVE_DEFAULT_PARTITION__,`s`='__HIVE_DEFAULT_PARTITION__',`t`='__HIVE_DEFAULT_PARTITION__');
-- ALTER TABLE `default`.`test2` PARTITION
(`i`=__HIVE_DEFAULT_PARTITION__,`j`=__HIVE_DEFAULT_PARTITION__,`s`='__HIVE_DEFAULT_PARTITION__',`t`='__HIVE_DEFAULT_PARTITION__')
UPDATE STATISTICS SET('numRows'='1','rawDataSize'='2' );
-ALTER TABLE `default`.`test2` PARTITION
(`i`=1956691,`j`=1956691,`s`='1956691',`t`='1956691') UPDATE STATISTICS FOR
COLUMN `foo`
SET('lowValue'='1956691','highValue'='1956691','numNulls'='0','numDVs'='1' );
--- BIT VECTORS PRESENT FOR `default`.`test2` PARTITION
`i`=1956691,`j`=1956691,`s`='1956691',`t`='1956691' FOR COLUMN `foo` BUT THEY
ARE NOT SUPPORTED YET. THE BASE64 VALUE FOR THE BITVECTOR IS SExMoAEBgZ3cVQ==
-ALTER TABLE `default`.`test2` PARTITION
(`i`=7005576,`j`=7005576,`s`='7005576',`t`='7005576') UPDATE STATISTICS FOR
COLUMN `foo`
SET('lowValue'='7005576','highValue'='7005576','numNulls'='0','numDVs'='1' );
--- BIT VECTORS PRESENT FOR `default`.`test2` PARTITION
`i`=7005576,`j`=7005576,`s`='7005576',`t`='7005576' FOR COLUMN `foo` BUT THEY
ARE NOT SUPPORTED YET. THE BASE64 VALUE FOR THE BITVECTOR IS SExMoAEBgc7krgc=
-ALTER TABLE `default`.`test2` PARTITION
(`i`=7286712,`j`=7286712,`s`='7286712',`t`='7286712') UPDATE STATISTICS FOR
COLUMN `foo`
SET('lowValue'='7286712','highValue'='7286712','numNulls'='0','numDVs'='1' );
--- BIT VECTORS PRESENT FOR `default`.`test2` PARTITION
`i`=7286712,`j`=7286712,`s`='7286712',`t`='7286712' FOR COLUMN `foo` BUT THEY
ARE NOT SUPPORTED YET. THE BASE64 VALUE FOR THE BITVECTOR IS SExMoAEBwperKQ==
+-- ALTER TABLE `default`.`test2` PARTITION
(`i`=1,`j`=1,`s`='__HIVE_DEFAULT_PARTITION__',`t`='__HIVE_DEFAULT_PARTITION__')
UPDATE STATISTICS FOR COLUMN `foo`
SET('lowValue'='1','highValue'='1','numNulls'='0','numDVs'='1' );
+-- BIT VECTORS PRESENT FOR `default`.`test2` PARTITION
`i`=1,`j`=1,`s`='__HIVE_DEFAULT_PARTITION__',`t`='__HIVE_DEFAULT_PARTITION__'
FOR COLUMN `foo` BUT THEY ARE NOT SUPPORTED YET. THE BASE64 VALUE FOR THE
BITVECTOR IS SExMoAEBwfO+SA==
ALTER TABLE `default`.`test2` PARTITION
(`i`=1522484,`j`=1522484,`s`='1522484',`t`='1522484') UPDATE STATISTICS FOR
COLUMN `foo`
SET('lowValue'='1522484','highValue'='1522484','numNulls'='0','numDVs'='1' );
-- BIT VECTORS PRESENT FOR `default`.`test2` PARTITION
`i`=1522484,`j`=1522484,`s`='1522484',`t`='1522484' FOR COLUMN `foo` BUT THEY
ARE NOT SUPPORTED YET. THE BASE64 VALUE FOR THE BITVECTOR IS SExMoAEBg5zSoAU=
+ALTER TABLE `default`.`test2` PARTITION
(`i`=1565998,`j`=1565998,`s`='1565998',`t`='1565998') UPDATE STATISTICS FOR
COLUMN `foo`
SET('lowValue'='1565998','highValue'='1565998','numNulls'='0','numDVs'='1' );
+-- BIT VECTORS PRESENT FOR `default`.`test2` PARTITION
`i`=1565998,`j`=1565998,`s`='1565998',`t`='1565998' FOR COLUMN `foo` BUT THEY
ARE NOT SUPPORTED YET. THE BASE64 VALUE FOR THE BITVECTOR IS SExMoAEBhKGjdQ==
+ALTER TABLE `default`.`test2` PARTITION
(`i`=1655195,`j`=1655195,`s`='1655195',`t`='1655195') UPDATE STATISTICS FOR
COLUMN `foo`
SET('lowValue'='1655195','highValue'='1655195','numNulls'='0','numDVs'='1' );
+-- BIT VECTORS PRESENT FOR `default`.`test2` PARTITION
`i`=1655195,`j`=1655195,`s`='1655195',`t`='1655195' FOR COLUMN `foo` BUT THEY
ARE NOT SUPPORTED YET. THE BASE64 VALUE FOR THE BITVECTOR IS SExMoAEBwvLYBQ==
+ALTER TABLE `default`.`test2` PARTITION
(`i`=1880938,`j`=1880938,`s`='1880938',`t`='1880938') UPDATE STATISTICS FOR
COLUMN `foo`
SET('lowValue'='1880938','highValue'='1880938','numNulls'='0','numDVs'='1' );
+-- BIT VECTORS PRESENT FOR `default`.`test2` PARTITION
`i`=1880938,`j`=1880938,`s`='1880938',`t`='1880938' FOR COLUMN `foo` BUT THEY
ARE NOT SUPPORTED YET. THE BASE64 VALUE FOR THE BITVECTOR IS SExMoAEBgb2svAQ=
+ALTER TABLE `default`.`test2` PARTITION
(`i`=1956691,`j`=1956691,`s`='1956691',`t`='1956691') UPDATE STATISTICS FOR
COLUMN `foo`
SET('lowValue'='1956691','highValue'='1956691','numNulls'='0','numDVs'='1' );
+-- BIT VECTORS PRESENT FOR `default`.`test2` PARTITION
`i`=1956691,`j`=1956691,`s`='1956691',`t`='1956691' FOR COLUMN `foo` BUT THEY
ARE NOT SUPPORTED YET. THE BASE64 VALUE FOR THE BITVECTOR IS SExMoAEBgZ3cVQ==
+-- ALTER TABLE `default`.`test2` PARTITION
(`i`=2,`j`=2,`s`='__HIVE_DEFAULT_PARTITION__',`t`='__HIVE_DEFAULT_PARTITION__')
UPDATE STATISTICS FOR COLUMN `foo`
SET('lowValue'='2','highValue'='2','numNulls'='0','numDVs'='1' );
+-- BIT VECTORS PRESENT FOR `default`.`test2` PARTITION
`i`=2,`j`=2,`s`='__HIVE_DEFAULT_PARTITION__',`t`='__HIVE_DEFAULT_PARTITION__'
FOR COLUMN `foo` BUT THEY ARE NOT SUPPORTED YET. THE BASE64 VALUE FOR THE
BITVECTOR IS SExMoAEBxIHguQQ=
ALTER TABLE `default`.`test2` PARTITION
(`i`=2049769,`j`=2049769,`s`='2049769',`t`='2049769') UPDATE STATISTICS FOR
COLUMN `foo`
SET('lowValue'='2049769','highValue'='2049769','numNulls'='0','numDVs'='1' );
-- BIT VECTORS PRESENT FOR `default`.`test2` PARTITION
`i`=2049769,`j`=2049769,`s`='2049769',`t`='2049769' FOR COLUMN `foo` BUT THEY
ARE NOT SUPPORTED YET. THE BASE64 VALUE FOR THE BITVECTOR IS SExMoAEBwfS2sAQ=
+ALTER TABLE `default`.`test2` PARTITION
(`i`=2146641,`j`=2146641,`s`='2146641',`t`='2146641') UPDATE STATISTICS FOR
COLUMN `foo`
SET('lowValue'='2146641','highValue'='2146641','numNulls'='0','numDVs'='1' );
+-- BIT VECTORS PRESENT FOR `default`.`test2` PARTITION
`i`=2146641,`j`=2146641,`s`='2146641',`t`='2146641' FOR COLUMN `foo` BUT THEY
ARE NOT SUPPORTED YET. THE BASE64 VALUE FOR THE BITVECTOR IS SExMoAEBg9/xOw==
+ALTER TABLE `default`.`test2` PARTITION
(`i`=2581458,`j`=2581458,`s`='2581458',`t`='2581458') UPDATE STATISTICS FOR
COLUMN `foo`
SET('lowValue'='2581458','highValue'='2581458','numNulls'='0','numDVs'='1' );
+-- BIT VECTORS PRESENT FOR `default`.`test2` PARTITION
`i`=2581458,`j`=2581458,`s`='2581458',`t`='2581458' FOR COLUMN `foo` BUT THEY
ARE NOT SUPPORTED YET. THE BASE64 VALUE FOR THE BITVECTOR IS SExMoAEBgf6ljQQ=
+ALTER TABLE `default`.`test2` PARTITION
(`i`=3023419,`j`=3023419,`s`='3023419',`t`='3023419') UPDATE STATISTICS FOR
COLUMN `foo`
SET('lowValue'='3023419','highValue'='3023419','numNulls'='0','numDVs'='1' );
+-- BIT VECTORS PRESENT FOR `default`.`test2` PARTITION
`i`=3023419,`j`=3023419,`s`='3023419',`t`='3023419' FOR COLUMN `foo` BUT THEY
ARE NOT SUPPORTED YET. THE BASE64 VALUE FOR THE BITVECTOR IS SExMoAEBge2+4gQ=
ALTER TABLE `default`.`test2` PARTITION
(`i`=3073641,`j`=3073641,`s`='3073641',`t`='3073641') UPDATE STATISTICS FOR
COLUMN `foo`
SET('lowValue'='3073641','highValue'='3073641','numNulls'='0','numDVs'='1' );
-- BIT VECTORS PRESENT FOR `default`.`test2` PARTITION
`i`=3073641,`j`=3073641,`s`='3073641',`t`='3073641' FOR COLUMN `foo` BUT THEY
ARE NOT SUPPORTED YET. THE BASE64 VALUE FOR THE BITVECTOR IS SExMoAEBguu6jgQ=
+ALTER TABLE `default`.`test2` PARTITION
(`i`=3076080,`j`=3076080,`s`='3076080',`t`='3076080') UPDATE STATISTICS FOR
COLUMN `foo`
SET('lowValue'='3076080','highValue'='3076080','numNulls'='0','numDVs'='1' );
+-- BIT VECTORS PRESENT FOR `default`.`test2` PARTITION
`i`=3076080,`j`=3076080,`s`='3076080',`t`='3076080' FOR COLUMN `foo` BUT THEY
ARE NOT SUPPORTED YET. THE BASE64 VALUE FOR THE BITVECTOR IS SExMoAEBweDt4QM=
+ALTER TABLE `default`.`test2` PARTITION
(`i`=3187683,`j`=3187683,`s`='3187683',`t`='3187683') UPDATE STATISTICS FOR
COLUMN `foo`
SET('lowValue'='3187683','highValue'='3187683','numNulls'='0','numDVs'='1' );
+-- BIT VECTORS PRESENT FOR `default`.`test2` PARTITION
`i`=3187683,`j`=3187683,`s`='3187683',`t`='3187683' FOR COLUMN `foo` BUT THEY
ARE NOT SUPPORTED YET. THE BASE64 VALUE FOR THE BITVECTOR IS SExMoAEBwZn8uAc=
+ALTER TABLE `default`.`test2` PARTITION
(`i`=3356420,`j`=3356420,`s`='3356420',`t`='3356420') UPDATE STATISTICS FOR
COLUMN `foo`
SET('lowValue'='3356420','highValue'='3356420','numNulls'='0','numDVs'='1' );
+-- BIT VECTORS PRESENT FOR `default`.`test2` PARTITION
`i`=3356420,`j`=3356420,`s`='3356420',`t`='3356420' FOR COLUMN `foo` BUT THEY
ARE NOT SUPPORTED YET. THE BASE64 VALUE FOR THE BITVECTOR IS SExMoAEBwa/logE=
ALTER TABLE `default`.`test2` PARTITION
(`i`=3583871,`j`=3583871,`s`='3583871',`t`='3583871') UPDATE STATISTICS FOR
COLUMN `foo`
SET('lowValue'='3583871','highValue'='3583871','numNulls'='0','numDVs'='1' );
-- BIT VECTORS PRESENT FOR `default`.`test2` PARTITION
`i`=3583871,`j`=3583871,`s`='3583871',`t`='3583871' FOR COLUMN `foo` BUT THEY
ARE NOT SUPPORTED YET. THE BASE64 VALUE FOR THE BITVECTOR IS SExMoAEBxoKDzwM=
ALTER TABLE `default`.`test2` PARTITION
(`i`=3847717,`j`=3847717,`s`='3847717',`t`='3847717') UPDATE STATISTICS FOR
COLUMN `foo`
SET('lowValue'='3847717','highValue'='3847717','numNulls'='0','numDVs'='1' );
-- BIT VECTORS PRESENT FOR `default`.`test2` PARTITION
`i`=3847717,`j`=3847717,`s`='3847717',`t`='3847717' FOR COLUMN `foo` BUT THEY
ARE NOT SUPPORTED YET. THE BASE64 VALUE FOR THE BITVECTOR IS SExMoAEBxfvAiwE=
-ALTER TABLE `default`.`test2` PARTITION
(`i`=7670676,`j`=7670676,`s`='7670676',`t`='7670676') UPDATE STATISTICS FOR
COLUMN `foo`
SET('lowValue'='7670676','highValue'='7670676','numNulls'='0','numDVs'='1' );
--- BIT VECTORS PRESENT FOR `default`.`test2` PARTITION
`i`=7670676,`j`=7670676,`s`='7670676',`t`='7670676' FOR COLUMN `foo` BUT THEY
ARE NOT SUPPORTED YET. THE BASE64 VALUE FOR THE BITVECTOR IS SExMoAEBgejUtQU=
-ALTER TABLE `default`.`test2` PARTITION
(`i`=1655195,`j`=1655195,`s`='1655195',`t`='1655195') UPDATE STATISTICS FOR
COLUMN `foo`
SET('lowValue'='1655195','highValue'='1655195','numNulls'='0','numDVs'='1' );
--- BIT VECTORS PRESENT FOR `default`.`test2` PARTITION
`i`=1655195,`j`=1655195,`s`='1655195',`t`='1655195' FOR COLUMN `foo` BUT THEY
ARE NOT SUPPORTED YET. THE BASE64 VALUE FOR THE BITVECTOR IS SExMoAEBwvLYBQ==
-ALTER TABLE `default`.`test2` PARTITION
(`i`=6129618,`j`=6129618,`s`='6129618',`t`='6129618') UPDATE STATISTICS FOR
COLUMN `foo`
SET('lowValue'='6129618','highValue'='6129618','numNulls'='0','numDVs'='1' );
--- BIT VECTORS PRESENT FOR `default`.`test2` PARTITION
`i`=6129618,`j`=6129618,`s`='6129618',`t`='6129618' FOR COLUMN `foo` BUT THEY
ARE NOT SUPPORTED YET. THE BASE64 VALUE FOR THE BITVECTOR IS SExMoAEBgqzpngY=
-ALTER TABLE `default`.`test2` PARTITION
(`i`=7880229,`j`=7880229,`s`='7880229',`t`='7880229') UPDATE STATISTICS FOR
COLUMN `foo`
SET('lowValue'='7880229','highValue'='7880229','numNulls'='0','numDVs'='1' );
--- BIT VECTORS PRESENT FOR `default`.`test2` PARTITION
`i`=7880229,`j`=7880229,`s`='7880229',`t`='7880229' FOR COLUMN `foo` BUT THEY
ARE NOT SUPPORTED YET. THE BASE64 VALUE FOR THE BITVECTOR IS SExMoAEBgturhwI=
-ALTER TABLE `default`.`test2` PARTITION
(`i`=5803231,`j`=5803231,`s`='5803231',`t`='5803231') UPDATE STATISTICS FOR
COLUMN `foo`
SET('lowValue'='5803231','highValue'='5803231','numNulls'='0','numDVs'='1' );
--- BIT VECTORS PRESENT FOR `default`.`test2` PARTITION
`i`=5803231,`j`=5803231,`s`='5803231',`t`='5803231' FOR COLUMN `foo` BUT THEY
ARE NOT SUPPORTED YET. THE BASE64 VALUE FOR THE BITVECTOR IS SExMoAEBgpW7mQI=
--- ALTER TABLE `default`.`test2` PARTITION
(`i`=__HIVE_DEFAULT_PARTITION__,`j`=__HIVE_DEFAULT_PARTITION__,`s`='3',`t`='3')
UPDATE STATISTICS FOR COLUMN `foo`
SET('lowValue'='0','highValue'='0','numNulls'='1','numDVs'='0' );
+ALTER TABLE `default`.`test2` PARTITION
(`i`=4115101,`j`=4115101,`s`='4115101',`t`='4115101') UPDATE STATISTICS FOR
COLUMN `foo`
SET('lowValue'='4115101','highValue'='4115101','numNulls'='0','numDVs'='1' );
+-- BIT VECTORS PRESENT FOR `default`.`test2` PARTITION
`i`=4115101,`j`=4115101,`s`='4115101',`t`='4115101' FOR COLUMN `foo` BUT THEY
ARE NOT SUPPORTED YET. THE BASE64 VALUE FOR THE BITVECTOR IS SExMoAEBgaamtAY=
+ALTER TABLE `default`.`test2` PARTITION
(`i`=42629,`j`=42629,`s`='42629',`t`='42629') UPDATE STATISTICS FOR COLUMN
`foo` SET('lowValue'='42629','highValue'='42629','numNulls'='0','numDVs'='1' );
+-- BIT VECTORS PRESENT FOR `default`.`test2` PARTITION
`i`=42629,`j`=42629,`s`='42629',`t`='42629' FOR COLUMN `foo` BUT THEY ARE NOT
SUPPORTED YET. THE BASE64 VALUE FOR THE BITVECTOR IS SExMoAEBweiP4AY=
+ALTER TABLE `default`.`test2` PARTITION
(`i`=4304398,`j`=4304398,`s`='4304398',`t`='4304398') UPDATE STATISTICS FOR
COLUMN `foo`
SET('lowValue'='4304398','highValue'='4304398','numNulls'='0','numDVs'='1' );
+-- BIT VECTORS PRESENT FOR `default`.`test2` PARTITION
`i`=4304398,`j`=4304398,`s`='4304398',`t`='4304398' FOR COLUMN `foo` BUT THEY
ARE NOT SUPPORTED YET. THE BASE64 VALUE FOR THE BITVECTOR IS SExMoAEBgf2tnwQ=
+ALTER TABLE `default`.`test2` PARTITION
(`i`=4409637,`j`=4409637,`s`='4409637',`t`='4409637') UPDATE STATISTICS FOR
COLUMN `foo`
SET('lowValue'='4409637','highValue'='4409637','numNulls'='0','numDVs'='1' );
+-- BIT VECTORS PRESENT FOR `default`.`test2` PARTITION
`i`=4409637,`j`=4409637,`s`='4409637',`t`='4409637' FOR COLUMN `foo` BUT THEY
ARE NOT SUPPORTED YET. THE BASE64 VALUE FOR THE BITVECTOR IS SExMoAEBgsT4sAc=
ALTER TABLE `default`.`test2` PARTITION
(`i`=4439186,`j`=4439186,`s`='4439186',`t`='4439186') UPDATE STATISTICS FOR
COLUMN `foo`
SET('lowValue'='4439186','highValue'='4439186','numNulls'='0','numDVs'='1' );
-- BIT VECTORS PRESENT FOR `default`.`test2` PARTITION
`i`=4439186,`j`=4439186,`s`='4439186',`t`='4439186' FOR COLUMN `foo` BUT THEY
ARE NOT SUPPORTED YET. THE BASE64 VALUE FOR THE BITVECTOR IS SExMoAEBgd22gQY=
ALTER TABLE `default`.`test2` PARTITION
(`i`=4497880,`j`=4497880,`s`='4497880',`t`='4497880') UPDATE STATISTICS FOR
COLUMN `foo`
SET('lowValue'='4497880','highValue'='4497880','numNulls'='0','numDVs'='1' );
-- BIT VECTORS PRESENT FOR `default`.`test2` PARTITION
`i`=4497880,`j`=4497880,`s`='4497880',`t`='4497880' FOR COLUMN `foo` BUT THEY
ARE NOT SUPPORTED YET. THE BASE64 VALUE FOR THE BITVECTOR IS SExMoAEBwcvXgAE=
-ALTER TABLE `default`.`test2` PARTITION
(`i`=2146641,`j`=2146641,`s`='2146641',`t`='2146641') UPDATE STATISTICS FOR
COLUMN `foo`
SET('lowValue'='2146641','highValue'='2146641','numNulls'='0','numDVs'='1' );
--- BIT VECTORS PRESENT FOR `default`.`test2` PARTITION
`i`=2146641,`j`=2146641,`s`='2146641',`t`='2146641' FOR COLUMN `foo` BUT THEY
ARE NOT SUPPORTED YET. THE BASE64 VALUE FOR THE BITVECTOR IS SExMoAEBg9/xOw==
-ALTER TABLE `default`.`test2` PARTITION
(`i`=967815,`j`=967815,`s`='967815',`t`='967815') UPDATE STATISTICS FOR COLUMN
`foo` SET('lowValue'='967815','highValue'='967815','numNulls'='0','numDVs'='1'
);
--- BIT VECTORS PRESENT FOR `default`.`test2` PARTITION
`i`=967815,`j`=967815,`s`='967815',`t`='967815' FOR COLUMN `foo` BUT THEY ARE
NOT SUPPORTED YET. THE BASE64 VALUE FOR THE BITVECTOR IS SExMoAEBgom62gM=
ALTER TABLE `default`.`test2` PARTITION
(`i`=4604522,`j`=4604522,`s`='4604522',`t`='4604522') UPDATE STATISTICS FOR
COLUMN `foo`
SET('lowValue'='4604522','highValue'='4604522','numNulls'='0','numDVs'='1' );
-- BIT VECTORS PRESENT FOR `default`.`test2` PARTITION
`i`=4604522,`j`=4604522,`s`='4604522',`t`='4604522' FOR COLUMN `foo` BUT THEY
ARE NOT SUPPORTED YET. THE BASE64 VALUE FOR THE BITVECTOR IS SExMoAEBgrrK+AY=
ALTER TABLE `default`.`test2` PARTITION
(`i`=5238051,`j`=5238051,`s`='5238051',`t`='5238051') UPDATE STATISTICS FOR
COLUMN `foo`
SET('lowValue'='5238051','highValue'='5238051','numNulls'='0','numDVs'='1' );
-- BIT VECTORS PRESENT FOR `default`.`test2` PARTITION
`i`=5238051,`j`=5238051,`s`='5238051',`t`='5238051' FOR COLUMN `foo` BUT THEY
ARE NOT SUPPORTED YET. THE BASE64 VALUE FOR THE BITVECTOR IS SExMoAEBhfjCjwE=
-ALTER TABLE `default`.`test2` PARTITION
(`i`=3187683,`j`=3187683,`s`='3187683',`t`='3187683') UPDATE STATISTICS FOR
COLUMN `foo`
SET('lowValue'='3187683','highValue'='3187683','numNulls'='0','numDVs'='1' );
--- BIT VECTORS PRESENT FOR `default`.`test2` PARTITION
`i`=3187683,`j`=3187683,`s`='3187683',`t`='3187683' FOR COLUMN `foo` BUT THEY
ARE NOT SUPPORTED YET. THE BASE64 VALUE FOR THE BITVECTOR IS SExMoAEBwZn8uAc=
-ALTER TABLE `default`.`test2` PARTITION
(`i`=6758530,`j`=6758530,`s`='6758530',`t`='6758530') UPDATE STATISTICS FOR
COLUMN `foo`
SET('lowValue'='6758530','highValue'='6758530','numNulls'='0','numDVs'='1' );
--- BIT VECTORS PRESENT FOR `default`.`test2` PARTITION
`i`=6758530,`j`=6758530,`s`='6758530',`t`='6758530' FOR COLUMN `foo` BUT THEY
ARE NOT SUPPORTED YET. THE BASE64 VALUE FOR THE BITVECTOR IS SExMoAEBgtSr0gQ=
-ALTER TABLE `default`.`test2` PARTITION
(`i`=2581458,`j`=2581458,`s`='2581458',`t`='2581458') UPDATE STATISTICS FOR
COLUMN `foo`
SET('lowValue'='2581458','highValue'='2581458','numNulls'='0','numDVs'='1' );
--- BIT VECTORS PRESENT FOR `default`.`test2` PARTITION
`i`=2581458,`j`=2581458,`s`='2581458',`t`='2581458' FOR COLUMN `foo` BUT THEY
ARE NOT SUPPORTED YET. THE BASE64 VALUE FOR THE BITVECTOR IS SExMoAEBgf6ljQQ=
-ALTER TABLE `default`.`test2` PARTITION
(`i`=4304398,`j`=4304398,`s`='4304398',`t`='4304398') UPDATE STATISTICS FOR
COLUMN `foo`
SET('lowValue'='4304398','highValue'='4304398','numNulls'='0','numDVs'='1' );
--- BIT VECTORS PRESENT FOR `default`.`test2` PARTITION
`i`=4304398,`j`=4304398,`s`='4304398',`t`='4304398' FOR COLUMN `foo` BUT THEY
ARE NOT SUPPORTED YET. THE BASE64 VALUE FOR THE BITVECTOR IS SExMoAEBgf2tnwQ=
-ALTER TABLE `default`.`test2` PARTITION
(`i`=812837,`j`=812837,`s`='812837',`t`='812837') UPDATE STATISTICS FOR COLUMN
`foo` SET('lowValue'='812837','highValue'='812837','numNulls'='0','numDVs'='1'
);
--- BIT VECTORS PRESENT FOR `default`.`test2` PARTITION
`i`=812837,`j`=812837,`s`='812837',`t`='812837' FOR COLUMN `foo` BUT THEY ARE
NOT SUPPORTED YET. THE BASE64 VALUE FOR THE BITVECTOR IS SExMoAEBwuja+gY=
--- ALTER TABLE `default`.`test2` PARTITION
(`i`=2,`j`=2,`s`='__HIVE_DEFAULT_PARTITION__',`t`='__HIVE_DEFAULT_PARTITION__')
UPDATE STATISTICS FOR COLUMN `foo`
SET('lowValue'='2','highValue'='2','numNulls'='0','numDVs'='1' );
--- BIT VECTORS PRESENT FOR `default`.`test2` PARTITION
`i`=2,`j`=2,`s`='__HIVE_DEFAULT_PARTITION__',`t`='__HIVE_DEFAULT_PARTITION__'
FOR COLUMN `foo` BUT THEY ARE NOT SUPPORTED YET. THE BASE64 VALUE FOR THE
BITVECTOR IS SExMoAEBxIHguQQ=
-ALTER TABLE `default`.`test2` PARTITION
(`i`=3356420,`j`=3356420,`s`='3356420',`t`='3356420') UPDATE STATISTICS FOR
COLUMN `foo`
SET('lowValue'='3356420','highValue'='3356420','numNulls'='0','numDVs'='1' );
--- BIT VECTORS PRESENT FOR `default`.`test2` PARTITION
`i`=3356420,`j`=3356420,`s`='3356420',`t`='3356420' FOR COLUMN `foo` BUT THEY
ARE NOT SUPPORTED YET. THE BASE64 VALUE FOR THE BITVECTOR IS SExMoAEBwa/logE=
--- ALTER TABLE `default`.`test2` PARTITION
(`i`=__HIVE_DEFAULT_PARTITION__,`j`=__HIVE_DEFAULT_PARTITION__,`s`='__HIVE_DEFAULT_PARTITION__',`t`='__HIVE_DEFAULT_PARTITION__')
UPDATE STATISTICS FOR COLUMN `foo`
SET('lowValue'='0','highValue'='0','numNulls'='1','numDVs'='0' );
-ALTER TABLE `default`.`test2` PARTITION
(`i`=42629,`j`=42629,`s`='42629',`t`='42629') UPDATE STATISTICS FOR COLUMN
`foo` SET('lowValue'='42629','highValue'='42629','numNulls'='0','numDVs'='1' );
--- BIT VECTORS PRESENT FOR `default`.`test2` PARTITION
`i`=42629,`j`=42629,`s`='42629',`t`='42629' FOR COLUMN `foo` BUT THEY ARE NOT
SUPPORTED YET. THE BASE64 VALUE FOR THE BITVECTOR IS SExMoAEBweiP4AY=
ALTER TABLE `default`.`test2` PARTITION
(`i`=5247332,`j`=5247332,`s`='5247332',`t`='5247332') UPDATE STATISTICS FOR
COLUMN `foo`
SET('lowValue'='5247332','highValue'='5247332','numNulls'='0','numDVs'='1' );
-- BIT VECTORS PRESENT FOR `default`.`test2` PARTITION
`i`=5247332,`j`=5247332,`s`='5247332',`t`='5247332' FOR COLUMN `foo` BUT THEY
ARE NOT SUPPORTED YET. THE BASE64 VALUE FOR THE BITVECTOR IS SExMoAEBg5mT4Qc=
-ALTER TABLE `default`.`test2` PARTITION
(`i`=1565998,`j`=1565998,`s`='1565998',`t`='1565998') UPDATE STATISTICS FOR
COLUMN `foo`
SET('lowValue'='1565998','highValue'='1565998','numNulls'='0','numDVs'='1' );
--- BIT VECTORS PRESENT FOR `default`.`test2` PARTITION
`i`=1565998,`j`=1565998,`s`='1565998',`t`='1565998' FOR COLUMN `foo` BUT THEY
ARE NOT SUPPORTED YET. THE BASE64 VALUE FOR THE BITVECTOR IS SExMoAEBhKGjdQ==
-ALTER TABLE `default`.`test2` PARTITION
(`i`=1880938,`j`=1880938,`s`='1880938',`t`='1880938') UPDATE STATISTICS FOR
COLUMN `foo`
SET('lowValue'='1880938','highValue'='1880938','numNulls'='0','numDVs'='1' );
--- BIT VECTORS PRESENT FOR `default`.`test2` PARTITION
`i`=1880938,`j`=1880938,`s`='1880938',`t`='1880938' FOR COLUMN `foo` BUT THEY
ARE NOT SUPPORTED YET. THE BASE64 VALUE FOR THE BITVECTOR IS SExMoAEBgb2svAQ=
-ALTER TABLE `default`.`test2` PARTITION
(`i`=9805326,`j`=9805326,`s`='9805326',`t`='9805326') UPDATE STATISTICS FOR
COLUMN `foo`
SET('lowValue'='9805326','highValue'='9805326','numNulls'='0','numDVs'='1' );
--- BIT VECTORS PRESENT FOR `default`.`test2` PARTITION
`i`=9805326,`j`=9805326,`s`='9805326',`t`='9805326' FOR COLUMN `foo` BUT THEY
ARE NOT SUPPORTED YET. THE BASE64 VALUE FOR THE BITVECTOR IS SExMoAEBw96RggU=
-ALTER TABLE `default`.`test2` PARTITION
(`i`=3076080,`j`=3076080,`s`='3076080',`t`='3076080') UPDATE STATISTICS FOR
COLUMN `foo`
SET('lowValue'='3076080','highValue'='3076080','numNulls'='0','numDVs'='1' );
--- BIT VECTORS PRESENT FOR `default`.`test2` PARTITION
`i`=3076080,`j`=3076080,`s`='3076080',`t`='3076080' FOR COLUMN `foo` BUT THEY
ARE NOT SUPPORTED YET. THE BASE64 VALUE FOR THE BITVECTOR IS SExMoAEBweDt4QM=
-ALTER TABLE `default`.`test2` PARTITION
(`i`=4409637,`j`=4409637,`s`='4409637',`t`='4409637') UPDATE STATISTICS FOR
COLUMN `foo`
SET('lowValue'='4409637','highValue'='4409637','numNulls'='0','numDVs'='1' );
--- BIT VECTORS PRESENT FOR `default`.`test2` PARTITION
`i`=4409637,`j`=4409637,`s`='4409637',`t`='4409637' FOR COLUMN `foo` BUT THEY
ARE NOT SUPPORTED YET. THE BASE64 VALUE FOR THE BITVECTOR IS SExMoAEBgsT4sAc=
+ALTER TABLE `default`.`test2` PARTITION
(`i`=5803231,`j`=5803231,`s`='5803231',`t`='5803231') UPDATE STATISTICS FOR
COLUMN `foo`
SET('lowValue'='5803231','highValue'='5803231','numNulls'='0','numDVs'='1' );
+-- BIT VECTORS PRESENT FOR `default`.`test2` PARTITION
`i`=5803231,`j`=5803231,`s`='5803231',`t`='5803231' FOR COLUMN `foo` BUT THEY
ARE NOT SUPPORTED YET. THE BASE64 VALUE FOR THE BITVECTOR IS SExMoAEBgpW7mQI=
+ALTER TABLE `default`.`test2` PARTITION
(`i`=6129618,`j`=6129618,`s`='6129618',`t`='6129618') UPDATE STATISTICS FOR
COLUMN `foo`
SET('lowValue'='6129618','highValue'='6129618','numNulls'='0','numDVs'='1' );
+-- BIT VECTORS PRESENT FOR `default`.`test2` PARTITION
`i`=6129618,`j`=6129618,`s`='6129618',`t`='6129618' FOR COLUMN `foo` BUT THEY
ARE NOT SUPPORTED YET. THE BASE64 VALUE FOR THE BITVECTOR IS SExMoAEBgqzpngY=
ALTER TABLE `default`.`test2` PARTITION
(`i`=6276003,`j`=6276003,`s`='6276003',`t`='6276003') UPDATE STATISTICS FOR
COLUMN `foo`
SET('lowValue'='6276003','highValue'='6276003','numNulls'='0','numDVs'='1' );
-- BIT VECTORS PRESENT FOR `default`.`test2` PARTITION
`i`=6276003,`j`=6276003,`s`='6276003',`t`='6276003' FOR COLUMN `foo` BUT THEY
ARE NOT SUPPORTED YET. THE BASE64 VALUE FOR THE BITVECTOR IS SExMoAEBw8Kw8wQ=
--- ALTER TABLE `default`.`test2` PARTITION
(`i`=1,`j`=1,`s`='__HIVE_DEFAULT_PARTITION__',`t`='__HIVE_DEFAULT_PARTITION__')
UPDATE STATISTICS FOR COLUMN `foo`
SET('lowValue'='1','highValue'='1','numNulls'='0','numDVs'='1' );
--- BIT VECTORS PRESENT FOR `default`.`test2` PARTITION
`i`=1,`j`=1,`s`='__HIVE_DEFAULT_PARTITION__',`t`='__HIVE_DEFAULT_PARTITION__'
FOR COLUMN `foo` BUT THEY ARE NOT SUPPORTED YET. THE BASE64 VALUE FOR THE
BITVECTOR IS SExMoAEBwfO+SA==
-ALTER TABLE `default`.`test2` PARTITION
(`i`=3023419,`j`=3023419,`s`='3023419',`t`='3023419') UPDATE STATISTICS FOR
COLUMN `foo`
SET('lowValue'='3023419','highValue'='3023419','numNulls'='0','numDVs'='1' );
--- BIT VECTORS PRESENT FOR `default`.`test2` PARTITION
`i`=3023419,`j`=3023419,`s`='3023419',`t`='3023419' FOR COLUMN `foo` BUT THEY
ARE NOT SUPPORTED YET. THE BASE64 VALUE FOR THE BITVECTOR IS SExMoAEBge2+4gQ=
-ALTER TABLE `default`.`test2` PARTITION
(`i`=4115101,`j`=4115101,`s`='4115101',`t`='4115101') UPDATE STATISTICS FOR
COLUMN `foo`
SET('lowValue'='4115101','highValue'='4115101','numNulls'='0','numDVs'='1' );
--- BIT VECTORS PRESENT FOR `default`.`test2` PARTITION
`i`=4115101,`j`=4115101,`s`='4115101',`t`='4115101' FOR COLUMN `foo` BUT THEY
ARE NOT SUPPORTED YET. THE BASE64 VALUE FOR THE BITVECTOR IS SExMoAEBgaamtAY=
+ALTER TABLE `default`.`test2` PARTITION
(`i`=6758530,`j`=6758530,`s`='6758530',`t`='6758530') UPDATE STATISTICS FOR
COLUMN `foo`
SET('lowValue'='6758530','highValue'='6758530','numNulls'='0','numDVs'='1' );
+-- BIT VECTORS PRESENT FOR `default`.`test2` PARTITION
`i`=6758530,`j`=6758530,`s`='6758530',`t`='6758530' FOR COLUMN `foo` BUT THEY
ARE NOT SUPPORTED YET. THE BASE64 VALUE FOR THE BITVECTOR IS SExMoAEBgtSr0gQ=
+ALTER TABLE `default`.`test2` PARTITION
(`i`=7005576,`j`=7005576,`s`='7005576',`t`='7005576') UPDATE STATISTICS FOR
COLUMN `foo`
SET('lowValue'='7005576','highValue'='7005576','numNulls'='0','numDVs'='1' );
+-- BIT VECTORS PRESENT FOR `default`.`test2` PARTITION
`i`=7005576,`j`=7005576,`s`='7005576',`t`='7005576' FOR COLUMN `foo` BUT THEY
ARE NOT SUPPORTED YET. THE BASE64 VALUE FOR THE BITVECTOR IS SExMoAEBgc7krgc=
+ALTER TABLE `default`.`test2` PARTITION
(`i`=7286712,`j`=7286712,`s`='7286712',`t`='7286712') UPDATE STATISTICS FOR
COLUMN `foo`
SET('lowValue'='7286712','highValue'='7286712','numNulls'='0','numDVs'='1' );
+-- BIT VECTORS PRESENT FOR `default`.`test2` PARTITION
`i`=7286712,`j`=7286712,`s`='7286712',`t`='7286712' FOR COLUMN `foo` BUT THEY
ARE NOT SUPPORTED YET. THE BASE64 VALUE FOR THE BITVECTOR IS SExMoAEBwperKQ==
+ALTER TABLE `default`.`test2` PARTITION
(`i`=7670676,`j`=7670676,`s`='7670676',`t`='7670676') UPDATE STATISTICS FOR
COLUMN `foo`
SET('lowValue'='7670676','highValue'='7670676','numNulls'='0','numDVs'='1' );
+-- BIT VECTORS PRESENT FOR `default`.`test2` PARTITION
`i`=7670676,`j`=7670676,`s`='7670676',`t`='7670676' FOR COLUMN `foo` BUT THEY
ARE NOT SUPPORTED YET. THE BASE64 VALUE FOR THE BITVECTOR IS SExMoAEBgejUtQU=
+ALTER TABLE `default`.`test2` PARTITION
(`i`=7880229,`j`=7880229,`s`='7880229',`t`='7880229') UPDATE STATISTICS FOR
COLUMN `foo`
SET('lowValue'='7880229','highValue'='7880229','numNulls'='0','numDVs'='1' );
+-- BIT VECTORS PRESENT FOR `default`.`test2` PARTITION
`i`=7880229,`j`=7880229,`s`='7880229',`t`='7880229' FOR COLUMN `foo` BUT THEY
ARE NOT SUPPORTED YET. THE BASE64 VALUE FOR THE BITVECTOR IS SExMoAEBgturhwI=
+ALTER TABLE `default`.`test2` PARTITION
(`i`=812837,`j`=812837,`s`='812837',`t`='812837') UPDATE STATISTICS FOR COLUMN
`foo` SET('lowValue'='812837','highValue'='812837','numNulls'='0','numDVs'='1'
);
+-- BIT VECTORS PRESENT FOR `default`.`test2` PARTITION
`i`=812837,`j`=812837,`s`='812837',`t`='812837' FOR COLUMN `foo` BUT THEY ARE
NOT SUPPORTED YET. THE BASE64 VALUE FOR THE BITVECTOR IS SExMoAEBwuja+gY=
+ALTER TABLE `default`.`test2` PARTITION
(`i`=967815,`j`=967815,`s`='967815',`t`='967815') UPDATE STATISTICS FOR COLUMN
`foo` SET('lowValue'='967815','highValue'='967815','numNulls'='0','numDVs'='1'
);
+-- BIT VECTORS PRESENT FOR `default`.`test2` PARTITION
`i`=967815,`j`=967815,`s`='967815',`t`='967815' FOR COLUMN `foo` BUT THEY ARE
NOT SUPPORTED YET. THE BASE64 VALUE FOR THE BITVECTOR IS SExMoAEBgom62gM=
ALTER TABLE `default`.`test2` PARTITION
(`i`=971079,`j`=971079,`s`='971079',`t`='971079') UPDATE STATISTICS FOR COLUMN
`foo` SET('lowValue'='971079','highValue'='971079','numNulls'='0','numDVs'='1'
);
-- BIT VECTORS PRESENT FOR `default`.`test2` PARTITION
`i`=971079,`j`=971079,`s`='971079',`t`='971079' FOR COLUMN `foo` BUT THEY ARE
NOT SUPPORTED YET. THE BASE64 VALUE FOR THE BITVECTOR IS SExMoAEBg6XR2gc=
+ALTER TABLE `default`.`test2` PARTITION
(`i`=9805326,`j`=9805326,`s`='9805326',`t`='9805326') UPDATE STATISTICS FOR
COLUMN `foo`
SET('lowValue'='9805326','highValue'='9805326','numNulls'='0','numDVs'='1' );
+-- BIT VECTORS PRESENT FOR `default`.`test2` PARTITION
`i`=9805326,`j`=9805326,`s`='9805326',`t`='9805326' FOR COLUMN `foo` BUT THEY
ARE NOT SUPPORTED YET. THE BASE64 VALUE FOR THE BITVECTOR IS SExMoAEBw96RggU=
+-- ALTER TABLE `default`.`test2` PARTITION
(`i`=__HIVE_DEFAULT_PARTITION__,`j`=__HIVE_DEFAULT_PARTITION__,`s`='3',`t`='3')
UPDATE STATISTICS FOR COLUMN `foo`
SET('lowValue'='0','highValue'='0','numNulls'='1','numDVs'='0' );
+-- ALTER TABLE `default`.`test2` PARTITION
(`i`=__HIVE_DEFAULT_PARTITION__,`j`=__HIVE_DEFAULT_PARTITION__,`s`='__HIVE_DEFAULT_PARTITION__',`t`='__HIVE_DEFAULT_PARTITION__')
UPDATE STATISTICS FOR COLUMN `foo`
SET('lowValue'='0','highValue'='0','numNulls'='1','numDVs'='0' );
diff --git
a/ql/src/test/results/clientpositive/llap/partition_explain_ddl.q.out
b/ql/src/test/results/clientpositive/llap/partition_explain_ddl.q.out
index 7368ca8c16b..a10fd5fa040 100644
--- a/ql/src/test/results/clientpositive/llap/partition_explain_ddl.q.out
+++ b/ql/src/test/results/clientpositive/llap/partition_explain_ddl.q.out
@@ -270,14 +270,14 @@ ALTER TABLE `default`.`add_part_test` ADD IF NOT EXISTS
PARTITION (`ds`='2010-01
ALTER TABLE `default`.`add_part_test` PARTITION (`ds`='2010-01-02') UPDATE
STATISTICS SET('numRows'='0','rawDataSize'='0' );
ALTER TABLE `default`.`add_part_test` ADD IF NOT EXISTS PARTITION
(`ds`='2010-01-03');
ALTER TABLE `default`.`add_part_test` PARTITION (`ds`='2010-01-03') UPDATE
STATISTICS SET('numRows'='15','rawDataSize'='225' );
-ALTER TABLE `default`.`add_part_test` PARTITION (`ds`='2010-01-01') UPDATE
STATISTICS FOR COLUMN `value`
SET('avgColLen'='7.526315789473684','maxColLen'='8','numNulls'='0','numDVs'='19'
);
--- BIT VECTORS PRESENT FOR `default`.`add_part_test` PARTITION
`ds`='2010-01-01' FOR COLUMN `value` BUT THEY ARE NOT SUPPORTED YET. THE BASE64
VALUE FOR THE BITVECTOR IS
SExMoBMTwq6o+gLE0trKAvuXwdz6/////wGAp4ikAcCYgKYEgKv42f3/////AcLt7oMD/orRm///////AcDeotcBwOvPh/r/////AYDyz7kGwM+kvvz/////AYD90bn+/////wGBytzd/v////8Bv9fU1v//////AYDRh8UEwf6S/v3/////Ab+aqtIChMGNvP7/////AQ==
ALTER TABLE `default`.`add_part_test` PARTITION (`ds`='2010-01-01') UPDATE
STATISTICS FOR COLUMN `key`
SET('avgColLen'='5.526315789473684','maxColLen'='6','numNulls'='0','numDVs'='19'
);
-- BIT VECTORS PRESENT FOR `default`.`add_part_test` PARTITION
`ds`='2010-01-01' FOR COLUMN `key` BUT THEY ARE NOT SUPPORTED YET. THE BASE64
VALUE FOR THE BITVECTOR IS
SExMoBMTga///AODuuFlwpGjgAL7r+CB+/////8BgPGY2AGB8bqnA8TDyvT6/////wG75PK0BMDg56b6/////wGAn/E7wM3HswOA1rnX/P////8BguujpwOB4qzYAv6j2hD/wYu4+v////8BgIKhwAGAge7KA8Cop9b//////wE=
-ALTER TABLE `default`.`add_part_test` PARTITION (`ds`='2010-01-03') UPDATE
STATISTICS FOR COLUMN `value`
SET('avgColLen'='8.0','maxColLen'='8','numNulls'='0','numDVs'='15' );
--- BIT VECTORS PRESENT FOR `default`.`add_part_test` PARTITION
`ds`='2010-01-03' FOR COLUMN `value` BUT THEY ARE NOT SUPPORTED YET. THE BASE64
VALUE FOR THE BITVECTOR IS
SExMoA8PgaOnjASAnPDu//////8BwfPgSP+i5ViAxKHO/P////8BgIjfnQTA44A8gJ2G1///////AcSq3Y7//////wH84vzz/f////8BhYzE6vz/////AfyQ+MsH/4aiEoChh/v//////wHBvOTP//////8B
+ALTER TABLE `default`.`add_part_test` PARTITION (`ds`='2010-01-01') UPDATE
STATISTICS FOR COLUMN `value`
SET('avgColLen'='7.526315789473684','maxColLen'='8','numNulls'='0','numDVs'='19'
);
+-- BIT VECTORS PRESENT FOR `default`.`add_part_test` PARTITION
`ds`='2010-01-01' FOR COLUMN `value` BUT THEY ARE NOT SUPPORTED YET. THE BASE64
VALUE FOR THE BITVECTOR IS
SExMoBMTwq6o+gLE0trKAvuXwdz6/////wGAp4ikAcCYgKYEgKv42f3/////AcLt7oMD/orRm///////AcDeotcBwOvPh/r/////AYDyz7kGwM+kvvz/////AYD90bn+/////wGBytzd/v////8Bv9fU1v//////AYDRh8UEwf6S/v3/////Ab+aqtIChMGNvP7/////AQ==
ALTER TABLE `default`.`add_part_test` PARTITION (`ds`='2010-01-03') UPDATE
STATISTICS FOR COLUMN `key`
SET('avgColLen'='6.0','maxColLen'='6','numNulls'='0','numDVs'='15' );
-- BIT VECTORS PRESENT FOR `default`.`add_part_test` PARTITION
`ds`='2010-01-03' FOR COLUMN `key` BUT THEY ARE NOT SUPPORTED YET. THE BASE64
VALUE FOR THE BITVECTOR IS
SExMoA8PxLrgqgHA37++Bv2T79H6/////wGAkZX+/v////8BwYzG8AWApP7O+f////8BgdfK4wT/m6bn+/////8B/9jt3wKC8sjC/f////8BvuyTzgPB1Mbz/P////8Bv5KKwgTBi8Ph+f////8BgIaQ5QM=
+ALTER TABLE `default`.`add_part_test` PARTITION (`ds`='2010-01-03') UPDATE
STATISTICS FOR COLUMN `value`
SET('avgColLen'='8.0','maxColLen'='8','numNulls'='0','numDVs'='15' );
+-- BIT VECTORS PRESENT FOR `default`.`add_part_test` PARTITION
`ds`='2010-01-03' FOR COLUMN `value` BUT THEY ARE NOT SUPPORTED YET. THE BASE64
VALUE FOR THE BITVECTOR IS
SExMoA8PgaOnjASAnPDu//////8BwfPgSP+i5ViAxKHO/P////8BgIjfnQTA44A8gJ2G1///////AcSq3Y7//////wH84vzz/f////8BhYzE6vz/////AfyQ+MsH/4aiEoChh/v//////wHBvOTP//////8B
@@ -544,14 +544,14 @@ ALTER TABLE `add_part_test_db`.`add_part_test` ADD IF NOT
EXISTS PARTITION (`ds`
ALTER TABLE `add_part_test_db`.`add_part_test` PARTITION (`ds`='2010-01-02')
UPDATE STATISTICS SET('numRows'='0','rawDataSize'='0' );
ALTER TABLE `add_part_test_db`.`add_part_test` ADD IF NOT EXISTS PARTITION
(`ds`='2010-01-03');
ALTER TABLE `add_part_test_db`.`add_part_test` PARTITION (`ds`='2010-01-03')
UPDATE STATISTICS SET('numRows'='15','rawDataSize'='225' );
-ALTER TABLE `add_part_test_db`.`add_part_test` PARTITION (`ds`='2010-01-01')
UPDATE STATISTICS FOR COLUMN `value`
SET('avgColLen'='7.526315789473684','maxColLen'='8','numNulls'='0','numDVs'='19'
);
--- BIT VECTORS PRESENT FOR `add_part_test_db`.`add_part_test` PARTITION
`ds`='2010-01-01' FOR COLUMN `value` BUT THEY ARE NOT SUPPORTED YET. THE BASE64
VALUE FOR THE BITVECTOR IS
SExMoBMTwq6o+gLE0trKAvuXwdz6/////wGAp4ikAcCYgKYEgKv42f3/////AcLt7oMD/orRm///////AcDeotcBwOvPh/r/////AYDyz7kGwM+kvvz/////AYD90bn+/////wGBytzd/v////8Bv9fU1v//////AYDRh8UEwf6S/v3/////Ab+aqtIChMGNvP7/////AQ==
ALTER TABLE `add_part_test_db`.`add_part_test` PARTITION (`ds`='2010-01-01')
UPDATE STATISTICS FOR COLUMN `key`
SET('avgColLen'='5.526315789473684','maxColLen'='6','numNulls'='0','numDVs'='19'
);
-- BIT VECTORS PRESENT FOR `add_part_test_db`.`add_part_test` PARTITION
`ds`='2010-01-01' FOR COLUMN `key` BUT THEY ARE NOT SUPPORTED YET. THE BASE64
VALUE FOR THE BITVECTOR IS
SExMoBMTga///AODuuFlwpGjgAL7r+CB+/////8BgPGY2AGB8bqnA8TDyvT6/////wG75PK0BMDg56b6/////wGAn/E7wM3HswOA1rnX/P////8BguujpwOB4qzYAv6j2hD/wYu4+v////8BgIKhwAGAge7KA8Cop9b//////wE=
-ALTER TABLE `add_part_test_db`.`add_part_test` PARTITION (`ds`='2010-01-03')
UPDATE STATISTICS FOR COLUMN `value`
SET('avgColLen'='8.0','maxColLen'='8','numNulls'='0','numDVs'='15' );
--- BIT VECTORS PRESENT FOR `add_part_test_db`.`add_part_test` PARTITION
`ds`='2010-01-03' FOR COLUMN `value` BUT THEY ARE NOT SUPPORTED YET. THE BASE64
VALUE FOR THE BITVECTOR IS
SExMoA8PgaOnjASAnPDu//////8BwfPgSP+i5ViAxKHO/P////8BgIjfnQTA44A8gJ2G1///////AcSq3Y7//////wH84vzz/f////8BhYzE6vz/////AfyQ+MsH/4aiEoChh/v//////wHBvOTP//////8B
+ALTER TABLE `add_part_test_db`.`add_part_test` PARTITION (`ds`='2010-01-01')
UPDATE STATISTICS FOR COLUMN `value`
SET('avgColLen'='7.526315789473684','maxColLen'='8','numNulls'='0','numDVs'='19'
);
+-- BIT VECTORS PRESENT FOR `add_part_test_db`.`add_part_test` PARTITION
`ds`='2010-01-01' FOR COLUMN `value` BUT THEY ARE NOT SUPPORTED YET. THE BASE64
VALUE FOR THE BITVECTOR IS
SExMoBMTwq6o+gLE0trKAvuXwdz6/////wGAp4ikAcCYgKYEgKv42f3/////AcLt7oMD/orRm///////AcDeotcBwOvPh/r/////AYDyz7kGwM+kvvz/////AYD90bn+/////wGBytzd/v////8Bv9fU1v//////AYDRh8UEwf6S/v3/////Ab+aqtIChMGNvP7/////AQ==
ALTER TABLE `add_part_test_db`.`add_part_test` PARTITION (`ds`='2010-01-03')
UPDATE STATISTICS FOR COLUMN `key`
SET('avgColLen'='6.0','maxColLen'='6','numNulls'='0','numDVs'='15' );
-- BIT VECTORS PRESENT FOR `add_part_test_db`.`add_part_test` PARTITION
`ds`='2010-01-03' FOR COLUMN `key` BUT THEY ARE NOT SUPPORTED YET. THE BASE64
VALUE FOR THE BITVECTOR IS
SExMoA8PxLrgqgHA37++Bv2T79H6/////wGAkZX+/v////8BwYzG8AWApP7O+f////8BgdfK4wT/m6bn+/////8B/9jt3wKC8sjC/f////8BvuyTzgPB1Mbz/P////8Bv5KKwgTBi8Ph+f////8BgIaQ5QM=
+ALTER TABLE `add_part_test_db`.`add_part_test` PARTITION (`ds`='2010-01-03')
UPDATE STATISTICS FOR COLUMN `value`
SET('avgColLen'='8.0','maxColLen'='8','numNulls'='0','numDVs'='15' );
+-- BIT VECTORS PRESENT FOR `add_part_test_db`.`add_part_test` PARTITION
`ds`='2010-01-03' FOR COLUMN `value` BUT THEY ARE NOT SUPPORTED YET. THE BASE64
VALUE FOR THE BITVECTOR IS
SExMoA8PgaOnjASAnPDu//////8BwfPgSP+i5ViAxKHO/P////8BgIjfnQTA44A8gJ2G1///////AcSq3Y7//////wH84vzz/f////8BhYzE6vz/////AfyQ+MsH/4aiEoChh/v//////wHBvOTP//////8B
@@ -646,14 +646,14 @@ ALTER TABLE `add_part_test_db`.`add_part_test` ADD IF NOT
EXISTS PARTITION (`ds`
ALTER TABLE `add_part_test_db`.`add_part_test` PARTITION (`ds`='2010-01-02')
UPDATE STATISTICS SET('numRows'='0','rawDataSize'='0' );
ALTER TABLE `add_part_test_db`.`add_part_test` ADD IF NOT EXISTS PARTITION
(`ds`='2010-01-03');
ALTER TABLE `add_part_test_db`.`add_part_test` PARTITION (`ds`='2010-01-03')
UPDATE STATISTICS SET('numRows'='15','rawDataSize'='225' );
-ALTER TABLE `add_part_test_db`.`add_part_test` PARTITION (`ds`='2010-01-01')
UPDATE STATISTICS FOR COLUMN `value`
SET('avgColLen'='7.526315789473684','maxColLen'='8','numNulls'='0','numDVs'='19'
);
--- BIT VECTORS PRESENT FOR `add_part_test_db`.`add_part_test` PARTITION
`ds`='2010-01-01' FOR COLUMN `value` BUT THEY ARE NOT SUPPORTED YET. THE BASE64
VALUE FOR THE BITVECTOR IS
SExMoBMTwq6o+gLE0trKAvuXwdz6/////wGAp4ikAcCYgKYEgKv42f3/////AcLt7oMD/orRm///////AcDeotcBwOvPh/r/////AYDyz7kGwM+kvvz/////AYD90bn+/////wGBytzd/v////8Bv9fU1v//////AYDRh8UEwf6S/v3/////Ab+aqtIChMGNvP7/////AQ==
ALTER TABLE `add_part_test_db`.`add_part_test` PARTITION (`ds`='2010-01-01')
UPDATE STATISTICS FOR COLUMN `key`
SET('avgColLen'='5.526315789473684','maxColLen'='6','numNulls'='0','numDVs'='19'
);
-- BIT VECTORS PRESENT FOR `add_part_test_db`.`add_part_test` PARTITION
`ds`='2010-01-01' FOR COLUMN `key` BUT THEY ARE NOT SUPPORTED YET. THE BASE64
VALUE FOR THE BITVECTOR IS
SExMoBMTga///AODuuFlwpGjgAL7r+CB+/////8BgPGY2AGB8bqnA8TDyvT6/////wG75PK0BMDg56b6/////wGAn/E7wM3HswOA1rnX/P////8BguujpwOB4qzYAv6j2hD/wYu4+v////8BgIKhwAGAge7KA8Cop9b//////wE=
-ALTER TABLE `add_part_test_db`.`add_part_test` PARTITION (`ds`='2010-01-03')
UPDATE STATISTICS FOR COLUMN `value`
SET('avgColLen'='8.0','maxColLen'='8','numNulls'='0','numDVs'='15' );
--- BIT VECTORS PRESENT FOR `add_part_test_db`.`add_part_test` PARTITION
`ds`='2010-01-03' FOR COLUMN `value` BUT THEY ARE NOT SUPPORTED YET. THE BASE64
VALUE FOR THE BITVECTOR IS
SExMoA8PgaOnjASAnPDu//////8BwfPgSP+i5ViAxKHO/P////8BgIjfnQTA44A8gJ2G1///////AcSq3Y7//////wH84vzz/f////8BhYzE6vz/////AfyQ+MsH/4aiEoChh/v//////wHBvOTP//////8B
+ALTER TABLE `add_part_test_db`.`add_part_test` PARTITION (`ds`='2010-01-01')
UPDATE STATISTICS FOR COLUMN `value`
SET('avgColLen'='7.526315789473684','maxColLen'='8','numNulls'='0','numDVs'='19'
);
+-- BIT VECTORS PRESENT FOR `add_part_test_db`.`add_part_test` PARTITION
`ds`='2010-01-01' FOR COLUMN `value` BUT THEY ARE NOT SUPPORTED YET. THE BASE64
VALUE FOR THE BITVECTOR IS
SExMoBMTwq6o+gLE0trKAvuXwdz6/////wGAp4ikAcCYgKYEgKv42f3/////AcLt7oMD/orRm///////AcDeotcBwOvPh/r/////AYDyz7kGwM+kvvz/////AYD90bn+/////wGBytzd/v////8Bv9fU1v//////AYDRh8UEwf6S/v3/////Ab+aqtIChMGNvP7/////AQ==
ALTER TABLE `add_part_test_db`.`add_part_test` PARTITION (`ds`='2010-01-03')
UPDATE STATISTICS FOR COLUMN `key`
SET('avgColLen'='6.0','maxColLen'='6','numNulls'='0','numDVs'='15' );
-- BIT VECTORS PRESENT FOR `add_part_test_db`.`add_part_test` PARTITION
`ds`='2010-01-03' FOR COLUMN `key` BUT THEY ARE NOT SUPPORTED YET. THE BASE64
VALUE FOR THE BITVECTOR IS
SExMoA8PxLrgqgHA37++Bv2T79H6/////wGAkZX+/v////8BwYzG8AWApP7O+f////8BgdfK4wT/m6bn+/////8B/9jt3wKC8sjC/f////8BvuyTzgPB1Mbz/P////8Bv5KKwgTBi8Ph+f////8BgIaQ5QM=
+ALTER TABLE `add_part_test_db`.`add_part_test` PARTITION (`ds`='2010-01-03')
UPDATE STATISTICS FOR COLUMN `value`
SET('avgColLen'='8.0','maxColLen'='8','numNulls'='0','numDVs'='15' );
+-- BIT VECTORS PRESENT FOR `add_part_test_db`.`add_part_test` PARTITION
`ds`='2010-01-03' FOR COLUMN `value` BUT THEY ARE NOT SUPPORTED YET. THE BASE64
VALUE FOR THE BITVECTOR IS
SExMoA8PgaOnjASAnPDu//////8BwfPgSP+i5ViAxKHO/P////8BgIjfnQTA44A8gJ2G1///////AcSq3Y7//////wH84vzz/f////8BhYzE6vz/////AfyQ+MsH/4aiEoChh/v//////wHBvOTP//////8B
@@ -900,66 +900,66 @@ ALTER TABLE `db_bdpbase`.`default_partition_test` ADD IF
NOT EXISTS PARTITION (`
ALTER TABLE `db_bdpbase`.`default_partition_test` PARTITION
(`sports`='Tennis') UPDATE STATISTICS SET('numRows'='16','rawDataSize'='635' );
-- ALTER TABLE `db_bdpbase`.`default_partition_test` ADD IF NOT EXISTS
PARTITION (`sports`='__HIVE_DEFAULT_PARTITION__');
-- ALTER TABLE `db_bdpbase`.`default_partition_test` PARTITION
(`sports`='__HIVE_DEFAULT_PARTITION__') UPDATE STATISTICS
SET('numRows'='6','rawDataSize'='247' );
-ALTER TABLE `db_bdpbase`.`default_partition_test` PARTITION
(`sports`='Tennis') UPDATE STATISTICS FOR COLUMN `country`
SET('avgColLen'='9.5625','maxColLen'='27','numNulls'='0','numDVs'='16' );
--- BIT VECTORS PRESENT FOR `db_bdpbase`.`default_partition_test` PARTITION
`sports`='Tennis' FOR COLUMN `country` BUT THEY ARE NOT SUPPORTED YET. THE
BASE64 VALUE FOR THE BITVECTOR IS
SExMoBAQweClxwTAto6P/P////8Bg5qv8gO9nZOuAYWnjJT8/////wH7y9SkAoD13gGBtJOV/v////8BgqrYtf7/////Af3z25EEgbjb3wK/2Jud//////8BgZbmgvr/////Af+XtN4Dga/pvP//////AcH6mY8B
-ALTER TABLE `db_bdpbase`.`default_partition_test` PARTITION
(`sports`='Tennis') UPDATE STATISTICS FOR COLUMN `city`
SET('avgColLen'='9.5625','maxColLen'='18','numNulls'='0','numDVs'='16' );
--- BIT VECTORS PRESENT FOR `db_bdpbase`.`default_partition_test` PARTITION
`sports`='Tennis' FOR COLUMN `city` BUT THEY ARE NOT SUPPORTED YET. THE BASE64
VALUE FOR THE BITVECTOR IS
SExMoBAQgfSH0gPAg7CJAoCl9ljC0YLK//////8B/picz/7/////AcDlwtP7/////wHAl84twIbP+v//////AYCoomaApeWJBoG1lab6/////wH/sNr5AoDjqJr8/////wHBz+68BcCH7fb9/////wH/+7xK
-ALTER TABLE `db_bdpbase`.`default_partition_test` PARTITION
(`sports`='Tennis') UPDATE STATISTICS FOR COLUMN `lastname`
SET('avgColLen'='6.625','maxColLen'='10','numNulls'='0','numDVs'='16' );
--- BIT VECTORS PRESENT FOR `db_bdpbase`.`default_partition_test` PARTITION
`sports`='Tennis' FOR COLUMN `lastname` BUT THEY ARE NOT SUPPORTED YET. THE
BASE64 VALUE FOR THE BITVECTOR IS
SExMoBAQw9jy4wbApZ6a/v////8B/sPU3fv/////AcCHp9kGgN/fv/r/////AYLFxPn+/////wGBkrK3Av2Ry8cCgc676Pv/////Ab/A89YBxOTiEvzixO/+/////wHD55ygA77R9+T6/////wHFq+mVB7vOpY39/////wE=
-ALTER TABLE `db_bdpbase`.`default_partition_test` PARTITION
(`sports`='Tennis') UPDATE STATISTICS FOR COLUMN `firstname`
SET('avgColLen'='5.875','maxColLen'='10','numNulls'='0','numDVs'='16' );
--- BIT VECTORS PRESENT FOR `db_bdpbase`.`default_partition_test` PARTITION
`sports`='Tennis' FOR COLUMN `firstname` BUT THEY ARE NOT SUPPORTED YET. THE
BASE64 VALUE FOR THE BITVECTOR IS
SExMoBAQgp+Lswf/6/Gw+/////8BgM2YkAPB0+LF/f////8B/8ulC8DngZ0CgJ+o9v//////AcDR9AWBwp7N+v////8BwZT4/QH/qIfj//////8BgP+t//3/////Ab+a5YgDxoiV3QK8+K/t/v////8Bgdruk/7/////AQ==
-ALTER TABLE `db_bdpbase`.`default_partition_test` PARTITION
(`sports`='Tennis') UPDATE STATISTICS FOR COLUMN `id`
SET('lowValue'='1007','highValue'='1086','numNulls'='0','numDVs'='16' );
--- BIT VECTORS PRESENT FOR `db_bdpbase`.`default_partition_test` PARTITION
`sports`='Tennis' FOR COLUMN `id` BUT THEY ARE NOT SUPPORTED YET. THE BASE64
VALUE FOR THE BITVECTOR IS
SExMoBAQgsirL7+NuZgFgJSyrf7/////AcDw1/3//////wGAw9/iAoGurff//////wH//tG+/v////8BhMDytf//////Abya/vb+/////wHCpbPM//////8B/v+D1v7/////AcD2p9r//////wGApJdwwLKYgQTByo7U//////8BwdS26vv/////AQ==
-ALTER TABLE `db_bdpbase`.`default_partition_test` PARTITION
(`sports`='Basketball') UPDATE STATISTICS FOR COLUMN `country`
SET('avgColLen'='8.666666666666666','maxColLen'='16','numNulls'='0','numDVs'='14'
);
--- BIT VECTORS PRESENT FOR `db_bdpbase`.`default_partition_test` PARTITION
`sports`='Basketball' FOR COLUMN `country` BUT THEY ARE NOT SUPPORTED YET. THE
BASE64 VALUE FOR THE BITVECTOR IS
SExMoA4OhdzCtAL8jYW5A8Ce5MX6/////wHAicoqgNKYqAGA+cYigKy/jwGB3qTH/f////8BgNG/hwLDkchH/YOnjf//////Af/knsj9/////wHA+9/oBICtjo7//////wE=
+ALTER TABLE `db_bdpbase`.`default_partition_test` PARTITION
(`sports`='Badminton') UPDATE STATISTICS FOR COLUMN `city`
SET('avgColLen'='7.961538461538462','maxColLen'='15','numNulls'='0','numDVs'='26'
);
+-- BIT VECTORS PRESENT FOR `db_bdpbase`.`default_partition_test` PARTITION
`sports`='Badminton' FOR COLUMN `city` BUT THEY ARE NOT SUPPORTED YET. THE
BASE64 VALUE FOR THE BITVECTOR IS
SExMoBoagcnkoQHDmv3pA/6E55gChOm3qP//////AbzE6Yj7/////wH/jeLHAYC7qMgEgO/pvP//////AYDl7q35/////wHAnoCTBsDeqIT+/////wGArM7x//////8BwdCEL//10sL+/////wGB/Yxrv/G7V8HV1cT7/////wGA/62HA4C7sfsBwJT/rPr/////AYCFgrIBgbbW6P//////Ab707dv//////wGEkeKsBYLSvzy6mZuX+v////8B
+ALTER TABLE `db_bdpbase`.`default_partition_test` PARTITION
(`sports`='Badminton') UPDATE STATISTICS FOR COLUMN `country`
SET('avgColLen'='10.038461538461538','maxColLen'='44','numNulls'='0','numDVs'='26'
);
+-- BIT VECTORS PRESENT FOR `db_bdpbase`.`default_partition_test` PARTITION
`sports`='Badminton' FOR COLUMN `country` BUT THEY ARE NOT SUPPORTED YET. THE
BASE64 VALUE FOR THE BITVECTOR IS
SExMoBoahbLBzAP85PKJ/f////8BwLe62gLD4vSXAYGN3q0B/6Xhi/r/////Ab2osqUFwqq+oQH+tdPa+v////8BgPenYoCwhkKAndeXA4Sn15/+/////wH+le6UAr/epnP/7bOp+v////8BgKHJV4DwkcACg4u68wGB85+S/f////8B/JyLowOAs7kWgYmk8fr/////Af/OrLoDgO721P//////AYGQ3sD7/////wE=
+ALTER TABLE `db_bdpbase`.`default_partition_test` PARTITION
(`sports`='Badminton') UPDATE STATISTICS FOR COLUMN `firstname`
SET('avgColLen'='5.615384615384615','maxColLen'='8','numNulls'='0','numDVs'='25'
);
+-- BIT VECTORS PRESENT FOR `db_bdpbase`.`default_partition_test` PARTITION
`sports`='Badminton' FOR COLUMN `firstname` BUT THEY ARE NOT SUPPORTED YET. THE
BASE64 VALUE FOR THE BITVECTOR IS
SExMoBkZyJCAxAK5lvTQBMDlqKP5/////wHAl7CAA8CbmRzA8faZ/f////8Bgf/q/f//////Ab/LlfIGgNTwqvz/////AcDcuH6Ay4aWAoDC4QXA6L+q/f////8BwPv+XoDLzxPAzvF9waDs/Pz/////AcCQvbL+/////wHAuJKC//////8Bv8CUgAXAzNZPw+WL8vz/////AYD4gCH9tourAcPksWU=
+ALTER TABLE `db_bdpbase`.`default_partition_test` PARTITION
(`sports`='Badminton') UPDATE STATISTICS FOR COLUMN `id`
SET('lowValue'='1004','highValue'='1094','numNulls'='0','numDVs'='26' );
+-- BIT VECTORS PRESENT FOR `db_bdpbase`.`default_partition_test` PARTITION
`sports`='Badminton' FOR COLUMN `id` BUT THEY ARE NOT SUPPORTED YET. THE BASE64
VALUE FOR THE BITVECTOR IS
SExMoBoahd3Cdf32590G/6SLj/3/////AYCykT7Av92e/f////8BwYfGqwP/9oKWAYD4z638/////wGBwrxzv+i89wHA0Niv/f////8BgLL2rgGAstnL+/////8BguuQrAH+1vPaBMG99/D5/////wH//4P6BcDSr2WAnKXH/P////8BgKfB3P3/////AYCTgJEEgqb8+Pv/////AcCCvmq+0O7IAoDBhvb+/////wHA0dlC
+ALTER TABLE `db_bdpbase`.`default_partition_test` PARTITION
(`sports`='Badminton') UPDATE STATISTICS FOR COLUMN `lastname`
SET('avgColLen'='6.269230769230769','maxColLen'='9','numNulls'='0','numDVs'='26'
);
+-- BIT VECTORS PRESENT FOR `db_bdpbase`.`default_partition_test` PARTITION
`sports`='Badminton' FOR COLUMN `lastname` BUT THEY ARE NOT SUPPORTED YET. THE
BASE64 VALUE FOR THE BITVECTOR IS
SExMoBoaw5bxWsDKgKgE/pbs5vz/////AYDw18AEguubl/3/////AcHBj579/////wH9pu6ABYKuotL+/////wH+x+S0//////8BgMj+2QLAjorG+f////8BwJm1pwLBgbeMBL/BgaD8/////wHAuJDKA4CXh93//////wHBuPXl+v////8B//SC/wWAweCB//////8BwMTBhv7/////AYC+l/cBwI3g1fr/////AYTay4cBvtbOsAL//sj+A8Hd+ZH4/////wE=
ALTER TABLE `db_bdpbase`.`default_partition_test` PARTITION
(`sports`='Basketball') UPDATE STATISTICS FOR COLUMN `city`
SET('avgColLen'='9.733333333333333','maxColLen'='26','numNulls'='0','numDVs'='15'
);
-- BIT VECTORS PRESENT FOR `db_bdpbase`.`default_partition_test` PARTITION
`sports`='Basketball' FOR COLUMN `city` BUT THEY ARE NOT SUPPORTED YET. THE
BASE64 VALUE FOR THE BITVECTOR IS
SExMoA8PgZjVoAbAiv9ng+yLbv3bzYP8/////wGFitRK/MrIowP/zYSG+/////8BwvzCl/7/////Af+jp8UBv+6Ctf//////AYGf/9wDv6/ZgQLCvb65+f////8BvsGr/QKAtqUo
-ALTER TABLE `db_bdpbase`.`default_partition_test` PARTITION
(`sports`='Basketball') UPDATE STATISTICS FOR COLUMN `lastname`
SET('avgColLen'='6.2','maxColLen'='8','numNulls'='0','numDVs'='15' );
--- BIT VECTORS PRESENT FOR `db_bdpbase`.`default_partition_test` PARTITION
`sports`='Basketball' FOR COLUMN `lastname` BUT THEY ARE NOT SUPPORTED YET. THE
BASE64 VALUE FOR THE BITVECTOR IS
SExMoA8PgZ/tvgSA18jgAoGZwtb+/////wH/zaeIAcDWpIP//////wGC/43R+/////8B/5/ogwGDhYerAfz89K4DgL6l8v7/////AYDwwZj//////wHAlpaV/f////8BgLqSK8GJg9D9/////wHCiZiWAw==
+ALTER TABLE `db_bdpbase`.`default_partition_test` PARTITION
(`sports`='Basketball') UPDATE STATISTICS FOR COLUMN `country`
SET('avgColLen'='8.666666666666666','maxColLen'='16','numNulls'='0','numDVs'='14'
);
+-- BIT VECTORS PRESENT FOR `db_bdpbase`.`default_partition_test` PARTITION
`sports`='Basketball' FOR COLUMN `country` BUT THEY ARE NOT SUPPORTED YET. THE
BASE64 VALUE FOR THE BITVECTOR IS
SExMoA4OhdzCtAL8jYW5A8Ce5MX6/////wHAicoqgNKYqAGA+cYigKy/jwGB3qTH/f////8BgNG/hwLDkchH/YOnjf//////Af/knsj9/////wHA+9/oBICtjo7//////wE=
ALTER TABLE `db_bdpbase`.`default_partition_test` PARTITION
(`sports`='Basketball') UPDATE STATISTICS FOR COLUMN `firstname`
SET('avgColLen'='6.466666666666667','maxColLen'='9','numNulls'='0','numDVs'='15'
);
-- BIT VECTORS PRESENT FOR `db_bdpbase`.`default_partition_test` PARTITION
`sports`='Basketball' FOR COLUMN `firstname` BUT THEY ARE NOT SUPPORTED YET.
THE BASE64 VALUE FOR THE BITVECTOR IS
SExMoA8PgbilpAeC7+ssvtnsxfj/////AcCW6PAFwLLw9f7/////AcHwo4v9/////wH/nYz3AoGH1J/9/////wH/7Jv7/f////8BxNrM2wK85uvN/v////8BgJnvHMCdv9b//////wGAw7/oBcLAloD5/////wE=
ALTER TABLE `db_bdpbase`.`default_partition_test` PARTITION
(`sports`='Basketball') UPDATE STATISTICS FOR COLUMN `id`
SET('lowValue'='1001','highValue'='1097','numNulls'='0','numDVs'='15' );
-- BIT VECTORS PRESENT FOR `db_bdpbase`.`default_partition_test` PARTITION
`sports`='Basketball' FOR COLUMN `id` BUT THEY ARE NOT SUPPORTED YET. THE
BASE64 VALUE FOR THE BITVECTOR IS
SExMoA8PgYCNxQOA2pic/f////8BxuPc2AP8m7G4A7+Ix+z7/////wG/xNKo/f////8BgLCJswSAxK+U/f////8BgPmo2gHE6pNr/pSPjQK+4MTY+v////8BgIiW4ASEgZT0+/////8B/OCGvQE=
-ALTER TABLE `db_bdpbase`.`default_partition_test` PARTITION
(`sports`='Football') UPDATE STATISTICS FOR COLUMN `country`
SET('avgColLen'='10.826086956521738','maxColLen'='33','numNulls'='0','numDVs'='22'
);
--- BIT VECTORS PRESENT FOR `db_bdpbase`.`default_partition_test` PARTITION
`sports`='Football' FOR COLUMN `country` BUT THEY ARE NOT SUPPORTED YET. THE
BASE64 VALUE FOR THE BITVECTOR IS
SExMoBYWw66T/gX/gadGwYr4n/3/////AYG57zXAkP/9+/////8BvbWmigfB/KHo+v////8BwYzq0gS/zsX3/f////8B//i05Pz/////AcG9m/4D//vz0fz/////AcCqpx3AxKqpAcCF+PACgIGGwPv/////AYSQlM0B/fqH6v//////Af+1/M38/////wGCp8si/pO8vQKC4MSEAQ==
+ALTER TABLE `db_bdpbase`.`default_partition_test` PARTITION
(`sports`='Basketball') UPDATE STATISTICS FOR COLUMN `lastname`
SET('avgColLen'='6.2','maxColLen'='8','numNulls'='0','numDVs'='15' );
+-- BIT VECTORS PRESENT FOR `db_bdpbase`.`default_partition_test` PARTITION
`sports`='Basketball' FOR COLUMN `lastname` BUT THEY ARE NOT SUPPORTED YET. THE
BASE64 VALUE FOR THE BITVECTOR IS
SExMoA8PgZ/tvgSA18jgAoGZwtb+/////wH/zaeIAcDWpIP//////wGC/43R+/////8B/5/ogwGDhYerAfz89K4DgL6l8v7/////AYDwwZj//////wHAlpaV/f////8BgLqSK8GJg9D9/////wHCiZiWAw==
+ALTER TABLE `db_bdpbase`.`default_partition_test` PARTITION
(`sports`='Cricket') UPDATE STATISTICS FOR COLUMN `city`
SET('avgColLen'='9.5','maxColLen'='18','numNulls'='0','numDVs'='14' );
+-- BIT VECTORS PRESENT FOR `db_bdpbase`.`default_partition_test` PARTITION
`sports`='Cricket' FOR COLUMN `city` BUT THEY ARE NOT SUPPORTED YET. THE BASE64
VALUE FOR THE BITVECTOR IS
SExMoA4Owv2KsweAxJ3Y+f////8Bv7aO5QaAo7XI+v////8BwM6p9/3/////AcCGkuoBwYfi6f//////Ab/3+6ICxPu9zwP90YX2//////8BgpXXv/j/////Af3c9qcEgZnkk/z/////Af/BmTE=
+ALTER TABLE `db_bdpbase`.`default_partition_test` PARTITION
(`sports`='Cricket') UPDATE STATISTICS FOR COLUMN `country`
SET('avgColLen'='9.714285714285714','maxColLen'='18','numNulls'='0','numDVs'='14'
);
+-- BIT VECTORS PRESENT FOR `db_bdpbase`.`default_partition_test` PARTITION
`sports`='Cricket' FOR COLUMN `country` BUT THEY ARE NOT SUPPORTED YET. THE
BASE64 VALUE FOR THE BITVECTOR IS
SExMoA4OwanPogfEsvOR+/////8B/M6b8AKCibP3/f////8Bvprl2gLB+fLA//////8B/7zUlv7/////AcXwxLz+/////wG7+JuG/v////8BgPWXlAHB1KGNAv/45vkDwvKSh/n/////AYSysbYC
+ALTER TABLE `db_bdpbase`.`default_partition_test` PARTITION
(`sports`='Cricket') UPDATE STATISTICS FOR COLUMN `firstname`
SET('avgColLen'='5.285714285714286','maxColLen'='9','numNulls'='0','numDVs'='14'
);
+-- BIT VECTORS PRESENT FOR `db_bdpbase`.`default_partition_test` PARTITION
`sports`='Cricket' FOR COLUMN `firstname` BUT THEY ARE NOT SUPPORTED YET. THE
BASE64 VALUE FOR THE BITVECTOR IS
SExMoA4OwbS80wOB6fyi/f////8B/4eU6QKB+P2a/f////8Bw7z4qQT8+8KdAsKaipb9/////wH/pLfZ//////8Bg/367/3/////Af72zOj//////wG+8a95gvbxuf3/////Ab7LzcwFwNTv8Pz/////AQ==
+ALTER TABLE `db_bdpbase`.`default_partition_test` PARTITION
(`sports`='Cricket') UPDATE STATISTICS FOR COLUMN `id`
SET('lowValue'='1002','highValue'='1099','numNulls'='0','numDVs'='14' );
+-- BIT VECTORS PRESENT FOR `db_bdpbase`.`default_partition_test` PARTITION
`sports`='Cricket' FOR COLUMN `id` BUT THEY ARE NOT SUPPORTED YET. THE BASE64
VALUE FOR THE BITVECTOR IS
SExMoA4Owp+5vgXAgIGC+/////8B/6frowTArIixAcCvrknA3Jmv//////8BgIHmBoGA38n6/////wHAhO5lgs76yAG+9dT6Ar+cjO36/////wGAx7GYBML+3Mj8/////wE=
+ALTER TABLE `db_bdpbase`.`default_partition_test` PARTITION
(`sports`='Cricket') UPDATE STATISTICS FOR COLUMN `lastname`
SET('avgColLen'='6.642857142857143','maxColLen'='10','numNulls'='0','numDVs'='14'
);
+-- BIT VECTORS PRESENT FOR `db_bdpbase`.`default_partition_test` PARTITION
`sports`='Cricket' FOR COLUMN `lastname` BUT THEY ARE NOT SUPPORTED YET. THE
BASE64 VALUE FOR THE BITVECTOR IS
SExMoA4Oh/eB3gH6kIqEBoDm49H7/////wGBzfvyAcDCzlTC2eaU/P////8B/q3H8v3/////Af+bxdoFgJL6jPv/////AYG84W//1I1igqC6pwH+kKX+/v////8Bwr362gQ=
ALTER TABLE `db_bdpbase`.`default_partition_test` PARTITION
(`sports`='Football') UPDATE STATISTICS FOR COLUMN `city`
SET('avgColLen'='8.782608695652174','maxColLen'='20','numNulls'='0','numDVs'='23'
);
-- BIT VECTORS PRESENT FOR `db_bdpbase`.`default_partition_test` PARTITION
`sports`='Football' FOR COLUMN `city` BUT THEY ARE NOT SUPPORTED YET. THE
BASE64 VALUE FOR THE BITVECTOR IS
SExMoBcXw7/xvgW/vaexAoD6oqj6/////wHBqdfw//////8BvuPJ1P7/////AYCN2LgDwaXjsv3/////Af+IxJcGwbyujvv/////Af+ttFnBqYmkA7+Yrqb7/////wHAgr+LBIGHpJP9/////wH/iY3oAYDAj7/8/////wGAie6wAYD20A3Cw5oi/ozl0QKAl+LVAcHRpASBoNS9//////8B
-ALTER TABLE `db_bdpbase`.`default_partition_test` PARTITION
(`sports`='Football') UPDATE STATISTICS FOR COLUMN `lastname`
SET('avgColLen'='5.6521739130434785','maxColLen'='8','numNulls'='0','numDVs'='23'
);
--- BIT VECTORS PRESENT FOR `db_bdpbase`.`default_partition_test` PARTITION
`sports`='Football' FOR COLUMN `lastname` BUT THEY ARE NOT SUPPORTED YET. THE
BASE64 VALUE FOR THE BITVECTOR IS
SExMoBcXgqW6lwS/7cK2AsGpjOz7/////wGCm5fW//////8BvbT96wTA5rbf/P////8Bgoq+hwO/6qXp/P////8B/8GzqP7/////AcCqq+L//////wGA5PWu/v////8Bwa37xwa/u+SQ/P////8Bwcrsrf3/////Ab+2k+ADgNahiAHAyNff/v////8BwNftnP7/////AYDDkyfB/tKCA4DswM8Bgoeop/3/////Af3g8/oB
+ALTER TABLE `db_bdpbase`.`default_partition_test` PARTITION
(`sports`='Football') UPDATE STATISTICS FOR COLUMN `country`
SET('avgColLen'='10.826086956521738','maxColLen'='33','numNulls'='0','numDVs'='22'
);
+-- BIT VECTORS PRESENT FOR `db_bdpbase`.`default_partition_test` PARTITION
`sports`='Football' FOR COLUMN `country` BUT THEY ARE NOT SUPPORTED YET. THE
BASE64 VALUE FOR THE BITVECTOR IS
SExMoBYWw66T/gX/gadGwYr4n/3/////AYG57zXAkP/9+/////8BvbWmigfB/KHo+v////8BwYzq0gS/zsX3/f////8B//i05Pz/////AcG9m/4D//vz0fz/////AcCqpx3AxKqpAcCF+PACgIGGwPv/////AYSQlM0B/fqH6v//////Af+1/M38/////wGCp8si/pO8vQKC4MSEAQ==
ALTER TABLE `db_bdpbase`.`default_partition_test` PARTITION
(`sports`='Football') UPDATE STATISTICS FOR COLUMN `firstname`
SET('avgColLen'='5.782608695652174','maxColLen'='9','numNulls'='0','numDVs'='23'
);
-- BIT VECTORS PRESENT FOR `db_bdpbase`.`default_partition_test` PARTITION
`sports`='Football' FOR COLUMN `firstname` BUT THEY ARE NOT SUPPORTED YET. THE
BASE64 VALUE FOR THE BITVECTOR IS
SExMoBcXwbS80wPA08+OBMDEmZT6/////wHA7fi1BMLU84kBvs2zyfr/////AcDRiGfCgsLrA4DDgsb9/////wG+ipqK/v////8BwMjJowWC5Jyw//////8Bv5j19Pn/////AYDBosL//////wHA9t7fAb/QhPkDgJCxk/v/////AYKK0Qb+ra2ZAoOA5Pj//////wH9vuKJAcH15av8/////wGA1v/hAg==
ALTER TABLE `db_bdpbase`.`default_partition_test` PARTITION
(`sports`='Football') UPDATE STATISTICS FOR COLUMN `id`
SET('lowValue'='1006','highValue'='1100','numNulls'='0','numDVs'='23' );
-- BIT VECTORS PRESENT FOR `db_bdpbase`.`default_partition_test` PARTITION
`sports`='Football' FOR COLUMN `id` BUT THEY ARE NOT SUPPORTED YET. THE BASE64
VALUE FOR THE BITVECTOR IS
SExMoBcXgaCXhwXA1P+S/f////8Bg93J8wG91quf/P////8Bg8OW9gG9v/KA//////8Bhbns+AW7mZtJwM2xGcCm2JD7/////wHAzv2WAsDMyob9/////wHCpeL4/v////8Bv4iY4wW/56Sb+f////8BgLbX1QHB2tTlBP+Sqp36/////wGA9fLJAcGhkpcBgIXC0QPBxYbz//////8B/uGZ+vv/////AQ==
--- ALTER TABLE `db_bdpbase`.`default_partition_test` PARTITION
(`sports`='__HIVE_DEFAULT_PARTITION__') UPDATE STATISTICS FOR COLUMN `country`
SET('avgColLen'='9.333333333333334','maxColLen'='15','numNulls'='0','numDVs'='6'
);
--- BIT VECTORS PRESENT FOR `db_bdpbase`.`default_partition_test` PARTITION
`sports`='__HIVE_DEFAULT_PARTITION__' FOR COLUMN `country` BUT THEY ARE NOT
SUPPORTED YET. THE BASE64 VALUE FOR THE BITVECTOR IS
SExMoAYGwaXO9gaA4928+f////8BgoXl0AP/u9nv/v////8BwP3t9gP/wbzN/P////8B
+ALTER TABLE `db_bdpbase`.`default_partition_test` PARTITION
(`sports`='Football') UPDATE STATISTICS FOR COLUMN `lastname`
SET('avgColLen'='5.6521739130434785','maxColLen'='8','numNulls'='0','numDVs'='23'
);
+-- BIT VECTORS PRESENT FOR `db_bdpbase`.`default_partition_test` PARTITION
`sports`='Football' FOR COLUMN `lastname` BUT THEY ARE NOT SUPPORTED YET. THE
BASE64 VALUE FOR THE BITVECTOR IS
SExMoBcXgqW6lwS/7cK2AsGpjOz7/////wGCm5fW//////8BvbT96wTA5rbf/P////8Bgoq+hwO/6qXp/P////8B/8GzqP7/////AcCqq+L//////wGA5PWu/v////8Bwa37xwa/u+SQ/P////8Bwcrsrf3/////Ab+2k+ADgNahiAHAyNff/v////8BwNftnP7/////AYDDkyfB/tKCA4DswM8Bgoeop/3/////Af3g8/oB
+ALTER TABLE `db_bdpbase`.`default_partition_test` PARTITION
(`sports`='Tennis') UPDATE STATISTICS FOR COLUMN `city`
SET('avgColLen'='9.5625','maxColLen'='18','numNulls'='0','numDVs'='16' );
+-- BIT VECTORS PRESENT FOR `db_bdpbase`.`default_partition_test` PARTITION
`sports`='Tennis' FOR COLUMN `city` BUT THEY ARE NOT SUPPORTED YET. THE BASE64
VALUE FOR THE BITVECTOR IS
SExMoBAQgfSH0gPAg7CJAoCl9ljC0YLK//////8B/picz/7/////AcDlwtP7/////wHAl84twIbP+v//////AYCoomaApeWJBoG1lab6/////wH/sNr5AoDjqJr8/////wHBz+68BcCH7fb9/////wH/+7xK
+ALTER TABLE `db_bdpbase`.`default_partition_test` PARTITION
(`sports`='Tennis') UPDATE STATISTICS FOR COLUMN `country`
SET('avgColLen'='9.5625','maxColLen'='27','numNulls'='0','numDVs'='16' );
+-- BIT VECTORS PRESENT FOR `db_bdpbase`.`default_partition_test` PARTITION
`sports`='Tennis' FOR COLUMN `country` BUT THEY ARE NOT SUPPORTED YET. THE
BASE64 VALUE FOR THE BITVECTOR IS
SExMoBAQweClxwTAto6P/P////8Bg5qv8gO9nZOuAYWnjJT8/////wH7y9SkAoD13gGBtJOV/v////8BgqrYtf7/////Af3z25EEgbjb3wK/2Jud//////8BgZbmgvr/////Af+XtN4Dga/pvP//////AcH6mY8B
+ALTER TABLE `db_bdpbase`.`default_partition_test` PARTITION
(`sports`='Tennis') UPDATE STATISTICS FOR COLUMN `firstname`
SET('avgColLen'='5.875','maxColLen'='10','numNulls'='0','numDVs'='16' );
+-- BIT VECTORS PRESENT FOR `db_bdpbase`.`default_partition_test` PARTITION
`sports`='Tennis' FOR COLUMN `firstname` BUT THEY ARE NOT SUPPORTED YET. THE
BASE64 VALUE FOR THE BITVECTOR IS
SExMoBAQgp+Lswf/6/Gw+/////8BgM2YkAPB0+LF/f////8B/8ulC8DngZ0CgJ+o9v//////AcDR9AWBwp7N+v////8BwZT4/QH/qIfj//////8BgP+t//3/////Ab+a5YgDxoiV3QK8+K/t/v////8Bgdruk/7/////AQ==
+ALTER TABLE `db_bdpbase`.`default_partition_test` PARTITION
(`sports`='Tennis') UPDATE STATISTICS FOR COLUMN `id`
SET('lowValue'='1007','highValue'='1086','numNulls'='0','numDVs'='16' );
+-- BIT VECTORS PRESENT FOR `db_bdpbase`.`default_partition_test` PARTITION
`sports`='Tennis' FOR COLUMN `id` BUT THEY ARE NOT SUPPORTED YET. THE BASE64
VALUE FOR THE BITVECTOR IS
SExMoBAQgsirL7+NuZgFgJSyrf7/////AcDw1/3//////wGAw9/iAoGurff//////wH//tG+/v////8BhMDytf//////Abya/vb+/////wHCpbPM//////8B/v+D1v7/////AcD2p9r//////wGApJdwwLKYgQTByo7U//////8BwdS26vv/////AQ==
+ALTER TABLE `db_bdpbase`.`default_partition_test` PARTITION
(`sports`='Tennis') UPDATE STATISTICS FOR COLUMN `lastname`
SET('avgColLen'='6.625','maxColLen'='10','numNulls'='0','numDVs'='16' );
+-- BIT VECTORS PRESENT FOR `db_bdpbase`.`default_partition_test` PARTITION
`sports`='Tennis' FOR COLUMN `lastname` BUT THEY ARE NOT SUPPORTED YET. THE
BASE64 VALUE FOR THE BITVECTOR IS
SExMoBAQw9jy4wbApZ6a/v////8B/sPU3fv/////AcCHp9kGgN/fv/r/////AYLFxPn+/////wGBkrK3Av2Ry8cCgc676Pv/////Ab/A89YBxOTiEvzixO/+/////wHD55ygA77R9+T6/////wHFq+mVB7vOpY39/////wE=
-- ALTER TABLE `db_bdpbase`.`default_partition_test` PARTITION
(`sports`='__HIVE_DEFAULT_PARTITION__') UPDATE STATISTICS FOR COLUMN `city`
SET('avgColLen'='10.5','maxColLen'='17','numNulls'='0','numDVs'='6' );
-- BIT VECTORS PRESENT FOR `db_bdpbase`.`default_partition_test` PARTITION
`sports`='__HIVE_DEFAULT_PARTITION__' FOR COLUMN `city` BUT THEY ARE NOT
SUPPORTED YET. THE BASE64 VALUE FOR THE BITVECTOR IS
SExMoAYGwaGlyQKAyt+3AYCs6oQBwt6jv/7/////Af/P9r4C//fig/v/////AQ==
--- ALTER TABLE `db_bdpbase`.`default_partition_test` PARTITION
(`sports`='__HIVE_DEFAULT_PARTITION__') UPDATE STATISTICS FOR COLUMN `lastname`
SET('avgColLen'='6.333333333333333','maxColLen'='8','numNulls'='0','numDVs'='6'
);
--- BIT VECTORS PRESENT FOR `db_bdpbase`.`default_partition_test` PARTITION
`sports`='__HIVE_DEFAULT_PARTITION__' FOR COLUMN `lastname` BUT THEY ARE NOT
SUPPORTED YET. THE BASE64 VALUE FOR THE BITVECTOR IS
SExMoAYGgbePuQfB9sjg+P////8Bw93qogW83dm9/P////8BwYbtqQK/yYTa/v////8B
+-- ALTER TABLE `db_bdpbase`.`default_partition_test` PARTITION
(`sports`='__HIVE_DEFAULT_PARTITION__') UPDATE STATISTICS FOR COLUMN `country`
SET('avgColLen'='9.333333333333334','maxColLen'='15','numNulls'='0','numDVs'='6'
);
+-- BIT VECTORS PRESENT FOR `db_bdpbase`.`default_partition_test` PARTITION
`sports`='__HIVE_DEFAULT_PARTITION__' FOR COLUMN `country` BUT THEY ARE NOT
SUPPORTED YET. THE BASE64 VALUE FOR THE BITVECTOR IS
SExMoAYGwaXO9gaA4928+f////8BgoXl0AP/u9nv/v////8BwP3t9gP/wbzN/P////8B
-- ALTER TABLE `db_bdpbase`.`default_partition_test` PARTITION
(`sports`='__HIVE_DEFAULT_PARTITION__') UPDATE STATISTICS FOR COLUMN
`firstname` SET('avgColLen'='7.0','maxColLen'='9','numNulls'='0','numDVs'='6' );
-- BIT VECTORS PRESENT FOR `db_bdpbase`.`default_partition_test` PARTITION
`sports`='__HIVE_DEFAULT_PARTITION__' FOR COLUMN `firstname` BUT THEY ARE NOT
SUPPORTED YET. THE BASE64 VALUE FOR THE BITVECTOR IS
SExMoAYGwe3GFsGq05QBv6XU8P7/////AYHCq/AGwJ7v2Pr/////AcG15yw=
-- ALTER TABLE `db_bdpbase`.`default_partition_test` PARTITION
(`sports`='__HIVE_DEFAULT_PARTITION__') UPDATE STATISTICS FOR COLUMN `id`
SET('lowValue'='1005','highValue'='1098','numNulls'='0','numDVs'='6' );
-- BIT VECTORS PRESENT FOR `db_bdpbase`.`default_partition_test` PARTITION
`sports`='__HIVE_DEFAULT_PARTITION__' FOR COLUMN `id` BUT THEY ARE NOT
SUPPORTED YET. THE BASE64 VALUE FOR THE BITVECTOR IS
SExMoAYGgeXMkgKAqeDgAYDOgWfAjve+/P////8Bga6jv///////Af/B69cD
-ALTER TABLE `db_bdpbase`.`default_partition_test` PARTITION
(`sports`='Cricket') UPDATE STATISTICS FOR COLUMN `country`
SET('avgColLen'='9.714285714285714','maxColLen'='18','numNulls'='0','numDVs'='14'
);
--- BIT VECTORS PRESENT FOR `db_bdpbase`.`default_partition_test` PARTITION
`sports`='Cricket' FOR COLUMN `country` BUT THEY ARE NOT SUPPORTED YET. THE
BASE64 VALUE FOR THE BITVECTOR IS
SExMoA4OwanPogfEsvOR+/////8B/M6b8AKCibP3/f////8Bvprl2gLB+fLA//////8B/7zUlv7/////AcXwxLz+/////wG7+JuG/v////8BgPWXlAHB1KGNAv/45vkDwvKSh/n/////AYSysbYC
-ALTER TABLE `db_bdpbase`.`default_partition_test` PARTITION
(`sports`='Cricket') UPDATE STATISTICS FOR COLUMN `city`
SET('avgColLen'='9.5','maxColLen'='18','numNulls'='0','numDVs'='14' );
--- BIT VECTORS PRESENT FOR `db_bdpbase`.`default_partition_test` PARTITION
`sports`='Cricket' FOR COLUMN `city` BUT THEY ARE NOT SUPPORTED YET. THE BASE64
VALUE FOR THE BITVECTOR IS
SExMoA4Owv2KsweAxJ3Y+f////8Bv7aO5QaAo7XI+v////8BwM6p9/3/////AcCGkuoBwYfi6f//////Ab/3+6ICxPu9zwP90YX2//////8BgpXXv/j/////Af3c9qcEgZnkk/z/////Af/BmTE=
-ALTER TABLE `db_bdpbase`.`default_partition_test` PARTITION
(`sports`='Cricket') UPDATE STATISTICS FOR COLUMN `lastname`
SET('avgColLen'='6.642857142857143','maxColLen'='10','numNulls'='0','numDVs'='14'
);
--- BIT VECTORS PRESENT FOR `db_bdpbase`.`default_partition_test` PARTITION
`sports`='Cricket' FOR COLUMN `lastname` BUT THEY ARE NOT SUPPORTED YET. THE
BASE64 VALUE FOR THE BITVECTOR IS
SExMoA4Oh/eB3gH6kIqEBoDm49H7/////wGBzfvyAcDCzlTC2eaU/P////8B/q3H8v3/////Af+bxdoFgJL6jPv/////AYG84W//1I1igqC6pwH+kKX+/v////8Bwr362gQ=
-ALTER TABLE `db_bdpbase`.`default_partition_test` PARTITION
(`sports`='Cricket') UPDATE STATISTICS FOR COLUMN `firstname`
SET('avgColLen'='5.285714285714286','maxColLen'='9','numNulls'='0','numDVs'='14'
);
--- BIT VECTORS PRESENT FOR `db_bdpbase`.`default_partition_test` PARTITION
`sports`='Cricket' FOR COLUMN `firstname` BUT THEY ARE NOT SUPPORTED YET. THE
BASE64 VALUE FOR THE BITVECTOR IS
SExMoA4OwbS80wOB6fyi/f////8B/4eU6QKB+P2a/f////8Bw7z4qQT8+8KdAsKaipb9/////wH/pLfZ//////8Bg/367/3/////Af72zOj//////wG+8a95gvbxuf3/////Ab7LzcwFwNTv8Pz/////AQ==
-ALTER TABLE `db_bdpbase`.`default_partition_test` PARTITION
(`sports`='Cricket') UPDATE STATISTICS FOR COLUMN `id`
SET('lowValue'='1002','highValue'='1099','numNulls'='0','numDVs'='14' );
--- BIT VECTORS PRESENT FOR `db_bdpbase`.`default_partition_test` PARTITION
`sports`='Cricket' FOR COLUMN `id` BUT THEY ARE NOT SUPPORTED YET. THE BASE64
VALUE FOR THE BITVECTOR IS
SExMoA4Owp+5vgXAgIGC+/////8B/6frowTArIixAcCvrknA3Jmv//////8BgIHmBoGA38n6/////wHAhO5lgs76yAG+9dT6Ar+cjO36/////wGAx7GYBML+3Mj8/////wE=
-ALTER TABLE `db_bdpbase`.`default_partition_test` PARTITION
(`sports`='Badminton') UPDATE STATISTICS FOR COLUMN `country`
SET('avgColLen'='10.038461538461538','maxColLen'='44','numNulls'='0','numDVs'='26'
);
--- BIT VECTORS PRESENT FOR `db_bdpbase`.`default_partition_test` PARTITION
`sports`='Badminton' FOR COLUMN `country` BUT THEY ARE NOT SUPPORTED YET. THE
BASE64 VALUE FOR THE BITVECTOR IS
SExMoBoahbLBzAP85PKJ/f////8BwLe62gLD4vSXAYGN3q0B/6Xhi/r/////Ab2osqUFwqq+oQH+tdPa+v////8BgPenYoCwhkKAndeXA4Sn15/+/////wH+le6UAr/epnP/7bOp+v////8BgKHJV4DwkcACg4u68wGB85+S/f////8B/JyLowOAs7kWgYmk8fr/////Af/OrLoDgO721P//////AYGQ3sD7/////wE=
-ALTER TABLE `db_bdpbase`.`default_partition_test` PARTITION
(`sports`='Badminton') UPDATE STATISTICS FOR COLUMN `city`
SET('avgColLen'='7.961538461538462','maxColLen'='15','numNulls'='0','numDVs'='26'
);
--- BIT VECTORS PRESENT FOR `db_bdpbase`.`default_partition_test` PARTITION
`sports`='Badminton' FOR COLUMN `city` BUT THEY ARE NOT SUPPORTED YET. THE
BASE64 VALUE FOR THE BITVECTOR IS
SExMoBoagcnkoQHDmv3pA/6E55gChOm3qP//////AbzE6Yj7/////wH/jeLHAYC7qMgEgO/pvP//////AYDl7q35/////wHAnoCTBsDeqIT+/////wGArM7x//////8BwdCEL//10sL+/////wGB/Yxrv/G7V8HV1cT7/////wGA/62HA4C7sfsBwJT/rPr/////AYCFgrIBgbbW6P//////Ab707dv//////wGEkeKsBYLSvzy6mZuX+v////8B
-ALTER TABLE `db_bdpbase`.`default_partition_test` PARTITION
(`sports`='Badminton') UPDATE STATISTICS FOR COLUMN `lastname`
SET('avgColLen'='6.269230769230769','maxColLen'='9','numNulls'='0','numDVs'='26'
);
--- BIT VECTORS PRESENT FOR `db_bdpbase`.`default_partition_test` PARTITION
`sports`='Badminton' FOR COLUMN `lastname` BUT THEY ARE NOT SUPPORTED YET. THE
BASE64 VALUE FOR THE BITVECTOR IS
SExMoBoaw5bxWsDKgKgE/pbs5vz/////AYDw18AEguubl/3/////AcHBj579/////wH9pu6ABYKuotL+/////wH+x+S0//////8BgMj+2QLAjorG+f////8BwJm1pwLBgbeMBL/BgaD8/////wHAuJDKA4CXh93//////wHBuPXl+v////8B//SC/wWAweCB//////8BwMTBhv7/////AYC+l/cBwI3g1fr/////AYTay4cBvtbOsAL//sj+A8Hd+ZH4/////wE=
-ALTER TABLE `db_bdpbase`.`default_partition_test` PARTITION
(`sports`='Badminton') UPDATE STATISTICS FOR COLUMN `firstname`
SET('avgColLen'='5.615384615384615','maxColLen'='8','numNulls'='0','numDVs'='25'
);
--- BIT VECTORS PRESENT FOR `db_bdpbase`.`default_partition_test` PARTITION
`sports`='Badminton' FOR COLUMN `firstname` BUT THEY ARE NOT SUPPORTED YET. THE
BASE64 VALUE FOR THE BITVECTOR IS
SExMoBkZyJCAxAK5lvTQBMDlqKP5/////wHAl7CAA8CbmRzA8faZ/f////8Bgf/q/f//////Ab/LlfIGgNTwqvz/////AcDcuH6Ay4aWAoDC4QXA6L+q/f////8BwPv+XoDLzxPAzvF9waDs/Pz/////AcCQvbL+/////wHAuJKC//////8Bv8CUgAXAzNZPw+WL8vz/////AYD4gCH9tourAcPksWU=
-ALTER TABLE `db_bdpbase`.`default_partition_test` PARTITION
(`sports`='Badminton') UPDATE STATISTICS FOR COLUMN `id`
SET('lowValue'='1004','highValue'='1094','numNulls'='0','numDVs'='26' );
--- BIT VECTORS PRESENT FOR `db_bdpbase`.`default_partition_test` PARTITION
`sports`='Badminton' FOR COLUMN `id` BUT THEY ARE NOT SUPPORTED YET. THE BASE64
VALUE FOR THE BITVECTOR IS
SExMoBoahd3Cdf32590G/6SLj/3/////AYCykT7Av92e/f////8BwYfGqwP/9oKWAYD4z638/////wGBwrxzv+i89wHA0Niv/f////8BgLL2rgGAstnL+/////8BguuQrAH+1vPaBMG99/D5/////wH//4P6BcDSr2WAnKXH/P////8BgKfB3P3/////AYCTgJEEgqb8+Pv/////AcCCvmq+0O7IAoDBhvb+/////wHA0dlC
+-- ALTER TABLE `db_bdpbase`.`default_partition_test` PARTITION
(`sports`='__HIVE_DEFAULT_PARTITION__') UPDATE STATISTICS FOR COLUMN `lastname`
SET('avgColLen'='6.333333333333333','maxColLen'='8','numNulls'='0','numDVs'='6'
);
+-- BIT VECTORS PRESENT FOR `db_bdpbase`.`default_partition_test` PARTITION
`sports`='__HIVE_DEFAULT_PARTITION__' FOR COLUMN `lastname` BUT THEY ARE NOT
SUPPORTED YET. THE BASE64 VALUE FOR THE BITVECTOR IS
SExMoAYGgbePuQfB9sjg+P////8Bw93qogW83dm9/P////8BwYbtqQK/yYTa/v////8B
@@ -1082,14 +1082,14 @@ ALTER TABLE `default`.`test_partitions` ADD IF NOT
EXISTS PARTITION (`c`='str1',
ALTER TABLE `default`.`test_partitions` PARTITION
(`c`='str1',`d`='1970-01-01',`e`=1) UPDATE STATISTICS
SET('numRows'='1','rawDataSize'='6' );
ALTER TABLE `default`.`test_partitions` ADD IF NOT EXISTS PARTITION
(`c`='str2',`d`='1970-02-02',`e`=2);
ALTER TABLE `default`.`test_partitions` PARTITION
(`c`='str2',`d`='1970-02-02',`e`=2) UPDATE STATISTICS
SET('numRows'='1','rawDataSize'='6' );
-ALTER TABLE `default`.`test_partitions` PARTITION
(`c`='str1',`d`='1970-01-01',`e`=1) UPDATE STATISTICS FOR COLUMN `b`
SET('avgColLen'='3.0','maxColLen'='3','numNulls'='0','numDVs'='1' );
--- BIT VECTORS PRESENT FOR `default`.`test_partitions` PARTITION
`c`='str1',`d`='1970-01-01',`e`=1 FOR COLUMN `b` BUT THEY ARE NOT SUPPORTED
YET. THE BASE64 VALUE FOR THE BITVECTOR IS SExMoAEBw8Gy1wE=
ALTER TABLE `default`.`test_partitions` PARTITION
(`c`='str1',`d`='1970-01-01',`e`=1) UPDATE STATISTICS FOR COLUMN `a`
SET('lowValue'='0','highValue'='0','numNulls'='1','numDVs'='1' );
-- BIT VECTORS PRESENT FOR `default`.`test_partitions` PARTITION
`c`='str1',`d`='1970-01-01',`e`=1 FOR COLUMN `a` BUT THEY ARE NOT SUPPORTED
YET. THE BASE64 VALUE FOR THE BITVECTOR IS SExMoAEA
-ALTER TABLE `default`.`test_partitions` PARTITION
(`c`='str2',`d`='1970-02-02',`e`=2) UPDATE STATISTICS FOR COLUMN `b`
SET('avgColLen'='3.0','maxColLen'='3','numNulls'='0','numDVs'='1' );
--- BIT VECTORS PRESENT FOR `default`.`test_partitions` PARTITION
`c`='str2',`d`='1970-02-02',`e`=2 FOR COLUMN `b` BUT THEY ARE NOT SUPPORTED
YET. THE BASE64 VALUE FOR THE BITVECTOR IS SExMoAEBgYOGywQ=
+ALTER TABLE `default`.`test_partitions` PARTITION
(`c`='str1',`d`='1970-01-01',`e`=1) UPDATE STATISTICS FOR COLUMN `b`
SET('avgColLen'='3.0','maxColLen'='3','numNulls'='0','numDVs'='1' );
+-- BIT VECTORS PRESENT FOR `default`.`test_partitions` PARTITION
`c`='str1',`d`='1970-01-01',`e`=1 FOR COLUMN `b` BUT THEY ARE NOT SUPPORTED
YET. THE BASE64 VALUE FOR THE BITVECTOR IS SExMoAEBw8Gy1wE=
ALTER TABLE `default`.`test_partitions` PARTITION
(`c`='str2',`d`='1970-02-02',`e`=2) UPDATE STATISTICS FOR COLUMN `a`
SET('lowValue'='0','highValue'='0','numNulls'='1','numDVs'='1' );
-- BIT VECTORS PRESENT FOR `default`.`test_partitions` PARTITION
`c`='str2',`d`='1970-02-02',`e`=2 FOR COLUMN `a` BUT THEY ARE NOT SUPPORTED
YET. THE BASE64 VALUE FOR THE BITVECTOR IS SExMoAEA
+ALTER TABLE `default`.`test_partitions` PARTITION
(`c`='str2',`d`='1970-02-02',`e`=2) UPDATE STATISTICS FOR COLUMN `b`
SET('avgColLen'='3.0','maxColLen'='3','numNulls'='0','numDVs'='1' );
+-- BIT VECTORS PRESENT FOR `default`.`test_partitions` PARTITION
`c`='str2',`d`='1970-02-02',`e`=2 FOR COLUMN `b` BUT THEY ARE NOT SUPPORTED
YET. THE BASE64 VALUE FOR THE BITVECTOR IS SExMoAEBgYOGywQ=
diff --git a/ql/src/test/results/clientpositive/llap/views_explain_ddl.q.out
b/ql/src/test/results/clientpositive/llap/views_explain_ddl.q.out
index f93a1a2f4e5..817aa06632b 100644
--- a/ql/src/test/results/clientpositive/llap/views_explain_ddl.q.out
+++ b/ql/src/test/results/clientpositive/llap/views_explain_ddl.q.out
@@ -274,7 +274,7 @@ POSTHOOK: Input: db1@table2_n13
POSTHOOK: Input: db1@v3_n3
#### A masked pattern was here ####
CREATE DATABASE IF NOT EXISTS `db1`;
-CREATE TABLE `db1`.`table2_n13`(
+CREATE TABLE `db1`.`table1_n19`(
`key` string,
`value` string)
ROW FORMAT SERDE
@@ -288,7 +288,7 @@ LOCATION
TBLPROPERTIES (
'bucketing_version'='2',
#### A masked pattern was here ####
-CREATE TABLE `db1`.`table1_n19`(
+CREATE TABLE `db1`.`table2_n13`(
`key` string,
`value` string)
ROW FORMAT SERDE
@@ -302,8 +302,8 @@ LOCATION
TBLPROPERTIES (
'bucketing_version'='2',
#### A masked pattern was here ####
-ALTER TABLE `db1`.`table2_n13` UPDATE STATISTICS
SET('numRows'='0','rawDataSize'='0' );
ALTER TABLE `db1`.`table1_n19` UPDATE STATISTICS
SET('numRows'='0','rawDataSize'='0' );
+ALTER TABLE `db1`.`table2_n13` UPDATE STATISTICS
SET('numRows'='0','rawDataSize'='0' );
CREATE VIEW `db1`.`v3_n3` AS SELECT `t1`.`key`, `t1`.`value`, `t2`.`key` `k`
FROM `db1`.`table1_n19` `t1` JOIN `db1`.`table2_n13` `t2` ON `t1`.`key` =
`t2`.`key`;
@@ -558,7 +558,7 @@ POSTHOOK: Input: db1@table2_n13
POSTHOOK: Input: db1@v6
#### A masked pattern was here ####
CREATE DATABASE IF NOT EXISTS `db1`;
-CREATE TABLE `db1`.`table2_n13`(
+CREATE TABLE `db1`.`table1_n19`(
`key` string,
`value` string)
ROW FORMAT SERDE
@@ -572,7 +572,7 @@ LOCATION
TBLPROPERTIES (
'bucketing_version'='2',
#### A masked pattern was here ####
-CREATE TABLE `db1`.`table1_n19`(
+CREATE TABLE `db1`.`table2_n13`(
`key` string,
`value` string)
ROW FORMAT SERDE
@@ -586,8 +586,8 @@ LOCATION
TBLPROPERTIES (
'bucketing_version'='2',
#### A masked pattern was here ####
-ALTER TABLE `db1`.`table2_n13` UPDATE STATISTICS
SET('numRows'='0','rawDataSize'='0' );
ALTER TABLE `db1`.`table1_n19` UPDATE STATISTICS
SET('numRows'='0','rawDataSize'='0' );
+ALTER TABLE `db1`.`table2_n13` UPDATE STATISTICS
SET('numRows'='0','rawDataSize'='0' );
CREATE VIEW `db1`.`v6` AS SELECT `t1`.`key`, `t1`.`value`, `t2`.`key` `k` FROM
`db1`.`table1_n19` `t1` JOIN `db1`.`table2_n13` `t2` ON `t1`.`key` = `t2`.`key`;
