To create table from file:
"CREATE TABLE Table1 (column_name1 STRING, column_name2 DOUBLE) WITH ('connector' = 'filesystem', 'path' = 'file:///C:/temp/test4.txt', 'format' = 'csv', 'csv.field-delimiter' = ';')");
To create file:
"CREATE TABLE Table1 (column_name1 STRING, column_name2 DOUBLE) WITH ( 'connector'='filesystem', 'path'='file:///C:/temp/test', 'format' = 'csv', 'csv.field-delimiter'= ';')");
Till I add 'sink.partition-commit.delay' or something - syntax is same.