[
https://issues.apache.org/jira/browse/ASTERIXDB-3274?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Ian Maxon updated ASTERIXDB-3274:
---------------------------------
Labels: triaged (was: )
> 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
> Priority: Major
> Labels: triaged
> 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)