search

StarRocks / starrocks

StarRocks, a Linux Foundation project, is a next-generation sub-second MPP OLAP database for full analytics scenarios, including multi-dimensional analytics, real-time analytics, and ad-hoc queries.
https://starrocks.io
Apache License 2.0
8.66k stars 1.75k forks source link

Use query sql instead of 'show proc "/xxxx"', in order to filter,aggregate or join #10296

Closed 5herhom closed 1 year ago

5herhom commented 2 years ago

In clickhouse, there is a database named "system", user can use "select" to query metrics in ck. In order to query metrics by user define, can starrocks support the feature?

jaogoy commented 1 year ago

Did you mean the information_schema or other others? What's the metrics you want to be implemented firstly?

5herhom commented 1 year ago

Did you mean the information_schema or other others? What's the metrics you want to be implemented firstly?

One situation is to get the replica num or replica size of table per backend node with ip. It should query many sql like show proc '/dbs/${dbId}'、show proc '/dbs/${dbId}/${tblId}/partitions'、show proc '/dbs/${dbId}/${tblId}/partitions/${partitionId}'、show proc '/dbs/${dbId}/${tblId}/partitions/${partitionId}/${indexId}'、show proc '/backends' . And join or aggregate the result of them by code like java. If they can be joined by col, it can be released by sql without other language.

github-actions[bot] commented 1 year ago

We have marked this issue as stale because it has been inactive for 6 months. If this issue is still relevant, removing the stale label or adding a comment will keep it active. Otherwise, we'll close it in 10 days to keep the issue queue tidy. Thank you for your contribution to StarRocks!