You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@drill.apache.org by Rameshwar Mane <mr...@gmail.com> on 2020/01/22 07:00:56 UTC
Issue in querying in hive tables unsupported operation
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
Re: Issue in querying in hive tables unsupported operation
Posted by Rameshwar Mane <mr...@gmail.com>.
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 <mr...@gmail.com> 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
>