A date can be analyzed in a variety of ways. Once you get the date data for a particular transaction, you’ll undoubtedly want to see
Category: Apache Hive
Get DayName in Apache Hive & Impala
It’s sometimes important to display the day name for the specified date when creating summary reports, pivot tables, and charts. We commonly save data in
Truncate External Table Partition Data- Apache Hive
For information on how to truncate whole data or partitioned data in internal tables, check the previous blog. According to Hive documentation, the target table
Bucketing in Apache Hive Part-2
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
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
Big Data & SQL 