You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hawq.apache.org by "Shivram Mani (JIRA)" <ji...@apache.org> on 2016/10/07 22:01:20 UTC
[jira] [Created] (HAWQ-1088) Escape string constants in filters
being passed to PXF via X-GP-FILTER
Shivram Mani created HAWQ-1088:
----------------------------------
Summary: Escape string constants in filters being passed to PXF via X-GP-FILTER
Key: HAWQ-1088
URL: https://issues.apache.org/jira/browse/HAWQ-1088
Project: Apache HAWQ
Issue Type: Sub-task
Components: PXF
Reporter: Shivram Mani
Assignee: Lei Chang
IF a query is provided with a constant containing quotes, it messes up with the parsing logic on the java side.
Eg: select * from nametable where name = 's"hivram';
The filterstring being passed as X-GP-FILTER: a1c\"s"hivram\"o5
The Filter parser now interprest the constant and the operation incorrectly and throws the below excpetion
{code}
ERROR: remote component error (500) from '127.0.0.1:51200': type Exception report message unknown opcode h(104) at 6 (filter string: 'a1c"s"hivram"o5') description The server encountered an internal error that prevented it from fulfilling this request. exception java.io.IOException: unknown opcode h(104) at 6 (filter string: 'a1c"s"hivram"o5') (libchurl.c:884) (seg5 localhost:40000 pid=28874)
DETAIL: External table hive_smallorc
{code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)