Hive queries
Budget: $10 – $30 CAD
you are going to do
1.Write 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 https://www.dropbox.com/s/ffkwf3ixq1mjk7q/cars.csv
1.Write 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 https://www.dropbox.com/s/ffkwf3ixq1mjk7q/cars.csv