[jira] [Created] (FLINK-3497) Add SQL scalar functions to Table API

["Timo Walther (JIRA)" <ji...@apache.org>]

Timo Walther created FLINK-3497:
-----------------------------------

             Summary: Add SQL scalar functions to Table API
                 Key: FLINK-3497
                 URL: https://issues.apache.org/jira/browse/FLINK-3497
             Project: Flink
          Issue Type: New Feature
          Components: Table API
            Reporter: Timo Walther


In order to use the Table API as ETL tool and prepare for FLINK-2099, we need to add more scalar functions such as {{trim()}}, {{abs()}}, {{like()}}, etc.

Calcite implements the most important functions. We can basically forward calls to Calcites built-in runtime functions. Some functions need special treatment because of Flink specifics.

I would propose the following steps:

- Implement TRIM, SUBSTRING as reference design
- remaining string functions
- math functions
- Date/time functions
- System functions
- Case
- Array
- other

Each step includes implementation, test and documentation.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)