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-jenkins@cloudera.com>
Tested-by: Impala Public Jenkins <impala-public-jenkins@cloudera.com>
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 @@
====
---- 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 @@
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 @@
====
---- 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 @@
====
---- QUERY
# Test non-count query for non-partition filter
+SET TIMEZONE=UTC;
SELECT * from iceberg_non_partitioned
where id < 5
ORDER BY id