Direct Select to Hadoop Hive

[jasonseril]

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

[IAMDV]

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,

DV

www.QlikShare.com

[jasonseril]

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.

[rbecher]

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

[jasonseril]

Hello Ralf,

Okay, I got it.

Thank you for the valuable information, really appreciated.

Best,

jason

[#6]

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

[rbecher]

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-f...

Easy to find with Google..

- Ralf

[#8]

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

[rbecher]

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

[#10]

Oki. So just need to connect with ODBC.

Thanks a lot Ralf

Regards,

Keerthi