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

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

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

select count(*) AS value
from baseballStats 

select CEIL(12.1) AS value
from ignoreMe

select CEIL(-12.1) AS value
from ignoreMe

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

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

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

select now() AS now
FROM ignoreMe

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

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

SELECT DISTINCTSUM(runs) AS VALUE
FROM baseballStats

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

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

select ln(1) AS value
from ignoreMe

select ln(12) AS value
from ignoreMe

SELECT SUM(DISTINCT AtBatting) 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 DivTailNums, 
       arrayDistinctString(DivTailNums) AS unique
from airlineStats 
WHERE arraylength(DivTailNums) >= 2
limit 5

select DivTailNums
from airlineStats 
where arraylength(DivTailNums) > 1

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

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

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

select dayOfWeek(1639351800000) AS dayOfWeek
FROM ignoreMe

select MOD(12, 5) AS value
from ignoreMe

select MOD(12, 2) AS value
from ignoreMe

SELECT DISTINCTAVG(runs) AS VALUE
FROM baseballStats

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

SELECT COVAR_SAMP(numberOfGames, AtBatting) AS covariance 
FROM baseballStats

select DISTINCTCOUNTBITMAP(league) AS value
from baseballStats 

select DISTINCTCOUNTRAWHLL(teamID) AS value
from baseballStats 

select minute(1639351800000) AS minute
FROM ignoreMe

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

select percentile(homeRuns, 50) AS value
from baseballStats 

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

select DISTINCTCOUNT(league) AS value
from baseballStats 

select DISTINCTCOUNT(teamID) AS value
from baseballStats 

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

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

select dow(1639351800000) AS dayOfWeek
FROM ignoreMe

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

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 DivTailNums, 
       DivAirports,
       arrayUnionString(DivTailNums, DivAirports) AS unionIds
from airlineStats 
WHERE arraylength(DivTailNums) >= 2
limit 5

SELECT AVG(DISTINCT AtBatting) AS VALUE
FROM baseballStats

select DISTINCTCOUNTBITMAP(teamID) AS value
from baseballStats 

select DISTINCTCOUNTRAWHLL(teamID, 1) AS value
from baseballStats 

select ago("P1D") AS oneDayAgo
FROM ignoreMe

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

select percentile(homeRuns, 80) AS value
from baseballStats 

select percentile(homeRuns, 99.9) 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 DivTailNums, 
       arrayConcatString(DivTailNums, DivTailNums) AS concatIds
from airlineStats 
WHERE arraylength(DivTailNums) >= 2
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 DivWheelsOffs, 
       DivWheelsOns,
       arrayUnionInt(DivWheelsOffs, DivWheelsOns) AS unionIds
from airlineStats 
WHERE arraylength(DivWheelsOffs) >= 2
limit 5

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

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

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

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

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

select quarter(1633046399000) AS quarter
FROM ignoreMe

select max(homeRuns) AS value
from baseballStats 

select percentileest(homeRuns, 50) AS value
from baseballStats 

select millisecond(1639351800000) AS millisecond
FROM ignoreMe

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

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

SELECT CHR(65) AS value
FROM ignoreMe

select DISTINCT league AS value
from baseballStats 

select DISTINCT(league) AS value
from baseballStats 

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

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 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 HISTOGRAM(numberOfGames, 0, 200, 10) AS histogram
FROM baseballStats 

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

{
  "data": {
    "name": {"full.name": "Peter", "nick.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":"JSONPATHSTRING(data, '$.age')"
            },
            {
               "columnName":"nickName",
               "transformFunction":"JSONPATHSTRING(data, '$.name[\"nick.name\"]')"
            }
         ]
      }
   }
}

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

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

select ABS(-12.1) AS value
from ignoreMe

select ABS(12.1) AS value
from ignoreMe

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

{
  "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":"names",
               "transformFunction":"JSONPATHARRAYDEFAULTEMPTY(data, '$.subjects[*].name')"
            },
            {
               "columnName":"ages",
               "transformFunction":"JSONPATHARRAYDEFAULTEMPTY(data, '$.subjects[*].score')"
            },
            {
               "columnName":"homeworkGrades",
               "transformFunction":"JSONPATHARRAYDEFAULTEMPTY(data, '$.subjects[*].homework_grades[1]')"
            }
         ]
      }
   }
}

{
  "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":"JSONPATHLONG(data, '$.age')"
            }
         ]
      }
   }
}

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

{
  "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":"name",
               "transformFunction":"JSONPATHSTRING(data, '$.name')"
            },
            {
               "columnName":"age",
               "transformFunction":"JSONPATHSTRING(data, '$.age')"
            }
         ]
      }
   }
}

{
  "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 day(1639351800000) AS day
FROM ignoreMe

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

select DISTINCTCOUNTHLL(teamID) AS value
from baseballStats 

select LOWER('Pinot') AS name
FROM ignoreMe

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

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

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

select EXP(1) AS value
from ignoreMe

select EXP(12) AS value
from ignoreMe

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

SELECT CODEPOINT('Apache Pinot') AS value
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

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

select DISTINCTCOUNTHLL(teamID, 12) AS value
from baseballStats 

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

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

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

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

select dayOfYear(1639351800000) AS dayOfYear
FROM ignoreMe

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

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

select min(yearID) AS value
from baseballStats 

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

select doy(1639351800000) AS dayOfYear
FROM ignoreMe

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

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

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 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 ARRAYLENGTH(RandomAirports) AS length, count(*) 
from airlineStats 
GROUP BY length
ORDER BY count(*) DESC
LIMIT 5