beam-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "ASF GitHub Bot (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (BEAM-301) Add a Beam SQL DSL
Date Mon, 10 Apr 2017 02:58:41 GMT

    [ https://issues.apache.org/jira/browse/BEAM-301?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15962383#comment-15962383
] 

ASF GitHub Bot commented on BEAM-301:
-------------------------------------

GitHub user XuMingmin opened a pull request:

    https://github.com/apache/beam/pull/2479

    [BEAM-301] Add a Beam SQL DSL

    The initial PR to setup skeleton of Beam SQL. 
    Pass `mvn verify` locally, a Jenkins job is required later for pre-commit check.

You can merge this pull request into a Git repository by running:

    $ git pull https://github.com/XuMingmin/beam sql_init_pr

Alternatively you can review and apply these changes as the patch at:

    https://github.com/apache/beam/pull/2479.patch

To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:

    This closes #2479
    
----
commit 07904d383bb2b14badb031be2bf5222e2d2c8d03
Author: mingmxu <mingmxu@ebay.com>
Date:   2017-04-10T02:49:08Z

    initial PR to setup Beam SQL skeleton
    
    initial PR to setup Beam SQL skeleton
    
    format fix in pom.xml

----


> Add a Beam SQL DSL
> ------------------
>
>                 Key: BEAM-301
>                 URL: https://issues.apache.org/jira/browse/BEAM-301
>             Project: Beam
>          Issue Type: New Feature
>          Components: 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.3.15#6346)

Mime
View raw message