|NO.Z.00064|——————————|BigDataEnd|——|Hadoop&Flink.V03|——|Flink.v03|Flink SQL|Flink SQL查询数据|Table API|SQL|

一、FlinkSQL：查询数据

### --- Table API
~~~     官网：https://ci.apache.org/projects/flink/flink-docs-release-1.11/dev/table/tableApi.htmlselect/filter/as
Table filtered = table.select($("name"),$("age")).filter($("age").mod(2).isEqual(0));

### --- 将处理结果输出到控制台
~~~     DataStream<Tuple2<Boolean, Row>> result = tEnv.toRetractStream(filtered, Row.class);

Table mingzi = table.select($("name").as("mingzi"));

DataStream<Tuple2<Boolean, Row>> result = tEnv.toRetractStream(mingzi, Row.class);

### --- SQL

tEnv.createTemporaryView("userss",data, $("name"), $("age"));
String s = "select name,age from userss where mod(age,2)=0";Table table = tEnv.sqlQuery(s);
DataStream<Tuple2<Boolean, Row>> result = tEnv.toRetractStream(table, Row.class);

---

 

 

 

 

 

 

 

 

 

---

Walter Savage Landor:strove with none,for none was worth my strife.Nature I loved and, next to Nature, Art:I warm'd both hands before the fire of life.It sinks, and I am ready to depart

                                                                                                                                                   ——W.S.Landor

---