Re: With as syntax does not work in ignite 2.9.0?

2020-12-09 Thread Ilya Kasnacheev
Hello! I don't think we can help you further without looking at some SQL statements. You could probably try commercial support which you trust. What's the connection string for your driver? Does it point to a server node or client node? Regards, -- Ilya Kasnacheev вт, 8 дек. 2020 г. в 09:17,

Re: With as syntax does not work in ignite 2.9.0?

2020-12-07 Thread yangjiajun
Hello.Thanks for u reply. Sorry for that I can't post sqls beacuse they contain sensitive bussiness info.I'm also sorry that I can't make a reproducer now. Here is my code to execute query: ResultSet excuteQuery(Connection conn, String sql) throws SQLException { Statement stmt = conn.crea

Re: With as syntax does not work in ignite 2.9.0?

2020-12-07 Thread Ilya Kasnacheev
Hello! Do you happen to run this query on client or server node? Try running it on a server node for a chance. Clients initialize cached lazily and yield a crop of NPEs. Regards, -- Ilya Kasnacheev пн, 7 дек. 2020 г. в 05:40, yangjiajun <1371549...@qq.com>: > Hello. > > We use 'with xxx as (

Re: With as syntax does not work in ignite 2.9.0?

2020-12-07 Thread Pavel Vinokurov
Hi, Could you show the query and the code block with the query execution because query "with p as (select * from person) select * from p" works well on 2.9.0. I suspect that the issue could be related to creating jdbc resources. Could you also show the configuration for the hikari jdbc pool. Than

RE: With as syntax does not work in ignite 2.9.0?

2020-12-07 Thread Alexandr Shapkin
Hi, I’ve filed a JIRA ticket https://issues.apache.org/jira/browse/IGNITE-13822 to track this issue.Full logs or a simple reproducer would help to debug this more quickly, feel free to share them as well. From: yangjiajunSent: Monday, December 7, 2020 5:40 AMTo: user@ignite.apache.orgSubject: With