Hive vs Impala in Big Data Hadoop

1. Impala is developed by Cloudera.and shipped by Cloudera, MapR, Oracle and Amazon.

2. Impala can query many file format such as Parquet, Avro, Text, RCFile, SequenceFile

3. it supports data stored in HDFS, Apache HBase and Amazon S3.

4.it supports multiple compression codecs: Snappy (Recommended for its effective balance between compression ratio and decompression speed), Gzip (Recommended when achieving the highest level of compression), Deflate (not supported for text files), Bzip2, LZO (for text files only);

Impala is best choice for interactive BI-like workloads, because Impala queries have the lowest latency across all other options -under concurrent.

Hive is great choice when low latency/multiuser support is not a requirement, such as for batch processing/ETL. Hive-on-Spark will narrow the time windows needed for such processing, but not to an extent that makes Hive suitable for BI