[ https://issues.apache.org/jira/browse/FLINK-10172?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16588085#comment-16588085 ]
ASF GitHub Bot commented on FLINK-10172: ---------------------------------------- asfgit closed pull request #6585: [FLINK-10172][table]re-adding asc & desc suffix expression to expressionParser URL: https://github.com/apache/flink/pull/6585 This is a PR merged from a forked repository. As GitHub hides the original diff on merge, it is displayed below for the sake of provenance: As this is a foreign pull request (from a fork), the diff is supplied below (as it won't show otherwise due to GitHub magic): diff --git a/flink-libraries/flink-table/src/main/scala/org/apache/flink/table/api/scala/expressionDsl.scala b/flink-libraries/flink-table/src/main/scala/org/apache/flink/table/api/scala/expressionDsl.scala index dfe69cb0411..12f956b1a57 100644 --- a/flink-libraries/flink-table/src/main/scala/org/apache/flink/table/api/scala/expressionDsl.scala +++ b/flink-libraries/flink-table/src/main/scala/org/apache/flink/table/api/scala/expressionDsl.scala @@ -236,7 +236,18 @@ trait ImplicitExpressionOperations { */ def as(name: Symbol, extraNames: Symbol*) = Alias(expr, name.name, extraNames.map(_.name)) + /** + * Specifies ascending order of an expression i.e. a field for orderBy call. + * + * @return ascend expression + */ def asc = Asc(expr) + + /** + * Specifies descending order of an expression i.e. a field for orderBy call. + * + * @return descend expression + */ def desc = Desc(expr) /** diff --git a/flink-libraries/flink-table/src/main/scala/org/apache/flink/table/expressions/ExpressionParser.scala b/flink-libraries/flink-table/src/main/scala/org/apache/flink/table/expressions/ExpressionParser.scala index 4b2440cf673..c0a577dccfd 100644 --- a/flink-libraries/flink-table/src/main/scala/org/apache/flink/table/expressions/ExpressionParser.scala +++ b/flink-libraries/flink-table/src/main/scala/org/apache/flink/table/expressions/ExpressionParser.scala @@ -48,6 +48,8 @@ object ExpressionParser extends JavaTokenParsers with PackratParsers { // Keyword lazy val AS: Keyword = Keyword("as") lazy val CAST: Keyword = Keyword("cast") + lazy val ASC: Keyword = Keyword("asc") + lazy val DESC: Keyword = Keyword("desc") lazy val NULL: Keyword = Keyword("Null") lazy val IF: Keyword = Keyword("?") lazy val TO_DATE: Keyword = Keyword("toDate") @@ -216,6 +218,12 @@ object ExpressionParser extends JavaTokenParsers with PackratParsers { // suffix operators + lazy val suffixAsc : PackratParser[Expression] = + composite <~ "." ~ ASC ~ opt("()") ^^ { e => Asc(e) } + + lazy val suffixDesc : PackratParser[Expression] = + composite <~ "." ~ DESC ~ opt("()") ^^ { e => Desc(e) } + lazy val suffixCast: PackratParser[Expression] = composite ~ "." ~ CAST ~ "(" ~ dataType ~ ")" ^^ { case e ~ _ ~ _ ~ _ ~ dt ~ _ => Cast(e, dt) @@ -324,6 +332,8 @@ object ExpressionParser extends JavaTokenParsers with PackratParsers { suffixToDate | // expression for log suffixLog | + // expression for ordering + suffixAsc | suffixDesc | // expressions that take enumerations suffixCast | suffixTrim | suffixTrimWithoutArgs | suffixExtract | suffixFloor | suffixCeil | // expressions that take literals diff --git a/flink-libraries/flink-table/src/test/scala/org/apache/flink/table/api/batch/table/stringexpr/SortStringExpressionTest.scala b/flink-libraries/flink-table/src/test/scala/org/apache/flink/table/api/batch/table/stringexpr/SortStringExpressionTest.scala new file mode 100644 index 00000000000..204ec7726aa --- /dev/null +++ b/flink-libraries/flink-table/src/test/scala/org/apache/flink/table/api/batch/table/stringexpr/SortStringExpressionTest.scala @@ -0,0 +1,60 @@ +/* + * Licensed to the Apache Software Foundation (ASF) under one + * or more contributor license agreements. See the NOTICE file + * distributed with this work for additional information + * regarding copyright ownership. The ASF licenses this file + * to you under the Apache License, Version 2.0 (the + * "License"); you may not use this file except in compliance + * with the License. You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * + * Unless required by applicable law or agreed to in writing, software + * distributed under the License is distributed on an "AS IS" BASIS, + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + * See the License for the specific language governing permissions and + * limitations under the License. + */ + +package org.apache.flink.table.api.batch.table.stringexpr + +import org.apache.flink.api.scala._ +import org.apache.flink.table.api.scala._ +import org.apache.flink.table.utils.TableTestBase +import org.junit.Test + +class SortStringExpressionTest extends TableTestBase { + + @Test + def testOrdering(): Unit = { + val util = batchTestUtil() + val t = util.addTable[(Int, Long, String)]("Table3") + + val t1 = t.select('_1 as 'a, '_2 as 'b, '_3 as 'c).orderBy('a) + val t2 = t.select("_1 as a, _2 as b, _3 as c").orderBy("a") + + verifyTableEquals(t1, t2) + } + + @Test + def testExplicitAscendOrdering(): Unit = { + val util = batchTestUtil() + val t = util.addTable[(Int, Long, String)]("Table3") + + val t1 = t.select('_1, '_2).orderBy('_1.asc) + val t2 = t.select("_1, _2").orderBy("_1.asc") + + verifyTableEquals(t1, t2) + } + + @Test + def testExplicitDescendOrdering(): Unit = { + val util = batchTestUtil() + val t = util.addTable[(Int, Long, String)]("Table3") + + val t1 = t.select('_1, '_2).orderBy('_1.desc) + val t2 = t.select("_1, _2").orderBy("_1.desc") + + verifyTableEquals(t1, t2) + } +} ---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: us...@infra.apache.org > Inconsistentcy in ExpressionParser and ExpressionDsl for order by asc/desc > -------------------------------------------------------------------------- > > Key: FLINK-10172 > URL: https://issues.apache.org/jira/browse/FLINK-10172 > Project: Flink > Issue Type: Bug > Components: Table API & SQL > Affects Versions: 1.6.0 > Reporter: Rong Rong > Assignee: Rong Rong > Priority: Major > Labels: pull-request-available > > The following expression throws an exception in parsing {{"id.asc"}} term. > {code:java} > Table allOrders = orderTable > .select("id,order_date,amount,customer_id") > .orderBy("id.asc"); > {code} > while it is correctly parsed for Scala: > {code:scala} > val allOrders:Table = orderTable > .select('id, 'order_date, 'amount, 'customer_id) > .orderBy('id.asc) > {code} > Anticipated some inconsistency between ExpressionParser and ExpressionDsl -- This message was sent by Atlassian JIRA (v7.6.3#76005)