Hive queries
$10-30 CAD
Πληρώθηκε κατά την παράδοση
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]
Ταυτότητα Εργασίας: #34207198
Σχετικά με την εργασία
8 freelancers κάνουν προσφορές κατά μέσο όρο $24 για αυτή τη δουλειά
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 Περισσότερα
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.
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 Περισσότερα
Hand-on Experience with database management systems and also working professional in reputed can perfoem the given within the timeline.
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 Περισσότερα
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
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 Περισσότερα
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.