Big Data   Apache Hive


Topic Replies Activity
Sorting Data with in groups using DISTRIBUTE BY and SORT BY 1 June 11, 2019
Handling NULL Values 1 June 11, 2019
Type Cast Functions for Data Type Conversion 1 June 11, 2019
Overview of Numeric Functions 1 June 11, 2019
Applying ROW_NUMBER using Windowing Functions 1 June 7, 2019
Applying RANK using Windowing Functions 1 June 7, 2019
Difference between RANK, DENSE_RANK and ROW_NUMBER 1 June 7, 2019
Understanding order of execution of SQL 1 June 7, 2019
Applying DENSE_RANK using Windowing Functions 1 June 7, 2019
Create tables to get daily revenue and daily product revenue 1 June 7, 2019
Reviewing Logs for Hive Queries 1 June 7, 2019
Hive Query - Execution Life Cycle 1 June 7, 2019
Overview of basic Hive Queries 1 June 7, 2019
Overview of Nested Sub Queries 1 June 7, 2019
Getting FIRST_VALUE and LAST_VALUE using Windowing Functions 1 June 7, 2019
Getting LEAD and LAG using Windowing Functions - partition by and order by 1 June 7, 2019
Getting LEAD and LAG using Windowing Functions - order by 1 June 7, 2019
Performing Aggregations using Windowing Functions 1 June 7, 2019
Overview of Analytics or Windowing Functions 1 June 7, 2019
Query Example - Word Count 1 June 6, 2019
Date Manipulation - Dealing with Unix Timestamp 1 June 6, 2019
Date Manipulation - Extracting information using functions 1 June 6, 2019
Date Manipulation - Extracting information using date_format 1 June 6, 2019
Date Manipulation - trunc 1 June 6, 2019
Date Manipulation - Date Arithmetic 1 June 6, 2019
Date Manipulation - Getting Current Date and Timestamp 1 June 6, 2019
String Manipulation - Reverse and Concatenating multiple strings 1 June 6, 2019
String Manipulation - trimming and padding Functions 1 June 6, 2019
String Manipulation - substr and split 1 June 6, 2019
String Manipulation - Case Conversion and Length 1 June 6, 2019