· 7 years ago · Nov 19, 2018, 10:28 AM
1CREATE TABLE IF NOT EXISTS schema.table(
2row_id INT(255) NOT NULL AUTO_INCREMENT PRIMARY KEY,
3val1 DOUBLE,
4val2 DOUBLE,
5val3 DOUBLE);
6
7INSERT INTO schema.table (va1, val2) VALUES (1, 2);
8INSERT INTO schema.table (va1, val2) VALUES (3, 4);
9INSERT INTO schema.table (va1, val2) VALUES (5, 6);
10
11CREATE OR REPLACE
12VIEW test_VIEW
13AS select
14 t1.row_id as row_id,
15 if (t1.val3 is null, SUM(t1.val1 + t1.val2) OVER(), t1.val3) AS val3
16 from
17 test t1