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