Sobes.tech

Data Engineer

Where can I view task logs in Airflow?

Middle
484

How can data be transferred when migrating a materialized view from Greenplum to ClickHouse?

460

What types of databases do you know?

Middle
447

Given two tables t1 and t2. List all types of joins you know, and the result of the query select * from t1 <join> t2 on t1.t = t2.t for each. |t1.t| ------ 1 2 4 null ------ |t2.t| ------ 1 3 null null

443

[name] tell us about your current project: what did you do, what interesting tasks, technologies, and the complexity of the project.

442

How does the query optimizer in Oracle work, what does it consider, and to which class does it belong?

Middle
438

What is the difference between RANK() and DENSE_RANK()?

411

What does the window function LEAD do in SQL?

Middle
411

How can an SQL injection occur through a date input field?

401

Describe an end-to-end technical task: from source to storefront, including layers and actions at each stage.

390

How does ClickHouse work and how does it differ from PostgreSQL?

Middle
387

Tell about your recent work experience, what projects, what stack?

Middle+
385

What is the purpose of slicing data into blocks in HDFS?

Middle
368

How does Pandas handle missing data?

Middle
365
/38