If I run this query:
SELECT "t1"."id" FROM "session" AS t1 WHERE ("t1"."dirty" = TRUE) ORDER BY "t1"."id" LIMIT 1000;
I get the following error:
Error : ERROR: unsupported clause type
This query works perfectly on a local table. Why is Citus raising an error when I use it on a distributed table?
instead of:
"t1"."dirty" = TRUE
use:
"t1"."dirty" IS TRUE
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With