This is an automated email from the ASF dual-hosted git repository.
cgivre pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/drill-site.git
The following commit(s) were added to refs/heads/master by this push:
new de30f12f4 Fixed JSON example to back-tick keyword `properties`
new d205461dc Merge pull request #35 from mbeckerle/site-2834
de30f12f4 is described below
commit de30f12f4b37f73caac35660d0cae8f8d88f9b7a
Author: Michael Beckerle <[email protected]>
AuthorDate: Sun Oct 8 10:50:52 2023 -0400
Fixed JSON example to back-tick keyword `properties`
DRILL-2834
---
_docs/en/data-sources-and-file-formats/050-json-data-model.md | 4 ++--
1 file changed, 2 insertions(+), 2 deletions(-)
diff --git a/_docs/en/data-sources-and-file-formats/050-json-data-model.md
b/_docs/en/data-sources-and-file-formats/050-json-data-model.md
index 39ad93bdc..d54eee273 100644
--- a/_docs/en/data-sources-and-file-formats/050-json-data-model.md
+++ b/_docs/en/data-sources-and-file-formats/050-json-data-model.md
@@ -307,9 +307,9 @@ To access a map field in an array, use dot notation to
drill down through the hi
},
. . .
-This example shows how to drill down using array notation plus dot notation in
features[0].properties.MAPBLKLOT to get the MAPBLKLOT property value in the San
Francisco city lots data:
+This example shows how to drill down using array notation plus dot notation in
features[0].`properties`.MAPBLKLOT to get the MAPBLKLOT property value in the
San Francisco city lots data. Note that the word 'properties' is a Drill SQL
keyword, so must be surrounded by back-ticks:
- SELECT features[0].properties.MAPBLKLOT, FROM
dfs.`/Users/drilluser/citylots.json`;
+ SELECT features[0].`properties`.MAPBLKLOT, FROM
dfs.`/Users/drilluser/citylots.json`;
|------------|
| EXPR$0 |