Skip to content

Latest commit

 

History

History
42 lines (31 loc) · 1.28 KB

valuein.md

File metadata and controls

42 lines (31 loc) · 1.28 KB
Raw
description
This section contains reference documentation for the VALUEIN function.

VALUEIN

Takes at least 2 arguments, where the first argument is a multi-valued column, and the following arguments are constant values. The transform function will filter the value from the multi-valued column with the given constant values. The VALUEIN transform function is especially useful when the same multi-valued column is both filtering column and grouping column.

Signature

VALUEIN('colName', value1, value2,...)

Usage Examples

These examples are based on the Hybrid Quick Start.

SELECT VALUEIN(RandomAirports, 'SEA') as airport, count(*)
FROM airlineStats
WHERE RandomAirports = 'SEA'
GROUP BY airport
airport count(*)
SEA 4858 
SELECT VALUEIN(RandomAirports, 'SEA', 'PSC') as airport, count(*)
FROM airlineStats
WHERE RandomAirports IN ('SEA', 'PSC')
GROUP BY airport
airport count(*)
PSC 4832
SEA 4858

{% hint style="info" %} The count(*) values returned by these queries will increase each time we execute the query as data is constantly being ingested by the Hybrid Quick Start. {% endhint %}