Requirement: Need to establish a connection between Qlik
view client and Hive tables in Linux environment.
Step 1: Check connectivity to Linux machine from the windows
through the port 1000. You can use telnet to check the connectivity.
Eg: telnet
<Hostname> <Port>
If we are able to connect to the machine through 10000 then
we are good to go.
Step2: Down load the Hive driver for windows from official
Microsoft website.
You can download 32 bit or 64 bit
based on your system specification.
·
HiveODBC32.msi
·
HiveODBC64.msi
Install the driver in your
windows machine.
Step 3: Select ODBC Data Source
64 from windows search.
Select user DSN tab select add
for adding a new data source. Then select Microsoft Hive ODBC Driver
Give the details and test the
connectivity.
·
Gave Thrift Transport as SASL (Transport
protocol used in Thrift layer).
Now save the Data source and exit. You can see in User DSN a
new entry is added with Name Qlik.
Step 4:
Now we have created a DSN for connecting to Hive. We can use
this for connecting Qlik with Hive tables.
Then open Qlik and select edit the script option.
From this window select ODBCà
Connect
Then select the DSN à
Qlik and give username and password. Test the connection and now you have
established a successful connection to Hive.
Then to select the tables from Qlik click on the tab select
and you can see a window as shown below.
In this select query gave the query and save the file. You
can use this QVW file for creating reports from HIVE tables.