drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rameshwar Mane <mr.man...@gmail.com>
Subject Re: Issue in querying in hive tables unsupported operation
Date Fri, 24 Jan 2020 00:54:25 GMT
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.manerm@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
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message