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