I have a table which looks like this: date user_id active_dt last_active_day 2020-01-01 1 null null 2020-01-02 1 null null 2020-01-03 1 null null 2020-01-04 1 2020-01-05 null 2020-01-05 1 2020-01-08 2020-01-05 (as of 2020-01-05, the last actve date was…
I am trying to sum a timestamp with a time that I have to cast from varchar to time. This is my attempt: select my_timestamp + cast(my_str_time as time) as my_end_time from my_db.my_table; my_timestamp format (already a timestamp): 2022-07-16 02:51:11…
Is it possible to use 2 dist keys in a table? I have a query which makes use of 3 tables. Table 1 - Table 2 join on ID1 and Table 2 - Table 3 join on ID2. I need…
I have a table that looks like this Tep ID number Date Value type ABC 1 22-09-2021 1.2 X XYZ 2 22-10-2021 3.2 X ABC 3 22-10-2021 3.2 Y WSH 4 22-10-2021 3.2 X I want the output like this…
i have to select a set of rows (like 200 unique rows) from 200 million rows at once without order by and it must be efficient.
I have a base_table and a final_table having same columns with plan and date being the primary keys. The data flow happens from base to final table. Initially final table will look like below: After that the base table will…
I have 2 tables. t1.uuid has 630,000 distinct values. t2.uuid has 300,000 distinct values. When I run SELECT t1.uuid , t2.uuid FROM t1 --630,000 uuids LEFT OUTER JOIN t2 -- 300,000 uuids ON t1.uuid = t2.uuid WHERE t2.uuid IS NULL…
In my database, there is a table which shows the landing pages, and what I want to do is to classify if the traffic is from SEO channel. When the landing page is exactly equal to the pattern /countrycode/index.aspx, then…