constant.txt

Consider the schema of table department
name,type,default_type,default_expression,comment,codec_expression,ttl_expression
DEPT_ID, Nullable(UInt32),,,,,
DEPT_NAME, Nullable(String),,,,,
DEPT_LOCATION, Nullable(String),,,,,

with data
DEPT_ID,DEPT_NAME,DEPT_LOCATION
10,Accounts,Delhi
20,Marketing ,Delhi
40,IT,Warsaw
30,Production,Hyderabad
50,Sales,Bengaluru

schema for table employee
name,type,default_type,default_expression,comment,codec_expression,ttl_expression
EMP_ID, Nullable(UInt32),,,,,
EMP_NAME, Nullable(String),,,,,
DEPT_ID, Nullable(UInt32),,,,,
SALARY, Nullable(UInt64),,,,,

and data for the table employee

EMP_ID,EMP_NAME,DEPT_ID,SALARY
1,Jojo,20,5000
2,Popat Lal,30,15000
3,Santa Singh,40,25000
4,Banta Singh,20,7500
5,Sohan Lal,20,15000
6,Kk,10,12000
7,Bob,20,35000
8,John,30,25000
9,Smith,40,5000