Exercises 6.1, 6.2, and 6.3 using Hive.  customer_id customer_name customer_zip 8-9-000 Maggie 47401 5-6-777 Nora 60640 1-2-333 Tina 60137 9-0-111 Ry

/ Computer Science / By
Exercises 6.1, 6.2, and 6.3 using Hive. 
customer_id customer_name customer_zip
8-9-000 Maggie 47401
5-6-777 Nora 60640
1-2-333 Tina 60137
9-0-111 Ryan 46202
6-7-888 Miles 60602
2-3-444 Tony 60611
3-4-555 Pam 35401
7-8-999 Neil 55403
4-5-666 Elly 47374
0-1-222 Dan 55499
product_id t_id no_of_items
2X1 T303 2
1X3 T666 2
4X1 T707 2
3X4 T707 4
2X4 T404 1
4X4 T444 1
3X3 T011 3
1X1 T333 1
2X3 T888 3
8X8 T999 3
3X3 T808 4
2X4 T202 4
3X3 T333 5
4X2 T909 3
8X8 T777 1
1X2 T999 5
1X1 T111 1
6X6 T555 1
2X2 T606 3
4X3 T808 1
4X4 T555 4
2X2 T022 3
2X2 T808 1
7X7 T666 1
4X4 T606 2
5X5 T555 2
2X4 T606 7
2X1 T505 4
2X2 T444 2
3X1 T606 4
5X3 T808 1
3X2 T707 1
9X9 T666 1
1X2 T101 3
4X2 T808 1
2X2 T505 3
1X4 T888 4
3X1 T303 2
6X6 T909 1
1X4 T101 1
4X3 T022 3
2X3 T404 2
3X4 T606 2
9X9 T303 3
1X4 T303 2
1X3 T999 1
9X9 T999 1
5X1 T022 2
3X2 T505 1
2X2 T222 1

building_id no_of_floors manager_id
B100 5 M120
B200 6 M230
B400 14 M340
B300 4 M230

supplier_id supplier_name
PG Pacifica Gear
WL Wilderness Limited
OA Outdoor Adventures
MK Mountain King

client_id client_name client_industry client_location
2220 Skyline Airline OakRidge
8880 SouthTravel Tourism Chattanooga
7770 LightRecords Music Chicago
1110 Harmony Music Nashville

t_id customer_id store_id t_year
T999 4-5-666 S6 2020
T707 5-6-777 S4 2020
T111 1-2-333 S1 2020
T404 8-9-000 S6 2020
T505 6-7-888 S14 2020
T444 3-4-555 S3 2020
T808 7-8-999 S9 2020
T888 8-9-000 S4 2020
T011 8-9-000 S7 2020
T666 5-6-777 S10 2020
T909 5-6-777 S4 2020
T333 1-2-333 S3 2020
T606 0-1-222 S11 2020
T222 2-3-444 S2 2020
T202 0-1-222 S8 2020
T022 9-0-111 S5 2020
T303 4-5-666 S6 2020
T555 2-3-444 S3 2020
T777 6-7-888 S13 2020
T101 7-8-999 S12 2020
product_id product_name product_price supplier_id category_id
3X4 Treado Tire 30.00 OA CY
1X4 Safe-T Helmet 40.00 PG CY
3X2 Bucky Knife 60.00 WL CP
2X4 Strongster Carribeaner 20.00 MK CL
5X1 Simple Sandal 50.00 PG FW
7X7 Hi-Tec GPS 300.00 OA EL
4X3 Mega Camera 275.00 WL EL
6X6 Biggy Tent 250.00 MK CP
2X1 Mmm Stove 80.00 WL CP
5X2 Action Sandal 70.00 PG FW
5X5 Tiny Tent 150.00 MK CP
4X2 Electra Compass 45.00 MK EL
9X9 Trusty Rope 30.00 WL CL
3X1 Sleepy Pad 25.00 WL CP
3X3 Cosy Sock 15.00 MK FW
2X3 Reflect-o Jacket 35.00 PG CY
4X1 Slicky Tire 25.00 OA CY
8X8 Power Pedals 20.00 MK CY
5X3 Luxo Tent 500.00 OA CP
4X4 Dura Boot 90.00 PG FW
1X3 Sunny Charger 125.00 OA EL
2X2 Easy Boot 70.00 MK FW
1X1 Zzz Bag 100.00 PG CP
1X2 Comfy Harness 150.00 MK CL

manager_id manager_firstname manager_lastname manager_yob manager_salary manager_bonus
M230 Fred Lee 1975 80000.00 5000.00
M120 Larry Long 1980 72000.00 ?
M340 George Shetuni 1976 52000.00 2000.00

1 Craig Martin 733 Manitowish Circle MN Minnesota 94341-2567 1955 M FALSE TRUE FALSE
9 Susan Mitchell 862 Grasskamp Parkway IA Iowa 57931 1959 F FALSE FALSE TRUE
12 Anna Owens 52717 Portage Plaza IL Illinois 43011-8911 1982 F FALSE TRUE FALSE
16 Tammy Coleman 85703 Walton Street ME Maine 92291 1966 F FALSE FALSE TRUE
17 Steven Hayes 14871 Homewood Avenue TX Texas 74737 1952 M TRUE FALSE TRUE
19 Andrew Arnold 53 Pine View Street CA California 43566 1963 M TRUE TRUE FALSE
25 Angela Knight 00 5th Parkway CA California 88766-1510 1958 F FALSE TRUE FALSE
27 Debra Scott 3516 Oxford Court NC North Carolina 27465 1989 F FALSE TRUE FALSE
28 Jennifer Robinson 51 Hallows Court CA California 34772-5235 1989 F TRUE FALSE FALSE
30 Andrea Rice 92 Lake View Drive CA California 63273-3249 1958 F TRUE FALSE FALSE
33 Samuel Oliver 52 Swallow Plaza IN Indiana 36867-2654 1962 M FALSE FALSE TRUE
34 Wanda Rice 9 New Castle Avenue CT Connecticut 45909 1992 F FALSE TRUE FALSE
36 Joseph Kelly 2 Buhler Terrace CA California 94011 1972 M TRUE TRUE TRUE
37 Sara Sanders 07 Lunder Lane NJ New Jersey 92985-9493 1955 F TRUE TRUE TRUE
39 Alan Romero 35 Schurz Drive CA California 42247 1973 M FALSE FALSE TRUE
40 Juan Carpenter 6 Buhler Trail CA California 8707

</t

4001 258682168-8 23-08-2018 TRUE
3810 509003229-7 28-09-2020 TRUE
980 666166456-8 07-01-2020 FALSE
3636 672200018-4 13-12-2017 TRUE
3993 221072623-9 13-09-2020 TRUE
3986 472421148-2 27-09-2020 FALSE
4023 350722979-X 28-11-2018 FALSE
987 807104140-8 31-05-2018 TRUE
4125 430655138-5 15-07-2020 TRUE
3988 196773597-2 04-12-2019 TRUE
3890 920047281-8 07-08-2019 TRUE
3988 958299685-4 23-04-2018 FALSE
3813 382574499-X 19-07-2020 TRUE
4118 999841757-0 05-01-2018 FALSE
3690 513542805-4 23-08-2019 TRUE
3909 389819691-7 27-12-2017 FALSE
4047 963525580-2 10-12-2019 TRUE
3814 995419681-1 08-12-2019 FALSE
3913 450921865-6 31-12-2018 TRUE
84 427338796-4 19-10-2018 TRUE
3639 560183180-7 03-03-2020 TRUE
3724 711197646-0 08-04-2018 TRUE
3992 889581064-3 26-07-2019 FALSE
83 900521803-7 07-08-2019 FALSE
982 265483963-X 26-05-2019 TRUE
78 480975468-5 11-05-2018 TRUE
4148 464193915-2 26-01-2019 TRUE
3633 155528332-2 30-01-2019 FALSE
4073 527561887-5 12-01-2019 FALSE
3786 762026239-3 02-07-2019 TRUE
86 301127668-4 28-06-2019 FALSE
110 334607264-9 12-03-2020 TRUE
65 469586352-9 20-01-2020 FALSE
3758 086476611-4 12-10-2017 TRUE
4006 472575199-5 05-12-2017 FALSE
3231 705165445-4 15-09-2018 FALSE
4037 238108087-2 17-06-2018 FALSE
Exercises 6.1, 6.2, and 6.3 using Hive.  customer_id customer_name customer_zip 8-9-000 Maggie 47401 5-6-777 Nora 60640 1-2-333 Tina 60137 9-0-111 Ryan 46202 6-7-888 Miles 60602 2-3-444 Tony 60611 3-4-555 Pam 35401 7-8-999 Neil 55403 4-5-666 Elly 47374 0-1-222 Dan 55499 product_id t_id no_of_items 2X1 T303 2 1X3 T666 2 4X1 T707 2 3X4 T707 4 2X4 T404 1 4X4 T444 1 3X3 T011 3 1X1 T333 1 2X3 T888 3 8X8 T999 3 3X3 T808 4 2X4 T202 4 3X3 T333 5 4X2 T909 3 8X8 T777 1 1X2 T999 5 1X1 T111 1 6X6 T555 1 2X2 T606 3 4X3 T808 1 4X4 T555 4 2X2 T022 3 2X2 T808 1 7X7 T666 1 4X4 T606 2 5X5 T555 2 2X4 T606 7 2X1 T505 4 2X2 T444 2 3X1 T606 4 5X3 T808 1 3X2 T707 1 9X9 T666 1 1X2 T101 3 4X2 T808 1 2X2 T505 3 1X4 T888 4 3X1 T303 2 6X6 T909 1 1X4 T101 1 4X3 T022 3 2X3 T404 2 3X4 T606 2 9X9 T303 3 1X4 T303 2 1X3 T999 1 9X9 T999 1 5X1 T022 2 3X2 T505 1 2X2 T222 1 building_id no_of_floors manager_id B100 5 M120 B200 6 M230 B400 14 M340 B300 4 M230 supplier_id supplier_name PG Pacifica Gear WL Wilderness Limited OA Outdoor Adventures MK Mountain King client_id client_name client_industry client_location 2220 Skyline Airline OakRidge 8880 SouthTravel Tourism Chattanooga 7770 LightRecords Music Chicago 1110 Harmony Music Nashville t_id customer_id store_id t_year T999 4-5-666 S6 2020 T707 5-6-777 S4 2020 T111 1-2-333 S1 2020 T404 8-9-000 S6 2020 T505 6-7-888 S14 2020 T444 3-4-555 S3 2020 T808 7-8-999 S9 2020 T888 8-9-000 S4 2020 T011 8-9-000 S7 2020 T666 5-6-777 S10 2020 T909 5-6-777 S4 2020 T333 1-2-333 S3 2020 T606 0-1-222 S11 2020 T222 2-3-444 S2 2020 T202 0-1-222 S8 2020 T022 9-0-111 S5 2020 T303 4-5-666 S6 2020 T555 2-3-444 S3 2020 T777 6-7-888 S13 2020 T101 7-8-999 S12 2020 product_id product_name product_price supplier_id category_id 3X4 Treado Tire 30.00 OA CY 1X4 Safe-T Helmet 40.00 PG CY 3X2 Bucky Knife 60.00 WL CP 2X4 Strongster Carribeaner 20.00 MK CL 5X1 Simple Sandal 50.00 PG FW 7X7 Hi-Tec GPS 300.00 OA EL 4X3 Mega Camera 275.00 WL EL 6X6 Biggy Tent 250.00 MK CP 2X1 Mmm Stove 80.00 WL CP 5X2 Action Sandal 70.00 PG FW 5X5 Tiny Tent 150.00 MK CP 4X2 Electra Compass 45.00 MK EL 9X9 Trusty Rope 30.00 WL CL 3X1 Sleepy Pad 25.00 WL CP 3X3 Cosy Sock 15.00 MK FW 2X3 Reflect-o Jacket 35.00 PG CY 4X1 Slicky Tire 25.00 OA CY 8X8 Power Pedals 20.00 MK CY 5X3 Luxo Tent 500.00 OA CP 4X4 Dura Boot 90.00 PG FW 1X3 Sunny Charger 125.00 OA EL 2X2 Easy Boot 70.00 MK FW 1X1 Zzz Bag 100.00 PG CP 1X2 Comfy Harness 150.00 MK CL manager_id manager_firstname manager_lastname manager_yob manager_salary manager_bonus M230 Fred Lee 1975 80000.00 5000.00 M120 Larry Long 1980 72000.00 ? M340 George Shetuni 1976 52000.00 2000.00 1 Craig Martin 733 Manitowish Circle MN Minnesota 94341-2567 1955 M FALSE TRUE FALSE 9 Susan Mitchell 862 Grasskamp Parkway IA Iowa 57931 1959 F FALSE FALSE TRUE 12 Anna Owens 52717 Portage Plaza IL Illinois 43011-8911 1982 F FALSE TRUE FALSE 16 Tammy Coleman 85703 Walton Street ME Maine 92291 1966 F FALSE FALSE TRUE 17 Steven Hayes 14871 Homewood Avenue TX Texas 74737 1952 M TRUE FALSE TRUE 19 Andrew Arnold 53 Pine View Street CA California 43566 1963 M TRUE TRUE FALSE 25 Angela Knight 00 5th Parkway CA California 88766-1510 1958 F FALSE TRUE FALSE 27 Debra Scott 3516 Oxford Court NC North Carolina 27465 1989 F FALSE TRUE FALSE 28 Jennifer Robinson 51 Hallows Court CA California 34772-5235 1989 F TRUE FALSE FALSE 30 Andrea Rice 92 Lake View Drive CA California 63273-3249 1958 F TRUE FALSE FALSE 33 Samuel Oliver 52 Swallow Plaza IN Indiana 36867-2654 1962 M FALSE FALSE TRUE 34 Wanda Rice 9 New Castle Avenue CT Connecticut 45909 1992 F FALSE TRUE FALSE 36 Joseph Kelly 2 Buhler Terrace CA California 94011 1972 M TRUE TRUE TRUE 37 Sara Sanders 07 Lunder Lane NJ New Jersey 92985-9493 1955 F TRUE TRUE TRUE 39 Alan Romero 35 Schurz Drive CA California 42247 1973 M FALSE FALSE TRUE 40 Juan Carpenter 6 Buhler Trail CA California 8707 4001 258682168-8 23-08-2018 TRUE 3810 509003229-7 28-09-2020 TRUE 980 666166456-8 07-01-2020 FALSE 3636 672200018-4 13-12-2017 TRUE 3993 221072623-9 13-09-2020 TRUE 3986 472421148-2 27-09-2020 FALSE 4023 350722979-X 28-11-2018 FALSE 987 807104140-8 31-05-2018 TRUE 4125 430655138-5 15-07-2020 TRUE 3988 196773597-2 04-12-2019 TRUE 3890 920047281-8 07-08-2019 TRUE 3988 958299685-4 23-04-2018 FALSE 3813 382574499-X 19-07-2020 TRUE 4118 999841757-0 05-01-2018 FALSE 3690 513542805-4 23-08-2019 TRUE 3909 389819691-7 27-12-2017 FALSE 4047 963525580-2 10-12-2019 TRUE 3814 995419681-1 08-12-2019 FALSE 3913 450921865-6 31-12-2018 TRUE 84 427338796-4 19-10-2018 TRUE 3639 560183180-7 03-03-2020 TRUE 3724 711197646-0 08-04-2018 TRUE 3992 889581064-3 26-07-2019 FALSE 83 900521803-7 07-08-2019 FALSE 982 265483963-X 26-05-2019 TRUE 78 480975468-5 11-05-2018 TRUE 4148 464193915-2 26-01-2019 TRUE 3633 155528332-2 30-01-2019 FALSE 4073 527561887-5 12-01-2019 FALSE 3786 762026239-3 02-07-2019 TRUE 86 301127668-4 28-06-2019 FALSE 110 334607264-9 12-03-2020 TRUE 65 469586352-9 20-01-2020 FALSE 3758 086476611-4 12-10-2017 TRUE 4006 472575199-5 05-12-2017 FALSE 3231 705165445-4 15-09-2018 FALSE 4037 238108087-2 17-06-2018 FALSE </t

Why Choose Us

  • 100% non-plagiarized Papers
  • 24/7 /365 Service Available
  • Affordable Prices
  • Any Paper, Urgency, and Subject
  • Will complete your papers in 6 hours
  • On-time Delivery
  • Money-back and Privacy guarantees
  • Unlimited Amendments upon request
  • Satisfaction guarantee

How it Works

  • Click on the “Place Your Order” tab at the top menu or “Order Now” icon at the bottom and a new page will appear with an order form to be filled.
  • Fill in your paper’s requirements in the "PAPER DETAILS" section.
  • Fill in your paper’s academic level, deadline, and the required number of pages from the drop-down menus.
  • Click “CREATE ACCOUNT & SIGN IN” to enter your registration details and get an account with us for record-keeping and then, click on “PROCEED TO CHECKOUT” at the bottom of the page.
  • From there, the payment sections will show, follow the guided payment process and your order will be available for our writing team to work on it.