Qlik Community

QlikView Extensions

Discussion Board for collaboration on QlikView Extensions.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Hadoop's hive (H-base)?

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

1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

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

Hi Ricardo,

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

Cheers!

Ralf

17 Replies
MVP & Luminary
MVP & Luminary

Hadoop's hive (H-base)?

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

Not applicable

Hadoop's hive (H-base)?

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

Not applicable

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

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

MVP & Luminary
MVP & Luminary

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

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

Not applicable

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

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

MVP & Luminary
MVP & Luminary

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

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

Also tried with Squirrel...

Not applicable

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

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

MVP & Luminary
MVP & Luminary

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

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

MVP & Luminary
MVP & Luminary

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

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.