Parquet File Format - Explained to a 5 Year Old!

[@WhisperingDeath]

"it takes a long time to make a story short" With so many hour-long techtube vids I appreciate how clear and concise you explained this topic!

[@DataMozart]

Thank you, I'm glad to hear that!

[@ДаниилИмани]

00:00 - introduction 02:05 - advantages of apache parquet format 03:06 - row-based 04:06 - column-based storage 05:01 - parquet storage; row groups 05:43 - projection and predicate(s) 07:07 - how parquet knows which row group to scan 07:30 - performance tip about optimal parquet file size 08:31 - data compression in parquet 10:04 - Delta format

[@williamknox8438]

THANK YOU! THIS HAS TO BE THE 12TH VIDEO I'VE WATCHED ON PARQUET AND I FINALLY UNDERSTAND.

[@DataMozart]

I'm happy to hear that! Cheers!

[@f00tballfever]

@@DataMozart awesome video. super easy to follow. would be amazing if you could upload more video like these with ELI5 format.

[@DatahaiBI]

Great video! Clear explanation of parquet

[@DataMozart]

Thanks a lot!

[@nemmanja0289]

great detailed explanation in short time, well done!

[@DataMozart]

Hvala Nemanja!

[@JB-ve8sk]

This was helpful - appreciate your time putting it together!

[@DataMozart]

Glad you enjoyed it!

[@kizzashadrackyawe9646]

Great explanations! Thank you!

[@DataMozart]

You're very welcome!

[@danielhd6719]

That was the best explanation for that format blin

[@DataMozart]

Thanks, happy to hear that!

[@murugesanrajasekaran5032]

Wry concise and clear tutorial. Keep up the great work. Subscribed

[@DataMozart]

Awesome, thank you!

[@Truthhurt419]

This is really awesome and simple explanation. Thanks for doing it

[@DataMozart]

You're very welcome, glad you liked it!

[@sophiehan6121]

awesome video, the best video explaining parquet file!

[@DataMozart]

Glad it was helpful!

[@agustinluengo3323]

It was exactly the video that I was looking for, thank you!

[@DataMozart]

Thanks, I'm happy to hear that!

[@venukumargadiparthy8233]

Can you also please create a video on avro and orc file format?

[@DataMozart]

It's on my to-do list

[@venukumargadiparthy8233]

@@DataMozart yeah , waiting for this.

[@KannanKalidasan]

Best and clear explanation of parquet format

[@DataMozart]

Glad you think so! Thanks!

[@rorycawley]

what about Apache Iceberg?

[@satyajit015]

awesome video with a great detailing. Thanks a lot for explaining.

[@DataMozart]

You are welcome! Glad you find it useful

[@felipecujar5688]

Awesome explanation! Thanks for it man !

[@DataMozart]

Cheers! Happy you found it useful

[@jamesmcewan]

good summary! well done 😉

[@DataMozart]

Thanks! 😃

[@dimitrigbo823]

Excellent video... Big thanks!!!

[@DataMozart]

You are welcome! I'm glad you liked it👍

[@rupaghosh6251]

Just an outstanding explanation

[@DataMozart]

Thank you, I'm happy to hear that!

[@edwardhicks630]

Incredible summary, thank you!!

[@DataMozart]

Glad you liked it!

[@loisiling5782]

Thank you so much!!!! Its such a good explanation!

[@DataMozart]

Glad it was helpful!

[@marijakiran]

This is fire! Thank you so much!

[@DataMozart]

Glad you like it!

[@mikitaarabei]

Great content, Thank You!

[@DataMozart]

Glad you liked it!

[@vivek5794-b2z]

Wow very detail explanation

[@DataMozart]

Glad you liked it

[@keviny9392]

Thank you ... very easy to understand.

[@DataMozart]

Glad to hear that!

[@pradyumnakumaragasthyaraju8474]

great video!

[@DataMozart]

Glad you enjoyed it

[@dishantkukreja5899]

Great Video, Thankyou!

[@DataMozart]

You're welcome! Happy to hear that you like it!

[@njacob4338]

Loved the "parquet format on steroids" analogy!

[@DataMozart]

Thank you!

[@joaovictorf.r.s.1570]

Thank you! Great Video!

[@DataMozart]

Thanks Joao, glad to hear that!

[@AyushSrivastava-gh7tb]

You're the best!

[@DataMozart]

Thanks!

[@ovidiuandrei6013]

thanks man 😊

[@DataMozart]

No problem 👍

[@roshankumargupta46]

Very apt!

[@DataMozart]

Thanks!

[@xianminxu8278]

well explained

[@DataMozart]

Thank you, I'm glad if it helps!

[@FranciscoGarofalo-mb3ud]

nice video

[@DataMozart]

Thank you!

[@FedericoLov]

So basically it's vertipaq but open source

[@DataMozart]

A kind of! But, yes, very similar to how VertiPaq stores the data

[@rahulvashishth8551]

nice explanation, only first one minute was unnecessary.

[@DataMozart]

Glad you liked it

[@ahmettek315]

You didn't really explain it to a 5 year old. I am older than that, have experience with databases including low level storage, have a proven IQ level over the average but I am still at a lost after your video. So what does a parquet file look like physically? How do you create a parquet file? Answers to such questions are missing.

[@DataMozart]

Really sorry that you didn't find the video useful:(

[@andreiberes9442]

proven IQ level over average =)))))