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 or can simply use “*” to represent all columns in the table in SELECT statement. […]
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 can be classified as DATE Function. Handling DATE in HIVE is not as easy as
Hive Date Functions – all possible Date operations Read More »
Recently I was working on a project in which client data warehouse was in Teradata. The requirement was to have something similar on Hadoop also for a specific business application. At a high level, the requirement was to have same data and run similar sql on that data to produce exactly same report on hadoop
How to implement recursive queries in Spark? Read More »
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 this post. What is HIVE ? HIVE is a software built on top of Hadoop
Hive Partitions – Everything you must know Read More »
Max Iterations error is not very common error in Spark however if you are working with Spark SQL you may encounter this error. The error mostly comes while running query which generates very long query plans. I was recently working on such query which involved many joins and derived tables & CTE etc. In short,
Max iterations (100) reached for batch Resolution – Spark Error Read More »