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)