I’m having trouble connecting Dremio Community to a remote Hive database. The error I get is:
java.net.ConnectException: Call From tqbigdprodldremiomr01/10.24.192.243 to isilonscprodhadoop.sari.local:8020 failed on connection exception: java.net.ConnectException: Connection refused; For more details see: http://wiki.apache.org/hadoop/ConnectionRefused
The Hive instance connects and I actually get the tables listed from the metastore. The problem comes with every query.
Every other connection: Greenplum, HDFS, ElasticSearch … works just fine.
Our HDFS is virtualized by EMC Isilon. I can connect to HDFS from the HDFS Dremio plugin, but it gives me an error when connecting to hive. Have any of you stumbled upon such a situation?
Thanks in advance