Flink SQL execution

Time:2022-5-10

1. 93. Enter the python virtual environment from source / home / liug / venv / bin / activate, and then go to the / home / liug / flick-1.14.0 / bin directory

2、 ./sql-client.sh

3、SET execution.result-mode=table;

4、SELECT name, 
  COUNT(*) AS cnt 
  FROM (VALUES (‘Bob’), (‘Alice’), (‘Greg’), (‘Bob’)) 
  AS NameTable(name) 
  GROUP BY name;

Recommended Today

Interannual variation of South Asian high and its relationship with summer monsoon precipitation in India and East Asia

Summary: Diagnostic analysis shows that the northwest southeast movement of SAH is the main interannual variation feature, which is closely related to the precipitation in India and East Asia. The southeast movement of SAH is closely related to the decrease of summer monsoon precipitation in India and the increase of summer monsoon precipitation in East […]