i
Zupee
Filter interviews by
To read parquet and csv files in Spark, use SparkSession's read method with appropriate options.
Create a SparkSession object
Use the read method of SparkSession to read parquet files with .parquet() method
Use the read method of SparkSession to read csv files with .csv() method
Specify options like header, delimiter, inferSchema, etc. as needed
Load the data into a DataFrame for further processing
To check the second highest salary, use the SQL query with ORDER BY and LIMIT.
Use SQL query with ORDER BY clause to sort salaries in descending order.
Use LIMIT 1,1 to select the second highest salary.
Example: SELECT salary FROM employees ORDER BY salary DESC LIMIT 1,1
Top trending discussions
I applied via Naukri.com and was interviewed in Nov 2024. There was 1 interview round.
Union combines the results of two or more SELECT statements, while Union all includes all rows, including duplicates.
Union removes duplicate rows from the result set, while Union all includes all rows.
Union sorts the result set, while Union all does not.
Union is slower than Union all because it performs a distinct operation.
Example: SELECT column1 FROM table1 UNION SELECT column1 FROM table2;
Example: SELECT column1 FRO
Joins are generally faster than unions.
Joins are typically faster than unions because they combine data from multiple tables based on a common column, while unions combine data from multiple queries into a single result set.
Joins can utilize indexes on the columns being joined, which can improve performance.
Unions involve combining the results of multiple queries, which can be slower as it requires merging and sorting ...
posted on 11 Jul 2024
I applied via Instahyre and was interviewed in Jan 2024. There was 1 interview round.
I applied via Approached by Company and was interviewed in Jan 2024. There was 1 interview round.
Leetcode problem to find the missing number. multiple followback on this. the second problem was dp to find the identity matrix. was rejected after this
Basic coding test like palindrome, series,arrays
posted on 7 Oct 2024
I applied via Approached by Company and was interviewed before Oct 2023. There was 1 interview round.
Topological Sort based question and it's follow up
posted on 1 Mar 2022
I applied via Approached by Company and was interviewed in Feb 2022. There was 1 interview round.
Check if the black king is under attack and if it is checkmate.
Check if any white knight can capture the black king
Check if the black king has any legal moves to escape capture
If the black king is under attack and has no legal moves, it is checkmate
I applied via LinkedIn and was interviewed before Aug 2020. There were 3 interview rounds.
posted on 14 May 2022
I applied via Recruitment Consulltant and was interviewed before May 2021. There were 2 interview rounds.
General coding questions
based on 1 review
Rating in categories
8-15 Yrs
₹ 60-75 LPA
Software Engineer
25
salaries
| ₹18 L/yr - ₹27 L/yr |
Software Developer
9
salaries
| ₹16 L/yr - ₹48.2 L/yr |
Finance Manager
7
salaries
| ₹11 L/yr - ₹18 L/yr |
Assistant Manager
7
salaries
| ₹9 L/yr - ₹14.5 L/yr |
Data Analyst
7
salaries
| ₹12.5 L/yr - ₹16 L/yr |
Dream11
Rummy Circle
Paytm First Games
Mobile Premier League