Big Data Interview | Mock | Problem Solving | Technical Round | Pyspark , SQL

[@mayanksatija684]

As per me, we can do the second question with below : with t1 as ( select customer_number,count(*) as count from orders group by customer_number) select t1.customer_number from t1 where t1.count = (select max(count) from t1)

[@SunilKumar-hq6bt]

I think the join condition in the solution for the first question should be employee(e1).managerid = employee(e2).id.

[@bhavyaparikh6933]

correct

[@anithas99]

1.1st qstn, the join condition should be like ON e.manager_id = m.id WHERE e.sal > m.sal So you can match the manager id first nd check for the manager's id coming as emp id which will give the proper answer i gss 2. Also 2nd qstn we can do order by count(ord_no) desc limit 1 Which will fetch the cust no who placed largest no.of orders in general Correct me if I'm wrong

[@gudiatoka]

In real life coalesce is used while writing/saving the data in storage location in single partion while repartition is used to achieve parallelism that will use worker node properly

[@gudiatoka]

Dear team..missing your videos of mock interview..pls do upload ❤

[@gurupradeep9648]

first one Select name from salary_table as a where salary>(select salary from salary_table where id =a.managerid)

[@gudiatoka]

GroupByKey and reduceByKey both used on rdd level

[@thetransformer2217]

Please upload a good quality Interviews, so that everyone could be benefited. This was nothing close to actual Data Engineer interview.

[@abhishekmodak8496]

This is not upto the mark interview. Answers are wrong for sql query.

[@VishalSharma-jn3mq]

Is this the standard difficulty of questions? I'm almost a fresher and trying for first switch. And it doesn't seems right as question are pretty easy.

[@ganeshchintala6668]

​@@VishalSharma-jn3mq how much experience u have?

[@VishalSharma-jn3mq]

@@ganeshchintala6668 2

[@dataanalyst3210]

not cool second sql question answer is wrong and if interview went wrong at least you can put the correct answe at the end of video this will help full for others it is not like just posting the thing.

[@sabmelegarebaba1233]

Hi Brother currently I am doing job in TCS and i am BCA graduate and I am thinking that after I will complete 2 year in tcs I will take Leave without pay for 2 year and I will do Full time MCA. Its that right way I am going or wrong way . Please suggest me what to do or esle I will go with Part time MCA ??

[@chaitanyasharma2565]

1st question ans is wrong. i guess

[@souravdas-kt7gg]

with c as(select e.*,m.salary as manager_salary,m.name as manager_name from employees_prac e left join employees_prac m on e.managerid=m.id where e.salary-m.salary>0) select name from c; My solution

[@kamalprajapati9955]

Select customer_id from(Select top 1 Customer_id,count(order_id) as NO_of_orders from orders group by customer_id order by No_of_orders desc);

[@ynreddy369]

The query which wrote in the video for salary is wrong. here is the exact query which will work select e.sal,e.name,e.emp_id,e.mngr_id from employee e inner join employee m on e.emp_id=m.mngr_id where(e.sal