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
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
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
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