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.
