I am using python to implement functions like CDIST and PIVOT table. But i have to use same thing using HANA Table functions. The data is in HANA itself. CDIST is used for calculating distance between two coordinates, i have latitude and longitude data.
For Pivot table, i have pivot columns and values available in another table. How to create a new pivot table in HANA table functions.
Please help.