950 karma · joined February 5, 2009
[ my public key: https://keybase.io/alexott; my proof: https://keybase.io/alexott/sigs/YGbMyjTEeMg-ketys_027-WJuGoEn-vKmE1jZ-213tQ ]
- transactions - you don't get a garbage in your table if your write failed
- supports update/delete/merge operations (in some implementations)
- metadata allows faster discovery of data, for example, if you have a lot of partitions on the cloud storage.
- metadata also allow to support features like data skipping, when you can filter out files that doesn't contain necessary data
- time travel - you can get back to previous versions of the tables
I’ll try to find time to do it myself, but most probably only tomorrow
Second thing, for example it didn’t work with compound objects. Especially for things like word embedded in excel, etc. Similar for XML-based types, zip-based, …
Plus rules aren’t very flexible - I’d used lisp-like language to describe detection patterns - that made it quite flexible in describing complex detection logic.
Extraction of content is a separate fun ;-)
when you run Python, it's on Spark, although you now can use Photon engine that is used for DB SQL by default