[LENS-233] Create an example schema and queries from a real world use case

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 2.1
• Component/s: examples
• Assignee: Amareshwari Sriramadasu
• Reporter: Jaideep Dhok
• Created: 23/Jan/15 07:08
• Updated: 22/Apr/15 12:48
• Resolved: 20/Apr/15 03:49

Description

Our example schema is too abstract with names like dim1, dim2 .. and fact1 etc.

It would be useful if we create a schema from a typical BI use cases like financial dwh (data warehouse) or perhaps an e-commerce or click logs dwh.

This will also be useful in posting test queries and rewritten queries in JIRAs

Issue Links

• duplicates: LENS-157 Lens-Example should have some facts table in db to run cube query in JDBC
• duplicates: LENS-321 Add join chains for dimension in exmaples

Sub-Tasks

• Create example metastore schema for sales: Closed
• Populate data in physical tables for sales: Resolved
• Add examples queries for sales: Closed