Results from Kylin and Tableau on a live connection don't match. Any reason? I'm creating a custom data source (Custom SQL Query) in Tableau and adding a parameter control using a query similar to below:
SELECT t2.c1 ,sum(t1.c2) AS c3 FROM t1 Inner join t2 on t1.k1 = t2.k1 group by t2.c1 order by c3 LIMIT <Parameters.Top N> t1 (fact) has 130MM rows and t2 (dimension) has 1.7MM The query shows different Top N records in Tableau as compared to Kylin and Hive. Thanks, Regards, -- View this message in context: http://apache-kylin.74782.x6.nabble.com/Kylin-and-Tableau-Top-N-query-tp3250.html Sent from the Apache Kylin mailing list archive at Nabble.com.
