[jira] [Commented] (HAWQ-965) Error reporting is misleading with incorrect table/file in PXF location in HA cluster

["Goden Yao (JIRA)" <ji...@apache.org>]

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