Open Control Panel, search for ODBC and open ODBC Data Source Administrator, in System DSN tab click Add, configure the data source as below, click OK.Ĭhoosing a Global Software Development Partner to Accelerate Your Digital Strategy ġ.Install the 64 bits Hortonworks Hive ODBC Driver, you can download ODBC Driver from here. Prerequisitesġ.Those are versions of each component we installed in Hortonworks HueĢ.We need to make sure HiveServer2 started.ģ.Here are the configuration for hive server2.
Here we are going to talk about qlikview how to connect Hortonworks Hive via ODBC.
As with most BI tools, QlikView can use Apache Hive (via ODBC connection) as the SQL access to data in Hadoop.
