The hive table contains 6 months data but cube only built with 1 month's, if you want to compare the query result between hive and kylin, a where condition should be added in the SQL to let them calculate on the same scope, while I didn't see that on your query; Could you please double confirm?
2016-01-15 23:10 GMT+08:00 sdangi <sda...@datalenz.com>: > How much difference between Hive and Kylin? > We have 6 months of data in Hive but the Cube in Kylin contained only 1 > month as we were testing incremental cube refresh. So Kylin did not have at > least 5 months of data. > a) any filtering condition in Cube descriptor? - No filtering condition in > the cube. If the cube had the filtering condition and I was firing a query > thru Tableau, why would it be any different, as it is not hitting Hive? > b) is the Cube built with the full date range of hive table? > No. It had only 1 month of data from hive tables. > c) Was the fact/lookup table data changed since cube be built? > No. > > > ShaoFeng Shi-2 wrote > > 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 < > > > sdangi@ > > > >: > > > >> 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 > > > ShaoFeng Shi-2 wrote > > 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 < > > > sdangi@ > > > >: > > > >> 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 > > > > -- > View this message in context: > http://apache-kylin.74782.x6.nabble.com/Kylin-and-Tableau-Top-N-query-tp3250p3269.html > Sent from the Apache Kylin mailing list archive at Nabble.com. > -- Best regards, Shaofeng Shi
