hodgesrm commented on issue #13572: URL: https://github.com/apache/superset/issues/13572#issuecomment-798771028
Here's a detailed reproduction of this issue. It does not come up in SQLite when I use a virtual env and dev setup. It seems to be related to the VARCHAR(36) column size in PostgreSQL. 1. Update your [virtual] environment to install master version of clickhouse-sqlalchemy from github: `pip install https://github.com/xzkostyan/clickhouse-sqlalchemy` 2. Go into Databases based and set up a database with the following SQLAlchemy URL: `clickhouse+native://demo:[email protected]/default?secure=true` 3. Save the database and go to Datasets panel. 4. Select a new dataset as shown in the image in the bug description. Schema is 'default' and the table name is 'github_events'. 5. Press Save to see the error. ClickHouse Enum types are potentially very large because they list all values. It's hard to give an upper bound for ClickHouse types but if you are storing ClickHouse native types names in VARCHAR I would allocate at least 500 characters. Another option obviously would be to convert to standard SQL types within Superset, which I understand is possible to do. ---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
