As with most BI tools, QlikView can use Apache Hive (via ODBC connection) as the SQL access to data in Hadoop. Here we are going to talk about qlikview how to connect Hortonworks Hive via ODBC.

Jul 24, 2020 Phoenix JDBC Driver Download Hortonworks HDP Hive: WINDOWS LINUX. MicroStrategy Hive ODBC Driver Installed with MicroStrategy. MicroStrategy Hive JDBC Driver Installed with MicroStrategy. HP Vertica: WINDOWS. Vertica ODBC Driver Download. Vertica ODBC Driver Download. Vertica JDBC Driver Download. Hubspot: WINDOWS LINUX. I cannot find the archive section on the download page. Could anyone help me to download Hortonworks ODBC Driver for Apace Hive (v2.1.10) please.

Prerequisites

Hortonworks Hive Odbc Driver Mac Download Windows 10

1.Those are versions of each component we installed in Hortonworks

2.We need to make sure HiveServer2 started.

3.Here are the configuration for hive server2. Please note the authentication is NONE.

Configure ODBC connection

1.Install the 64 bits Hortonworks Hive ODBC Driver, you can download ODBC Driver from here.

2.Configure ODBC connection

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.

COVID-19: Digital Insights For Enterprise Action

Access Perficient’s latest insights into how you can leverage digital technologies to not only respond to the pandemic, but drive your operations forward and deliver experiences your customers need.

3.Click Test

Connect to ODBC data source

Cloudera Odbc Driver Download

1.Open QlikView 11 client, (close the Wizard if it appears), click File -> Edit Script, in Data tab choose ODBC as Database and click Connect, select the Data Source you created in previous step and type the User ID/Password:

2.The ODBC connection code are generated automatically in scripts

3.Click File -> Reload to load data

Tips for Hive ODBC Connection Issue

The ODBC connection might failed for some reasons. Here are some tips for trouble shooting.

1.Make sure hive server2 started.

a) You can verify that port 10000 is in use once you start hiveserver2.

sudo netstat -tulpn | grep 10000

b) HiveServer2 supports a new command shell Beeline that works with HiveServer2. It’s a JDBC client that is based on the SQLLine CLI.

bin/beeline

!connect jdbc:hive2://HadoopLab2:10000

Hadoop Odbc Driver

2.Make sure authentication mechanism of hive server2 is proper. You should select mechanism base on hive configuration file. Here we set ‘NONE’ in configuration file. But when mechanism ‘No Authentication’ is selected, the test results always are timeout, and when ‘username’ selected, any value entered in username input box, test result is successfully. It’s weird.

How it is useful: This is useful to connect hortonworks stream data from HCatalog to bring to MS excel to visualize

Step1: Get hold on ip address of the VM box

Step2: Locate Hortonworks hive ODBC drive to download (HortonworksHiveODBC64.msi) it will end with 32 bit system if you are working on a 32 bit operating system

Step3: Configure the ODBC Drive:

Hit Windows + F: Will open a search dialogue on right side of screen

Type Administrative there, the relevant tool option will appear. Hit on that: Keep category Everywhere than Files

Hit Configure ( Refer next pic)

Then add details related to VM :

Then Hit test : To test the connectivity details:

Hit ok on all the windows to close the dialogue boxes

After this it goes same as Horton works original document on sentiment analysis on windows 7

I have just tried to taken care of stuff where it gets different from Windows 7 to Windows 8:

Please follow the detailed steps on how to connect and visualize from here