Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
This section contains reference documentation for the ago function.
select mvCol1,
arrayConcatLong(mvCol1, mvCol2) AS concatLongs
from multiValueTable
WHERE arraylength(mvCol1) >= 2
limit 5select ABS(-12.1) AS value
from ignoreMeselect ABS(12.1) AS value
from ignoreMeselect homeRuns, baseOnBalls, ADD(homeRuns, baseOnBalls) AS total
from baseballStats
WHERE teamID = 'ML1'
AND yearID = 1956
AND playerName = 'Henry Louis'select count(*) AS value
from baseballStats select CEIL(12.1) AS value
from ignoreMeselect CEIL(-12.1) AS value
from ignoreMeselect mvCol1,
arrayConcatDouble(mvCol1, mvCol2) AS concatDoubles
from multiValueTable
WHERE arraylength(mvCol1) >= 2
limit 5SELECT CHR(65) AS value
FROM ignoreMeselect ago("P1D") AS oneDayAgo
FROM ignoreMeSELECT *
FROM tableName
WHERE tsInMillis > ago("P1D")select DivAirportIDs,
arrayDistinctInt(DivAirportIDs) AS unique
from airlineStats
WHERE arraylength(DivAirportIDs) >= 2
limit 5select DivAirportIDs,
arrayRemoveInt(DivAirportIDs, 12892) AS value
from airlineStats
WHERE arraylength(DivAirportIDs) >= 2
AND arrayContainsInt(DivAirportIDs, 12892) = 1
limit 5select DivTailNums,
arrayConcatString(DivTailNums, DivTailNums) AS concatIds
from airlineStats
WHERE arraylength(DivTailNums) >= 2
limit 5This section contains reference documentation for base64 encode and decode functions.
This section contains reference documentation for the fromEpochBucket functions.
This page contains reference documentation for functions in Apache Pinot.
select AVGMV(DivLongestGTimes) AS value
from airlineStats
where arraylength(DivLongestGTimes) > 1SELECT COVAR_SAMP(numberOfGames, AtBatting) AS covariance
FROM baseballStatsselect DISTINCTCOUNTHLLMV(DivLongestGTimes) AS value
from airlineStats
where arraylength(DivLongestGTimes) > 1select dayOfYear(1639351800000) AS dayOfYear
FROM ignoreMeselect DISTINCTCOUNTRAWHLLMV(DivAirports) AS value
from airlineStats
where arraylength(DivAirports) > 1select day(1639351800000) AS day
FROM ignoreMeSELECT DISTINCTAVGMV(DivLongestGTimes) AS VALUE
FROM airlineStats
WHERE arraylength(DivLongestGTimes) > 1select DivTailNums,
arrayIndexOfString(DivTailNums, 'N7713A') AS index
from airlineStats
WHERE arraylength(DivTailNums) >= 2
limit 5select LOWER('Pinot') AS name
FROM ignoreMeselect MINMV(DivLongestGTimes) AS value
from airlineStats
where arraylength(DivLongestGTimes) > 1select EXP(1) AS value
from ignoreMeselect EXP(12) AS value
from ignoreMeselect min(yearID) AS value
from baseballStats select max(homeRuns) AS value
from baseballStats select MOD(12, 5) AS value
from ignoreMeselect MOD(12, 2) AS value
from ignoreMeSELECT length('Pinot') AS value
FROM ignoreMeselect DISTINCTCOUNTBITMAPMV(DivLongestGTimes) AS value
from airlineStats
where arraylength(DivLongestGTimes) > 1select DivTailNums
from airlineStats
where arraylength(DivTailNums) > 1select DivTailNums,
arrayContainsString(DivTailNums, 'N7713A') AS index
from airlineStats
WHERE arraylength(DivTailNums) >= 2
limit 5SELECT DISTINCTSUM(runs) AS VALUE
FROM baseballStatsSELECT SUM(DISTINCT AtBatting) AS VALUE
FROM baseballStatsselect DISTINCTCOUNTRAWHLL(teamID) AS value
from baseballStats SELECT concat('Apache', 'Pinot', ' ') AS value
FROM ignoreMeSELECT concat('real-time', 'analytics', '__') AS value
FROM ignoreMeSELECT DISTINCTSUMMV(DivLongestGTimes) AS VALUE
FROM airlineStats
WHERE arraylength(DivLongestGTimes) > 1SELECT LPAD('Hello, World', '20', '*') AS value
FROM ignoreMe{"timestamp": "2019-10-09 21:25:25", "meta": {"age": 12}}select FLOOR(12.1) AS value
from ignoreMeselect FLOOR(-12.1) AS value
from ignoreMeselect DivTailNums
from airlineStats
where arraylength(DivTailNums) > 1select event_id, location, MD5(location) AS hash
from meetupRsvp
limit 1select MINMAXRANGE(yearID) AS value
from baseballStats select DISTINCTCOUNTHLL(teamID) AS value
from baseballStats select millisecond(1639351800000) AS millisecond
FROM ignoreMeselect millisecond(1639351800000, 'America/St_Johns') AS millisecond
FROM ignoreMeselect MINMAXRANGEMV(DivLongestGTimes) AS value
from airlineStats
where arraylength(DivLongestGTimes) > 1select hour(1639351800000) AS hour
FROM ignoreMeselect hour(1639351800000, 'CET') AS hour
FROM ignoreMeselect FlightNum,
arraySortString(RandomAirports) AS sortedAirports,
RandomAirports
from airlineStats
WHERE arraylength(RandomAirports) BETWEEN 2 AND 4
limit 5select DivAirportIDs,
arrayContainsInt(DivAirportIDs, 14683) AS containsValue
from airlineStats
WHERE arraylength(DivAirportIDs) >= 2
limit 5select DivTailNums,
DivAirports,
arrayUnionString(DivTailNums, DivAirports) AS unionIds
from airlineStats
WHERE arraylength(DivTailNums) >= 2
limit 5select dayOfYear(1639351800000, 'CET') AS dayOfYear
FROM ignoreMeselect doy(1639351800000) AS dayOfYear
FROM ignoreMeselect doy(1639351800000, 'CET') AS dayOfYear
FROM ignoreMeselect DISTINCTCOUNTRAWHLLMV(DivAirports, 1) AS value
from airlineStats
where arraylength(DivAirports) > 1select RandomAirports,
arrayRemoveString(RandomAirports, 'SEA') AS value
from airlineStats
WHERE arraylength(RandomAirports) BETWEEN 2 AND 4
limit 5select day(1639351800000, 'CET') AS day
FROM ignoreMeselect dayOfMonth(1639351800000) AS day
FROM ignoreMeselect dayOfMonth(1639351800000, 'CET') AS day
FROM ignoreMeselect DivAirportIDs,
arrayIndexOfInt(DivAirportIDs, 14683) AS index
from airlineStats
WHERE arraylength(DivAirportIDs) >= 2
limit 5select DISTINCTCOUNTBITMAPMV(DivTailNums) AS value
from airlineStats
where arraylength(DivTailNums) > 1select COUNTMV(DivTailNums) AS value
from airlineStats
where arraylength(DivTailNums) > 1select ARRAYLENGTH(RandomAirports) AS length, count(*)
from airlineStats
GROUP BY length
ORDER BY count(*) DESC
LIMIT 5select DISTINCT league AS value
from baseballStats select DISTINCT(league) AS value
from baseballStats SELECT FromDateTime('2019-08-07', 'yyyy-MM-dd') AS epochMillis
FROM ignoreMeSELECT FromDateTime(
'2019-08-07 3:12:13 PM',
'yyyy-MM-dd hh:mm:ss a'
) AS epochMillis
FROM ignoreMeSELECT FromDateTime(
'2019-08-07T15:12:13',
'yyyy-MM-dd''T''HH:mm:ss'
) AS epochMillis
FROM ignoreMeSELECT FromDateTime(
'2019-08-07T07:12:13-0800',
'yyyy-MM-dd''T''HH:mm:ssZ'
) AS epochMillis
FROM ignoreMeSELECT toBase64(toUtf8('hello!')) AS encoded
FROM ignoreMeSELECT fromUtf8(fromBase64('aGVsbG8h')) AS decoded
FROM ignoreMeSELECT fromBase64('aGVsbG8h') AS decoded
FROM ignoreMeSELECT toBase64('hello!') AS encoded
FROM ignoreMeselect DISTINCTCOUNTRAWHLL(teamID, 1) AS value
from baseballStats SELECT HISTOGRAM(numberOfGames, 0, 200, 10) AS histogram
FROM baseballStats select HISTOGRAM(AtBatting, Array['-Infinity', 1, 10, 50, 100, 500, 1000]) AS histogram
from baseballStatsselect DivTailNums,
arrayDistinctString(DivTailNums) AS unique
from airlineStats
WHERE arraylength(DivTailNums) >= 2
limit 5{
"tableConfig":{
"ingestionConfig":{
"transformConfigs":[
{
"columnName":"data",
"transformFunction":"JSONFORMAT(meta)"
}
]
}
}
}select DISTINCTCOUNTMV(DivTailNums) AS value
from airlineStats
where arraylength(DivTailNums) > 1select DivAirportIDs,
arraySortInt(DivAirportIDs) AS sortedIds
from airlineStats
WHERE arraylength(DivAirportIDs) >= 2
limit 5select FromEpochSecondsBucket(1613472303, 1) AS bucket
FROM ignoreMeselect FromEpochSecondsBucket(1613472303, 2) AS bucket
FROM ignoreMeselect FromEpochMinutesBucket(2689120, 10) AS bucket
FROM ignoreMeselect FromEpochHoursBucket(89637, 5) AS bucket
FROM ignoreMeselect FromEpochDaysBucket(1867, 10) AS bucket
FROM ignoreMeselect DISTINCTCOUNTHLL(teamID, 12) AS value
from baseballStats select FlightNum,
arraySliceString(RandomAirports, 0, 2) AS airports,
RandomAirports
from airlineStats
WHERE arraylength(RandomAirports) BETWEEN 2 AND 4
limit 5select FlightNum,
arraySliceInt(DivAirportIDs, 0, 1) AS airports,
DivAirportIDs
from airlineStats
WHERE arraylength(DivAirportIDs) >= 2
limit 5select FlightNum,
arrayReverseString(RandomAirports) AS reversedAirports,
RandomAirports
from airlineStats
WHERE arraylength(RandomAirports) BETWEEN 2 AND 4
limit 5SELECT 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 falseSELECT 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 falseselect ln(1) AS value
from ignoreMeselect ln(12) AS value
from ignoreMeSELECT ' Pinot with spaces ' AS notTrimmed,
ltrim(' Pinot with spaces ') AS trimmed
FROM ignoreMeselect MAXMV(DivLongestGTimes) AS value
from airlineStats
where arraylength(DivLongestGTimes) > 1select homeRuns, numberOfGames, DIV(homeRuns, numberOfGames) AS total
from baseballStats
WHERE teamID = 'ML1'
AND yearID = 1956
AND playerName = 'Henry Louis'select minute(1639351800000) AS minute
FROM ignoreMeselect minute(1639351800000, 'America/St_Johns') AS minute
FROM ignoreMeselect DISTINCTCOUNT(league) AS value
from baseballStats select DISTINCTCOUNT(teamID) AS value
from baseballStats select mode(yearID) AS value
from baseballStats
WHERE AtBatting != 0 AND yearID > 2001SELECT 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 DivWheelsOffs,
DivWheelsOns,
arrayUnionInt(DivWheelsOffs, DivWheelsOns) AS unionIds
from airlineStats
WHERE arraylength(DivWheelsOffs) >= 2
limit 5select FromEpochSeconds(1613472303) AS epochMillis
FROM ignoreMeselect FromEpochMinutes(26891205) AS epochMillis
FROM ignoreMeselect FromEpochHours(448186) AS epochMillis
FROM ignoreMeselect FromEpochDays(18674) AS epochMillis
FROM ignoreMeselect mode(yearID, 'AVG') AS value
from baseballStats
WHERE AtBatting != 0 AND yearID > 2001select mode(yearID, 'MIN') AS value
from baseballStats
WHERE AtBatting != 0 AND yearID > 2001select mode(yearID, 'MAX') AS value
from baseballStats
WHERE AtBatting != 0 AND yearID > 2001select distinctCountRawThetaSketch(teamID) AS value
from baseballStats select distinctCountRawThetaSketch(teamID, 'nominalEntries=10') AS value
from baseballStatsselect distinctCountRawThetaSketch(
yearID,
'nominalEntries=4096',
'teamID = ''SFN'' AND numberOfGames=28 AND homeRuns=1',
'teamID = ''CHN'' AND numberOfGames=28 AND homeRuns=1',
'SET_INTERSECT($1, $2)'
) AS value
from baseballStats select id, repo, JSONEXTRACTKEY(repo, '$.*') AS keys
from githubEvents
WHERE id = 7044874109select percentile(homeRuns, 50) AS value
from baseballStats select month(1633046399000, 'UTC') AS month
FROM ignoreMeselect month(1633046399000, 'CET') AS month
FROM ignoreMeSELECT COVAR_POP(numberOfGames, hits) AS covariance
FROM baseballStatsselect percentileest(homeRuns, 50) AS value
from baseballStats select now() AS now
FROM ignoreMeSELECT *
FROM tableName
WHERE tsInMillis > now() - 86400000select PERCENTILEESTMV(DivLongestGTimes, 50) AS value
from airlineStats
where arraylength(DivLongestGTimes) > 1select homeRuns, baseOnBalls, MULT(homeRuns, baseOnBalls) AS total
from baseballStats
WHERE teamID = 'ML1'
AND yearID = 1956
AND playerName = 'Henry Louis'select mvCol1,
arrayConcatFloat(mvCol1, mvCol2) AS concatFloats
from multiValueTable
WHERE arraylength(mvCol1) >= 2
limit 5select PERCENTILETDigest(homeRuns, 50) AS value
from baseballStats select PERCENTILEMV(DivLongestGTimes, 50) AS value
from airlineStats
where arraylength(DivLongestGTimes) > 1select quarter(1633046399000) AS quarter
FROM ignoreMe{
"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 dateTrunc('week', 1639480981746) AS ts
FROM ignoreMeselect dateTrunc('week', 1639480981746, 'MILLISECONDS') AS ts
FROM ignoreMeselect dateTrunc(
'week',
1639480981746,
'MILLISECONDS',
'UTC',
'SECONDS'
) AS ts
FROM ignoreMeselect dateTrunc(
'week',
1639480981746,
'MILLISECONDS',
'CET',
'SECONDS'
) AS ts
FROM ignoreMeselect dateTrunc(
'quarter',
1639480981746,
'MILLISECONDS',
'America/Los_Angeles',
'HOURS'
) AS ts
FROM ignoreMe{
"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')"
}
]
}
}
}select repo
from githubEvents
WHERE id = 7044874109select id, jsonextractscalar(repo, '$.name', 'STRING') AS name
from githubEvents
WHERE id = 7044874109select id, jsonextractscalar(repo, '$.foo', 'STRING') AS name
from githubEvents
WHERE id = 7044874109[
{
"message": "QueryExecutionError:\njava.lang.RuntimeException: Illegal Json Path: [$.foo], when reading [{\"id\":115911530,\"name\":\"LimeVista/Tapes\",\"url\":\"https://api.github.com/repos/LimeVista/Tapes\"}]\n\tat org.apache.pinot.core.operator.transform.function.JsonExtractScalarTransformFunction.transformToStringValuesSV(JsonExtractScalarTransformFunction.java:254)\n\tat org.apache.pinot.core.operator.docvalsets.TransformBlockValSet.getStringValuesSV(TransformBlockValSet.java:90)\n\tat org.apache.pinot.core.common.RowBasedBlockValueFetcher.createFetcher(RowBasedBlockValueFetcher.java:64)\n\tat org.apache.pinot.core.common.RowBasedBlockValueFetcher.<init>(RowBasedBlockValueFetcher.java:32)",
"errorCode": 200
}
]select id, jsonextractscalar(repo, '$.foo', 'STRING', 'dummyValue') AS name
from githubEvents
WHERE id = 7044874109{
"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\"]')"
}
]
}
}
}{
"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 percentile(homeRuns, 80) AS value
from baseballStats select percentile(homeRuns, 99.9) AS value
from baseballStats select percentileest(homeRuns, 80) AS value
from baseballStats select percentileest(homeRuns, 99.9) AS value
from baseballStats select PERCENTILEESTMV(DivLongestGTimes, 90) AS value
from airlineStats
where arraylength(DivLongestGTimes) > 1select PERCENTILEESTMV(DivLongestGTimes, 99.9) AS value
from airlineStats
where arraylength(DivLongestGTimes) > 1select PERCENTILETDigest(homeRuns, 80) AS value
from baseballStats select PERCENTILETDigest(homeRuns, 99.9) AS value
from baseballStats select PERCENTILEMV(DivLongestGTimes, 90) AS value
from airlineStats
where arraylength(DivLongestGTimes) > 1select PERCENTILEMV(DivLongestGTimes, 99.9) AS value
from airlineStats
where arraylength(DivLongestGTimes) > 1select quarter(1633046399000, 'UTC') AS quarter
FROM ignoreMeselect quarter(1633046399000, 'CET') AS quarter
FROM ignoreMe{
"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":"JSONPATHARRAY(data, '$.subjects[*].name')"
},
{
"columnName":"ages",
"transformFunction":"JSONPATHARRAY(data, '$.subjects[*].score')"
},
{
"columnName":"homeworkGrades",
"transformFunction":"JSONPATHARRAY(data, '$.subjects[*].homework_grades[1]')"
}
]
}
}
}nominalEntries (defaults to 4096).SELECT CODEPOINT('Apache Pinot') AS value
FROM ignoreMeSELECT DISTINCTAVG(runs) AS VALUE
FROM baseballStatsselect dayOfWeek(1639351800000) AS dayOfWeek
FROM ignoreMeselect distinctCountThetaSketch(teamID) AS value
from baseballStats select distinctCountThetaSketch(teamID, 'nominalEntries=10') AS value
from baseballStatsselect yearID
from baseballStats
where teamID = 'SFN' AND numberOfGames = 28 AND homeRuns = 1select yearID
from baseballStats
where teamID = 'CHN' AND numberOfGames = 28 AND homeRuns = 1select distinctCountThetaSketch(
yearID,
'nominalEntries=4096',
'teamID = ''SFN'' AND numberOfGames=28 AND homeRuns=1',
'teamID = ''CHN'' AND numberOfGames=28 AND homeRuns=1',
'SET_INTERSECT($1, $2)'
) AS value
from baseballStats SELECT AVG(DISTINCT AtBatting) AS VALUE
FROM baseballStatsselect DivWheelsOffs,
arrayConcatInt(DivWheelsOffs, DivWheelsOns) AS concatIds
from airlineStats
WHERE arraylength(DivWheelsOffs) >= 2
limit 5select dayOfWeek(1639351800000, 'CET') AS dayOfWeek
FROM ignoreMeselect dow(1639351800000) AS dayOfWeek
FROM ignoreMeselect dow(1639351800000, 'CET') AS dayOfWeek
FROM ignoreMeThis section contains reference documentation for the DATETIMECONVERT function.
MICROSECONDSNANOSECONDSselect PERCENTILETDIGESTMV(DivLongestGTimes, 50) AS value
from airlineStats
where arraylength(DivLongestGTimes) > 1select DISTINCTCOUNTBITMAP(league) AS value
from baseballStats select id,
created_at_timestamp,
cast(created_at_timestamp AS long) AS timeInMs,
DATETIMECONVERT(
created_at_timestamp,
'1:MILLISECONDS:EPOCH',
'1:DAYS:EPOCH',
'1:DAYS'
) AS convertedTime
from githubEvents
WHERE id = 7044874134select id,
created_at_timestamp,
cast(created_at_timestamp AS long) AS timeInMs,
DATETIMECONVERT(
created_at_timestamp,
'1:MILLISECONDS:EPOCH',
'1:MILLISECONDS:EPOCH',
'15:MINUTES'
) AS convertedTime
from githubEvents
WHERE id = 7044874134select id,
created_at_timestamp,
cast(created_at_timestamp AS long) AS timeInMs,
DATETIMECONVERT(
created_at_timestamp,
'1:MILLISECONDS:EPOCH',
'1:DAYS:SIMPLE_DATE_FORMAT:yyyy-MM-dd',
'1:DAYS'
) AS convertedTime
from githubEvents
WHERE id = 7044874134select id,
created_at_timestamp,
cast(created_at_timestamp AS long) AS timeInMs,
DATETIMECONVERT(
created_at_timestamp,
'1:MILLISECONDS:EPOCH',
'1:MILLISECONDS:SIMPLE_DATE_FORMAT:yyyy-MM-dd HH:mm tz(Pacific/Kiritimati)',
'1:MILLISECONDS'
) AS convertedTime
from githubEvents
WHERE id = 7044874134select id,
created_at_timestamp,
cast(created_at_timestamp AS long) AS timeInMs,
DATETIMECONVERT(
created_at_timestamp,
'1:MILLISECONDS:EPOCH',
'1:MILLISECONDS:SIMPLE_DATE_FORMAT:yyyy-MM-dd HH:mm tz(Pacific/Kiritimati)',
'1:DAYS'
) AS convertedTime
from githubEvents
WHERE id = 7044874134select DivAirportIDs,
arrayReverseInt(DivAirportIDs) AS reversedIds
from airlineStats
WHERE arraylength(DivAirportIDs) >= 2
limit 5select PERCENTILETDIGESTMV(DivLongestGTimes, 90) AS value
from airlineStats
where arraylength(DivLongestGTimes) > 1select PERCENTILETDIGESTMV(DivLongestGTimes, 99.9) AS value
from airlineStats
where arraylength(DivLongestGTimes) > 1select DISTINCTCOUNTBITMAP(teamID) AS value
from baseballStats