Data Engineer

Qanday bo'lim turlari mavjud?

Spark'da spill haqida nima bilasiz?

Middle

Островок

Hozirgi ishingizda sun'iy intellektdan foydalanasizmi? Qaysi asboblar va qanday?

Batch yuklash yoki stream bilan ishladingizmi?

Middle

Aston

2021 va 2022 yillar uchun "zarur bo'lgan kategoriya mahsulotlari" va "buyurtma bo'yicha buyurtmalar soni" ni ko'rsating (yakuniy ko'rinish: 2 qator. Maydonlar: yil, mahsulotlar soni, buyurtmalar soni) with cte as( select year(o.order_date) as year_orders, g.cat_1, count(distinct o.order_id) as count_orders, sum(g.quantity) as count_quan from Orders o join Goods g on o.order_id = g.order_id where (g.cat_1 = 'Kiyim' and Year(o.order_date) = 2021) or (g.cat_1 = 'Kiyim' va Year(o.order_date) = 2022) group by year_orders, g.cat_1 ) select year_orders, count_quan, count_orders from cte 2025 yil uchun, har bir kategoriya bo'yicha eng ko'p sotilgan model 3 ta with cte as( select cat_1, price, quantity, model, rank() over(partition by cat_1) as rk from Orders o join Goods g on o.order_id = g.order_id where Year(o.order_date) = 2025 ) 2025 yil uchun, har bir kategoriya bo'yicha eng ko'p sotilgan model 3 ta with cte as( select g.cat_1, g.model, (price * quantity), rank() over(partition by g.cat_1) as rk from Orders o join Goods g on o.order_id = g.order_id where Year(o.order_date) = 2025 ) with cte as( select g.cat_1, g.model, sum(price * quantity) as sum_, rank() over(partition by g.cat_1 order by sum() desc) as rk from Orders o join Goods g on o.order_id = g.order_id where Year(o.order_date) = 2025 ) with cte1 as( select g.cat_1, g.model, sum(price * quantity) as sum_total, from Orders o join Goods g on o.order_id = g.order_id where Year(o.order_date) = 2025 ), cte2 as(select g.cat_1, g.model, sum_total, rank() over(partition by g.cat_1 order sum_total desc) as rk from cte1 ) select g.cat_1, g.model, sum_total from cte2 where rk <=3 kategori nomi, model va umumiy sotuvlar (eng yaxshi 3) with cte1 as( select g.cat_1 as cat_name, g.model as model, sum(price * quantity) as sum_total, from Orders o join Goods g on o.order_id = g.order_id where Year(o.order_date) = 2025 group by Year(o.order_date), g.model ), cte2 as(select cat_name, model, sum_total, rank() over(partition by cat_name order sum_total desc) as rk from cte1 ) select cat_name, model, sum_total from cte2 where rk <=3

Nima uchun hozir yangi takliflarni ko'rib chiqyapsiz?

So'nggi yilda Python'da eng muhim loyiha yoki vazifa haqida gapiring.

CDC nima va uning bilan ishlash tajribangiz bormi?

Transaktsiya izolyatsiya darajalari deb nomlanadigan tushuncha bormi? Bu haqda nima bilasiz?

Qaysi vizualizatsiya asboblari bilan ishladingiz va Power BI bilan qanchalik yaqin ishladingiz?

Python'da kontekst menejerlari bilan ishladingizmi? Ular nima va nima uchun kerak?

Middle

Островок

Spark/UDF kontekstida serializatsiya va deserializatsiya haqida nima bilasiz?

Middle

Островок

Agar executor'da 10 yadro bo'lsa, bir vaqtning o'zida nechta vazifa parallel bajariladi?

Hozirgi ish joyingiz haqida gapirib bering: asosiy mahsulot, sizning funksiyangiz.

Menga qanday savollaringiz bor?

Data Quality uchun nima uchun tayyor motor, masalan Great Expectations o'rniga Python/Airflow'da maxsus skriptlar tanlandi?

1 000 va 1 000 000 qatorli jadvallar uchun hash join qanday ishlaydi?

Yozuvlar hashlarini taqqoslash usuli manba va maqsad jadvali orasidagi farqni hisoblash uchun qoʻllanildimi?

Kafka ning asosiy tushunchalari haqida gapiring (foydalanuvchilar guruhi, bo'linmalar, mavzular).

1. Buyurtmalar: - order_date datetime NULL emas - user_id int NULL emas - order_id int NULL emas 2. Mahsulotlar: - order_id int NULL emas - model int NULL emas - cat_1 varchar(50) NULL emas - price int NULL emas - quantity int NULL emas cat_1 qiymatlari: - Kiyim-kechak - Poyabzal - Kosmetika - Uy uchun mahsulotlar - O'yinchoqlar 2021 yilda "Kiyim-kechak" kategoriyasidagi va 2022 yilda "Poyabzal" kategoriyasidagi buyurtmalar va "kerakli kategoriyadagi mahsulotlar" sonini ko'rsating (oxirgi ko'rinish: 2 satr. Maydonlar: yil, mahsulotlar soni, buyurtmalar soni) with cte as( select year(o.order_date) as year_orders, g.cat_1, count(distinct o.order_id) as count_orders, sum(g.quantity) as count_quan from Orders o join Goods g on o.order_id = g.order_id where g.cat_1 = 'Kiyim-kechak' and Year(o.order_date) = 2021 or g.cat_1 = 'Poyabzal' and Year(o.order_date) = 2022 group by year_orders, g.cat_1 ) select year_orders, count_quan, count_orders from cte