Hi, Austin, Most probably, you have not specified "Cache" connection argument while trying to connect with Tableu to your cluster.
In your case you should specify either "Cache=Person" or "Cache=Organization " so that ODBC driver would know upon which cache to run queries. Hope, it helps. Best Regards, Igor On Fri, Aug 12, 2016 at 10:37 AM, Vladimir Ozerov <[email protected]> wrote: > Hi Austin, > > Most probably Igor Sapego will be able to assist you. As far as I know he > is unavailable during this week, but I hope he will be able to answer you > in the beginning of the next week. > > Vladimir. > > On Tue, Aug 9, 2016 at 2:34 PM, austin solomon < > [email protected]> wrote: > >> Hi, >> >> I am using Apache ignite 1.7.0-SNAPSHOT version. >> >> My ignite cluster is running in CentOS server and I'm trying to connect >> to it through ODBC driver from Windows PC. >> >> My confguration is like below: >> >> <property name="odbcConfiguration"> >> <bean class="org.apache.ignite.confi >> guration.OdbcConfiguration"></bean> >> </property> >> >> <property name="cacheConfiguration"> >> <list> >> <bean class="org.apache.ignite.confi >> guration.CacheConfiguration"> >> <property name="name" value="Person"/> >> <property name="cacheMode" value="PARTITIONED"/> >> <property name="atomicityMode" value="TRANSACTIONAL"/> >> <property name="writeSynchronizationMode" >> value="FULL_SYNC"/> >> >> <!-- Configure type metadata to enable queries. --> >> <property name="typeMetadata"> >> <list> >> <bean class="org.apache.ignite.cache >> .CacheTypeMetadata"> >> <property name="keyType" >> value="java.lang.Long"/> >> <property name="valueType" >> value="Person"/> >> <property name="ascendingFields"> >> <map> >> <entry key="orgId" >> value="java.lang.Long"/> >> </map> >> </property> >> <property name="queryFields"> >> <map> >> <entry key="id" value="java.lang.Integer"/> >> <entry key="firstName" >> value="java.lang.String"/> >> <entry key="lastName" >> value="java.lang.String"/> >> <entry key="resume" >> value="java.lang.String"/> >> <entry key="salary" >> value="java.lang.Integer"/> >> </map> >> </property> >> </bean> >> </list> >> </property> >> </bean> >> >> <bean class="org.apache.ignite.confi >> guration.CacheConfiguration"> >> <property name="name" value="Organization"/> >> <property name="cacheMode" value="PARTITIONED"/> >> <property name="atomicityMode" value="TRANSACTIONAL"/> >> <property name="writeSynchronizationMode" >> value="FULL_SYNC"/> >> >> <!-- Configure type metadata to enable queries. --> >> <property name="typeMetadata"> >> <list> >> <bean class="org.apache.ignite.cache >> .CacheTypeMetadata"> >> <property name="keyType" >> value="java.lang.Long"/> >> <property name="valueType" >> value="Organization"/> >> <property name="ascendingFields"> >> <map> >> <entry key="name" >> value="java.lang.String"/> >> </map> >> </property> >> </bean> >> </list> >> </property> >> </bean> >> </list> >> </property> >> >> My problem here is, I could not able to get the data present in cache >> that i have created, In Tableau i can see only the columns. >> >> When i checked the cache using ignitevisorcmd.sh i got the following >> output: >> Time of the snapshot: 08/09/16, 16:52:46 >> +=========================================================== >> ==========================================================+ >> | Name(@) | Mode | Nodes | Entries (Heap / Off heap) | >> Hits | Misses | Reads | Writes | >> +=========================================================== >> ==========================================================+ >> | Organization(@c0) | PARTITIONED | 1 | min: 2 (2 / 0) | >> min: 0 | min: 0 | min: 0 | min: 0 | >> | | | | avg: 2.00 (2.00 / 0.00) | >> avg: 0.00 | avg: 0.00 | avg: 0.00 | avg: 0.00 | >> | | | | max: 2 (2 / 0) | >> max: 0 | max: 0 | max: 0 | max: 0 | >> +-------------------+-------------+-------+----------------- >> ----------+-----------+-----------+-----------+-----------+ >> | Person(@c1) | PARTITIONED | 1 | min: 5 (5 / 0) | >> min: 0 | min: 0 | min: 0 | min: 0 | >> | | | | avg: 5.00 (5.00 / 0.00) | >> avg: 0.00 | avg: 0.00 | avg: 0.00 | avg: 0.00 | >> | | | | max: 5 (5 / 0) | >> max: 0 | max: 0 | max: 0 | max: 0 | >> +----------------------------------------------------------- >> ----------------------------------------------------------+ >> >> I have attached the screen shot. >> >> Can you please help me what I am missing here. >> >> Thanks >> Austin >> > >
