i have a fact table named "A"  with 4 cloumns          clicks     cost        
dates                 product  1       1       1.00        2016-01-02          
A  2       2       3.00        2016-01-03           B  3       5       16.00    
 
2016-01-03           A  4       3       6.00        2016-01-04           A 
there have an error when use the sql like "select sum(clicks)/sum(cost) from
xxxx group xxxx "  and how can i  group by "year" and "month" with cloumn
"dates" ?

--
View this message in context: 
http://apache-kylin.74782.x6.nabble.com/How-can-i-use-the-sql-function-by-kylin-version-1-6-tp7566.html
Sent from the Apache Kylin mailing list archive at Nabble.com.

Reply via email to