mikulskibartosz.name
About me
Newsletter
efficacious.engineering
mlops.today
Bartosz Mikulski
Building trustworthy data pipelines because AI cannot learn from dirty data
All Stories
How to purge a Kafka topic
How to remove all messages from a Kafka topic
Get the last day of the month in Redshift
How to use the last_day function in Redshift
How to make an unconditional join in Redshift
LEFT OUTER JOIN ON 1=1 in Redshift
How to count the number of rows that match a condition in Redshift
How to count the rows by multiple conditions at the same time in SQL
How to index data in Redshift
How to create an equivalent of an index in Redshift
How to generate a sequence of dates in Redshift
How to use the generate_series function to generate a sequence of dates
How to assign rows to ranked groups in AWS Athena
How to use the NTILE function in Athena
How to define an AWS Athena view using Airflow
How to use the AWSAthenaOperator
How to write Hive queries with column position number in the GROUP BY or ORDER BY clauses
How to enable column position support in Hive GROUP BY or ORDER BY
How to check whether a regular expression matches a string in Hive
What is the equivalent of Athena/Presto regexp_like in Hive
How to check whether a YARN application has finished
How to use Airflow PythonSensor to check whether a YARN application finished running
How to use WHEN CASE queires in AWS Athena
Using conditions in AWS Athena queries
« Prev
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
Next »
About me
|
Newsletter