[ https://issues.apache.org/jira/browse/HAWQ-965?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15402749#comment-15402749 ]
Goden Yao commented on HAWQ-965: -------------------------------- can you clarify where the incorrect table/file path is in your sample? {code} pxf://singlecluster/... {code} is considered a format of HA uri (without port) in the current logic. > 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 > Fix For: backlog > > > 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)