SQL-92 and SQL-89 joins are supported by most RDBMSs, including Apache Impala. This article will explain how the syntax is written in both ways and
Query: SQL vs Apache Pig
SQL Queries are used to get data from tables by using SELECT statements with suitable filters and sorting. In this post, I’ll attempt to illustrate
Show Files Statement in Impala
This post will show you how to retrieve a list of the files that make up a certain table, or a partition inside a partitioned
Column Statistics in Apache Impala
Along with the “Table Statistics”, the statistics about the table columns used by the Impala query planner. This post will show you how to retrieve
Table Statistics in Apache Impala
Statistics about whole tables and partitions may be used by the Impala query planner. Physical characteristics such as the number of rows, the number of
Locks in Apache Hive
Locks are used to support concurrency when many programs want to access the same table at the same time. It protects data from being corrupted
Big Data & SQL 