topic Re: QV - Hadoop Connectivity in QlikView

QV - Hadoop Connectivity

Thu, 19 Jun 2014 06:53:20 GMT

Hi all,

Please help me in connecting to Hadoop from Qlikview.

Regards,

Keerthi

Re: QV - Hadoop Connectivity

ashfaq_haseeb — Thu, 19 Jun 2014 07:13:19 GMT

Look at the below post from RALF.

http://community.qlik.com/docs/DOC-2457

Hope it helped.

Regards

ASHFAQ

Re: QV - Hadoop Connectivity

Thu, 19 Jun 2014 07:16:57 GMT

Hi Ashfaq,

JDBC connector is a demo version ryt?

Do you know how to achieve with Cloudera ODBC.

Reragds,

Keerthi

Re: QV - Hadoop Connectivity

ashfaq_haseeb — Thu, 19 Jun 2014 07:18:33 GMT

Hi,

I didn't try before.

Regards

ASHFAQ

Re: QV - Hadoop Connectivity

its_anandrjs — Thu, 19 Jun 2014 07:20:12 GMT

There are many post related to this you can see one of them

Re: HDInsight Hive Qlikview

How to connect Hadoop Hive

Connecting to Hadoop Hive from QlikView

Re: QV - Hadoop Connectivity

Thu, 19 Jun 2014 07:21:36 GMT

Ok. But somewhere i saw cloudera connectors can be used to achieve connection.

Regards,

Keerthi

Re: QV - Hadoop Connectivity

its_anandrjs — Thu, 19 Jun 2014 07:24:14 GMT

Hi Keerthi,

You can read the below mention post and may be you get some answer there which is related to Cloudera ODBC.

Re: Re: source data

Re: QV - Hadoop Connectivity

Thu, 19 Jun 2014 07:28:46 GMT

Thanks anand. I will read and get back to you if i find any difficulties,

Regards,

Keerthi

Re: QV - Hadoop Connectivity

Fri, 20 Jun 2014 05:18:27 GMT

HI Anand,

I installed HIve ODBC drivers for Hadoop. But i am getting error when i try to connect it. Please let me know if i have done any mistake.

I have installed only Cloudera ODBC Driver for Apache Hive. Is there any other drivers to be installed. Please help me with this

Thanks,

Keerthi

Re: QV - Hadoop Connectivity

Fri, 20 Jun 2014 09:40:54 GMT

HI All,

I installed Cloudera ODBC driver for Impala 2.5.

I am able to connect to Hiveserver.

Regards,

Keerthi

Re: QV - Hadoop Connectivity

Mon, 23 Jun 2014 06:14:26 GMT

HI keerthi,

I also installed Cloudera ODBC for impala. Still I am getting the issue.

Thanks,

Sahithya

Re: QV - Hadoop Connectivity

Mon, 23 Jun 2014 06:22:44 GMT

HI Sahithya,

I installed Cloudera driver for Apache Hive.

Cofiguration image can be seen below

http://www.cloudera.com/content/cloudera-content/cloudera-docs/Connectors/PDF/Cloudera-ODBC-Driver-for-Apache-Hive-Insta…

Regards,

Keerthi

Re: QV - Hadoop Connectivity

Mon, 23 Jun 2014 06:41:05 GMT

Its working when i changed Port to 21050 for IMPALA and also for APACHE HIVE

Change port to 21050 and HIVESERVER2 should be running.

Re: QV - Hadoop Connectivity

Mon, 23 Jun 2014 06:47:29 GMT

Hi,

While creating User DSN, what will be the delegation UID.

Thanks,

Sahithya

Re: QV - Hadoop Connectivity

Mon, 23 Jun 2014 06:49:29 GMT

I have not given any UID. Try connecting without UID.

Regards,

Keerthi

Re: QV - Hadoop Connectivity

Mon, 23 Jun 2014 06:55:05 GMT

To connect to hadoop, we can install either clouderaHiveODBC or CloderaImpalaODBC.

Re: QV - Hadoop Connectivity

Mon, 23 Jun 2014 06:56:52 GMT

Yes we can install anyone of it. I tried with both its working fine.

Regards,

Keerthi

Re: QV - Hadoop Connectivity

saradhi_it — Mon, 26 Oct 2015 11:11:19 GMT

i downloaded this ODBC Connector to connect hadoop hive is it useful for us ,i mean will it work or we need download cloudera odbc drivers to connect hive ,,,,

With Regards

Pardhu