hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dmitry Tolpeko <>
Subject Re: hplsql tool not supporting NON EQUI JOIN
Date Thu, 19 Jan 2017 19:15:45 GMT

Can you please post the statement?


On Thu, Jan 19, 2017 at 7:38 PM, <> wrote:

> Hi there,
> This is Prabhu Sekar from Cognizant UK.
> We are working on an initiative where in we need to migrate 100+ complex
> stored procedures from SQL to Hive.
> While researching, we came across and found it to be very
> exciting tool and thought it would be of great help to us to migrate the
> procedures seamlessly.
> But when we attempt to execute procedures with non equi joins, it throws
> an error like "*FAILED: Error in semantic analysis: Both Left and Right
> Aliases **Encountered in..*"
> Could you please let us know if there is an alternate solution or a work
> around to sort out this issue without changing the existing procedure?
> Thanks,
> Prabhu
> This e-mail and any files transmitted with it are for the sole use of the
> intended recipient(s) and may contain confidential and privileged
> information. If you are not the intended recipient(s), please reply to the
> sender and destroy all copies of the original message. Any unauthorized
> review, use, disclosure, dissemination, forwarding, printing or copying of
> this email, and/or any action taken in reliance on the contents of this
> e-mail is strictly prohibited and may be unlawful. Where permitted by
> applicable law, this e-mail and other e-mail communications sent to and
> from Cognizant e-mail addresses may be monitored.

View raw message