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. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > > >
