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