如何在Ignite缓存中使用SQL UNION

import org.apache.ignite.Ignite;
import org.apache.ignite.IgniteCache;
import org.apache.ignite.Ignition;

public class IgniteUnionExample {
    public static void main(String[] args) {
        try (Ignite ignite = Ignition.start()) {
            // 获取缓存实例
            IgniteCache<Long, String> cache1 = ignite.getOrCreateCache("table1");
            IgniteCache<Long, String> cache2 = ignite.getOrCreateCache("table2");

            // 插入示例数据
            cache1.put(1L, "Alice");
            cache1.put(2L, "Bob");
            cache2.put(3L, "Charlie");
            cache2.put(4L, "David");

            // 使用SQL UNION查询
            String sql = "SELECT id, name FROM table1 UNION SELECT id, name FROM table2";
            List<List<?>> result = ignite.cache("table1").query(new SqlFieldsQuery(sql)).getAll();

            // 打印结果
            for (List<?> row : result) {
                System.out.println("ID: " + row.get(0) + ", Name: " + row.get(1));
            }
        }
    }
}