RE: SQL Error: Failed to query Ignite
I deleted everything under $IGNITE_HOME/work and it's working as expected now. I probably messed up big with all my different configuration attempts :) Again, thank you so much for your help! ./t -Original Message- From: slava.koptilin [mailto:slava.kopti...@gmail.com] Sent: mandag 15. januar 2018 16.44 To: user@ignite.apache.org Subject: RE: SQL Error: Failed to query Ignite Hi, > Now my question is simply, why the star? What does it do? "*" means that it is a cache template :) > I now have two "identical" caches Hmm, I cannot reproduce that behavior. Please share your Ignite configuration. Thanks! -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/
RE: SQL Error: Failed to query Ignite
Hi, > Now my question is simply, why the star? What does it do? "*" means that it is a cache template :) > I now have two "identical" caches Hmm, I cannot reproduce that behavior. Please share your Ignite configuration. Thanks! -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/
RE: SQL Error: Failed to query Ignite
Another thing, I now have two "identical" caches, is this correct? I assumed I would just end up with SQL_PUBLIC_TOKEN +-+-+---+---+---+---+---+---+ | SQL_PUBLIC_TOKEN(@c2) | PARTITIONED | 2 | min: 0 (0 / 0) | min: 0| min: 0| min: 0| min: 0| | | | | avg: 0.00 (0.00 / 0.00) | avg: 0.00 | avg: 0.00 | avg: 0.00 | avg: 0.00 | | | | | max: 0 (0 / 0) | max: 0| max: 0| max: 0| max: 0| +-+-+---+---+---+---+---+---+ | tokenCache(@c3) | PARTITIONED | 2 | min: 0 (0 / 0) | min: 0| min: 0| min: 0| min: 0| | | | | avg: 0.50 (0.00 / 0.50) | avg: 0.00 | avg: 0.00 | avg: 0.00 | avg: 0.00 | | | | | max: 1 (0 / 1) | max: 0| max: 0| max: 0| max: 0| +---+ -Original Message- From: Thomas Isaksen [mailto:thomas.isak...@sysco.no] Sent: mandag 15. januar 2018 12.19 To: user@ignite.apache.org Subject: RE: SQL Error: Failed to query Ignite Yes! That did it! Now my question is simply, why the star? What does it do. I thought I had to use template= Thanks heaps! ./t -Original Message- From: slava.koptilin [mailto:slava.kopti...@gmail.com] Sent: mandag 15. januar 2018 11.55 To: user@ignite.apache.org Subject: Re: SQL Error: Failed to query Ignite Hi Thomas, Please try to configure your template in the following way: **" /> In that case, you should be able to create a table via thin driver: CREATE TABLE TOKEN(id LONG, token VARCHAR, PRIMARY KEY (id)) WITH template=tokenCache; Thanks, Slava. -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/
RE: SQL Error: Failed to query Ignite
Yes! That did it! Now my question is simply, why the star? What does it do. I thought I had to use template= Thanks heaps! ./t -Original Message- From: slava.koptilin [mailto:slava.kopti...@gmail.com] Sent: mandag 15. januar 2018 11.55 To: user@ignite.apache.org Subject: Re: SQL Error: Failed to query Ignite Hi Thomas, Please try to configure your template in the following way: **" /> In that case, you should be able to create a table via thin driver: CREATE TABLE TOKEN(id LONG, token VARCHAR, PRIMARY KEY (id)) WITH template=tokenCache; Thanks, Slava. -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/
Re: SQL Error: Failed to query Ignite
Hi Thomas, Please try to configure your template in the following way: **" /> In that case, you should be able to create a table via thin driver: CREATE TABLE TOKEN(id LONG, token VARCHAR, PRIMARY KEY (id)) WITH template=tokenCache; Thanks, Slava. -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/