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 08:39 AM
/etc/hive/conf/
Created on 06-30-2016 10:01 AM - edited 08-19-2019 04:56 AM
Created on 06-30-2016 10:23 AM - edited 08-19-2019 04:56 AM
If the hive.server2.authentication and hive.server2.enable.doAs property are set as below
what should be the ODBC driver set up, I mean Host, port , database, authentication mehcanism, Delegation UID values.
FYI i logged in to sandbox using root as user and output of ifconfig is as below
Created 06-30-2016 10:48 AM
@Rajkumar Singh Binary and HTTP
Created on 06-30-2016 11:11 AM - edited 08-19-2019 04:56 AM
@Rajkumar Singh I tried with Binary and HTTP getting the error, please see below
I am thinking am i not giving the host, port, database and Delegation UID correct ?
Do i need to enable the sasl property in hive-site.xml
Created 06-30-2016 10:42 AM
what are the other options available in Thrift Transport while installing driver?
Created 06-30-2016 10:56 AM
@Ravikumar Kumashican you try with http or binary, if it helps
Created 06-30-2016 11:22 AM
use authentication mechanism 'use name' and transport binary
Created on 06-30-2016 12:56 PM - edited 08-19-2019 04:55 AM
I am thinking there might be some issue Hive ODBC driver set up why becuase when 'hive.metastore.sasl.enabled' was set to false in hive-site.xml i was getting below error
But when 'hive.metastore.sasl.enabled' was set to true in hive-site.xml i am getting below error
In both case it is just vice versa if u observer the error message.
Is there something we can set it in hive ODBC driver config file to set SASL to true
Created on 06-30-2016 03:56 PM - edited 08-19-2019 04:55 AM
Yes 192.168.228.128 is the adress i am using.
I used command line to connect to that host it is taking very long time, It is almost more than 30 minutes