View A: used devices (no primary key, many records per day) experiment bucket device seconds x y z day Mandatory user-defined filter: experiment and the time interval. Report the SUM(seconds) per bucket: SELECT bucket, sum(seconds ) FROM A WHERE expe...

Backend: Redshift table; the column C (varchar (1000) ) has data like this: A1:B1&A4:B7&A9:B12 It is basically the key:value pairs. The & separates the pairs, the : separates the key and value. The number and length of keys and values is not fixed. T...