This is an automated email from the ASF dual-hosted git repository.
laszlog pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/impala.git
commit efc627d050caeb9947af2dfd3fc8a02236c44d0e
Author: Fang-Yu Rao <fangyu....@cloudera.com>
AuthorDate: Tue Sep 8 11:14:13 2020 -0700
IMPALA-10158: Set timezone to UTC for Iceberg-related E2E tests
We found that the tests of test_iceberg_query and test_iceberg_profile
fail after the patch for IMPALA-9741 has been merged and that it is due
to the default timezone of Impala not being UTC. This patch fixes the
issue by adding "SET TIMEZONE=UTC;" before those test queries are run.
Testing:
- Verified in a local development environment that the tests of
test_iceberg_query and test_iceberg_profile could pass after applying
this patch.
Change-Id: Ie985519e8ded04f90465e141488bd2dda78af6c3
Reviewed-on: http://gerrit.cloudera.org:8080/16425
Reviewed-by: Impala Public Jenkins <impala-public-jenk...@cloudera.com>
Tested-by: Impala Public Jenkins <impala-public-jenk...@cloudera.com>
---
.../workloads/functional-query/queries/QueryTest/iceberg-profile.test | 1 +
.../workloads/functional-query/queries/QueryTest/iceberg-query.test | 4 ++++
2 files changed, 5 insertions(+)
diff --git
a/testdata/workloads/functional-query/queries/QueryTest/iceberg-profile.test
b/testdata/workloads/functional-query/queries/QueryTest/iceberg-profile.test
index fce7e1a..3c4c3cd 100644
--- a/testdata/workloads/functional-query/queries/QueryTest/iceberg-profile.test
+++ b/testdata/workloads/functional-query/queries/QueryTest/iceberg-profile.test
@@ -1,6 +1,7 @@
====
---- QUERY
# This query will filter files by partition column predicate
+SET TIMEZONE=UTC;
select * from functional_parquet.iceberg_partitioned
where event_time > to_timestamp('2020-01-01 09:00:00','yyyy-MM-dd HH:mm:ss')
---- RUNTIME_PROFILE
diff --git
a/testdata/workloads/functional-query/queries/QueryTest/iceberg-query.test
b/testdata/workloads/functional-query/queries/QueryTest/iceberg-query.test
index 67e081d..dd63bd6 100644
--- a/testdata/workloads/functional-query/queries/QueryTest/iceberg-query.test
+++ b/testdata/workloads/functional-query/queries/QueryTest/iceberg-query.test
@@ -65,6 +65,7 @@ bigint,bigint
====
---- QUERY
# Test timestamp filter for iceberg derived partition 'HOUR'
+SET TIMEZONE=UTC;
SELECT count(*) from iceberg_partitioned
where event_time > to_timestamp('2020-01-01 09:00:00','yyyy-MM-dd HH:mm:ss')
---- TYPES
@@ -73,6 +74,7 @@ bigint
6
====
---- QUERY
+SET TIMEZONE=UTC;
SELECT count(*) from iceberg_non_partitioned
where event_time > to_timestamp('2020-01-01 09:00:00','yyyy-MM-dd HH:mm:ss')
---- TYPES
@@ -82,6 +84,7 @@ bigint
====
---- QUERY
# Test non-count query for partition filter
+SET TIMEZONE=UTC;
SELECT * from iceberg_partitioned
where event_time > to_timestamp('2020-01-01 09:00:00','yyyy-MM-dd HH:mm:ss')
ORDER BY id
@@ -97,6 +100,7 @@ int,string,string,timestamp
====
---- QUERY
# Test non-count query for non-partition filter
+SET TIMEZONE=UTC;
SELECT * from iceberg_non_partitioned
where id < 5
ORDER BY id
