Apache Hive is one of the most popular SQL framework in Hadoop ecosystem.
In the previous post, we discussed about HIVE transactional tables; how to create it, properties and configurations required and example of HIVE transactional table DDL… Read More »Hive Transactional Tables: Limitations and Considerations (Part 2)
We all know HDFS does not support random deletes, updates. With HIVE ACID properties enabled, we can directly run UPDATE/DELETE on HIVE tables. Hive ACID… Read More »Hive Transactional Tables: Everything you must know (Part 1)
BETWEEN operator in HIVE When we have to check if column value lies between a range of value then we use BETWEEN operator in the… Read More »Hive – BETWEEN
IN operator is used to compare any column value in the table with multiple possible values. It returns TRUE if value is matching with any… Read More »Hive – IN
WHERE clause in HIVE WHERE clause is used to FILTER out records from final result set. When you run any query in HIVE and you… Read More »Hive – WHERE
select DISTINCT in HIVE DISTINCT keyword is used in SELECT statement in HIVE to fetch only unique rows. The row does not mean entire row… Read More »Hive – DISTINCT
SELECT statement in HIVE SELECT statement is used to fetch records from table. A table may consists of many columns and you can specify the… Read More »Hive – SELECT
Date Functions are used to apply different transformations on DATE datatype in HIVE. DATE consists of primarily 3 components – YEAR , MONTH & DAY.… Read More »Hive Date Functions – all possible Date operations
What are partitions in HIVE? How partitions are implemented in HIVE? What is the benefit of partition in HIVE? If you have these or similar… Read More »Hive Partitions – Everything you must know
While working on HIVE, you may want to use variables in the query to get results. A good coding practice is not to hardcode values… Read More »How to use variables in HIVE Query
