
Hi
I want to load mysql data to Hive. I used the following processor
QueryDatabaseTable -> PutHiveStreaming
In QueryDatabaseTable the database Connection Pooling service used is DBCPconnectionPool. In PuthiveStreaming the HiveMetastoreURI I given is thrift://myownIP:9083
and created a ORC table in hive
CREATE TABLE employeeacid (empno int, ename string,job string, mgr int,hiredate string, sal int, comm int, deptno int)
CLUSTERED BY(empno) INTO 3 BUCKETS
STORED AS ORC TBLPROPERTIES ('transactional'='true');
while running the error I am getting is
putHiveStreaming[id....] Error writing[org.apache.nifi.processors.hive.putHivestreaming...] to Hivestreaming transaction due to java.lang.illegalArgumentException:java.net.UnknownHostException:quickstart.cloudera:java.lang.illegalArgumentException:
I refered this link "https://community.hortonworks.com/articles/87686/rdbms-to-hive-using-nifi-small-medium-tables.html"
@Ryan Cicak Could any one please advise on this.
