incubator-drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Neeraja Rentachintala <nrentachint...@maprtech.com>
Subject Re: Meet Some questions when install Apache Drill with Hive as the document
Date Mon, 29 Sep 2014 16:36:52 GMT
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, 夏乐 <xiale@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]
>
>
>
>
>
>
>
>
>

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