ClickHouse - Data Engineer 挂经

ClickHouse应该是现在全球最红的data公司了吧

面的是data warehouse组的Data Engineer，感觉这个组只考SQL，对SQL要求很高，job description也写的很清楚 SQL需要特别特别特别熟练，hiring manager是一个俄罗斯大叔，很友善，整个面试过程很轻松愉快。问了很多八股，虽然有些题我答的不太好，但面试官全程给了很多guidance。

SQL部分：
Explain the difference between UNION and UNION ALL, which one would you choose?
Explain left anti join, and write 3 different versions of left anti join

应该是以下三种方法：
SELECT *
FROM tableA a
LEFT JOIN tableB b ON b.user_id = a.user_id
WHERE b.user_id IS NULL

SELECT *
FROM tableA a
WHERE NOT EXISTS (

您好！
本帖隐藏的内容需要积分高于 188 才可浏览
您当前积分为 0。
使用VIP即刻解锁阅读权限或查看其他获取积分的方式

游客，您好！
本帖隐藏的内容需要积分高于 188 才可浏览
您当前积分为 0。
VIP即刻解锁阅读权限 或 查看其他获取积分的方式
Unlock interview details and practice with AI
Curated Interview Questions from Top Companies

ws of data. He said we should take max/min per hour per plane_id)

What is slowly changing dimension?

How would you model many-to-many relationships? (bridge table)


两天后收到拒信，recruiter给的feedback是 lacked in some critical areas  such as data modeling fundamentals and analytical SQL.

祝大家好运多多！offer满满！