Dunnhumby

Name the tools and technologies you have worked with to date.

What steps do you take to troubleshoot a slow-running Spark job?

What would you do if you were assigned a task with a technology you've never used before?

Explain how you would use repartition or coalesce effectively to optimize processing when analyzing data only for a specific region.

How can you delete partitions from a table in Hive using a command?

If manual partitions are created in a Hive data-warehouse table directory, and you query records from those partitions, will you see the data? If not, how can this be fixed?

What is the difference between static and dynamic partitioning in Hive?

Write a SQL query to find distinct IDs from a table where the count is more than 1 and greater than 200.