[jira] [Updated] (DRILL-982) Parquet reader should return NULL value for non-exist column in execution phase, in stead of raising ExecutionSetupException

["Jacques Nadeau (JIRA)" <ji...@apache.org>]

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

Jacques Nadeau updated DRILL-982:
---------------------------------

    Fix Version/s:     (was: 0.4.0)
                   0.5.0

> 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: Jason Altekruse
>             Fix For: 0.5.0
>
>
> 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)