topic Re: Hadoop's hive (H-base)? in QlikView

Hadoop's hive (H-base)?

Mon, 26 Jan 2026 16:26:21 GMT

Interested in knowing if users of QlikView have/are used/using H-Base as their data source from on-premise or cloud?

Hadoop's hive (H-base)?

rbecher — Wed, 21 Sep 2011 19:07:27 GMT

Hi Ricardo,

we are trying to figure out right now how to connect Hadoop with our new JDBC Connector:

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

-Ralf

Hadoop's hive (H-base)?

Fri, 23 Sep 2011 20:29:36 GMT

Hi Ralf,

Many thanks for your prompt reply. After downloading the dll (presumably a 64-bit environ) and having only Windows XP at 32-bit (although QV Server runs on a 64-bit environ) I attempted to register the dll via command prompt regsvr.exe name.dll and its reply was "jdbcconnector_x64.dll is not an executable file and no registrationhelper is registered for this file type." Would there be specific directives on how to deploy the aforementioned dll? Thank you in advance. -Ricardo

Re: Hadoop's hive (H-base)?

Fri, 23 Sep 2011 20:31:18 GMT

Hi Ralf,

Re: Hadoop's hive (H-base)?

rbecher — Sat, 24 Sep 2011 08:45:37 GMT

Hi Ricardo,

this dll is for Windows 64 bit environment. I will see if we can make 32 bit one next week. In the meantime you could try to use it on your 64 bit QVS. You do not need to register the dll via regsvr.exe, just copy it into the QV program folder.

- Ralf

Re: Hadoop's hive (H-base)?

Mon, 26 Sep 2011 14:07:26 GMT

Hi Ralf,

Thanks for the advice, and the news about a possible 32-bit dll. I have asked two other colleagues to conduct some testing on this. Best, Ricardo

Re: Hadoop's hive (H-base)?

rbecher — Wed, 28 Sep 2011 09:56:06 GMT

I made some testings with Hive 0.7.1 JDBC driver but still get connection refused error.

Also tried with Squirrel...

Re: Hadoop's hive (H-base)?

Wed, 28 Sep 2011 13:41:09 GMT

Hi Ralf. Never give up! However, in the interest of the future use of QlikView –at least from my perspective in the company I work with—accessing this data source will be a key component since it would open a rich information source –internally. Do you know whether QlikTech is actively working in making this connector a reality or is your work independent from them?

Thanks in advance,

Ricardo

Re: Hadoop's hive (H-base)?

rbecher — Wed, 28 Sep 2011 14:19:18 GMT

Ricardo, I totally agree.

It would be a major step to connect to Hive or HBase to retrieve Hadoop data! Also to connect other NoSQL databases, we are figuring out at the moment.

Btw, we've developed this JDBC Connector intependently in our company with some efforts. It saves us several hours loading time per day on a QV 9 environment.

We hope to turn this into a commercial product soon. But, we still waiting to get some support from QlikTech. There are open issues in custom datasources API documentation..

Re: Hadoop's hive (H-base)?

rbecher — Wed, 28 Sep 2011 21:10:37 GMT

Custom Connect to Hive is done with our JDBC Connector. I had to collect all jars and build a special setting for Hive 0.7.1 JDBC. Now we have to fix some issues in the DLL. Then I will prepare an example, soon.

Re: Hadoop's hive (H-base)?

rbecher — Thu, 29 Sep 2011 17:32:43 GMT

Ricardo,

it's working now with Hive: http://community.qlik.com/docs/DOC-2438

You will need a special set of jars I have prepared: hive_jdbc-0.7.1.zip Add all of them into the CLASSPATH variable.

A will prepare a tutorial tomorrow.

- Ralf

Re: Hadoop's hive (H-base)?

Thu, 29 Sep 2011 19:15:17 GMT

Hi Ralf,

Thank you for the due diligence. I will be installing Apache™ Hadoop™ current version in an isolated environment so as to use your developments thereafter. Best, Ricardo

Re: Hadoop's hive (H-base)?

rbecher — Fri, 30 Sep 2011 15:28:06 GMT

Hi Ricardo,

please take a look at my new tutorial: http://community.qlik.com/docs/DOC-2457

Cheers!

Ralf

Re: Hadoop's hive (H-base)?

Fri, 04 Nov 2011 14:55:49 GMT

DataRoket allows you to connect seamlessly to any Hadoop data. If you have a project, we would love to test it for you. For more information:

http://tinyurl.com/4x4n7zj

Hadoop's hive (H-base)?

rbecher — Fri, 02 Dec 2011 22:20:45 GMT

Please download the new version of the JDBC Connector. There is the fix for using Hadoop: http://bit.ly/vRIhbW

- Ralf

Hadoop's hive (H-base)?

rbecher — Mon, 12 Dec 2011 20:57:10 GMT

The new Hive version 0.8.0 will have some enhancements in the JDBC driver for a better query performance using batch fetching.

- Ralf

Hadoop's hive (H-base)?

rbecher — Tue, 27 Dec 2011 10:11:18 GMT

Apache Hive 0.8.0 released: http://hive.apache.org/releases.html

- Ralf

Re: Hadoop's hive (H-base)?

Mon, 14 Jan 2013 10:07:05 GMT

The new Hive ODBC connector form HortonWorks works very well.

http://hortonworks.com/download/