Uploaded image for project: 'Flink'
  1. Flink
  2. FLINK-18240

Correct modulus function usage in documentation or allow % operator

    XMLWordPrintableJSON

    Details

      Description

      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:

      SELECT * FROM Orders WHERE a % 2 = 0
      

      But % operator is not allowed in Flink:

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

      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

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                fsk119 Shengkai Fang
                Reporter:
                jark Jark Wu
              • Votes:
                0 Vote for this issue
                Watchers:
                6 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: