Blog Archives
1 29 30 31 32 33 34

SQL analytic functions interview questions – Part 1

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”...



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.

Read more ›



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

Read more ›



⏯ 02: Hue and terminal window to work with HDFS

Learn step by step at: Course: Getting started with BigData on Cloudera

Read more ›



1 29 30 31 32 33 34

Java Developer Interview Q&As

800+ Java Interview Q&As

Top