Interview Questions

Shell commands for renaming a file?

Create a Python program to demonstrate the use of set operations (union, intersection).

Describe Spark's memory management model. How do you handle heap memory overhead issues?

Extended the solution to determine the nth largest element in an array.

GeoPandas - definition and features

Grouping and aggregation functions?

How many cities does each department operate in? List the top 3 departments in terms of the most number of cities. In case of a tie, order by dept_id.

How would you decide between using DISTKEY and SORTKEY?

Implement an algorithm to find the longest common prefix among an array of strings.

List customers with more than 5 orders.

List every combination of dept_name, employee_name, and city such that the employee belongs to the department and the same city in which the department is located.

Reverse a string with special characters preserved.

Write Python code to remove duplicates from a string.

Write a Python program to reverse words in a string.

Write a function that replaces all characters in a list except for a given character

Add Row Numbers using window function in PySpark

Add a column to the Employees table that shows the name of the employee with the next higher employee_id.

Add a new column with manager names for each employee using a self-join.

Add a new column with the average salary by department.

Calculate the cumulative transaction amount for each month using a transaction table.