Hi,
Your configuration perfectly works on my side.
Make sure that you are connecting to the server node with an appropriate
configuration of indexes.
I'm afraid, that without a complete reproducer it's not possible to figure
out the reason.
Kind regards,
Alex
--
Sent from: http://apache-ignit
The code is here:
String sql = "explain SELECT FID,FNUMBER FROM
\"customerCache\".CustomerIgniteInfo WHERE FUSEDSTATUS = 3)";
Class.forName("org.apache.ignite.IgniteJdbcThinDriver"); Connection conn =
DriverManager.getConnection("jdbc:ignite:thin://192.168.63.36?distributedJoins=true");
Pre
Hi,
Actually, the same exact code I sent you works as expected on my side.
Could you share a reproducer so that I can take a look at it?
At least, please Ignite configuration and how you run explain query via thin
JDBC driver.
Kind regards,
Alex
--
Sent from: http://apache-ignite-users.70518.
afedotov,
As you say ,you removed JPA related annotations.
How to removed?
I try as your suggestion, I found if I build a new entity class and use
cache.query() ,it will take the index, but still not take the index with JDBC
thin mode.
What did I miss?
Thanks.
well,
I use jdbc thin mode.
It's ok with cache.query();
But It did not work with JDBC thin mode.
Thanks.
Hi,
Just to clarify, the same result I have while running using the thin JDBC
driver.
Class.forName("org.apache.ignite.IgniteJdbcThinDriver");
try (
Connection conn =
DriverManager.getConnection("jdbc:ignite:thin://localhost:10800");
PreparedStatement pre
Hi,
Not sure, what's wrong with your code.
Either IX_T_BD_StatusFid or IX_T_BD_CUSTOMER should have been taken.
I removed JPA related annotations and checked your code, it gave me the
following plan:
[[SELECT
__Z0.FID AS __C0_0,
__Z0.FNUMBER AS __C0_1
FROM "customerCache".CUSTOMERIGNITEIN
Hi,
I got a strange thing.
I execute a query with JDBC thin mode.
But the performance and explain is very strange.
The SQL is :
SELECT FID,FNUMBER FROM "customerCache".CustomerIgniteInfo WHERE
FUSEDSTATUS = 3
and explain is:
SELECT
__Z0.FID AS __C0_0,
__Z0.F