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
>