Enum fileds are not supported by create table
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
As a solution you can change nationality Enum16 to nationality Enum16('Russian' = 1, 'English' = 2, 'American' = 3) - for example