Hi Ahmad, Does the "show tables" command work for you from Hive shell ? Can you please share you Hive version that is being used ?
And share the content from your Hive storage plugin, which is available on the storage tab on Drill web UI. Thanks, Khurram On Tue, May 14, 2019 at 10:07 AM Ahmad, Sami <sami.ah...@dot.state.fl.us> wrote: > 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: user-h...@drill.apache.org [mailto:user-h...@drill.apache.org] > Sent: Tuesday, May 14, 2019 10:55 AM > To: Ahmad, Sami <sami.ah...@dot.state.fl.us> > Subject: WELCOME to user@drill.apache.org > > EXTERNAL SENDER: Use caution with links and attachments. > > > Hi! This is the ezmlm program. I'm managing the user@drill.apache.org > mailing list. > > I'm working for my owner, who can be reached at > user-ow...@drill.apache.org. > > Acknowledgment: I have added the address > > sami.ah...@dot.state.fl.us > > to the user mailing list. > > Welcome to user@drill.apache.org! > > 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: > <user-subscr...@drill.apache.org> > > To remove your address from the list, send a message to: > <user-unsubscr...@drill.apache.org> > > Send mail to the following for info and FAQ for this list: > <user-i...@drill.apache.org> > <user-...@drill.apache.org> > > Similar addresses exist for the digest list: > <user-digest-subscr...@drill.apache.org> > <user-digest-unsubscr...@drill.apache.org> > > To get messages 123 through 145 (a maximum of 100 per request), mail: > <user-get.123_...@drill.apache.org> > > To get an index with subject and author for messages 123-456 , mail: > <user-index.123_...@drill.apache.org> > > 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: > <user-thread.12...@drill.apache.org> > > 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 > "john@host.domain", just add a hyphen and your address (with '=' instead > of '@') after the command word: > <user-subscribe-john=host.dom...@drill.apache.org> > > To stop subscription for this address, mail: > <user-unsubscribe-john=host.dom...@drill.apache.org> > > 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 user-ow...@drill.apache.org. Please > be patient, my owner is a lot slower than I am ;-) > > --- Enclosed is a copy of the request I received. > > Return-Path: <sami.ah...@dot.state.fl.us> > 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" <sami.ah...@dot.state.fl.us> > 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 user@drill.apache.org > Thread-Topic: confirm subscribe to user@drill.apache.org > Thread-Index: AQHVCmSDlyDdP1lRT0SYTvGULj1vtqZqtS8Q > Date: Tue, 14 May 2019 14:55:03 +0000 > Message-ID: > < > bl0pr0901mb3154e9e2d60af474e6fa961689...@bl0pr0901mb3154.namprd09.prod.outlook.com > > > References: <1557845487.3588.ez...@drill.apache.org> > In-Reply-To: <1557845487.3588.ez...@drill.apache.org> > Accept-Language: en-US > Content-Language: en-US > X-MS-Has-Attach: > X-MS-TNEF-Correlator: > authentication-results: spf=none (sender IP is ) smtp.mailfrom= > sami.ah...@dot.state.fl.us; > 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 > >