blob: 8ddd7b1d7d33f7a0e17739fa1ae664136508721b [file] [log] [blame]
====
---- QUERY
# Check that scanning different file formats is not affected by
# flag use_local_tz_for_unix_timestamp_conversion.
SET timezone=CET;
select min(timestamp_col) from functional.alltypestiny;
---- TYPES
TIMESTAMP
---- RESULTS
2009-01-01 00:00:00
====
---- QUERY
SET timezone=CET;
select min(timestamp_col) from functional_seq.alltypestiny;
---- TYPES
TIMESTAMP
---- RESULTS
2009-01-01 00:00:00
====
---- QUERY
SET timezone=CET;
select min(timestamp_col) from functional_rc.alltypestiny;
---- TYPES
TIMESTAMP
---- RESULTS
2009-01-01 00:00:00
====
---- QUERY
SET timezone=CET;
select min(timestamp_col) from functional_avro.alltypestiny;
---- TYPES
STRING
---- RESULTS
'2009-01-01 00:00:00'
====
---- QUERY
SET timezone=CET;
select min(timestamp_col) from functional_parquet.alltypestiny;
---- TYPES
TIMESTAMP
---- RESULTS
2009-01-01 00:00:00
====
---- QUERY
# Regression test for IMPALA-9385.
SET timezone=CET;
select min(timestamp_col) from functional_orc_def.alltypestiny;
---- TYPES
TIMESTAMP
---- RESULTS
2009-01-01 00:00:00
====
---- QUERY
SET timezone=CET;
select min(timestamp_col) from functional_kudu.alltypestiny;
---- TYPES
TIMESTAMP
---- RESULTS
2009-01-01 00:00:00
====
---- QUERY
SET timezone=CET;
select min(timestamp_col) from functional_hbase.alltypestiny;
---- TYPES
TIMESTAMP
---- RESULTS
2009-01-01 00:00:00
====