[HAWQ-1581] Separate PXF system parameters from user configurable visible parameters

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 2.3.0.0-incubating
• Component/s: PXF
• Assignee: Shivram Mani
• Reporter: Shivram Mani
• Created: 24/Jan/18 00:28
• Updated: 10/May/18 22:03
• Resolved: 07/Feb/18 00:41

Description

We need to modify our system such that user configurable options are kept distinct form the internal parameters. The custom parameters are configured in the LOCATION section of the external table DDL, is exposed to PXF server as X-GP-<param_name>.

X-GP-USER is an internal parameter used to set the user information. When the DDL has a custom parameter named user it ends up updating X-GP-USER to also include the user configured in the DDL Location. This causes the JDBC connector to fail.

We will instead use {X-GP-OPTIONS-} as the prefix for all user configurable parameters to keep them isolated.

Issue Links

• links to: GitHub Pull Request #1332