最近在验证flink sql 从source 读取数据写入到sink,验证一些场景,下面是简单的从一个文件当中读取数据写入到一个文件当中,这其中也遇到不少问题
import org.apache.flink.table.api.EnvironmentSettings;
import org.apache.flink.table.api.TableEnvironment;
//前提条件,在tmp目录下的input文件,随便输入一些单词就好
public class JavaSqlWordDemo {
public static void main(String[] args) throws Exception{
EnvironmentSettings settings = EnvironmentSettings.newInstance().build();
TableEnvironment tableEnvironment = TableEnvironment.create(settings);
String source_ddl ="create table filesourcev (word STRING) with ("+
"'connector' = 'filesystem',"+
"'format' = 'csv',"+
"'path' = 'file:///tmp/input')";
tableEnvironment.executeSql(source_ddl);
tableEnvironment.executeSql("select * from filesourcev").print();
String execsql ="create table myfilesink (word STRING) with ("+
"'connector' = 'filesystem',"+
"'format' = 'csv',"+
"'path' = 'file:///tmp/xxdss')";
tableEnvironment.executeSql(execsql);
tableEnvironment.executeSql(