functiongoogle-bigqueryduplicatesanalytics
Most efficient way to delete duplicates from GBQ table by multiple columns
I have the following table (see above).
What is the most efficient way to delete duplicates by appId AND clientId so the resulting table contains only those rows with minimum DIFF
Ex: 260848 should be yandex as source
Thanks!
Solution
Below is for BigQuery Standard SQL
#standardSQL
SELECT AS VALUE ARRAY_AGG(t ORDER BY DIFF LIMIT 1)[OFFSET(0)]
FROM `project.dataset.table` t
GROUP BY appId, clientId
- Unknown error in Haskell that prevents a function from running
- curly-curly braces - why won't this function accept an unquoted variable
- Turing Machine - Finding k-th element based on input
- Discrepancy in passing array to function
- What is a "static" function in C?
- Running Azure functions locally gives "No runtime" error after .NET7 upgrade
- Java function (method) available everywhere (global)
- postgres event trigger and function not working
- Cannot access temporary tables from within a function
- Why doesn't it just give the list itself?
- Apply function to list depending on values in another list
- Speed up R function that combines linestrings into a single linestring
- The execution order of the promise according to the return type 2
- Unable to properly return python data in function
- Why is the chat window opening before I click open chat?
- Please define a stack overflow exception -- c#
- Bash shell...find command...names with wildcards...alias or function
- Generate many random alphanumeric strings
- shell script functions arguments/parameters
- Pass a parameter in a function which is passed by "reference" in another function
- gcc compilation error on simple short int function call with flag -Werror=traditional-conversion
- Ti-basic passing function as an argument to another function
- Passing function with arguments as a prop and invoking it internally in React
- Is there a way to declare an array = a function that returns an array? (c++)
- tkinter images not opening in a function
- Passing multiple callable to odeint
- Function to return dynamic set of columns for given table
- Student's t-distribution CDF R base documentation
- Java equivalent of function mapping in Python
- Declaring Global variable inside of a function in C++