[jira] [Created] (DRILL-307) Remove _MAP[] from Drill SQL

["Mehant Baid (JIRA)" <ji...@apache.org>]

Mehant Baid created DRILL-307:
---------------------------------

             Summary: Remove _MAP[] from Drill SQL
                 Key: DRILL-307
                 URL: https://issues.apache.org/jira/browse/DRILL-307
             Project: Apache Drill
          Issue Type: Bug
            Reporter: Mehant Baid
            Assignee: Mehant Baid


Currently while executing SQL we need to use _MAP['columnname'] in the select statements. 

The problem while using select statements with columnnames instead of _MAP['columnname'] is that Optiq tries to verify that these columns exist in the schema and raises validation errors. 

The way we've solved the problem is to override the 'rowtype' returned to Optiq while creating a Drill table. We have defined a new class RelDataTypeDrillImpl which is the 'rowtype' returned to Optiq and will be invoked for any validation purposes. RelDataTypeDrillImpl always returns true when queried if a certain field exists in the table, with its type as 'ANY'. This gets us past the validation in Optiq and allows us to use column names directly in select statements. 



--
This message was sent by Atlassian JIRA
(v6.1#6144)