Impala vs. Pig vs. Airpal



Hacker News, Reddit, Stack Overflow Stats

  • -
  • -
  • 1.17K
  • -
  • -
  • 0
  • 30
  • 140
  • 0

GitHub Stats

Description

What is Impala?

Impala is a modern, open source, MPP SQL query engine for Apache Hadoop. Impala is shipped by Cloudera, MapR, and Amazon. With Impala, you can query data, whether stored in HDFS or Apache HBase – including SELECT, JOIN, and aggregate functions – in real time.

What is Pig?

Pig is a dataflow programming environment for processing very large files. Pig's language is called Pig Latin. A Pig Latin program consists of a directed acyclic graph where each node represents an operation that transforms data. Operations are of two flavors: (1) relational-algebra style operations such as join, filter, project; (2) functional-programming style operators such as map, reduce.

What is Airpal?

A web-based query execution tool built on top of Facebook's PrestoDB.

Want advice about which of these to choose?Ask the StackShare community!

Pros

Why do developers choose Impala?
Why do you like Impala?

Why do developers choose Pig?
Why do you like Pig?

Why do developers choose Airpal?
Why do you like Airpal?

Cons

What are the cons of using Impala?
No Cons submitted yet for Impala
Downsides of Impala?

What are the cons of using Pig?
No Cons submitted yet for Pig
Downsides of Pig?

What are the cons of using Airpal?
No Cons submitted yet for Airpal
Downsides of Airpal?

Companies

What companies use Impala?
15 companies on StackShare use Impala
What companies use Pig?
10 companies on StackShare use Pig
What companies use Airpal?
2 companies on StackShare use Airpal

Integrations

What tools integrate with Impala?
2 tools on StackShare integrate with Impala
What tools integrate with Pig?
1 tools on StackShare integrate with Pig
What tools integrate with Airpal?
4 tools on StackShare integrate with Airpal

What are some alternatives to Impala, Pig, and Airpal?

  • Apache Spark - Fast and general engine for large-scale data processing
  • Apache Flink - Fast and reliable large-scale data processing engine
  • Druid - Fast column-oriented distributed data store
  • Presto - Distributed SQL Query Engine for Big Data (by Facebook)

See all alternatives to Impala