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 03:02:08 GMT
Can you try these in sequence:

- use hive;
- show tables;

On Fri, Aug 28, 2015 at 7:55 PM, Kartik Bhatia <KBhatia@scif.com> 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:abhishek.girish@gmail.com]
> Sent: Friday, August 28, 2015 7:19 PM
> To: user@drill.apache.org
> 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 <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