[jira] [Commented] (ASTERIXDB-2900) Temporary External Dataset

["Michael J. Carey (Jira)" <ji...@apache.org>]

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

Michael J. Carey commented on ASTERIXDB-2900:
---------------------------------------------

An example of such a feature can be found in the way that Neo4J handles its data loading: [https://neo4j.com/docs/cypher-manual/current/clauses/load-csv/.|https://neo4j.com/docs/cypher-manual/current/clauses/load-csv/]

One could imagine maybe adding this as a SQL++ WITH-clause variant, as the WITH clause essentially introduces a temporary view with a local-to-a-query name - thereby avoiding the need to clutter the namespace/metadata of a dataverse and to have to explicitly define and then delete temporary views.

> Temporary External Dataset
> --------------------------
>
>                 Key: ASTERIXDB-2900
>                 URL: https://issues.apache.org/jira/browse/ASTERIXDB-2900
>             Project: Apache AsterixDB
>          Issue Type: New Feature
>            Reporter: Gift Sinthong
>            Priority: Trivial
>
> Creating a temporary dataset that references data in an external data source (e.g., local file, s3, hdfs). It would be nice to be able to interact with external data but not having to drop that external dataset afterward.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)