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