Return-Path: X-Original-To: apmail-incubator-drill-user-archive@minotaur.apache.org Delivered-To: apmail-incubator-drill-user-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id C14721768C for ; Mon, 29 Sep 2014 16:34:03 +0000 (UTC) Received: (qmail 94523 invoked by uid 500); 29 Sep 2014 16:34:03 -0000 Delivered-To: apmail-incubator-drill-user-archive@incubator.apache.org Received: (qmail 94463 invoked by uid 500); 29 Sep 2014 16:34:03 -0000 Mailing-List: contact drill-user-help@incubator.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: drill-user@incubator.apache.org Delivered-To: mailing list drill-user@incubator.apache.org Delivered-To: moderator for drill-user@incubator.apache.org Received: (qmail 79197 invoked by uid 99); 29 Sep 2014 11:39:11 -0000 X-ASF-Spam-Status: No, hits=2.2 required=5.0 tests=HTML_MESSAGE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of xiale@jd.com designates 58.83.206.59 as permitted sender) From: =?gb2312?B?z8TA1g==?= To: "drill-user@incubator.apache.org" Subject: Meet Some questions when install Apache Drill with Hive as the document Thread-Topic: Meet Some questions when install Apache Drill with Hive as the document Thread-Index: Ac/b2d/ttptb1GX9S8CzjcHMcip6gw== Date: Mon, 29 Sep 2014 11:38:33 +0000 Message-ID: <799E1230FB1C2F4B9E5A7ECC2768CF45987B80@mbx05.360buyAD.local> Accept-Language: zh-CN, en-US Content-Language: zh-CN X-MS-Has-Attach: yes X-MS-TNEF-Correlator: x-originating-ip: [118.144.128.53] Content-Type: multipart/related; boundary="_004_799E1230FB1C2F4B9E5A7ECC2768CF45987B80mbx05360buyADloca_"; type="multipart/alternative" MIME-Version: 1.0 X-Virus-Checked: Checked by ClamAV on apache.org --_004_799E1230FB1C2F4B9E5A7ECC2768CF45987B80mbx05360buyADloca_ Content-Type: multipart/alternative; boundary="_000_799E1230FB1C2F4B9E5A7ECC2768CF45987B80mbx05360buyADloca_" --_000_799E1230FB1C2F4B9E5A7ECC2768CF45987B80mbx05360buyADloca_ Content-Type: text/plain; charset="gb2312" Content-Transfer-Encoding: base64 SGksDQpJIGhhdmUgc3VjY2VlZCBpbnN0YWxsIEFwYWNoZSBEcmlsbCB3aXRoIGhkZnMuIEJ1dCBJ IG1lZXQgc29tZSBxdWVzdGlvbnMgZHVyaW5nIGluc3RhbGwgQXBhY2hlIERyaWxsIHdpdGggaGl2 ZSBhbmQgSGJhc2UuIENhbiB5b3UgZ2l2ZSBzb21lIGFkdmljZSBmb3IgYmVsb3cgcXVlc3Rpb25z Pw0KDQoNCjEuICAgIEluc3RhbGwgQXBhY2hlIERpcmxsIHdpdGggaGl2ZS4gSSB1c2UgZm9sbG93 IGNvbmZpZ3VyYXRpb24gdG8gY29uZmlnIGhpdmUgc3RvcmFnZS4gQW5kIG15IEhhZG9vcCBDbHVz dGVyIGhhcyBjb25maWdlZCBIQS4NCg0Kew0KDQogICJ0eXBlIjogImhpdmUiLA0KDQogICJlbmFi bGVkIjogdHJ1ZSwNCg0KICAiY29uZmlnUHJvcHMiOiB7DQoNCiAgICAiaGl2ZS5tZXRhc3RvcmUu dXJpcyI6ICJ0aHJpZnQ6Ly9zcGFyay1qcmRhdGEtMDYucGVrZGMxLmpkZmluLmxvY2FsOjkwODMi LA0KDQogICAgImhpdmUubWV0YXN0b3JlLnNhc2wuZW5hYmxlZCI6ICJmYWxzZSIsDQoNCiAgICAi ZnMuZGVmYXVsdC5uYW1lIjogImhkZnM6Ly9uczEiDQoNCiAgfQ0KDQp9DQoNCkFmdGVyIEkgdXNl IGhpdmUgqENzZXJ2aWNlIG1ldGFzdG9yZSBpbiB0aGUgY29tcHV0ZXIgd2hvc2UgbmFtZSBpcyCh sHNwYXJrLWpyZGF0YS0wNi5wZWtkYzEuamRmaW4ubG9jYWyhsS4NCg0KSW4gdGhlIGRyaWxsLCBJ IGNhbiBzZWUgaGl2ZSB0YWJsZXMsIGJ1dCAgZHJpbGwgYWx3YXlzICB0aHJvd3MNCg0KobAwOiBq ZGJjOmRyaWxsOnprPXNwYXJrLWpyZGF0YS0wNi5wZWtkYzEuamRmaW4+IHNlbGVjdCAqIGZyb20g cG9rZXM7DQoNClF1ZXJ5IGZhaWxlZDogRmFpbHVyZSB3aGlsZSBzZXR0aW5nIHVwIEZvcmVtYW4u IENvbm5lY3Rpb24gcmVmdXNlZCBbMmYxZTRhZTYtYjY3ZC00MjUyLTg0NTYtYjRkZDM2ZmU5YzUx XQ0KDQoNCg0KRXJyb3I6IGV4Y2VwdGlvbiB3aGlsZSBleGVjdXRpbmcgcXVlcnk6IEZhaWx1cmUg d2hpbGUgdHJ5aW5nIHRvIGdldCBuZXh0IHJlc3VsdCBiYXRjaC4gKHN0YXRlPSxjb2RlPTApobEg ICAgd2hlbiBJIHJ1biBzcWwuDQoNCg0KDQpNeSBlbnZpcm9ubWVudCBsaXN0IGJlbG93OiBBcGFj aGUgSGFkb29wIDIuNC4xLCBIaXZlIDAuMTMsIERyaWxsIDAuNQ0KDQoNCg0KMDogamRiYzpkcmls bDp6az1zcGFyay1qcmRhdGEtMDYucGVrZGMxLmpkZmluPiB1c2UgaGl2ZTsNCg0KKy0tLS0tLS0t LS0tLSstLS0tLS0tLS0tLS0rDQoNCnwgICAgIG9rICAgICB8ICBzdW1tYXJ5ICAgfA0KDQorLS0t LS0tLS0tLS0tKy0tLS0tLS0tLS0tLSsNCg0KfCB0cnVlICAgICAgIHwgRGVmYXVsdCBzY2hlbWEg Y2hhbmdlZCB0byAnaGl2ZScgfA0KDQorLS0tLS0tLS0tLS0tKy0tLS0tLS0tLS0tLSsNCg0KMSBy b3cgc2VsZWN0ZWQgKDAuMDU3IHNlY29uZHMpDQoNCjA6IGpkYmM6ZHJpbGw6ems9c3BhcmstanJk YXRhLTA2LnBla2RjMS5qZGZpbj4gc2hvdyB0YWJsZXM7IChJIGNhbiBzZWUgdGhlIHRhYmxlcyBp biB0aGUgaGl2ZSkNCg0KKy0tLS0tLS0tLS0tLS0tKy0tLS0tLS0tLS0tLSsNCg0KfCBUQUJMRV9T Q0hFTUEgfCBUQUJMRV9OQU1FIHwNCg0KKy0tLS0tLS0tLS0tLS0tKy0tLS0tLS0tLS0tLSsNCg0K fCBoaXZlLmRlZmF1bHQgfCBwb2tlcyAgICAgIHwNCg0KfCBoaXZlLmRlZmF1bHQgfCBjdXN0b21l cnMgIHwNCg0KKy0tLS0tLS0tLS0tLS0tKy0tLS0tLS0tLS0tLSsNCg0KMiByb3dzIHNlbGVjdGVk ICgwLjMyNCBzZWNvbmRzKQ0KDQqhsDA6IGpkYmM6ZHJpbGw6ems9c3BhcmstanJkYXRhLTA2LnBl a2RjMS5qZGZpbj4gc2VsZWN0ICogZnJvbSBwb2tlczsNCg0KUXVlcnkgZmFpbGVkOiBGYWlsdXJl IHdoaWxlIHNldHRpbmcgdXAgRm9yZW1hbi4gQ29ubmVjdGlvbiByZWZ1c2VkIFsyZjFlNGFlNi1i NjdkLTQyNTItODQ1Ni1iNGRkMzZmZTljNTFdDQoNCg0KDQpFcnJvcjogZXhjZXB0aW9uIHdoaWxl IGV4ZWN1dGluZyBxdWVyeTogRmFpbHVyZSB3aGlsZSB0cnlpbmcgdG8gZ2V0IG5leHQgcmVzdWx0 IGJhdGNoLiAoc3RhdGU9LGNvZGU9MCmhsQ0KDQoNCg0KQ2FuIHlvdSBnaXZlIHNvbWUgYWR2aWNl IGFib3V0IGl0PyBUaGFua3MuDQoNCg0KDQrPxMDWICC+qbarvfDI2ry8yvXT68r9vt23/s7xsr8N Ci0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLQ0KtdjWt6O6sbG+qcrQs6/R9Mf4 sbGzvc73wrc4usWxsbO9ysC8zdbQ0MRB1/k1suMNCtPKz+SjunhpYWxlQGpkLmNvbTxtYWlsdG86 eGlhbGVAamQuY29tPqGhoaGhoc341rejund3dy5qci5qZC5jb208aHR0cDovL3d3dy5qci5qZC5j b20vPg0KDQpbTE9HT10NCg0KDQoNCg0K --_000_799E1230FB1C2F4B9E5A7ECC2768CF45987B80mbx05360buyADloca_ Content-Type: text/html; charset="gb2312" Content-Transfer-Encoding: quoted-printable

Hi,<= o:p>

I ha= ve 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 bel= ow questions?

 

1.    Install Apache Dirll with hive. I use follow configuration to config hi= ve storage. And my Hadoop Cluster has configed HA.

{

  "type":= "hive",

  "enabled&quo= t;: true,

  "configProps= ": {

    "= ;hive.metastore.uris": "thrift://spark-jrdata-06.pekdc1.jdfin.loc= al:9083", 

    = "hive.metastore.sasl.enabled": "false",

    "= ;fs.default.name": "hdfs://ns1"

  }

= }

= After I use hive =A8Cservic= e metastore in the computer whose name is =A1=B0spark-jrdata-06.pekdc1.jdfi= n.local=A1=B1.

In the drill, I can see = hive tables, but  drill always  throws

=A1=B00: jdbc:= drill:zk=3Dspark-jrdata-06.pekdc1.jdfin> select * from pokes;=

Query failed: = Failure while setting up Foreman. Connection refused [2f1e4ae6-b67d-4252-84= 56-b4dd36fe9c51]

 

= Error: exception = while executing query: Failure while trying to get next result batch. (stat= e=3D,code=3D0)=A1=B1    wh= en 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 se= conds)

0: jdbc:drill:zk=3Dspark= -jrdata-06.pekdc1.jdfin> show tables; (I can see the tables in the hive)

+--------------+= ------------+

| TABLE_SCHEMA | TABLE_N= AME |

+--------------+= ------------+

| hive.default | pokes&n= bsp;     |

| hive.default | custome= rs  |

+--------------+= ------------+

2 rows selected (0.324 s= econds)

=A1=B00: jdbc:= drill:zk=3Dspark-jrdata-06.pekdc1.jdfin> select * from pokes;=

Query failed: = Failure while setting up Foreman. Connection refused [2f1e4ae6-b67d-4252-84= 56-b4dd36fe9c51]

 

Error: excepti= on while executing query: Failure while trying to get next result batch. (s= tate=3D,code=3D0)=A1=B1

 

Can you give some advice= about it? Thanks.

=  

 

=CF=C4=C0=D6  =BE=A9=B6=AB=BD=F0=C8=DA=BC=BC=CA=F5=D3=EB=CA=FD=BE=DD=B7=FE=CE=F1= =B2=BF

-----------------------------------------------= ----------------------------------------------

=B5=D8=D6=B7=A3=BA=B1=B1=BE=A9=CA=D0=B3=AF=D1=F4=C7=F8=B1=B1=B3= =BD=CE=F7=C2=B78=BA=C5=B1=B1=B3=BD=CA=C0=BC=CD= =D6=D0=D0=C4A=D7=F95=B2=E3

=D3=CA=CF=E4=A3=BAxiale@j= d.com=A1=A1=A1=A1=A1=A1=CD=F8=D6=B7=A3=BAwww.jr.jd.com

 

=3D"LOGO"

&nbs= p;

&n= bsp;

 

 

--_000_799E1230FB1C2F4B9E5A7ECC2768CF45987B80mbx05360buyADloca_-- --_004_799E1230FB1C2F4B9E5A7ECC2768CF45987B80mbx05360buyADloca_--