topic Re: Direct Select to Hadoop Hive in QlikView

Direct Select to Hadoop Hive

jasonseril — Wed, 18 Jun 2014 08:03:06 GMT

Hello All,

I installed the Cloudera platform on a virtual machine and uploaded some datasets. I want to know if we can "Direct Select" to these datasets in Hadoop Hive? If we can, please guide us on how to. Document materials, links will be appreciated.

Thanks in advance.

Best,

Jason

Re: Direct Select to Hadoop Hive

IAMDV — Wed, 18 Jun 2014 08:09:01 GMT

Jason - Check the below post by Ralf Becher. Ralf is expert in this area. Hopefully he can add more to your question.

http://tiqview.tumblr.com/post/30384282535/connect-to-hadoop-hive-from-within-qlikview

Curious to know - I assume you're using Linux box?

Cheers,

www.QlikShare.com

Re: Direct Select to Hadoop Hive

jasonseril — Wed, 18 Jun 2014 08:25:24 GMT

thanks Deepak Vadithala for the information.

What I mean is pulling data using the 'Direct Select' function of QlikView through connectors (ie cloudera, etc.). Something like below:

ODBC CONNECT TO [Sample Cloudera Hive DSN];

TestDirectSelect:

DIRECT SELECT "ch_code"

FROM HIVE."default"."bigdata_sample";

Is this possible?

By the way, Im using VirtualBox with CDH4 linux installed.

Thanks in advance.

Re: Direct Select to Hadoop Hive

rbecher — Wed, 18 Jun 2014 08:27:47 GMT

Hi Jason,

there should be an Cloudera ODBC driver available now. I think this should work with direct select but I guess it will not be fun because Hive is very slow you probably could consider Impala.

However, the whole direct select architecture is not designed for the use of Big Data, IMHO. So practically, we rather use a two step approach in our Big Data projects:

1. Let the user select from preloaded dimension values like Date, Region, Product etc.

2. Reload a slice out of the Big Data facts with the selection into QlikView for analysis

- Ralf

Re: Direct Select to Hadoop Hive

jasonseril — Wed, 18 Jun 2014 08:31:50 GMT

Hello Ralf,

Okay, I got it.

Thank you for the valuable information, really appreciated.

Best,

jason

Re: Direct Select to Hadoop Hive

Thu, 19 Jun 2014 06:21:40 GMT

Hi Ralf,

Could you please provide me details how to connect to Hadoop with cloudera ODBC ??

I have seen demo of JDBC connector but its just a demo version.

I need to establish a connection between qlikview and Cloudera

Thanks & Regards,

Keerthi

Re: Direct Select to Hadoop Hive

rbecher — Thu, 19 Jun 2014 08:09:39 GMT

Hi Keerthi,

you can download Cloudera ODBC drivers here:

http://www.cloudera.com/content/support/en/downloads/connectors.html

Install guide here:

http://www.cloudera.com/content/cloudera-content/cloudera-docs/Connectors/PDF/Cloudera-ODBC-Driver-for-Apache-Hive-Install-Guide.pdf

Easy to find with Google..

- Ralf

Re: Direct Select to Hadoop Hive

Mon, 23 Jun 2014 06:39:11 GMT

Hi Ralf,

Once i create Data source.

From Qlikview i need to connect it through ODBC right ?

This is how i connected to it.

Can u help me in connecting with CUSTOM CONNECT

Thanks & Regards,

Keerthi

Re: Direct Select to Hadoop Hive

rbecher — Mon, 23 Jun 2014 07:23:43 GMT

You don't need a CUSTOM CONNECT in this case..

Re: Direct Select to Hadoop Hive

Mon, 23 Jun 2014 09:28:11 GMT

Oki. So just need to connect with ODBC.

Thanks a lot Ralf

Regards,

Keerthi