SQL Practice Logo

SQLPractice Online

Level 8 - PrincipalDebugging Questionsm1 distributed data architecture

Debug Cast on Shard Key

Fix query so shard index is usable: SELECT * FROM tenant_orders WHERE CAST(tenant_id AS TEXT)='42' AND order_ts >= CURRENT_DATE - INTERVAL '1 day';

Schema Context

tenant_orders(order_id, tenant_id, order_ts, amount)