Hi,
I have succeed install Apache Drill with hdfs. But I meet some questions during
install Apache Drill with hive and Hbase. Can you give some advice for below
questions?
1. Install Apache Dirll with hive. I use follow configuration to config hive
storage. And my Hadoop Cluster has configed HA.
{
"type": "hive",
"enabled": true,
"configProps": {
"hive.metastore.uris": "thrift://spark-jrdata-06.pekdc1.jdfin.local:9083",
"hive.metastore.sasl.enabled": "false",
"fs.default.name": "hdfs://ns1"
}
}
After I use hive �Cservice metastore in the computer whose name is
“spark-jrdata-06.pekdc1.jdfin.local”.
In the drill, I can see hive tables, but drill always throws
“0: jdbc:drill:zk=spark-jrdata-06.pekdc1.jdfin> select * from pokes;
Query failed: Failure while setting up Foreman. Connection refused
[2f1e4ae6-b67d-4252-8456-b4dd36fe9c51]
Error: exception while executing query: Failure while trying to get next result
batch. (state=,code=0)” when I run sql.
My environment list below: Apache Hadoop 2.4.1, Hive 0.13, Drill 0.5
0: jdbc:drill:zk=spark-jrdata-06.pekdc1.jdfin> use hive;
+------------+------------+
| ok | summary |
+------------+------------+
| true | Default schema changed to 'hive' |
+------------+------------+
1 row selected (0.057 seconds)
0: jdbc:drill:zk=spark-jrdata-06.pekdc1.jdfin> show tables; (I can see the
tables in the hive)
+--------------+------------+
| TABLE_SCHEMA | TABLE_NAME |
+--------------+------------+
| hive.default | pokes |
| hive.default | customers |
+--------------+------------+
2 rows selected (0.324 seconds)
“0: jdbc:drill:zk=spark-jrdata-06.pekdc1.jdfin> select * from pokes;
Query failed: Failure while setting up Foreman. Connection refused
[2f1e4ae6-b67d-4252-8456-b4dd36fe9c51]
Error: exception while executing query: Failure while trying to get next result
batch. (state=,code=0)”
Can you give some advice about it? Thanks.
夏乐 京东金融技术与数据服务部
---------------------------------------------------------------------------------------------
地址：北京市朝阳区北辰西路8号北辰世纪中心A座5层
邮箱：[email protected]<mailto:[email protected]> 网址：www.jr.jd.com<http://www.jr.jd.com/>
[LOGO]
