select ABS(-12.1) AS value
from ignoreMe

select ABS(12.1) AS value
from ignoreMe

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

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

select FLOOR(12.1) AS value
from ignoreMe

select FLOOR(-12.1) AS value
from ignoreMe

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

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

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

select remove('foo bar foo sheep', 'foo') AS value
from ignoreMe

SELECT CHR(65) AS value
FROM ignoreMe

select min(yearID) AS value
from baseballStats 

SELECT REPLACE('Hello, World', 'Hello', 'Goodbye') AS value
FROM ignoreMe

SELECT REPLACE('Hello, World', 'Hellow', 'Goodbye') AS value
FROM ignoreMe

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

select max(homeRuns) AS value
from baseballStats 

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

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

select DISTINCTCOUNT(league) AS value
from baseballStats 

select DISTINCTCOUNT(teamID) AS value
from baseballStats 

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

select hour(1639351800000) AS hour
FROM ignoreMe

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

select day(1639351800000) AS day
FROM ignoreMe

select EXP(1) AS value
from ignoreMe

select EXP(12) AS value
from ignoreMe

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

select LOWER('Pinot') AS name
FROM ignoreMe

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

select MINMAXRANGE(yearID) AS value
from baseballStats 

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

select millisecond(1639351800000) AS millisecond
FROM ignoreMe

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

SELECT COVAR_POP(numberOfGames, hits) AS covariance 
FROM baseballStats

select percentile(homeRuns, 50) AS value
from baseballStats 

SELECT length('Pinot') AS value
FROM ignoreMe

select DISTINCTCOUNTHLL(teamID) AS value
from baseballStats 

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

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

select quarter(1633046399000) AS quarter
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 REVERSE('Pinot') AS name
FROM ignoreMe

select percentileest(homeRuns, 50) AS value
from baseballStats 

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

select now() AS now
FROM ignoreMe

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

select DISTINCTCOUNTBITMAP(league) AS value
from baseballStats 

select PERCENTILETDigest(homeRuns, 50) AS value
from baseballStats 

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

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

select DivTailNums
from airlineStats 
where arraylength(DivTailNums) > 1

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

SELECT COVAR_SAMP(numberOfGames, AtBatting) AS covariance 
FROM baseballStats

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

select dayOfWeek(1639351800000) AS dayOfWeek
FROM ignoreMe

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 mode(yearID) AS value
from baseballStats 
WHERE AtBatting != 0 AND yearID > 2001

select DivTailNums
from airlineStats 
where arraylength(DivTailNums) > 1

select dayOfYear(1639351800000) AS dayOfYear
FROM ignoreMe

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

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

select DISTINCTCOUNTBITMAPMV(DivLongestGTimes) 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 day(1639351800000, 'CET') AS day
FROM ignoreMe

select dayOfMonth(1639351800000) AS day
FROM ignoreMe

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

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

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 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 percentile(homeRuns, 80) AS value
from baseballStats 

select percentile(homeRuns, 99.9) AS value
from baseballStats 

select DISTINCTCOUNTHLL(teamID, 12) AS value
from baseballStats 

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

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

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 DISTINCTCOUNTBITMAP(teamID) AS value
from baseballStats 

select PERCENTILETDigest(homeRuns, 80) AS value
from baseballStats 

select PERCENTILETDigest(homeRuns, 99.9) AS value
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

select DISTINCTCOUNTMV(DivTailNums) AS value
from airlineStats 
where arraylength(DivTailNums) > 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

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

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

select dow(1639351800000) AS dayOfWeek
FROM ignoreMe

select dow(1639351800000, 'CET') AS dayOfWeek
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 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 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 COUNTMV(DivTailNums) AS value
from airlineStats 
where arraylength(DivTailNums) > 1

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

select doy(1639351800000) AS dayOfYear
FROM ignoreMe

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

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 DISTINCTCOUNTBITMAPMV(DivTailNums) AS value
from airlineStats 
where arraylength(DivTailNums) > 1

select regexpExtract('foo', '.*') AS value
from ignoreMe

select regexpExtract('foo123', '[0-9]+') AS value
from ignoreMe

select regexpExtract('foo123', '[^0-9]+') AS value
from ignoreMe

select regexpExtract('foo bar baz', '(\w+) (\w+)', 0) AS value
from ignoreMe

select regexpExtract('foo bar baz', '(\w+) (\w+)', 2) AS value
from ignoreMe

select regexpExtract('foo123', 'bar', 0, 'defaultValue') AS value
from ignoreMe

select count(*) AS value
from baseballStats 

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 DISTINCT league AS value
from baseballStats 

select DISTINCT(league) AS value
from baseballStats 

{
  "data": {
    "name": "Pete",
    "age": 24,
    "subjects": [
      {
        "name": "maths",
        "homework_grades": [80, 85, 90, 95, 100],
        "grade": "A",
        "score": 90
      },
      {
        "name": "english",
        "homework_grades": [60, 65, 70, 85, 90],
        "grade": "B",
        "score": 70
      }
    ]
  }
}

{
   "tableConfig":{
      "ingestionConfig":{
         "transformConfigs":[
            {
               "columnName":"age",
               "transformFunction":"JSONPATHDOUBLE(data, '$.age')"
            }
         ]
      }
   }
}

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

select distinctCountThetaSketch(teamID) AS value
from baseballStats