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
SQL Server Built-in Functions
In SQL, a built-in function is a programming object that takes zero or more inputs and returns a value. A feature that is built into
Partitioned, Bucketed and Skewed Tables in Hive
When working with a large amount of data on a Hadoop file system, both partitioning and bucketing in Hive are used to avoid table scans
When to avoid bucketing in Hive
When working with large datasets that need to be divided into chunks for better management and the possibility to connect queries with other large datasets,
Apache Sqoop vs Apache Flume
The goal of choosing an ETL solution is to ensure that data enters Hadoop at a rate that meets analytic requirements, and top-rated Hadoop data
Data Platform Job Roles: Business Systems Analyst
These are a series of posts that can assist beginners who are eager to dive into the “data platform” or professionals who are considering a
Big Data & SQL 