Closed flover97 closed 3 years ago
apache superset or sqlalchemy doesn't understand decimal datatype for clickhouse
my package versions: aiohttp==3.7.3 alembic==1.5.4 amqp==2.6.1 apache-superset==1.1.0 apispec==3.3.2 appdirs==1.4.4 async-timeout==3.0.1 attrs==20.3.0 Babel==2.9.0 backoff==1.10.0 billiard==3.6.3.0 bleach==3.3.0 Brotli==1.0.9 cachelib==0.1.1 celery==4.4.7 certifi==2020.12.5 cffi==1.14.4 chardet==3.0.4 click==7.1.2 colorama==0.4.4 contextlib2==0.6.0.post1 convertdate==2.3.0 cron-descriptor==1.2.24 croniter==1.0.6 cryptography==3.4.4 decorator==4.4.2 defusedxml==0.6.0 distlib==0.3.1 dnspython==2.1.0 email-validator==1.1.2 filelock==3.0.12 Flask==1.1.2 Flask-AppBuilder==3.1.1 Flask-Babel==1.0.0 Flask-Caching==1.9.0 Flask-Compress==1.8.0 Flask-JWT-Extended==3.25.0 Flask-Login==0.4.1 Flask-Migrate==2.6.0 Flask-OpenID==1.2.5 Flask-SQLAlchemy==2.4.4 flask-talisman==0.7.0 Flask-WTF==0.14.3 future==0.18.2 geographiclib==1.50 geopy==2.1.0 gunicorn==20.0.4 holidays==0.10.3 humanize==3.2.0 idna==2.10 importlib-metadata==3.4.0 infi.clickhouse-orm==2.1.0 iso8601==0.1.14 isodate==0.6.0 itsdangerous==1.1.0 Jinja2==2.11.3 jsonschema==3.2.0 kombu==4.6.11 korean-lunar-calendar==0.2.1 Mako==1.1.4 Markdown==3.3.3 MarkupSafe==1.1.1 marshmallow==3.10.0 marshmallow-enum==1.5.1 marshmallow-sqlalchemy==0.23.1 msgpack==1.0.2 multidict==5.1.0 natsort==7.1.1 numpy==1.20.1 packaging==20.9 pandas==1.2.4 parsedatetime==2.6 pathlib2==2.3.5 pgsanity==0.2.9 Pillow==8.1.0 pkg-resources==0.0.0 polyline==1.4.0 prison==0.1.3 psycopg2==2.8.6 py==1.10.0 pyarrow==3.0.0 pycparser==2.20 PyJWT==1.7.1 PyMeeus==0.3.7 pyparsing==2.4.7 pyrsistent==0.17.3 python-dateutil==2.8.1 python-dotenv==0.15.0 python-editor==1.0.4 python-geohash==0.8.5 python3-openid==3.2.0 pytz==2021.1 PyYAML==5.4.1 redis==3.5.3 requests==2.25.1 retry==0.9.2 selenium==3.141.0 simplejson==3.17.2 six==1.15.0 slackclient==2.5.0 SQLAlchemy==1.3.23 sqlalchemy-clickhouse==0.1.5.post0 SQLAlchemy-Utils==0.36.8 sqlparse==0.3.0 typing-extensions==3.7.4.3 urllib3==1.26.3 uWSGI==2.0.19.1 vine==1.3.0 virtualenv==20.4.2 webencodings==0.5.1 Werkzeug==1.0.1 WTForms==2.3.3 WTForms-JSON==0.3.3 yarl==1.6.3 zipp==3.4.0
aiohttp==3.7.3 alembic==1.5.4 amqp==2.6.1 apache-superset==1.1.0 apispec==3.3.2 appdirs==1.4.4 async-timeout==3.0.1 attrs==20.3.0 Babel==2.9.0 backoff==1.10.0 billiard==3.6.3.0 bleach==3.3.0 Brotli==1.0.9 cachelib==0.1.1 celery==4.4.7 certifi==2020.12.5 cffi==1.14.4 chardet==3.0.4 click==7.1.2 colorama==0.4.4 contextlib2==0.6.0.post1 convertdate==2.3.0 cron-descriptor==1.2.24 croniter==1.0.6 cryptography==3.4.4 decorator==4.4.2 defusedxml==0.6.0 distlib==0.3.1 dnspython==2.1.0 email-validator==1.1.2 filelock==3.0.12 Flask==1.1.2 Flask-AppBuilder==3.1.1 Flask-Babel==1.0.0 Flask-Caching==1.9.0 Flask-Compress==1.8.0 Flask-JWT-Extended==3.25.0 Flask-Login==0.4.1 Flask-Migrate==2.6.0 Flask-OpenID==1.2.5 Flask-SQLAlchemy==2.4.4 flask-talisman==0.7.0 Flask-WTF==0.14.3 future==0.18.2 geographiclib==1.50 geopy==2.1.0 gunicorn==20.0.4 holidays==0.10.3 humanize==3.2.0 idna==2.10 importlib-metadata==3.4.0 infi.clickhouse-orm==2.1.0 iso8601==0.1.14 isodate==0.6.0 itsdangerous==1.1.0 Jinja2==2.11.3 jsonschema==3.2.0 kombu==4.6.11 korean-lunar-calendar==0.2.1 Mako==1.1.4 Markdown==3.3.3 MarkupSafe==1.1.1 marshmallow==3.10.0 marshmallow-enum==1.5.1 marshmallow-sqlalchemy==0.23.1 msgpack==1.0.2 multidict==5.1.0 natsort==7.1.1 numpy==1.20.1 packaging==20.9 pandas==1.2.4 parsedatetime==2.6 pathlib2==2.3.5 pgsanity==0.2.9 Pillow==8.1.0 pkg-resources==0.0.0 polyline==1.4.0 prison==0.1.3 psycopg2==2.8.6 py==1.10.0 pyarrow==3.0.0 pycparser==2.20 PyJWT==1.7.1 PyMeeus==0.3.7 pyparsing==2.4.7 pyrsistent==0.17.3 python-dateutil==2.8.1 python-dotenv==0.15.0 python-editor==1.0.4 python-geohash==0.8.5 python3-openid==3.2.0 pytz==2021.1 PyYAML==5.4.1 redis==3.5.3 requests==2.25.1 retry==0.9.2 selenium==3.141.0 simplejson==3.17.2 six==1.15.0 slackclient==2.5.0 SQLAlchemy==1.3.23 sqlalchemy-clickhouse==0.1.5.post0 SQLAlchemy-Utils==0.36.8 sqlparse==0.3.0 typing-extensions==3.7.4.3 urllib3==1.26.3 uWSGI==2.0.19.1 vine==1.3.0 virtualenv==20.4.2 webencodings==0.5.1 Werkzeug==1.0.1 WTForms==2.3.3 WTForms-JSON==0.3.3 yarl==1.6.3 zipp==3.4.0
better use
apache superset or sqlalchemy doesn't understand decimal datatype for clickhouse
my package versions:
aiohttp==3.7.3 alembic==1.5.4 amqp==2.6.1 apache-superset==1.1.0 apispec==3.3.2 appdirs==1.4.4 async-timeout==3.0.1 attrs==20.3.0 Babel==2.9.0 backoff==1.10.0 billiard==3.6.3.0 bleach==3.3.0 Brotli==1.0.9 cachelib==0.1.1 celery==4.4.7 certifi==2020.12.5 cffi==1.14.4 chardet==3.0.4 click==7.1.2 colorama==0.4.4 contextlib2==0.6.0.post1 convertdate==2.3.0 cron-descriptor==1.2.24 croniter==1.0.6 cryptography==3.4.4 decorator==4.4.2 defusedxml==0.6.0 distlib==0.3.1 dnspython==2.1.0 email-validator==1.1.2 filelock==3.0.12 Flask==1.1.2 Flask-AppBuilder==3.1.1 Flask-Babel==1.0.0 Flask-Caching==1.9.0 Flask-Compress==1.8.0 Flask-JWT-Extended==3.25.0 Flask-Login==0.4.1 Flask-Migrate==2.6.0 Flask-OpenID==1.2.5 Flask-SQLAlchemy==2.4.4 flask-talisman==0.7.0 Flask-WTF==0.14.3 future==0.18.2 geographiclib==1.50 geopy==2.1.0 gunicorn==20.0.4 holidays==0.10.3 humanize==3.2.0 idna==2.10 importlib-metadata==3.4.0 infi.clickhouse-orm==2.1.0 iso8601==0.1.14 isodate==0.6.0 itsdangerous==1.1.0 Jinja2==2.11.3 jsonschema==3.2.0 kombu==4.6.11 korean-lunar-calendar==0.2.1 Mako==1.1.4 Markdown==3.3.3 MarkupSafe==1.1.1 marshmallow==3.10.0 marshmallow-enum==1.5.1 marshmallow-sqlalchemy==0.23.1 msgpack==1.0.2 multidict==5.1.0 natsort==7.1.1 numpy==1.20.1 packaging==20.9 pandas==1.2.4 parsedatetime==2.6 pathlib2==2.3.5 pgsanity==0.2.9 Pillow==8.1.0 pkg-resources==0.0.0 polyline==1.4.0 prison==0.1.3 psycopg2==2.8.6 py==1.10.0 pyarrow==3.0.0 pycparser==2.20 PyJWT==1.7.1 PyMeeus==0.3.7 pyparsing==2.4.7 pyrsistent==0.17.3 python-dateutil==2.8.1 python-dotenv==0.15.0 python-editor==1.0.4 python-geohash==0.8.5 python3-openid==3.2.0 pytz==2021.1 PyYAML==5.4.1 redis==3.5.3 requests==2.25.1 retry==0.9.2 selenium==3.141.0 simplejson==3.17.2 six==1.15.0 slackclient==2.5.0 SQLAlchemy==1.3.23 sqlalchemy-clickhouse==0.1.5.post0 SQLAlchemy-Utils==0.36.8 sqlparse==0.3.0 typing-extensions==3.7.4.3 urllib3==1.26.3 uWSGI==2.0.19.1 vine==1.3.0 virtualenv==20.4.2 webencodings==0.5.1 Werkzeug==1.0.1 WTForms==2.3.3 WTForms-JSON==0.3.3 yarl==1.6.3 zipp==3.4.0