Hello team! Hoping to get some help building a trace query – didn't find what I was looking for in the docs or on GitHub issues. In short, I'm wondering if SigNoz has an equivalent to TraceQL's structural operators. My use case is as follows: Service A produces a span with attributes

{"attr1": "foo"}

Service B produces a child (or descendant) span with attributes

{"attr2": "bar"}

I need a way to find all spans where

attr2 = bar

AND that have a parent (or ancestor) span where

attr1 = foo

. Is this possible with SigNoz at the moment?

Don’t think it’s possible right now. cc @Srikanth Chekuri

Hey Nitya, thanks for the response! I tried to build a Clickhouse query to emulate this. I've had some success with searching for immediate child/parent spans as well as grandparent/grandchild spans. But what I'd really like is arbitrary depth searches. It looks like Clickhouse now supports recursive CTEs, but I haven't had any luck getting that to work in SigNoz – I only get 500 status codes. Can you confirm whether recursive CTEs are supported in SigNoz's Clickhouse query input? Happy to share the queries I've written if that would help! This is the only missing feature that's blocking us from moving away from our current APM tool onto SigNoz cloud. Would be super cool to find a solution here :)

We don’t restrict anything in the ch query builder. You can share the queries , will have a look