Bloom filters allow you to prune the number of files you even have to look at, which matters a lot when there is a coat associated with scanning the files.
Partitioning the data can be advantageous both for pruning (on its sort keys) or for parallel query fan-out (you independently scan and apply the predicate to the high cardinality column in each partition concurrently).
In the use case that underpins the article, they want to minimize unnecessary access to parquet file data because it lives on a high latency storage system and the compute infrastructure is not meant to be scaled up to match the number of partitions. So they just want an index to help find the data in the high cardinality column
Such declarations MUST be preceded by the comment:
# I DECLARE
The only time I’ve seen them mentioned is in news reports about their existence as a campaign, never actual usage.
Another interesting campaign around corruption is ipaidabribe.com to gain some data around this. Unfortunately, both giving and taking bribes is illegal, thus you need anonymity for reports resulting in a lower data quality.
To fix that, there’s proposals to make it legal to pay “harassment bribes” (the ones where the bribe giver does not gain undue advantage).
> Giving complete immunity to the bribe-giver would ensure higher reporting and co-operation of the giver in bringing to justice the bribe taker. The present law acts as a deterrent to reporting of bribery.
https://prsindia.org/theprsblog/should-bribe-giving-be-legal...
once I started working with DaVinci.. game changer, from start to finish, with some advanced motion tracking, title overlays, in less than a few hours. Upside is also that there are plenty of tutorials available for DaVinci, from beginner to advanced
https://www.blackmagicdesign.com/products/davinciresolve/edi...
- Kdenlive is also a fairly capable video editor. https://kdenlive.org/en/
- From what I have heard the Blender video editor for many people is a go to tool as well. In this case it likely would have been overkill, but figured it is worth mentioning.
And yes, Blender would have been overkill, but I might've gone that route if Openshot didn't work out.
- Opening Movie Maker redirects to the Photos app, with a note that Microsoft Clipchamp has this functionality now and Movie Maker is deprecated.
- Install Clipchamp and see that its hilariously bad at batch-adding clips to the timeline. Adding 300 clips, one at a time, is a dealbreaker.
- Look up reviews for free 3rd party apps to do this on Windows. Find everyone recommending DaVinci Resolve. Fine. Install Resolve. Looks great. Import my clips, and get only audio. A quick Google search tells me that Resolve free version doesn't support importing 10-bit video. Welp.
- Let's try FOSS then. Shotcut is supposedly better than Openshot. Install Shotcut. Import all clips, add to timeline and export. Takes a few hours to export, displays a Success message and gives me the first few seconds of video, followed by a couple of hours of just audio.
- F** it, let's try Openshot. Hesitant because I've heard a lot of crashing happens, but what do I have to lose. Install. Import clips. Add to timeline. Let's me add transitions. Export takes a few hours. Gives me flawless output file.
Moral of the story: For occasional amateur video editing, Openshot is great.
D sharp is slightly higher in pitch than Eb in Pythagorean tuning.
For eg: Bb major uses: Bb C D Eb F G A Bb while A# major uses: A# B# Cx D# E# Fx Gx A# (x indicates double-sharp) Despite all the notes being exactly the same on a tempered instrument.