Pergunta de entrevista da empresa Netcracker Technology

Python- 1. WAP to eliminate vowels in input string. 2. WAP to print "aaabbbbcccc". input - 'a3b4c4' SQL- 1. rank/dense_rank/row_num - state difference and explain with a real life example. 2. Input Table C1 | c2 1 | India 2 | Aus 3 | Pak 4 | SL OutPut India | Aus India | Pak India | SL Aus | Pak Aus | SL Pak | SL Big Data :- 1. Diff between Parquet/Avro/ORC/CSV 2. Hive partitioning vs bucketing 3. How data is stored in AWS S3 ? 4. Types of Spark modes (cluster/client) 5. Types of cluster managers (YARN/Mesos/ Kubernetes/Local/Standalone)

Resposta da entrevista

Sigiloso

19 de ago. de 2022

SQL Q.2) with cte_row as (select row_number() over(order by c1) as id,c1 from teams) select c1.c1,c2.c1 from cte_row c1 join cte_row c2 on c1.id