RE: SQL Error: Failed to query Ignite

2018-01-15 Thread Thomas Isaksen
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

2018-01-15 Thread slava.koptilin
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

2018-01-15 Thread Thomas Isaksen
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

2018-01-15 Thread Thomas Isaksen
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

2018-01-15 Thread slava.koptilin
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/