hazelcast / hazelcast/hazelcast-code-samples

UPDATE sql statement

Open
#539 0 comments 0 reactions 0 assignees View on GitHub
Dominant language
Java
Stars
558
Forks
600
PR merge metrics
No merged PRs in 30d

Description

Hi,
Having trouble executing "UPDATE" sql statement in cluster:

Whenever try to use "UPDATE" sql statement combined with "EXISTS" condition like:

```
UPDATE table_A T1
SET name="A"
WHERE EXISTS (SELECT 1
FROM table_B T2
WHERE T1.id=T2.parent_id)
```

will get exception like:

```
There are not enough rules to produce a node with desired properties: convention=LOGICAL, sort=(],
DistributionTraitDef=ANY. All the inputs have relevant nodes, however the cost is still infinite.
```
Could anyone maybe give a hint about what's going wrong?

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.