You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@asterixdb.apache.org by "ASF subversion and git services (Jira)" <ji...@apache.org> on 2023/05/05 13:19:00 UTC

[jira] [Commented] (ASTERIXDB-3174) Support Create Dataset As Select Syntax

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

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

Commit 0814b0e559f1c677972db6e59b35e47b99c84a96 in asterixdb's branch refs/heads/master from Peeyush Gupta
[ https://gitbox.apache.org/repos/asf?p=asterixdb.git;h=0814b0e559 ]

[ASTERIXDB-3174][COMP] Support CREATE DATASET AS SELECT Syntax

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

Details:
With this change we add support for CREATE DATASET AS SELECT syntax
that can be used to initialize a dataset during it creation by
upserting data from the result of a query.

Change-Id: I4d49b944ed11532ff45b6862345b11b9fae236c1
Reviewed-on: https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/17508
Integration-Tests: Jenkins <je...@fulliautomatix.ics.uci.edu>
Tested-by: Jenkins <je...@fulliautomatix.ics.uci.edu>
Reviewed-by: Peeyush Gupta <pe...@couchbase.com>
Reviewed-by: Murtadha Hubail <mh...@apache.org>


> Support Create Dataset As Select Syntax
> ---------------------------------------
>
>                 Key: ASTERIXDB-3174
>                 URL: https://issues.apache.org/jira/browse/ASTERIXDB-3174
>             Project: Apache AsterixDB
>          Issue Type: Improvement
>          Components: COMP - Compiler
>    Affects Versions: 0.9.9
>            Reporter: Peeyush Gupta
>            Priority: Major
>             Fix For: 0.9.9
>
>
> Add support for CREATE DATASET AS SELECT syntax that can be used to initialize a dataset during it creation by upserting data from the result of a query.
> E.g.,
> {code:java}
> create dataset orders_copy primary key (oid: int64) as
> select value x from orders x {code}



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