[HAWQ-1587] Metadata not being handled correctly with PXF parameter isolation

• 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: 10/Feb/18 01:33
• Updated: 30/Apr/18 21:28
• Resolved: 10/Feb/18 01:53

Description

https://issues.apache.org/jira/browse/HAWQ-1581 separated the system params from the user param.s. installcheck-good reports the following error which is due to the incorrect handling of the METADATA property in the PXF server

  SELECT * FROM pxf_get_item_fields('Hive', '*');
! ERROR:  remote component error (500) from '127.0.0.1:51200':  type  Exception report   message   Internal server error. Property "METADATA" has no value in current request    description   The server encountered an internal error that prevented it from fulfilling this request.    exception   java.lang.IllegalArgumentException: Internal server error. Property "METADATA" has no value in current request 
   \d hcatalog.*.*
+ ERROR:  remote component error (500) from '127.0.0.1:51200':  type  Exception report   message   Internal server error. Property "METADATA" has no value in current request    description   The server encountered an internal error that prevented it from fulfilling this request.    exception   java.lang.IllegalArgumentException: Internal server error. Property "METADATA" has no value in current request 
  SELECT * FROM pxf_get_item_fields('Hive', '*abc*abc*');
! ERROR:  remote component error (500) from '127.0.0.1:51200':  type  Exception report   message   Internal server error. Property "METADATA" has no value in current request    description   The server encountered an internal error that prevented it from fulfilling this request.    exception   java.lang.IllegalArgumentException: Internal server error. Property "METADATA" has no value in current request 
  \d hcatalog.*abc*.*abc*
+ ERROR:  remote component error (500) from '127.0.0.1:51200':  type  Exception report   message   Internal server error. Property "METADATA" has no value in current request    description   The server encountered an internal error that prevented it from fulfilling this request.    exception   java.lang.IllegalArgumentException: Internal server error. Property "METADATA" has no value in current request 
  \d hcatalog
  Invalid pattern provided.
  \d hcatalog.

Issue Links

• links to: GitHub Pull Request #1340