WITH input as (
select array(1.0, 2.0, 3.0, 4.0) as x, array(1, 2) as y
UNION ALL
select array(2.0, 3.0, 4.0, 5.0) as x, array(1, 2) as y
)
select
transpose_and_dot(x, y) as xy,
transpose_and_dot(y, x) as yx
from
input;
[[“3.0″,”6.0”],[“5.0″,”10.0”],[“7.0″,”14.0”],[“9.0″,”18.0”]] [[“3.0″,”5.0″,”7.0″,”9.0”],[“6.0″,”10.0″,”14.0″,”18.0”]]
WhereOS is a data innovation platform and service.
For teams and businesses who want to get more value out of data – WhereOS minimizes your effort and maximizes your results.
If you wish discuss with us, please contact us through support@eaglepeaks.com or call us +358 50 486 9257.
© WhereOS 2021 All rights reserved
