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

Example 86 with Tuple3

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

the class SumMinMaxITCase method testSumMaxAndProject.

@Test
public void testSumMaxAndProject() throws Exception {
    final ExecutionEnvironment env = ExecutionEnvironment.getExecutionEnvironment();
    DataSet<Tuple3<Integer, Long, String>> ds = CollectionDataSets.get3TupleDataSet(env);
    DataSet<Tuple2<Integer, Long>> sumDs = ds.sum(0).andMax(1).project(0, 1);
    List<Tuple2<Integer, Long>> result = sumDs.collect();
    String expected = "231,6\n";
    compareResultAsTuples(result, expected);
}

Example 87 with Tuple3

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

the class SumMinMaxITCase method testNestedAggregate.

@Test
public void testNestedAggregate() throws Exception {
    /*
		 * Nested Aggregate
		 */
    final ExecutionEnvironment env = ExecutionEnvironment.getExecutionEnvironment();
    DataSet<Tuple3<Integer, Long, String>> ds = CollectionDataSets.get3TupleDataSet(env);
    DataSet<Tuple1<Integer>> aggregateDs = ds.groupBy(1).min(0).min(0).project(0);
    List<Tuple1<Integer>> result = aggregateDs.collect();
    String expected = "1\n";
    compareResultAsTuples(result, expected);
}

Example 88 with Tuple3

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

the class TableEnvironmentITCase method testRegisterWithFields.

@Test
public void testRegisterWithFields() 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);
    tableEnv.registerDataSet(tableName, ds, "a, b, c");
    Table t = tableEnv.scan(tableName);
    Table result = t.select("a, b, c");
    DataSet<Row> resultSet = tableEnv.toDataSet(result, Row.class);
    List<Row> results = resultSet.collect();
    String expected = "1,1,Hi\n" + "2,2,Hello\n" + "3,2,Hello world\n" + "4,3,Hello world, how are you?\n" + "5,3,I am fine.\n" + "6,3,Luke Skywalker\n" + "7,4,Comment#1\n" + "8,4,Comment#2\n" + "9,4,Comment#3\n" + "10,4,Comment#4\n" + "11,5,Comment#5\n" + "12,5,Comment#6\n" + "13,5,Comment#7\n" + "14,5,Comment#8\n" + "15,5,Comment#9\n" + "16,6,Comment#10\n" + "17,6,Comment#11\n" + "18,6,Comment#12\n" + "19,6,Comment#13\n" + "20,6,Comment#14\n" + "21,6,Comment#15\n";
    compareResultAsText(results, expected);
}

Example 89 with Tuple3

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

the class TableEnvironmentITCase method testTableRegisterNew.

@Test
public void testTableRegisterNew() 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);
    tableEnv.unregisterTable(tableName);
    Table t2 = tableEnv.fromDataSet(ds).filter("f0 > 8");
    tableEnv.registerTable(tableName, t2);
    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 = "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);
}

Example 90 with Tuple3

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

the class SqlITCase method testJoin.

@Test
public void testJoin() throws Exception {
    ExecutionEnvironment env = ExecutionEnvironment.getExecutionEnvironment();
    BatchTableEnvironment tableEnv = TableEnvironment.getTableEnvironment(env, config());
    DataSet<Tuple3<Integer, Long, String>> ds1 = CollectionDataSets.getSmall3TupleDataSet(env);
    DataSet<Tuple5<Integer, Long, Integer, String, Long>> ds2 = CollectionDataSets.get5TupleDataSet(env);
    tableEnv.registerDataSet("t1", ds1, "a, b, c");
    tableEnv.registerDataSet("t2", ds2, "d, e, f, g, h");
    String sqlQuery = "SELECT c, g FROM t1, t2 WHERE b = e";
    Table result = tableEnv.sql(sqlQuery);
    DataSet<Row> resultSet = tableEnv.toDataSet(result, Row.class);
    List<Row> results = resultSet.collect();
    String expected = "Hi,Hallo\n" + "Hello,Hallo Welt\n" + "Hello world,Hallo Welt\n";
    compareResultAsText(results, expected);
}