You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "github-actions[bot] (via GitHub)" <gi...@apache.org> on 2023/08/11 08:03:16 UTC
[GitHub] [doris] github-actions[bot] commented on pull request #22881: [Enhancement] submit Baidu test cases
github-actions[bot] commented on PR #22881:
URL: https://github.com/apache/doris/pull/22881#issuecomment-1674355803
#### `sh-checker report`
To get the full details, please check in the [job]("https://github.com/apache/doris/actions/runs/5830291325") output.
<details>
<summary>shellcheck errors</summary>
```
'shellcheck ' returned error 1 finding the following syntactical issues:
----------
In pytest/deploy/qe/init_data.sh line 21:
cd ../../hdfs/data/qe/
^--------------------^ SC2164 (warning): Use 'cd ... || exit' or 'cd ... || return' in case cd fails.
Did you mean:
cd ../../hdfs/data/qe/ || exit
In pytest/deploy/qe/init_data.sh line 23:
mysql -h ${FE_HOST} -P${FE_QUERY_PORT} -uroot -p${FE_PASSWORD} -e "DROP DATABASE IF EXISTS ${FE_DB}"
^--------^ SC2154 (warning): FE_HOST is referenced but not assigned.
^--------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------------^ SC2154 (warning): FE_QUERY_PORT is referenced but not assigned.
^--------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^------------^ SC2154 (warning): FE_PASSWORD is referenced but not assigned.
^------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^------^ SC2154 (warning): FE_DB is referenced but not assigned.
Did you mean:
mysql -h "${FE_HOST}" -P"${FE_QUERY_PORT}" -uroot -p"${FE_PASSWORD}" -e "DROP DATABASE IF EXISTS ${FE_DB}"
In pytest/deploy/qe/init_data.sh line 24:
mysql -h ${FE_HOST} -P${FE_QUERY_PORT} -uroot -p${FE_PASSWORD} -e "create database ${FE_DB}"
^--------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
Did you mean:
mysql -h "${FE_HOST}" -P"${FE_QUERY_PORT}" -uroot -p"${FE_PASSWORD}" -e "create database ${FE_DB}"
In pytest/deploy/qe/init_data.sh line 26:
mysql -h ${FE_HOST} -P${FE_QUERY_PORT} -uroot -p${FE_PASSWORD} ${FE_DB} -e 'create table baseall(k1 tinyint, k2 smallint, k3 int, k4 bigint, k5 decimal(9,3), k6 char(5), k10 date, k11 datetime, k7 varchar(20), k8 double max, k9 float sum) engine=olap distributed by hash(k1) buckets 5 properties("storage_type"="column")'
^--------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^------^ SC2086 (info): Double quote to prevent globbing and word splitting.
Did you mean:
mysql -h "${FE_HOST}" -P"${FE_QUERY_PORT}" -uroot -p"${FE_PASSWORD}" "${FE_DB}" -e 'create table baseall(k1 tinyint, k2 smallint, k3 int, k4 bigint, k5 decimal(9,3), k6 char(5), k10 date, k11 datetime, k7 varchar(20), k8 double max, k9 float sum) engine=olap distributed by hash(k1) buckets 5 properties("storage_type"="column")'
In pytest/deploy/qe/init_data.sh line 27:
curl --location-trusted -T baseall.txt -u root:${FE_PASSWORD} http://${FE_HOST}:${FE_WEB_PORT}/api/${FE_DB}/baseall/_stream_load
^------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^------------^ SC2154 (warning): FE_WEB_PORT is referenced but not assigned.
^------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^------^ SC2086 (info): Double quote to prevent globbing and word splitting.
Did you mean:
curl --location-trusted -T baseall.txt -u root:"${FE_PASSWORD}" http://"${FE_HOST}":"${FE_WEB_PORT}"/api/"${FE_DB}"/baseall/_stream_load
In pytest/deploy/qe/init_data.sh line 29:
mysql -h ${FE_HOST} -P${FE_QUERY_PORT} -uroot -p${FE_PASSWORD} ${FE_DB} -e 'create table test(k1 tinyint, k2 smallint, k3 int, k4 bigint, k5 decimal(9,3), k6 char(5), k10 date, k11 datetime, k7 varchar(20), k8 double max, k9 float sum) engine=olap distributed by hash(k1) buckets 5 properties("storage_type"="column")'
^--------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^------^ SC2086 (info): Double quote to prevent globbing and word splitting.
Did you mean:
mysql -h "${FE_HOST}" -P"${FE_QUERY_PORT}" -uroot -p"${FE_PASSWORD}" "${FE_DB}" -e 'create table test(k1 tinyint, k2 smallint, k3 int, k4 bigint, k5 decimal(9,3), k6 char(5), k10 date, k11 datetime, k7 varchar(20), k8 double max, k9 float sum) engine=olap distributed by hash(k1) buckets 5 properties("storage_type"="column")'
In pytest/deploy/qe/init_data.sh line 30:
curl --location-trusted -T baseall.txt -u root:${FE_PASSWORD} http://${FE_HOST}:${FE_WEB_PORT}/api/${FE_DB}/test/_stream_load
^------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^------^ SC2086 (info): Double quote to prevent globbing and word splitting.
Did you mean:
curl --location-trusted -T baseall.txt -u root:"${FE_PASSWORD}" http://"${FE_HOST}":"${FE_WEB_PORT}"/api/"${FE_DB}"/test/_stream_load
In pytest/deploy/qe/init_data.sh line 31:
curl --location-trusted -T xaaa -u root:${FE_PASSWORD} http://${FE_HOST}:${FE_WEB_PORT}/api/${FE_DB}/test/_stream_load
^------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^------^ SC2086 (info): Double quote to prevent globbing and word splitting.
Did you mean:
curl --location-trusted -T xaaa -u root:"${FE_PASSWORD}" http://"${FE_HOST}":"${FE_WEB_PORT}"/api/"${FE_DB}"/test/_stream_load
In pytest/deploy/qe/init_data.sh line 33:
mysql -h ${FE_HOST} -P${FE_QUERY_PORT} -uroot -p${FE_PASSWORD} ${FE_DB} -e 'create table bigtable(k1 tinyint, k2 smallint, k3 int, k4 bigint, k5 decimal(9,3), k6 char(5), k10 date, k11 datetime, k7 varchar(20), k8 double max, k9 float sum) engine=olap distributed by hash(k1) buckets 5 properties("storage_type"="column")'
^--------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^------^ SC2086 (info): Double quote to prevent globbing and word splitting.
Did you mean:
mysql -h "${FE_HOST}" -P"${FE_QUERY_PORT}" -uroot -p"${FE_PASSWORD}" "${FE_DB}" -e 'create table bigtable(k1 tinyint, k2 smallint, k3 int, k4 bigint, k5 decimal(9,3), k6 char(5), k10 date, k11 datetime, k7 varchar(20), k8 double max, k9 float sum) engine=olap distributed by hash(k1) buckets 5 properties("storage_type"="column")'
In pytest/deploy/qe/init_data.sh line 34:
curl --location-trusted -T baseall.txt -u root:${FE_PASSWORD} http://${FE_HOST}:${FE_WEB_PORT}/api/${FE_DB}/bigtable/_stream_load
^------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^------^ SC2086 (info): Double quote to prevent globbing and word splitting.
Did you mean:
curl --location-trusted -T baseall.txt -u root:"${FE_PASSWORD}" http://"${FE_HOST}":"${FE_WEB_PORT}"/api/"${FE_DB}"/bigtable/_stream_load
In pytest/deploy/qe/init_data_broker.sh line 24:
mysql -h ${FE_HOST} -P${FE_QUERY_PORT} -uroot -p${FE_PASSWORD} -e "DROP DATABASE IF EXISTS ${FE_DB}"
^--------^ SC2154 (warning): FE_HOST is referenced but not assigned.
^--------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------------^ SC2154 (warning): FE_QUERY_PORT is referenced but not assigned.
^--------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^------------^ SC2154 (warning): FE_PASSWORD is referenced but not assigned.
^------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^------^ SC2154 (warning): FE_DB is referenced but not assigned.
Did you mean:
mysql -h "${FE_HOST}" -P"${FE_QUERY_PORT}" -uroot -p"${FE_PASSWORD}" -e "DROP DATABASE IF EXISTS ${FE_DB}"
In pytest/deploy/qe/init_data_broker.sh line 25:
mysql -h ${FE_HOST} -P${FE_QUERY_PORT} -uroot -p${FE_PASSWORD} -e "create database ${FE_DB}"
^--------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
Did you mean:
mysql -h "${FE_HOST}" -P"${FE_QUERY_PORT}" -uroot -p"${FE_PASSWORD}" -e "create database ${FE_DB}"
In pytest/deploy/qe/init_data_broker.sh line 27:
mysql -h ${FE_HOST} -P${FE_QUERY_PORT} -uroot -p${FE_PASSWORD} -e "create table ${FE_DB}.baseall(k1 tinyint, k2 smallint, k3 int, k4 bigint, k5 decimal(9,3), k6 char(5), k10 date, k11 datetime, k7 varchar(20), k8 double max, k9 float sum) engine=olap distributed by hash(k1) buckets 5 properties('storage_type'='column')"
^--------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
Did you mean:
mysql -h "${FE_HOST}" -P"${FE_QUERY_PORT}" -uroot -p"${FE_PASSWORD}" -e "create table ${FE_DB}.baseall(k1 tinyint, k2 smallint, k3 int, k4 bigint, k5 decimal(9,3), k6 char(5), k10 date, k11 datetime, k7 varchar(20), k8 double max, k9 float sum) engine=olap distributed by hash(k1) buckets 5 properties('storage_type'='column')"
In pytest/deploy/qe/init_data_broker.sh line 28:
mysql -h ${FE_HOST} -P${FE_QUERY_PORT} -uroot -p${FE_PASSWORD} -e "create table ${FE_DB}.test(k1 tinyint, k2 smallint, k3 int, k4 bigint, k5 decimal(9,3), k6 char(5), k10 date, k11 datetime, k7 varchar(20), k8 double max, k9 float sum) engine=olap partition by range(k1) (partition p1 values less than ('-64'), partition p2 values less than ('0'), partition p3 values less than ('64'), partition p4 values less than maxvalue ) distributed by hash(k1) buckets 5 properties('storage_type'='column')"
^--------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
Did you mean:
mysql -h "${FE_HOST}" -P"${FE_QUERY_PORT}" -uroot -p"${FE_PASSWORD}" -e "create table ${FE_DB}.test(k1 tinyint, k2 smallint, k3 int, k4 bigint, k5 decimal(9,3), k6 char(5), k10 date, k11 datetime, k7 varchar(20), k8 double max, k9 float sum) engine=olap partition by range(k1) (partition p1 values less than ('-64'), partition p2 values less than ('0'), partition p3 values less than ('64'), partition p4 values less than maxvalue ) distributed by hash(k1) buckets 5 properties('storage_type'='column')"
In pytest/deploy/qe/init_data_broker.sh line 29:
mysql -h ${FE_HOST} -P${FE_QUERY_PORT} -uroot -p${FE_PASSWORD} -e "create table ${FE_DB}.bigtable(k1 tinyint, k2 smallint, k3 int, k4 bigint, k5 decimal(9,3), k6 char(5), k10 date, k11 datetime, k7 varchar(20), k8 double max, k9 float sum) engine=olap distributed by hash(k1) buckets 5 properties('storage_type'='column')"
^--------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
Did you mean:
mysql -h "${FE_HOST}" -P"${FE_QUERY_PORT}" -uroot -p"${FE_PASSWORD}" -e "create table ${FE_DB}.bigtable(k1 tinyint, k2 smallint, k3 int, k4 bigint, k5 decimal(9,3), k6 char(5), k10 date, k11 datetime, k7 varchar(20), k8 double max, k9 float sum) engine=olap distributed by hash(k1) buckets 5 properties('storage_type'='column')"
In pytest/deploy/qe/init_data_broker.sh line 30:
mysql -h ${FE_HOST} -P${FE_QUERY_PORT} -uroot -p${FE_PASSWORD} -e "CREATE TABLE ${FE_DB}.all_type_table (tinyint_key tinyint(4) NULL, smallint_key smallint(6) NULL, int_key int(11) NOT NULL, bigint_key bigint(20) NULL, char_50_key char(50) NULL, character_key varchar(500) NOT NULL, char_key char(1) NULL, character_most_key varchar(65533) NULL, decimal_key decimal(20, 6) NULL, decimal_most_key decimal(27, 9) NULL, date_key date NULL, datetime_key datetime NULL, tinyint_value tinyint(4) SUM NULL, smallint_value smallint(6) SUM NULL, int_value int(11) SUM NULL, largeint_value largeint SUM NULL, char_50_value char(50) REPLACE NULL, character_value varchar(500) REPLACE NULL, char_value char(1) REPLACE NULL, character_most_value varchar(65533) REPLACE NULL, decimal_value decimal(20, 6) SUM NULL, decimal_most_value decimal(27, 9) SUM NULL, date_value_replace date REPLACE NULL, date_value_max date REPLACE NULL, date_value_min date REPLACE NULL, datetime_value_replace datetime REPLACE NULL
, datetime_value_max datetime REPLACE NULL, datetime_value_min datetime REPLACE NULL, float_value float SUM NULL, double_value double SUM NULL) ENGINE=OLAP DISTRIBUTED BY HASH(tinyint_key) BUCKETS 5 PROPERTIES ('storage_type' = 'COLUMN')"
^--------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
Did you mean:
mysql -h "${FE_HOST}" -P"${FE_QUERY_PORT}" -uroot -p"${FE_PASSWORD}" -e "CREATE TABLE ${FE_DB}.all_type_table (tinyint_key tinyint(4) NULL, smallint_key smallint(6) NULL, int_key int(11) NOT NULL, bigint_key bigint(20) NULL, char_50_key char(50) NULL, character_key varchar(500) NOT NULL, char_key char(1) NULL, character_most_key varchar(65533) NULL, decimal_key decimal(20, 6) NULL, decimal_most_key decimal(27, 9) NULL, date_key date NULL, datetime_key datetime NULL, tinyint_value tinyint(4) SUM NULL, smallint_value smallint(6) SUM NULL, int_value int(11) SUM NULL, largeint_value largeint SUM NULL, char_50_value char(50) REPLACE NULL, character_value varchar(500) REPLACE NULL, char_value char(1) REPLACE NULL, character_most_value varchar(65533) REPLACE NULL, decimal_value decimal(20, 6) SUM NULL, decimal_most_value decimal(27, 9) SUM NULL, date_value_replace date REPLACE NULL, date_value_max date REPLACE NULL, date_value_min date REPLACE NULL, datetime_value_replace datetime REPLAC
E NULL, datetime_value_max datetime REPLACE NULL, datetime_value_min datetime REPLACE NULL, float_value float SUM NULL, double_value double SUM NULL) ENGINE=OLAP DISTRIBUTED BY HASH(tinyint_key) BUCKETS 5 PROPERTIES ('storage_type' = 'COLUMN')"
In pytest/deploy/qe/init_data_broker.sh line 33:
mysql -h ${FE_HOST} -P${FE_QUERY_PORT} -uroot -p${FE_PASSWORD} -e "LOAD LABEL ${FE_DB}.label_1 (DATA INFILE('$hdfs_data_path/qe/baseall.txt') INTO TABLE baseall COLUMNS TERMINATED BY '$separator') $broker_property"
^--------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^-------------^ SC2154 (warning): hdfs_data_path is referenced but not assigned.
^-------------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
^--------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
^--------------^ SC2154 (warning): broker_property is referenced but not assigned.
^--------------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
Did you mean:
mysql -h "${FE_HOST}" -P"${FE_QUERY_PORT}" -uroot -p"${FE_PASSWORD}" -e "LOAD LABEL ${FE_DB}.label_1 (DATA INFILE('${hdfs_data_path}/qe/baseall.txt') INTO TABLE baseall COLUMNS TERMINATED BY '${separator}') ${broker_property}"
In pytest/deploy/qe/init_data_broker.sh line 35:
mysql -h ${FE_HOST} -P${FE_QUERY_PORT} -uroot -p${FE_PASSWORD} -e "LOAD LABEL ${FE_DB}.label_2 (DATA INFILE('$hdfs_data_path/qe/baseall.txt') INTO TABLE test COLUMNS TERMINATED BY '$separator') $broker_property"
^--------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^-------------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
^--------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
^--------------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
Did you mean:
mysql -h "${FE_HOST}" -P"${FE_QUERY_PORT}" -uroot -p"${FE_PASSWORD}" -e "LOAD LABEL ${FE_DB}.label_2 (DATA INFILE('${hdfs_data_path}/qe/baseall.txt') INTO TABLE test COLUMNS TERMINATED BY '${separator}') ${broker_property}"
In pytest/deploy/qe/init_data_broker.sh line 37:
mysql -h ${FE_HOST} -P${FE_QUERY_PORT} -uroot -p${FE_PASSWORD} -e "LOAD LABEL ${FE_DB}.label_3 (DATA INFILE('$hdfs_data_path/qe/xaaa') INTO TABLE test COLUMNS TERMINATED BY '$separator') $broker_property"
^--------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^-------------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
^--------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
^--------------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
Did you mean:
mysql -h "${FE_HOST}" -P"${FE_QUERY_PORT}" -uroot -p"${FE_PASSWORD}" -e "LOAD LABEL ${FE_DB}.label_3 (DATA INFILE('${hdfs_data_path}/qe/xaaa') INTO TABLE test COLUMNS TERMINATED BY '${separator}') ${broker_property}"
In pytest/deploy/qe/init_data_broker.sh line 39:
mysql -h ${FE_HOST} -P${FE_QUERY_PORT} -uroot -p${FE_PASSWORD} -e "LOAD LABEL ${FE_DB}.label_4 (DATA INFILE('$hdfs_data_path/qe/baseall.txt') INTO TABLE bigtable COLUMNS TERMINATED BY '$separator') $broker_property"
^--------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^-------------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
^--------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
^--------------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
Did you mean:
mysql -h "${FE_HOST}" -P"${FE_QUERY_PORT}" -uroot -p"${FE_PASSWORD}" -e "LOAD LABEL ${FE_DB}.label_4 (DATA INFILE('${hdfs_data_path}/qe/baseall.txt') INTO TABLE bigtable COLUMNS TERMINATED BY '${separator}') ${broker_property}"
In pytest/deploy/qe/init_data_broker.sh line 41:
mysql -h ${FE_HOST} -P${FE_QUERY_PORT} -uroot -p${FE_PASSWORD} -e "LOAD LABEL ${FE_DB}.label_5 (DATA INFILE('$hdfs_data_path/sys/all_type.txt') INTO TABLE all_type_table COLUMNS TERMINATED BY '$separator') $broker_property PROPERTIES('max_filter_ratio'='0.05')"
^--------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^-------------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
^--------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
^--------------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
Did you mean:
mysql -h "${FE_HOST}" -P"${FE_QUERY_PORT}" -uroot -p"${FE_PASSWORD}" -e "LOAD LABEL ${FE_DB}.label_5 (DATA INFILE('${hdfs_data_path}/sys/all_type.txt') INTO TABLE all_type_table COLUMNS TERMINATED BY '${separator}') ${broker_property} PROPERTIES('max_filter_ratio'='0.05')"
In pytest/deploy/qe/init_data_duplicate.sh line 23:
mysql -h ${FE_HOST} -P${FE_QUERY_PORT} -uroot -p${FE_PASSWORD} -e "DROP DATABASE IF EXISTS ${FE_DB}"
^--------^ SC2154 (warning): FE_HOST is referenced but not assigned.
^--------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------------^ SC2154 (warning): FE_QUERY_PORT is referenced but not assigned.
^--------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^------------^ SC2154 (warning): FE_PASSWORD is referenced but not assigned.
^------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^------^ SC2154 (warning): FE_DB is referenced but not assigned.
Did you mean:
mysql -h "${FE_HOST}" -P"${FE_QUERY_PORT}" -uroot -p"${FE_PASSWORD}" -e "DROP DATABASE IF EXISTS ${FE_DB}"
In pytest/deploy/qe/init_data_duplicate.sh line 24:
mysql -h ${FE_HOST} -P${FE_QUERY_PORT} -uroot -p${FE_PASSWORD} -e "create database ${FE_DB}"
^--------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
Did you mean:
mysql -h "${FE_HOST}" -P"${FE_QUERY_PORT}" -uroot -p"${FE_PASSWORD}" -e "create database ${FE_DB}"
In pytest/deploy/qe/init_data_duplicate.sh line 26:
mysql -h ${FE_HOST} -P${FE_QUERY_PORT} -uroot -p${FE_PASSWORD} -e "create table ${FE_DB}.baseall(k1 tinyint, k2 smallint, k3 int, k4 bigint, k5 decimal(9,3), k6 char(5), k10 date, k11 datetime, k7 varchar(20), k8 double, k9 float ) engine=olap duplicate key (k1, k2, k3, k4, k5, k6, k10) distributed by hash(k1) buckets 5 properties('storage_type'='column')"
^--------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
Did you mean:
mysql -h "${FE_HOST}" -P"${FE_QUERY_PORT}" -uroot -p"${FE_PASSWORD}" -e "create table ${FE_DB}.baseall(k1 tinyint, k2 smallint, k3 int, k4 bigint, k5 decimal(9,3), k6 char(5), k10 date, k11 datetime, k7 varchar(20), k8 double, k9 float ) engine=olap duplicate key (k1, k2, k3, k4, k5, k6, k10) distributed by hash(k1) buckets 5 properties('storage_type'='column')"
In pytest/deploy/qe/init_data_duplicate.sh line 28:
mysql -h ${FE_HOST} -P${FE_QUERY_PORT} -uroot -p${FE_PASSWORD} -e "create table ${FE_DB}.test(k1 tinyint, k2 smallint, k3 int, k4 bigint, k5 decimal(9,3), k6 char(5), k10 date, k11 datetime, k7 varchar(20), k8 double, k9 float) engine=olap duplicate key (k1, k2, k3, k4, k5, k6, k10) partition by range(k1) (partition p1 values less than ('-64'), partition p2 values less than ('0'), partition p3 values less than ('64'), partition p4 values less than maxvalue ) distributed by hash(k1) buckets 5 properties('storage_type'='column')"
^--------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
Did you mean:
mysql -h "${FE_HOST}" -P"${FE_QUERY_PORT}" -uroot -p"${FE_PASSWORD}" -e "create table ${FE_DB}.test(k1 tinyint, k2 smallint, k3 int, k4 bigint, k5 decimal(9,3), k6 char(5), k10 date, k11 datetime, k7 varchar(20), k8 double, k9 float) engine=olap duplicate key (k1, k2, k3, k4, k5, k6, k10) partition by range(k1) (partition p1 values less than ('-64'), partition p2 values less than ('0'), partition p3 values less than ('64'), partition p4 values less than maxvalue ) distributed by hash(k1) buckets 5 properties('storage_type'='column')"
In pytest/deploy/qe/init_data_duplicate.sh line 30:
mysql -h ${FE_HOST} -P${FE_QUERY_PORT} -uroot -p${FE_PASSWORD} -e "create table ${FE_DB}.bigtable(k1 tinyint, k2 smallint, k3 int, k4 bigint, k5 decimal(9,3), k6 char(5), k10 date, k11 datetime, k7 varchar(20), k8 double, k9 float) engine=olap duplicate key (k1, k2, k3, k4, k5, k6, k10) distributed by hash(k1) buckets 5 properties('storage_type'='column')"
^--------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
Did you mean:
mysql -h "${FE_HOST}" -P"${FE_QUERY_PORT}" -uroot -p"${FE_PASSWORD}" -e "create table ${FE_DB}.bigtable(k1 tinyint, k2 smallint, k3 int, k4 bigint, k5 decimal(9,3), k6 char(5), k10 date, k11 datetime, k7 varchar(20), k8 double, k9 float) engine=olap duplicate key (k1, k2, k3, k4, k5, k6, k10) distributed by hash(k1) buckets 5 properties('storage_type'='column')"
In pytest/deploy/qe/init_data_duplicate.sh line 32:
mysql -h ${FE_HOST} -P${FE_QUERY_PORT} -uroot -p${FE_PASSWORD} -e "LOAD LABEL ${FE_DB}.label_1 (DATA INFILE('$hdfs_data_path/qe/baseall.txt') INTO TABLE baseall COLUMNS TERMINATED BY '$separator') $broker_property"
^--------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^-------------^ SC2154 (warning): hdfs_data_path is referenced but not assigned.
^-------------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
^--------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
^--------------^ SC2154 (warning): broker_property is referenced but not assigned.
^--------------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
Did you mean:
mysql -h "${FE_HOST}" -P"${FE_QUERY_PORT}" -uroot -p"${FE_PASSWORD}" -e "LOAD LABEL ${FE_DB}.label_1 (DATA INFILE('${hdfs_data_path}/qe/baseall.txt') INTO TABLE baseall COLUMNS TERMINATED BY '${separator}') ${broker_property}"
In pytest/deploy/qe/init_data_duplicate.sh line 34:
mysql -h ${FE_HOST} -P${FE_QUERY_PORT} -uroot -p${FE_PASSWORD} -e "LOAD LABEL ${FE_DB}.label_2 (DATA INFILE('$hdfs_data_path/qe/baseall.txt') INTO TABLE test COLUMNS TERMINATED BY '$separator') $broker_property"
^--------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^-------------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
^--------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
^--------------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
Did you mean:
mysql -h "${FE_HOST}" -P"${FE_QUERY_PORT}" -uroot -p"${FE_PASSWORD}" -e "LOAD LABEL ${FE_DB}.label_2 (DATA INFILE('${hdfs_data_path}/qe/baseall.txt') INTO TABLE test COLUMNS TERMINATED BY '${separator}') ${broker_property}"
In pytest/deploy/qe/init_data_duplicate.sh line 36:
mysql -h ${FE_HOST} -P${FE_QUERY_PORT} -uroot -p${FE_PASSWORD} -e "LOAD LABEL ${FE_DB}.label_3 (DATA INFILE('$hdfs_data_path/qe/xaaa') INTO TABLE test COLUMNS TERMINATED BY '$separator') $broker_property"
^--------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^-------------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
^--------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
^--------------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
Did you mean:
mysql -h "${FE_HOST}" -P"${FE_QUERY_PORT}" -uroot -p"${FE_PASSWORD}" -e "LOAD LABEL ${FE_DB}.label_3 (DATA INFILE('${hdfs_data_path}/qe/xaaa') INTO TABLE test COLUMNS TERMINATED BY '${separator}') ${broker_property}"
In pytest/deploy/qe/init_data_duplicate.sh line 38:
mysql -h ${FE_HOST} -P${FE_QUERY_PORT} -uroot -p${FE_PASSWORD} -e "LOAD LABEL ${FE_DB}.label_4 (DATA INFILE('$hdfs_data_path/qe/baseall.txt') INTO TABLE bigtable COLUMNS TERMINATED BY '$separator') $broker_property"
^--------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^-------------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
^--------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
^--------------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
Did you mean:
mysql -h "${FE_HOST}" -P"${FE_QUERY_PORT}" -uroot -p"${FE_PASSWORD}" -e "LOAD LABEL ${FE_DB}.label_4 (DATA INFILE('${hdfs_data_path}/qe/baseall.txt') INTO TABLE bigtable COLUMNS TERMINATED BY '${separator}') ${broker_property}"
In pytest/deploy/qe/init_data_list.sh line 23:
mysql -h ${FE_HOST} -P${FE_QUERY_PORT} -uroot -p${FE_PASSWORD} -e "DROP DATABASE IF EXISTS ${FE_DB}"
^--------^ SC2154 (warning): FE_HOST is referenced but not assigned.
^--------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------------^ SC2154 (warning): FE_QUERY_PORT is referenced but not assigned.
^--------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^------------^ SC2154 (warning): FE_PASSWORD is referenced but not assigned.
^------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^------^ SC2154 (warning): FE_DB is referenced but not assigned.
Did you mean:
mysql -h "${FE_HOST}" -P"${FE_QUERY_PORT}" -uroot -p"${FE_PASSWORD}" -e "DROP DATABASE IF EXISTS ${FE_DB}"
In pytest/deploy/qe/init_data_list.sh line 24:
mysql -h ${FE_HOST} -P${FE_QUERY_PORT} -uroot -p${FE_PASSWORD} -e "create database ${FE_DB}"
^--------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
Did you mean:
mysql -h "${FE_HOST}" -P"${FE_QUERY_PORT}" -uroot -p"${FE_PASSWORD}" -e "create database ${FE_DB}"
In pytest/deploy/qe/init_data_list.sh line 26:
mysql -h ${FE_HOST} -P${FE_QUERY_PORT} -uroot -p${FE_PASSWORD} -e "create table ${FE_DB}.baseall(k1 tinyint, k2 smallint, k3 int, k4 bigint, k5 decimal(9,3), k6 char(5), k10 date not null, k11 datetime, k7 varchar(20), k8 double max, k9 float sum) engine=olap partition by list(k10) (partition p1 values in ('1989-03-21','1991-08-11'), partition p2 values in ('2015-04-02','2012-03-14'), partition p3 values in ('1988-03-21','2014-11-11'), partition p4 values in ('1901-12-31','3124-10-10'), partition p5 values in ('2015-01-01','9999-12-12')) distributed by hash(k1) buckets 5 properties('storage_type'='column')"
^--------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
Did you mean:
mysql -h "${FE_HOST}" -P"${FE_QUERY_PORT}" -uroot -p"${FE_PASSWORD}" -e "create table ${FE_DB}.baseall(k1 tinyint, k2 smallint, k3 int, k4 bigint, k5 decimal(9,3), k6 char(5), k10 date not null, k11 datetime, k7 varchar(20), k8 double max, k9 float sum) engine=olap partition by list(k10) (partition p1 values in ('1989-03-21','1991-08-11'), partition p2 values in ('2015-04-02','2012-03-14'), partition p3 values in ('1988-03-21','2014-11-11'), partition p4 values in ('1901-12-31','3124-10-10'), partition p5 values in ('2015-01-01','9999-12-12')) distributed by hash(k1) buckets 5 properties('storage_type'='column')"
In pytest/deploy/qe/init_data_list.sh line 28:
mysql -h ${FE_HOST} -P${FE_QUERY_PORT} -uroot -p${FE_PASSWORD} -e "create table ${FE_DB}.test(k1 tinyint not null, k2 smallint, k3 int, k4 bigint, k5 decimal(9,3), k6 char(5), k10 date, k11 datetime, k7 varchar(20), k8 double max, k9 float sum) engine=olap partition by list(k1) (partition p1 values in ('-127','-126','-125','-124','-123','-122','-121','-120','-119','-118','-117','-116','-115','-114','-113','-112'), partition p2 values in ('-111','-110','-109','-108','-107','-106','-105','-104','-103','-102','-101','-100','-99','-98','-97','-96'), partition p3 values in ('-95','-94','-93','-92','-91','-90','-89','-88','-87','-86','-85','-84','-83','-82','-81','-80'), partition p4 values in ('-79','-78','-77','-76','-75','-74','-73','-72','-71','-70','-69','-68','-67','-66','-65','-64'), partition p5 values in ('-63','-62','-61','-60','-59','-58','-57','-56','-55','-54','-53','-52','-51','-50','-49','-48'), partition p6 values in ('-47','-46','-45','-44','-43','-42','-41','-40',
'-39','-38','-37','-36','-35','-34','-33','-32'), partition p7 values in ('-31','-30','-29','-28','-27','-26','-25','-24','-23','-22','-21','-20','-19','-18','-17','-16'), partition p8 values in ('-15','-14','-13','-12','-11','-10','-9','-8','-7','-6','-5','-4','-3','-2','-1','0'), partition p9 values in ('1','2','3','4','5','6','7','8','9','10','11','12','13','14','15','16'), partition p10 values in ('17','18','19','20','21','22','23','24','25','26','27','28','29','30','31','32'), partition p11 values in ('33','34','35','36','37','38','39','40','41','42','43','44','45','46','47','48'), partition p12 values in ('49','50','51','52','53','54','55','56','57','58','59','60','61','62','63','64'), partition p13 values in ('65','66','67','68','69','70','71','72','73','74','75','76','77','78','79','80'), partition p14 values in ('81','82','83','84','85','86','87','88','89','90','91','92','93','94','95','96'), partition p15 values in ('97','98','99','100','101','102','103','104','10
5','106','107','108','109','110','111','112'), partition p16 values in ('113','114','115','116','117','118','119','120','121','122','123','124','125','126','127')) distributed by hash(k1) buckets 5 properties('storage_type'='column')"
^--------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
Did you mean:
mysql -h "${FE_HOST}" -P"${FE_QUERY_PORT}" -uroot -p"${FE_PASSWORD}" -e "create table ${FE_DB}.test(k1 tinyint not null, k2 smallint, k3 int, k4 bigint, k5 decimal(9,3), k6 char(5), k10 date, k11 datetime, k7 varchar(20), k8 double max, k9 float sum) engine=olap partition by list(k1) (partition p1 values in ('-127','-126','-125','-124','-123','-122','-121','-120','-119','-118','-117','-116','-115','-114','-113','-112'), partition p2 values in ('-111','-110','-109','-108','-107','-106','-105','-104','-103','-102','-101','-100','-99','-98','-97','-96'), partition p3 values in ('-95','-94','-93','-92','-91','-90','-89','-88','-87','-86','-85','-84','-83','-82','-81','-80'), partition p4 values in ('-79','-78','-77','-76','-75','-74','-73','-72','-71','-70','-69','-68','-67','-66','-65','-64'), partition p5 values in ('-63','-62','-61','-60','-59','-58','-57','-56','-55','-54','-53','-52','-51','-50','-49','-48'), partition p6 values in ('-47','-46','-45','-44','-43','-42','-41',
'-40','-39','-38','-37','-36','-35','-34','-33','-32'), partition p7 values in ('-31','-30','-29','-28','-27','-26','-25','-24','-23','-22','-21','-20','-19','-18','-17','-16'), partition p8 values in ('-15','-14','-13','-12','-11','-10','-9','-8','-7','-6','-5','-4','-3','-2','-1','0'), partition p9 values in ('1','2','3','4','5','6','7','8','9','10','11','12','13','14','15','16'), partition p10 values in ('17','18','19','20','21','22','23','24','25','26','27','28','29','30','31','32'), partition p11 values in ('33','34','35','36','37','38','39','40','41','42','43','44','45','46','47','48'), partition p12 values in ('49','50','51','52','53','54','55','56','57','58','59','60','61','62','63','64'), partition p13 values in ('65','66','67','68','69','70','71','72','73','74','75','76','77','78','79','80'), partition p14 values in ('81','82','83','84','85','86','87','88','89','90','91','92','93','94','95','96'), partition p15 values in ('97','98','99','100','101','102','103','10
4','105','106','107','108','109','110','111','112'), partition p16 values in ('113','114','115','116','117','118','119','120','121','122','123','124','125','126','127')) distributed by hash(k1) buckets 5 properties('storage_type'='column')"
In pytest/deploy/qe/init_data_list.sh line 30:
mysql -h ${FE_HOST} -P${FE_QUERY_PORT} -uroot -p${FE_PASSWORD} -e "create table ${FE_DB}.bigtable(k1 tinyint, k2 smallint, k3 int, k4 bigint, k5 decimal(9,3), k6 char(5) not null, k10 date, k11 datetime, k7 varchar(20), k8 double max, k9 float sum) engine=olap partition by list(k6) (partition p1 values in ('true'), partition p2 values in ('false')) distributed by hash(k1) buckets 5 properties('storage_type'='column')"
^--------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
Did you mean:
mysql -h "${FE_HOST}" -P"${FE_QUERY_PORT}" -uroot -p"${FE_PASSWORD}" -e "create table ${FE_DB}.bigtable(k1 tinyint, k2 smallint, k3 int, k4 bigint, k5 decimal(9,3), k6 char(5) not null, k10 date, k11 datetime, k7 varchar(20), k8 double max, k9 float sum) engine=olap partition by list(k6) (partition p1 values in ('true'), partition p2 values in ('false')) distributed by hash(k1) buckets 5 properties('storage_type'='column')"
In pytest/deploy/qe/init_data_list.sh line 32:
mysql -h ${FE_HOST} -P${FE_QUERY_PORT} -uroot -p${FE_PASSWORD} -e "LOAD LABEL ${FE_DB}.label_1 (DATA INFILE('$hdfs_data_path/qe/baseall.txt') INTO TABLE baseall COLUMNS TERMINATED BY '$separator') $broker_property"
^--------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^-------------^ SC2154 (warning): hdfs_data_path is referenced but not assigned.
^-------------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
^--------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
^--------------^ SC2154 (warning): broker_property is referenced but not assigned.
^--------------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
Did you mean:
mysql -h "${FE_HOST}" -P"${FE_QUERY_PORT}" -uroot -p"${FE_PASSWORD}" -e "LOAD LABEL ${FE_DB}.label_1 (DATA INFILE('${hdfs_data_path}/qe/baseall.txt') INTO TABLE baseall COLUMNS TERMINATED BY '${separator}') ${broker_property}"
In pytest/deploy/qe/init_data_list.sh line 34:
mysql -h ${FE_HOST} -P${FE_QUERY_PORT} -uroot -p${FE_PASSWORD} -e "LOAD LABEL ${FE_DB}.label_2 (DATA INFILE('$hdfs_data_path/qe/baseall.txt') INTO TABLE test COLUMNS TERMINATED BY '$separator') $broker_property"
^--------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^-------------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
^--------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
^--------------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
Did you mean:
mysql -h "${FE_HOST}" -P"${FE_QUERY_PORT}" -uroot -p"${FE_PASSWORD}" -e "LOAD LABEL ${FE_DB}.label_2 (DATA INFILE('${hdfs_data_path}/qe/baseall.txt') INTO TABLE test COLUMNS TERMINATED BY '${separator}') ${broker_property}"
In pytest/deploy/qe/init_data_list.sh line 36:
mysql -h ${FE_HOST} -P${FE_QUERY_PORT} -uroot -p${FE_PASSWORD} -e "LOAD LABEL ${FE_DB}.label_3 (DATA INFILE('$hdfs_data_path/qe/xaaa') INTO TABLE test COLUMNS TERMINATED BY '$separator') $broker_property"
^--------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^-------------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
^--------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
^--------------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
Did you mean:
mysql -h "${FE_HOST}" -P"${FE_QUERY_PORT}" -uroot -p"${FE_PASSWORD}" -e "LOAD LABEL ${FE_DB}.label_3 (DATA INFILE('${hdfs_data_path}/qe/xaaa') INTO TABLE test COLUMNS TERMINATED BY '${separator}') ${broker_property}"
In pytest/deploy/qe/init_data_list.sh line 38:
mysql -h ${FE_HOST} -P${FE_QUERY_PORT} -uroot -p${FE_PASSWORD} -e "LOAD LABEL ${FE_DB}.label_4 (DATA INFILE('$hdfs_data_path/qe/baseall.txt') INTO TABLE bigtable COLUMNS TERMINATED BY '$separator') $broker_property"
^--------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^-------------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
^--------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
^--------------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
Did you mean:
mysql -h "${FE_HOST}" -P"${FE_QUERY_PORT}" -uroot -p"${FE_PASSWORD}" -e "LOAD LABEL ${FE_DB}.label_4 (DATA INFILE('${hdfs_data_path}/qe/baseall.txt') INTO TABLE bigtable COLUMNS TERMINATED BY '${separator}') ${broker_property}"
In pytest/deploy/qe/init_data_multi.sh line 23:
mysql -h ${FE_HOST} -P${FE_QUERY_PORT} -uroot -p${FE_PASSWORD} -e "DROP DATABASE IF EXISTS ${FE_DB}"
^--------^ SC2154 (warning): FE_HOST is referenced but not assigned.
^--------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------------^ SC2154 (warning): FE_QUERY_PORT is referenced but not assigned.
^--------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^------------^ SC2154 (warning): FE_PASSWORD is referenced but not assigned.
^------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^------^ SC2154 (warning): FE_DB is referenced but not assigned.
Did you mean:
mysql -h "${FE_HOST}" -P"${FE_QUERY_PORT}" -uroot -p"${FE_PASSWORD}" -e "DROP DATABASE IF EXISTS ${FE_DB}"
In pytest/deploy/qe/init_data_multi.sh line 24:
mysql -h ${FE_HOST} -P${FE_QUERY_PORT} -uroot -p${FE_PASSWORD} -e "create database ${FE_DB}"
^--------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
Did you mean:
mysql -h "${FE_HOST}" -P"${FE_QUERY_PORT}" -uroot -p"${FE_PASSWORD}" -e "create database ${FE_DB}"
In pytest/deploy/qe/init_data_multi.sh line 26:
mysql -h ${FE_HOST} -P${FE_QUERY_PORT} -uroot -p${FE_PASSWORD} -e "create table ${FE_DB}.baseall(k1 tinyint, k2 smallint, k3 int, k4 bigint, k5 decimal(9,3), k6 char(5), k10 date, k11 datetime, k7 varchar(20), k8 double max, k9 float sum) engine=olap partition by range(k1,k10) (partition p1 values less than ('-8','1989-12-31'), partition p2 values less than ('0', '1999-12-31'), partition p3 values less than ('8', '2999-12-31'), partition p4 values less than ('16','9999-12-31')) distributed by hash(k1) buckets 5 properties('storage_type'='column')"
^--------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
Did you mean:
mysql -h "${FE_HOST}" -P"${FE_QUERY_PORT}" -uroot -p"${FE_PASSWORD}" -e "create table ${FE_DB}.baseall(k1 tinyint, k2 smallint, k3 int, k4 bigint, k5 decimal(9,3), k6 char(5), k10 date, k11 datetime, k7 varchar(20), k8 double max, k9 float sum) engine=olap partition by range(k1,k10) (partition p1 values less than ('-8','1989-12-31'), partition p2 values less than ('0', '1999-12-31'), partition p3 values less than ('8', '2999-12-31'), partition p4 values less than ('16','9999-12-31')) distributed by hash(k1) buckets 5 properties('storage_type'='column')"
In pytest/deploy/qe/init_data_multi.sh line 28:
mysql -h ${FE_HOST} -P${FE_QUERY_PORT} -uroot -p${FE_PASSWORD} -e "create table ${FE_DB}.test(k1 tinyint, k2 smallint, k3 int, k4 bigint, k5 decimal(9,3), k6 char(5), k10 date, k11 datetime, k7 varchar(20), k8 double max, k9 float sum) engine=olap partition by range(k10,k11) (partition p1 values less than ('1989-12-31', '1959-12-31 00:00:00'), partition p2 values less than ('1999-12-31', '1989-12-31 00:00:00'), partition p3 values less than ('2999-12-31', '1999-12-31 00:00:00'), partition p4 values less than ('9999-12-31', '9999-12-31 00:00:00')) distributed by hash(k1) buckets 5 properties('storage_type'='column')"
^--------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
Did you mean:
mysql -h "${FE_HOST}" -P"${FE_QUERY_PORT}" -uroot -p"${FE_PASSWORD}" -e "create table ${FE_DB}.test(k1 tinyint, k2 smallint, k3 int, k4 bigint, k5 decimal(9,3), k6 char(5), k10 date, k11 datetime, k7 varchar(20), k8 double max, k9 float sum) engine=olap partition by range(k10,k11) (partition p1 values less than ('1989-12-31', '1959-12-31 00:00:00'), partition p2 values less than ('1999-12-31', '1989-12-31 00:00:00'), partition p3 values less than ('2999-12-31', '1999-12-31 00:00:00'), partition p4 values less than ('9999-12-31', '9999-12-31 00:00:00')) distributed by hash(k1) buckets 5 properties('storage_type'='column')"
In pytest/deploy/qe/init_data_multi.sh line 30:
mysql -h ${FE_HOST} -P${FE_QUERY_PORT} -uroot -p${FE_PASSWORD} -e "create table ${FE_DB}.bigtable(k1 tinyint, k2 smallint, k3 int, k4 bigint, k5 decimal(9,3), k6 char(5), k10 date, k11 datetime, k7 varchar(20), k8 double max, k9 float sum) engine=olap partition by range(k1,k10) (partition p1 values less than ('-8','1989-12-31'), partition p2 values less than ('0', '1999-12-31'), partition p3 values less than ('8', '2999-12-31'), partition p4 values less than ('16','9999-12-31')) distributed by hash(k1) buckets 5 properties('storage_type'='column')"
^--------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
Did you mean:
mysql -h "${FE_HOST}" -P"${FE_QUERY_PORT}" -uroot -p"${FE_PASSWORD}" -e "create table ${FE_DB}.bigtable(k1 tinyint, k2 smallint, k3 int, k4 bigint, k5 decimal(9,3), k6 char(5), k10 date, k11 datetime, k7 varchar(20), k8 double max, k9 float sum) engine=olap partition by range(k1,k10) (partition p1 values less than ('-8','1989-12-31'), partition p2 values less than ('0', '1999-12-31'), partition p3 values less than ('8', '2999-12-31'), partition p4 values less than ('16','9999-12-31')) distributed by hash(k1) buckets 5 properties('storage_type'='column')"
In pytest/deploy/qe/init_data_multi.sh line 32:
mysql -h ${FE_HOST} -P${FE_QUERY_PORT} -uroot -p${FE_PASSWORD} -e "LOAD LABEL ${FE_DB}.label_1 (DATA INFILE('$hdfs_data_path/qe/baseall.txt') INTO TABLE baseall COLUMNS TERMINATED BY '$separator') $broker_property"
^--------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^-------------^ SC2154 (warning): hdfs_data_path is referenced but not assigned.
^-------------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
^--------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
^--------------^ SC2154 (warning): broker_property is referenced but not assigned.
^--------------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
Did you mean:
mysql -h "${FE_HOST}" -P"${FE_QUERY_PORT}" -uroot -p"${FE_PASSWORD}" -e "LOAD LABEL ${FE_DB}.label_1 (DATA INFILE('${hdfs_data_path}/qe/baseall.txt') INTO TABLE baseall COLUMNS TERMINATED BY '${separator}') ${broker_property}"
In pytest/deploy/qe/init_data_multi.sh line 34:
mysql -h ${FE_HOST} -P${FE_QUERY_PORT} -uroot -p${FE_PASSWORD} -e "LOAD LABEL ${FE_DB}.label_2 (DATA INFILE('$hdfs_data_path/qe/baseall.txt') INTO TABLE test COLUMNS TERMINATED BY '$separator') $broker_property"
^--------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^-------------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
^--------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
^--------------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
Did you mean:
mysql -h "${FE_HOST}" -P"${FE_QUERY_PORT}" -uroot -p"${FE_PASSWORD}" -e "LOAD LABEL ${FE_DB}.label_2 (DATA INFILE('${hdfs_data_path}/qe/baseall.txt') INTO TABLE test COLUMNS TERMINATED BY '${separator}') ${broker_property}"
In pytest/deploy/qe/init_data_multi.sh line 36:
mysql -h ${FE_HOST} -P${FE_QUERY_PORT} -uroot -p${FE_PASSWORD} -e "LOAD LABEL ${FE_DB}.label_3 (DATA INFILE('$hdfs_data_path/qe/xaaa') INTO TABLE test COLUMNS TERMINATED BY '$separator') $broker_property"
^--------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^-------------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
^--------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
^--------------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
Did you mean:
mysql -h "${FE_HOST}" -P"${FE_QUERY_PORT}" -uroot -p"${FE_PASSWORD}" -e "LOAD LABEL ${FE_DB}.label_3 (DATA INFILE('${hdfs_data_path}/qe/xaaa') INTO TABLE test COLUMNS TERMINATED BY '${separator}') ${broker_property}"
In pytest/deploy/qe/init_data_multi.sh line 38:
mysql -h ${FE_HOST} -P${FE_QUERY_PORT} -uroot -p${FE_PASSWORD} -e "LOAD LABEL ${FE_DB}.label_4 (DATA INFILE('$hdfs_data_path/qe/baseall.txt') INTO TABLE bigtable COLUMNS TERMINATED BY '$separator') $broker_property"
^--------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^-------------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
^--------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
^--------------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
Did you mean:
mysql -h "${FE_HOST}" -P"${FE_QUERY_PORT}" -uroot -p"${FE_PASSWORD}" -e "LOAD LABEL ${FE_DB}.label_4 (DATA INFILE('${hdfs_data_path}/qe/baseall.txt') INTO TABLE bigtable COLUMNS TERMINATED BY '${separator}') ${broker_property}"
In pytest/deploy/qe/init_data_stream.sh line 21:
cd ../../hdfs/data/qe/
^--------------------^ SC2164 (warning): Use 'cd ... || exit' or 'cd ... || return' in case cd fails.
Did you mean:
cd ../../hdfs/data/qe/ || exit
In pytest/deploy/qe/init_data_stream.sh line 23:
mysql -h ${FE_HOST} -P${FE_QUERY_PORT} -uroot -p${FE_PASSWORD} -e "DROP DATABASE IF EXISTS ${FE_DB}"
^--------^ SC2154 (warning): FE_HOST is referenced but not assigned.
^--------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------------^ SC2154 (warning): FE_QUERY_PORT is referenced but not assigned.
^--------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^------------^ SC2154 (warning): FE_PASSWORD is referenced but not assigned.
^------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^------^ SC2154 (warning): FE_DB is referenced but not assigned.
Did you mean:
mysql -h "${FE_HOST}" -P"${FE_QUERY_PORT}" -uroot -p"${FE_PASSWORD}" -e "DROP DATABASE IF EXISTS ${FE_DB}"
In pytest/deploy/qe/init_data_stream.sh line 24:
mysql -h ${FE_HOST} -P${FE_QUERY_PORT} -uroot -p${FE_PASSWORD} -e "create database ${FE_DB}"
^--------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
Did you mean:
mysql -h "${FE_HOST}" -P"${FE_QUERY_PORT}" -uroot -p"${FE_PASSWORD}" -e "create database ${FE_DB}"
In pytest/deploy/qe/init_data_stream.sh line 26:
mysql -h ${FE_HOST} -P${FE_QUERY_PORT} -uroot -p${FE_PASSWORD} ${FE_DB} -e 'create table baseall(k1 tinyint, k2 smallint, k3 int, k4 bigint, k5 decimal(9,3), k6 char(5), k10 date, k11 datetime, k7 varchar(20), k8 double max, k9 float sum) engine=olap distributed by hash(k1) buckets 5 properties("storage_type"="column")'
^--------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^------^ SC2086 (info): Double quote to prevent globbing and word splitting.
Did you mean:
mysql -h "${FE_HOST}" -P"${FE_QUERY_PORT}" -uroot -p"${FE_PASSWORD}" "${FE_DB}" -e 'create table baseall(k1 tinyint, k2 smallint, k3 int, k4 bigint, k5 decimal(9,3), k6 char(5), k10 date, k11 datetime, k7 varchar(20), k8 double max, k9 float sum) engine=olap distributed by hash(k1) buckets 5 properties("storage_type"="column")'
In pytest/deploy/qe/init_data_stream.sh line 27:
curl --location-trusted -T baseall.txt -u root:${FE_PASSWORD} http://${FE_HOST}:${FE_WEB_PORT}/api/${FE_DB}/baseall/_stream_load
^------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^------------^ SC2154 (warning): FE_WEB_PORT is referenced but not assigned.
^------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^------^ SC2086 (info): Double quote to prevent globbing and word splitting.
Did you mean:
curl --location-trusted -T baseall.txt -u root:"${FE_PASSWORD}" http://"${FE_HOST}":"${FE_WEB_PORT}"/api/"${FE_DB}"/baseall/_stream_load
In pytest/deploy/qe/init_data_stream.sh line 29:
mysql -h ${FE_HOST} -P${FE_QUERY_PORT} -uroot -p${FE_PASSWORD} ${FE_DB} -e 'create table test(k1 tinyint, k2 smallint, k3 int, k4 bigint, k5 decimal(9,3), k6 char(5), k10 date, k11 datetime, k7 varchar(20), k8 double max, k9 float sum) engine=olap distributed by hash(k1) buckets 5 properties("storage_type"="column")'
^--------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^------^ SC2086 (info): Double quote to prevent globbing and word splitting.
Did you mean:
mysql -h "${FE_HOST}" -P"${FE_QUERY_PORT}" -uroot -p"${FE_PASSWORD}" "${FE_DB}" -e 'create table test(k1 tinyint, k2 smallint, k3 int, k4 bigint, k5 decimal(9,3), k6 char(5), k10 date, k11 datetime, k7 varchar(20), k8 double max, k9 float sum) engine=olap distributed by hash(k1) buckets 5 properties("storage_type"="column")'
In pytest/deploy/qe/init_data_stream.sh line 30:
curl --location-trusted -T baseall.txt -u root:${FE_PASSWORD} http://${FE_HOST}:${FE_WEB_PORT}/api/${FE_DB}/test/_stream_load
^------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^------^ SC2086 (info): Double quote to prevent globbing and word splitting.
Did you mean:
curl --location-trusted -T baseall.txt -u root:"${FE_PASSWORD}" http://"${FE_HOST}":"${FE_WEB_PORT}"/api/"${FE_DB}"/test/_stream_load
In pytest/deploy/qe/init_data_stream.sh line 31:
curl --location-trusted -T xaaa -u root:${FE_PASSWORD} http://${FE_HOST}:${FE_WEB_PORT}/api/${FE_DB}/test/_stream_load
^------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^------^ SC2086 (info): Double quote to prevent globbing and word splitting.
Did you mean:
curl --location-trusted -T xaaa -u root:"${FE_PASSWORD}" http://"${FE_HOST}":"${FE_WEB_PORT}"/api/"${FE_DB}"/test/_stream_load
In pytest/deploy/qe/init_data_stream.sh line 33:
mysql -h ${FE_HOST} -P${FE_QUERY_PORT} -uroot -p${FE_PASSWORD} ${FE_DB} -e 'create table bigtable(k1 tinyint, k2 smallint, k3 int, k4 bigint, k5 decimal(9,3), k6 char(5), k10 date, k11 datetime, k7 varchar(20), k8 double max, k9 float sum) engine=olap distributed by hash(k1) buckets 5 properties("storage_type"="column")'
^--------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^------^ SC2086 (info): Double quote to prevent globbing and word splitting.
Did you mean:
mysql -h "${FE_HOST}" -P"${FE_QUERY_PORT}" -uroot -p"${FE_PASSWORD}" "${FE_DB}" -e 'create table bigtable(k1 tinyint, k2 smallint, k3 int, k4 bigint, k5 decimal(9,3), k6 char(5), k10 date, k11 datetime, k7 varchar(20), k8 double max, k9 float sum) engine=olap distributed by hash(k1) buckets 5 properties("storage_type"="column")'
In pytest/deploy/qe/init_data_stream.sh line 34:
curl --location-trusted -T baseall.txt -u root:${FE_PASSWORD} http://${FE_HOST}:${FE_WEB_PORT}/api/${FE_DB}/bigtable/_stream_load
^------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^------^ SC2086 (info): Double quote to prevent globbing and word splitting.
Did you mean:
curl --location-trusted -T baseall.txt -u root:"${FE_PASSWORD}" http://"${FE_HOST}":"${FE_WEB_PORT}"/api/"${FE_DB}"/bigtable/_stream_load
In pytest/deploy/qe/init_data_unique.sh line 23:
mysql -h ${FE_HOST} -P${FE_QUERY_PORT} -uroot -p${FE_PASSWORD} -e "DROP DATABASE IF EXISTS ${FE_DB}"
^--------^ SC2154 (warning): FE_HOST is referenced but not assigned.
^--------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------------^ SC2154 (warning): FE_QUERY_PORT is referenced but not assigned.
^--------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^------------^ SC2154 (warning): FE_PASSWORD is referenced but not assigned.
^------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^------^ SC2154 (warning): FE_DB is referenced but not assigned.
Did you mean:
mysql -h "${FE_HOST}" -P"${FE_QUERY_PORT}" -uroot -p"${FE_PASSWORD}" -e "DROP DATABASE IF EXISTS ${FE_DB}"
In pytest/deploy/qe/init_data_unique.sh line 24:
mysql -h ${FE_HOST} -P${FE_QUERY_PORT} -uroot -p${FE_PASSWORD} -e "create database ${FE_DB}"
^--------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
Did you mean:
mysql -h "${FE_HOST}" -P"${FE_QUERY_PORT}" -uroot -p"${FE_PASSWORD}" -e "create database ${FE_DB}"
In pytest/deploy/qe/init_data_unique.sh line 26:
mysql -h ${FE_HOST} -P${FE_QUERY_PORT} -uroot -p${FE_PASSWORD} -e "create table ${FE_DB}.baseall(k1 tinyint, k2 smallint, k3 int, k4 bigint, k5 decimal(9,3), k6 char(5), k10 date, k11 datetime, k7 varchar(20), k8 double, k9 float ) engine=olap unique key (k1, k2, k3, k4, k5, k6, k10) distributed by hash(k1) buckets 5 properties('storage_type'='column')"
^--------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
Did you mean:
mysql -h "${FE_HOST}" -P"${FE_QUERY_PORT}" -uroot -p"${FE_PASSWORD}" -e "create table ${FE_DB}.baseall(k1 tinyint, k2 smallint, k3 int, k4 bigint, k5 decimal(9,3), k6 char(5), k10 date, k11 datetime, k7 varchar(20), k8 double, k9 float ) engine=olap unique key (k1, k2, k3, k4, k5, k6, k10) distributed by hash(k1) buckets 5 properties('storage_type'='column')"
In pytest/deploy/qe/init_data_unique.sh line 28:
mysql -h ${FE_HOST} -P${FE_QUERY_PORT} -uroot -p${FE_PASSWORD} -e "create table ${FE_DB}.test(k1 tinyint, k2 smallint, k3 int, k4 bigint, k5 decimal(9,3), k6 char(5), k10 date, k11 datetime, k7 varchar(20), k8 double, k9 float) engine=olap unique key (k1, k2, k3, k4, k5, k6, k10) partition by range(k1) (partition p1 values less than ('-64'), partition p2 values less than ('0'), partition p3 values less than ('64'), partition p4 values less than maxvalue ) distributed by hash(k1) buckets 5 properties('storage_type'='column')"
^--------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
Did you mean:
mysql -h "${FE_HOST}" -P"${FE_QUERY_PORT}" -uroot -p"${FE_PASSWORD}" -e "create table ${FE_DB}.test(k1 tinyint, k2 smallint, k3 int, k4 bigint, k5 decimal(9,3), k6 char(5), k10 date, k11 datetime, k7 varchar(20), k8 double, k9 float) engine=olap unique key (k1, k2, k3, k4, k5, k6, k10) partition by range(k1) (partition p1 values less than ('-64'), partition p2 values less than ('0'), partition p3 values less than ('64'), partition p4 values less than maxvalue ) distributed by hash(k1) buckets 5 properties('storage_type'='column')"
In pytest/deploy/qe/init_data_unique.sh line 30:
mysql -h ${FE_HOST} -P${FE_QUERY_PORT} -uroot -p${FE_PASSWORD} -e "create table ${FE_DB}.bigtable(k1 tinyint, k2 smallint, k3 int, k4 bigint, k5 decimal(9,3), k6 char(5), k10 date, k11 datetime, k7 varchar(20), k8 double, k9 float) engine=olap unique key (k1, k2, k3, k4, k5, k6, k10) distributed by hash(k1) buckets 5 properties('storage_type'='column')"
^--------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
Did you mean:
mysql -h "${FE_HOST}" -P"${FE_QUERY_PORT}" -uroot -p"${FE_PASSWORD}" -e "create table ${FE_DB}.bigtable(k1 tinyint, k2 smallint, k3 int, k4 bigint, k5 decimal(9,3), k6 char(5), k10 date, k11 datetime, k7 varchar(20), k8 double, k9 float) engine=olap unique key (k1, k2, k3, k4, k5, k6, k10) distributed by hash(k1) buckets 5 properties('storage_type'='column')"
In pytest/deploy/qe/init_data_unique.sh line 32:
mysql -h ${FE_HOST} -P${FE_QUERY_PORT} -uroot -p${FE_PASSWORD} -e "LOAD LABEL ${FE_DB}.label_1 (DATA INFILE('$hdfs_data_path/qe/baseall.txt') INTO TABLE baseall COLUMNS TERMINATED BY '$separator') $broker_property"
^--------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^-------------^ SC2154 (warning): hdfs_data_path is referenced but not assigned.
^-------------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
^--------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
^--------------^ SC2154 (warning): broker_property is referenced but not assigned.
^--------------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
Did you mean:
mysql -h "${FE_HOST}" -P"${FE_QUERY_PORT}" -uroot -p"${FE_PASSWORD}" -e "LOAD LABEL ${FE_DB}.label_1 (DATA INFILE('${hdfs_data_path}/qe/baseall.txt') INTO TABLE baseall COLUMNS TERMINATED BY '${separator}') ${broker_property}"
In pytest/deploy/qe/init_data_unique.sh line 34:
mysql -h ${FE_HOST} -P${FE_QUERY_PORT} -uroot -p${FE_PASSWORD} -e "LOAD LABEL ${FE_DB}.label_2 (DATA INFILE('$hdfs_data_path/qe/baseall.txt') INTO TABLE test COLUMNS TERMINATED BY '$separator') $broker_property"
^--------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^-------------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
^--------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
^--------------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
Did you mean:
mysql -h "${FE_HOST}" -P"${FE_QUERY_PORT}" -uroot -p"${FE_PASSWORD}" -e "LOAD LABEL ${FE_DB}.label_2 (DATA INFILE('${hdfs_data_path}/qe/baseall.txt') INTO TABLE test COLUMNS TERMINATED BY '${separator}') ${broker_property}"
In pytest/deploy/qe/init_data_unique.sh line 36:
mysql -h ${FE_HOST} -P${FE_QUERY_PORT} -uroot -p${FE_PASSWORD} -e "LOAD LABEL ${FE_DB}.label_3 (DATA INFILE('$hdfs_data_path/qe/xaaa') INTO TABLE test COLUMNS TERMINATED BY '$separator') $broker_property"
^--------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^-------------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
^--------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
^--------------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
Did you mean:
mysql -h "${FE_HOST}" -P"${FE_QUERY_PORT}" -uroot -p"${FE_PASSWORD}" -e "LOAD LABEL ${FE_DB}.label_3 (DATA INFILE('${hdfs_data_path}/qe/xaaa') INTO TABLE test COLUMNS TERMINATED BY '${separator}') ${broker_property}"
In pytest/deploy/qe/init_data_unique.sh line 38:
mysql -h ${FE_HOST} -P${FE_QUERY_PORT} -uroot -p${FE_PASSWORD} -e "LOAD LABEL ${FE_DB}.label_4 (DATA INFILE('$hdfs_data_path/qe/baseall.txt') INTO TABLE bigtable COLUMNS TERMINATED BY '$separator') $broker_property"
^--------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^-------------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
^--------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
^--------------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
Did you mean:
mysql -h "${FE_HOST}" -P"${FE_QUERY_PORT}" -uroot -p"${FE_PASSWORD}" -e "LOAD LABEL ${FE_DB}.label_4 (DATA INFILE('${hdfs_data_path}/qe/baseall.txt') INTO TABLE bigtable COLUMNS TERMINATED BY '${separator}') ${broker_property}"
In pytest/deploy/qe/init_ext.sh line 19:
mysql -h ${FE_HOST} -P${FE_QUERY_PORT} -uroot@test_cluster -e 'DROP DATABASE IF EXISTS test_query_qa'
^--------^ SC2154 (warning): FE_HOST is referenced but not assigned.
^--------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------------^ SC2154 (warning): FE_QUERY_PORT is referenced but not assigned.
^--------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
Did you mean:
mysql -h "${FE_HOST}" -P"${FE_QUERY_PORT}" -uroot@test_cluster -e 'DROP DATABASE IF EXISTS test_query_qa'
In pytest/deploy/qe/init_ext.sh line 20:
mysql -h ${FE_HOST} -P${FE_QUERY_PORT} -uroot@test_cluster -e 'create database test_query_qa'
^--------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
Did you mean:
mysql -h "${FE_HOST}" -P"${FE_QUERY_PORT}" -uroot@test_cluster -e 'create database test_query_qa'
In pytest/deploy/qe/init_ext.sh line 21:
mysql -h ${FE_HOST} -P${FE_QUERY_PORT} -uroot@test_cluster -e 'create EXTERNAL table test_query_qa.baseall(k1 tinyint, k2 smallint, k3 int, k4 bigint, k5 decimal(9,3), k6 char(5), k10 date, k11 datetime, k7 varchar(20), k8 double max, k9 float sum) engine=broker properties("broker_name" = "hdfs", "path" = "hdfs://xxxxxxx/qe/baseall.txt", "column_separator" = "\t") BROKER PROPERTIES ("username"="root", "password"="")'
^--------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
Did you mean:
mysql -h "${FE_HOST}" -P"${FE_QUERY_PORT}" -uroot@test_cluster -e 'create EXTERNAL table test_query_qa.baseall(k1 tinyint, k2 smallint, k3 int, k4 bigint, k5 decimal(9,3), k6 char(5), k10 date, k11 datetime, k7 varchar(20), k8 double max, k9 float sum) engine=broker properties("broker_name" = "hdfs", "path" = "hdfs://xxxxxxx/qe/baseall.txt", "column_separator" = "\t") BROKER PROPERTIES ("username"="root", "password"="")'
In pytest/deploy/qe/init_ext.sh line 22:
mysql -h ${FE_HOST} -P${FE_QUERY_PORT} -uroot@test_cluster -e 'create EXTERNAL table test_query_qa.test(k1 tinyint, k2 smallint, k3 int, k4 bigint, k5 decimal(9,3), k6 char(5), k10 date, k11 datetime, k7 varchar(20), k8 double max, k9 float sum) engine=broker properties( "broker_name" = "hdfs", "path" = "hdfs://xxxxxxxx/qe/baseall.txt, hdfs://xxxxxxxx/qe/xaaa", "column_separator" = "\t") BROKER PROPERTIES ("username"="root", "password"="")'
^--------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
Did you mean:
mysql -h "${FE_HOST}" -P"${FE_QUERY_PORT}" -uroot@test_cluster -e 'create EXTERNAL table test_query_qa.test(k1 tinyint, k2 smallint, k3 int, k4 bigint, k5 decimal(9,3), k6 char(5), k10 date, k11 datetime, k7 varchar(20), k8 double max, k9 float sum) engine=broker properties( "broker_name" = "hdfs", "path" = "hdfs://xxxxxxxx/qe/baseall.txt, hdfs://xxxxxxxx/qe/xaaa", "column_separator" = "\t") BROKER PROPERTIES ("username"="root", "password"="")'
In pytest/deploy/qe/init_ext.sh line 23:
mysql -h ${FE_HOST} -P${FE_QUERY_PORT} -uroot@test_cluster -e 'create EXTERNAL table test_query_qa.bigtable(k1 tinyint, k2 smallint, k3 int, k4 bigint, k5 decimal(9,3), k6 char(5), k10 date, k11 datetime, k7 varchar(20), k8 double max, k9 float sum) engine=broker properties( "broker_name" = "hdfs", "path" = "hdfs://xxxxxxxx/qe/baseall.txt", "column_separator" = "\t") BROKER PROPERTIES ("username"="root", "password"="")'
^--------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
Did you mean:
mysql -h "${FE_HOST}" -P"${FE_QUERY_PORT}" -uroot@test_cluster -e 'create EXTERNAL table test_query_qa.bigtable(k1 tinyint, k2 smallint, k3 int, k4 bigint, k5 decimal(9,3), k6 char(5), k10 date, k11 datetime, k7 varchar(20), k8 double max, k9 float sum) engine=broker properties( "broker_name" = "hdfs", "path" = "hdfs://xxxxxxxx/qe/baseall.txt", "column_separator" = "\t") BROKER PROPERTIES ("username"="root", "password"="")'
In pytest/deploy/qe/init_mysql.sh line 20:
mysql -h ${MYSQL_HOST} -P${MYSQL_PORT} -u${MYSQL_USER} -p${MYSQL_PASSWORD} -e "DROP DATABASE IF EXISTS ${MYSQL_DB}"
^-----------^ SC2154 (warning): MYSQL_HOST is referenced but not assigned.
^-----------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^-----------^ SC2154 (warning): MYSQL_PORT is referenced but not assigned.
^-----------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^-----------^ SC2154 (warning): MYSQL_USER is referenced but not assigned.
^-----------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^---------------^ SC2154 (warning): MYSQL_PASSWORD is referenced but not assigned.
^---------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^---------^ SC2154 (warning): MYSQL_DB is referenced but not assigned.
Did you mean:
mysql -h "${MYSQL_HOST}" -P"${MYSQL_PORT}" -u"${MYSQL_USER}" -p"${MYSQL_PASSWORD}" -e "DROP DATABASE IF EXISTS ${MYSQL_DB}"
In pytest/deploy/qe/init_mysql.sh line 22:
mysql -h ${MYSQL_HOST} -P${MYSQL_PORT} -u${MYSQL_USER} -p${MYSQL_PASSWORD} -e "CREATE DATABASE ${MYSQL_DB}"
^-----------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^-----------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^-----------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^---------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
Did you mean:
mysql -h "${MYSQL_HOST}" -P"${MYSQL_PORT}" -u"${MYSQL_USER}" -p"${MYSQL_PASSWORD}" -e "CREATE DATABASE ${MYSQL_DB}"
In pytest/deploy/qe/init_mysql.sh line 24:
mysql -h ${MYSQL_HOST} -P${MYSQL_PORT} -u${MYSQL_USER} -p${MYSQL_PASSWORD} ${MYSQL_DB} -e 'CREATE TABLE `baseall` ( `k1` tinyint(4) DEFAULT NULL, `k2` smallint(6) DEFAULT NULL, `k3` int(11) DEFAULT NULL, `k4` bigint(20) DEFAULT NULL, `k5` decimal(9,3) DEFAULT NULL, `k6` char(5) DEFAULT NULL, `k10` date DEFAULT NULL, `k11` datetime DEFAULT NULL, `k7` varchar(20) DEFAULT NULL, `k8` double DEFAULT NULL, `k9` float DEFAULT NULL)'
^-----------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^-----------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^-----------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^---------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^---------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^-- SC2016 (info): Expressions don't expand in single quotes, use double quotes for that.
Did you mean:
mysql -h "${MYSQL_HOST}" -P"${MYSQL_PORT}" -u"${MYSQL_USER}" -p"${MYSQL_PASSWORD}" "${MYSQL_DB}" -e 'CREATE TABLE `baseall` ( `k1` tinyint(4) DEFAULT NULL, `k2` smallint(6) DEFAULT NULL, `k3` int(11) DEFAULT NULL, `k4` bigint(20) DEFAULT NULL, `k5` decimal(9,3) DEFAULT NULL, `k6` char(5) DEFAULT NULL, `k10` date DEFAULT NULL, `k11` datetime DEFAULT NULL, `k7` varchar(20) DEFAULT NULL, `k8` double DEFAULT NULL, `k9` float DEFAULT NULL)'
In pytest/deploy/qe/init_mysql.sh line 25:
mysql -h ${MYSQL_HOST} -P${MYSQL_PORT} -u${MYSQL_USER} -p${MYSQL_PASSWORD} ${MYSQL_DB} -e 'CREATE TABLE `bigtable` ( `k1` tinyint(4) DEFAULT NULL, `k2` smallint(6) DEFAULT NULL, `k3` int(11) DEFAULT NULL, `k4` bigint(20) DEFAULT NULL, `k5` decimal(9,3) DEFAULT NULL, `k6` char(5) DEFAULT NULL, `k10` date DEFAULT NULL, `k11` datetime DEFAULT NULL, `k7` varchar(20) DEFAULT NULL, `k8` double DEFAULT NULL, `k9` float DEFAULT NULL)'
^-----------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^-----------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^-----------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^---------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^---------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^-- SC2016 (info): Expressions don't expand in single quotes, use double quotes for that.
Did you mean:
mysql -h "${MYSQL_HOST}" -P"${MYSQL_PORT}" -u"${MYSQL_USER}" -p"${MYSQL_PASSWORD}" "${MYSQL_DB}" -e 'CREATE TABLE `bigtable` ( `k1` tinyint(4) DEFAULT NULL, `k2` smallint(6) DEFAULT NULL, `k3` int(11) DEFAULT NULL, `k4` bigint(20) DEFAULT NULL, `k5` decimal(9,3) DEFAULT NULL, `k6` char(5) DEFAULT NULL, `k10` date DEFAULT NULL, `k11` datetime DEFAULT NULL, `k7` varchar(20) DEFAULT NULL, `k8` double DEFAULT NULL, `k9` float DEFAULT NULL)'
In pytest/deploy/qe/init_mysql.sh line 26:
mysql -h ${MYSQL_HOST} -P${MYSQL_PORT} -u${MYSQL_USER} -p${MYSQL_PASSWORD} ${MYSQL_DB} -e 'CREATE TABLE `test` ( `k1` tinyint(4) DEFAULT NULL, `k2` smallint(6) DEFAULT NULL, `k3` int(11) DEFAULT NULL, `k4` bigint(20) DEFAULT NULL, `k5` decimal(9,3) DEFAULT NULL, `k6` char(5) DEFAULT NULL, `k10` date DEFAULT NULL, `k11` datetime DEFAULT NULL, `k7` varchar(20) DEFAULT NULL, `k8` double DEFAULT NULL, `k9` float DEFAULT NULL)'
^-----------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^-----------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^-----------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^---------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^---------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^-- SC2016 (info): Expressions don't expand in single quotes, use double quotes for that.
Did you mean:
mysql -h "${MYSQL_HOST}" -P"${MYSQL_PORT}" -u"${MYSQL_USER}" -p"${MYSQL_PASSWORD}" "${MYSQL_DB}" -e 'CREATE TABLE `test` ( `k1` tinyint(4) DEFAULT NULL, `k2` smallint(6) DEFAULT NULL, `k3` int(11) DEFAULT NULL, `k4` bigint(20) DEFAULT NULL, `k5` decimal(9,3) DEFAULT NULL, `k6` char(5) DEFAULT NULL, `k10` date DEFAULT NULL, `k11` datetime DEFAULT NULL, `k7` varchar(20) DEFAULT NULL, `k8` double DEFAULT NULL, `k9` float DEFAULT NULL)'
In pytest/deploy/qe/init_mysql.sh line 28:
mysql -h ${MYSQL_HOST} -P${MYSQL_PORT} -u${MYSQL_USER} -p${MYSQL_PASSWORD} ${MYSQL_DB} -e 'LOAD DATA LOCAL INFILE "../../hdfs/data/qe/baseall.txt" INTO TABLE baseall'
^-----------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^-----------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^-----------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^---------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^---------^ SC2086 (info): Double quote to prevent globbing and word splitting.
Did you mean:
mysql -h "${MYSQL_HOST}" -P"${MYSQL_PORT}" -u"${MYSQL_USER}" -p"${MYSQL_PASSWORD}" "${MYSQL_DB}" -e 'LOAD DATA LOCAL INFILE "../../hdfs/data/qe/baseall.txt" INTO TABLE baseall'
In pytest/deploy/qe/init_mysql.sh line 29:
mysql -h ${MYSQL_HOST} -P${MYSQL_PORT} -u${MYSQL_USER} -p${MYSQL_PASSWORD} ${MYSQL_DB} -e 'LOAD DATA LOCAL INFILE "../../hdfs/data/qe/xaaa" INTO TABLE test'
^-----------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^-----------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^-----------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^---------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^---------^ SC2086 (info): Double quote to prevent globbing and word splitting.
Did you mean:
mysql -h "${MYSQL_HOST}" -P"${MYSQL_PORT}" -u"${MYSQL_USER}" -p"${MYSQL_PASSWORD}" "${MYSQL_DB}" -e 'LOAD DATA LOCAL INFILE "../../hdfs/data/qe/xaaa" INTO TABLE test'
In pytest/deploy/qe/init_mysql.sh line 30:
mysql -h ${MYSQL_HOST} -P${MYSQL_PORT} -u${MYSQL_USER} -p${MYSQL_PASSWORD} ${MYSQL_DB} -e 'LOAD DATA LOCAL INFILE "../../hdfs/data/qe/baseall.txt" INTO TABLE test'
^-----------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^-----------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^-----------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^---------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^---------^ SC2086 (info): Double quote to prevent globbing and word splitting.
Did you mean:
mysql -h "${MYSQL_HOST}" -P"${MYSQL_PORT}" -u"${MYSQL_USER}" -p"${MYSQL_PASSWORD}" "${MYSQL_DB}" -e 'LOAD DATA LOCAL INFILE "../../hdfs/data/qe/baseall.txt" INTO TABLE test'
In pytest/deploy/qe/init_mysql.sh line 31:
mysql -h ${MYSQL_HOST} -P${MYSQL_PORT} -u${MYSQL_USER} -p${MYSQL_PASSWORD} ${MYSQL_DB} -e 'LOAD DATA LOCAL INFILE "../../hdfs/data/qe/baseall.txt" INTO TABLE bigtable'
^-----------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^-----------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^-----------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^---------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^---------^ SC2086 (info): Double quote to prevent globbing and word splitting.
Did you mean:
mysql -h "${MYSQL_HOST}" -P"${MYSQL_PORT}" -u"${MYSQL_USER}" -p"${MYSQL_PASSWORD}" "${MYSQL_DB}" -e 'LOAD DATA LOCAL INFILE "../../hdfs/data/qe/baseall.txt" INTO TABLE bigtable'
In pytest/qe/palo2/data/init_lateral_view.sh line 24:
mysql -h ${FE_HOST} -P${FE_QUERY_PORT} -uroot -p${FE_PASSWORD} -e "DROP DATABASE IF EXISTS test_lateral_view"
^--------^ SC2154 (warning): FE_HOST is referenced but not assigned.
^--------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------------^ SC2154 (warning): FE_QUERY_PORT is referenced but not assigned.
^--------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^------------^ SC2154 (warning): FE_PASSWORD is referenced but not assigned.
^------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
Did you mean:
mysql -h "${FE_HOST}" -P"${FE_QUERY_PORT}" -uroot -p"${FE_PASSWORD}" -e "DROP DATABASE IF EXISTS test_lateral_view"
In pytest/qe/palo2/data/init_lateral_view.sh line 25:
mysql -h ${FE_HOST} -P${FE_QUERY_PORT} -uroot -p${FE_PASSWORD} -e "create database test_lateral_view"
^--------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
Did you mean:
mysql -h "${FE_HOST}" -P"${FE_QUERY_PORT}" -uroot -p"${FE_PASSWORD}" -e "create database test_lateral_view"
In pytest/qe/palo2/data/init_lateral_view.sh line 27:
mysql -h ${FE_HOST} -P${FE_QUERY_PORT} -uroot -p${FE_PASSWORD} -e "create table test_lateral_view.lateral_view_data(k1 int, k2 int, k3 int, k4 varchar(500), k5 varchar(500), k6 varchar(500), k7 varchar(500), k8 varchar(500), k9 bitmap bitmap_union) DISTRIBUTED BY HASH(k1)"
^--------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
Did you mean:
mysql -h "${FE_HOST}" -P"${FE_QUERY_PORT}" -uroot -p"${FE_PASSWORD}" -e "create table test_lateral_view.lateral_view_data(k1 int, k2 int, k3 int, k4 varchar(500), k5 varchar(500), k6 varchar(500), k7 varchar(500), k8 varchar(500), k9 bitmap bitmap_union) DISTRIBUTED BY HASH(k1)"
In pytest/qe/palo2/data/init_lateral_view.sh line 28:
mysql -h ${FE_HOST} -P${FE_QUERY_PORT} -uroot -p${FE_PASSWORD} -e "LOAD LABEL test_lateral_view.label_1 (DATA INFILE('$hdfs_path/lateral_view_data') INTO TABLE lateral_view_data (k1,k2,k3,k4,k5,k6,k7,k8) set (k9=bitmap_from_string(k8))) WITH BROKER '$broker' ('username'='$username', 'password'='$password')"
^--------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
^-----^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
^-------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
^-------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
Did you mean:
mysql -h "${FE_HOST}" -P"${FE_QUERY_PORT}" -uroot -p"${FE_PASSWORD}" -e "LOAD LABEL test_lateral_view.label_1 (DATA INFILE('${hdfs_path}/lateral_view_data') INTO TABLE lateral_view_data (k1,k2,k3,k4,k5,k6,k7,k8) set (k9=bitmap_from_string(k8))) WITH BROKER '${broker}' ('username'='${username}', 'password'='${password}')"
In pytest/qe/palo2/data/init_lateral_view.sh line 30:
mysql -h ${FE_HOST} -P${FE_QUERY_PORT} -uroot -p${FE_PASSWORD} -e "create table test_lateral_view.lateral_view_check(k1 int, k2 int, k3 int, k4 varchar(50), k5 varchar(50), k6 bigint, k7 double, k8 bigint) DISTRIBUTED BY HASH(k1)"
^--------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
Did you mean:
mysql -h "${FE_HOST}" -P"${FE_QUERY_PORT}" -uroot -p"${FE_PASSWORD}" -e "create table test_lateral_view.lateral_view_check(k1 int, k2 int, k3 int, k4 varchar(50), k5 varchar(50), k6 bigint, k7 double, k8 bigint) DISTRIBUTED BY HASH(k1)"
In pytest/qe/palo2/data/init_lateral_view.sh line 31:
mysql -h ${FE_HOST} -P${FE_QUERY_PORT} -uroot -p${FE_PASSWORD} -e "LOAD LABEL test_lateral_view.label_2 (DATA INFILE('$hdfs_path/lateral_view_check') INTO TABLE lateral_view_check (k1,k2,k3,k4,k5,k6,k7,k8)) WITH BROKER '$broker' ('username'='$username', 'password'='$password')"
^--------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
^-----^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
^-------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
^-------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
Did you mean:
mysql -h "${FE_HOST}" -P"${FE_QUERY_PORT}" -uroot -p"${FE_PASSWORD}" -e "LOAD LABEL test_lateral_view.label_2 (DATA INFILE('${hdfs_path}/lateral_view_check') INTO TABLE lateral_view_check (k1,k2,k3,k4,k5,k6,k7,k8)) WITH BROKER '${broker}' ('username'='${username}', 'password'='${password}')"
In pytest/qe/palo2/data/init_lateral_view.sh line 32:
mysql -h ${FE_HOST} -P${FE_QUERY_PORT} -uroot -p${FE_PASSWORD} -e "create table test_lateral_view.test_aggregate_key(k1 int, k2 int, k3 int, k4 varchar(500), k5 varchar(500), k6 varchar(500), k7 varchar(500), k8 varchar(500), k9 bitmap bitmap_union) AGGREGATE KEY(k1,k2,k3,k4,k5,k6,k7,k8) DISTRIBUTED BY HASH(k1)"
^--------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
Did you mean:
mysql -h "${FE_HOST}" -P"${FE_QUERY_PORT}" -uroot -p"${FE_PASSWORD}" -e "create table test_lateral_view.test_aggregate_key(k1 int, k2 int, k3 int, k4 varchar(500), k5 varchar(500), k6 varchar(500), k7 varchar(500), k8 varchar(500), k9 bitmap bitmap_union) AGGREGATE KEY(k1,k2,k3,k4,k5,k6,k7,k8) DISTRIBUTED BY HASH(k1)"
In pytest/qe/palo2/data/init_lateral_view.sh line 33:
mysql -h ${FE_HOST} -P${FE_QUERY_PORT} -uroot -p${FE_PASSWORD} -e "LOAD LABEL test_lateral_view.label_3 (DATA INFILE('$hdfs_path/lateral_view_data') INTO TABLE test_aggregate_key (k1,k2,k3,k4,k5,k6,k7,k8) set (k9=bitmap_from_string(k8))) WITH BROKER '$broker' ('username'='$username', 'password'='$password')"
^--------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
^-----^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
^-------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
^-------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
Did you mean:
mysql -h "${FE_HOST}" -P"${FE_QUERY_PORT}" -uroot -p"${FE_PASSWORD}" -e "LOAD LABEL test_lateral_view.label_3 (DATA INFILE('${hdfs_path}/lateral_view_data') INTO TABLE test_aggregate_key (k1,k2,k3,k4,k5,k6,k7,k8) set (k9=bitmap_from_string(k8))) WITH BROKER '${broker}' ('username'='${username}', 'password'='${password}')"
In pytest/qe/palo2/data/init_lateral_view.sh line 35:
mysql -h ${FE_HOST} -P${FE_QUERY_PORT} -uroot -p${FE_PASSWORD} -e "create table test_lateral_view.test_aggregate_key_bucket(k1 int, k2 int, k3 int, k4 varchar(500), k5 varchar(500), k6 varchar(500), k7 varchar(500), k8 varchar(500), k9 bitmap bitmap_union) AGGREGATE KEY(k1,k2,k3,k4,k5,k6,k7,k8) DISTRIBUTED BY HASH(k1,k2,k3,k4,k5,k6,k7,k8)"
^--------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
Did you mean:
mysql -h "${FE_HOST}" -P"${FE_QUERY_PORT}" -uroot -p"${FE_PASSWORD}" -e "create table test_lateral_view.test_aggregate_key_bucket(k1 int, k2 int, k3 int, k4 varchar(500), k5 varchar(500), k6 varchar(500), k7 varchar(500), k8 varchar(500), k9 bitmap bitmap_union) AGGREGATE KEY(k1,k2,k3,k4,k5,k6,k7,k8) DISTRIBUTED BY HASH(k1,k2,k3,k4,k5,k6,k7,k8)"
In pytest/qe/palo2/data/init_lateral_view.sh line 36:
mysql -h ${FE_HOST} -P${FE_QUERY_PORT} -uroot -p${FE_PASSWORD} -e "LOAD LABEL test_lateral_view.label_4 (DATA INFILE('$hdfs_path/lateral_view_data') INTO TABLE test_aggregate_key_bucket (k1,k2,k3,k4,k5,k6,k7,k8) set (k9=bitmap_from_string(k8))) WITH BROKER '$broker' ('username'='$username', 'password'='$password')"
^--------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
^-----^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
^-------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
^-------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
Did you mean:
mysql -h "${FE_HOST}" -P"${FE_QUERY_PORT}" -uroot -p"${FE_PASSWORD}" -e "LOAD LABEL test_lateral_view.label_4 (DATA INFILE('${hdfs_path}/lateral_view_data') INTO TABLE test_aggregate_key_bucket (k1,k2,k3,k4,k5,k6,k7,k8) set (k9=bitmap_from_string(k8))) WITH BROKER '${broker}' ('username'='${username}', 'password'='${password}')"
In pytest/qe/palo2/data/init_lateral_view.sh line 38:
mysql -h ${FE_HOST} -P${FE_QUERY_PORT} -uroot -p${FE_PASSWORD} -e "create table test_lateral_view.test_aggregate_value_replace(k1 int, k2 int, k3 int, k4 varchar(500) replace, k5 varchar(500) replace, k6 varchar(500) replace, k7 varchar(500) replace, k8 varchar(500) replace, k9 bitmap bitmap_union) AGGREGATE KEY(k1,k2,k3) DISTRIBUTED BY HASH(k1)"
^--------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
Did you mean:
mysql -h "${FE_HOST}" -P"${FE_QUERY_PORT}" -uroot -p"${FE_PASSWORD}" -e "create table test_lateral_view.test_aggregate_value_replace(k1 int, k2 int, k3 int, k4 varchar(500) replace, k5 varchar(500) replace, k6 varchar(500) replace, k7 varchar(500) replace, k8 varchar(500) replace, k9 bitmap bitmap_union) AGGREGATE KEY(k1,k2,k3) DISTRIBUTED BY HASH(k1)"
In pytest/qe/palo2/data/init_lateral_view.sh line 39:
mysql -h ${FE_HOST} -P${FE_QUERY_PORT} -uroot -p${FE_PASSWORD} -e "LOAD LABEL test_lateral_view.label_5 (DATA INFILE('$hdfs_path/lateral_view_data') INTO TABLE test_aggregate_value_replace (k1,k2,k3,k4,k5,k6,k7,k8) set (k9=bitmap_from_string(k8))) WITH BROKER '$broker' ('username'='$username', 'password'='$password')"
^--------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
^-----^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
^-------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
^-------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
Did you mean:
mysql -h "${FE_HOST}" -P"${FE_QUERY_PORT}" -uroot -p"${FE_PASSWORD}" -e "LOAD LABEL test_lateral_view.label_5 (DATA INFILE('${hdfs_path}/lateral_view_data') INTO TABLE test_aggregate_value_replace (k1,k2,k3,k4,k5,k6,k7,k8) set (k9=bitmap_from_string(k8))) WITH BROKER '${broker}' ('username'='${username}', 'password'='${password}')"
In pytest/qe/palo2/data/init_lateral_view.sh line 41:
mysql -h ${FE_HOST} -P${FE_QUERY_PORT} -uroot -p${FE_PASSWORD} -e "create table test_lateral_view.test_aggregate_value(k1 int, k2 int, k3 int, k4 varchar(500) max, k5 varchar(500) min, k6 varchar(500) max, k7 varchar(500) max, k8 varchar(500) min, k9 bitmap bitmap_union) AGGREGATE KEY(k1,k2,k3) DISTRIBUTED BY HASH(k1)"
^--------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
Did you mean:
mysql -h "${FE_HOST}" -P"${FE_QUERY_PORT}" -uroot -p"${FE_PASSWORD}" -e "create table test_lateral_view.test_aggregate_value(k1 int, k2 int, k3 int, k4 varchar(500) max, k5 varchar(500) min, k6 varchar(500) max, k7 varchar(500) max, k8 varchar(500) min, k9 bitmap bitmap_union) AGGREGATE KEY(k1,k2,k3) DISTRIBUTED BY HASH(k1)"
In pytest/qe/palo2/data/init_lateral_view.sh line 42:
mysql -h ${FE_HOST} -P${FE_QUERY_PORT} -uroot -p${FE_PASSWORD} -e "LOAD LABEL test_lateral_view.label_6 (DATA INFILE('$hdfs_path/lateral_view_data') INTO TABLE test_aggregate_value (k1,k2,k3,k4,k5,k6,k7,k8) set (k9=bitmap_from_string(k8))) WITH BROKER '$broker' ('username'='$username', 'password'='$password')"
^--------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
^-----^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
^-------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
^-------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
Did you mean:
mysql -h "${FE_HOST}" -P"${FE_QUERY_PORT}" -uroot -p"${FE_PASSWORD}" -e "LOAD LABEL test_lateral_view.label_6 (DATA INFILE('${hdfs_path}/lateral_view_data') INTO TABLE test_aggregate_value (k1,k2,k3,k4,k5,k6,k7,k8) set (k9=bitmap_from_string(k8))) WITH BROKER '${broker}' ('username'='${username}', 'password'='${password}')"
In pytest/qe/palo2/data/init_lateral_view.sh line 44:
mysql -h ${FE_HOST} -P${FE_QUERY_PORT} -uroot -p${FE_PASSWORD} -e "create table test_lateral_view.test_unique_key(k1 int, k2 int, k3 int, k4 varchar(500), k5 varchar(500), k6 varchar(500), k7 varchar(500), k8 varchar(500), k9 varchar(500)) UNIQUE KEY(k1,k2,k3,k4,k5,k6,k7,k8) DISTRIBUTED BY HASH(k1)"
^--------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
Did you mean:
mysql -h "${FE_HOST}" -P"${FE_QUERY_PORT}" -uroot -p"${FE_PASSWORD}" -e "create table test_lateral_view.test_unique_key(k1 int, k2 int, k3 int, k4 varchar(500), k5 varchar(500), k6 varchar(500), k7 varchar(500), k8 varchar(500), k9 varchar(500)) UNIQUE KEY(k1,k2,k3,k4,k5,k6,k7,k8) DISTRIBUTED BY HASH(k1)"
In pytest/qe/palo2/data/init_lateral_view.sh line 45:
mysql -h ${FE_HOST} -P${FE_QUERY_PORT} -uroot -p${FE_PASSWORD} -e "LOAD LABEL test_lateral_view.label_7 (DATA INFILE('$hdfs_path/lateral_view_data') INTO TABLE test_unique_key (k1,k2,k3,k4,k5,k6,k7,k8) set (k9=k8)) WITH BROKER '$broker' ('username'='$username', 'password'='$password')"
^--------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
^-----^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
^-------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
^-------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
Did you mean:
mysql -h "${FE_HOST}" -P"${FE_QUERY_PORT}" -uroot -p"${FE_PASSWORD}" -e "LOAD LABEL test_lateral_view.label_7 (DATA INFILE('${hdfs_path}/lateral_view_data') INTO TABLE test_unique_key (k1,k2,k3,k4,k5,k6,k7,k8) set (k9=k8)) WITH BROKER '${broker}' ('username'='${username}', 'password'='${password}')"
In pytest/qe/palo2/data/init_lateral_view.sh line 47:
mysql -h ${FE_HOST} -P${FE_QUERY_PORT} -uroot -p${FE_PASSWORD} -e "create table test_lateral_view.test_unique_key_bucket(k1 int, k2 int, k3 int, k4 varchar(500), k5 varchar(500), k6 varchar(500), k7 varchar(500), k8 varchar(500), k9 varchar(500)) UNIQUE KEY(k1,k2,k3,k4,k5,k6,k7,k8) DISTRIBUTED BY HASH(k1,k2,k3,k4,k5,k6,k7,k8)"
^--------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
Did you mean:
mysql -h "${FE_HOST}" -P"${FE_QUERY_PORT}" -uroot -p"${FE_PASSWORD}" -e "create table test_lateral_view.test_unique_key_bucket(k1 int, k2 int, k3 int, k4 varchar(500), k5 varchar(500), k6 varchar(500), k7 varchar(500), k8 varchar(500), k9 varchar(500)) UNIQUE KEY(k1,k2,k3,k4,k5,k6,k7,k8) DISTRIBUTED BY HASH(k1,k2,k3,k4,k5,k6,k7,k8)"
In pytest/qe/palo2/data/init_lateral_view.sh line 48:
mysql -h ${FE_HOST} -P${FE_QUERY_PORT} -uroot -p${FE_PASSWORD} -e "LOAD LABEL test_lateral_view.label_8 (DATA INFILE('$hdfs_path/lateral_view_data') INTO TABLE test_unique_key_bucket (k1,k2,k3,k4,k5,k6,k7,k8) set (k9=k8)) WITH BROKER '$broker' ('username'='$username', 'password'='$password')"
^--------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
^-----^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
^-------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
^-------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
Did you mean:
mysql -h "${FE_HOST}" -P"${FE_QUERY_PORT}" -uroot -p"${FE_PASSWORD}" -e "LOAD LABEL test_lateral_view.label_8 (DATA INFILE('${hdfs_path}/lateral_view_data') INTO TABLE test_unique_key_bucket (k1,k2,k3,k4,k5,k6,k7,k8) set (k9=k8)) WITH BROKER '${broker}' ('username'='${username}', 'password'='${password}')"
In pytest/qe/palo2/data/init_lateral_view.sh line 50:
mysql -h ${FE_HOST} -P${FE_QUERY_PORT} -uroot -p${FE_PASSWORD} -e "create table test_lateral_view.test_unique_value(k1 int, k2 int, k3 int, k4 varchar(500), k5 varchar(500), k6 varchar(500), k7 varchar(500), k8 varchar(500), k9 varchar(500)) UNIQUE KEY(k1,k2,k3) DISTRIBUTED BY HASH(k1)"
^--------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
Did you mean:
mysql -h "${FE_HOST}" -P"${FE_QUERY_PORT}" -uroot -p"${FE_PASSWORD}" -e "create table test_lateral_view.test_unique_value(k1 int, k2 int, k3 int, k4 varchar(500), k5 varchar(500), k6 varchar(500), k7 varchar(500), k8 varchar(500), k9 varchar(500)) UNIQUE KEY(k1,k2,k3) DISTRIBUTED BY HASH(k1)"
In pytest/qe/palo2/data/init_lateral_view.sh line 51:
mysql -h ${FE_HOST} -P${FE_QUERY_PORT} -uroot -p${FE_PASSWORD} -e "LOAD LABEL test_lateral_view.label_9 (DATA INFILE('$hdfs_path/lateral_view_data') INTO TABLE test_unique_value (k1,k2,k3,k4,k5,k6,k7,k8) set (k9=k8)) WITH BROKER '$broker' ('username'='$username', 'password'='$password')"
^--------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
^-----^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
^-------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
^-------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
Did you mean:
mysql -h "${FE_HOST}" -P"${FE_QUERY_PORT}" -uroot -p"${FE_PASSWORD}" -e "LOAD LABEL test_lateral_view.label_9 (DATA INFILE('${hdfs_path}/lateral_view_data') INTO TABLE test_unique_value (k1,k2,k3,k4,k5,k6,k7,k8) set (k9=k8)) WITH BROKER '${broker}' ('username'='${username}', 'password'='${password}')"
In pytest/qe/palo2/data/init_lateral_view.sh line 53:
mysql -h ${FE_HOST} -P${FE_QUERY_PORT} -uroot -p${FE_PASSWORD} -e "create table test_lateral_view.test_duplicate_key(k1 int, k2 int, k3 int, k4 varchar(500), k5 varchar(500), k6 varchar(500), k7 varchar(500), k8 varchar(500), k9 varchar(500)) DUPLICATE KEY(k1,k2,k3,k4,k5,k6,k7,k8) DISTRIBUTED BY HASH(k1)"
^--------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
Did you mean:
mysql -h "${FE_HOST}" -P"${FE_QUERY_PORT}" -uroot -p"${FE_PASSWORD}" -e "create table test_lateral_view.test_duplicate_key(k1 int, k2 int, k3 int, k4 varchar(500), k5 varchar(500), k6 varchar(500), k7 varchar(500), k8 varchar(500), k9 varchar(500)) DUPLICATE KEY(k1,k2,k3,k4,k5,k6,k7,k8) DISTRIBUTED BY HASH(k1)"
In pytest/qe/palo2/data/init_lateral_view.sh line 54:
mysql -h ${FE_HOST} -P${FE_QUERY_PORT} -uroot -p${FE_PASSWORD} -e "LOAD LABEL test_lateral_view.label_10 (DATA INFILE('$hdfs_path/lateral_view_data') INTO TABLE test_duplicate_key (k1,k2,k3,k4,k5,k6,k7,k8) set (k9=k8)) WITH BROKER '$broker' ('username'='$username', 'password'='$password')"
^--------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
^-----^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
^-------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
^-------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
Did you mean:
mysql -h "${FE_HOST}" -P"${FE_QUERY_PORT}" -uroot -p"${FE_PASSWORD}" -e "LOAD LABEL test_lateral_view.label_10 (DATA INFILE('${hdfs_path}/lateral_view_data') INTO TABLE test_duplicate_key (k1,k2,k3,k4,k5,k6,k7,k8) set (k9=k8)) WITH BROKER '${broker}' ('username'='${username}', 'password'='${password}')"
In pytest/qe/palo2/data/init_lateral_view.sh line 56:
mysql -h ${FE_HOST} -P${FE_QUERY_PORT} -uroot -p${FE_PASSWORD} -e "create table test_lateral_view.test_duplicate_key_bucket(k1 int, k2 int, k3 int, k4 varchar(500), k5 varchar(500), k6 varchar(500), k7 varchar(500), k8 varchar(500), k9 varchar(500)) DUPLICATE KEY(k1,k2,k3,k4,k5,k6,k7,k8) DISTRIBUTED BY HASH(k1,k2,k3,k4,k5,k6,k7,k8)"
^--------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
Did you mean:
mysql -h "${FE_HOST}" -P"${FE_QUERY_PORT}" -uroot -p"${FE_PASSWORD}" -e "create table test_lateral_view.test_duplicate_key_bucket(k1 int, k2 int, k3 int, k4 varchar(500), k5 varchar(500), k6 varchar(500), k7 varchar(500), k8 varchar(500), k9 varchar(500)) DUPLICATE KEY(k1,k2,k3,k4,k5,k6,k7,k8) DISTRIBUTED BY HASH(k1,k2,k3,k4,k5,k6,k7,k8)"
In pytest/qe/palo2/data/init_lateral_view.sh line 57:
mysql -h ${FE_HOST} -P${FE_QUERY_PORT} -uroot -p${FE_PASSWORD} -e "LOAD LABEL test_lateral_view.label_11 (DATA INFILE('$hdfs_path/lateral_view_data') INTO TABLE test_duplicate_key_bucket (k1,k2,k3,k4,k5,k6,k7,k8) set (k9=k8)) WITH BROKER '$broker' ('username'='$username', 'password'='$password')"
^--------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
^-----^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
^-------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
^-------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
Did you mean:
mysql -h "${FE_HOST}" -P"${FE_QUERY_PORT}" -uroot -p"${FE_PASSWORD}" -e "LOAD LABEL test_lateral_view.label_11 (DATA INFILE('${hdfs_path}/lateral_view_data') INTO TABLE test_duplicate_key_bucket (k1,k2,k3,k4,k5,k6,k7,k8) set (k9=k8)) WITH BROKER '${broker}' ('username'='${username}', 'password'='${password}')"
In pytest/qe/palo2/data/init_lateral_view.sh line 59:
mysql -h ${FE_HOST} -P${FE_QUERY_PORT} -uroot -p${FE_PASSWORD} -e "create table test_lateral_view.test_duplicate_value(k1 int, k2 int, k3 int, k4 varchar(500), k5 varchar(500), k6 varchar(500), k7 varchar(500), k8 varchar(500), k9 varchar(500)) DUPLICATE KEY(k1,k2,k3) DISTRIBUTED BY HASH(k1)"
^--------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
Did you mean:
mysql -h "${FE_HOST}" -P"${FE_QUERY_PORT}" -uroot -p"${FE_PASSWORD}" -e "create table test_lateral_view.test_duplicate_value(k1 int, k2 int, k3 int, k4 varchar(500), k5 varchar(500), k6 varchar(500), k7 varchar(500), k8 varchar(500), k9 varchar(500)) DUPLICATE KEY(k1,k2,k3) DISTRIBUTED BY HASH(k1)"
In pytest/qe/palo2/data/init_lateral_view.sh line 60:
mysql -h ${FE_HOST} -P${FE_QUERY_PORT} -uroot -p${FE_PASSWORD} -e "LOAD LABEL test_lateral_view.label_12 (DATA INFILE('$hdfs_path/lateral_view_data') INTO TABLE test_duplicate_value (k1,k2,k3,k4,k5,k6,k7,k8) set (k9=k8)) WITH BROKER '$broker' ('username'='$username', 'password'='$password')"
^--------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
^-----^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
^-------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
^-------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
Did you mean:
mysql -h "${FE_HOST}" -P"${FE_QUERY_PORT}" -uroot -p"${FE_PASSWORD}" -e "LOAD LABEL test_lateral_view.label_12 (DATA INFILE('${hdfs_path}/lateral_view_data') INTO TABLE test_duplicate_value (k1,k2,k3,k4,k5,k6,k7,k8) set (k9=k8)) WITH BROKER '${broker}' ('username'='${username}', 'password'='${password}')"
In pytest/qe/palo2/data/init_lateral_view.sh line 62:
mysql -h ${FE_HOST} -P${FE_QUERY_PORT} -uroot -p${FE_PASSWORD} -e 'create table test_lateral_view.test_range_partition(k1 int, k2 int, k3 int, k4 varchar(500), k5 varchar(500), k6 varchar(500), k7 varchar(500), k8 varchar(500), k9 bitmap bitmap_union) PARTITION BY RANGE(k1) (partition p1 values less than ("-32768"), partition p2 values less than ("0"), partition p3 values less than ("32768"), partition p4 values less than ("65536")) DISTRIBUTED BY HASH(k1)'
^--------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
Did you mean:
mysql -h "${FE_HOST}" -P"${FE_QUERY_PORT}" -uroot -p"${FE_PASSWORD}" -e 'create table test_lateral_view.test_range_partition(k1 int, k2 int, k3 int, k4 varchar(500), k5 varchar(500), k6 varchar(500), k7 varchar(500), k8 varchar(500), k9 bitmap bitmap_union) PARTITION BY RANGE(k1) (partition p1 values less than ("-32768"), partition p2 values less than ("0"), partition p3 values less than ("32768"), partition p4 values less than ("65536")) DISTRIBUTED BY HASH(k1)'
In pytest/qe/palo2/data/init_lateral_view.sh line 63:
mysql -h ${FE_HOST} -P${FE_QUERY_PORT} -uroot -p${FE_PASSWORD} -e "LOAD LABEL test_lateral_view.label_13 (DATA INFILE('$hdfs_path/lateral_view_data') INTO TABLE test_range_partition (k1,k2,k3,k4,k5,k6,k7,k8) set (k9=bitmap_from_string(k8))) WITH BROKER '$broker' ('username'='$username', 'password'='$password')"
^--------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
^-----^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
^-------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
^-------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
Did you mean:
mysql -h "${FE_HOST}" -P"${FE_QUERY_PORT}" -uroot -p"${FE_PASSWORD}" -e "LOAD LABEL test_lateral_view.label_13 (DATA INFILE('${hdfs_path}/lateral_view_data') INTO TABLE test_range_partition (k1,k2,k3,k4,k5,k6,k7,k8) set (k9=bitmap_from_string(k8))) WITH BROKER '${broker}' ('username'='${username}', 'password'='${password}')"
In pytest/qe/palo2/data/init_lateral_view.sh line 65:
mysql -h ${FE_HOST} -P${FE_QUERY_PORT} -uroot -p${FE_PASSWORD} -e 'create table test_lateral_view.test_range_partition_bucket(k1 int, k2 int, k3 int, k4 varchar(500), k5 varchar(500), k6 varchar(500), k7 varchar(500), k8 varchar(500), k9 bitmap bitmap_union) PARTITION BY RANGE(k1) (partition p1 values less than ("-32768"), partition p2 values less than ("0"), partition p3 values less than ("32768"), partition p4 values less than ("65536")) DISTRIBUTED BY HASH(k1,k2,k3,k4,k5,k6,k7,k8)'
^--------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
Did you mean:
mysql -h "${FE_HOST}" -P"${FE_QUERY_PORT}" -uroot -p"${FE_PASSWORD}" -e 'create table test_lateral_view.test_range_partition_bucket(k1 int, k2 int, k3 int, k4 varchar(500), k5 varchar(500), k6 varchar(500), k7 varchar(500), k8 varchar(500), k9 bitmap bitmap_union) PARTITION BY RANGE(k1) (partition p1 values less than ("-32768"), partition p2 values less than ("0"), partition p3 values less than ("32768"), partition p4 values less than ("65536")) DISTRIBUTED BY HASH(k1,k2,k3,k4,k5,k6,k7,k8)'
In pytest/qe/palo2/data/init_lateral_view.sh line 66:
mysql -h ${FE_HOST} -P${FE_QUERY_PORT} -uroot -p${FE_PASSWORD} -e "LOAD LABEL test_lateral_view.label_14 (DATA INFILE('$hdfs_path/lateral_view_data') INTO TABLE test_range_partition_bucket (k1,k2,k3,k4,k5,k6,k7,k8) set (k9=bitmap_from_string(k8))) WITH BROKER '$broker' ('username'='$username', 'password'='$password')"
^--------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
^-----^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
^-------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
^-------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
Did you mean:
mysql -h "${FE_HOST}" -P"${FE_QUERY_PORT}" -uroot -p"${FE_PASSWORD}" -e "LOAD LABEL test_lateral_view.label_14 (DATA INFILE('${hdfs_path}/lateral_view_data') INTO TABLE test_range_partition_bucket (k1,k2,k3,k4,k5,k6,k7,k8) set (k9=bitmap_from_string(k8))) WITH BROKER '${broker}' ('username'='${username}', 'password'='${password}')"
In pytest/qe/palo2/data/init_lateral_view.sh line 68:
mysql -h ${FE_HOST} -P${FE_QUERY_PORT} -uroot -p${FE_PASSWORD} -e 'create table test_lateral_view.test_list_partition(k1 int, k2 int not null, k3 int, k4 varchar(500), k5 varchar(500), k6 varchar(500), k7 varchar(500), k8 varchar(500), k9 bitmap bitmap_union) PARTITION BY LIST(k2) (partition p1 values in ("1","2"), partition p2 values in ("3","4","5","6"), partition p3 values in ("7","8","9","10"), partition p4 values in ("11","12","13","14","15","16")) DISTRIBUTED BY HASH(k1)'
^--------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
Did you mean:
mysql -h "${FE_HOST}" -P"${FE_QUERY_PORT}" -uroot -p"${FE_PASSWORD}" -e 'create table test_lateral_view.test_list_partition(k1 int, k2 int not null, k3 int, k4 varchar(500), k5 varchar(500), k6 varchar(500), k7 varchar(500), k8 varchar(500), k9 bitmap bitmap_union) PARTITION BY LIST(k2) (partition p1 values in ("1","2"), partition p2 values in ("3","4","5","6"), partition p3 values in ("7","8","9","10"), partition p4 values in ("11","12","13","14","15","16")) DISTRIBUTED BY HASH(k1)'
In pytest/qe/palo2/data/init_lateral_view.sh line 69:
mysql -h ${FE_HOST} -P${FE_QUERY_PORT} -uroot -p${FE_PASSWORD} -e "LOAD LABEL test_lateral_view.label_15 (DATA INFILE('$hdfs_path/lateral_view_data') INTO TABLE test_list_partition (k1,k2,k3,k4,k5,k6,k7,k8) set (k9=bitmap_from_string(k8))) WITH BROKER '$broker' ('username'='$username', 'password'='$password')"
^--------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
^-----^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
^-------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
^-------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
Did you mean:
mysql -h "${FE_HOST}" -P"${FE_QUERY_PORT}" -uroot -p"${FE_PASSWORD}" -e "LOAD LABEL test_lateral_view.label_15 (DATA INFILE('${hdfs_path}/lateral_view_data') INTO TABLE test_list_partition (k1,k2,k3,k4,k5,k6,k7,k8) set (k9=bitmap_from_string(k8))) WITH BROKER '${broker}' ('username'='${username}', 'password'='${password}')"
In pytest/qe/palo2/data/init_lateral_view.sh line 71:
mysql -h ${FE_HOST} -P${FE_QUERY_PORT} -uroot -p${FE_PASSWORD} -e 'create table test_lateral_view.test_list_partition_bucket(k1 int, k2 int not null, k3 int, k4 varchar(500), k5 varchar(500), k6 varchar(500), k7 varchar(500), k8 varchar(500), k9 bitmap bitmap_union) PARTITION BY LIST(k2) (partition p1 values in ("1","2"), partition p2 values in ("3","4","5","6"), partition p3 values in ("7","8","9","10"), partition p4 values in ("11","12","13","14","15","16")) DISTRIBUTED BY HASH(k1,k2,k3,k4,k5,k6,k7,k8)'
^--------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
Did you mean:
mysql -h "${FE_HOST}" -P"${FE_QUERY_PORT}" -uroot -p"${FE_PASSWORD}" -e 'create table test_lateral_view.test_list_partition_bucket(k1 int, k2 int not null, k3 int, k4 varchar(500), k5 varchar(500), k6 varchar(500), k7 varchar(500), k8 varchar(500), k9 bitmap bitmap_union) PARTITION BY LIST(k2) (partition p1 values in ("1","2"), partition p2 values in ("3","4","5","6"), partition p3 values in ("7","8","9","10"), partition p4 values in ("11","12","13","14","15","16")) DISTRIBUTED BY HASH(k1,k2,k3,k4,k5,k6,k7,k8)'
In pytest/qe/palo2/data/init_lateral_view.sh line 72:
mysql -h ${FE_HOST} -P${FE_QUERY_PORT} -uroot -p${FE_PASSWORD} -e "LOAD LABEL test_lateral_view.label_16 (DATA INFILE('$hdfs_path/lateral_view_data') INTO TABLE test_list_partition_bucket (k1,k2,k3,k4,k5,k6,k7,k8) set (k9=bitmap_from_string(k8))) WITH BROKER '$broker' ('username'='$username', 'password'='$password')"
^--------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
^-----^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
^-------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
^-------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
Did you mean:
mysql -h "${FE_HOST}" -P"${FE_QUERY_PORT}" -uroot -p"${FE_PASSWORD}" -e "LOAD LABEL test_lateral_view.label_16 (DATA INFILE('${hdfs_path}/lateral_view_data') INTO TABLE test_list_partition_bucket (k1,k2,k3,k4,k5,k6,k7,k8) set (k9=bitmap_from_string(k8))) WITH BROKER '${broker}' ('username'='${username}', 'password'='${password}')"
In pytest/qe/palo2/data/init_lateral_view.sh line 74:
mysql -h ${FE_HOST} -P${FE_QUERY_PORT} -uroot -p${FE_PASSWORD} -e 'create table test_lateral_view.test_multi_partition(k1 int, k2 int, k3 int, k4 varchar(500), k5 varchar(500), k6 varchar(500), k7 varchar(500), k8 varchar(500), k9 bitmap bitmap_union) PARTITION BY RANGE(k1,k2) (partition p1 values less than ("-32768","2"), partition p2 values less than ("0","4"),partition p3 values less than ("32768","8"),partition p4 values less than ("65536","18")) DISTRIBUTED BY HASH(k1)'
^--------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
Did you mean:
mysql -h "${FE_HOST}" -P"${FE_QUERY_PORT}" -uroot -p"${FE_PASSWORD}" -e 'create table test_lateral_view.test_multi_partition(k1 int, k2 int, k3 int, k4 varchar(500), k5 varchar(500), k6 varchar(500), k7 varchar(500), k8 varchar(500), k9 bitmap bitmap_union) PARTITION BY RANGE(k1,k2) (partition p1 values less than ("-32768","2"), partition p2 values less than ("0","4"),partition p3 values less than ("32768","8"),partition p4 values less than ("65536","18")) DISTRIBUTED BY HASH(k1)'
In pytest/qe/palo2/data/init_lateral_view.sh line 75:
mysql -h ${FE_HOST} -P${FE_QUERY_PORT} -uroot -p${FE_PASSWORD} -e "LOAD LABEL test_lateral_view.label_17 (DATA INFILE('$hdfs_path/lateral_view_data') INTO TABLE test_multi_partition (k1,k2,k3,k4,k5,k6,k7,k8) set (k9=bitmap_from_string(k8))) WITH BROKER '$broker' ('username'='$username', 'password'='$password')"
^--------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
^-----^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
^-------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
^-------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
Did you mean:
mysql -h "${FE_HOST}" -P"${FE_QUERY_PORT}" -uroot -p"${FE_PASSWORD}" -e "LOAD LABEL test_lateral_view.label_17 (DATA INFILE('${hdfs_path}/lateral_view_data') INTO TABLE test_multi_partition (k1,k2,k3,k4,k5,k6,k7,k8) set (k9=bitmap_from_string(k8))) WITH BROKER '${broker}' ('username'='${username}', 'password'='${password}')"
In pytest/qe/palo2/data/init_lateral_view.sh line 77:
mysql -h ${FE_HOST} -P${FE_QUERY_PORT} -uroot -p${FE_PASSWORD} -e 'create table test_lateral_view.test_multi_partition_bucket(k1 int, k2 int, k3 int, k4 varchar(500), k5 varchar(500), k6 varchar(500), k7 varchar(500), k8 varchar(500), k9 bitmap bitmap_union) PARTITION BY RANGE(k1,k2) (partition p1 values less than ("-32768","-8"), partition p2 values less than ("0","0"),partition p3 values less than ("32768","8"),partition p4 values less than ("65536","18")) DISTRIBUTED BY HASH(k1,k2,k3,k4,k5,k6,k7,k8)'
^--------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
Did you mean:
mysql -h "${FE_HOST}" -P"${FE_QUERY_PORT}" -uroot -p"${FE_PASSWORD}" -e 'create table test_lateral_view.test_multi_partition_bucket(k1 int, k2 int, k3 int, k4 varchar(500), k5 varchar(500), k6 varchar(500), k7 varchar(500), k8 varchar(500), k9 bitmap bitmap_union) PARTITION BY RANGE(k1,k2) (partition p1 values less than ("-32768","-8"), partition p2 values less than ("0","0"),partition p3 values less than ("32768","8"),partition p4 values less than ("65536","18")) DISTRIBUTED BY HASH(k1,k2,k3,k4,k5,k6,k7,k8)'
In pytest/qe/palo2/data/init_lateral_view.sh line 78:
mysql -h ${FE_HOST} -P${FE_QUERY_PORT} -uroot -p${FE_PASSWORD} -e "LOAD LABEL test_lateral_view.label_18 (DATA INFILE('$hdfs_path/lateral_view_data') INTO TABLE test_multi_partition_bucket (k1,k2,k3,k4,k5,k6,k7,k8) set (k9=bitmap_from_string(k8))) WITH BROKER '$broker' ('username'='$username', 'password'='$password')"
^--------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
^-----^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
^-------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
^-------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
Did you mean:
mysql -h "${FE_HOST}" -P"${FE_QUERY_PORT}" -uroot -p"${FE_PASSWORD}" -e "LOAD LABEL test_lateral_view.label_18 (DATA INFILE('${hdfs_path}/lateral_view_data') INTO TABLE test_multi_partition_bucket (k1,k2,k3,k4,k5,k6,k7,k8) set (k9=bitmap_from_string(k8))) WITH BROKER '${broker}' ('username'='${username}', 'password'='${password}')"
In pytest/qe/palo2/data/init_lateral_view.sh line 80:
mysql -h ${FE_HOST} -P${FE_QUERY_PORT} -uroot -p${FE_PASSWORD} -e 'create table test_lateral_view.test_explode_split_type(k1 int, k2 char(255), k3 varchar(500), k4 string) DISTRIBUTED BY HASH(k1)'
^--------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
Did you mean:
mysql -h "${FE_HOST}" -P"${FE_QUERY_PORT}" -uroot -p"${FE_PASSWORD}" -e 'create table test_lateral_view.test_explode_split_type(k1 int, k2 char(255), k3 varchar(500), k4 string) DISTRIBUTED BY HASH(k1)'
In pytest/qe/palo2/data/init_lateral_view.sh line 81:
mysql -h ${FE_HOST} -P${FE_QUERY_PORT} -uroot -p${FE_PASSWORD} -e "LOAD LABEL test_lateral_view.label_19 (DATA INFILE('$hdfs_path/lateral_view_data') INTO TABLE test_explode_split_type (k1,v2,v3,v4,v5,v6,v7,v8) set (k2=v4,k3=v4,k4=v4)) WITH BROKER '$broker' ('username'='$username', 'password'='$password')"
^--------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
^-----^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
^-------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
^-------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
Did you mean:
mysql -h "${FE_HOST}" -P"${FE_QUERY_PORT}" -uroot -p"${FE_PASSWORD}" -e "LOAD LABEL test_lateral_view.label_19 (DATA INFILE('${hdfs_path}/lateral_view_data') INTO TABLE test_explode_split_type (k1,v2,v3,v4,v5,v6,v7,v8) set (k2=v4,k3=v4,k4=v4)) WITH BROKER '${broker}' ('username'='${username}', 'password'='${password}')"
In pytest/qe/palo2/data/init_lateral_view.sh line 83:
mysql -h ${FE_HOST} -P${FE_QUERY_PORT} -uroot -p${FE_PASSWORD} -e 'create table test_lateral_view.test_explode_split_type_check(k1 int, k2 varchar(50)) DISTRIBUTED BY HASH(k1)'
^--------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
Did you mean:
mysql -h "${FE_HOST}" -P"${FE_QUERY_PORT}" -uroot -p"${FE_PASSWORD}" -e 'create table test_lateral_view.test_explode_split_type_check(k1 int, k2 varchar(50)) DISTRIBUTED BY HASH(k1)'
In pytest/qe/palo2/data/init_lateral_view.sh line 84:
mysql -h ${FE_HOST} -P${FE_QUERY_PORT} -uroot -p${FE_PASSWORD} -e "LOAD LABEL test_lateral_view.label_20 (DATA INFILE('$hdfs_path/lateral_view_check') INTO TABLE test_explode_split_type_check (k1,v2,v3,v4,v5,v6,v7,v8) set (k2=v4)) WITH BROKER '$broker' ('username'='$username', 'password'='$password')"
^--------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
^-----^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
^-------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
^-------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
Did you mean:
mysql -h "${FE_HOST}" -P"${FE_QUERY_PORT}" -uroot -p"${FE_PASSWORD}" -e "LOAD LABEL test_lateral_view.label_20 (DATA INFILE('${hdfs_path}/lateral_view_check') INTO TABLE test_explode_split_type_check (k1,v2,v3,v4,v5,v6,v7,v8) set (k2=v4)) WITH BROKER '${broker}' ('username'='${username}', 'password'='${password}')"
In pytest/qe/palo2/data/init_lateral_view.sh line 86:
mysql -h ${FE_HOST} -P${FE_QUERY_PORT} -uroot -p${FE_PASSWORD} -e 'create table test_lateral_view.lateral_view_multi_data(k1 int, k2 int, k3 int, k4 varchar(2000), k5 varchar(2000), k6 varchar(2000), k7 varchar(2000), k8 varchar(2000)) DISTRIBUTED BY HASH(k1)'
^--------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
Did you mean:
mysql -h "${FE_HOST}" -P"${FE_QUERY_PORT}" -uroot -p"${FE_PASSWORD}" -e 'create table test_lateral_view.lateral_view_multi_data(k1 int, k2 int, k3 int, k4 varchar(2000), k5 varchar(2000), k6 varchar(2000), k7 varchar(2000), k8 varchar(2000)) DISTRIBUTED BY HASH(k1)'
In pytest/qe/palo2/data/init_lateral_view.sh line 87:
mysql -h ${FE_HOST} -P${FE_QUERY_PORT} -uroot -p${FE_PASSWORD} -e "LOAD LABEL test_lateral_view.label_21 (DATA INFILE('$hdfs_path/lateral_view_multi_data') INTO TABLE lateral_view_multi_data (k1,k2,k3,k4,k5,k6,k7,k8)) WITH BROKER '$broker' ('username'='$username', 'password'='$password')"
^--------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
^-----^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
^-------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
^-------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
Did you mean:
mysql -h "${FE_HOST}" -P"${FE_QUERY_PORT}" -uroot -p"${FE_PASSWORD}" -e "LOAD LABEL test_lateral_view.label_21 (DATA INFILE('${hdfs_path}/lateral_view_multi_data') INTO TABLE lateral_view_multi_data (k1,k2,k3,k4,k5,k6,k7,k8)) WITH BROKER '${broker}' ('username'='${username}', 'password'='${password}')"
In pytest/qe/palo2/data/init_lateral_view.sh line 89:
mysql -h ${FE_HOST} -P${FE_QUERY_PORT} -uroot -p${FE_PASSWORD} -e 'create table test_lateral_view.lateral_view_multi_check(k1 int, k2 int, k3 int, k4 varchar(200), k5 bigint, k6 bigint, k7 double) DISTRIBUTED BY HASH(k1)'
^--------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
Did you mean:
mysql -h "${FE_HOST}" -P"${FE_QUERY_PORT}" -uroot -p"${FE_PASSWORD}" -e 'create table test_lateral_view.lateral_view_multi_check(k1 int, k2 int, k3 int, k4 varchar(200), k5 bigint, k6 bigint, k7 double) DISTRIBUTED BY HASH(k1)'
In pytest/qe/palo2/data/init_lateral_view.sh line 90:
mysql -h ${FE_HOST} -P${FE_QUERY_PORT} -uroot -p${FE_PASSWORD} -e "LOAD LABEL test_lateral_view.label_22 (DATA INFILE('$hdfs_path/lateral_view_multi_check') INTO TABLE lateral_view_multi_check (k1,k2,k3,k4,k5,k6,k7)) WITH BROKER '$broker' ('username'='$username', 'password'='$password')"
^--------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
^-----^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
^-------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
^-------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
Did you mean:
mysql -h "${FE_HOST}" -P"${FE_QUERY_PORT}" -uroot -p"${FE_PASSWORD}" -e "LOAD LABEL test_lateral_view.label_22 (DATA INFILE('${hdfs_path}/lateral_view_multi_check') INTO TABLE lateral_view_multi_check (k1,k2,k3,k4,k5,k6,k7)) WITH BROKER '${broker}' ('username'='${username}', 'password'='${password}')"
In pytest/qe/query_regression/var.sh line 1:
# Licensed to the Apache Software Foundation (ASF) under one
^-- SC2148 (error): Tips depend on target shell and yours is unknown. Add a shebang or a 'shell' directive.
In pytest/run_case.sh line 1:
#!/usr/bin
^-- SC1008 (error): This shebang was unrecognized. ShellCheck only supports sh/bash/dash/ksh. Add a 'shell' directive to specify.
In pytest/run_case.sh line 19:
export ROOT_PATH=`pwd`
^-------^ SC2155 (warning): Declare and assign separately to avoid masking return values.
^---^ SC2006 (style): Use $(...) notation instead of legacy backticks `...`.
Did you mean:
export ROOT_PATH=$(pwd)
In pytest/run_case.sh line 20:
export SYS_PATH=$ROOT_PATH/sys
^--------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
Did you mean:
export SYS_PATH=${ROOT_PATH}/sys
In pytest/run_case.sh line 21:
export QE_PATH=$ROOT_PATH/qe/palo2/src
^--------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
Did you mean:
export QE_PATH=${ROOT_PATH}/qe/palo2/src
In pytest/run_case.sh line 22:
export QE_BUG_PATH=$ROOT_PATH/qe/query_regression
^--------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
Did you mean:
export QE_BUG_PATH=${ROOT_PATH}/qe/query_regression
In pytest/run_case.sh line 23:
export REPORT_PATH=$ROOT_PATH/result
^--------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
Did you mean:
export REPORT_PATH=${ROOT_PATH}/result
In pytest/run_case.sh line 24:
export ENV_PATH=$ROOT_PATH/lib
^--------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
Did you mean:
export ENV_PATH=${ROOT_PATH}/lib
In pytest/run_case.sh line 25:
export PYTHONPATH=$PYTHONPATH:$ROOT_PATH:$ROOT_PATH/sys:$ROOT_PATH/qe/palo2/lib:$ROOT_PATH/deploy
^---------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
^--------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
^--------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
^--------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
^--------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
Did you mean:
export PYTHONPATH=${PYTHONPATH}:${ROOT_PATH}:${ROOT_PATH}/sys:${ROOT_PATH}/qe/palo2/lib:${ROOT_PATH}/deploy
In pytest/run_case.sh line 26:
rm -f $ROOT_PATH/*.xml | tee
^--------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
Did you mean:
rm -f "${ROOT_PATH}"/*.xml | tee
In pytest/run_case.sh line 27:
rm -f $ROOT_PATH/*.html | tee
^--------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
Did you mean:
rm -f "${ROOT_PATH}"/*.html | tee
In pytest/run_case.sh line 28:
rm -rf $REPORT_PATH
^----------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^----------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
Did you mean:
rm -rf "${REPORT_PATH}"
In pytest/run_case.sh line 29:
mkdir -p $REPORT_PATH
^----------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^----------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
Did you mean:
mkdir -p "${REPORT_PATH}"
In pytest/run_case.sh line 31:
cd $SYS_PATH
^----------^ SC2164 (warning): Use 'cd ... || exit' or 'cd ... || return' in case cd fails.
^-------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^-------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
Did you mean:
cd "${SYS_PATH}" || exit
In pytest/run_case.sh line 45:
[ -e /tmp/fd1 ] || mkfifo /tmp/fd1
^-------------^ SC2292 (style): Prefer [[ ]] over [ ] for tests in Bash/Ksh.
Did you mean:
[[ -e /tmp/fd1 ]] || mkfifo /tmp/fd1
In pytest/run_case.sh line 49:
for ((i=1;i<=${PROCESS_NUM};i++))
^------------^ SC2004 (style): $/${} is unnecessary on arithmetic variables.
In pytest/run_case.sh line 57:
cd $ENV_PATH
^----------^ SC2164 (warning): Use 'cd ... || exit' or 'cd ... || return' in case cd fails.
^-------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^-------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
Did you mean:
cd "${ENV_PATH}" || exit
In pytest/run_case.sh line 67:
ls $case_file
^--------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
Did you mean:
ls "${case_file}"
In pytest/run_case.sh line 68:
pytest -sv --junit-xml=$REPORT_PATH/${case_file%.py}.xml --html=$REPORT_PATH/${case_file%.py}.html $case_file --tb=native 2>&1 > ${case_file%.py}.log
^----------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^----------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
^--------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^----------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^----------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
^--------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
^--^ SC2069 (warning): To redirect stdout+stderr, 2>&1 must be last (or use '{ cmd > file; } 2>&1' to clarify).
^--------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
Did you mean:
pytest -sv --junit-xml="${REPORT_PATH}"/"${case_file%.py}".xml --html="${REPORT_PATH}"/"${case_file%.py}".html "${case_file}" --tb=native 2>&1 > "${case_file%.py}".log
In pytest/run_case.sh line 74:
for case_file in $@
^-- SC2068 (error): Double quote array expansions to avoid re-splitting elements.
In pytest/run_case.sh line 76:
read -u3
^--^ SC2162 (info): read without -r will mangle backslashes.
In pytest/run_case.sh line 78:
echo "run $case_file"
^--------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
Did you mean:
echo "run ${case_file}"
In pytest/run_case.sh line 79:
pytest_execute $case_file
^--------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
Did you mean:
pytest_execute "${case_file}"
In pytest/run_case.sh line 80:
if [ $RESTART_BE_AUTO == true ]; then
^--------------------------^ SC2292 (style): Prefer [[ ]] over [ ] for tests in Bash/Ksh.
^--------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
Did you mean:
if [[ "${RESTART_BE_AUTO}" == true ]]; then
In pytest/run_case.sh line 94:
cd $SYS_PATH
^----------^ SC2164 (warning): Use 'cd ... || exit' or 'cd ... || return' in case cd fails.
^-------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^-------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
Did you mean:
cd "${SYS_PATH}" || exit
In pytest/run_case.sh line 95:
case_execute $case_files
^---------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^---------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
Did you mean:
case_execute "${case_files}"
In pytest/run_case.sh line 131:
cd $QE_PATH
^---------^ SC2164 (warning): Use 'cd ... || exit' or 'cd ... || return' in case cd fails.
^------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
Did you mean:
cd "${QE_PATH}" || exit
In pytest/run_case.sh line 132:
case_execute $case_files
^---------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^---------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
Did you mean:
case_execute "${case_files}"
In pytest/run_case.sh line 136:
cd $QE_BUG_PATH
^-------------^ SC2164 (warning): Use 'cd ... || exit' or 'cd ... || return' in case cd fails.
^----------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^----------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
Did you mean:
cd "${QE_BUG_PATH}" || exit
In pytest/run_case.sh line 137:
case_execute $case_files
^---------^ SC2248 (style): Prefer double quoting even when variables don't contain special characters.
^---------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
Did you mean:
case_execute "${case_files}"
In pytest/run_case.sh line 193:
cd $SYS_PATH
^----------^ SC2164 (warning): Use 'cd ... || exit' or 'cd ... || return' in case cd fails.
^-------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^-------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
Did you mean:
cd "${SYS_PATH}" || exit
In pytest/run_case.sh line 194:
case_execute $case_files
^---------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^---------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
Did you mean:
case_execute "${case_files}"
In pytest/run_case.sh line 200:
cd $SYS_PATH/test_sys_routine_load/
^-- SC2164 (warning): Use 'cd ... || exit' or 'cd ... || return' in case cd fails.
^-------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^-------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
Did you mean:
cd "${SYS_PATH}"/test_sys_routine_load/ || exit
In pytest/run_case.sh line 201:
case_execute $case_files
^---------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^---------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
Did you mean:
case_execute "${case_files}"
In pytest/run_case.sh line 207:
cd $SYS_PATH/test_sys_broker_load/
^-- SC2164 (warning): Use 'cd ... || exit' or 'cd ... || return' in case cd fails.
^-------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^-------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
Did you mean:
cd "${SYS_PATH}"/test_sys_broker_load/ || exit
In pytest/run_case.sh line 208:
case_execute $case_files
^---------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^---------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
Did you mean:
case_execute "${case_files}"
In pytest/run_case.sh line 214:
cd $SYS_PATH/test_sys_backup_restore
^-- SC2164 (warning): Use 'cd ... || exit' or 'cd ... || return' in case cd fails.
^-------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^-------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
Did you mean:
cd "${SYS_PATH}"/test_sys_backup_restore || exit
In pytest/run_case.sh line 215:
case_execute $case_files
^---------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^---------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
Did you mean:
case_execute "${case_files}"
In pytest/run_case.sh line 224:
cd $SYS_PATH/test_sys_stream_load/
^-- SC2164 (warning): Use 'cd ... || exit' or 'cd ... || return' in case cd fails.
^-------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^-------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
Did you mean:
cd "${SYS_PATH}"/test_sys_stream_load/ || exit
In pytest/run_case.sh line 225:
case_execute $case_files
^---------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^---------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
Did you mean:
case_execute "${case_files}"
In pytest/run_case.sh line 241:
cd $SYS_PATH/test_sys_alter_for_uniq/
^-- SC2164 (warning): Use 'cd ... || exit' or 'cd ... || return' in case cd fails.
^-------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^-------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
Did you mean:
cd "${SYS_PATH}"/test_sys_alter_for_uniq/ || exit
In pytest/run_case.sh line 242:
case_execute $case_files
^---------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^---------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
Did you mean:
case_execute "${case_files}"
In pytest/run_case.sh line 258:
cd $SYS_PATH/test_sys_alter_for_duplicate/
^-- SC2164 (warning): Use 'cd ... || exit' or 'cd ... || return' in case cd fails.
^-------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^-------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
Did you mean:
cd "${SYS_PATH}"/test_sys_alter_for_duplicate/ || exit
In pytest/run_case.sh line 259:
case_execute $case_files
^---------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^---------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
Did you mean:
case_execute "${case_files}"
In pytest/run_case.sh line 275:
cd $SYS_PATH/test_sys_alter_for_aggregate/
^-- SC2164 (warning): Use 'cd ... || exit' or 'cd ... || return' in case cd fails.
^-------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^-------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
Did you mean:
cd "${SYS_PATH}"/test_sys_alter_for_aggregate/ || exit
In pytest/run_case.sh line 276:
case_execute $case_files
^---------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^---------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
Did you mean:
case_execute "${case_files}"
In pytest/run_case.sh line 283:
cd $SYS_PATH/test_sys_bitmap/
^---------------------------^ SC2164 (warning): Use 'cd ... || exit' or 'cd ... || return' in case cd fails.
^-------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^-------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
Did you mean:
cd "${SYS_PATH}"/test_sys_bitmap/ || exit
In pytest/run_case.sh line 284:
case_execute $case_files
^---------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^---------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
Did you mean:
case_execute "${case_files}"
In pytest/run_case.sh line 291:
cd $SYS_PATH/test_sys_export/
^---------------------------^ SC2164 (warning): Use 'cd ... || exit' or 'cd ... || return' in case cd fails.
^-------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^-------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
Did you mean:
cd "${SYS_PATH}"/test_sys_export/ || exit
In pytest/run_case.sh line 292:
case_execute $case_files
^---------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^---------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
Did you mean:
case_execute "${case_files}"
In pytest/run_case.sh line 296:
cd $SYS_PATH/test_sys_string
^--------------------------^ SC2164 (warning): Use 'cd ... || exit' or 'cd ... || return' in case cd fails.
^-------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^-------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
Did you mean:
cd "${SYS_PATH}"/test_sys_string || exit
In pytest/run_case.sh line 297:
case_execute $case_files
^---------^ SC2248 (style): Prefer double quoting even when variables don't contain special characters.
^---------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
Did you mean:
case_execute "${case_files}"
In pytest/run_case.sh line 304:
cd $SYS_PATH/test_sys_array
^-------------------------^ SC2164 (warning): Use 'cd ... || exit' or 'cd ... || return' in case cd fails.
^-------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^-------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
Did you mean:
cd "${SYS_PATH}"/test_sys_array || exit
In pytest/run_case.sh line 305:
case_execute $case_files
^---------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^---------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
Did you mean:
case_execute "${case_files}"
In pytest/run_case.sh line 308:
if [ -z $QUERY_ONLY ]; then
^----------------^ SC2292 (style): Prefer [[ ]] over [ ] for tests in Bash/Ksh.
^---------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^---------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
Did you mean:
if [[ -z "${QUERY_ONLY}" ]]; then
In pytest/run_restart_case.sh line 1:
#!/usr/bin
^-- SC1008 (error): This shebang was unrecognized. ShellCheck only supports sh/bash/dash/ksh. Add a 'shell' directive to specify.
In pytest/run_restart_case.sh line 19:
export ROOT_PATH=`pwd`
^-------^ SC2155 (warning): Declare and assign separately to avoid masking return values.
^---^ SC2006 (style): Use $(...) notation instead of legacy backticks `...`.
Did you mean:
export ROOT_PATH=$(pwd)
In pytest/run_restart_case.sh line 20:
export SYS_PATH=$ROOT_PATH/sys
^--------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
Did you mean:
export SYS_PATH=${ROOT_PATH}/sys
In pytest/run_restart_case.sh line 21:
export QE_PATH=$ROOT_PATH/qe/palo2/src
^--------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
Did you mean:
export QE_PATH=${ROOT_PATH}/qe/palo2/src
In pytest/run_restart_case.sh line 22:
export REPORT_PATH=$ROOT_PATH/result
^--------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
Did you mean:
export REPORT_PATH=${ROOT_PATH}/result
In pytest/run_restart_case.sh line 24:
if [[ ! -d $REPORT_PATH ]]; then
^----------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
Did you mean:
if [[ ! -d ${REPORT_PATH} ]]; then
In pytest/run_restart_case.sh line 25:
mkdir -p $REPORT_PATH
^----------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^----------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
Did you mean:
mkdir -p "${REPORT_PATH}"
In pytest/run_restart_case.sh line 35:
ls $case_file
^--------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
Did you mean:
ls "${case_file}"
In pytest/run_restart_case.sh line 36:
pytest -sv --junit-xml=$REPORT_PATH/${case_file%.py}.xml --html=$REPORT_PATH/${case_file%.py}.html $case_file --tb=native 2>&1 > ${case_file%.py}.log
^----------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^----------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
^--------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^----------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^----------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
^--------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^--------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
^--^ SC2069 (warning): To redirect stdout+stderr, 2>&1 must be last (or use '{ cmd > file; } 2>&1' to clarify).
^--------------^ SC2086 (info): Double quote to prevent globbing and word splitting.
Did you mean:
pytest -sv --junit-xml="${REPORT_PATH}"/"${case_file%.py}".xml --html="${REPORT_PATH}"/"${case_file%.py}".html "${case_file}" --tb=native 2>&1 > "${case_file%.py}".log
In pytest/run_restart_case.sh line 42:
cd $SYS_PATH/test_scene
^---------------------^ SC2164 (warning): Use 'cd ... || exit' or 'cd ... || return' in case cd fails.
^-------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^-------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
Did you mean:
cd "${SYS_PATH}"/test_scene || exit
In pytest/run_restart_case.sh line 43:
pytest_execute $case
^---^ SC2248 (style): Prefer double quoting even when variables don't contain special characters.
^---^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
Did you mean:
pytest_execute "${case}"
In pytest/run_restart_case.sh line 46:
for i in $cases
^----^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
Did you mean:
for i in ${cases}
In pytest/run_restart_case.sh line 48:
cd $SYS_PATH
^----------^ SC2164 (warning): Use 'cd ... || exit' or 'cd ... || return' in case cd fails.
^-------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^-------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
Did you mean:
cd "${SYS_PATH}" || exit
In pytest/run_restart_case.sh line 49:
echo $i
^-- SC2086 (info): Double quote to prevent globbing and word splitting.
^-- SC2250 (style): Prefer putting braces around variable references even when not strictly required.
Did you mean:
echo "${i}"
In pytest/run_restart_case.sh line 50:
pytest_execute $i
^-- SC2086 (info): Double quote to prevent globbing and word splitting.
^-- SC2250 (style): Prefer putting braces around variable references even when not strictly required.
Did you mean:
pytest_execute "${i}"
In pytest/run_restart_case.sh line 55:
cd $SYS_PATH
^----------^ SC2164 (warning): Use 'cd ... || exit' or 'cd ... || return' in case cd fails.
^-------^ SC2086 (info): Double quote to prevent globbing and word splitting.
^-------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
Did you mean:
cd "${SYS_PATH}" || exit
In pytest/run_restart_case.sh line 56:
echo $i
^-- SC2248 (style): Prefer double quoting even when variables don't contain special characters.
^-- SC2250 (style): Prefer putting braces around variable references even when not strictly required.
Did you mean:
echo "${i}"
In pytest/run_restart_case.sh line 57:
pytest_execute $i
^-- SC2248 (style): Prefer double quoting even when variables don't contain special characters.
^-- SC2250 (style): Prefer putting braces around variable references even when not strictly required.
Did you mean:
pytest_execute "${i}"
In pytest/var.sh line 1:
# Licensed to the Apache Software Foundation (ASF) under one
^-- SC2148 (error): Tips depend on target shell and yours is unknown. Add a shebang or a 'shell' directive.
In pytest/var.sh line 34:
root_path=`pwd`
^---^ SC2006 (style): Use $(...) notation instead of legacy backticks `...`.
Did you mean:
root_path=$(pwd)
In pytest/var.sh line 35:
export PYTHONPATH=$root_path:$root_path/lib::$root_path/sys:$root_path/deploy:$root_path/qe/palo2/lib
^--------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
^--------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
^--------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
^--------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
^--------^ SC2250 (style): Prefer putting braces around variable references even when not strictly required.
Did you mean:
export PYTHONPATH=${root_path}:${root_path}/lib::${root_path}/sys:${root_path}/deploy:${root_path}/qe/palo2/lib
In pytest/var.sh line 38:
hdfs_data_path='hdfs://xxxxx/user/test/data'
^------------^ SC2034 (warning): hdfs_data_path appears unused. Verify use (or export if used externally).
In pytest/var.sh line 39:
broker_property="WITH BROKER 'hdfs' ('username'='root', 'password'='')"
^-------------^ SC2034 (warning): broker_property appears unused. Verify use (or export if used externally).
For more information:
https://www.shellcheck.net/wiki/SC1008 -- This shebang was unrecognized. Sh...
https://www.shellcheck.net/wiki/SC2068 -- Double quote array expansions to ...
https://www.shellcheck.net/wiki/SC2148 -- Tips depend on target shell and y...
----------
You can address the above issues in one of three ways:
1. Manually correct the issue in the offending shell script;
2. Disable specific issues by adding the comment:
# shellcheck disable=NNNN
above the line that contains the issue, where NNNN is the error code;
3. Add '-e NNNN' to the SHELLCHECK_OPTS setting in your .yml action file.
```
</details>
<details>
<summary>shfmt errors</summary>
```
'shfmt ' returned error 1 finding the following formatting issues:
----------
--- pytest/deploy/qe/init_data.sh.orig
+++ pytest/deploy/qe/init_data.sh
@@ -1,4 +1,4 @@
-#!/bin/sh
+#!/bin/sh
# Licensed to the Apache Software Foundation (ASF) under one
# or more contributor license agreements. See the NOTICE file
# distributed with this work for additional information
@@ -32,4 +32,3 @@
mysql -h ${FE_HOST} -P${FE_QUERY_PORT} -uroot -p${FE_PASSWORD} ${FE_DB} -e 'create table bigtable(k1 tinyint, k2 smallint, k3 int, k4 bigint, k5 decimal(9,3), k6 char(5), k10 date, k11 datetime, k7 varchar(20), k8 double max, k9 float sum) engine=olap distributed by hash(k1) buckets 5 properties("storage_type"="column")'
curl --location-trusted -T baseall.txt -u root:${FE_PASSWORD} http://${FE_HOST}:${FE_WEB_PORT}/api/${FE_DB}/bigtable/_stream_load
-
--- pytest/deploy/qe/init_data_broker.sh.orig
+++ pytest/deploy/qe/init_data_broker.sh
@@ -20,7 +20,6 @@
# hdfs_data_path='hdfs://xxxxxx'
# broker_property="WITH BROKER 'hdfs' ('username'='root', 'password'='')"
-
mysql -h ${FE_HOST} -P${FE_QUERY_PORT} -uroot -p${FE_PASSWORD} -e "DROP DATABASE IF EXISTS ${FE_DB}"
mysql -h ${FE_HOST} -P${FE_QUERY_PORT} -uroot -p${FE_PASSWORD} -e "create database ${FE_DB}"
@@ -29,7 +28,6 @@
mysql -h ${FE_HOST} -P${FE_QUERY_PORT} -uroot -p${FE_PASSWORD} -e "create table ${FE_DB}.bigtable(k1 tinyint, k2 smallint, k3 int, k4 bigint, k5 decimal(9,3), k6 char(5), k10 date, k11 datetime, k7 varchar(20), k8 double max, k9 float sum) engine=olap distributed by hash(k1) buckets 5 properties('storage_type'='column')"
mysql -h ${FE_HOST} -P${FE_QUERY_PORT} -uroot -p${FE_PASSWORD} -e "CREATE TABLE ${FE_DB}.all_type_table (tinyint_key tinyint(4) NULL, smallint_key smallint(6) NULL, int_key int(11) NOT NULL, bigint_key bigint(20) NULL, char_50_key char(50) NULL, character_key varchar(500) NOT NULL, char_key char(1) NULL, character_most_key varchar(65533) NULL, decimal_key decimal(20, 6) NULL, decimal_most_key decimal(27, 9) NULL, date_key date NULL, datetime_key datetime NULL, tinyint_value tinyint(4) SUM NULL, smallint_value smallint(6) SUM NULL, int_value int(11) SUM NULL, largeint_value largeint SUM NULL, char_50_value char(50) REPLACE NULL, character_value varchar(500) REPLACE NULL, char_value char(1) REPLACE NULL, character_most_value varchar(65533) REPLACE NULL, decimal_value decimal(20, 6) SUM NULL, decimal_most_value decimal(27, 9) SUM NULL, date_value_replace date REPLACE NULL, date_value_max date REPLACE NULL, date_value_min date REPLACE NULL, datetime_value_replace datetime REPLACE NUL
L, datetime_value_max datetime REPLACE NULL, datetime_value_min datetime REPLACE NULL, float_value float SUM NULL, double_value double SUM NULL) ENGINE=OLAP DISTRIBUTED BY HASH(tinyint_key) BUCKETS 5 PROPERTIES ('storage_type' = 'COLUMN')"
-
mysql -h ${FE_HOST} -P${FE_QUERY_PORT} -uroot -p${FE_PASSWORD} -e "LOAD LABEL ${FE_DB}.label_1 (DATA INFILE('$hdfs_data_path/qe/baseall.txt') INTO TABLE baseall COLUMNS TERMINATED BY '$separator') $broker_property"
mysql -h ${FE_HOST} -P${FE_QUERY_PORT} -uroot -p${FE_PASSWORD} -e "LOAD LABEL ${FE_DB}.label_2 (DATA INFILE('$hdfs_data_path/qe/baseall.txt') INTO TABLE test COLUMNS TERMINATED BY '$separator') $broker_property"
--- pytest/deploy/qe/init_data_list.sh.orig
+++ pytest/deploy/qe/init_data_list.sh
@@ -37,5 +37,4 @@
mysql -h ${FE_HOST} -P${FE_QUERY_PORT} -uroot -p${FE_PASSWORD} -e "LOAD LABEL ${FE_DB}.label_4 (DATA INFILE('$hdfs_data_path/qe/baseall.txt') INTO TABLE bigtable COLUMNS TERMINATED BY '$separator') $broker_property"
-
sleep 20
--- pytest/deploy/qe/init_data_stream.sh.orig
+++ pytest/deploy/qe/init_data_stream.sh
@@ -1,4 +1,4 @@
-#!/bin/sh
+#!/bin/sh
# Licensed to the Apache Software Foundation (ASF) under one
# or more contributor license agreements. See the NOTICE file
# distributed with this work for additional information
@@ -32,4 +32,3 @@
mysql -h ${FE_HOST} -P${FE_QUERY_PORT} -uroot -p${FE_PASSWORD} ${FE_DB} -e 'create table bigtable(k1 tinyint, k2 smallint, k3 int, k4 bigint, k5 decimal(9,3), k6 char(5), k10 date, k11 datetime, k7 varchar(20), k8 double max, k9 float sum) engine=olap distributed by hash(k1) buckets 5 properties("storage_type"="column")'
curl --location-trusted -T baseall.txt -u root:${FE_PASSWORD} http://${FE_HOST}:${FE_WEB_PORT}/api/${FE_DB}/bigtable/_stream_load
-
--- pytest/qe/palo2/data/init_lateral_view.sh.orig
+++ pytest/qe/palo2/data/init_lateral_view.sh
@@ -77,15 +77,14 @@
mysql -h ${FE_HOST} -P${FE_QUERY_PORT} -uroot -p${FE_PASSWORD} -e 'create table test_lateral_view.test_multi_partition_bucket(k1 int, k2 int, k3 int, k4 varchar(500), k5 varchar(500), k6 varchar(500), k7 varchar(500), k8 varchar(500), k9 bitmap bitmap_union) PARTITION BY RANGE(k1,k2) (partition p1 values less than ("-32768","-8"), partition p2 values less than ("0","0"),partition p3 values less than ("32768","8"),partition p4 values less than ("65536","18")) DISTRIBUTED BY HASH(k1,k2,k3,k4,k5,k6,k7,k8)'
mysql -h ${FE_HOST} -P${FE_QUERY_PORT} -uroot -p${FE_PASSWORD} -e "LOAD LABEL test_lateral_view.label_18 (DATA INFILE('$hdfs_path/lateral_view_data') INTO TABLE test_multi_partition_bucket (k1,k2,k3,k4,k5,k6,k7,k8) set (k9=bitmap_from_string(k8))) WITH BROKER '$broker' ('username'='$username', 'password'='$password')"
-mysql -h ${FE_HOST} -P${FE_QUERY_PORT} -uroot -p${FE_PASSWORD} -e 'create table test_lateral_view.test_explode_split_type(k1 int, k2 char(255), k3 varchar(500), k4 string) DISTRIBUTED BY HASH(k1)'
+mysql -h ${FE_HOST} -P${FE_QUERY_PORT} -uroot -p${FE_PASSWORD} -e 'create table test_lateral_view.test_explode_split_type(k1 int, k2 char(255), k3 varchar(500), k4 string) DISTRIBUTED BY HASH(k1)'
mysql -h ${FE_HOST} -P${FE_QUERY_PORT} -uroot -p${FE_PASSWORD} -e "LOAD LABEL test_lateral_view.label_19 (DATA INFILE('$hdfs_path/lateral_view_data') INTO TABLE test_explode_split_type (k1,v2,v3,v4,v5,v6,v7,v8) set (k2=v4,k3=v4,k4=v4)) WITH BROKER '$broker' ('username'='$username', 'password'='$password')"
-mysql -h ${FE_HOST} -P${FE_QUERY_PORT} -uroot -p${FE_PASSWORD} -e 'create table test_lateral_view.test_explode_split_type_check(k1 int, k2 varchar(50)) DISTRIBUTED BY HASH(k1)'
+mysql -h ${FE_HOST} -P${FE_QUERY_PORT} -uroot -p${FE_PASSWORD} -e 'create table test_lateral_view.test_explode_split_type_check(k1 int, k2 varchar(50)) DISTRIBUTED BY HASH(k1)'
mysql -h ${FE_HOST} -P${FE_QUERY_PORT} -uroot -p${FE_PASSWORD} -e "LOAD LABEL test_lateral_view.label_20 (DATA INFILE('$hdfs_path/lateral_view_check') INTO TABLE test_explode_split_type_check (k1,v2,v3,v4,v5,v6,v7,v8) set (k2=v4)) WITH BROKER '$broker' ('username'='$username', 'password'='$password')"
-mysql -h ${FE_HOST} -P${FE_QUERY_PORT} -uroot -p${FE_PASSWORD} -e 'create table test_lateral_view.lateral_view_multi_data(k1 int, k2 int, k3 int, k4 varchar(2000), k5 varchar(2000), k6 varchar(2000), k7 varchar(2000), k8 varchar(2000)) DISTRIBUTED BY HASH(k1)'
+mysql -h ${FE_HOST} -P${FE_QUERY_PORT} -uroot -p${FE_PASSWORD} -e 'create table test_lateral_view.lateral_view_multi_data(k1 int, k2 int, k3 int, k4 varchar(2000), k5 varchar(2000), k6 varchar(2000), k7 varchar(2000), k8 varchar(2000)) DISTRIBUTED BY HASH(k1)'
mysql -h ${FE_HOST} -P${FE_QUERY_PORT} -uroot -p${FE_PASSWORD} -e "LOAD LABEL test_lateral_view.label_21 (DATA INFILE('$hdfs_path/lateral_view_multi_data') INTO TABLE lateral_view_multi_data (k1,k2,k3,k4,k5,k6,k7,k8)) WITH BROKER '$broker' ('username'='$username', 'password'='$password')"
-mysql -h ${FE_HOST} -P${FE_QUERY_PORT} -uroot -p${FE_PASSWORD} -e 'create table test_lateral_view.lateral_view_multi_check(k1 int, k2 int, k3 int, k4 varchar(200), k5 bigint, k6 bigint, k7 double) DISTRIBUTED BY HASH(k1)'
+mysql -h ${FE_HOST} -P${FE_QUERY_PORT} -uroot -p${FE_PASSWORD} -e 'create table test_lateral_view.lateral_view_multi_check(k1 int, k2 int, k3 int, k4 varchar(200), k5 bigint, k6 bigint, k7 double) DISTRIBUTED BY HASH(k1)'
mysql -h ${FE_HOST} -P${FE_QUERY_PORT} -uroot -p${FE_PASSWORD} -e "LOAD LABEL test_lateral_view.label_22 (DATA INFILE('$hdfs_path/lateral_view_multi_check') INTO TABLE lateral_view_multi_check (k1,k2,k3,k4,k5,k6,k7)) WITH BROKER '$broker' ('username'='$username', 'password'='$password')"
-
--- pytest/run_case.sh.orig
+++ pytest/run_case.sh
@@ -16,7 +16,7 @@
# specific language governing permissions and limitations
# under the License.
-export ROOT_PATH=`pwd`
+export ROOT_PATH=$(pwd)
export SYS_PATH=$ROOT_PATH/sys
export QE_PATH=$ROOT_PATH/qe/palo2/src
export QE_BUG_PATH=$ROOT_PATH/qe/query_regression
@@ -46,13 +46,11 @@
exec 3<>/tmp/fd1
rm -rf /tmp/fd1
-for ((i=1;i<=${PROCESS_NUM};i++))
-do
- echo >&3
+for ((i = 1; i <= ${PROCESS_NUM}; i++)); do
+ echo >&3
done
-function check_cluster ()
-{
+function check_cluster() {
# check if fe or be dead and start it
cd $ENV_PATH
python node_op.py -c '''
@@ -61,42 +59,37 @@
'''
}
-function pytest_execute ()
-{
+function pytest_execute() {
case_file=$1
ls $case_file
- pytest -sv --junit-xml=$REPORT_PATH/${case_file%.py}.xml --html=$REPORT_PATH/${case_file%.py}.html $case_file --tb=native 2>&1 > ${case_file%.py}.log
+ pytest -sv --junit-xml=$REPORT_PATH/${case_file%.py}.xml --html=$REPORT_PATH/${case_file%.py}.html $case_file --tb=native 2>&1 >${case_file%.py}.log
sleep 1
}
-function case_execute ()
-{
- for case_file in $@
- do
+function case_execute() {
+ for case_file in $@; do
read -u3
{
echo "run $case_file"
pytest_execute $case_file
if [ $RESTART_BE_AUTO == true ]; then
check_cluster
- fi
+ fi
echo >&3
- }&
+ } &
done
}
# 执行时间较长,最先执行
-function long_time_case ()
-{
+function long_time_case() {
case_files='test_sys_partition_complex_without_restart_be.py
test_sys_storage_medium.py test_sys_delete_load.py'
cd $SYS_PATH
case_execute $case_files
}
-function query_case ()
-{
+function query_case() {
# query case
case_files='test_query_predicates.py
test_query_others.py
@@ -137,8 +130,7 @@
case_execute $case_files
}
-function sys_case ()
-{
+function sys_case() {
# sys case
case_files='test_sys_verify.py
test_sys_bloom_filter_a.py
@@ -290,7 +282,7 @@
test_select_into_query.py'
cd $SYS_PATH/test_sys_export/
case_execute $case_files
-
+
# sys/test_sys_string
case_files='test_sys_string_basic.py'
cd $SYS_PATH/test_sys_string
--- pytest/run_restart_case.sh.orig
+++ pytest/run_restart_case.sh
@@ -16,7 +16,7 @@
# specific language governing permissions and limitations
# under the License.
-export ROOT_PATH=`pwd`
+export ROOT_PATH=$(pwd)
export SYS_PATH=$ROOT_PATH/sys
export QE_PATH=$ROOT_PATH/qe/palo2/src
export REPORT_PATH=$ROOT_PATH/result
@@ -29,11 +29,10 @@
testsuite=normal
fi
-function pytest_execute()
-{
+function pytest_execute() {
case_file=$1
ls $case_file
- pytest -sv --junit-xml=$REPORT_PATH/${case_file%.py}.xml --html=$REPORT_PATH/${case_file%.py}.html $case_file --tb=native 2>&1 > ${case_file%.py}.log
+ pytest -sv --junit-xml=$REPORT_PATH/${case_file%.py}.xml --html=$REPORT_PATH/${case_file%.py}.html $case_file --tb=native 2>&1 >${case_file%.py}.log
sleep 1
}
@@ -43,8 +42,7 @@
pytest_execute $case
cases='test_sys_update_restart.py test_sys_partition_complex_with_restart_be.py test_sys_restart.py test_sys_binlog_restart.py test_sys_resource_tag.py'
-for i in $cases
-do
+for i in $cases; do
cd $SYS_PATH
echo $i
pytest_execute $i
--- pytest/var.sh.orig
+++ pytest/var.sh
@@ -31,7 +31,7 @@
export PALO_CLIENT_LOG_SQL=DEBUG
export PALO_CLIENT_STDOUT=DEBUG
-root_path=`pwd`
+root_path=$(pwd)
export PYTHONPATH=$root_path:$root_path/lib::$root_path/sys:$root_path/deploy:$root_path/qe/palo2/lib
# hdfs broker set
----------
You can reformat the above files to meet shfmt's requirements by typing:
shfmt -w filename
```
</details>
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org