This is an automated email from the ASF dual-hosted git repository.
yiguolei pushed a commit to branch branch-2.1
in repository https://gitbox.apache.org/repos/asf/doris.git
The following commit(s) were added to refs/heads/branch-2.1 by this push:
new a0a025f7633 [fix](regression test)fix test_hive_parquet_alter_column
p2 case. (#34727) (#34859)
a0a025f7633 is described below
commit a0a025f7633488aab597231ad60c1d8480724d63
Author: daidai <[email protected]>
AuthorDate: Tue May 14 23:30:06 2024 +0800
[fix](regression test)fix test_hive_parquet_alter_column p2 case. (#34727)
(#34859)
fix test_hive_parquet_alter_column p2 case.
Since this is a p2 case. The data is stored on emr, not in docker. So there
is no need to consider hive2 and hive3.
---
.../hive/test_hive_parquet_alter_column.out | 1674 --------------------
.../hive/test_hive_parquet_alter_column.groovy | 21 +-
2 files changed, 7 insertions(+), 1688 deletions(-)
diff --git
a/regression-test/data/external_table_p2/hive/test_hive_parquet_alter_column.out
b/regression-test/data/external_table_p2/hive/test_hive_parquet_alter_column.out
index b0b6de5634a..d566c008c0d 100644
---
a/regression-test/data/external_table_p2/hive/test_hive_parquet_alter_column.out
+++
b/regression-test/data/external_table_p2/hive/test_hive_parquet_alter_column.out
@@ -1674,1677 +1674,3 @@ B
-- !decimal_decimal --
--- !desc --
-col_int INT Yes true \N
-col_smallint INT Yes true \N
-col_tinyint INT Yes true \N
-col_bigint BIGINT Yes true \N
-col_float FLOAT Yes true \N
-col_double DOUBLE Yes true \N
-col_boolean BOOLEAN Yes true \N
-col_string TEXT Yes true \N
-col_char CHAR(10) Yes true \N
-col_varchar VARCHAR(255) Yes true \N
-col_date DATE Yes true \N
-col_timestamp DATETIME(6) Yes true \N
-col_decimal DECIMAL(10, 2) Yes true \N
-
--- !show --
--1 -400 -20 -400000000 40.5444 50.75 false First A
ADC 2023-10-06 2023-10-09T17:15 1238.45
--1 -400 -20 -400000000 40.5444 50.75 false First A
ADC 2023-10-06 2023-10-09T17:15 1238.45
--1 -400 -20 -400000000 40.5444 50.75 false First A
ADC 2023-10-06 2023-10-09T17:15 1238.45
--1 -400 -20 -400000000 40.5444 50.75 false First A
ADC 2023-10-06 2023-10-09T17:15 1238.45
--1 -400 -20 -400000000 40.5444 50.75 false First A
ADC 2023-10-06 2023-10-09T17:15 1238.45
--1 -400 -20 -400000000 40.5444 50.75 false First A
ADC 2023-10-06 2023-10-09T17:15 1238.45
--1 -400 -20 -400000000 40.5444 50.75 false First A
ADC 2023-10-06 2023-10-09T17:15 1238.45
-
--- !order --
--1
--1
--1
-
--- !order --
--400
--400
--400
-
--- !order --
--20
--20
--20
-
--- !order --
--400000000
--400000000
--400000000
-
--- !order --
-10.5
-10.5
-10.5
-
--- !order --
-20.75
-20.75
-20.75
-
--- !order --
-false
-false
-false
-
--- !order --
-Fifth
-Fifth
-Fifth
-
--- !order --
-A
-A
-A
-
--- !order --
-ADC
-ADC
-ADC
-
--- !order --
-2023-10-06
-2023-10-06
-2023-10-06
-
--- !order --
-2023-10-06T14:30
-2023-10-06T14:30
-2023-10-06T14:30
-
--- !order --
-123.45
-123.45
-123.45
-
--- !desc --
-col_int INT Yes true \N
-col_smallint SMALLINT Yes true \N
-col_tinyint SMALLINT Yes true \N
-col_bigint BIGINT Yes true \N
-col_float FLOAT Yes true \N
-col_double DOUBLE Yes true \N
-col_boolean BOOLEAN Yes true \N
-col_string TEXT Yes true \N
-col_char CHAR(10) Yes true \N
-col_varchar VARCHAR(255) Yes true \N
-col_date DATE Yes true \N
-col_timestamp DATETIME(6) Yes true \N
-col_decimal DECIMAL(10, 2) Yes true \N
-
--- !show --
--1 -400 -20 -400000000 40.5444 50.75 false First A
ADC 2023-10-06 2023-10-09T17:15 1238.45
--1 -400 -20 -400000000 40.5444 50.75 false First A
ADC 2023-10-06 2023-10-09T17:15 1238.45
--1 -400 -20 -400000000 40.5444 50.75 false First A
ADC 2023-10-06 2023-10-09T17:15 1238.45
--1 -400 -20 -400000000 40.5444 50.75 false First A
ADC 2023-10-06 2023-10-09T17:15 1238.45
--1 -400 -20 -400000000 40.5444 50.75 false First A
ADC 2023-10-06 2023-10-09T17:15 1238.45
--1 -400 -20 -400000000 40.5444 50.75 false First A
ADC 2023-10-06 2023-10-09T17:15 1238.45
--1 -400 -20 -400000000 40.5444 50.75 false First A
ADC 2023-10-06 2023-10-09T17:15 1238.45
-
--- !order --
--1
--1
--1
-
--- !order --
--400
--400
--400
-
--- !order --
--20
--20
--20
-
--- !order --
--400000000
--400000000
--400000000
-
--- !order --
-10.5
-10.5
-10.5
-
--- !order --
-20.75
-20.75
-20.75
-
--- !order --
-false
-false
-false
-
--- !order --
-Fifth
-Fifth
-Fifth
-
--- !order --
-A
-A
-A
-
--- !order --
-ADC
-ADC
-ADC
-
--- !order --
-2023-10-06
-2023-10-06
-2023-10-06
-
--- !order --
-2023-10-06T14:30
-2023-10-06T14:30
-2023-10-06T14:30
-
--- !order --
-123.45
-123.45
-123.45
-
--- !desc --
-col_int INT Yes true \N
-col_smallint SMALLINT Yes true \N
-col_tinyint TINYINT Yes true \N
-col_bigint BIGINT Yes true \N
-col_float FLOAT Yes true \N
-col_double DOUBLE Yes true \N
-col_boolean BOOLEAN Yes true \N
-col_string TEXT Yes true \N
-col_char CHAR(10) Yes true \N
-col_varchar VARCHAR(255) Yes true \N
-col_date DATE Yes true \N
-col_timestamp DATETIME(6) Yes true \N
-col_decimal DECIMAL(10, 2) Yes true \N
-
--- !show --
--1 -400 -20 -400000000 40.5444 50.75 false First A
ADC 2023-10-06 2023-10-09T17:15 1238.45
--1 -400 -20 -400000000 40.5444 50.75 false First A
ADC 2023-10-06 2023-10-09T17:15 1238.45
--1 -400 -20 -400000000 40.5444 50.75 false First A
ADC 2023-10-06 2023-10-09T17:15 1238.45
--1 -400 -20 -400000000 40.5444 50.75 false First A
ADC 2023-10-06 2023-10-09T17:15 1238.45
--1 -400 -20 -400000000 40.5444 50.75 false First A
ADC 2023-10-06 2023-10-09T17:15 1238.45
--1 -400 -20 -400000000 40.5444 50.75 false First A
ADC 2023-10-06 2023-10-09T17:15 1238.45
--1 -400 -20 -400000000 40.5444 50.75 false First A
ADC 2023-10-06 2023-10-09T17:15 1238.45
-
--- !order --
--1
--1
--1
-
--- !order --
--400
--400
--400
-
--- !order --
--20
--20
--20
-
--- !order --
--400000000
--400000000
--400000000
-
--- !order --
-10.5
-10.5
-10.5
-
--- !order --
-20.75
-20.75
-20.75
-
--- !order --
-false
-false
-false
-
--- !order --
-Fifth
-Fifth
-Fifth
-
--- !order --
-A
-A
-A
-
--- !order --
-ADC
-ADC
-ADC
-
--- !order --
-2023-10-06
-2023-10-06
-2023-10-06
-
--- !order --
-2023-10-06T14:30
-2023-10-06T14:30
-2023-10-06T14:30
-
--- !order --
-123.45
-123.45
-123.45
-
--- !desc --
-col_int BIGINT Yes true \N
-col_smallint BIGINT Yes true \N
-col_tinyint BIGINT Yes true \N
-col_bigint BIGINT Yes true \N
-col_float FLOAT Yes true \N
-col_double DOUBLE Yes true \N
-col_boolean BOOLEAN Yes true \N
-col_string TEXT Yes true \N
-col_char CHAR(10) Yes true \N
-col_varchar VARCHAR(255) Yes true \N
-col_date DATE Yes true \N
-col_timestamp DATETIME(6) Yes true \N
-col_decimal DECIMAL(10, 2) Yes true \N
-
--- !show --
--1 -400 -20 -400000000 40.5444 50.75 false First A
ADC 2023-10-06 2023-10-09T17:15 1238.45
--1 -400 -20 -400000000 40.5444 50.75 false First A
ADC 2023-10-06 2023-10-09T17:15 1238.45
--1 -400 -20 -400000000 40.5444 50.75 false First A
ADC 2023-10-06 2023-10-09T17:15 1238.45
--1 -400 -20 -400000000 40.5444 50.75 false First A
ADC 2023-10-06 2023-10-09T17:15 1238.45
--1 -400 -20 -400000000 40.5444 50.75 false First A
ADC 2023-10-06 2023-10-09T17:15 1238.45
--1 -400 -20 -400000000 40.5444 50.75 false First A
ADC 2023-10-06 2023-10-09T17:15 1238.45
--1 -400 -20 -400000000 40.5444 50.75 false First A
ADC 2023-10-06 2023-10-09T17:15 1238.45
-
--- !order --
--1
--1
--1
-
--- !order --
--400
--400
--400
-
--- !order --
--20
--20
--20
-
--- !order --
--400000000
--400000000
--400000000
-
--- !order --
-10.5
-10.5
-10.5
-
--- !order --
-20.75
-20.75
-20.75
-
--- !order --
-false
-false
-false
-
--- !order --
-Fifth
-Fifth
-Fifth
-
--- !order --
-A
-A
-A
-
--- !order --
-ADC
-ADC
-ADC
-
--- !order --
-2023-10-06
-2023-10-06
-2023-10-06
-
--- !order --
-2023-10-06T14:30
-2023-10-06T14:30
-2023-10-06T14:30
-
--- !order --
-123.45
-123.45
-123.45
-
--- !desc --
-col_int FLOAT Yes true \N
-col_smallint FLOAT Yes true \N
-col_tinyint FLOAT Yes true \N
-col_bigint FLOAT Yes true \N
-col_float FLOAT Yes true \N
-col_double DOUBLE Yes true \N
-col_boolean BOOLEAN Yes true \N
-col_string TEXT Yes true \N
-col_char CHAR(10) Yes true \N
-col_varchar VARCHAR(255) Yes true \N
-col_date DATE Yes true \N
-col_timestamp DATETIME(6) Yes true \N
-col_decimal DECIMAL(10, 2) Yes true \N
-
--- !show --
--1.0 -400.0 -20.0 -4.0E8 40.5444 50.75 false First A ADC
2023-10-06 2023-10-09T17:15 1238.45
--1.0 -400.0 -20.0 -4.0E8 40.5444 50.75 false First A ADC
2023-10-06 2023-10-09T17:15 1238.45
--1.0 -400.0 -20.0 -4.0E8 40.5444 50.75 false First A ADC
2023-10-06 2023-10-09T17:15 1238.45
--1.0 -400.0 -20.0 -4.0E8 40.5444 50.75 false First A ADC
2023-10-06 2023-10-09T17:15 1238.45
--1.0 -400.0 -20.0 -4.0E8 40.5444 50.75 false First A ADC
2023-10-06 2023-10-09T17:15 1238.45
--1.0 -400.0 -20.0 -4.0E8 40.5444 50.75 false First A ADC
2023-10-06 2023-10-09T17:15 1238.45
--1.0 -400.0 -20.0 -4.0E8 40.5444 50.75 false First A ADC
2023-10-06 2023-10-09T17:15 1238.45
-
--- !order --
--1.0
--1.0
--1.0
-
--- !order --
--400.0
--400.0
--400.0
-
--- !order --
--20.0
--20.0
--20.0
-
--- !order --
--4.0E8
--4.0E8
--4.0E8
-
--- !order --
-10.5
-10.5
-10.5
-
--- !order --
-20.75
-20.75
-20.75
-
--- !order --
-false
-false
-false
-
--- !order --
-Fifth
-Fifth
-Fifth
-
--- !order --
-A
-A
-A
-
--- !order --
-ADC
-ADC
-ADC
-
--- !order --
-2023-10-06
-2023-10-06
-2023-10-06
-
--- !order --
-2023-10-06T14:30
-2023-10-06T14:30
-2023-10-06T14:30
-
--- !order --
-123.45
-123.45
-123.45
-
--- !desc --
-col_int DOUBLE Yes true \N
-col_smallint DOUBLE Yes true \N
-col_tinyint DOUBLE Yes true \N
-col_bigint DOUBLE Yes true \N
-col_float DOUBLE Yes true \N
-col_double DOUBLE Yes true \N
-col_boolean BOOLEAN Yes true \N
-col_string TEXT Yes true \N
-col_char CHAR(10) Yes true \N
-col_varchar VARCHAR(255) Yes true \N
-col_date DATE Yes true \N
-col_timestamp DATETIME(6) Yes true \N
-col_decimal DECIMAL(10, 2) Yes true \N
-
--- !show --
--1.0 -400.0 -20.0 -4.0E8 40.54439926147461 50.75 false First
A ADC 2023-10-06 2023-10-09T17:15 1238.45
--1.0 -400.0 -20.0 -4.0E8 40.54439926147461 50.75 false First
A ADC 2023-10-06 2023-10-09T17:15 1238.45
--1.0 -400.0 -20.0 -4.0E8 40.54439926147461 50.75 false First
A ADC 2023-10-06 2023-10-09T17:15 1238.45
--1.0 -400.0 -20.0 -4.0E8 40.54439926147461 50.75 false First
A ADC 2023-10-06 2023-10-09T17:15 1238.45
--1.0 -400.0 -20.0 -4.0E8 40.54439926147461 50.75 false First
A ADC 2023-10-06 2023-10-09T17:15 1238.45
--1.0 -400.0 -20.0 -4.0E8 40.54439926147461 50.75 false First
A ADC 2023-10-06 2023-10-09T17:15 1238.45
--1.0 -400.0 -20.0 -4.0E8 40.54439926147461 50.75 false First
A ADC 2023-10-06 2023-10-09T17:15 1238.45
-
--- !order --
--1.0
--1.0
--1.0
-
--- !order --
--400.0
--400.0
--400.0
-
--- !order --
--20.0
--20.0
--20.0
-
--- !order --
--4.0E8
--4.0E8
--4.0E8
-
--- !order --
-10.5
-10.5
-10.5
-
--- !order --
-20.75
-20.75
-20.75
-
--- !order --
-false
-false
-false
-
--- !order --
-Fifth
-Fifth
-Fifth
-
--- !order --
-A
-A
-A
-
--- !order --
-ADC
-ADC
-ADC
-
--- !order --
-2023-10-06
-2023-10-06
-2023-10-06
-
--- !order --
-2023-10-06T14:30
-2023-10-06T14:30
-2023-10-06T14:30
-
--- !order --
-123.45
-123.45
-123.45
-
--- !desc --
-col_int INT Yes true \N
-col_smallint SMALLINT Yes true \N
-col_tinyint TINYINT Yes true \N
-col_bigint BIGINT Yes true \N
-col_float FLOAT Yes true \N
-col_double DOUBLE Yes true \N
-col_boolean BOOLEAN Yes true \N
-col_string TEXT Yes true \N
-col_char CHAR(10) Yes true \N
-col_varchar VARCHAR(255) Yes true \N
-col_date DATE Yes true \N
-col_timestamp DATETIME(6) Yes true \N
-col_decimal DECIMAL(10, 2) Yes true \N
-
--- !show --
--1 -400 -20 -400000000 40.5444 50.75 false First A
ADC 2023-10-06 2023-10-09T17:15 1238.45
--1 -400 -20 -400000000 40.5444 50.75 false First A
ADC 2023-10-06 2023-10-09T17:15 1238.45
--1 -400 -20 -400000000 40.5444 50.75 false First A
ADC 2023-10-06 2023-10-09T17:15 1238.45
--1 -400 -20 -400000000 40.5444 50.75 false First A
ADC 2023-10-06 2023-10-09T17:15 1238.45
--1 -400 -20 -400000000 40.5444 50.75 false First A
ADC 2023-10-06 2023-10-09T17:15 1238.45
--1 -400 -20 -400000000 40.5444 50.75 false First A
ADC 2023-10-06 2023-10-09T17:15 1238.45
--1 -400 -20 -400000000 40.5444 50.75 false First A
ADC 2023-10-06 2023-10-09T17:15 1238.45
-
--- !order --
--1
--1
--1
-
--- !order --
--400
--400
--400
-
--- !order --
--20
--20
--20
-
--- !order --
--400000000
--400000000
--400000000
-
--- !order --
-10.5
-10.5
-10.5
-
--- !order --
-20.75
-20.75
-20.75
-
--- !order --
-false
-false
-false
-
--- !order --
-Fifth
-Fifth
-Fifth
-
--- !order --
-A
-A
-A
-
--- !order --
-ADC
-ADC
-ADC
-
--- !order --
-2023-10-06
-2023-10-06
-2023-10-06
-
--- !order --
-2023-10-06T14:30
-2023-10-06T14:30
-2023-10-06T14:30
-
--- !order --
-123.45
-123.45
-123.45
-
--- !desc --
-col_int TEXT Yes true \N
-col_smallint TEXT Yes true \N
-col_tinyint TEXT Yes true \N
-col_bigint TEXT Yes true \N
-col_float TEXT Yes true \N
-col_double TEXT Yes true \N
-col_boolean BOOLEAN Yes true \N
-col_string TEXT Yes true \N
-col_char TEXT Yes true \N
-col_varchar TEXT Yes true \N
-col_date TEXT Yes true \N
-col_timestamp TEXT Yes true \N
-col_decimal TEXT Yes true \N
-
--- !show --
--1 -200 -10 -20000000 2.05777E1 3.075E1 false First
A ADC 2023-10-06�� 2023-10-09 17:15:00�� 1238.45
--1 -200 -10 -20000000 2.05777E1 3.075E1 false First
A ADC 2023-10-06�� 2023-10-09 17:15:00�� 1238.45
--1 -200 -10 -20000000 2.05777E1 3.075E1 false First
A ADC 2023-10-06�� 2023-10-09 17:15:00�� 1238.45
--1 -200 -10 -20000000 2.05777E1 3.075E1 false First
A ADC 2023-10-06�� 2023-10-09 17:15:00�� 1238.45
--1 -200 -10 -20000000 2.05777E1 3.075E1 false First
A ADC 2023-10-06�� 2023-10-09 17:15:00�� 1238.45
--1 -200 -10 -20000000 2.05777E1 3.075E1 false First
A ADC 2023-10-06�� 2023-10-09 17:15:00�� 1238.45
--1 -200 -10 -20000000 2.05777E1 3.075E1 false First
A ADC 2023-10-06�� 2023-10-09 17:15:00�� 1238.45
-
--- !order --
--1
--1
--1
-
--- !order --
--200
--200
--200
-
--- !order --
--10
--10
--10
-
--- !order --
--20000000
--20000000
--20000000
-
--- !order --
-1.05E1
-1.05E1
-1.05E1
-
--- !order --
-2.075E1
-2.075E1
-2.075E1
-
--- !order --
-false
-false
-false
-
--- !order --
-Fifth
-Fifth
-Fifth
-
--- !order --
-A
-A
-A
-
--- !order --
-ADC
-ADC
-ADC
-
--- !order --
-2023-10-06��
-2023-10-06��
-2023-10-06��
-
--- !order --
-2023-10-06 14:30:00��
-2023-10-06 14:30:00��
-2023-10-06 14:30:00��
-
--- !order --
-123.45
-123.45
-123.45
-
--- !desc --
-col_int CHAR(10) Yes true \N
-col_smallint CHAR(10) Yes true \N
-col_tinyint CHAR(10) Yes true \N
-col_bigint CHAR(10) Yes true \N
-col_float CHAR(10) Yes true \N
-col_double CHAR(10) Yes true \N
-col_boolean BOOLEAN Yes true \N
-col_string CHAR(10) Yes true \N
-col_char CHAR(10) Yes true \N
-col_varchar CHAR(10) Yes true \N
-col_date CHAR(10) Yes true \N
-col_timestamp CHAR(10) Yes true \N
-col_decimal CHAR(10) Yes true \N
-
--- !show --
--1 -200 -10 -20000000 2.05777E1 3.075E1 false First
A ADC 2023-10-06�� 2023-10-09 17:15:00�� 1238.45
--1 -200 -10 -20000000 2.05777E1 3.075E1 false First
A ADC 2023-10-06�� 2023-10-09 17:15:00�� 1238.45
--1 -200 -10 -20000000 2.05777E1 3.075E1 false First
A ADC 2023-10-06�� 2023-10-09 17:15:00�� 1238.45
--1 -200 -10 -20000000 2.05777E1 3.075E1 false First
A ADC 2023-10-06�� 2023-10-09 17:15:00�� 1238.45
--1 -200 -10 -20000000 2.05777E1 3.075E1 false First
A ADC 2023-10-06�� 2023-10-09 17:15:00�� 1238.45
--1 -200 -10 -20000000 2.05777E1 3.075E1 false First
A ADC 2023-10-06�� 2023-10-09 17:15:00�� 1238.45
--1 -200 -10 -20000000 2.05777E1 3.075E1 false First
A ADC 2023-10-06�� 2023-10-09 17:15:00�� 1238.45
-
--- !order --
--1
--1
--1
-
--- !order --
--200
--200
--200
-
--- !order --
--10
--10
--10
-
--- !order --
--20000000
--20000000
--20000000
-
--- !order --
-1.05E1
-1.05E1
-1.05E1
-
--- !order --
-2.075E1
-2.075E1
-2.075E1
-
--- !order --
-false
-false
-false
-
--- !order --
-Fifth
-Fifth
-Fifth
-
--- !order --
-A
-A
-A
-
--- !order --
-ADC
-ADC
-ADC
-
--- !order --
-2023-10-06��
-2023-10-06��
-2023-10-06��
-
--- !order --
-2023-10-06 14:30:00��
-2023-10-06 14:30:00��
-2023-10-06 14:30:00��
-
--- !order --
-123.45
-123.45
-123.45
-
--- !desc --
-col_int VARCHAR(20) Yes true \N
-col_smallint VARCHAR(20) Yes true \N
-col_tinyint VARCHAR(20) Yes true \N
-col_bigint VARCHAR(20) Yes true \N
-col_float VARCHAR(20) Yes true \N
-col_double VARCHAR(20) Yes true \N
-col_boolean BOOLEAN Yes true \N
-col_string VARCHAR(20) Yes true \N
-col_char VARCHAR(20) Yes true \N
-col_varchar VARCHAR(20) Yes true \N
-col_date VARCHAR(20) Yes true \N
-col_timestamp VARCHAR(20) Yes true \N
-col_decimal VARCHAR(20) Yes true \N
-
--- !show --
--1 -200 -10 -20000000 2.05777E1 3.075E1 false First
A ADC 2023-10-06�� 2023-10-09 17:15:00�� 1238.45
--1 -200 -10 -20000000 2.05777E1 3.075E1 false First
A ADC 2023-10-06�� 2023-10-09 17:15:00�� 1238.45
--1 -200 -10 -20000000 2.05777E1 3.075E1 false First
A ADC 2023-10-06�� 2023-10-09 17:15:00�� 1238.45
--1 -200 -10 -20000000 2.05777E1 3.075E1 false First
A ADC 2023-10-06�� 2023-10-09 17:15:00�� 1238.45
--1 -200 -10 -20000000 2.05777E1 3.075E1 false First
A ADC 2023-10-06�� 2023-10-09 17:15:00�� 1238.45
--1 -200 -10 -20000000 2.05777E1 3.075E1 false First
A ADC 2023-10-06�� 2023-10-09 17:15:00�� 1238.45
--1 -200 -10 -20000000 2.05777E1 3.075E1 false First
A ADC 2023-10-06�� 2023-10-09 17:15:00�� 1238.45
-
--- !order --
--1
--1
--1
-
--- !order --
--200
--200
--200
-
--- !order --
--10
--10
--10
-
--- !order --
--20000000
--20000000
--20000000
-
--- !order --
-1.05E1
-1.05E1
-1.05E1
-
--- !order --
-2.075E1
-2.075E1
-2.075E1
-
--- !order --
-false
-false
-false
-
--- !order --
-Fifth
-Fifth
-Fifth
-
--- !order --
-A
-A
-A
-
--- !order --
-ADC
-ADC
-ADC
-
--- !order --
-2023-10-06��
-2023-10-06��
-2023-10-06��
-
--- !order --
-2023-10-06 14:30:00��
-2023-10-06 14:30:00��
-2023-10-06 14:30:00��
-
--- !order --
-123.45
-123.45
-123.45
-
--- !desc --
-col_int INT Yes true \N
-col_smallint SMALLINT Yes true \N
-col_tinyint TINYINT Yes true \N
-col_bigint BIGINT Yes true \N
-col_float FLOAT Yes true \N
-col_double DOUBLE Yes true \N
-col_boolean BOOLEAN Yes true \N
-col_string TEXT Yes true \N
-col_char CHAR(10) Yes true \N
-col_varchar VARCHAR(255) Yes true \N
-col_date DATE Yes true \N
-col_timestamp DATETIME(6) Yes true \N
-col_decimal DECIMAL(10, 2) Yes true \N
-
--- !show --
--1 -400 -20 -400000000 40.5444 50.75 false First A
ADC 2023-10-06 2023-10-09T17:15 1238.45
--1 -400 -20 -400000000 40.5444 50.75 false First A
ADC 2023-10-06 2023-10-09T17:15 1238.45
--1 -400 -20 -400000000 40.5444 50.75 false First A
ADC 2023-10-06 2023-10-09T17:15 1238.45
--1 -400 -20 -400000000 40.5444 50.75 false First A
ADC 2023-10-06 2023-10-09T17:15 1238.45
--1 -400 -20 -400000000 40.5444 50.75 false First A
ADC 2023-10-06 2023-10-09T17:15 1238.45
--1 -400 -20 -400000000 40.5444 50.75 false First A
ADC 2023-10-06 2023-10-09T17:15 1238.45
--1 -400 -20 -400000000 40.5444 50.75 false First A
ADC 2023-10-06 2023-10-09T17:15 1238.45
-
--- !order --
--1
--1
--1
-
--- !order --
--400
--400
--400
-
--- !order --
--20
--20
--20
-
--- !order --
--400000000
--400000000
--400000000
-
--- !order --
-10.5
-10.5
-10.5
-
--- !order --
-20.75
-20.75
-20.75
-
--- !order --
-false
-false
-false
-
--- !order --
-Fifth
-Fifth
-Fifth
-
--- !order --
-A
-A
-A
-
--- !order --
-ADC
-ADC
-ADC
-
--- !order --
-2023-10-06
-2023-10-06
-2023-10-06
-
--- !order --
-2023-10-06T14:30
-2023-10-06T14:30
-2023-10-06T14:30
-
--- !order --
-123.45
-123.45
-123.45
-
--- !desc --
-col_int INT Yes true \N
-col_smallint SMALLINT Yes true \N
-col_tinyint TINYINT Yes true \N
-col_bigint BIGINT Yes true \N
-col_float FLOAT Yes true \N
-col_double DOUBLE Yes true \N
-col_boolean BOOLEAN Yes true \N
-col_string TEXT Yes true \N
-col_char CHAR(10) Yes true \N
-col_varchar VARCHAR(255) Yes true \N
-col_date DATE Yes true \N
-col_timestamp DATETIME(6) Yes true \N
-col_decimal DECIMAL(10, 2) Yes true \N
-
--- !show --
--1 -400 -20 -400000000 40.5444 50.75 false First A
ADC 2023-10-06 2023-10-09T17:15 1238.45
--1 -400 -20 -400000000 40.5444 50.75 false First A
ADC 2023-10-06 2023-10-09T17:15 1238.45
--1 -400 -20 -400000000 40.5444 50.75 false First A
ADC 2023-10-06 2023-10-09T17:15 1238.45
--1 -400 -20 -400000000 40.5444 50.75 false First A
ADC 2023-10-06 2023-10-09T17:15 1238.45
--1 -400 -20 -400000000 40.5444 50.75 false First A
ADC 2023-10-06 2023-10-09T17:15 1238.45
--1 -400 -20 -400000000 40.5444 50.75 false First A
ADC 2023-10-06 2023-10-09T17:15 1238.45
--1 -400 -20 -400000000 40.5444 50.75 false First A
ADC 2023-10-06 2023-10-09T17:15 1238.45
-
--- !order --
--1
--1
--1
-
--- !order --
--400
--400
--400
-
--- !order --
--20
--20
--20
-
--- !order --
--400000000
--400000000
--400000000
-
--- !order --
-10.5
-10.5
-10.5
-
--- !order --
-20.75
-20.75
-20.75
-
--- !order --
-false
-false
-false
-
--- !order --
-Fifth
-Fifth
-Fifth
-
--- !order --
-A
-A
-A
-
--- !order --
-ADC
-ADC
-ADC
-
--- !order --
-2023-10-06
-2023-10-06
-2023-10-06
-
--- !order --
-2023-10-06T14:30
-2023-10-06T14:30
-2023-10-06T14:30
-
--- !order --
-123.45
-123.45
-123.45
-
--- !desc --
-col_int DECIMAL(5, 1) Yes true \N
-col_smallint DECIMAL(5, 1) Yes true \N
-col_tinyint DECIMAL(5, 1) Yes true \N
-col_bigint DECIMAL(5, 1) Yes true \N
-col_float FLOAT Yes true \N
-col_double DOUBLE Yes true \N
-col_boolean BOOLEAN Yes true \N
-col_string TEXT Yes true \N
-col_char CHAR(10) Yes true \N
-col_varchar VARCHAR(255) Yes true \N
-col_date DATE Yes true \N
-col_timestamp DATETIME(6) Yes true \N
-col_decimal DECIMAL(5, 1) Yes true \N
-
--- !show --
--1.0 -400.0 -20.0 29496729.6 40.5444 50.75 false First A
ADC 2023-10-06 2023-10-09T17:15 1238.4
--1.0 -400.0 -20.0 29496729.6 40.5444 50.75 false First A
ADC 2023-10-06 2023-10-09T17:15 1238.4
--1.0 -400.0 -20.0 29496729.6 40.5444 50.75 false First A
ADC 2023-10-06 2023-10-09T17:15 1238.4
--1.0 -400.0 -20.0 29496729.6 40.5444 50.75 false First A
ADC 2023-10-06 2023-10-09T17:15 1238.4
--1.0 -400.0 -20.0 29496729.6 40.5444 50.75 false First A
ADC 2023-10-06 2023-10-09T17:15 1238.4
--1.0 -400.0 -20.0 29496729.6 40.5444 50.75 false First A
ADC 2023-10-06 2023-10-09T17:15 1238.4
--1.0 -400.0 -20.0 29496729.6 40.5444 50.75 false First A
ADC 2023-10-06 2023-10-09T17:15 1238.4
-
--- !order --
--1.0
--1.0
--1.0
-
--- !order --
--400.0
--400.0
--400.0
-
--- !order --
--20.0
--20.0
--20.0
-
--- !order --
--153960755.2
--153960755.2
--153960755.2
-
--- !order --
-10.5
-10.5
-10.5
-
--- !order --
-20.75
-20.75
-20.75
-
--- !order --
-false
-false
-false
-
--- !order --
-Fifth
-Fifth
-Fifth
-
--- !order --
-A
-A
-A
-
--- !order --
-ADC
-ADC
-ADC
-
--- !order --
-2023-10-06
-2023-10-06
-2023-10-06
-
--- !order --
-2023-10-06T14:30
-2023-10-06T14:30
-2023-10-06T14:30
-
--- !order --
-123.4
-123.4
-123.4
-
--- !int_int --
-2
-2
-2
-
--- !int_smallint --
-100
-100
-100
-
--- !int_tinyint --
-5
-5
-5
-
--- !int_bigint --
-1000000000
-1000000000
-1000000000
-
--- !int_float --
-
--- !int_double --
-
--- !int_boolean --
-
--- !int_string --
-
--- !int_char --
-B
-B
-B
-
--- !int_varchar --
-
--- !int_date --
-2023-10-06
-2023-10-06
-2023-10-06
-
--- !int_timestamp --
-2023-10-06T14:30
-2023-10-06T14:30
-2023-10-06T14:30
-
--- !int_decimal --
-
--- !smallint_int --
-1
-1
-1
-
--- !smallint_smallint --
-100
-100
-100
-
--- !smallint_tinyint --
-5
-5
-5
-
--- !smallint_bigint --
-1000000000
-1000000000
-1000000000
-
--- !smallint_float --
-
--- !smallint_double --
-
--- !smallint_boolean --
-
--- !smallint_string --
-
--- !smallint_char --
-C
-C
-C
-
--- !smallint_varchar --
-
--- !smallint_date --
-2023-10-06
-2023-10-06
-2023-10-06
-
--- !smallint_timestamp --
-2023-10-06T14:30
-2023-10-06T14:30
-2023-10-06T14:30
-
--- !smallint_decimal --
-
--- !tinyint_int --
-3
-3
-3
-
--- !tinyint_smallint --
-100
-100
-100
-
--- !tinyint_tinyint --
-5
-5
-5
-
--- !tinyint_bigint --
-1000000000
-1000000000
-1000000000
-
--- !tinyint_float --
-
--- !tinyint_double --
-
--- !tinyint_boolean --
-
--- !tinyint_string --
-
--- !tinyint_char --
-A
-A
-A
-
--- !tinyint_varchar --
-
--- !tinyint_date --
-2023-10-06
-2023-10-06
-2023-10-06
-
--- !tinyint_timestamp --
-2023-10-06T14:30
-2023-10-06T14:30
-2023-10-06T14:30
-
--- !tinyint_decimal --
-
--- !bigint_int --
-3
-3
-3
-
--- !bigint_smallint --
-100
-100
-100
-
--- !bigint_tinyint --
-5
-5
-5
-
--- !bigint_bigint --
-1000000000
-1000000000
-1000000000
-
--- !bigint_float --
-
--- !bigint_double --
-
--- !bigint_boolean --
-
--- !bigint_string --
-
--- !bigint_char --
-A
-A
-A
-
--- !bigint_varchar --
-
--- !bigint_date --
-2023-10-06
-2023-10-06
-2023-10-06
-
--- !bigint_timestamp --
-2023-10-06T14:30
-2023-10-06T14:30
-2023-10-06T14:30
-
--- !bigint_decimal --
-
--- !float_int --
-
--- !float_smallint --
-
--- !float_tinyint --
-
--- !float_bigint --
-
--- !float_float --
-
--- !float_double --
-
--- !float_boolean --
-
--- !float_string --
-
--- !float_char --
-
--- !float_varchar --
-
--- !float_date --
-2023-10-06
-2023-10-06
-2023-10-06
-
--- !float_timestamp --
-2023-10-06T14:30
-2023-10-06T14:30
-2023-10-06T14:30
-
--- !float_decimal --
-
--- !double_int --
-2.0
-2.0
-2.0
-
--- !double_smallint --
-
--- !double_tinyint --
-
--- !double_bigint --
-
--- !double_float --
-
--- !double_double --
-
--- !double_boolean --
-
--- !double_string --
-
--- !double_char --
-A
-A
-A
-
--- !double_varchar --
-
--- !double_date --
-2023-10-06
-2023-10-06
-2023-10-06
-
--- !double_timestamp --
-2023-10-06T14:30
-2023-10-06T14:30
-2023-10-06T14:30
-
--- !double_decimal --
-
--- !boolean_int --
-3
-3
-3
-
--- !boolean_smallint --
-100
-100
-100
-
--- !boolean_tinyint --
-5
-5
-5
-
--- !boolean_bigint --
-1000000000
-1000000000
-1000000000
-
--- !boolean_float --
-
--- !boolean_double --
-
--- !boolean_boolean --
-
--- !boolean_string --
-
--- !boolean_char --
-A
-A
-A
-
--- !boolean_varchar --
-
--- !boolean_date --
-2023-10-06
-2023-10-06
-2023-10-06
-
--- !boolean_timestamp --
-2023-10-06T14:30
-2023-10-06T14:30
-2023-10-06T14:30
-
--- !boolean_decimal --
-
--- !string_int --
-
--- !string_smallint --
-
--- !string_tinyint --
-
--- !string_bigint --
-
--- !string_float --
-
--- !string_double --
-
--- !string_boolean --
-
--- !string_string --
-
--- !string_char --
-A
-A
-A
-
--- !string_varchar --
-
--- !string_date --
-
--- !string_timestamp --
-
--- !string_decimal --
-
--- !char_int --
-
--- !char_smallint --
-
--- !char_tinyint --
-
--- !char_bigint --
-
--- !char_float --
-
--- !char_double --
-
--- !char_boolean --
-
--- !char_string --
-
--- !char_char --
-A
-A
-A
-
--- !char_varchar --
-
--- !char_date --
-
--- !char_timestamp --
-
--- !char_decimal --
-
--- !varchar_int --
-
--- !varchar_smallint --
-
--- !varchar_tinyint --
-
--- !varchar_bigint --
-
--- !varchar_float --
-
--- !varchar_double --
-
--- !varchar_boolean --
-
--- !varchar_string --
-
--- !varchar_char --
-B
-B
-B
-
--- !varchar_varchar --
-
--- !varchar_date --
-
--- !varchar_timestamp --
-
--- !varchar_decimal --
-
--- !date_int --
-3
-3
-3
-
--- !date_smallint --
-100
-100
-100
-
--- !date_tinyint --
-5
-5
-5
-
--- !date_bigint --
-1000000000
-1000000000
-1000000000
-
--- !date_float --
-
--- !date_double --
-
--- !date_boolean --
-
--- !date_string --
-
--- !date_char --
-A
-A
-A
-
--- !date_varchar --
-
--- !date_date --
-2023-10-06
-2023-10-06
-2023-10-06
-
--- !date_timestamp --
-2023-10-06T14:30
-2023-10-06T14:30
-2023-10-06T14:30
-
--- !date_decimal --
-
--- !timestamp_int --
-3
-3
-3
-
--- !timestamp_smallint --
-100
-100
-100
-
--- !timestamp_tinyint --
-5
-5
-5
-
--- !timestamp_bigint --
-1000000000
-1000000000
-1000000000
-
--- !timestamp_float --
-
--- !timestamp_double --
-
--- !timestamp_boolean --
-
--- !timestamp_string --
-
--- !timestamp_char --
-B
-B
-B
-
--- !timestamp_varchar --
-
--- !timestamp_date --
-2023-10-06
-2023-10-06
-2023-10-06
-
--- !timestamp_timestamp --
-2023-10-06T14:30
-2023-10-06T14:30
-2023-10-06T14:30
-
--- !timestamp_decimal --
-
--- !decimal_int --
-
--- !decimal_smallint --
-
--- !decimal_tinyint --
-
--- !decimal_bigint --
-
--- !decimal_float --
-
--- !decimal_double --
-
--- !decimal_boolean --
-
--- !decimal_string --
-
--- !decimal_char --
-
--- !decimal_varchar --
-
--- !decimal_date --
-2023-10-06
-2023-10-06
-2023-10-06
-
--- !decimal_timestamp --
-2023-10-06T14:30
-2023-10-06T14:30
-2023-10-06T14:30
-
--- !decimal_decimal --
diff --git
a/regression-test/suites/external_table_p2/hive/test_hive_parquet_alter_column.groovy
b/regression-test/suites/external_table_p2/hive/test_hive_parquet_alter_column.groovy
index 332ce580de2..f07a13e2398 100644
---
a/regression-test/suites/external_table_p2/hive/test_hive_parquet_alter_column.groovy
+++
b/regression-test/suites/external_table_p2/hive/test_hive_parquet_alter_column.groovy
@@ -17,17 +17,11 @@
suite("test_hive_parquet_alter_column",
"p2,external,hive,external_remote,external_remote_hive") {
String enabled = context.config.otherConfigs.get("enableExternalHiveTest")
- if (enabled == null || !enabled.equalsIgnoreCase("true")) {
- logger.info("diable Hive test.")
- return;
- }
-
- for (String hivePrefix : ["hive2", "hive3"]) {
+ if (enabled != null && enabled.equalsIgnoreCase("true")) {
String extHiveHmsHost =
context.config.otherConfigs.get("extHiveHmsHost")
String extHiveHmsPort =
context.config.otherConfigs.get("extHiveHmsPort")
- String hms_port = context.config.otherConfigs.get(hivePrefix +
"HmsPort")
- String catalog_name = "test_${hivePrefix}_parquet_alter_column"
+ String catalog_name = "test_hive_parquet_alter_column"
sql """drop catalog if exists ${catalog_name};"""
sql """
create catalog if not exists ${catalog_name} properties (
@@ -44,21 +38,20 @@ suite("test_hive_parquet_alter_column",
"p2,external,hive,external_remote,extern
sql """ use multi_catalog """
-
+
types =
["int","smallint","tinyint","bigint","float","double","boolean","string","char","varchar","date","timestamp","decimal"]
-
+
for( String type1 in types) {
qt_desc """ desc parquet_alter_column_to_${type1} ; """
qt_show """ select * from parquet_alter_column_to_${type1}
${Orderby} """
-
+
for( String type2 in types) {
qt_order """ select col_${type2} from
parquet_alter_column_to_${type1} order by col_${type2} limit 3 """
-
+
}
}
-
order_qt_int_int """ select col_int from parquet_alter_column_to_int
where col_int>=2 order by col_int limit 3"""
order_qt_int_smallint """ select col_smallint from
parquet_alter_column_to_int where col_smallint>=3 order by col_smallint limit
3"""
order_qt_int_tinyint """ select col_tinyint from
parquet_alter_column_to_int where col_tinyint>=3 order by col_tinyint limit
3"""
@@ -230,4 +223,4 @@ suite("test_hive_parquet_alter_column",
"p2,external,hive,external_remote,extern
order_qt_decimal_decimal """ select col_decimal from
parquet_alter_column_to_decimal where col_decimal=1.5 order by col_decimal
limit 3"""
}
-}
+}
\ No newline at end of file
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
