You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@flink.apache.org by "Hequn Cheng (JIRA)" <ji...@apache.org> on 2019/01/16 05:51:02 UTC

[jira] [Updated] (FLINK-11342) Add example for every built-In TableAPI&SQL Function

     [ https://issues.apache.org/jira/browse/FLINK-11342?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Hequn Cheng updated FLINK-11342:
--------------------------------
    Description: 
There are a lot of built-in tableApi&SQL functions: https://ci.apache.org/projects/flink/flink-docs-master/dev/table/functions.html

Take {{TEMPORAL.extract(TIMEINTERVALUNIT)}} as an example, we have an example for it. 
{code:java}
E.g., '2006-06-05'.toDate.extract(DAY) returns 5; '2006-06-05'.toDate.extract(QUARTER) returns 2.
{code}

The example is very helpful for users who are not familiar with the udf. And I think it would be great if we can add an example for every built-in function.

This Jira issue is an umbrella issue. As there are kinds of built-in functions, I think it would be better to create more subtasks for it. For example, add a subtask for adding examples for built-in Comparison Functions.

  was:
There are a lot of built-in tableApi&SQL functions: https://ci.apache.org/projects/flink/flink-docs-master/dev/table/functions.html

Take {{TEMPORAL.extract(TIMEINTERVALUNIT)}} as an example, we have an example for it. 
{code:java}
E.g., '2006-06-05'.toDate.extract(DAY) returns 5; '2006-06-05'.toDate.extract(QUARTER) returns 2.
{code}

The example is very helpful for users who are not familiar with the udf. And I think it would be great if we can add an example for every built-in function.



> Add example for every built-In TableAPI&SQL Function 
> -----------------------------------------------------
>
>                 Key: FLINK-11342
>                 URL: https://issues.apache.org/jira/browse/FLINK-11342
>             Project: Flink
>          Issue Type: Improvement
>          Components: Table API &amp; SQL
>    Affects Versions: 1.7.0, 1.7.1
>            Reporter: Hequn Cheng
>            Priority: Major
>
> There are a lot of built-in tableApi&SQL functions: https://ci.apache.org/projects/flink/flink-docs-master/dev/table/functions.html
> Take {{TEMPORAL.extract(TIMEINTERVALUNIT)}} as an example, we have an example for it. 
> {code:java}
> E.g., '2006-06-05'.toDate.extract(DAY) returns 5; '2006-06-05'.toDate.extract(QUARTER) returns 2.
> {code}
> The example is very helpful for users who are not familiar with the udf. And I think it would be great if we can add an example for every built-in function.
> This Jira issue is an umbrella issue. As there are kinds of built-in functions, I think it would be better to create more subtasks for it. For example, add a subtask for adding examples for built-in Comparison Functions.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)