Data Engineer
A table structure is created as shown in the image. How to perform the query shown in the image? Which type of join should be used to fill the 'naming' column for records with type='table_aw' and 'serial_number' for type='table2'?
How to join two tables in SQL?
МТСAre you from Moscow? Have you lived here long? Why did you move to Moscow?
Tell us about yourself, where you worked, what you did, and interesting tasks and failures.
AstonHow to run a second Airflow DAG immediately after the first one successfully completes?
ОстровокOur topic is highly structured, tree-like, and the data is raw — how to process it?
МВидеоTop 3 criteria for choosing an offer if there are multiple proposals.
You work with Data Science and big data processing — is there a replacement in this library written in Rust, multithreaded, unlike Pandas, very fast. Do you know such?
МВидеоWhat is Spark JDBC and how to efficiently load a large table through it?
What is the purpose of a foreign key constraint and what is the meaning of delete/update restrictions when dependent records exist?
How are your dbt models structured and how do you assemble a data mart from multiple sources through Trino?
Have you worked with type annotations? Do you know what they are?
МТСHow is QA (quality assurance) organized in your process?
Which version of Airflow have you worked with?
[name] asked: How to implement data retention for only 2 years in ClickHouse?
How does the broadcast mechanism physically work — how do partitions of a small table get to executors with a large table?
What is important to you in your future work?
You have a query that performs poorly, slowly, or crashes — how to optimize it?
МВидеоWhat visualization tools have you worked with and how closely have you worked with Power BI?
What issues have you encountered working with Greenplum?