You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@drill.apache.org by cg...@apache.org on 2023/10/09 15:52:08 UTC
[drill-site] branch master updated: Fixed JSON example to back-tick keyword `properties`
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 <mb...@apache.org>
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 |