We have a column store table having billions of rows, we want to fix few of its columns to trim quotes.
Query we used is update tab_h set f=TRIM(BOTH ‘"’ FROM f)
Though it will not work for table with billion of rows. we even tried using this stored procedure
CREATE OR REPLACE PROCEDURE update_tab AS
FOR i in 1 … 50 LOOP
update tab_h set f=TRIM(BOTH ‘"’ FROM f) where f IN (SELECT f FROM tab_h WHERE f like ‘%"%"’ limit 10000);
But this too doesn’t seems sufficient for updating billions of rows.