[jira] [Commented] (HAWQ-1057) LIKE operator is broken for HiveOrc profile

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

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

Oleksandr Diachenko commented on HAWQ-1057:
-------------------------------------------

Looks like issue was introduced after HAWQ-779 merge.

> LIKE operator is broken for HiveOrc profile
> -------------------------------------------
>
>                 Key: HAWQ-1057
>                 URL: https://issues.apache.org/jira/browse/HAWQ-1057
>             Project: Apache HAWQ
>          Issue Type: Bug
>          Components: PXF
>            Reporter: Oleksandr Diachenko
>            Assignee: Goden Yao
>             Fix For: 2.0.1.0-incubating
>
>
> {code}
> # \d pxf_hive_small_data
> External table "public.pxf_hive_small_data"
>  Column |       Type       | Modifiers 
> --------+------------------+-----------
>  t1     | text             | 
>  t2     | text             | 
>  num1   | integer          | 
>  dub1   | double precision | 
> Type: readable
> Encoding: UTF8
> Format type: custom
> Format options: formatter 'pxfwritable_import' 
> External location: pxf://localhost:51200/hive_orc_table?PROFILE=HiveORC&delimiter=
> {code}
> {code}
> select * from pxf_hive_small_data where t1 like '%ro%1';
> ERROR:  remote component error (500) from '192.168.98.232:51200':  type  Exception report   message   Can't create expression (and) with no children.    description   The server encountered an internal error that prevented it from fulfilling this request.    exception   java.io.IOException: Can't create expression (and) with no children. (libchurl.c:884)  (seg2 localhost:40000 pid=72391)
> DETAIL:  External table pxf_hive_small_data
> {code}



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