[ https://issues.apache.org/jira/browse/HAWQ-462?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Goden Yao resolved HAWQ-462. ---------------------------- Resolution: Fixed final fix is to use querycontext to pass on the security token as well as the key in Hash table (key is in the format of "protocol://<host><port>"). So pxf (as external table) is using the same code path to handle secured environment query with tokens as native tables. > 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 > Affects Versions: 2.0.0-beta-incubating > Reporter: Kavinder Dhaliwal > Assignee: Shivram Mani > Fix For: 2.0.0 > > > 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)