[
https://issues.apache.org/jira/browse/DRILL-197?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13755867#comment-13755867
]
Ted Dunning commented on DRILL-197:
-----------------------------------
Ahh... as with many of my character defects, this one seems to stem from
over-using MySQL in my youth.
See
http://stackoverflow.com/questions/1992314/what-is-the-difference-between-single-and-double-quotes-in-sql
> Difference between single and double quotes not clear and error messages are
> opaque
> -----------------------------------------------------------------------------------
>
> Key: DRILL-197
> URL: https://issues.apache.org/jira/browse/DRILL-197
> Project: Apache Drill
> Issue Type: Bug
> Reporter: Ted Dunning
>
> The following query fails:
> {code}
> select _MAP["N_REGIONKEY"]
> from "nation.parquet"
> {code}
> but the following very similar query succeeds:
> {code}
> select _MAP['N_REGIONKEY']
> from "nation.parquet"
> {code}
> The difference is in the use of single or double quotes for the index of
> {{_MAP}}
> I certainly don't know what the difference is here, but it seems important to
> either resolve or document.
> Conversely, this query also fails, but this time because double quotes *have*
> to be used.
> {code}
> select _MAP['N_REGIONKEY']
> from 'nation.parquet';
> {code}
> This is pretty perverse.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
