[jira] [Commented] (DRILL-197) Difference between single and double quotes not clear and error messages are opaque

["Julian Hyde (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/DRILL-197?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13890848#comment-13890848 ] 

Julian Hyde commented on DRILL-197:
-----------------------------------

Now https://github.com/julianhyde/optiq/issues/33 is fixed, Optiq can support what Drill needs.

> 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
>             Fix For: 1.0.0-milestone-1
>
>
> 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 was sent by Atlassian JIRA
(v6.1.5#6160)