Can you try these in sequence: - use hive; - show tables;
On Fri, Aug 28, 2015 at 7:55 PM, Kartik Bhatia <[email protected]> wrote: > show databases - gives me list of databases. > show hive.data - gives message Default schema changed to [hive.data] > show tables - org.apache.drill.common.exceptions.UserRemoteException: > VALIDATION ERROR: No default schema selected. Select a schema using 'USE > schema' command > > > -----Original Message----- > From: Abhishek Girish [mailto:[email protected]] > Sent: Friday, August 28, 2015 7:19 PM > To: [email protected] > Subject: Re: Hive execution error > > Can you successfully do a "use hive" followed by "show tables"? > > I mean to check if your hive configuration is successful. Please refer to > https://drill.apache.org/docs/hive-storage-plugin/ for details on > configuring Hive plug-in. > > From the error it looks like "nameservice1" is not being resolved. Try > using IP address of the hive server instead (in hive config file &/or > plug-in). > > -Abhishek > > On Fri, Aug 28, 2015 at 4:46 PM, Kartik Bhatia <[email protected]> wrote: > > > Hi, > > I can see the tables in hive. > > When I select table and run the query, it gives an error below. > > > > ERROR [HY000] [MapR][Drill] (1040) Drill failed to execute the query: > > SELECT * FROM `hive`.`data`.`adjuste _collection` LIMIT 100 > > [30027]Query execution error. Details:[ SYSTEM ERROR: > > UnknownHostException: nameservice1 > > > > > > [Error Id: 46e465d5-3bfe-42d0-8fc8-2fd0c954dc10 on > > vllxb234.scirx.com:31010] ] > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > > This e-mail message from State Compensation Insurance Fund and all > > attachments transmitted with it may be privileged or confidential and > > protected from disclosure. If you are not the intended recipient, you > > are hereby notified that any dissemination, distribution, copying, or > > taking any action based on it is strictly prohibited and may have > > legal consequences. If you have received this e-mail in error, please > > notify the sender by reply e-mail and destroy the original message and > > all copies. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > > >
