topic Re: Is QlikView connection is compatible with Hadoop Big Data(Amazon RedShift) in QlikView

Is QlikView connection is compatible with Hadoop Big Data(Amazon RedShift)

Karim_Khan — Tue, 22 Dec 2015 12:45:15 GMT

Hi QlikViewers,

Hope you all are doing well I don't know whether i am asking the right(silly) question.Because I have try each and every attempt to make the successful connection between our best QlikView tool and Amazon red Shift Big Data.Connection is done successfully data is also getting fetched/pull from database.Even I have checked the logs also all is working well except connection is not getting terminated neither through Exit Script() command nor through Disconnect() command QVD is also getting created..

Now I have one doubt is our qlikview is compatible to make the connection and termination of connection with Hadoop Big Data(Amazon RedShift).I am using QlikView Developer version.I have already had many discussion with our qlikview experts and community members.So I need one last not least conclusion of all QlikViewers.So I can communicate the same to my client for any alternate solution.

Thanks in Advance

Regards,

swuehl‌rbecher‌jagan‌Neetu_Singh‌MRKachhiaIMP‌Avinashelite‌sunindia‌hic‌JohnW‌vikasmahajan‌

Resource Library‌New to QlikView‌QlikView Support‌Blogs‌QlikView‌Community Information‌App Development‌

Re: Is QlikView connection is compatible with Hadoop Big Data(Amazon RedShift)

avinashelite — Tue, 22 Dec 2015 12:50:29 GMT

Hi Karim,

1.how many tables do you have in your model?

2.Your facing this issue both in server and desktop? if its in server only !! they issue might be in the server end try to restart the sever

3.Which connector your using

Re: Is QlikView connection is compatible with Hadoop Big Data(Amazon RedShift)

Karim_Khan — Tue, 22 Dec 2015 12:54:47 GMT

Hi Avinash,

1.Currently only one table i am using in my data model.

2.I am facing issue in Desktop version.

3.I am using JDBC connector 64 bit 30 days trial version.

Regards,

Karim Khan

Re: Is QlikView connection is compatible with Hadoop Big Data(Amazon RedShift)

Peter_Cammaert — Tue, 22 Dec 2015 12:58:43 GMT

Why do you think the connection is not being terminated? Can you see active connections to Amazon after you have run the load script or terminated QV Desktop? You can use the netstat Windows command to check those.

In general, network connections are closed as soon as the process that created them terminates.

Best,

Peter

Re: Is QlikView connection is compatible with Hadoop Big Data(Amazon RedShift)

Karim_Khan — Tue, 22 Dec 2015 13:07:51 GMT

Because if i am trying to close it by clicking on Close button or cancel it getting in hung mode.I have to close the QV.exe forcefully through Task Manger.

Even in Log Files its not showing execution terminated as general in different Dashboards.

Regards,

Re: Is QlikView connection is compatible with Hadoop Big Data(Amazon RedShift)

Peter_Cammaert — Tue, 22 Dec 2015 13:18:19 GMT

So it's not necessarily a problem of the connectiion not getting terminated, your QV Desktop simply hangs somewhere at the end or remains busy doing something...

What happens if you replace the DISCONNECT; statement with:

DROP Table KK_PRODUCT;

Re: Is QlikView connection is compatible with Hadoop Big Data(Amazon RedShift)

Peter_Cammaert — Tue, 22 Dec 2015 13:21:14 GMT

Also remove the DIRECTORY: leftover immediately after the SET statements. It's a table label allright but currently in the wrong place...

Re: Is QlikView connection is compatible with Hadoop Big Data(Amazon RedShift)

Karim_Khan — Tue, 22 Dec 2015 13:24:27 GMT

Yes I have tried that also.But all in vain

Re: Is QlikView connection is compatible with Hadoop Big Data(Amazon RedShift)

Karim_Khan — Tue, 22 Dec 2015 13:40:24 GMT

Above code is also not working

Re: Is QlikView connection is compatible with Hadoop Big Data(Amazon RedShift)

rbecher — Tue, 22 Dec 2015 15:03:05 GMT

The main problem with your statement is FIRST!

It will load ALL data from Redshift and then filter it to the very first 10 rows on the client (Qlikview Desktop) site!

To limit / filter the data set you need to specify a WHERE CLAUSE instead..

Re: Is QlikView connection is compatible with Hadoop Big Data(Amazon RedShift)

rbecher — Tue, 22 Dec 2015 15:06:17 GMT

So, it's clear then why it might look like nothing happens after 10 rows are retrieved:

it's still loading all data until the end of table is reached.

Re: Is QlikView connection is compatible with Hadoop Big Data(Amazon RedShift)

swuehl — Tue, 22 Dec 2015 15:10:05 GMT

That's a good point, but would this explain that the QVD gets written?

I also noticed a

SET ErrorMode=0;

statement in the script, so it might be good to set error mode back to 1 and check for any errors popping up.

Re: Is QlikView connection is compatible with Hadoop Big Data(Amazon RedShift)

Karim_Khan — Tue, 22 Dec 2015 15:20:16 GMT

But Ralf I can achieve the same through debugger also na?

Re: Is QlikView connection is compatible with Hadoop Big Data(Amazon RedShift)

rbecher — Tue, 22 Dec 2015 15:27:37 GMT

I already offered you help directy, don't know what else to say here..

Re: Is QlikView connection is compatible with Hadoop Big Data(Amazon RedShift)

Karim_Khan — Tue, 22 Dec 2015 15:40:41 GMT

K I got the point and thanks again for helping me

Re: Is QlikView connection is compatible with Hadoop Big Data(Amazon RedShift)

Karim_Khan — Tue, 22 Dec 2015 15:46:54 GMT

Finally got the answer.

Re: Is QlikView connection is compatible with Hadoop Big Data(Amazon RedShift)

Peter_Cammaert — Tue, 22 Dec 2015 23:45:24 GMT

Experienced members are golden. Noone beats them.

Re: Is QlikView connection is compatible with Hadoop Big Data(Amazon RedShift)

Karim_Khan — Wed, 23 Dec 2015 09:10:22 GMT

You are right OLD is GOLD