drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From 澶忎箰 <xi...@jd.com>
Subject Meet Some questions when install Apache Drill with Hive as the document
Date Mon, 29 Sep 2014 11:38:33 GMT
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<mailto:xiale@jd.com>   网址:www.jr.jd.com<http://www.jr.jd.com/>

[LOGO]




Mime
  • Unnamed multipart/related (inline, None, 0 bytes)
View raw message