Data Engineers & analysts must know the analytic functions applied over a window of rows is a powerful tool to analyse the data. This post compliments “Apache Spark window functions”...
Blog Archives
SQL analytic functions interview questions – Part 2
This extends SQL window function for analytical queries interview questions – Part 1 Analytic function construct The analytic function names can be RANK(), … Read more ›...
SQL analytic functions interview questions – Part 3
This extends SQL analytic functions interview questions – Part 2 and SQL analytic functions interview questions – Part 1. The below example was created in IMPALA SQL engine with Common...
SQL querying Temporal tables & SCD Type 2
Q1. What is a temporal table? A1. Temporal tables store and maintain information with respect to time. … Read more ›...
SQL retrieving the latest records interview Q&As
This question can reveal a lot about your ability to write SQL queries as different approaches can be used and there will be drill down on pros and cons of...
Straight Through Processing, OLTP, Data warehousing & OLAP
Large mission critical applications use Straight Through Processing, and these systems need to be highly scalable. So, when you apply for these high paying jobs, it really pays to prepare...
Understanding Cloudera Hadoop users
Step 1: A number of special users are created by default when installing and using CDH and Cloudera Manager. For example
Unix user id: hdfs
groups: hdfs hadoop
Unix user id: spark
groups: spark
Unix user id: hive
groups: hive
and so on.
…
What do data analysts, engineers & scientists do?
In addition to the Data Analysts, the Data Engineers & Data Scientists must have the below know-hows.
⏯ 01: Cloudera Manager Tutorial
1. Installing & getting started with Cloudera QuickStart on VMWare for windows in 17 steps
Learn step by step at: Course: Getting started with BigData on Cloudera
…
Contact us: java-interview@hotmail.com
Latest posts by Arulkumaran Kumaraswamipillai (see all)
- 300+ Big Data Interview Questions & Answers - July 11, 2022
- 800+ Java interview questions & answers - July 11, 2022
- What does this Unix code snippet do? - July 2, 2022
Responsive WordPress Theme powered by CyberChimps
Top
