Re: hplsql tool not supporting NON EQUI JOIN

[Dmitry Tolpeko <dm...@gmail.com>]

Prabhu,

Can you please post the statement?

Dmitry

On Thu, Jan 19, 2017 at 7:38 PM, <Pr...@cognizant.com> 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 hplsql.org 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.
>