No video
21 - Snowflake Data Warehouse Internals (CMU Advanced Databases / Spring 2023)
Рет қаралды 12,649
Жыл бұрынProf. Andy Pavlo (www.cs.cmu.edu/~pavlo/)
Slides: 15721.courses.cs.cmu.edu/spri...
15-721 Advanced Database Systems (Spring 2023)
Carnegie Mellon University
15721.courses.cs.cmu.edu/spri...
@gilpinim 10 ай бұрын
58:43 I'm super curious about Andy's opinion. too bad it's cut 😂😂
@HeIsVeryMinkas Жыл бұрын
Is that In Baltimore by K Mack in the intro? You got some good taste in hiphop.
@cambridgeNCT Жыл бұрын
Terrific Talk - Thanks. Same question as @taLin - "DBMS supports query plan hints" (47:09) ? I wasn't aware of that - is that true? That's completely against the grain if true.
@jmitesh01 7 ай бұрын
While Snowflake automatically clusters micro-partition in background what do the actual clustering key do to the Snowflake stored data? I'm guessing cluster key is rearrangment within a micro-partition i.e., How does query optimizer utilizes clustering key?
@talin331 Жыл бұрын
Hi Andy, Thanks a lot for the lecture! Can you please clarify what you mean by "DBMS supports query plan hints" (47:09) ? As far as I know because of Snowflake's philosophy "as a service" there are no hints and no plans to implement them. Thanks, Tania.
@ChuckLathrope Жыл бұрын
No runtime hints still. Maybe talking about how you can visually see the query plan as executed in query profile view and select nodes to focus in on in the new UI and also can get a plan given some sql with explain_json function.
@xinliang3113 7 ай бұрын
"59:00" The gang fight video is so funny!!! Where can I find this video online?
@jiqingtang2858 Жыл бұрын
Spills of the off camera discussions?
CMU Database Group
Рет қаралды 5 М.
CMU Database Group
Рет қаралды 9 М.
CNBC Television
Рет қаралды 13 М.
CMU Database Group
Рет қаралды 8 М.
Seattle Data Guy
Рет қаралды 149 М.
CMU Database Group
Рет қаралды 2,6 М.
CMU Database Group
Рет қаралды 10 М.