You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@drill.apache.org by 夏乐 <xi...@jd.com> on 2014/09/29 13:38:33 UTC
Meet Some questions when install Apache Drill with Hive as the
document
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��
���䣺xiale@jd.com<ma...@jd.com>��������ַ��www.jr.jd.com<http://www.jr.jd.com/>
[LOGO]
Re: Meet Some questions when install Apache Drill with Hive as the document
Posted by Neeraja Rentachintala <nr...@maprtech.com>.
Hi
Dril in the current version (0.5) doesnt support Hive 0.13.
This could be a possible reason for the error.
Does this work for you with Hive 0.12.
On Mon, Sep 29, 2014 at 4:38 AM, 夏乐 <xi...@jd.com> wrote:
> 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 –service 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层
>
> 邮箱:xiale@jd.com 网址:www.jr.jd.com
>
>
>
> [image: LOGO]
>
>
>
>
>
>
>
>
>