Hi all,
Thanks to join the meeting. As discussed, we're planning to merge DSL_SQL
branch back to master, targeted in the middle of July. A tag
'dsl_sql_merge'[1] is created to track all todo tasks.
*What's added in Beam SQL?*
BeamSQL provides the capability to execute SQL queries with Beam Java SDK,
either by translating SQL to a PTransform, or run with a standalone CLI
client.
*Checklist for merge:*
1. functionality
1.1. SQL grammer:
1.1.1. basic query with SELECT/FILTER/PROJECT;
1.1.2. AGGREGATION with global window;
1.1.3. AGGREGATION with FIX_TIME/SLIDING_TIME/SESSION window;
1.1.4. JOIN
1.2. UDF/UDAF support;
1.3. support predefined String/Math/Date functions, see[2];
2. DSL interface to convert SQL as PTransform;
3. junit test;
4. Java document;
5. Document of SQL feature in website;
Any comments/suggestions are very welcomed.
Note:
[1].
https://issues.apache.org/jira/browse/BEAM-2436?jql=labels%20%3D%20dsl_sql_merge
[2]. https://calcite.apache.org/docs/reference.html
--
----
Mingmin
