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. > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ >
