| ==== |
| ---- QUERY |
| # IMPALA-4363: Verify that if an out of range parquet timestamp is read, |
| # it's treated as a NULL and a warning is issued. |
| SELECT * FROM out_of_range_timestamp; |
| ---- TYPES |
| TIMESTAMP |
| ---- RESULTS |
| NULL |
| 1400-01-01 00:00:00 |
| 9999-12-31 00:00:00 |
| NULL |
| ---- ERRORS |
| Parquet file '$NAMENODE/test-warehouse/$DATABASE.db/out_of_range_timestamp/out_of_range_timestamp.parquet' column 'ts' contains an out of range timestamp. The valid date range is 1400-01-01..9999-12-31. (1 of 2 similar) |
| ==== |
| ---- QUERY |
| # IMPALA-7595: Test Parquet timestamp columns where the time part is |
| # out of the valid range [0..24H). |
| SELECT * FROM out_of_range_time_of_day; |
| ---- TYPES |
| TIMESTAMP |
| ---- RESULTS |
| NULL |
| 1970-01-01 00:00:00 |
| 1970-01-01 23:59:59.999999999 |
| NULL |
| ---- ERRORS |
| Parquet file '$NAMENODE/test-warehouse/$DATABASE.db/out_of_range_time_of_day/out_of_range_time_of_day.parquet' column 'd' contains a timestamp with invalid time of day. The time of day should be 0 <= and < 24 hour (in nanoseconds). (1 of 2 similar) |
| ==== |