Тёмный

5 ways that DuckDB makes SQL better 

Learn Data with Mark
Подписаться 10 тыс.
Просмотров 9 тыс.
50% 1

In this video, you'll learn 5 ways that DuckDB has made SQL better, including 'FROM..SELECT' and 'GROUP BY ALL'.
#dataengineering #duckdb
Blog post - duckdb.org/202...

Опубликовано:

 

5 окт 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 18   
@michaelhunger6160
@michaelhunger6160 Год назад
Soo good Mark, love that they have the select last and group by all (which could be inferred) like in Cypher.
@kylebaker8502
@kylebaker8502 9 месяцев назад
Thanks for the tips, just looking into DuckDB, nice to see these quality of life features.
@andynelson2340
@andynelson2340 Год назад
These are great, love DuckDB syntax.
@CaribouDataScience
@CaribouDataScience Год назад
One of my favorites (which you mentioned) is read_csv_auto() which includes the ability to read files from the internet.
@learndatawithmark
@learndatawithmark Год назад
That's definitely a cool one as well!
@danieleden1856
@danieleden1856 Год назад
Awesome video of very useful shortcuts, thanks Mark!
@learndatawithmark
@learndatawithmark Год назад
No worries!
@billash5132
@billash5132 Год назад
group by all I had no idea 🙏🙏🙏
@learndatawithmark
@learndatawithmark Год назад
They even added that feature to Snowflake now, so DuckDB is leading the charge!
@gsnaveen2
@gsnaveen2 15 дней назад
Thanks!
@learndatawithmark
@learndatawithmark 13 дней назад
Thank you! Very kind
@cosmos177
@cosmos177 2 месяца назад
I'd give the features a ranking of 2,3,4,4,5 out of 10. cheers.
@learndatawithmark
@learndatawithmark 2 месяца назад
You are a tough one to please! 😄
@cosmos177
@cosmos177 2 месяца назад
@@learndatawithmark Sorry ... Felt most ware cosmetic... a bit of fluff.. However i later saw your PIVOT and UNPIVOT videos... and they were really excellent. Both in terms of DuckDb syntax /features and also your example/content. Thanks for the videos. New subscriber. cheers.
@kuatroka
@kuatroka Год назад
could you explain again the REPLACE functionality and the use case in your precise example? I did't get it. Thanks
@learndatawithmark
@learndatawithmark Год назад
So for that one, I wanted to return all the fields, but I wanted to apply a transformation to a couple of those fields and have it effectively replace them in-line. Does that makes sense?
@AtomicPixels
@AtomicPixels 6 месяцев назад
Ha sql is so basic already I am not feeling bad for the guy that has to have to type the word SELECT. Big boo hoo. Try to install a JavaScript package and not die of old age before you begin coding the project itself
@geoffreyvanwyk4588
@geoffreyvanwyk4588 6 месяцев назад
Maybe the JavaScript package management system is such a pain because the developers suffered psychological damage from having to write SELECT first for all those years.
Далее
Querying DuckDB with PRQL
6:39
Просмотров 3,4 тыс.
Why should you care about DuckDB? ft. Mihai Bojin
14:35
UUID vs INT: What’s Better For Your Primary Key?
9:40
Why use DuckDB in your data pipelines ft. Niels Claeys
22:26
DuckDB and SQL - for Data Analysis and Processing
24:31