You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@superset.apache.org by GitBox <gi...@apache.org> on 2021/03/18 10:53:51 UTC
[GitHub] [superset] bm8836900 opened a new issue #13690: the "type" field in the "table_columns" table was too short
bm8836900 opened a new issue #13690:
URL: https://github.com/apache/superset/issues/13690
There is an enum in my table. When creating a data set, the creation failed because the "type" field in the "table_columns" table was too short
DataBase：mysql 5.7.33
Superset Error Message：(MySQLdb._exceptions.DataError) (1406, "Data too long for column 'type' at row 1")
[SQL: INSERT INTO table_columns (uuid, created_on, changed_on, column_name, verbose_name, is_active, type, groupby, filterable, description, table_id, is_dttm, expression, python_date_format, created_by_fk, changed_by_fk) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)]
[parameters: (b'#\xe8J\xd1\xa9\xeaOg\xaaI\x12\x1c\x7fR\xfd\x82', datetime.datetime(2021, 3, 18, 17, 30, 17, 894672), datetime.datetime(2021, 3, 18, 17, 30, 17, 894672), 'Continent', None, 1, "ENUM('ASIA','EUROPE','NORTH AMERICA','AFRICA','OCEANIA','ANTARCTICA','SOUTH AMERICA')", 1, 1, None, 6, 0, None, None, 1, 1)]
----------------------------------------------------------------
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:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [superset] ganczarek commented on issue #13690: the "type" field in the "table_columns" table was too short
Posted by GitBox <gi...@apache.org>.
ganczarek commented on issue #13690:
URL: https://github.com/apache/superset/issues/13690#issuecomment-940994956
https://github.com/apache/superset/issues/13572 is the same issue.
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [superset] bm8836900 commented on issue #13690: the "type" field in the "table_columns" table was too short
Posted by GitBox <gi...@apache.org>.
bm8836900 commented on issue #13690:
URL: https://github.com/apache/superset/issues/13690#issuecomment-808786067
superset version：1.0.1
mysql databse：test
mysql table name：country
在mysql自带测试库test中的country表中，有一个字段“Continent”是用enum类型创建的。在superset创建数据集时，superset会将源表的表结构保存在“table”表中。其中“type”字段是将源表字段数据类型以字符串的形式保存的。所以在遇到较长字符串时，因为“type”字段长度的限制，导致无法保存源表数据结构，导致superset创建数据集失败。例如：
field name：Continent
field data type：ENUM('ASIA','EUROPE','NORTH AMERICA','AFRICA','OCEANIA','ANTARCTICA','SOUTH AMERICA')
--
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:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org