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
35 freelancers are bidding on average $141 for this job
HI I am sql database ,Big Data professional who has industry extensive experience in several databases. I can give training , support, in any project and resolve your work asap. Hope to meet you soon. Thank you.