+ "from \"example\".\"sales_fact_1997\" as s\n"
+ "join \"example\".\"employee\" as e\n"
+ "on e.\"EMPID\" = s.\"CUST_ID\""
+ "\n order by e.\"EMPID\"";
Tap empTap = new FileTap( new SQLTypedTextDelimited( ",", "\"" ),
"src/main/resources/data/example/employee.tcsv", SinkMode.KEEP );
Tap salesTap = new FileTap( new SQLTypedTextDelimited( ",", "\"" ),
"src/main/resources/data/example/sales_fact_1997.tcsv", SinkMode.KEEP );
Tap resultsTap = new FileTap( new SQLTypedTextDelimited( ",", "\"" ),
"build/test/output/flow/results.tcsv", SinkMode.REPLACE );
FlowDef flowDef = FlowDef.flowDef()
.setName( "sql flow" )
.addSource( "example.employee", empTap )