NRI Subscriber(South Africa)| Bigdata Interview | Part-1 | Spark, HDFS, Hive, Sqoop,Hbase | Feedback

#SparkInterviewQuestions #HadoopHiveHbaseSqoop #CleverStudies

Follow me on LinkedIn
-----------------------------------------------------------------------------
Follow this link to join 'Clever Studies' official WhatsApp groups:
--------------------------------------------------
Follow this link to join 'Clever Studies' official telegram channel:
--------------------------------------------------
(Who choose Paid Membership option will get the following benefits)
Watch premium YT videos in our channel
Mock Interview and Feedback
Gdrive access for Bigdata Materials (Complimentary)
--------------------------------------------------
PySpark by Naresh playlist:
--------------------------------------------------
PySpark Software Installation:
--------------------------------------------------
Realtime Interview playlist :
--------------------------------------------------
Apache Spark playlist :
--------------------------------------------------
PySpark playlist:
--------------------------------------------------
Apache Hadoop playlist:
--------------------------------------------------
Bigdata playlist:
--------------------------------------------------
Scala Playlist:
--------------------------------------------------
SQL Playlist:

Hello Viewers,

We ‘Clever Studies’ YouTube Channel formed by group of experienced software professionals to fill the gap in the industry by providing free content on software tutorials, mock interviews, study materials, interview tips, knowledge sharing by Real-time working professionals and many more to help the freshers, working professionals, software aspirants to get a job.

If you like our videos, please do subscribe and share within your friends circle.

Thank you !

[dipteshroy]

Interviewer wont allow candidate to explain so much in detail and will be pissed. Answer should be precise and to the point.

[rupeshdeoria]

I believe parquet is not default support by hive we need to extend jar...

[rameshroshan]

next interview 1-1 hour 3 interviews but end end concept clear ful biga data, just start basics next part 2--part 3---- full big data concepts interview level finished LOL ITS TRUE CLEVER INTERVIEW FOR CLEVER PROGRAMMERS LOL STISFIED KEEP DOING GOOD WORK

[butchiraju]

How to register for hadoop, spark mock interview

[rameshroshan]

thse 2 should be there in SIR your youtube at any cost 1 sql 2 ds algo trust me if these are 4/5 certainly you can take just candidate takes 2 months beat expereinced developers of 10 years, simple after KT --- 2months inside company task done whereas if you take without this 2 skills some or other time resource will bottleneck if and only if these 2 skills are not good 1 SQL 2 DS ALGO probably java relate with scala and for him python is cakewalk or else please see history who bagged above 40 lacs surely they must be very good at these 2 skills. rest 2 months inside on the job they can learn big data

[rameshroshan]

sir humble request please create sql intermediate series a concept and how its asked interview, this will help as Source Mishra youtube channel
Most asked questions
Important DBMS & SQL Query Topics For Data Engineering Interview

Basic-Medium

1. Relations, Schema Design, E-R Diagrams
2. Primary Key, Foriegn Key, Composite Key, Surrogate Key
3. Normalization & Denormalization
4. ACID Properties
5. Transactions
6. Transaction Concurrency
7. Concurrency Control
8. Indexing
9. Types of Indexing
10. DDL, DML, DCL
11. Integrity Constraints
12. Difference between Delete & Truncate?
13. Which one is faster count(*) or count(1)?
14. All type of joins
15. Queries related to SELF JOIN
16. What is NULL SAFE Join
17. Queries related to Group By & Having clause
18. Use of Where clause along with Group by
19. CASE-WHEN statement
20. Group by aggregation with CASE-WHEN statement
21. Use of WITH Clause
22. Difference between any, all & exists
23. Difference between Union & Union All

Advance

1. Difference between Views & Materialized Views
2. When to use Stored procedures & how can we create dynamic Stored procedures
3. Queries related to Window Functions
- Difference between Rank(), Row_Number(), Dense_Rank()
- Over clause with Partition By & Order By
- Aggregation in Window functions like Sum(), AVG(), MIN()
MAX(), FIRST_VALUES(), LAST_VALUE()
- Use of LAG() window function
- Queries for running SUM/AVG etc in Window functions
-> Rows Between
-> Unbounded preceding