[jira] [Resolved] (HAWQ-1053) Varchar columns are not being projected from WHERE clause for HiveORC profile

["Oleksandr Diachenko (JIRA)" <ji...@apache.org>]

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

Oleksandr Diachenko resolved HAWQ-1053.
---------------------------------------
    Resolution: Fixed

> Varchar columns are not being projected from WHERE clause for HiveORC profile
> -----------------------------------------------------------------------------
>
>                 Key: HAWQ-1053
>                 URL: https://issues.apache.org/jira/browse/HAWQ-1053
>             Project: Apache HAWQ
>          Issue Type: Bug
>          Components: PXF
>            Reporter: Oleksandr Diachenko
>            Assignee: Oleksandr Diachenko
>            Priority: Critical
>             Fix For: 2.0.1.0-incubating
>
>
> Query returns empty result when condition applied to varchar column but it's not in select list:
> {code}
> SELECT t1 FROM pxf_hive_orc_types WHERE vc1 = 'abcd';
>  t1 
> ----
> (0 rows)
> {code}
> But it works when this varchar column included in SELECT clause:
> {code}
> SELECT t1, vc1 FROM pxf_hive_orc_types WHERE vc1 = 'abcd';
>   t1  | vc1  
> ------+------
>  row1 | abcd
> (1 row)
> {code}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)