How to integrate Qlik sense with hiveserver2

[#1]

I need to integrate the Qlik sense with Hive server2 running in my cluster

[#2]

@bandhu gupta

Please follow : http://hortonworks.com/hadoop-tutorial/business-discovery-and-visualizing-your-data-in-hdp-using-qli...

[#3]

@Sandeep Nemuri

Thanks for the link.

But in this documents there are two different ways of ingesting data .

Can you or anyone please explain the 2nd method .ie QlickView Hybrid solution ?

In this link its been described that with simple modification in the load script , the application can be configured to run hydrid soluiton.

It would be really of great help, if anyone can please describe this simple modification. ?

Thanks in advance.

[#4 · Accepted solution]

The QlikView Hybrid Solution is also referred to as "QlikView Direct Discovery", whereby data is not cached in QlikView but is, instead, loaded on demand, directly from the source. This allows Qlik to run against the vast amount of data in a Hadoop Data Lake without memory restrictions.

One simple modification to the load script would be replacing the word "SELECT" with "DIRECT QUERY" within the SQL statement. You can find the documentation from Qlik at https://help.qlik.com/en-US/connectors/Subsystems/ODBC_connector_QV_help/Content/1.0/ApacheHive/Load....

There are other functions related to the "DIRECT QUERY" option and you can find further documentation at https://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/DirectDiscovery/direct-discovery....