Re: Kylin and Tableau -- Top N query

2016-01-16 Thread ShaoFeng Shi
p by t2.c1 > >> order by c3 > >> LIMIT > > > >> > >> 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. > >&g

Re: Kylin and Tableau -- Top N query

2016-01-15 Thread sdangi
gt; Inner join t2 >> on t1.k1 = t2.k1 >> group by t2.c1 >> order by c3 >> LIMIT > >> >> 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

Re: Kylin and Tableau -- Top N query

2016-01-14 Thread ShaoFeng Shi
y 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

Kylin and Tableau -- Top N query

2016-01-14 Thread sdangi
2.c1 order by c3 LIMIT 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 Sen