You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@calcite.apache.org by "jackylau (Jira)" <ji...@apache.org> on 2023/05/31 02:00:00 UTC

[jira] [Commented] (CALCITE-5736) Add ARRAY_REVERSE for Spark dialect

    [ https://issues.apache.org/jira/browse/CALCITE-5736?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17727754#comment-17727754 ] 

jackylau commented on CALCITE-5736:
-----------------------------------

spark doesn't support the array_reverse.

it supports reverse, which not only can reverse string, but also can reverse array

 

so close this issue

 
{code:java}
reverse(array) - Returns a reversed string or an array with reverse order of elements.Examples:> SELECT reverse('Spark SQL');
 LQS krapS
> SELECT reverse(array(2, 1, 4, 3));
 [3,4,1,2]{code}
 

 

> Add ARRAY_REVERSE for Spark dialect
> -----------------------------------
>
>                 Key: CALCITE-5736
>                 URL: https://issues.apache.org/jira/browse/CALCITE-5736
>             Project: Calcite
>          Issue Type: Improvement
>          Components: core
>    Affects Versions: 1.35.0
>            Reporter: jackylau
>            Priority: Major
>              Labels: pull-request-available
>             Fix For: 1.35.0
>
>




--
This message was sent by Atlassian Jira
(v8.20.10#820010)