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, 夏乐 <[email protected]> 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层 > > 邮箱：[email protected] 网址：www.jr.jd.com > > > > [image: LOGO] > > > > > > > > >
