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