Example sql execution syntax in TransformFunction
Could someone point me on an example of a transform function (R or Java is fine) which includes SQL against tables from the calling SQL please ... I can see various examples with errors but nothing which is valid plus I don't see how the tables in originating SQL select are referred to.
Eg for a query SELECT udft_function FROM table a INNER JOIN b on a.key = b.foreign_key what does the code in udft_function see ?
can it execute a query like SELECT a.col1, b.col1 FROM table a INNER JOIN b on a.key = b.foreign_key ?