In my previous article, I had discussed the conversion of bigint value to date time in both PostgreSQL and SQL Server. It raises several questions
PostgreSQL BigInt Value – Conversion to UTC and Local Times
Most of the ticketing systems by default use either MySQL or PostgreSQL and often stores the date-time of the DML events in Bigint format. When
Computing Running & Cumulative Average
This article helps you understand how to calculate the running average and cumulative average on a given data set. As discussed earlier, windowing functions
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
Big Data & SQL 