Wail Y. Alkowaileet created ASTERIXDB-3274:
----------------------------------------------
Summary: Nested values should be skipped when replaced with an
external embedded value
Key: ASTERIXDB-3274
URL: https://issues.apache.org/jira/browse/ASTERIXDB-3274
Project: Apache AsterixDB
Issue Type: Bug
Components: RT - Runtime
Affects Versions: 0.9.9
Reporter: Wail Y. Alkowaileet
Assignee: Wail Y. Alkowaileet
Fix For: 0.9.9
DDL:
{noformat}
CREATE TYPE TestType AS {
};
CREATE EXTERNAL DATASET Name(TestType) USING %adapter% (
%template%,
("container"="playground"),
("definition"="external-filter/embed/name/{name:string}"),
("embed-filter-values" = "true"),
("format"="json")
);{noformat}
Sample data in external-filter/embed/name/{*}Jones{*}:
{noformat}
{"id": 1, "name": {"first": "Mike", "last": "Jones"}, "department":
"accounting"}
{"id": 2, "name": {"first": "Alice"},"department": "engineering"}
{"id": 3, "name": null, "department": "hr"} {noformat}
We can see that the filter value \{name:string} will replace the nested values
such as "name": \{"first": "Mike", "last": "Jones"}. Thus, the JSON parser
should skip those nested values as it will be replaced by the filter value
(i.e., "Jones" as in the example above)
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
