I have tried several changes and came to a point where i have moved further however still stuck .
From beeline i can run two queries...on two different tables, but when I attempt to run a single query that joins them, I get the following error:
Getting log thread is interrupted, since query is done!
Error: Error while compiling statement: FAILED: SemanticException Unable to compare key strength for hdfs://nameservice1/darchive/source/lls/di/ppxtyu and hdfs://nameservice1/darchive/source/lls/di/aubxcry: java.lang.NullPointerException (state=42000,code=40000)
These are the values i have for them which are in brackets.
whitelist.key.acl.READ (hdfs, hive)
From hive2 logs i see that it comes till getting metadata for the sources and then fails with the above error.
if i do a select * from table it works effectively. however when i do a join it fails.
There are only 2 blacklists with a * rest are no value(no one is blacklisted)
Any suggestions ?
Yes checked that. I have * for most of them.
I dont think whitelist.key.acl.MANAGEMENT requires hive. However i will give it a try.