i
Cognizant
Proud winner of ABECA 2024 - AmbitionBox Employee Choice Awards
Filter interviews by
More questions about coding in sql & pyspark
I applied via Naukri.com and was interviewed in Apr 2023. There were 3 interview rounds.
Speculative execution in Hadoop is a feature that allows the framework to launch duplicate tasks for a job, with the goal of completing the job faster.
Speculative execution is used when a task is taking longer to complete than expected.
Hadoop identifies slow-running tasks and launches duplicate tasks on other nodes.
The first task to complete is used, while the others are killed to avoid duplication of results.
This help...
Lists are mutable ordered collections, tuples are immutable ordered collections, and sets are mutable unordered collections.
Lists are mutable and ordered, allowing for duplicate elements. Example: [1, 2, 3, 3]
Tuples are immutable and ordered, allowing for duplicate elements. Example: (1, 2, 3, 3)
Sets are mutable and unordered, not allowing for duplicate elements. Example: {1, 2, 3}
Rank assigns a unique rank to each distinct row, while dense rank assigns consecutive ranks to rows with the same values.
Rank function assigns unique ranks to each distinct row in the result set
Dense rank function assigns consecutive ranks to rows with the same values
Rank function leaves gaps in the ranking sequence if there are ties, while dense rank does not
To add data into a partitioned hive table, you can use the INSERT INTO statement with the PARTITION clause.
Use INSERT INTO statement to add data into the table.
Specify the partition column values using the PARTITION clause.
Example: INSERT INTO table_name PARTITION (partition_column=value) VALUES (data);
WAP to add index wise elements of a list . A=[1,2,3] , B=[4,5,7] C should be [5,7,10]
I applied via Walk-in and was interviewed before Jul 2021. There was 1 interview round.
based on 3 interviews
Interview experience
based on 17 reviews
Rating in categories
Associate
72.1k
salaries
| ₹5.1 L/yr - ₹16 L/yr |
Programmer Analyst
55.5k
salaries
| ₹2.4 L/yr - ₹9.4 L/yr |
Senior Associate
49.3k
salaries
| ₹9 L/yr - ₹28 L/yr |
Senior Processing Executive
29k
salaries
| ₹1.8 L/yr - ₹9 L/yr |
Technical Lead
17.6k
salaries
| ₹5.9 L/yr - ₹21 L/yr |
TCS
Infosys
Wipro
Accenture