| ==== |
| ---- QUERY |
| SET abort_on_error=1; |
| SELECT * FROM $DATABASE.timestamp_text_table; |
| ---- TYPES |
| TIMESTAMP |
| ---- CATCH |
| Error converting column: 0 to TIMESTAMP |
| ==== |
| ---- QUERY |
| SET abort_on_error=0; |
| SELECT * FROM $DATABASE.timestamp_text_table; |
| ---- TYPES |
| TIMESTAMP |
| ---- RESULTS |
| 1996-04-22 10:00:00.432100000 |
| 1996-04-22 10:00:00.432100000 |
| 1996-04-22 10:00:00 |
| 1996-04-22 10:00:00 |
| 1996-04-22 00:00:00 |
| NULL |
| NULL |
| ---- ERRORS |
| Error converting column: 0 to TIMESTAMP |
| Error converting column: 0 to TIMESTAMP |
| Error parsing row: file: __HDFS_FILENAME__, before offset: 148 |
| Error parsing row: file: __HDFS_FILENAME__, before offset: 148 |
| ==== |