Hi All, I am trying to convert a Simple RelNode to SQL Text with Hive as Dialect using RelToSqlConverter.
Problem is if the Order By Key is a Projection which was Aliased, the Output query contains the original column name instead of the Alias, which is not allowed in Hive as valid Order By keys are projections only. For Instance, Select first_name as n1 from emp order by first_name; (Failing in hive!) Expected SQL, Select first_name as n1 from emp order by n1; I create the TableScan, Projection(with the alias) & Sort in the mentioned order. Any leads would be greatly appreciated. Thanks & Regards, Krishnakant
