Hive queries

Κλειστό Αναρτήθηκε Πριν 1 χρόνο Πληρώθηκε κατά την παράδοση
Κλειστό Πληρώθηκε κατά την παράδοση

you are going to do

[login to view URL] a Hive query to create a table called used_cars from data. Use a schema that is appropriate for the column headings. The date column for the dataset is not in a format that is recognized by Apache Hive by default (you cannot use DATE type to load this dataset). Look up methods for loading the date from this dataset correctly into Hive.

2. Write Hive queries to see how many missing values you have in each attribute. Create a bar chart displaying the number of missing records by column name.

3. Group the price column and count the number of unique prices. Create a bar chart with name with price and number of times it occurs for the top 10 unique prices. Do you notice if there is a single price that is repeating across the ads? Take note of this price.

dataset : wget [login to view URL]

Hadoop MySQL Python Hive

Ταυτότητα Εργασίας: #34207198

Σχετικά με την εργασία

8 προτάσεις Απομακρυσμένη εργασία Ενεργό Πριν 1 χρόνο

8 freelancers κάνουν προσφορές κατά μέσο όρο $24 για αυτή τη δουλειά

palencarlos540

Hello. I am an expert in Big data analytics and I am belong to Big Data Project team. And I have much experiences in Hive database and HBase database. So I think that I am perfectly fit your project. If you wanna to di Περισσότερα

$20 CAD σε 2 μέρες
(1 Κριτική)
2.3
yehyenabil

hay,i am a data analyst and i have long time experience with databases and SQL ,i can done your task with clean code and high performance just massage me for more details.

$20 CAD σε 1 μέρα
(2 Αξιολογήσεις)
0.8
HamadUllah18

Hi there! I can help you with creating a table in HiveQL. I'll follow the excel file provided and will input all the data into the database. I'll also create a bar chart for both missing records and for the top 10 uni Περισσότερα

$40 CAD σε 1 μέρα
(0 Αξιολογήσεις)
0.0
abrazshaikh

Hand-on Experience with database management systems and also working professional in reputed can perfoem the given within the timeline.

$20 CAD σε 7 μέρες
(0 Αξιολογήσεις)
0.0
mismael18

Hi, I went throught the task description and understand that you need to create a new table and query the data to get some insights. I have experience in PostgreSQL queries and Python analysis as well. I am a certifi Περισσότερα

$20 CAD σε 5 μέρες
(0 Αξιολογήσεις)
0.0
rakeshreddy1240

I have worked on hive for one of the client. 80 percent of data we check in hive. Due to continuous working on that I have excelled in hive

$20 CAD σε 7 μέρες
(0 Αξιολογήσεις)
0.0
flxgrimm

Hello, my name is Felix and i am a Database Expert. I looked at your csv file and i am sure that i can convert it in the right format and fulfill your Task. I also have a lot of experience with visualizing data! In add Περισσότερα

$30 CAD σε 7 μέρες
(0 Αξιολογήσεις)
0.0
prashanthsai28

I am already working in the project with accenture so i am good at it and i can handle it you can give me this work.

$20 CAD σε 7 μέρες
(0 Αξιολογήσεις)
0.0