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

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Not A Problem
• Fix Version/s: 0.1.0-m1
• Assignee: Unassigned
• Reporter: Ted Dunning
• Created: 02/Sep/13 02:10
• Updated: 04/Feb/14 16:56
• Resolved: 02/Sep/13 02:24

Description

The following query fails:

select _MAP["N_REGIONKEY"] 
from "nation.parquet"

but the following very similar query succeeds:

select _MAP['N_REGIONKEY'] 
from "nation.parquet"

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.

select _MAP['N_REGIONKEY'] 
from 'nation.parquet';

This is pretty perverse.