1. A special utility?
2. NiFI: Load Table to ORC with PutHDFS, PutHiveQL Merge with ACID Table
4. NiFI: PutHiveStreaming
5. NiFi: To Druid, Insert into hive acid table from table ontop of Druid
6. NiFi to HBase, Hive table on hbase insert into Hive Acid Table
7. Some SnappyData in memory pattern?
8. IBM BigSQL?
I would go with either attunity & or some utility/framework which can be modified depending on the use case. These kind of frameworks reduces time and effort. Multiple tables can be processed in parallel with less effort.
that would definitely work, but they are not open source and not free.
Any suggestions for open source?