[
https://issues.apache.org/jira/browse/HAWQ-462?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Kavinder Dhaliwal updated HAWQ-462:
-----------------------------------
Description:
On an HA Secure Cluster querying a hive external table works:
{code}
create external table pxf_hive(s1 text, n1 int, d1 float, bg bigint, b boolean)
location
('pxf://ip-10-32-38-119.ore1.vpc.pivotal.io:51200/hive_table?profile=Hive')
format 'custom' (formatter='pxfwritable_import');
select * from pxf_hive;
{code}
but querying the same table via hcatalog does not
{code}
SELECT * FROM hcatalog.default.hive_table;
ERROR: Failed to acquire a delegation token for uri hdfs://localhost:8020/
(hd_work_mgr.c:930)
{code}
This should be fixed by the PR for
https://issues.apache.org/jira/browse/HAWQ-317
was:
On an HA Secure Cluster querying a hive external table works:
```
create external table pxf_hive(s1 text, n1 int, d1 float, bg bigint, b boolean)
location
('pxf://ip-10-32-38-119.ore1.vpc.pivotal.io:51200/hive_table?profile=Hive')
format 'custom' (formatter='pxfwritable_import');
select * from pxf_hive;
```
but querying the same table via hcatalog does not
SELECT * FROM hcatalog.default.hive_table;
ERROR: Failed to acquire a delegation token for uri hdfs://localhost:8020/
(hd_work_mgr.c:930)
This should be fixed by the PR for
https://issues.apache.org/jira/browse/HAWQ-317
> Querying Hcatalog in HA Secure Environment Fails
> ------------------------------------------------
>
> Key: HAWQ-462
> URL: https://issues.apache.org/jira/browse/HAWQ-462
> Project: Apache HAWQ
> Issue Type: Bug
> Components: External Tables, Hcatalog, PXF
> Reporter: Kavinder Dhaliwal
> Assignee: Lei Chang
>
> On an HA Secure Cluster querying a hive external table works:
> {code}
> create external table pxf_hive(s1 text, n1 int, d1 float, bg bigint, b
> boolean) location
> ('pxf://ip-10-32-38-119.ore1.vpc.pivotal.io:51200/hive_table?profile=Hive')
> format 'custom' (formatter='pxfwritable_import');
> select * from pxf_hive;
> {code}
> but querying the same table via hcatalog does not
> {code}
> SELECT * FROM hcatalog.default.hive_table;
> ERROR: Failed to acquire a delegation token for uri hdfs://localhost:8020/
> (hd_work_mgr.c:930)
> {code}
> This should be fixed by the PR for
> https://issues.apache.org/jira/browse/HAWQ-317
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
