SAP HANA交叉应用替代品 [英] SAP HANA alternative for cross apply

问题描述

HANA sql中是否有MsSql中可用的交叉应用"运算符的替代方法? 还是有一种方法可以将函数应用于表中的值?像

Is there an alternative in HANA sql for the "cross apply" operator as available in MsSql? Or is there a way to apply a function for values in a table? Something like

select T.*, F.* from T cross join someFunction(T.Value) F

推荐答案

您可以在SAP HANA中使用交叉联接，这不是问题. 但是，如果要将函数应用于T.VALUE的所有条目，则查询需要如下所示:

You can use the cross join in SAP HANA, that's not a problem. However, if you want to apply a function to all entries of T.VALUE then the query needs to look like this:

select T.*, someFunction(T.Value)
from T cross join F

这篇关于SAP HANA交叉应用替代品的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！