You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@asterixdb.apache.org by "Wail Y. Alkowaileet (Jira)" <ji...@apache.org> on 2023/10/02 19:47:00 UTC
[jira] [Created] (ASTERIXDB-3274) Nested values should be skipped when replaced with an external embedded value
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)