Some additional details : Hadoop cluster is kerberos enabled. Drill user has been provided all the permissions required through Apache ranger. Any inputs on the issue? Am i missing any configurations or providing wrong configurations?
Thanks and Regards Rameshwar Mane On Wed, Jan 22, 2020 at 12:30 PM Rameshwar Mane <[email protected]> wrote: > Hi team, > > I was trying to query hive tables using Apache drill web interface. Was > facing following issues. > I am able to list tables and schemas. but while trying to query the table > its not able to execute. > > Please find all the logs and snapshots from web ui below. > Stack Version : > > Drill : 1.17.0 > Hadoop 3.1.1.3.1.4.0-315 > Hive 3.1.0.3.1.4.0-315 > JAVA openjdk version "1.8.0_222" > > Hive Storage Pluign : > > { > "type": "hive", > "configProps": { > "hive.metastore.uris": "thrift://xx.xx.xx.xx:9083", > "hive.metastore.warehouse.dir": "/warehouse/tablespace/managed/hive", > "fs.default.name": "hdfs://xx.xx.xx.xx:8020", > "hive.metastore.sasl.enabled": "true", > "hive.server2.enable.doAs": "false", > "hive.metastore.execute.setugi": "true", > "hive.metastore.kerberos.principal": "hive/_HOST@<REALM>.COM", > "hive.security.authorization.enabled": "true" > }, > "enabled": true > } > > Drill Query Query : > > select * from hiveasg.nifi_test1.assoc_5879238342_avro > > Contents of drillbit.log file : > > https://drive.google.com/file/d/1319oYbwFzprMQsGZ4BTTBT08YyiSWbTT > > Contents of drillbit_queris.json : > > > {"queryId":"21d81830-2eab-0d43-f76e-1e021cd1e111","schema":"","queryText":"select > * from > hiveasg.nifi_test1.assoc_5879238342_avro","start":1579673551875,"finish":1579673551954,"outcome":"FAILED","username":"drill","remoteAddress":"xx.xx.xx.xx:48503"} > > Web api Error snapshot : > > https://drive.google.com/open?id=1Jt5h7do81bFhxtav9Y_W-6_bWKxArp2f >
