Created on 06-30-2016 07:07 AM - edited 09-16-2022 03:28 AM
I was trying to configure my HortonWorks ODBC Driver and i am getting below error.
am i missing anything in the set up ? btw i am not getting what is Delagation UserID here.
FYI, I logged in as root user and password:Training123@Ravi and output of my ifconfig is
and I am refering the below link for configuring ODBC Driver and i am getting different set up window than what is available in link
Created 06-30-2016 04:48 PM
Interesting, I don't understand why you can't connect via beeline if the service is up and you can connect on this port. Can you please confirm that you can connect to Hive View via Ambari (and submit queries successfully)?
One thing to check is that the sandbox has enough resources to provide a YARN container for Hive. You can check the ResourceManager UI by navigating to http://192.168.228.128:8088 and seeing if the consumed memory/CPU is exceeding the resources of your cluster. You can also list what YARN apps are running by yarn application -list from the sandbox shell.
Created 06-30-2016 07:30 AM
@slachterman Could you please help me with above question
Created 06-30-2016 02:01 PM
@Ravikumar Kumashi are you able to connect using that host, port, and username using the hive command line client on the sandbox?
Created 06-30-2016 02:11 PM
@slachterman how can we do it from command line, I mean what is the command i need to use in sandbox
Created 06-30-2016 02:32 PM
beeline -u jdbc:hive2://192.168.228.128:10000/default
Is 192.168.228.128 the address you are using to reach the sandbox from your windows PC for other protocols, like SSH?
Created 06-30-2016 07:39 AM
@Ravikumar Kumashi the documentation you followed looked far old and it is meant for odbc driver version 1.2.0.*, what authentication mechanism you are currently using with hiveserver2?
Created on 06-30-2016 07:46 AM - edited 08-19-2019 04:56 AM
@Rajkumar Singh I new to Hortonworks, I am just trying to follow the tutorials given in the Hortonworks.I am using User Name as the Authentication mechanism, please see below
Do I need to follow different link or steps ?
Created on 06-30-2016 11:37 AM - edited 08-19-2019 04:55 AM
for username authentication there isn no Binary option, so i tried with Username and password authentication with Thrift Transport option as Binary and HTTP still getting below error
Created 06-30-2016 07:58 AM
can you check the following property value either from amabri or in hive-site.xml, it should be configured in any of the following option
NONE,KERBEROS,PAM,LDAP,CUSTOM
Created 06-30-2016 08:25 AM
@Rajkumar Singh How to find the hive-site.xml path in HortonWorks Sandbox and how to see the these properties in hive-site.xml, sorry i am new to Hortonworks sandbox and my question might sounds silly