Unable to run subquery - cause: FROM in correlated subquery must have USE KEYS clause: FROM product

Hello,

How can I fix this error ?

Unable to run subquery - cause: FROM in correlated subquery must have USE KEYS clause: FROM product

SELECT 

p.name,
p.unitPrice

FROM product p

WHERE price > (
    SELECT avg(p.unitPrice) FROM product
)

You can’t fix this. This not supported version you using. You must use higher version.
Not sure what is meaning of query. In correlated subquery required secondary index.

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.