Hive using tez has recently (1.2.0) become much faster (if you use the ORC format), so that for most of the use cases it will be sufficient. Alternatively you could use as well SparkSQL (if you have the memory) or apache phoenix. The latter one has - currently - a little bit less SQL support and requires full access to all nodes on the cluster. However, access is rather fast. You can use it for storing/retrieving Pre -aggregated values and use spark or hive for any other queries.
Le lun. 6 juil. 2015 à 9:23, spierki <florian.spierc...@crisalid.com> a écrit : > Hello, > > I'm actually asking my self about performance of using Spark SQL with Hive > to do real time analytics. > I know that Hive has been created for batch processing, and Spark is use to > do fast queries. > > But, use Spark SQL with Hive will allow me to do real time queries ? Or it > just will make fastest queries but not real time. > Should I use an other datawarehouse, like Hbase ? > > Thanks in advance for your time and consideration, > Florian > > > > -- > View this message in context: > http://apache-spark-user-list.1001560.n3.nabble.com/Spark-SQL-queries-hive-table-real-time-tp23642.html > Sent from the Apache Spark User List mailing list archive at Nabble.com. > > --------------------------------------------------------------------- > To unsubscribe, e-mail: user-unsubscr...@spark.apache.org > For additional commands, e-mail: user-h...@spark.apache.org > >
