During data analysis, data analysts must categorize data into categories so that different aspects of the information may be displayed in a more understandable manner.
Author: SHAFI SHAIK
Hi, this is Shafi Shaik, Microsoft Solutions Specialist in Data platform as well as in Data Management & Analytics. I am a certified associate in Oracle SQL*Plus and extensively trained in MongoDB Administration. My current role is Database administration with hands-on expertise in almost all relational databases namely Microsoft SQL Server, MySQL, Oracle SQL*Plus, PostGreSQL & Teradata. I'm also specialized in database development, warehousing, traditional data analysis and Big Data analysis.
Partitioning vs Bucketing in Hive
Partitioning in Hive divides huge tables into smaller logical tables depending on column values; one logical table is created for each individual value. By defining
Apache Hive Data Model
Apache Hive is built on top of Apache Hadoop, which is a distributed, fault-tolerant, and open source data warehouse platform for reading, writing, and handling
Configuration Functions in SQL Server
The following are the list of configuration commands that helps to identify the configured settings information of current instance, in SQL Server. @@DATEFIRST This function
First_Value, Last_Value vs Lead, Lag in SQL Server
The First_Value function in SQL Server returns the first value in an ordered set of values and the Last_Value function returns the last value in an ordered set of
COUNT_BIG function in SQL Server
COUNT_BIG is similar to the COUNT function. The only difference between these functions is the data types of their return values. COUNT_BIG always returns a
Big Data & SQL 