Wail Y. Alkowaileet created ASTERIXDB-3344:
----------------------------------------------

             Summary: 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
             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)

Reply via email to