Is there a function to get the max of two values in Google BigQuery?

google-bigquery
YABADABADOU picture YABADABADOU · Sep 27, 2013 · Viewed 10.3k times · Source

I want to get the maximum value of 2 Integer (or 2 float).

I know I can do it with a IF function like this: IF (column1 > column2, column1, column2)

however I was wondering if a function to do that exists or if there is a plan to add that kind of function in the future.

In MySQL there is the GREATER function that can do that. Example: GREATER(column1, column2).

Answer

Jason Roselander picture Jason Roselander · Aug 27, 2014

BigQuery supports 

GREATEST(expr1, expr2, ...)

which returns the largest argument. I've filed an internal bug to get this added to our public documentation.

Related questions

Setting GOOGLE_APPLICATION_CREDENTIALS for BigQuery Python CLI

I'm trying to connect to Google BigQuery through the BigQuery API, using Python. I'm following this page here: https://cloud.google.com/bigquery/bigquery-api-quickstart My code is as follows: import os import argparse from apiclient.discovery import build from apiclient.…

Read More
Google BigQuery Delete Rows?

Anyone know of any plans to add support for delete parts of data from a table in Google Bigquery? The issue we have right now is we are using it for analytics of data points we collect over time. We …

Read More
Can we cast the type in BigQuery?

Following my query : SELECT SQRT((D_o_latitude - T_s_lat)^2+(D_o_longitude - T_s_long)^2)/0.00001 FROM [datasetName.tableName] I am getting the error as Error: Argument type mismatch in function SUBTRACT:'D_o_latitude' is type …

Read More