[ https://issues.apache.org/jira/browse/BEAM-301?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Xu Mingmin updated BEAM-301: ---------------------------- Fix Version/s: 2.2.0 > 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 > Fix For: 2.2.0 > > > 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)