Write HiveQL statement to create a data file for below schemas:Order: CustomerId, ItemID, ItemName, OrderDate, DeliveryDateCustomer: CustomerId,CustomerName, Address, City, State, CountryCreate a table for Order and Customer data.\n\nWrite HiveQL to find the number of items bought by each customer?
All Questions › Category: Data Science › Write HiveQL statement to create a data file for below schemas:Order: CustomerId, ItemID, ItemName, OrderDate, DeliveryDateCustomer: CustomerId,CustomerName, Address, City, State, CountryCreate a table for Order and Customer data.\n\nWrite HiveQL to find the number of items bought by each customer?