We are currently investigation how we can setup write rights to Hive/Hadoop to store temporary results on Hive/Hadoop instead of in the SQL DB of AC.
We also read it might be possible to use Hive/Hadoop tables in the enrichment / split activity, and not only in the RDBMS activity.
We however have some questions related to this, maybe the community can help us:
- Is it possible to store the result of an RDBMS activity on Hive instead of the SQL DB of Adobe Campaign? - What rights does AC need to be able to write tables on Hive/Hadoop? - How can we configure AC to be able to do this? - How can we achieve access to Hive/Hadoop through enrichments/split activities? - Is there any risk that giving those rights will also grant rights on other tables?