[ 
https://issues.apache.org/jira/browse/HAWQ-1052?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15504862#comment-15504862
 ] 

Shivram Mani commented on HAWQ-1052:
------------------------------------

In extractPxfAttributes() in pxffilters.c we have a check on the operator. For 
operators not supported by PXF we throw an exception. 
{code}
switch(tag) {
                        default:
                                /*
                                 * tag is not supported, it's risk of having:
                                 * 1) false-positive tuples
                                 * 2) unable to join tables
                                 * 3) etc
                                 */
                                elog(ERROR, "extractPxfAttributes: unsupported 
node tag %d, unable to extract attribute from qualifier", tag);
                                break;
}
{code}
Instead we have to allow the query to pass through as filters can be done on 
the HAWQ side

> Select from PXF/ORC table fails for boolean datatype
> ----------------------------------------------------
>
>                 Key: HAWQ-1052
>                 URL: https://issues.apache.org/jira/browse/HAWQ-1052
>             Project: Apache HAWQ
>          Issue Type: Bug
>          Components: PXF
>            Reporter: Oleksandr Diachenko
>            Assignee: Shivram Mani
>            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}



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

Reply via email to