Goden Yao created HAWQ-257:
------------------------------
Summary: PXF to honor user defined port in location URL
Key: HAWQ-257
URL: https://issues.apache.org/jira/browse/HAWQ-257
Project: Apache HAWQ
Issue Type: Improvement
Components: PXF
Reporter: Goden Yao
Assignee: Goden Yao
I should be able to configure which port PXF service is listening to and input
the same value in DDL to create tables
{code}
CREATE EXTERNAL TABLE ext_table <attr list, ...>
LOCATION('pxf://<host>:<port>/path/to/data?...
{code}
When I input a mismatch port number different from what I pre-defined, I should
get a clear error message on that.
*Background information*
The reason that PXF currently ignores the port value in the DDL is due to
legacy issues: 1) user can only configure this port that PXF services listen to
through GUC, which was a hidden secret. We should remove this setting from GUC
and make it more user visible (e.g. in config file) 2) For HA consideration,
when you don't put port in the URI, we use 51200 to connect to the pxf service.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
