Hive ODBC driver

[Shalini_J (shalini)]

I need a connection string format to connect Mapr Hive ODBC driver from uipath ?

[Priyanka_Ramesh]

Hi SHalini,

can you try using this link

ConnectionString ="
Dsn=Sample Microsoft Hive DSN;
applysspwithqueries=1;asyncexecpollinterval=100;
authmech=3;binarycolumnlength=32767;
caissuedcertnamesmismatch=0;
decimalcolumnscale=10;
gettableswithquery=0;
host=;
port=10000;
rowsfetchedperblock=10000;
Schema=default;
uid=;
pwd=*******"

[bcorrea (Bruno Correa)]

Hi, uipath dont provide driver, that will have to be downloaded from the manufacturer:
https://mapr.com/docs/52/Hive/install_hive_odbc_connector_windows.html

[Priyanka_Ramesh]

Once the connection is Successful , try this Query “SELECT CURRENT_DATE”