Re: Design schema for faster analytics

2016-10-18 Thread Buntu Dev
Thanks Jim. While performance tuning of the queries will definitely help, I also would like to know if there is a general practice on how metrics with multiple dimensions are generally queried. For example, for a given metric like LTV I got about 65 different ways to segment based on product/sku an

Re: Design schema for faster analytics

2016-10-18 Thread Jim Apple
This might help: http://www.cloudera.com/documentation/enterprise/latest/topics/impala_performance.html On Tue, Oct 18, 2016 at 12:30 AM, Buntu Dev wrote: > I got table of user purchases and subscriptions with various product skus > along with user attributes in a single table (~1g and 20M rows).