The role of CREATE TABLE is to provide the necessary metadata for the table
-- the location of the data, its format, etc. Executing CREATE TABLE
creates an entry in the catalog, but otherwise doesn't do anything.
In a case like this one
CREATE TABLE Table1 (column_name1 STRING, column_name2 DOUBL
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