AnsweredAssumed Answered

Drill Query throws UnresolvedAddressException while querying large files (500MB+) but works fine for lesser file size

Question asked by mohanpj on Mar 20, 2017
Latest reply on Mar 28, 2017 by maprcommunity

Drill query on hive table throws back  below error in Drill Web UI.

Below is the query:

SELECT `DATES` FROM hive.Test limit 100

Query Failed: An Error Occurred

org.apache.drill.common.exceptions.UserRemoteException: SYSTEM ERROR: UnresolvedAddressException [Error Id: ebe51799-b609-42be-964d-5e8ee9b2b274 on terminal3:31010]

 

 

 

 

 

===============================================================

Futher details of the components used

[Hive version 1.2]

[Drill version 1.6]

[ MapR  cluster M3 edition ]

 

 

Enabled Storage Plugins (in apache drill web UI for hive plugin connection)

{
"type": "hive",
"enabled": true,
"configProps": {
"hive.metastore.uris": "thrift://ipaddress:9083",
"hive.metastore.warehouse.dir": "/tmp/drill_hive_wh"
}
}

Outcomes