Hive execution error

[Kartik Bhatia <KB...@scif.com>]

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

Re: Hive execution error

[Venki Korukanti <ve...@gmail.com>]

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