drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Parth Chandra (JIRA)" <j...@apache.org>
Subject [jira] [Assigned] (DRILL-982) Parquet reader should return NULL value for non-exist column in execution phase, in stead of raising ExecutionSetupException
Date Wed, 20 Aug 2014 17:50:28 GMT

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

Parth Chandra reassigned DRILL-982:
-----------------------------------

    Assignee: DrillCommitter  (was: Parth Chandra)

Reviewed

> Parquet reader should return NULL value for non-exist column in execution phase, in stead
of raising ExecutionSetupException
> ----------------------------------------------------------------------------------------------------------------------------
>
>                 Key: DRILL-982
>                 URL: https://issues.apache.org/jira/browse/DRILL-982
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Storage - Parquet
>            Reporter: Jinfeng Ni
>            Assignee: DrillCommitter
>             Fix For: 0.5.0
>
>         Attachments: 0001-DRILL-982-Return-nulls-for-non-existent-columns-in-p.patch
>
>
> If query a non-exist column against a parquet file, DRILL currently raises ExecutionSetupException:
> SELECT  NON_EXIT_COLUMN from cp.`tpch/nation.parquet`;
> This will cause problem, when we have multiple parquet files, and the first one does
not have the column, while the rest of them have the column.  
>  
> It would be better to return NULL expression during execution stage, if the columns does
not exist in the parquet file. 
> Later on, if DRILL adds a new option to verify column existence before executing a query
( just like what a schema-based system will do), we could throw PlanException in planning
phase, once the parquet footer information is available to planner. 



--
This message was sent by Atlassian JIRA
(v6.2#6252)

Mime
View raw message