Re:Analytics 101: Choosing the right database
by threeseed on Friday March 25, 2016 @04:24PM
(#11362415)
The data format is important. ORC/Parquet being substantially faster then Text or Sequence files.
But the query engines are far more important in terms of performance. Just spend any time with SparkSQL and then Hive and you'll know what I mean.
You will also need to think about the schema, partitioning, compression and other parameters, and those are not trivial decisions.