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.configuration.
> OdbcConfiguration"></bean>
>         </property>
>
>         <property name="cacheConfiguration">
>             <list>
>                 <bean class="org.apache.ignite.configuration.
> 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.configuration.
> 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
>

Reply via email to