Aggregating data to more concise data sets is a useful technique when you have a known output your users are looking for. In this video you can see how to create a new table through Apache Phoenix and load it with aggregate data from a select query.
- [Instructor] If we wanted to build other tables…on top of our view right here,…we can do so just as we would in a regular SQL database.…So let's go ahead now and build something…that will aggregate some data…up to the monthly level for us.…First, I'm going to type select,…then I'm going to say substr, for substring,…a common function we've used to parse strings.…Give it the column we want to parse, which is orderDate,…and give it where to start and where to end.…
We'll say from sales and we'll limit 10…just to take a look and see what the data comes back as.…So you can see here, what we have in this column…is the year-month,…now if we add on to this with an aggregation…we'll be essentially creating monthly totals.…So let's do that now.…Select substring orderDate,…comma one comma seven.…We'll call it as mt, so we're giving the column an alias,…comma, count of one.…
We'll call this orders, so as orders,…this is coming from the sales table.…Now because we have an aggregation…of course we need to do a group by, so group by,…
This course can help professionals further their career in big data analytics using HBase and the Hadoop framework. Learn to describe HBase in the context of the NoSQL landscape, build simple architecture models, and explore basic HBase commands. Instructor Ben Sullins shows how all the concepts fit together, resulting in the kind of distributed big data storage you need for scalable, enterprise-level applications.
- What is HBase?
- Who uses HBase?
- Comparing HBase and an RDBMS
- How data is stored in HBase
- Data model operations
- HBase architecture
- Creating tables
- Querying data