ClickHouse / ClickHouse/ClickHouse

Parsing error doesn't indicate line/row that has issue

Open
#56,740 0 comments 0 reactions 0 assignees View on GitHub
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

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.