Mailing-List: contact drill-user-help@incubator.apache.org; run by ezmlm
Precedence: bulk
Reply-To: drill-user@incubator.apache.org
Received-SPF: pass (athena.apache.org: domain of nrentachintala@maprtech.com
 designates 209.85.216.48 as permitted sender)
MIME-Version: 1.0
In-Reply-To: <799E1230FB1C2F4B9E5A7ECC2768CF45987B80@mbx05.360buyAD.local>
References: <799E1230FB1C2F4B9E5A7ECC2768CF45987B80@mbx05.360buyAD.local>
Date: Mon, 29 Sep 2014 09:36:52 -0700
Message-ID: 
 <CAH-_v4+t=SsCww4KyfjEsVo6cmTJU5iHOncHPVUoHB2_KBzPuw@mail.gmail.com>
Subject: Re: Meet Some questions when install Apache Drill with Hive as the
 document
From: Neeraja Rentachintala <nrentachintala@maprtech.com>
To: drill-user@incubator.apache.org
Content-Type: multipart/alternative; boundary=001a11336d5cce01e1050436df00

--001a11336d5cce01e1050436df00
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

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, =E5=A4=8F=E4=B9=90 <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 =E2=80=93service metastore in the computer whose name is
> =E2=80=9Cspark-jrdata-06.pekdc1.jdfin.local=E2=80=9D.
>
> In the drill, I can see hive tables, but  drill always  throws
>
> =E2=80=9C0: jdbc:drill:zk=3Dspark-jrdata-06.pekdc1.jdfin> select * from p=
okes;
>
> 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=3D,code=3D0)=E2=80=9D    when I run sql.
>
>
>
> My environment list below: Apache Hadoop 2.4.1, Hive 0.13, Drill 0.5
>
>
>
> 0: jdbc:drill:zk=3Dspark-jrdata-06.pekdc1.jdfin> use hive;
>
> +------------+------------+
>
> |     ok     |  summary   |
>
> +------------+------------+
>
> | true       | Default schema changed to 'hive' |
>
> +------------+------------+
>
> 1 row selected (0.057 seconds)
>
> 0: jdbc:drill:zk=3Dspark-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)
>
> =E2=80=9C0: jdbc:drill:zk=3Dspark-jrdata-06.pekdc1.jdfin> select * from p=
okes;
>
> 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=3D,code=3D0)=E2=80=9D
>
>
>
> Can you give some advice about it? Thanks.
>
>
>
>
>
> =E5=A4=8F=E4=B9=90  =E4=BA=AC=E4=B8=9C=E9=87=91=E8=9E=8D=E6=8A=80=E6=9C=
=AF=E4=B8=8E=E6=95=B0=E6=8D=AE=E6=9C=8D=E5=8A=A1=E9=83=A8
>
>
> -------------------------------------------------------------------------=
--------------------
>
> =E5=9C=B0=E5=9D=80=EF=BC=9A=E5=8C=97=E4=BA=AC=E5=B8=82=E6=9C=9D=E9=98=B3=
=E5=8C=BA=E5=8C=97=E8=BE=B0=E8=A5=BF=E8=B7=AF8=E5=8F=B7=E5=8C=97=E8=BE=B0=
=E4=B8=96=E7=BA=AA=E4=B8=AD=E5=BF=83A=E5=BA=A75=E5=B1=82
>
> =E9=82=AE=E7=AE=B1=EF=BC=9Axiale@jd.com =E7=BD=91=E5=9D=80=EF=BC=9Awww.jr=
.jd.com
>
>
>
> [image: LOGO]
>
>
>
>
>
>
>
>
>

--001a11336d5cce01e1050436df00--