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:[email protected]] Sent: Friday, August 28, 2015 8:48 PM To: [email protected] 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 <[email protected]> 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:[email protected]] > Sent: Friday, August 28, 2015 8:27 PM > To: [email protected] > 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 <[email protected]> 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:[email protected]] > > Sent: Friday, August 28, 2015 8:02 PM > > To: [email protected] > > 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 <[email protected]> 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:[email protected]] > > > Sent: Friday, August 28, 2015 7:19 PM > > > To: [email protected] > > > 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 <[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. > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > > > > ~~ > > > > > > > > > >
