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   |

Reply via email to