Convert Impala to ClickHouse

CREATE TABLE IF NOT EXISTS EMPLOYEE (

   Id INT COMMENT 'Employee Id',

   Name STRING COMMENT 'Employee Name',

   Salary BIGINT COMMENT 'Employee Salary',

   Boilerplate_content STRING,

   Gender STRING,

   Join_dt DATE

 )

 COMMENT 'Employee Table'

 PARTITIONED BY(Join_dt DATE)

 ROW FORMAT DELIMITED

 FIELDS TERMINATED BY ','

 STORED AS TEXTFILE