It looks like you have HA configuration on HDFS cluster. HA related parameters are not available to the Hive storage plugin. Try passing the HA related parameters (such as dfs.nameservices, dfs.ha.namenodes.nameservice1 etc) from core-site.xml to Hive storage plugin config section. More on this here <https://groups.google.com/a/cloudera.org/forum/#!topic/cdh-user/cax7rH3cYms> .
Let us know if that works or not. 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. > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ >
