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

SQL++
1

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
)
2

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.

3

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