Supporting Join expression

[BarAshkenazi]

Hi,

I'd like to know if it's possible to support join expressions.

For example, I'd like to check which node types the pods of a specific deployment are running on, and get a result that looks like this:

m5.2xlarge: 30
m5.large: 10

Is there currently a way to achieve this with a single SQL query?

[yaacov]

tl;dr - no

hmm,
I removed join for easier maintainability #19

You might try to look for information already encoded in the pod to get the information without join ?

[BarAshkenazi]

Thanks for the response!
The pod status only has the node IP/name, but it doesn't include info such as node-type, architecture, spot/on-demand, nodepool, disk-size, etc.
I think that adding join/group-by capabilities can make this tool very powerful compared to jq

[yaacov]

I will be very happy for a pull request adding goup by and or join :-)