Database Reference
In-Depth Information
WARNING
If you are having trouble getting SSIS and Hive to communicate over
the network, one troubleshooting step you can take is to disable the
firewalls on both computers entirely, using the instructions provided by
Microsoft:
http://technet.microsoft.com/en-us/library/
cc766337(v=ws.10).aspx
.
If this allows the computers to start
communicating, it indicates a problem with the firewall configuration.
If they still cannot communicate, you have a different issue.
Be aware that disabling the firewall can open up potential security risks
and may be prohibited by your network policy. This is recommended
only as a troubleshooting step, and you should restore the firewall as
soon as you identify the problem.
After opening the ports, verify that the Hive server is running in Thrift
mode. You can check this by opening the Hive server's
hive-site.xml
configuration file, which you can find in the Hive installation directory,
under the
conf
folder (by default,
C:\hdp\hadoop\hive-0.11.0.1.3.0.0-0380\conf
). Locate the
property entry for
hive.server2.servermode
. Make sure that the value
of the property is set to
thrift
. This puts the Hive server into a mode that
better supports multiple users and enables authentication from external
clients. This is required for the Hortonworks ODBC driver to work correctly.
The value in the configuration file should look like the following:
<property>
<name>hive.server2.servermode</name>
<value>thrift</value>
<description>HiveServer server type: thrift or
http</description>
</property>
