11 ms·

how is this different from hive on hadoop?

• haberman 15y ago
  Check out "What Hive is NOT" from this page: http://hive.apache.org/docs/r0.8.1/ http://hive.apache.org/docs/r0.8.1/ "Hive is based on Hadoop, which is a batch processing system. As a result, Hive does not and cannot promise low latencies on queries. [...] Hive queries response times for even the smallest jobs can be of the order of several minutes. However for larger jobs (e.g., jobs processing terabytes of data) in general they may run into hours." BigQuery OTOH can query over billions of rows in seconds. It is based on a system called Dremel (http://static.googleusercontent.com/external_content/untrusted_dlcp/research.google.com/en/us/pubs/archive/36632.pdf http://static.googleusercontent.com/external_content/untrust...) that is specifically designed for interactive use, as opposed to being a query language built on top of a batch system.
  • jshen 15y ago
    Awesome, thank you, I have some reading to do :)