Bigquery resources exceeded during query execution – optimization

I have got a problem with this query. SELECT event_date, country, COUNT(*) AS sessions, AVG(length) AS average_session_length FROM ( SELECT country, event_date, global_session_id, (MAX(event_timestamp) – MIN(event_timestamp))/(60 * 1000 * 1000) AS length FROM ( SELECT user_pseudo_id, event_timestamp, country, event_date, SUM(is_new_session) OVER (ORDER BY user_pseudo_id, event_timestamp) AS global_session_id, SUM(is_new_session) OVER (PARTITION BY user_pseudo_id ORDER BY event_timestamp)…

Details

How to stop TypeScript error ‘Type A has no properties in common with Type B’ when Type B “extends” Type A in some way

(edited Title to make more general) I’m working in a codebase which uses React class components and Typescript everywhere, and I’m trying to implement react-dropzone (a lightweight, simple but effective file-drop component) using the class-based method. The Hooks implementation is cleaner and simpler but I’d prefer to avoid so as to preserve the paradigm maintained…

Details