[
https://issues.apache.org/jira/browse/ASTERIXDB-3344?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Ian Maxon resolved ASTERIXDB-3344.
----------------------------------
Resolution: Fixed
> 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
> Labels: triaged
> 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)