ClickHouse / ClickHouse/ClickHouse
Parsing error doesn't indicate line/row that has issue
Open
comp-formats
usability
- Dominant language
- C++
- Stars
- 49.9k
- Forks
- 9k
- Avg merge
- 21h 32m
- Merged PRs (30d)
- 515
Description
I'm trying to convert the value from a JSON file to the Date type:
```sql
from 'movies.json' select release_date, cast(release_date as date);
```
It throws this error:
```
Received exception:
Code: 38. DB::Exception: Cannot parse date: value is too short: Cannot parse Date from String: while executing 'FUNCTION CAST(release_date : 0, 'date' :: 1) -> CAST(release_date, 'date') Date : 2'. (CANNOT_PARSE_DATE)
```
It would be helpful if it told me on which line the error's happening so that I can investigate further.
Contributor guide
Assessment
This issue has not been assessed yet.