| ==== |
| ---- QUERY |
| SELECT * FROM $DATABASE.out_of_range_date_orc; |
| ---- TYPES |
| DATE |
| ---- RESULTS |
| 2019-10-04 |
| 1582-10-15 |
| NULL |
| 9999-12-31 |
| ---- ERRORS |
| ORC file '$NAMENODE/test-warehouse/$DATABASE.db/out_of_range_date_orc/out_of_range_date.orc' column '1' contains an out of range date. The valid date range is 0001-01-01..9999-12-31. |
| ==== |
| ---- QUERY |
| set abort_on_error=1; |
| SELECT * FROM $DATABASE.out_of_range_date_orc; |
| ---- CATCH |
| ORC file '$NAMENODE/test-warehouse/$DATABASE.db/out_of_range_date_orc/out_of_range_date.orc' column '1' contains an out of range date. The valid date range is 0001-01-01..9999-12-31. |
| ==== |
| |
