Shulou(Shulou.com)05/31 Report--

This article mainly introduces the SLS log service other query example analysis, has a certain reference value, interested friends can refer to, I hope you can learn a lot after reading this article, the following let the editor take you to understand.

Group_concat operation

Array_join (array_agg (DISTINCT device_id),',')

Parallel sql query

| * | set session parallel_sql=true; select xxx |

Analyze the city according to the user ip

* | select count ("_ _ tag__:__client_ip__") count, ip_to_provider ("_ _ tag__:__client_ip__") provider,ip_to_country ("_ _ tag__:__client_ip__") country,ip_to_province ("_ _ tag__:__client_ip__") province Ip_to_city ("_ _ tag__:__client_ip__") city group by "_ _ tag__:__client_ip__", ip_to_province ("_ _ tag__:__client_ip__") * | select count (1) count, ip_to_country ("_ _ tag__:__client_ip__") country Ip_to_province ("_ _ tag__:__client_ip__") province group by ip_to_country ("_ _ tag__:__client_ip__"), ip_to_province ("_ _ tag__:__client_ip__") thank you for reading this article carefully. I hope the article "sample Analysis of other queries in SLS Log Service" shared by the editor will be helpful to you. At the same time, I also hope that you will support us and pay attention to the industry information channel. More related knowledge is waiting for you to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.