Merge pull request #35 from mbeckerle/site-2834
Fixed JSON example to back-tick keyword `properties`
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 39ad93b..d54eee2 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 @@
},
. . .
-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 |
