[ https://issues.apache.org/jira/browse/HAWQ-965?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Shivram Mani updated HAWQ-965: ------------------------------ Description: When we create an external table with PXF protocol and use an incorrect path, we get a deceiving error about Standby namenode. eg: {code} template1=# create external table hive_txt1 (a int, b text) location ('pxf://singlecluster/testtxt?profile=Hive') format 'custom' (formatter='pxfwritable_import'); CREATE EXTERNAL TABLE template1=# select * from hive_txt1; ERROR: Standby NameNode of HA nameservice singlecluster was not found after call to Active NameNode failed - failover aborted (pxfmasterapi.c:257) {code} was: When we create an external table with PXF protocol and use an incorrect path, we get a deceiving error about Standby namenode. eg: ``` template1=# create external table hive_txt1 (a int, b text) location ('pxf://singlecluster/testtxt?profile=Hive') format 'custom' (formatter='pxfwritable_import'); CREATE EXTERNAL TABLE template1=# select * from hive_txt1; ERROR: Standby NameNode of HA nameservice singlecluster was not found after call to Active NameNode failed - failover aborted (pxfmasterapi.c:257) ``` > Error reporting is misleading with incorrect table/file in PXF location in HA > cluster > ------------------------------------------------------------------------------------- > > Key: HAWQ-965 > URL: https://issues.apache.org/jira/browse/HAWQ-965 > Project: Apache HAWQ > Issue Type: Bug > Components: PXF > Reporter: Shivram Mani > Assignee: Goden Yao > > When we create an external table with PXF protocol and use an incorrect path, > we get a deceiving error about Standby namenode. > eg: > {code} > template1=# create external table hive_txt1 (a int, b text) location > ('pxf://singlecluster/testtxt?profile=Hive') format 'custom' > (formatter='pxfwritable_import'); > CREATE EXTERNAL TABLE > template1=# select * from hive_txt1; > > ERROR: Standby NameNode of HA nameservice singlecluster was not found > after call to Active NameNode failed - failover aborted (pxfmasterapi.c:257) > {code} -- This message was sent by Atlassian JIRA (v6.3.4#6332)