If you're familiar with SQL you'll have no issues working in Apache Phoenix. Out of the box, however, this platform doesn't know about all of our HBase assets. In this video you learn to create a view on top of the HBase sales table and then run some quer
- [Instructor] Now that we're in Apache Phoenix…we can take a look around,…and start working with some data assets here…that are already existing as well as creating our own.…So, first, if I just wanted to see what's there…I'll type the command pound…which is exclamation mark, and tables.…And from here you'll see what's going on.…Now notice that we don't have a…table for our sales database,…and while we created that in Hbase…Apache Phoenix doesn't know about that yet.…We actually need to create this table in Apache Phoenix…even though it's just a logical connection…meaning we're just defining what it is,…and that way it'll know where to get the data…from HBase and how to treat it.…
So to do this I'm actually going to…start by creating a view.…This way I'm not modifying the underlying system table.…I'm just having a logical view on top of it to work with.…So I'll type create view,…and then in double quotes sales…open paran…type row…for the first column,…and this is a varchar,…and primary key.…If you recall we never added data types in HBase,…
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