[
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)