Prabhu, Can you please post the statement?
Dmitry On Thu, Jan 19, 2017 at 7:38 PM, <prabhu.sek...@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. >