We set up a hadoop cluster with 3 linux servers[say A,B,C]. In server A we have configured Apache Ambari and nifi in server B. We are planning to move data from mysql database to hive database. As a part of the flow, we are using Processors like ExecuteSQL ----> ConvertAvroToJSON ----> PutFile ---->ReplaceText ----->ConvertJSONToSQL ---->PutHiveQL [refer the attached file].
Currently we are running Ambari and Hive in Server A and trying to connect to it from Server B [nifi]. We are facing issue with connectivity with Hive.
Were u able to create a connection with Ambari on a different server? As we too are facing the same issue with connection form nifi to hive in Ambari. As the error states it cannot load the Database Driver, where as we have provided a jdbc driver and its path to fetch. We later on tried to create a connection with sql database and still facing the same issue as for hive. PFA of screenshot of the error while connecting to sql server database .