Notes
Notes - notes.io |
DATASET:
The electric_vehicle.csv file is in the location Desktop/Project/Kickoffs-Electric_Vehicle/.
SCHEMA:
Electric_Vehicle
Column Name
Data Type
Description
Vehicle_Number
Varchar(20)
It is a unique vaue for vehicle.
Country
String
Name of the country.
City
String
Name of the city.
Postal_Code
Int
Postal code of the city
Model_Year
Int
The year it was manufactured.
Company
Varchar(20)
Name of the company.
Model
Varchar(20)
Name of the model.
Electric_Vehicle_Type
Varchar(50)
Type of the electric vehicle.
Alternative_Fuel_Vehicle
Varchar(10)
Whether the vehicle supports alternate fuel.
Create a database named as electric_db.
Create a managed table electric_vehicle and columns as specified in the above table. NOTE that the 1 row should be terminated .
Load the data of electric_vehicle.csv file into the electric_vehicle table.
Then load the data into hdfs in the location /user/labuser/electric_vehicle.
Now,Create a managed table country_partition and columns as specified in the above table. NOTE that the 1 row should be terminated and it is partitioned by country.
Load the data into country_partition table by partitioning where country's are 'Adams , Benton , Jefferson , King , Pierce '.
Click on the SUBMIT button to Validate your solution.
|
Notes.io is a web-based application for taking notes. You can take your notes and share with others people. If you like taking long notes, notes.io is designed for you. To date, over 8,000,000,000 notes created and continuing...
With notes.io;
- * You can take a note from anywhere and any device with internet connection.
- * You can share the notes in social platforms (YouTube, Facebook, Twitter, instagram etc.).
- * You can quickly share your contents without website, blog and e-mail.
- * You don't need to create any Account to share a note. As you wish you can use quick, easy and best shortened notes with sms, websites, e-mail, or messaging services (WhatsApp, iMessage, Telegram, Signal).
- * Notes.io has fabulous infrastructure design for a short link and allows you to share the note as an easy and understandable link.
Fast: Notes.io is built for speed and performance. You can take a notes quickly and browse your archive.
Easy: Notes.io doesn’t require installation. Just write and share note!
Short: Notes.io’s url just 8 character. You’ll get shorten link of your note when you want to share. (Ex: notes.io/q )
Free: Notes.io works for 12 years and has been free since the day it was started.
You immediately create your first note and start sharing with the ones you wish. If you want to contact us, you can use the following communication channels;
Email: [email protected]
Twitter: http://twitter.com/notesio
Instagram: http://instagram.com/notes.io
Facebook: http://facebook.com/notesio
Regards;
Notes.io Team