From the course: Presto Essentials: Data Science

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Access data with arrays

Access data with arrays - Presto Tutorial

From the course: Presto Essentials: Data Science

Start my 1-month free trial

Access data with arrays

- [Instructor] Now Presto is an advanced data platform that works with complex data types. If you are only used to working with relational databases, these next couple of clips might be a little bit abstract to you because you haven't come across this yet. But if you're more used to working with big data systems, this will be very familiar. And what I'm talking about here, specifically are array functions. So let's take a look and see what that even means. Let's log into Presto. and in Presto I want to create an array. So I can do so by saying select array. And I'll just give it some numbers here. Five, three, six, one, four. And what it did there is it created a complex data type. So again if you're not used to this you might be wondering what's going on and so often data is nested and this is specific to Jason data which comes in where you may have a customer record and that in database terms is one row and that customer may have many orders. Now, instead of having separate tables…

Contents