[
https://issues.apache.org/jira/browse/HAWQ-1057?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15494942#comment-15494942
]
Goden Yao commented on HAWQ-1057:
---------------------------------
yep. HAWQ-779 introduced "LIKE" operator - for plugins in the code base, we
should pass through this operator but do nothing as no plugins support this
(only custom plugins might need it)
> 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
> Priority: Critical
> 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)
