ClickHouse Error: year 54725 is out of range

[hermanzdosilovic]

Whatever query I run in SQL Lab I get the following error:

ClickHouse Error
year 54725 is out of range

This may be triggered by:
Issue 1002 - The database returned an unexpected error.

How to reproduce the bug

1. Go to SQL -> SQL Lab
2. Choose any clickhouse database
3. Write any query, for example: select version(), select 1, select now(), or select 'hello, world'
4. See error

Expected results

A query should run successfully.

Actual results

I get the following error:

ClickHouse Error
year 54725 is out of range

This may be triggered by:
Issue 1002 - The database returned an unexpected error.

Screenshots

Environment

• browser type and version: Version 1.44.105 Chromium: 106.0.5249.91 (Official Build) (x86_64)
• superset version: apache/superset:31895f412eba60e274c7158a39cf0a8455ffd671 (Docker image)
• python version: 3.8.13
• node.js version: N/A since I am using official Docker image
• any feature flags active:

  FEATURE_FLAGS = {
      "ALERT_REPORTS": True,
      "DASHBOARD_RBAC": True,
      "ENABLE_TEMPLATE_PROCESSING": True,
      "SCHEDULED_QUERIES": True
  }
  

Checklist

• I have checked the superset logs for python stacktraces and included it here as text if there are any. Logs are available here.
• I have reproduced the issue with at least the latest released version of superset.
• I have checked the issue tracker for the same issue and I haven't found one similar.

Additional context

1. ClickHouse version: 21.12.2.17
2. Using clickhouse-sqlalchemy==0.2.2

[zhaoyongjie]

Hi @hermanzdosilovic, this issue has been resoved by #21667, so I close it. Feel free to reopen this one if you have the same issue yet.