Thanks Jason for sharing these queries and their resolutions. ...
Thanks Jason for sharing these queries and their resolutions.
Being new to Hadoop, I recently installed the Hortonworks Sandbox on my Windows 7 Premium 64bit machine. However, even after following the tutorials for Tableau, Excel and ODBC, I am unable to connect. Any help would be appreciated!
I have tried to be as detailed with my computing environment as possible:
Virtual Box + Hortonworks Sandbox (latest)
Able to connect with browser on 127.0.0.1:8000, nyse_stocks table created and registered with HCAT, Hive queries on nyse_stocks successful.
Virtual OS: Red Hat 64bit
Windows 7 Home Premium 64bit
ODBC: Both, 32bit and 64bit installed
RAM: 1800MB allocated to Virtualbox. I currently only have 4GB on my laptop and am currently awaiting for my 2nd 4GB stick to arrive. The system is a little sluggish but my RAM should arrive soon…
1. Virtual Box Preference:
NATNetwork CIDR: 10.0.2.0/24 (default settings, with NAT enabled); no port forwarding set
Adapter: 192.168.56.1 Mask: 255.255.255.0
DHCP: 192.168.56.1 Mask: 255.255.255.0 Bounds 22.214.171.124-110
2. Sandbox Settings:
Adapter 1: NAT enabled
Adapter 2: Host only adapter
3. ~ifconfig results:
1.Testing the 64 bit ODBC connection from Administrative Tools:
Port: 10000 (also tried 8000, 8888)
Database default, Hive Server 2, Username: hue (no password)
Driver Version: V126.96.36.1995 Running connectivity tests…
Attempting connection Failed to establish connection
SQLSTATE: HY000[Hortonworks][HiveODBC] (34) Error from Hive: connect() failed: errno = 10060.
TESTS COMPLETED WITH ERROR.32 bit ODBC:
2.Testing the 32 bit ODBC and attempting to connect with Tableau:
Server Type: Hive Server 2
Mechanism: User Name
Using Hortonworks Hive
Server Name: tried 192.168.56.101:10000 and 127.0.0.1:8000
Authentication: User Name (sandbox)
Unable to connect to the ODBC Data Source. Check that the necessary drivers are installed and that the connection properties are valid.
[Hortonworks][HiveODBC] (34) Error from Hive: connect() failed: errno = 10060.
Unable to connect to the server “192.168.56.101”. Check that the server is running and that you have access privileges to the requested database.
Unable to connect to the server. Check that the server is running and that you have access privileges to the requested database.