5 ms·

impala is good but it's no match for the best analytics databases out there

• anonymousDan 12y ago
  In terms of performance or features? They had a paper at CIDR this year that claims they are competitive with a well known analytics DB (presumably oracle although it wasn't named explicitly).
  • supergirl 12y ago
    afaik impala doesn't have multicore joins while almost any other serious db has. so if it uses 1 core out of 10, 20 to do the join then it might be 10x, 20x slower than the best
    • mping 12y ago
      ...but throughput shouldn't be a problem if you have N queries at same time (N=nr of cores)
      • supergirl 12y ago
        yeah, I guess if you want throughput then it's fine
• eropple 12y ago
  Most of those analytics databases are pretty temperamental in cloud environments, though. I haven't used Impala, but something that can run on EMR (especially if it can get better turnaround times than Redshift) is pretty interesting. (Vertica in AWS is a tire fire. Avoid avoid avoid.)