DISTINCT

[pantonis]

We have the requirement for Pivoting on our UI since this is one of the key concepts of OLAP. To do this we need to get unique values of a table column and we use SELECT DISTINCT(col)....

This causes issues to large tables.

Any other alternative way to achieve this?

[Faisal Saeed]

Hey there, I would try GROUP BY, It’s much more efficient.

SELECT COL1, … FROM … GROUP BY COL1;

--
You received this message because you are subscribed to the Google Groups "MariaDB ColumnStore" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mariadb-columns...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/mariadb-columnstore/a3243bb3-ad06-49d8-a517-c4e21207cd29n%40googlegroups.com.

[Roland Noland]

Hi,

I would use Faisal's suggestion with the currently available MCS.

JFYI We are re-factoring DISTINCT[1] so it will leverage GROUP BY internally.

Regards,

Roman

1. https://jira.mariadb.org/browse/MCOL-5187

вт, 27 июн. 2023 г. в 09:58, pantonis <anton...@gmail.com>:

We have the requirement for Pivoting on our UI since this is one of the key concepts of OLAP. To do this we need to get unique values of a table column and we use SELECT DISTINCT(col)....

This causes issues to large tables.

Any other alternative way to achieve this?

[pantonis]

Thank you