[jira] [Created] (FLINK-18240) Correct remainder function usage in documentation or allow % operator

["Jark Wu (Jira)" <ji...@apache.org>]

Jark Wu created FLINK-18240:
-------------------------------

             Summary: Correct remainder function usage in documentation or allow % operator
                 Key: FLINK-18240
                 URL: https://issues.apache.org/jira/browse/FLINK-18240
             Project: Flink
          Issue Type: Bug
          Components: Documentation, Table SQL / API
            Reporter: Jark Wu


In the documentation: https://ci.apache.org/projects/flink/flink-docs-release-1.10/dev/table/sql/queries.html#scan-projection-and-filter

There is an example:

{code}
SELECT * FROM Orders WHERE a % 2 = 0
{code}

But % operator is not allowed in Flink:


{code:java}
org.apache.calcite.sql.parser.SqlParseException: Percent remainder '%' is not allowed under the current SQL conformance level
{code}

Either we correct the documentation to use {{MOD}} function, or allow % operator. 

This is reported in user-zh ML: http://apache-flink.147419.n8.nabble.com/FLINK-SQL-td3822.html



--
This message was sent by Atlassian Jira
(v8.3.4#803005)