Hive – DISTINCT
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 in the table but it means “row” as per column listed in the SELECT statement. […]
Read moreCategory: Apache HIVE
Apache Hive is one of the most popular SQL framework in Hadoop ecosystem.
Hive – SELECT
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 column name which you want to fetch in SELECT statement. You can mention column name/s […]
Read moreHive Date Functions – all possible Date operations
Date Functions are used to apply different transformations on DATE datatype in HIVE. DATE consists of primarily 3 components – YEAR , MONTH & DAY. Any function which help us in identifying, extract or modify value of these DATE components […]
Read moreHive Partitions – Everything you must know
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 questions about partitions in HIVE then we have answered such questions and many more in […]
Read moreHow to use variables in HIVE Query
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 in the query itself so we should know how to use variables in the HIVE […]
Read more
