[
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 <[email protected]>
Tested-by: Jenkins <[email protected]>
Integration-Tests: Wail Alkowaileet <[email protected]>
> 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)
