[jira] [Commented] (ASTERIXDB-3344) Allow ORDER BY without PARTITION BY in COPY TO

["ASF subversion and git services (Jira)" <ji...@apache.org>]

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

ASF subversion and git services commented on ASTERIXDB-3344:
------------------------------------------------------------

Commit b5886b11cc5e7c4e9a686285345a1118a0a151b0 in asterixdb's branch refs/heads/master from Wail Alkowaileet
[ https://gitbox.apache.org/repos/asf?p=asterixdb.git;h=b5886b11cc ]

[ASTERIXDB-3344][COMP] Support ORDER BY without PARTITION BY in COPY TO

- user model changes: yes
- storage format changes: no
- interface changes: no

Details:
Support sorting the written result of COPY TO without PARTITION BY.

Change-Id: I7f3b3e32bd5c40e18111c816b2791f5fff65bc82
Reviewed-on: https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/18137
Reviewed-by: Ali Alsuliman <al...@gmail.com>
Tested-by: Jenkins <je...@fulliautomatix.ics.uci.edu>
Integration-Tests: Wail Alkowaileet <wa...@gmail.com>


> Allow ORDER BY without PARTITION BY in COPY TO
> ----------------------------------------------
>
>                 Key: ASTERIXDB-3344
>                 URL: https://issues.apache.org/jira/browse/ASTERIXDB-3344
>             Project: Apache AsterixDB
>          Issue Type: Bug
>          Components: COMP - Compiler
>    Affects Versions: 0.9.9
>            Reporter: Wail Y. Alkowaileet
>            Assignee: Wail Y. Alkowaileet
>            Priority: Major
>             Fix For: 0.9.9
>
>
> Example:
> {noformat}
> COPY Customer c
> TO S3
> PATH ("copy-to-result", "order-by")
> -- Write the result sorted by the company
> -- Notice that there's no PARTITION BY in the OVER-clause
> OVER (ORDER BY c.company)
> WITH {
>     "accessKeyId":"dummyAccessKey",
>     "secretAccessKey":"dummySecretKey",
>     "region":"us-west-2",
>     "container":"playground",
>     "format":"json"
> } {noformat}



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