Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
qlikrajan
Contributor III

Qlikview with HIVE

Hey Expert,

We were thinking of big data implementation with qlikview. We want to store our historical data in HIVE and use it with qlikview. Are you aware of any connectors? Or would you like to share your own experience of big data implementation with qlikview.

Any insight is highly appreciated.

Thanks!

9 Replies
Highlighted
MVP & Luminary
MVP & Luminary

Re: Qlikview with HIVE

Maybe this is helpful: How to connect Hadoop Hive

- Marcus

Highlighted
qlikrajan
Contributor III

Re: Qlikview with HIVE

Have you implemented it in any of your project. I am asking as I have some questions.

Highlighted
MVP & Luminary
MVP & Luminary

Re: Qlikview with HIVE

No, I haven't. I know only that others like rbecher have done it.

- Marcus

Highlighted
qlikrajan
Contributor III

Re: Qlikview with HIVE

Thanks Marcus, it is very helpful indeed. I read the post and conversation below the post.

Highlighted
MVP & Luminary
MVP & Luminary

Re: Qlikview with HIVE

‌I think all major Hadoop distributors provide ODBC drivers for Hive. Just download it from their website and read instructions.

However, there are reasons to use JDBC connectivity.

If you need this you can contact me directly: ralf.becher@tiq-solutions.de

Vizlib Head of R&D
Highlighted
qlikrajan
Contributor III

Re: Qlikview with HIVE

Thanks a lot Ralf! I will contact you soon.

Highlighted
qlikrajan
Contributor III

Re: Qlikview with HIVE

Hi Ralf,

Just need a quick clarification. You said all Hadoop distributors (cloudera, Hortonworks etc) provide ODBC drivers for Hive. Can't we use that ODBC driver to connect with qlikview application? I did not get completely the JDBC thing.

Thanks!

Highlighted
MVP & Luminary
MVP & Luminary

Re: Qlikview with HIVE

‌Yes, you should try the ODBC driver first. But as I mentioned there could be situations where they might not work.

Vizlib Head of R&D
Highlighted
qlikrajan
Contributor III

Re: Qlikview with HIVE

Thank you Ralf. Really appreciate your input. I explore the tool and see how things work with a sample dataset. I will let you know if I come across any complex issues.

Thanks again!