select mvCol1, 
       arrayConcatLong(mvCol1, mvCol2) AS concatLongs
from multiValueTable
WHERE arraylength(mvCol1) >= 2
limit 5

SELECT CHR(65) AS value
FROM ignoreMe

select homeRuns, baseOnBalls, ADD(homeRuns, baseOnBalls) AS total
from baseballStats 
WHERE teamID = 'ML1' 
AND yearID = 1956 
AND playerName = 'Henry Louis'

select CEIL(12.1) AS value
from ignoreMe

select CEIL(-12.1) AS value
from ignoreMe

select AVGMV(DivLongestGTimes) AS value
from airlineStats 
where arraylength(DivLongestGTimes) > 1

SELECT CODEPOINT('Apache Pinot') AS value
FROM ignoreMe

select mvCol1, 
       arrayConcatFloat(mvCol1, mvCol2) AS concatFloats
from multiValueTable
WHERE arraylength(mvCol1) >= 2
limit 5

select FLOOR(12.1) AS value
from ignoreMe

select FLOOR(-12.1) AS value
from ignoreMe

select DivTailNums, 
       arrayConcatString(DivTailNums, DivTailNums) AS concatIds
from airlineStats 
WHERE arraylength(DivTailNums) >= 2
limit 5

select RandomAirports, 
       arrayRemoveString(RandomAirports, 'SEA') AS value
from airlineStats 
WHERE arraylength(RandomAirports) BETWEEN 2 AND 4
limit 5

select DivAirportIDs, 
       arrayReverseInt(DivAirportIDs) AS reversedIds
from airlineStats 
WHERE arraylength(DivAirportIDs) >= 2
limit 5

select DivWheelsOffs, 
       arrayConcatInt(DivWheelsOffs, DivWheelsOns) AS concatIds
from airlineStats 
WHERE arraylength(DivWheelsOffs) >= 2
limit 5

select DivTailNums, 
       arrayIndexOfString(DivTailNums, 'N7713A') AS index
from airlineStats 
WHERE arraylength(DivTailNums) >= 2
limit 5

select DivTailNums
from airlineStats 
where arraylength(DivTailNums) > 1

SELECT COVAR_POP(numberOfGames, hits) AS covariance 
FROM baseballStats

SELECT concat('Apache', 'Pinot', ' ') AS value
FROM ignoreMe

SELECT concat('real-time', 'analytics', '__') AS value
FROM ignoreMe

SELECT DISTINCTSUM(runs) AS VALUE
FROM baseballStats

SELECT SUM(DISTINCT AtBatting) AS VALUE
FROM baseballStats

SELECT DISTINCTAVG(runs) AS VALUE
FROM baseballStats

select hour(1639351800000) AS hour
FROM ignoreMe

select hour(1639351800000, 'CET') AS hour
FROM ignoreMe

select DivTailNums, 
       arrayContainsString(DivTailNums, 'N7713A') AS index
from airlineStats 
WHERE arraylength(DivTailNums) >= 2
limit 5

select mvCol1, 
       arrayConcatDouble(mvCol1, mvCol2) AS concatDoubles
from multiValueTable
WHERE arraylength(mvCol1) >= 2
limit 5

select ABS(-12.1) AS value
from ignoreMe

select ABS(12.1) AS value
from ignoreMe

select ln(1) AS value
from ignoreMe

select ln(12) AS value
from ignoreMe

select MOD(12, 5) AS value
from ignoreMe

select MOD(12, 2) AS value
from ignoreMe

select MINMAXRANGE(yearID) AS value
from baseballStats 

select EXP(1) AS value
from ignoreMe

select EXP(12) AS value
from ignoreMe

select MINMAXRANGEMV(DivLongestGTimes) AS value
from airlineStats 
where arraylength(DivLongestGTimes) > 1

SELECT ' Pinot with spaces  ' AS notTrimmed,
       ltrim(' Pinot with spaces ') AS trimmed
FROM ignoreMe

COVAR_SAMP(col1, col2) = COVAR_POP(col1, col2) * besselCorrection

SELECT COVAR_SAMP(numberOfGames, AtBatting) AS covariance 
FROM baseballStats

select count(*) AS value
from baseballStats 

select dayOfWeek(1639351800000) AS dayOfWeek
FROM ignoreMe

select dayOfYear(1639351800000) AS dayOfYear
FROM ignoreMe

SELECT DISTINCTSUMMV(DivLongestGTimes) AS VALUE
FROM airlineStats
WHERE arraylength(DivLongestGTimes) > 1

SELECT DISTINCTAVGMV(DivLongestGTimes) AS VALUE
FROM airlineStats
WHERE arraylength(DivLongestGTimes) > 1

select DISTINCTCOUNTHLLMV(DivLongestGTimes) AS value
from airlineStats 
where arraylength(DivLongestGTimes) > 1

select LOWER('Pinot') AS name
FROM ignoreMe

select DISTINCTCOUNTHLL(teamID) AS value
from baseballStats 

select min(yearID) AS value
from baseballStats 

select DISTINCTCOUNTBITMAP(league) AS value
from baseballStats 

select quarter(1633046399000) AS quarter
FROM ignoreMe

select now() AS now
FROM ignoreMe

SELECT * 
FROM tableName
WHERE tsInMillis > now() - 86400000

select percentile(homeRuns, 50) AS value
from baseballStats 

select max(homeRuns) AS value
from baseballStats 

SELECT length('Pinot') AS value
FROM ignoreMe

select PERCENTILETDigest(homeRuns, 50) AS value
from baseballStats 

select MAXMV(DivLongestGTimes) AS value
from airlineStats 
where arraylength(DivLongestGTimes) > 1

select month(1633046399000, 'UTC') AS month
FROM ignoreMe

select month(1633046399000, 'CET') AS month
FROM ignoreMe

select DISTINCTCOUNTRAWHLL(teamID) AS value
from baseballStats 

select DISTINCTCOUNTRAWHLLMV(DivAirports) AS value
from airlineStats 
where arraylength(DivAirports) > 1

select millisecond(1639351800000) AS millisecond
FROM ignoreMe

select millisecond(1639351800000, 'America/St_Johns') AS millisecond
FROM ignoreMe

select DivTailNums
from airlineStats 
where arraylength(DivTailNums) > 1

select DivAirportIDs, 
       arrayContainsInt(DivAirportIDs, 14683) AS containsValue
from airlineStats 
WHERE arraylength(DivAirportIDs) >= 2
limit 5

select DivAirportIDs, 
       arrayDistinctInt(DivAirportIDs) AS unique
from airlineStats 
WHERE arraylength(DivAirportIDs) >= 2
limit 5

select DivTailNums, 
       arrayDistinctString(DivTailNums) AS unique
from airlineStats 
WHERE arraylength(DivTailNums) >= 2
limit 5

select FlightNum, 
       arrayReverseString(RandomAirports) AS reversedAirports, 
       RandomAirports
from airlineStats 
WHERE arraylength(RandomAirports) BETWEEN 2 AND 4
limit 5

select DISTINCTCOUNTMV(DivTailNums) AS value
from airlineStats 
where arraylength(DivTailNums) > 1

SELECT AVG(DISTINCT AtBatting) AS VALUE
FROM baseballStats

select DivAirportIDs, 
       arrayIndexOfInt(DivAirportIDs, 14683) AS index
from airlineStats 
WHERE arraylength(DivAirportIDs) >= 2
limit 5

select dayOfWeek(1639351800000, 'CET') AS dayOfWeek
FROM ignoreMe

select dow(1639351800000) AS dayOfWeek
FROM ignoreMe

select dow(1639351800000, 'CET') AS dayOfWeek
FROM ignoreMe

select ago("P1D") AS oneDayAgo
FROM ignoreMe

SELECT * 
FROM tableName
WHERE tsInMillis > ago("P1D")

select dayOfYear(1639351800000, 'CET') AS dayOfYear
FROM ignoreMe

select doy(1639351800000) AS dayOfYear
FROM ignoreMe

select doy(1639351800000, 'CET') AS dayOfYear
FROM ignoreMe

select FromEpochSeconds(1613472303) AS epochMillis
FROM ignoreMe

select FromEpochMinutes(26891205) AS epochMillis
FROM ignoreMe

select FromEpochHours(448186) AS epochMillis
FROM ignoreMe

select FromEpochDays(18674) AS epochMillis
FROM ignoreMe

select DivAirportIDs, 
       arraySortInt(DivAirportIDs) AS sortedIds
from airlineStats 
WHERE arraylength(DivAirportIDs) >= 2
limit 5

select DISTINCTCOUNTHLL(teamID, 12) AS value
from baseballStats 

select FromEpochSecondsBucket(1613472303, 1) AS bucket
FROM ignoreMe

select FromEpochSecondsBucket(1613472303, 2) AS bucket
FROM ignoreMe

select FromEpochMinutesBucket(2689120, 10) AS bucket
FROM ignoreMe

select FromEpochHoursBucket(89637, 5) AS bucket
FROM ignoreMe

select FromEpochDaysBucket(1867, 10) AS bucket
FROM ignoreMe

select DISTINCTCOUNTBITMAP(teamID) AS value
from baseballStats 

SELECT FromDateTime('2019-08-07', 'yyyy-MM-dd') AS epochMillis
FROM ignoreMe

SELECT FromDateTime(
    '2019-08-07 3:12:13 PM', 
    'yyyy-MM-dd hh:mm:ss a'
    ) AS epochMillis
FROM ignoreMe

SELECT FromDateTime(
    '2019-08-07T15:12:13', 
    'yyyy-MM-dd''T''HH:mm:ss'
    ) AS epochMillis
FROM ignoreMe

SELECT FromDateTime(
    '2019-08-07T07:12:13-0800', 
    'yyyy-MM-dd''T''HH:mm:ssZ'
    ) AS epochMillis
FROM ignoreMe

select quarter(1633046399000, 'UTC') AS quarter
FROM ignoreMe

select quarter(1633046399000, 'CET') AS quarter
FROM ignoreMe

select percentile(homeRuns, 80) AS value
from baseballStats 

select percentile(homeRuns, 99.9) AS value
from baseballStats 

select PERCENTILETDigest(homeRuns, 80) AS value
from baseballStats 

select PERCENTILETDigest(homeRuns, 99.9) AS value
from baseballStats 

select DISTINCTCOUNTRAWHLL(teamID, 1) AS value
from baseballStats 

select DISTINCTCOUNTRAWHLLMV(DivAirports, 1) AS value
from airlineStats 
where arraylength(DivAirports) > 1

select COUNTMV(DivTailNums) AS value
from airlineStats 
where arraylength(DivTailNums) > 1

select DivWheelsOffs, 
       DivWheelsOns,
       arrayUnionInt(DivWheelsOffs, DivWheelsOns) AS unionIds
from airlineStats 
WHERE arraylength(DivWheelsOffs) >= 2
limit 5

select FlightNum, 
       arraySliceString(RandomAirports, 0, 2) AS airports, 
       RandomAirports
from airlineStats 
WHERE arraylength(RandomAirports) BETWEEN 2 AND 4
limit 5

select id, repo, JSONEXTRACTKEY(repo, '$.*') AS keys
from githubEvents 
WHERE id = 7044874109

select FlightNum, 
       arraySliceInt(DivAirportIDs, 0, 1) AS airports, 
	     DivAirportIDs
from airlineStats 
WHERE arraylength(DivAirportIDs) >= 2
limit 5

select DISTINCTCOUNTBITMAPMV(DivLongestGTimes) AS value
from airlineStats 
where arraylength(DivLongestGTimes) > 1

select day(1639351800000) AS day
FROM ignoreMe

{"timestamp": "2019-10-09 21:25:25", "meta": {"age": 12}}

select DISTINCTCOUNT(league) AS value
from baseballStats 

select DISTINCTCOUNT(teamID) AS value
from baseballStats 

SELECT isSubnetOf('192.168.0.1/24', '192.168.0.225') 
AS result
FROM myTable;
---> returns true

SELECT isSubnetOf('1.2.3.128/26', '1.2.5.1') 
AS result
FROM myTable;
---> returns false

SELECT isSubnetOf('2001:4800:7825:103::/64', '2001:4800:7825:103::2050')
AS result
FROM myTable;
---> returns true

SELECT isSubnetOf('7890:db8:113::8a2e:370:7334/127', '7890:db8:113::8a2e:370:7336') 
AS result
FROM myTable;
---> returns false

select MINMV(DivLongestGTimes) AS value
from airlineStats 
where arraylength(DivLongestGTimes) > 1

select homeRuns, numberOfGames, DIV(homeRuns, numberOfGames) AS total
from baseballStats 
WHERE teamID = 'ML1' 
AND yearID = 1956 
AND playerName = 'Henry Louis'

select mode(yearID) AS value
from baseballStats 
WHERE AtBatting != 0 AND yearID > 2001

select event_id, location, MD5(location) AS hash
from meetupRsvp 
limit 1

select PERCENTILEMV(DivLongestGTimes, 50) AS value
from airlineStats 
where arraylength(DivLongestGTimes) > 1

select minute(1639351800000) AS minute
FROM ignoreMe

select minute(1639351800000, 'America/St_Johns') AS minute
FROM ignoreMe

select homeRuns, baseOnBalls, MULT(homeRuns, baseOnBalls) AS total
from baseballStats 
WHERE teamID = 'ML1' 
AND yearID = 1956 
AND playerName = 'Henry Louis'

select percentileest(homeRuns, 50) AS value
from baseballStats 

SELECT LPAD('Hello, World', '20', '*') AS value
FROM ignoreMe

select PERCENTILETDIGESTMV(DivLongestGTimes, 50) AS value
from airlineStats 
where arraylength(DivLongestGTimes) > 1

select PERCENTILEESTMV(DivLongestGTimes, 50) AS value
from airlineStats 
where arraylength(DivLongestGTimes) > 1

SELECT toBase64(toUtf8('hello!')) AS encoded
FROM ignoreMe

SELECT fromUtf8(fromBase64('aGVsbG8h')) AS decoded
FROM ignoreMe

SELECT fromBase64('aGVsbG8h') AS decoded
FROM ignoreMe

SELECT toBase64('hello!') AS encoded
FROM ignoreMe

select DISTINCTCOUNTBITMAPMV(DivTailNums) AS value
from airlineStats 
where arraylength(DivTailNums) > 1

select ARRAYLENGTH(RandomAirports) AS length, count(*) 
from airlineStats 
GROUP BY length
ORDER BY count(*) DESC
LIMIT 5

select day(1639351800000, 'CET') AS day
FROM ignoreMe

select dayOfMonth(1639351800000) AS day
FROM ignoreMe

select dayOfMonth(1639351800000, 'CET') AS day
FROM ignoreMe

select DISTINCT league AS value
from baseballStats 

select DISTINCT(league) AS value
from baseballStats 

{
   "tableConfig":{
      "ingestionConfig":{
         "transformConfigs":[
            {
               "columnName":"data",
               "transformFunction":"JSONFORMAT(meta)"
            }
         ]
      }
   }
}

SELECT count(*) 
FROM myTable 
WHERE isSubnetOf('192.168.0.1/24', ipAddressCol);

SELECT count(*) 
FROM myTable 
WHERE isSubnetOf('192.168.0.1/24', ipAddressCol) 
OR isSubnetOf(ipPrefixCol, '7890:db8:113::8a2e:370:7336');

SELECT 
    CASE 
        WHEN isSubnetOf('105.25.245.115/27', srcIPAddress) THEN 'case1' 
        WHEN isSubnetOf('105.25.245.115/27', dstIPAddress) THEN 'case2'
        ELSE 'case3' 
    END AS differentFlow
FROM myTable;

select DivAirportIDs, 
       arrayRemoveInt(DivAirportIDs, 12892) AS value
from airlineStats 
WHERE arraylength(DivAirportIDs) >= 2
AND arrayContainsInt(DivAirportIDs, 12892) = 1
limit 5

select DivTailNums, 
       DivAirports,
       arrayUnionString(DivTailNums, DivAirports) AS unionIds
from airlineStats 
WHERE arraylength(DivTailNums) >= 2
limit 5

select FlightNum, 
       arraySortString(RandomAirports) AS sortedAirports, 
       RandomAirports
from airlineStats 
WHERE arraylength(RandomAirports) BETWEEN 2 AND 4
limit 5

select mode(yearID, 'AVG') AS value
from baseballStats 
WHERE AtBatting != 0 AND yearID > 2001

select mode(yearID, 'MIN') AS value
from baseballStats 
WHERE AtBatting != 0 AND yearID > 2001

select mode(yearID, 'MAX') AS value
from baseballStats 
WHERE AtBatting != 0 AND yearID > 2001

select PERCENTILEMV(DivLongestGTimes, 90) AS value
from airlineStats 
where arraylength(DivLongestGTimes) > 1

select PERCENTILEMV(DivLongestGTimes, 99.9) AS value
from airlineStats 
where arraylength(DivLongestGTimes) > 1

select percentileest(homeRuns, 80) AS value
from baseballStats 

select percentileest(homeRuns, 99.9) AS value
from baseballStats 

select PERCENTILETDIGESTMV(DivLongestGTimes, 90) AS value
from airlineStats 
where arraylength(DivLongestGTimes) > 1

select PERCENTILETDIGESTMV(DivLongestGTimes, 99.9) AS value
from airlineStats 
where arraylength(DivLongestGTimes) > 1

SELECT HISTOGRAM(numberOfGames, 0, 200, 10) AS histogram
FROM baseballStats 

select HISTOGRAM(AtBatting, Array['-Infinity', 1, 10, 50, 100, 500, 1000]) AS histogram
from baseballStats

select PERCENTILEESTMV(DivLongestGTimes, 90) AS value
from airlineStats 
where arraylength(DivLongestGTimes) > 1

select PERCENTILEESTMV(DivLongestGTimes, 99.9) AS value
from airlineStats 
where arraylength(DivLongestGTimes) > 1