Data Engineer

What issues have you encountered working with Greenplum?

What types of keys/distribution strategies exist in Greenplum?

What are decorators in Python?

How to properly open and close files in Python using a context manager?

What distribution strategies for data exist?

Is it possible to create and apply a decorator without the @ syntax?

What types of partitions are there?

How did you work with files when restarting the DAG after it failed, to avoid overwriting data in S3 with incomplete data?

What physically happens during INSERT, UPDATE, and DELETE in Greenplum; why is disk space not freed after DELETE and how does DELETE differ from TRUNCATE?