Folks, I'm embarking on a project to build a POC around spark sql, I was wondering if anyone has experience in comparing spark sql with hive or interactive hive and data points around the types of queries suited for both, I am naively assuming that spark sql will beat hive in all queries given that computations are mostly done in memory but want to hear some more data points around queries that maybe problematic in spark-sql, also are there debugging tools people ordinarily use with spark-sql to troubleshoot perf related issues.
I look forward to hearing from the community. Regards
