drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Kartik Bhatia <KBha...@scif.com>
Subject RE: Hive execution error
Date Sat, 29 Aug 2015 06:27:54 GMT
In Drill Explorer, I can execute command show tables.
it generates list of all tables.

However select on table gives namespace 

-----Original Message-----
From: Abhishek Girish [mailto:agirish@mapr.com] 
Sent: Friday, August 28, 2015 9:05 PM
To: user@drill.apache.org
Subject: Re: Hive execution error

That should work! Coming back to the show tables on hive schema, can you try it on sqlline?

If you are able to list tables, and describe tables, I'd expect you should be able to query
tables.

On Friday, August 28, 2015, Kartik Bhatia <KBhatia@scif.com> wrote:

> I am trying to query hive in CHD 5.4.3 and then connect Drill to 
> reporting tool like MicroStrategy for visualization
>
> -----Original Message-----
> From: Abhishek Girish [mailto:abhishek.girish@gmail.com 
> <javascript:;>]
> Sent: Friday, August 28, 2015 8:48 PM
> To: user@drill.apache.org <javascript:;>
> Subject: Re: Hive execution error
>
> You can have multiple client connections to Drill. But each connection 
> would be a separate session. Specifically, in case of Drill UI each 
> query you submit would be a separate session. Any session options you 
> change in one session will not be visible in another. You also cannot 
> select a workspace / schema in one connection and expect it to be 
> selected in another.
>
> In sqlline, when you connect to Drill, you start a session and it will 
> remain active till the duration of the connection.
>
> Can you share details as to what you were trying to accomplish in this 
> regard?
>
> -Abhishek
>
> On Fri, Aug 28, 2015 at 8:36 PM, Kartik Bhatia <KBhatia@scif.com 
> <javascript:;>> wrote:
>
> > abhishek,
> > Yes I am using Drill Web UI.
> > I wanted to check if we could have both quries  from sqlline and UI 
> > at the same time.ie. both options active at same time.
> >
> > -----Original Message-----
> > From: Abhishek Girish [mailto:abhishek.girish@gmail.com 
> > <javascript:;>]
> > Sent: Friday, August 28, 2015 8:27 PM
> > To: user@drill.apache.org <javascript:;>
> > Subject: Re: Hive execution error
> >
> > 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
> <javascript:;>> 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 
> > > <javascript:;>
> ]
> > > Sent: Friday, August 28, 2015 8:02 PM
> > > To: user@drill.apache.org <javascript:;>
> > > 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
> <javascript:;>> 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
> <javascript:;>]
> > > > Sent: Friday, August 28, 2015 7:19 PM
> > > > To: user@drill.apache.org <javascript:;>
> > > > 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
> <javascript:;>>
> > 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.
> > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> > > > > ~~
> > > > > ~~
> > > > >
> > > >
> > >
> >
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
View raw message