> Can LLAP be used as a caching tool for data from Oracle DB or any RDBMS.
No, LLAP intermediates HDFS. It holds column & index data streams as-is (i.e dictionary encoding, RLE, bloom filters etc are preserved). Because it does not cache row-tuples, it cannot exist as a caching tool for another RDBMS. I have heard of Oracle GoldenGate replicating into Hive, but it is not without its own pains of schema compat. Cheers, Gopal