drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jacques Nadeau (JIRA)" <j...@apache.org>
Subject [jira] [Resolved] (DRILL-307) Remove _MAP[] from Drill SQL
Date Tue, 04 Mar 2014 16:58:22 GMT

     [ https://issues.apache.org/jira/browse/DRILL-307?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Jacques Nadeau resolved DRILL-307.
----------------------------------

    Resolution: Fixed

Resolved in recent commit as part of JDBC thinning

> 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
>         Attachments: DRILL-307.patch
>
>
> 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.2#6252)

Mime
View raw message