topic RE: Hive database connection using OLEDB utility in Product Forum

Hive database connection using OLEDB utility

SahelaJ — Fri, 01 Dec 2017 16:35:00 GMT

Hi, I need to access Hive dataware house to fetch some details.I am using OLEDB utility for setting the connection.The connection string format is " jdbc:hive2://:/;user=;password=; ". I am passing the same in OLEDB utility ConnectionString Variable. But I am getting below error. Kindly Suggest. Error : " Internal: Could not excite code stage because exception thrown by code stage: An OLE DB Provider was not specified in the ConnectionString. An example would be, 'Provider = SQLOLEDB;' " Thanks in advance, Sahela J

Hello,

Denis__Dennehy — Fri, 15 Dec 2017 16:07:00 GMT

Hello, I don't know about Hive but the connection string for Excel looks something like this: Provider=Microsoft.ACE.OLEDB.12.0;Data Source=""C:\Temp\Testfile.xlsx"";Extended Properties=""Excel 12.0 Xml;HDR=NO;""; I would expect your connection string to look something more like that (with Provider= etc...)

RE: Hive database connection using OLEDB utility

rajeevpalla1 — Wed, 24 May 2023 08:34:00 GMT

Hi Sahela,
I need to access Hive server database house to fetch some details.I am using OLEDB utility for setting the connection.
if you find any solution kindly Guide us.

thanks in advance.

------------------------------
rajeev palla
------------------------------