Hey Arthur, I don't think Drill was able to resolve your hostname/cluster-name. Some system or cluster configuration might not be right. Please try with an IP address instead. You can refer to http://drill.apache.org/docs/hive-storage-plugin/ for details.
I would also suggest first try querying HDFS by using the DFS storage plug-in. That would confirm if you are able to connect to your cluster and query files. Refer to: http://drill.apache.org/docs/file-system-storage-plugin/ Also, Drill does not fully support Hive 1.1.0 as yet. Supports Hive 0.13 as of now and support for Hive 1.0.0 is coming soon. Regards, Abhishek On Sun, Jun 14, 2015 at 5:37 AM, Arthur Chan <[email protected]> wrote: > Hi, > > I just installed DRILL, and trying my first query from Drill to get data > from HIVE, however, I got the following error: > > org.apache.drill.common.exceptions.UserRemoteException: SYSTEM ERROR: > java.net.UnknownHostException: mycluster > > > Information about my Hive/Hadoop > > Hive: 1.1.0 > > Hadoop: 2.6.0 cluster with HA, the hdfs cluster name is "mycluster" > > > Below is my configuration: > > { > > "type": "hive", > > "enabled": true, > > "configProps": { > > "hive.metastore.uris": "thrift://192.168.0.31:9083", > > "hive.metastore.sasl.enabled": "false", > > "hive.metastore.warehouse.dir": "/user/hadoop/hive/warehouse", > > "fs.default.name": "hdfs:///mycluster" > > } > > } > > > > Please help! > > Regards >
