Impala vs. Pig vs. Airpal

Get help choosing one of these Get news updates about these tools


Heads up: you're comparing apples to oranges. Tools belonging to different groups are often not directly comparable because they usually have different intended purposes and benefits.

Impala

Pig

Airpal

Favorites

8

Favorites

5

Favorites

14

Hacker News, Reddit, Stack Overflow Stats

  • -
  • -
  • 1.08K
  • -
  • -
  • 0
  • 30
  • 139
  • 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.

Pros about this tool

Pros
Why do you like Impala?

Pros
Why do you like Pig?

Pros
Why do you like Airpal?

Companies

12 Companies Using Impala
7 Companies Using Pig
2 Companies Using Airpal

Integrations

Impala Integrations
Pig Integrations
Airpal Integrations

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



Interest Over Time


Get help choosing one of these