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
> 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

This message was sent by Atlassian JIRA

View raw message