Please see my previous post on bucketing and bucketed tables for more information. Bucketed Sorted Tables will be explored in this post. As discussed in
Transactional Tables in Apache Hive
It is now possible to create transactional tables that enable operations with ACID semantics in Hive 4.0 (HIVE-18453). These transactional tables are used for data
Accessing Part of the Date – Apache Impala
The most critical and significant column is always the date/time in the data. A date/time dimension provides all the information you need for a given
Integrity Constraints in Apache Hive
Since Hive 2.1.0, non-validated primary and foreign key constraints have been supported. When constraints are provided, several SQL tools generate more efficient queries. Since these
Add or Subtract Days to a Date – Apache Impala
There are plenty of built-in functions available in Apache Impala that helps in analyzing the data and business logic implementations. It relieves a developer’s worries
LEFT and RIGHT functions in Apache Impala
String functions are used to execute an input string operation and return the output string. There are many built-in string functions available on almost all
Big Data & SQL 