How do I fix ADF Pipeline Error 2347?

Verify the ODBC/JDBC connection setup. For JDBC in the same VNet, retrieve the URL from Hive → Summary → HIVESERVER2 JDBC URL in Ambari.. Validate JDBC config against 'Query Apache Hive through the JDBC driver in HDInsight'; for ODBC, follow 'Tutorial: Query Apache Hive with ODBC and PowerShell'.. Open the Ambari UI and confirm Hiveserver2, Hive Metastore, and Hiveserver2 Interactive are running.. Review the Ambari dashboard alert section and resolve any active alerts per the 'Managing and Monitoring a Cluster' guidance.. If the cluster looks healthy and the connection is correct, contact the Azure HDInsight support team with the full activity run details.

High severityconfigurationAzure Data Factory →

ADF Pipeline Error:
ADF Pipeline Error 2347

What does this error mean?

Hive script execution via ODBC failed on the HDI cluster — submitted from ADF, failed downstream on Hive.

Common causes

1Incorrectly configured ODBC or JDBC connection string to the HDInsight cluster
2Hiveserver2, Hive Metastore, or Hiveserver2 Interactive service is down or unhealthy
3Network/virtual network connectivity issue between ADF integration runtime and HDI cluster
4Active Ambari alerts indicating cluster degradation affecting Hive execution

How to fix it

1Verify the ODBC/JDBC connection setup. For JDBC in the same VNet, retrieve the URL from Hive → Summary → HIVESERVER2 JDBC URL in Ambari.
2Validate JDBC config against 'Query Apache Hive through the JDBC driver in HDInsight'; for ODBC, follow 'Tutorial: Query Apache Hive with ODBC and PowerShell'.
3Open the Ambari UI and confirm Hiveserver2, Hive Metastore, and Hiveserver2 Interactive are running.
4Review the Ambari dashboard alert section and resolve any active alerts per the 'Managing and Monitoring a Cluster' guidance.
5If the cluster looks healthy and the connection is correct, contact the Azure HDInsight support team with the full activity run details.

Frequently asked questions

What causes ADF Pipeline Error 2347?

Pipeline configuration or connectivity issue

Where can I find more details?

Open Azure Data Factory Monitor, find the failed run, click on the activity, and view the full error output in the Output tab.

Source · learn.microsoft.com/en-us/azure/data-factory/data-factory-troubleshoot-guide#error-code-2347