[ https://issues.apache.org/jira/browse/BEAM-301?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16060434#comment-16060434 ]
Xu Mingmin commented on BEAM-301: --------------------------------- [~julianhyde] we're preparing for the first version of SQL support in Beam, both as DSL and CLI client, hopefully in middle of July. You can follow to see all the SQL tasks in https://issues.apache.org/jira/browse/BEAM/component/12332480, and the checklist to merge back to master here https://docs.google.com/document/d/1EHZgSu4Jd75iplYpYT_K_JwSZxL2DWG8kv_EmQzNXFc/edit?usp=sharing. > Add a Beam SQL DSL > ------------------ > > Key: BEAM-301 > URL: https://issues.apache.org/jira/browse/BEAM-301 > Project: Beam > Issue Type: New Feature > Components: dsl-sql, sdk-ideas > Reporter: Jean-Baptiste Onofré > Assignee: Xu Mingmin > > The SQL DSL helps developers to build a Beam pipeline from SQL statement in > String directly. > In Phase I, it starts to support INSERT/SELECT queries with FILTERs, one > example SQL as below: > {code} > INSERT INTO `SUB_USEREVENT` (`SITEID`, `PAGEID`, `PAGENAME`, `EVENTTIMESTAMP`) > (SELECT STREAM `USEREVENT`.`SITEID`, `USEREVENT`.`PAGEID`, > `USEREVENT`.`PAGENAME`, `USEREVENT`.`EVENTTIMESTAMP` > FROM `USEREVENT` AS `USEREVENT` > WHERE `USEREVENT`.`SITEID` > 10) > {code} > A design doc is available at > https://docs.google.com/document/d/1Uc5xYTpO9qsLXtT38OfuoqSLimH_0a1Bz5BsCROMzCU/edit?usp=sharing. -- This message was sent by Atlassian JIRA (v6.4.14#64029)