Examples with Tuple3 org.apache.flink.api.java.tuple.Tuple3 used on opensource projects

Example 91 with Tuple3

use of org.apache.flink.api.java.tuple.Tuple3 in project flink by apache.

the class SqlITCase method testFilterFromDataSet.

@Test
public void testFilterFromDataSet() throws Exception {
    ExecutionEnvironment env = ExecutionEnvironment.getExecutionEnvironment();
    BatchTableEnvironment tableEnv = TableEnvironment.getTableEnvironment(env, config());
    DataSet<Tuple3<Integer, Long, String>> ds = CollectionDataSets.get3TupleDataSet(env);
    tableEnv.registerDataSet("DataSetTable", ds, "x, y, z");
    String sqlQuery = "SELECT x FROM DataSetTable WHERE z LIKE '%Hello%'";
    Table result = tableEnv.sql(sqlQuery);
    DataSet<Row> resultSet = tableEnv.toDataSet(result, Row.class);
    List<Row> results = resultSet.collect();
    String expected = "2\n" + "3\n" + "4";
    compareResultAsText(results, expected);
}

Example 92 with Tuple3

use of org.apache.flink.api.java.tuple.Tuple3 in project flink by apache.

the class SqlITCase method testSelectFromTable.

@Test
public void testSelectFromTable() throws Exception {
    ExecutionEnvironment env = ExecutionEnvironment.getExecutionEnvironment();
    BatchTableEnvironment tableEnv = TableEnvironment.getTableEnvironment(env, config());
    DataSet<Tuple3<Integer, Long, String>> ds = CollectionDataSets.get3TupleDataSet(env);
    Table in = tableEnv.fromDataSet(ds, "a,b,c");
    tableEnv.registerTable("T", in);
    String sqlQuery = "SELECT a, c FROM T";
    Table result = tableEnv.sql(sqlQuery);
    DataSet<Row> resultSet = tableEnv.toDataSet(result, Row.class);
    List<Row> results = resultSet.collect();
    String expected = "1,Hi\n" + "2,Hello\n" + "3,Hello world\n" + "4,Hello world, how are you?\n" + "5,I am fine.\n" + "6,Luke Skywalker\n" + "7,Comment#1\n" + "8,Comment#2\n" + "9,Comment#3\n" + "10,Comment#4\n" + "11,Comment#5\n" + "12,Comment#6\n" + "13,Comment#7\n" + "14,Comment#8\n" + "15,Comment#9\n" + "16,Comment#10\n" + "17,Comment#11\n" + "18,Comment#12\n" + "19,Comment#13\n" + "20,Comment#14\n" + "21,Comment#15\n";
    compareResultAsText(results, expected);
}

Example 93 with Tuple3

use of org.apache.flink.api.java.tuple.Tuple3 in project flink by apache.

the class SqlITCase method testAggregation.

@Test
public void testAggregation() throws Exception {
    ExecutionEnvironment env = ExecutionEnvironment.getExecutionEnvironment();
    BatchTableEnvironment tableEnv = TableEnvironment.getTableEnvironment(env, config());
    DataSet<Tuple3<Integer, Long, String>> ds = CollectionDataSets.get3TupleDataSet(env);
    tableEnv.registerDataSet("AggTable", ds, "x, y, z");
    String sqlQuery = "SELECT sum(x), min(x), max(x), count(y), avg(x) FROM AggTable";
    Table result = tableEnv.sql(sqlQuery);
    DataSet<Row> resultSet = tableEnv.toDataSet(result, Row.class);
    List<Row> results = resultSet.collect();
    String expected = "231,1,21,21,11";
    compareResultAsText(results, expected);
}

Example 94 with Tuple3

use of org.apache.flink.api.java.tuple.Tuple3 in project flink by apache.

the class SqlITCase method testUnion.

@Test
public void testUnion() throws Exception {
    StreamExecutionEnvironment env = StreamExecutionEnvironment.getExecutionEnvironment();
    StreamTableEnvironment tableEnv = TableEnvironment.getTableEnvironment(env);
    StreamITCase.clear();
    DataStream<Tuple3<Integer, Long, String>> ds1 = StreamTestData.getSmall3TupleDataSet(env);
    Table t1 = tableEnv.fromDataStream(ds1, "a,b,c");
    tableEnv.registerTable("T1", t1);
    DataStream<Tuple5<Integer, Long, Integer, String, Long>> ds2 = StreamTestData.get5TupleDataStream(env);
    tableEnv.registerDataStream("T2", ds2, "a, b, d, c, e");
    String sqlQuery = "SELECT * FROM T1 " + "UNION ALL " + "(SELECT a, b, c FROM T2 WHERE a	< 3)";
    Table result = tableEnv.sql(sqlQuery);
    DataStream<Row> resultSet = tableEnv.toDataStream(result, Row.class);
    resultSet.addSink(new StreamITCase.StringSink());
    env.execute();
    List<String> expected = new ArrayList<>();
    expected.add("1,1,Hi");
    expected.add("2,2,Hello");
    expected.add("3,2,Hello world");
    expected.add("1,1,Hallo");
    expected.add("2,2,Hallo Welt");
    expected.add("2,3,Hallo Welt wie");
    StreamITCase.compareWithList(expected);
}

Example 95 with Tuple3

use of org.apache.flink.api.java.tuple.Tuple3 in project flink by apache.

the class TableEnvironmentITCase method testTableRegister.

@Test
public void testTableRegister() throws Exception {
    final String tableName = "MyTable";
    ExecutionEnvironment env = ExecutionEnvironment.getExecutionEnvironment();
    BatchTableEnvironment tableEnv = TableEnvironment.getTableEnvironment(env, config());
    DataSet<Tuple3<Integer, Long, String>> ds = CollectionDataSets.get3TupleDataSet(env);
    Table t = tableEnv.fromDataSet(ds);
    tableEnv.registerTable(tableName, t);
    Table result = tableEnv.scan(tableName).select("f0, f1").filter("f0 > 7");
    DataSet<Row> resultSet = tableEnv.toDataSet(result, Row.class);
    List<Row> results = resultSet.collect();
    String expected = "8,4\n" + "9,4\n" + "10,4\n" + "11,5\n" + "12,5\n" + "13,5\n" + "14,5\n" + "15,5\n" + "16,6\n" + "17,6\n" + "18,6\n" + "19,6\n" + "20,6\n" + "21,6\n";
    compareResultAsText(results, expected);
}