Data warehouse

I have a data warehouse with about 14 million transactions per day( 10 years, about 51 billion records) this data has been archived on oracle and because of performance issues no analytic report can be executed on the servers. I decided to transfer the data to distributed platforms like Spark .
Is it possible to transfer the data to elastic search and build my data warehouse on elastic search? Does ES support SQL to make my analytic reports? Does ES require more servers than Spark?
Thank you

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.