I want to check pyspark connectivity with Hive ODBC in Fabric Notebook

[imraj45]

I’m new to Microsoft Fabric and trying to connect PySpark with Hive ODBC in a Fabric Notebook. I want to verify if the connection is working correctly.

Could someone guide me on the steps to check connectivity? Do I need to configure anything specific in Fabric Notebooks to make this work? Any sample code or best practices would be really helpful.

Thanks in advance!

[v-sgandrathi · Accepted solution]

Hi @imraj45,

Thanks for connecting with the Microsoft Fabric Community Forum.

To successfully connect Fabric Notebooks with Hive ODBC, you need to configure a few configurations They are:

Fabric Notebooks support PySpark, but you must manually install pyodbc to enable ODBC connectivity with Hive.

Additionally, a properly installed and configured Hive ODBC driver is required for the connection to work.
You also need to define the connection using a pre-configured Data Source Name (DSN) to establish communication between Fabric Notebooks and Hive ODBC.

With these configurations in place, the connection should work seamlessly.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.