Apache Hive is 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