Adding drill-dev
-----Original Message-----
From: Ahmad, Sami
Sent: Tuesday, May 14, 2019 1:08 PM
To: [email protected]
Cc: [email protected]
Subject: RE: WELCOME to [email protected]
I am not able to see any hive or hbase tables in drill , I get the schema fine
, getting the error in the logfile shown below .
Regards
[root@hadoop1 bin]# ./drillbit.sh start
Starting drillbit, logging to /root/apache-drill-1.16.0/log/drillbit.out
[root@hadoop1 bin]#
[root@hadoop1 bin]# ./sqlline -u jdbc:drill:zk=hadoop1:2181 Apache Drill 1.16.0
"Say hello to my little Drill."
apache drill> show schemas;
+--------------------+
| SCHEMA_NAME |
+--------------------+
| cp.default |
| dfs.default |
| dfs.root |
| dfs.tmp |
| hbase |
| hive.aaronm |
| hive.default |
| hive.es_testdb |
| hive.guest |
| hive.ivann |
| hive.levic |
| hive.nasirq |
| hive.nipar |
| hive.rangertst |
| hive.richas |
| hive.roumig |
| hive.sami |
| hive.sandeeps |
| hive.sasmitap |
| hive.sid |
| hive.swaroopa |
| hive.tito |
| hive.usha |
| information_schema |
| sys |
+--------------------+
25 rows selected (1.869 seconds)
apache drill> use hive;
+------+----------------------------------+
| ok | summary |
+------+----------------------------------+
| true | Default schema changed to [hive] |
+------+----------------------------------+
1 row selected (0.103 seconds)
apache drill (hive)> show tables; <<<< NOT SHOWING ANY
HIVE TABLES.
+--------------+------------+
| TABLE_SCHEMA | TABLE_NAME |
+--------------+------------+
+--------------+------------+
No rows selected (0.601 seconds)
apache drill (hive)>
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
[na:1.8.0_112]
at java.lang.Thread.run(Thread.java:745) [na:1.8.0_112] Caused by:
java.util.concurrent.ExecutionException: MetaException(message:Got exception:
org.apache.thrift.TApplicationException Invalid method name:
'get_tables_by_type')
at
org.apache.drill.shaded.guava.com.google.common.util.concurrent.AbstractFuture.getDoneValue(AbstractFuture.java:502)
~[drill-shaded-guava-23.0.jar:23.0]
at
org.apache.drill.shaded.guava.com.google.common.util.concurrent.AbstractFuture.get(AbstractFuture.java:461)
~[drill-shaded-guava-23.0.jar:23.0]
at
org.apache.drill.shaded.guava.com.google.common.util.concurrent.AbstractFuture$TrustedFuture.get(AbstractFuture.java:83)
~[drill-shaded-guava-23.0.jar:23.0]
at
org.apache.drill.shaded.guava.com.google.common.util.concurrent.Uninterruptibles.getUninterruptibly(Uninterruptibles.java:142)
~[drill-shaded-guava-23.0.jar:23.0]
at
org.apache.drill.shaded.guava.com.google.common.cache.LocalCache$Segment.getAndRecordStats(LocalCache.java:2453)
~[drill-shaded-guava-23.0.jar:23.0]
at
org.apache.drill.shaded.guava.com.google.common.cache.LocalCache$Segment.loadSync(LocalCache.java:2417)
~[drill-shaded-guava-23.0.jar:23.0]
at o
-----Original Message-----
From: [email protected] [mailto:[email protected]]
Sent: Tuesday, May 14, 2019 10:55 AM
To: Ahmad, Sami <[email protected]>
Subject: WELCOME to [email protected]
EXTERNAL SENDER: Use caution with links and attachments.
Hi! This is the ezmlm program. I'm managing the [email protected] mailing
list.
I'm working for my owner, who can be reached at [email protected].
Acknowledgment: I have added the address
[email protected]
to the user mailing list.
Welcome to [email protected]!
Please save this message so that you know the address you are subscribed under,
in case you later want to unsubscribe or change your subscription address.
--- Administrative commands for the user list ---
I can handle administrative requests automatically. Please do not send them to
the list address! Instead, send your message to the correct command address:
To subscribe to the list, send a message to:
<[email protected]>
To remove your address from the list, send a message to:
<[email protected]>
Send mail to the following for info and FAQ for this list:
<[email protected]>
<[email protected]>
Similar addresses exist for the digest list:
<[email protected]>
<[email protected]>
To get messages 123 through 145 (a maximum of 100 per request), mail:
<[email protected]>
To get an index with subject and author for messages 123-456 , mail:
<[email protected]>
They are always returned as sets of 100, max 2000 per request, so you'll
actually get 100-499.
To receive all messages with the same subject as message 12345, send a short
message to:
<[email protected]>
The messages should contain one line or word of text to avoid being treated as
sp@m, but I will ignore their content.
Only the ADDRESS you send to is important.
You can start a subscription for an alternate address, for example
"[email protected]", just add a hyphen and your address (with '=' instead of
'@') after the command word:
<[email protected]>
To stop subscription for this address, mail:
<[email protected]>
In both cases, I'll send a confirmation message to that address. When you
receive it, simply reply to it to complete your subscription.
If despite following these instructions, you do not get the desired results,
please contact my owner at [email protected]. Please be patient, my
owner is a lot slower than I am ;-)
--- Enclosed is a copy of the request I received.
Return-Path: <[email protected]>
Received: (qmail 12237 invoked by uid 99); 14 May 2019 14:55:15 -0000
Received: from pnap-us-west-generic-nat.apache.org (HELO
spamd1-us-west.apache.org) (209.188.14.142)
by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 14 May 2019 14:55:15 +0000
Received: from localhost (localhost [127.0.0.1])
by spamd1-us-west.apache.org (ASF Mail Server at
spamd1-us-west.apache.org) with ESMTP id 42BBFC5B46
for
<user-sc.1557845487.ongognfnibknechabfkd-Sami.Ahmad=dot.state.fl...@drill.apache.org>;
Tue, 14 May 2019 14:55:15 +0000 (UTC)
X-Virus-Scanned: Debian amavisd-new at spamd1-us-west.apache.org
X-Spam-Flag: NO
X-Spam-Score: 0.549
X-Spam-Level:
X-Spam-Status: No, score=0.549 tagged_above=-999 required=6.31
tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1,
DKIM_VALID_EF=-0.1, KAM_INFOUSMEBIZ=0.75, RCVD_IN_DNSWL_NONE=-0.0001,
SPF_HELO_PASS=-0.001, SPF_PASS=-0.001, URIBL_BLOCKED=0.001]
autolearn=disabled
Authentication-Results: spamd1-us-west.apache.org (amavisd-new);
dkim=pass (1024-bit key) header.d=dot.state.fl.us
Received: from mx1-lw-eu.apache.org ([10.40.0.8])
by localhost (spamd1-us-west.apache.org [10.40.0.7]) (amavisd-new, port
10024)
with ESMTP id WIGqrOYFhOGS
for
<user-sc.1557845487.ongognfnibknechabfkd-Sami.Ahmad=dot.state.fl...@drill.apache.org>;
Tue, 14 May 2019 14:55:12 +0000 (UTC)
Received: from GCC01-CY1-obe.outbound.protection.outlook.com
(mail-eopbgr830121.outbound.protection.outlook.com [40.107.83.121])
by mx1-lw-eu.apache.org (ASF Mail Server at mx1-lw-eu.apache.org) with
ESMTPS id 385AA5FB42
for
<user-sc.1557845487.ongognfnibknechabfkd-Sami.Ahmad=dot.state.fl...@drill.apache.org>;
Tue, 14 May 2019 14:55:12 +0000 (UTC)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=dot.state.fl.us;
s=selector1;
h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck;
bh=FG36ZZm24V/Sa+Cahhby4FdXeuNBBjVrqcw7MAftG3U=;
b=kubvI7tJmYr7oLS7lzYjZwd0rTfPHJgNKouDkKCD6sH5wfmOhKO0tMsh9Z4/X9Y63Oymn5dxz6j2wwV9M1d6YOsP1EPjy3/e5zBGZP/sUGpVCBXyTMrLzY7HdBb2NlUvi3vw6TD4UPRSsqALt8bf0dMr/TPhSoDnpHvkrXANaZM=
Received: from BL0PR0901MB3154.namprd09.prod.outlook.com (20.177.243.145) by
BL0PR0901MB2481.namprd09.prod.outlook.com (52.132.19.143) with Microsoft SMTP
Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id
15.20.1878.21; Tue, 14 May 2019 14:55:03 +0000
Received: from BL0PR0901MB3154.namprd09.prod.outlook.com
([fe80::f8d0:42f:dc63:9883]) by BL0PR0901MB3154.namprd09.prod.outlook.com
([fe80::f8d0:42f:dc63:9883%7]) with mapi id 15.20.1878.024; Tue, 14 May 2019
14:55:03 +0000
From: "Ahmad, Sami" <[email protected]>
To:
"user-sc.1557845487.ongognfnibknechabfkd-Sami.Ahmad=dot.state.fl...@drill.apache.org"
<user-sc.1557845487.ongognfnibknechabfkd-Sami.Ahmad=dot.state.fl...@drill.apache.org>
Subject: RE: confirm subscribe to [email protected]
Thread-Topic: confirm subscribe to [email protected]
Thread-Index: AQHVCmSDlyDdP1lRT0SYTvGULj1vtqZqtS8Q
Date: Tue, 14 May 2019 14:55:03 +0000
Message-ID:
<bl0pr0901mb3154e9e2d60af474e6fa961689...@bl0pr0901mb3154.namprd09.prod.outlook.com>
References: <[email protected]>
In-Reply-To: <[email protected]>
Accept-Language: en-US
Content-Language: en-US
X-MS-Has-Attach:
X-MS-TNEF-Correlator:
authentication-results: spf=none (sender IP is )
[email protected];
x-originating-ip: [156.75.180.190]
x-ms-publictraffictype: Email
x-ms-office365-filtering-correlation-id: 891d59b5-e680-490f-e77a-08d6d87c258a
x-ms-office365-filtering-ht: Tenant
x-microsoft-antispam:
BCL:0;PCL:0;RULEID:(2390118)(7020095)(4652040)(8989299)(4534185)(4627221)(201703031133081)(201702281549075)(8990200)(5600141)(711020)(4605104)(4618075)(2017052603328)(7193020);SRVR:BL0PR0901MB2481;
x-ms-traffictypediagnostic: BL0PR0901MB2481:
x-ms-exchange-purlcount: 1
x-microsoft-antispam-prvs:
<bl0pr0901mb2481972fb739d8b1bbfc5ea889...@bl0pr0901mb2481.namprd09.prod.outlook.com>
x-ms-oob-tlc-oobclassifiers: OLM:6108;
x-forefront-prvs: 0037FD6480
x-forefront-antispam-report:
SFV:NSPM;SFS:(10019020)(346002)(366004)(39860400002)(396003)(136003)(376002)(13464003)(199004)(189003)(786003)(74482002)(186003)(222073003)(316002)(53936002)(55016002)(6506007)(86362001)(66574012)(9686003)(6306002)(53546011)(81156014)(99286004)(7696005)(5660300002)(76176011)(8676002)(8936002)(68736007)(81166006)(71200400001)(71190400001)(74316002)(229853002)(66066001)(446003)(66946007)(66476007)(14454004)(64756008)(45080400002)(476003)(256004)(478600001)(66446008)(66556008)(52536014)(966005)(486006)(11346002)(2906002)(14444005)(5024004)(72206003)(19627235002)(26005)(3846002)(25786009)(6116002)(305945005)(7736002)(6436002)(73956011)(76116006)(33656002)(102836004)(6246003)(10126004)(30470500001);DIR:OUT;SFP:1102;SCL:1;SRVR:BL0PR0901MB2481;H:BL0PR0901MB3154.namprd09.prod.outlook.com;FPR:;SPF:None;LANG:en;PTR:InfoNoRecords;A:1;MX:1;
received-spf: None (protection.outlook.com: dot.state.fl.us does not designate
permitted sender hosts)
x-ms-exchange-senderadcheck: 1
x-microsoft-antispam-message-info:
k2rNJMj8gMUewNyNOmI0SUR+UCyah3rez5r2HigVsxBskiAAZWkWINZXHfqqFEclRqF4i+o1zV6fLJgi21JXzH4zC2cUwLqjfAhQaVHkPf1tevLYvdIbmetRZPeLHXldcWQO2KfTn0YdXBGyQrv9CgAleETkSlJlU47PChYqxlDMkFyx5uwYItTRIJ+M1UMatfen4JeLkLqY38qiMhFl0k6vhEKMbf6bUGmhHFFSvRKTlMTD3jOepQ/0KDsq3bytE/g96JFoFcNJjlQ3YeYQNjj588uisRW7SMAYvlGZY5aVSoMmlQX5zDAX1C9Q4H07TfFGFgBWguBYlLrVYKQ5Lni8AEkozf2NfQVk5h1aPk62ANi/9njwEJwGfMn1S+LDn1zPveeTa65+FFTdsT8AZHAzl/cSJPpFwc0s56hSVh4=
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
MIME-Version: 1.0
X-OriginatorOrg: dot.state.fl.us
X-MS-Exchange-CrossTenant-Network-Message-Id:
891d59b5-e680-490f-e77a-08d6d87c258a
X-MS-Exchange-CrossTenant-originalarrivaltime: 14 May 2019 14:55:03.6058
(UTC)
X-MS-Exchange-CrossTenant-fromentityheader: Hosted
X-MS-Exchange-CrossTenant-id: db21de5d-bc9c-420c-8f3f-8f08f85b5ada
X-MS-Exchange-CrossTenant-mailboxtype: HOSTED
X-MS-Exchange-Transport-CrossTenantHeadersStamped: BL0PR0901MB2481
