Re: Read SQL table via cache api

Hi Andrei, I got this to work by setting the server and client time zones to be the same. So what happened was that I had created the table and inserted the record using Sqlline.sh on the server host. That must have stored the effective_date field in the key based on the server's time zone (UTC).

Re: Read SQL table via cache api

Hi Andrei, I captured below logs with the -DIGNITE_QUIET=false flag. There is a 5-hour difference between the two time zones. Server Log ignite-ef771a6b.log Client Log ignite-86fd5276.log

Re: Read SQL table via cache api

Hi, Could you please set -DIGNITE_QUIET=false to turn off the quiet mode and re-attach the logs? BR, Andrei -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Read SQL table via cache api

Another observation is that if I take out the effective_date field (Timestamp) from the key, and use only the Int and Double columns as the primary keys, the server finds it without any problem. -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Read SQL table via cache api

Hi Andrei, Thank you for your reply. Here is the server log. However, I do not see any relevant information in it. The cache get request was made from the client between line 117 (client joins the topology) and 127 (client leaves the topology). ignite-db357bff.log

Re: Read SQL table via cache api

Hi, I don't think that it's possible to understand a reason without logs. Please attach them here or possible if you can reproduce it then you may file a Jira issue and attach logs there with a full description of the problem. BR, Andrei -- Sent from: http://apache-ignite-users.70518.x6.nabble

Re: Read SQL table via cache api

Hi Andrei, I have figured this out after several hours of troubleshooting today. I had the Ignite server process, which hosted the table/cache, running on a Linux host (CentOS7). On the other hand, I was running the client code on a Macbook. It seems that the two platform was deserializing the ke

Re: Read SQL table via cache api

Hi, I think that information about it could be located in node log. Could you please provide the log of the node where you tries to read the data? BR, Andrei -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Read SQL table via cache api

I ran below SQL from Ignite Sqlline which creates a table and inserts one entry. I am trying to query that entry using cache api. However, the value always returns null. ## SQL CREATE TABLE SIMPLE_TABLE ( ACCOUNT_ID INT, SECURITY_ALIAS INT, POSITION_TYPE VA