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)