search

Altinity / clickhouse-mysql-data-reader

utility to read mysql data
MIT License
368 stars 94 forks source link

Enum fileds are not supported by create table #154

Open lelvisl opened 5 years ago

lelvisl commented 5 years ago

2019-06-21 14:57:36,391/1561129056.391024:DEBUG:Query: CREATE TABLE IF NOT EXISTS DEV.candidates ( id String, created_at DateTime, updated_at Nullable(DateTime), last_name String, first_name String, other_name Nullable(String), gender Enum16, nationality Enum16, date_born Date, address String, phone String, other_phone String, email Nullable(String), education_id String, user_id String, search_full_name String, by_robot Nullable(Int8) )

2019-06-21 14:57:36,391/1561129056.391306:DEBUG:Block send time: 0.000087 2019-06-21 14:57:36,392/1561129056.392637:CRITICAL:Code: 92. DB::Exception: Enum data type cannot be empty. Stack trace:

script don't get enum values from mysql

goodFancier commented 4 years ago

As a solution you can change nationality Enum16 to nationality Enum16('Russian' = 1, 'English' = 2, 'American' = 3) - for example