drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Abhishek Girish <abhishek.gir...@gmail.com>
Subject Re: Hive execution error
Date Sat, 29 Aug 2015 02:18:38 GMT
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 <KBhatia@scif.com> 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.
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message