You're probably not using ARRAY_AGG correctly in SQL (here's what to fix) ️ Does your SQL query return too many rows? Imagine you have orders, and each order has many products. Getting one row per ...
Move GROUP_BY from SQL to clojure group-by Move to-many into VendorAdapters, use array_agg for adapters which support it and a. use string_agg in SQL and str/split in Clojure and use attributes to ...
Data Engineer @Tiger Analytics ⭐Azure|Snowflake | SQL SERVER | T-SQL | SSIS | Tera Data | Python | Oracle | AZURE | SQL | DATA BRICKS | SPARK | ADF | Ex-Infoscion ...
CREATE OR REPLACE FUNCTION evergreen.array_remove_item_by_value(inp ANYARRAY, el ANYELEMENT) RETURNS anyarray AS $$ SELECT ARRAY_AGG(x.e) FROM UNNEST( $1 ) x(e) WHERE x.e <> $2; $$ LANGUAGE SQL; ...