SAP HANA Studio's Remote Source has stopped working
My Hive's remote source in SAP HANA Studio Has stopped working. The image below shows it:
The error that shows is the following:
SAP DBTech JDBC: [403]: internal error: Cannot get remote source objects: [unixODBC][Driver Manager]Data source name not found, and no default driver specified
In SAP HANA machine, I have the next configuration in /etc/odbc.ini:
[HIVE]
Description=Hortonworks Hive ODBC Driver (64-bit) DSN
Driver=/usr/lib/hive/lib/native/Linux-amd64-64/libhortonworkshiveodbc64.so
HOST="My AWS IP instance"
PORT=10000
Schema=default
ServiceDiscoveryMode=0
ZKNamespace=
HiveServerType=2
AuthMech=3
ThriftTransport=1
UseNativeQuery=0
UID=hive
PWD=hive
KrbHostFQDN=_HOST
KrbServiceName=hive
KrbRealm=
SSL=0
TwoWaySSL=0
ClientCert=
ClientPrivateKey=
ClientPrivateKeyPassword=
When I try to run isql, it runs successfully and I can run queries successfully too. The image below shows it:
What could be the error?
Thanks for the support!
Solution
You may want to check that the ODBC.ini for the adm OS user is still configured correctly. "Data source name not found" sounds a lot like "there is no ODBC.ini entry for that".
- Is defining a delimiter in a hive ORC Table useless?
- Unable to exit Hive
- How to delete and update a record in Hive
- Unable to access hiveserver2 via beeline
- Creating deciles in SQL
- Keeping the order of records in Hive collect
- How to cache dataframes that will be retained after spark session terminates
- Writing SQL vs using Dataframe APIs in Spark SQL
- Athena unable to parse date using OpenCSVSerde
- java.lang.RuntimeException: Unable to instantiate org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient
- Why does Spark not create a new file after inserting data into an external table?
- How to change date format in hive?
- Hive Always Fails at Mapreduce
- Hql query through using YARN APPLICATION ID
- How to delete data physically with Presto/Trino?
- Parsing a table that has a JSON column with multiple rows per field
- athena insert and hive format error for HiveIgnoreKeyTextOutputFormat
- How do we know if a table is managed table or external table?
- I need to calculate profit/loss for given stock data set, ensuring that the first bought items are sold first
- Filtering is supported only on partition keys of type string Hive
- Flutter, Hive, GetIt => Problem Registering Box
- Export as csv in beeline hive
- Parquet column cannot be converted in file (...) Expected decimal, Found: FIXED_LEN_BYTE_ARRAY
- DuckDB insert the hive partitions into parquet file
- hive -e with delimiter
- Spark: what options can be passed with DataFrame.saveAsTable or DataFrameWriter.options?
- Simulate recursive formula
- Will Insert Into Command preserve order in Spark3
- Spark Streaming - Refresh Static Data
- HIVE SQL script to set end date to 12-31 of current year