You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
This produces wrong SQL translation as sd() should be translated to STDDEV_SAMP(); all() to LOGICAL_AND() and any() to LOGICAL_OR().
Furthermore, BigQuery doesn't support OVER() clause for LOGICAL_AND() and LOGICAL_OR(). So all() and any() should be translated using win_absent() instead.
The text was updated successfully, but these errors were encountered:
Currently
sd()
,all()
andany()
window functions are translated to SQL using the following snippet.This produces wrong SQL translation as
sd()
should be translated toSTDDEV_SAMP()
;all()
toLOGICAL_AND()
andany()
toLOGICAL_OR()
.Furthermore, BigQuery doesn't support
OVER()
clause forLOGICAL_AND()
andLOGICAL_OR()
. Soall()
andany()
should be translated usingwin_absent()
instead.The text was updated successfully, but these errors were encountered: