flink-issues 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] (FLINK-6749) Table API / SQL Docs: SQL Page
Date Wed, 07 Jun 2017 22:07:19 GMT

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

ASF GitHub Bot commented on FLINK-6749:
---------------------------------------

Github user fhueske commented on a diff in the pull request:

    https://github.com/apache/flink/pull/4046#discussion_r120752761
  
    --- Diff: docs/dev/table/sql.md ---
    @@ -163,31 +164,257 @@ For a better definition of SQL queries within a Java String, Flink
SQL uses a le
     
     {% top %}
     
    -Example Queries
    ----------------
    +Operations
    +--------------------
    +
    +### Scan, Projection, and Filter
     
    -**TODO: Add a examples for different operations with similar structure as for the Table
API. Add highlighted tags if an operation is not supported by stream / batch.**
    -
    -* Scan & Values
    -* Selection & Projection
    -* Aggregations (distinct only Batch)
    -  * GroupBy
    -  * GroupBy Windows (TUMBLE, HOP, SESSION)
    -  * OVER windows (Only Stream)
    -  * Grouping sets, rollup, cube (only batch)
    -  * Having (only batch?)
    -* Joins
    -  * Inner equi joins (only batch)
    -  * Outer equi joins (only batch)
    -  * TableFunction
    -* Set operations (only batch, except Union ALL)
    -* OrderBy + Limit + Offset
    +<div markdown="1">
    +<table class="table table-bordered">
    +  <thead>
    +    <tr>
    +      <th class="text-left" style="width: 20%">Operators</th>
    +      <th class="text-center">Description</th>
    +    </tr>
    +  </thead>
    +  <tbody>
    +  	<tr>
    +  		<td><strong>Scan / Select / As</strong></td>
    +  		<td>
    +{% highlight sql %}
    +SELECT * FROM Orders
    +SELECT a, c AS d FROM Orders
    +{% endhighlight %}
    +      </td>
    +  	</tr>
    +    <tr>
    +      <td><strong>Where / Filter</strong></td>
    +      <td>
    +{% highlight sql %}
    +SELECT * FROM Orders WHERE b = 'red'
    +SELECT * FROM Orders WHERE a % 2 = 0
    +{% endhighlight %}
    +      </td>
    +    </tr>
    +    <tr>
    +      <td><strong>User Defined Functions (UDF)</strong></td>
    +      <td>
    +      <p>SQL queries can refer to UDFs provided that they are registered in the
`TableEnvironment`.</p>
    --- End diff --
    
    Markdown highlighting does not seem to work here. We should also add a link to the UDF
docs.


> Table API / SQL Docs: SQL Page
> ------------------------------
>
>                 Key: FLINK-6749
>                 URL: https://issues.apache.org/jira/browse/FLINK-6749
>             Project: Flink
>          Issue Type: Sub-task
>          Components: Documentation, Table API & SQL
>    Affects Versions: 1.3.0
>            Reporter: Fabian Hueske
>            Assignee: Haohui Mai
>
> Update and refine {{./docs/dev/table/sql.md}} in feature branch https://github.com/apache/flink/tree/tableDocs



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)

Mime
View raw message