wForget commented on PR #6017:
URL: https://github.com/apache/kyuubi/pull/6017#issuecomment-1910125815
> How about introducing a new syntax instead of hint, something like `CALL
OBSERVE('observer1', sum(c1), count(1)) (select * from t1)`, it will return the
result of observation
This seems to only observe the final result, I want to insert observers at
the all stages of SQL like in test case.
original sql:
```
SELECT *
FROM
(SELECT * from t1) tt1
join
(SELECT c1, c1 * 2 as c3 from t2) tt2
on tt1.c1 = tt2.c1
```
sql with observers:
```
SELECT /*+ OBSERVE('observer3', sum(tt2.c3), count(1)) */ *
FROM
(SELECT /*+ OBSERVE('observer1', sum(c1), count(1)) */ * from t1) tt1
join
(SELECT /*+ OBSERVE('observer2', sum(c1), count(1)) */ c1, c1 * 2 as c3
from t2) tt2
on tt1.c1 = tt2.c1
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
