[ https://issues.apache.org/jira/browse/HAWQ-1052?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Oleksandr Diachenko updated HAWQ-1052: -------------------------------------- Description: {code} \d pxf_hive_orc_types External table "public.pxf_hive_orc_types" Column | Type | Modifiers --------+-----------------------------+----------- t1 | text | t2 | text | num1 | integer | dub1 | double precision | dec1 | numeric | tm | timestamp without time zone | r | real | bg | bigint | b | boolean | tn | smallint | sml | smallint | dt | date | vc1 | character varying(5) | c1 | character(3) | bin | bytea | Type: readable Encoding: UTF8 Format type: custom Format options: formatter 'pxfwritable_import' External location: pxf://localhost:51200/hive_orc_all_types?PROFILE=HiveORC&delimiter=^A {code} Query fails if condition applied to boolean column: {code} SELECT t1, b FROM pxf_hive_orc_types WHERE b is true; ERROR: extractPxfAttributes: unsupported node tag 330, unable to extract attribute from qualifier (pxffilters.c:665) (seg4 localhost:40000 pid=73027) DETAIL: External table pxf_hive_orc_types {code} 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} was: {code} \d pxf_hive_orc_types External table "public.pxf_hive_orc_types" Column | Type | Modifiers --------+-----------------------------+----------- t1 | text | t2 | text | num1 | integer | dub1 | double precision | dec1 | numeric | tm | timestamp without time zone | r | real | bg | bigint | b | boolean | tn | smallint | sml | smallint | dt | date | vc1 | character varying(5) | c1 | character(3) | bin | bytea | Type: readable Encoding: UTF8 Format type: custom Format options: formatter 'pxfwritable_import' External location: pxf://localhost:51200/hive_orc_all_types?PROFILE=HiveORC&delimiter=^A {code} Query fails if condition applied to boolean column: {code} SELECT t1, b FROM pxf_hive_orc_types WHERE b is true; ERROR: extractPxfAttributes: unsupported node tag 330, unable to extract attribute from qualifier (pxffilters.c:665) (seg4 localhost:40000 pid=73027) DETAIL: External table pxf_hive_orc_types {code} > SELECT from PXF/ORC table fails for boolean and varchar datatypes > ----------------------------------------------------------------- > > Key: HAWQ-1052 > URL: https://issues.apache.org/jira/browse/HAWQ-1052 > Project: Apache HAWQ > Issue Type: Bug > Components: PXF > Reporter: Oleksandr Diachenko > Assignee: Goden Yao > Priority: Critical > Fix For: 2.0.1.0-incubating > > > {code} > \d pxf_hive_orc_types > External table "public.pxf_hive_orc_types" > Column | Type | Modifiers > --------+-----------------------------+----------- > t1 | text | > t2 | text | > num1 | integer | > dub1 | double precision | > dec1 | numeric | > tm | timestamp without time zone | > r | real | > bg | bigint | > b | boolean | > tn | smallint | > sml | smallint | > dt | date | > vc1 | character varying(5) | > c1 | character(3) | > bin | bytea | > Type: readable > Encoding: UTF8 > Format type: custom > Format options: formatter 'pxfwritable_import' > External location: > pxf://localhost:51200/hive_orc_all_types?PROFILE=HiveORC&delimiter=^A > {code} > Query fails if condition applied to boolean column: > {code} > SELECT t1, b FROM pxf_hive_orc_types WHERE b is true; > ERROR: extractPxfAttributes: unsupported node tag 330, unable to extract > attribute from qualifier (pxffilters.c:665) (seg4 localhost:40000 pid=73027) > DETAIL: External table pxf_hive_orc_types > {code} > 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} -- This message was sent by Atlassian JIRA (v6.3.4#6332)