You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hawq.apache.org by "Kavinder Dhaliwal (JIRA)" <ji...@apache.org> on 2016/02/26 02:55:18 UTC
[jira] [Updated] (HAWQ-462) Querying Hcatalog in HA Secure
Environment Fails
[ 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:
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
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
> Reporter: Kavinder Dhaliwal
> Assignee: Lei Chang
>
> 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
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)