Hi, the function ANY_VALUE, that exist in 5.7 is not yet adopted in MariaDB 10.2.5.

This function is useful for GROUP BY queries when the ONLY_FULL_GROUP_BY SQL mode is enabled, for cases when MySQL rejects a query that you know is valid for reasons that MySQL cannot determine. The function return value and type are the same as the return value and type of its argument, but the function result is not checked for the ONLY_FULL_GROUP_BY SQL mode.

https://dev.mysql.com/doc/refman/5.7/en/miscellaneous-functions.html
https://dev.mysql.com/doc/refman/5.7/en/miscellaneous-functions.html#function_any-value