Our Use Case is, Initially I want to ingest 5 tables from RDBMS to Hadoop(HDFS, Hive, HBASE doesn't matter). And join them them in HDP. Then put them into Janus Graph for Graphing. Also there will be incremental load created. I was trying to use NiFi for loading the data into HBase and then looking if I can join Tables in HBase. Or load the data into Hive and join but it will be loaded with hell of data everytime. If this is not the best practice can you please suggest any other approach for this ?