This article helps you understand how to calculate the running average and cumulative average on a given data set. As discussed earlier, windowing functions
Category: Apache Hive
Displaying the column names in Hive
In my previous post, I discussed about setting a property in the Hive prompt to print the database name which we are currently working. Similarly,
Showing the database name in Hive Prompt
Unlike in traditional RDBMS systems, it is difficult to know in which database we are currently working in Hive due to its command-line interface. It
Skipping First and Footer Row – Hive Internal & External Tables
Most of the data-sets (CSV files, Text files, and so forth.) do have header row inside the data, and loading them in the Hive tables
Hive Internal Table – With External Data
Have you ever wonder what will happen if you miss the “external” keyword while creating an external table? It will be an internal table at
Regular Expressions – RLIKE in Hive
Either SQL Developers or Data Analysts often use arithmetic operators in their queries such as =, >, <, != Apart from this, LIKE, EXISTS, IN,
Big Data & SQL 