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...
select 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 CODEPOINT('Apache Pinot') AS value
FROM ignoreMeselect DivWheelsOffs,
arrayConcatInt(DivWheelsOffs, DivWheelsOns) AS concatIds
from airlineStats
WHERE arraylength(DivWheelsOffs) >= 2
limit 5select DivTailNums,
arrayContainsString(DivTailNums, 'N7713A') AS index
from airlineStats
WHERE arraylength(DivTailNums) >= 2
limit 5select DivTailNums,
arrayIndexOfString(DivTailNums, 'N7713A') AS index
from airlineStats
WHERE arraylength(DivTailNums) >= 2
limit 5select AVGMV(DivLongestGTimes) AS value
from airlineStats
where arraylength(DivLongestGTimes) > 1select CEIL(12.1) AS value
from ignoreMeselect CEIL(-12.1) AS value
from ignoreMeSELECT CHR(65) AS value
FROM ignoreMeselect DivTailNums
from airlineStats
where arraylength(DivTailNums) > 1select day(1639351800000) AS day
FROM ignoreMeselect DISTINCTCOUNTHLLMV(DivLongestGTimes) AS value
from airlineStats
where arraylength(DivLongestGTimes) > 1select DISTINCTCOUNTHLL(teamID) AS value
from baseballStats select DISTINCTCOUNTBITMAPMV(DivLongestGTimes) AS value
from airlineStats
where arraylength(DivLongestGTimes) > 1select DivTailNums
from airlineStats
where arraylength(DivTailNums) > 1select homeRuns, numberOfGames, DIV(homeRuns, numberOfGames) AS total
from baseballStats
WHERE teamID = 'ML1'
AND yearID = 1956
AND playerName = 'Henry Louis'select FLOOR(12.1) AS value
from ignoreMeselect FLOOR(-12.1) AS value
from ignoreMeselect hour(1639351800000) AS hour
FROM ignoreMeselect hour(1639351800000, 'CET') AS hour
FROM ignoreMeselect MINMAXRANGE(yearID) AS value
from baseballStats select count(*) AS value
from baseballStats SELECT LPAD('Hello, World', '20', '*') AS value
FROM ignoreMeselect MINMV(DivLongestGTimes) AS value
from airlineStats
where arraylength(DivLongestGTimes) > 1select MOD(12, 5) AS value
from ignoreMeselect MOD(12, 2) AS value
from ignoreMeselect ln(1) AS value
from ignoreMeselect ln(12) AS value
from ignoreMeselect remove('foo bar foo sheep', 'foo') AS value
from ignoreMeSELECT ' Pinot with spaces ' AS notTrimmed,
ltrim(' Pinot with spaces ') AS trimmed
FROM ignoreMeselect REVERSE('Pinot') AS name
FROM ignoreMeselect EXP(1) AS value
from ignoreMeselect EXP(12) AS value
from ignoreMeSELECT ' Pinot with spaces ' AS notTrimmed,
rtrim(' Pinot with spaces ') AS trimmed
FROM ignoreMeSELECT RPAD('Hello, World', '20', '*') AS value
FROM ignoreMeSELECT REPLACE('Hello, World', 'Hello', 'Goodbye') AS value
FROM ignoreMeSELECT REPLACE('Hello, World', 'Hellow', 'Goodbye') AS value
FROM ignoreMeselect MINMAXRANGEMV(DivLongestGTimes) AS value
from airlineStats
where arraylength(DivLongestGTimes) > 1select dayOfYear(1639351800000) AS dayOfYear
FROM ignoreMeselect dayOfWeek(1639351800000) AS dayOfWeek
FROM ignoreMeselect DISTINCTCOUNT(league) AS value
from baseballStats select DISTINCTCOUNT(teamID) AS value
from baseballStats select DISTINCTCOUNTBITMAP(league) AS value
from baseballStats select DISTINCTCOUNTHLL(teamID) AS value
from baseballStats select LOWER('Pinot') AS name
FROM ignoreMeselect event_id, location, MD5(location) AS hash
from meetupRsvp
limit 1select minute(1639351800000) AS minute
FROM ignoreMeselect minute(1639351800000, 'America/St_Johns') AS minute
FROM ignoreMeselect MAXMV(DivLongestGTimes) AS value
from airlineStats
where arraylength(DivLongestGTimes) > 1select DISTINCTCOUNTRAWHLLMV(DivAirports) AS value
from airlineStats
where arraylength(DivAirports) > 1select month(1633046399000, 'UTC') AS month
FROM ignoreMeselect month(1633046399000, 'CET') AS month
FROM ignoreMeselect now() AS now
FROM ignoreMeSELECT *
FROM tableName
WHERE tsInMillis > now() - 86400000{"timestamp": "2019-10-09 21:25:25", "meta": {"age": 12}}SELECT length('Pinot') AS value
FROM ignoreMeselect min(yearID) AS value
from baseballStats select event_id, location, SHA(location) AS hash
from meetupRsvp
limit 1select percentile(homeRuns, 50) AS value
from baseballStats select percentileest(homeRuns, 50) AS value
from baseballStats select quarter(1633046399000) AS quarter
FROM ignoreMeselect round(1639144274, 30) AS rounded
FROM ignoreMeselect round(1639144274000, 5000) AS rounded
FROM ignoreMeSELECT concat('Apache', 'Pinot', ' ') AS value
FROM ignoreMeSELECT concat('real-time', 'analytics', '__') AS value
FROM ignoreMeselect DivAirportIDs,
arrayContainsInt(DivAirportIDs, 14683) AS containsValue
from airlineStats
WHERE arraylength(DivAirportIDs) >= 2
limit 5select DivAirportIDs,
arrayDistinctInt(DivAirportIDs) AS unique
from airlineStats
WHERE arraylength(DivAirportIDs) >= 2
limit 5select DivAirportIDs,
arrayIndexOfInt(DivAirportIDs, 14683) AS index
from airlineStats
WHERE arraylength(DivAirportIDs) >= 2
limit 5select DivAirportIDs,
arrayReverseInt(DivAirportIDs) AS reversedIds
from airlineStats
WHERE arraylength(DivAirportIDs) >= 2
limit 5select FlightNum,
arraySliceInt(DivAirportIDs, 0, 1) AS airports,
DivAirportIDs
from airlineStats
WHERE arraylength(DivAirportIDs) >= 2
limit 5select DivWheelsOffs,
DivWheelsOns,
arrayUnionInt(DivWheelsOffs, DivWheelsOns) AS unionIds
from airlineStats
WHERE arraylength(DivWheelsOffs) >= 2
limit 5select COUNTMV(DivTailNums) AS value
from airlineStats
where arraylength(DivTailNums) > 1select day(1639351800000, 'CET') AS day
FROM ignoreMeselect dayOfMonth(1639351800000) AS day
FROM ignoreMeselect dayOfMonth(1639351800000, 'CET') AS day
FROM ignoreMeselect DISTINCT league AS value
from baseballStats select DISTINCT(league) AS value
from baseballStats select DISTINCTCOUNTHLL(teamID, 12) AS value
from baseballStats select DISTINCTCOUNTBITMAPMV(DivTailNums) AS value
from airlineStats
where arraylength(DivTailNums) > 1select DISTINCTCOUNTMV(DivTailNums) AS value
from airlineStats
where arraylength(DivTailNums) > 1select 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 id, repo, JSONEXTRACTKEY(repo, '$.*') AS keys
from githubEvents
WHERE id = 7044874109select DivTailNums,
arrayDistinctString(DivTailNums) AS unique
from airlineStats
WHERE arraylength(DivTailNums) >= 2
limit 5select RandomAirports,
arrayRemoveString(RandomAirports, 'SEA') AS value
from airlineStats
WHERE arraylength(RandomAirports) BETWEEN 2 AND 4
limit 5select DivAirportIDs,
arraySortInt(DivAirportIDs) AS sortedIds
from airlineStats
WHERE arraylength(DivAirportIDs) >= 2
limit 5select dayOfYear(1639351800000, 'CET') AS dayOfYear
FROM ignoreMeselect doy(1639351800000) AS dayOfYear
FROM ignoreMeselect doy(1639351800000, 'CET') AS dayOfYear
FROM ignoreMeselect dayOfWeek(1639351800000, 'CET') AS dayOfWeek
FROM ignoreMeselect dow(1639351800000) AS dayOfWeek
FROM ignoreMeselect dow(1639351800000, 'CET') AS dayOfWeek
FROM ignoreMeselect DISTINCTCOUNTBITMAP(teamID) AS value
from baseballStats select DISTINCTCOUNTRAWHLL(teamID, 1) AS value
from baseballStats select DISTINCTCOUNTRAWHLLMV(DivAirports, 1) AS value
from airlineStats
where arraylength(DivAirports) > 1{
"tableConfig":{
"ingestionConfig":{
"transformConfigs":[
{
"columnName":"data",
"transformFunction":"JSONFORMAT(meta)"
}
]
}
}
}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 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 quarter(1633046399000, 'UTC') AS quarter
FROM ignoreMeselect quarter(1633046399000, 'CET') AS quarter
FROM ignoreMeselect DivAirportIDs,
arrayRemoveInt(DivAirportIDs, 12892) AS value
from airlineStats
WHERE arraylength(DivAirportIDs) >= 2
AND arrayContainsInt(DivAirportIDs, 12892) = 1
limit 5This section contains reference documentation for the fromEpoch functions.
select FlightNum,
arrayReverseString(RandomAirports) AS reversedAirports,
RandomAirports
from airlineStats
WHERE arraylength(RandomAirports) BETWEEN 2 AND 4
limit 5select FlightNum,
arraySortString(RandomAirports) AS sortedAirports,
RandomAirports
from airlineStats
WHERE arraylength(RandomAirports) BETWEEN 2 AND 4
limit 5select DivTailNums,
DivAirports,
arrayUnionString(DivTailNums, DivAirports) AS unionIds
from airlineStats
WHERE arraylength(DivTailNums) >= 2
limit 5This page contains reference documentation for functions in Apache Pinot.
select homeRuns, baseOnBalls, MULT(homeRuns, baseOnBalls) AS total
from baseballStats
WHERE teamID = 'ML1'
AND yearID = 1956
AND playerName = 'Henry Louis'select max(homeRuns) AS value
from baseballStats select PERCENTILEMV(DivLongestGTimes, 50) AS value
from airlineStats
where arraylength(DivLongestGTimes) > 1select PERCENTILETDigest(homeRuns, 50) AS value
from baseballStats select millisecond(1639351800000) AS millisecond
FROM ignoreMeselect millisecond(1639351800000, 'America/St_Johns') AS millisecond
FROM ignoreMeselect sqrt(25) AS value
from ignoreMeselect SEGMENTPARTITIONEDDISTINCTCOUNT(teamID) AS value
from baseballStats select second(1639351800000) AS second
FROM ignoreMeselect second(1639351800000, 'America/St_Johns') AS second
FROM ignoreMeselect event_id, location, SHA512(location) AS hash
from meetupRsvp
limit 1select mode(yearID) AS value
from baseballStats
WHERE AtBatting != 0 AND yearID > 2001select PERCENTILEESTMV(DivLongestGTimes, 50) AS value
from airlineStats
where arraylength(DivLongestGTimes) > 1select PERCENTILETDIGESTMV(DivLongestGTimes, 50) AS value
from airlineStats
where arraylength(DivLongestGTimes) > 1select event_id, location, SHA256(location) AS hash
from meetupRsvp
limit 1select FlightNum,
arraySliceString(RandomAirports, 0, 2) AS airports,
RandomAirports
from airlineStats
WHERE arraylength(RandomAirports) BETWEEN 2 AND 4
limit 5select PERCENTILEMV(DivLongestGTimes, 90) AS value
from airlineStats
where arraylength(DivLongestGTimes) > 1select PERCENTILEMV(DivLongestGTimes, 99.9) AS value
from airlineStats
where arraylength(DivLongestGTimes) > 1select DivTailNums,
arrayConcatString(DivTailNums, DivTailNums) AS concatIds
from airlineStats
WHERE arraylength(DivTailNums) >= 2
limit 5select PERCENTILETDigest(homeRuns, 80) AS value
from baseballStats select PERCENTILETDigest(homeRuns, 99.9) AS value
from baseballStats select 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 PERCENTILEESTMV(DivLongestGTimes, 90) AS value
from airlineStats
where arraylength(DivLongestGTimes) > 1select PERCENTILEESTMV(DivLongestGTimes, 99.9) AS value
from airlineStats
where arraylength(DivLongestGTimes) > 1select PERCENTILETDIGESTMV(DivLongestGTimes, 90) AS value
from airlineStats
where arraylength(DivLongestGTimes) > 1select PERCENTILETDIGESTMV(DivLongestGTimes, 99.9) AS value
from airlineStats
where arraylength(DivLongestGTimes) > 1select ARRAYLENGTH(RandomAirports) AS length, count(*)
from airlineStats
GROUP BY length
ORDER BY count(*) DESC
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 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":"age",
"transformFunction":"JSONPATHLONG(data, '$.age')"
}
]
}
}
}nominalEntries (defaults to 4096).select 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 {
"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 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":"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":"JSONPATHDOUBLE(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":"names",
"transformFunction":"JSONPATHARRAY(data, '$.subjects[*].name')"
},
{
"columnName":"ages",
"transformFunction":"JSONPATHARRAY(data, '$.subjects[*].score')"
},
{
"columnName":"homeworkGrades",
"transformFunction":"JSONPATHARRAY(data, '$.subjects[*].homework_grades[1]')"
}
]
}
}
}select regexpExtract('foo', '.*') AS value
from ignoreMeselect regexpExtract('foo123', '[0-9]+') AS value
from ignoreMeselect regexpExtract('foo123', '[^0-9]+') AS value
from ignoreMeselect regexpExtract('foo bar baz', '(\w+) (\w+)', 0) AS value
from ignoreMeselect regexpExtract('foo bar baz', '(\w+) (\w+)', 2) AS value
from ignoreMeselect regexpExtract('foo123', 'bar', 0, 'defaultValue') AS value
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 This section contains reference documentation for the DATETIMECONVERT function.
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": "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')"
}
]
}
}
}MICROSECONDSNANOSECONDSselect 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 = 7044874134