RE: SQL Error: Failed to query Ignite

[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=<bean id>

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:

<property name="cacheConfiguration">
    <list>
        <bean id="tokenCacheTemplate"
class="org.apache.ignite.configuration.CacheConfiguration">
            <property name=&quot;name&quot; value=&quot;tokenCache&lt;b>**"
/>
            <property name="cacheMode" value="PARTITIONED" />
            <property name="backups" value="1" />
            
            
        </bean>
    </list>
</property>

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/