This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
I’ve also noticed it convert timestamps to strings when there’s no need:
SELECT TO_CHAR(orders.created_at, 'YYYY-MM-DD HH24:MI:SS') AS
"orders.created_time", COUNT(*) AS "orders.count" FROM orders GROUP BY 1
LIMIT 500; (i.e. orders.created_at is alre...
It’s a table of ~1m rows so that may well be true, it’s a shame though
as I think we’ll have to avoid this feature for the time being. I’m to
give Redshift a trial soon to see if that helps. I do wonder (just
thinking out loud, I’m not an expert) why...
Hi, I just tried this for the first time today and nearly brought down
the system! Here’s the query it generated: SELECT event_group.id AS
`event_group.id`, event_group.NAME AS `event_group.name`, ( SUM(DISTINCT
( CAST(FLOOR(COALESCE(event_group_view...