Re: Cannot get the data in Tableau

[austin solomon]

Hi Igor,

I have specified "Cache" connection argument while connecting to Ignite's
ODBC, also I can see the column names of the created schema. (Check my
previous post for screen shots)

I can't  able to preview or query the cache.

Below is my full xml configuration.

http://www.springframework.org/schema/beans;
   xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance;
   xmlns:util="http://www.springframework.org/schema/util;
   xsi:schemaLocation="
http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans.xsd
http://www.springframework.org/schema/util
http://www.springframework.org/schema/util/spring-util.xsd;>

























































































10.10.1.33:47500..47509









Thanks,



--
View this message in context: 
http://apache-ignite-users.70518.x6.nabble.com/Cannot-get-the-data-in-Tableau-tp6876p7104.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.

Re: Cannot get the data in Tableau

[Igor Sapego]

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 
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 <
> austin.solomon...@gmail.com> 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:
>>
>> 
>> 
>> 
>>
>> 
>> 
>> 
>> 
>> 
>> 
>> > value="FULL_SYNC"/>
>>
>> 
>> 
>> 
>> 
>> > value="java.lang.Long"/>
>> > value="Person"/>
>> 
>> 
>> > value="java.lang.Long"/>
>> 
>> 
>> 
>> 
>> 
>> > value="java.lang.String"/>
>> > value="java.lang.String"/>
>> > value="java.lang.String"/>
>> > value="java.lang.Integer"/>
>> 
>> 
>> 
>> 
>> 
>> 
>>
>> 
>> 
>> 
>> 
>> > value="FULL_SYNC"/>
>>
>> 
>> 
>> 
>> 
>> > value="java.lang.Long"/>
>> > value="Organization"/>
>> 
>> 
>> > value="java.lang.String"/>
>> 
>> 
>> 
>> 
>> 
>> 
>> 
>> 
>>
>> 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
>>
>
>

Re: Cannot get the data in Tableau

[Vladimir Ozerov]

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 
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:
>
> 
> 
> 
>
> 
> 
> 
> 
> 
> 
>  value="FULL_SYNC"/>
>
> 
> 
> 
> 
>  value="java.lang.Long"/>
> 
> 
> 
>  value="java.lang.Long"/>
> 
> 
> 
> 
> 
>  value="java.lang.String"/>
>  value="java.lang.String"/>
>  value="java.lang.String"/>
>  value="java.lang.Integer"/>
> 
> 
> 
> 
> 
> 
>
> 
> 
> 
> 
>  value="FULL_SYNC"/>
>
> 
> 
> 
> 
>  value="java.lang.Long"/>
>  value="Organization"/>
> 
> 
>  value="java.lang.String"/>
> 
> 
> 
> 
> 
> 
> 
> 
>
> 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
>