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:26:56 GMT
I'm not sure why "show tables" is throwing an error, even after you
selected a schema. I'm guessing you are using the drill web UI to run
queries. Can you confirm? Session information isn't stored as of now, when
you issue queries from the UI. Can you try connecting using sqlline?



On Fri, Aug 28, 2015 at 8:06 PM, Kartik Bhatia <KBhatia@scif.com> wrote:

> here is the output.
>
> - use hive; -->    Default schema changed to [hive]
>
> - show tables;  -->
>  org.apache.drill.common.exceptions.UserRemoteException: VALIDATION ERROR:
> No default schema selected. Select a schema using 'USE schema' command
>
> DESCRIBE  `hive`.`data`.role_dim  -->    gives me list of all colimns in
> the table
>
> -----Original Message-----
> From: Abhishek Girish [mailto:abhishek.girish@gmail.com]
> Sent: Friday, August 28, 2015 8:02 PM
> To: user@drill.apache.org
> Subject: Re: Hive execution error
>
> Can you try these in sequence:
>
> - use hive;  Default schema changed to [hive]
> - show tables;  org.apache.drill.common.exceptions.UserRemoteException:
> VALIDATION ERROR: No default schema selected. Select a schema using 'USE
> schema' command
> DESCRIBE `hive`.`data`.role_dim  - gives me list of all colimns in the
> table
>
> 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