Select the problem / Define the problem.
Create Tables with constraints
Design a Schema based on tables and explain the schema.
Create primary keys, foreign keys.
Use of the following Clauses:
Example : order by, between, group by, having, order by,
AND, OR, with
Use Aggregate Functions
Use of nested queries, Scalar Subquery.
Part 2 has to be done in HBASE
Create Tables – 4 tables with Column family and columns
Column family - 5 column families: Make sure have different parameter. Ex: versions
Minimum 4 Columns in each Column family
Perform basic queries like your assignment1
Try to extract data using timestamp
Insert partial data in a row
Check table status – enabled or disabled
Use count command to count the number of rows in a tables