Page History

We're proposing to change the current syntax for COPY FROM.
The current syntax looks as follows:

COPY Customers
USING localfs (
  ("path"="asterix_nc1://data/nontagged/customerData.json"),
  ("format"="json")
);

This syntax uses the old way of configuring the adapter localfs.
In our feeds, we use the WITH clause.
Another issue is that the current syntax is missing the keyword FROM, which makes it ambiguous if we add support for COPY TO.

Concretely we propose to change the syntax to be as follows:

COPY Customers
FROM localfs
PATH ("asterix_nc1://data/nontagged/customerData.json")
WITH {
  "format": "json"
};

First, the proposed syntax introduces the use of FROM <adapterName>.
Second, it mandates the use of PATH (instead of having it in the WITH clause).
Additionally, the proposed syntax will make both COPY FROM and COPY TO less different.

Example of COPY TO:

COPY Customers
TO localfs
PATH("localhost:///myData/Customers")
WITH {
  "format" : "json"
};