How much difference between Hive and Kylin? Did you check some factors like: a) any filtering condition in Cube descriptor? b) is the Cube built with the full date range of hive table? c) Was the fact/lookup table data changed since cube be built? Just some hints to exclude those mistakes. Besides, you can run the SQL from Kylin UI to eliminate the possibility of ODBC driver.
2016-01-15 7:50 GMT+08:00 sdangi <[email protected]>: > 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. > -- Best regards, Shaofeng Shi
