I have Hortonworks Hive odbc driver setup on DESKTOP A. So when I execute below command
it is SUCCESSFUL
But when I am trying to run using RSUBMIT from DESKTOP B though connection RSUBMIT is SUCCESSFUL but i am encountering with below error
Note: The odbc is authenticated with kerberos.
Is the DSN a machine/system DSN or a User DSN? That might make a difference.
Also, if using Kerberos or IWA, there might be a Trusted for Delegation change needed. With the RSUBMIT, you're introducing an addition network hop between the client(s) and the target database.
Moving this topic to Data Management for more experts to see it.
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!
Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.
Find more tutorials on the SAS Users YouTube channel.