You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hawq.apache.org by "Oleksandr Diachenko (JIRA)" <ji...@apache.org> on 2016/09/14 22:18:20 UTC
[jira] [Updated] (HAWQ-1052) Incorrect result for PXF/ORC table
fails for boolean, varchar, real datatypes
[ https://issues.apache.org/jira/browse/HAWQ-1052?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Oleksandr Diachenko updated HAWQ-1052:
--------------------------------------
Summary: Incorrect result for PXF/ORC table fails for boolean, varchar, real datatypes (was: SELECT from PXF/ORC table fails for boolean, varchar, real datatypes)
> Incorrect result for PXF/ORC table fails for boolean, varchar, real 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)