Basics of Google Cloud Bigtable

For our Cloud Bigtable instance:

1. Create a Bigtable instance with the name vehicle-locations.
2. Make sure HDD is selected for our instance.
3. For Region, choose us-east1 and set the Zone as Any.
4. Make sure the number of nodes listed is 1.

To connect to Bigtable with HBase:

1. From the top of the GCP dashboard, click the Activate Cloud Shell button (the square button with >_ in it).
2. Using sudo, update the cloud shell and install the Java 8 runtime for HBase.
3. Clone the Bigtable examples repo: https://github.com/GoogleCloudPlatform/cloud-bigtable-examples.git
4. Change to the cloud-bigtable-examples/quickstart directory.
5. Run the quickstart.sh script to set up a connection. Don't worry about any errors or warnings, as the script should pick up your project's Bigtable instance and drop you into a connected HBase shell.

Don't disconnect! Stay in the HBase shell for the next objective.

We need to create a table using the provided information and then query that data with HBase:

1. Create a table named vehicles with column groups called loc and det.
2. Enter the following details into the table for our two vehicles, placing the Lat and Long data in the loc column group, and the Company and Route data in the det column group:

| Row Key |            Lat            |            Long            |    Company    | Route  | |---------------- |:----------------: |:-----------------: |:---------: |:-------:| | M117-223 | 40.781212 | -73.961942 | NYMT | 86 | | M117-391 | 40.780664 | -73.958357 | NYMT | 88 |

3. Use get to pull a single row using a row key.
4. Scan the entire table.
5. Find all vehicles assigned to Route 88 using a ValueFilter with a regexstring. Note: This is an example of an extremely inefficient way to search the database. The entire table needs to be read to find matching rows.
6. Perform a scan for the second vehicle using the ROWPREFIXFILTER filter and the first 6 characters from the Row Key column.