Cannot access more than one hive prompt

[jaydeep vishwakarma <ja...@mkhoj.com>]

Hi,

I am trying to access two hive prompt from same machine. Only first one
is working. But other one hive prompt showing
following error when doing simple select query.

FAILED: Error in semantic analysis: Unable to fetch table employee

How to access more than one hive prompt in same system.

Regards,
Jaydeep

The information contained in this communication is intended solely for the use of the individual or entity to whom it is addressed and others authorized to receive it. It may contain confidential or legally privileged information. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. If you have received this communication in error, please notify us immediately by responding to this email and then delete it from your system. The firm is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt.

Re: Cannot access more than one hive prompt

[Edward Capriolo <ed...@gmail.com>]

On Wed, Jun 9, 2010 at 3:42 PM, jaydeep vishwakarma <
jaydeep.vishwakarma@mkhoj.com> wrote:

> Hi,
>
> I am trying to access two hive prompt from same machine. Only first one
> is working. But other one hive prompt showing
> following error when doing simple select query.
>
> FAILED: Error in semantic analysis: Unable to fetch table employee
>
> How to access more than one hive prompt in same system.
>
> Regards,
> Jaydeep
>
> The information contained in this communication is intended solely for the
> use of the individual or entity to whom it is addressed and others
> authorized to receive it. It may contain confidential or legally privileged
> information. If you are not the intended recipient you are hereby notified
> that any disclosure, copying, distribution or taking any action in reliance
> on the contents of this information is strictly prohibited and may be
> unlawful. If you have received this communication in error, please notify us
> immediately by responding to this email and then delete it from your system.
> The firm is neither liable for the proper and complete transmission of the
> information contained in this communication nor for any delay in its
> receipt.
>

I remember once asking the same question :)

http://wiki.apache.org/hadoop/HiveDerbyServerMode