#sqlreporting — Public Fediverse posts
Live and recent posts from across the Fediverse tagged #sqlreporting, aggregated by home.social.
-
Why does this SQL aggregate undercount?
Why does this SQL aggregate undercount in production. The SQL code groups by a rounded timestamp, collapsing multiple events into one bucket. In SQL analytics this undercounts traffic.
#whatswrongwiththissqlquery #sqlbug #sqlproductionbug #sqldebugging #sqldatabase #sqlcodereview #sqlperformance #sqlreliability #sqlanalytics #sqldataintegrity #sqlengineering #sqlaggregatebug #sqlgroupby #sqlreporting #sqlda...
-
Why does this SQL aggregate undercount?
Why does this SQL aggregate undercount in production. The SQL code groups by a rounded timestamp, collapsing multiple events into one bucket. In SQL analytics this undercounts traffic.
#whatswrongwiththissqlquery #sqlbug #sqlproductionbug #sqldebugging #sqldatabase #sqlcodereview #sqlperformance #sqlreliability #sqlanalytics #sqldataintegrity #sqlengineering #sqlaggregatebug #sqlgroupby #sqlreporting #sqlda...
-
Why does this SQL aggregate undercount?
Why does this SQL aggregate undercount in production. The SQL code groups by a rounded timestamp, collapsing multiple events into one bucket. In SQL analytics this undercounts traffic.
#whatswrongwiththissqlquery #sqlbug #sqlproductionbug #sqldebugging #sqldatabase #sqlcodereview #sqlperformance #sqlreliability #sqlanalytics #sqldataintegrity #sqlengineering #sqlaggregatebug #sqlgroupby #sqlreporting #sqlda...