Hour Scripted Field

[stevezemlicka (Stephen Zemlicka)]

For those that come across this in the future, I had an issue with the previous solution and timezone. Seems this was matching UTC which didn't align with the expected output due to how timezones are handled with scripted fields. What ultimately worked was:

return LocalDateTime.ofInstant(Instant.ofEpochMilli(doc['@timestamp'].value.millis),ZoneId.of('America/Chicago')).getHour()

ES 6.0 - Scripted Field HourOfDay with Timezone - error

Hello, First Post Here, I will try to do my best to make a clear presentation. I recently upgraded ELK on my UAT node from 5.6 to 6.0 OS : 2012r2 ; single node. ELK : 6.0.0 Java : 1.8.0_151 I was running a painless scripted field pretty well on 5.6.0 to deduce HourOfDay, as follow : Name : HourOfDay Script : LocalDateTime.ofInstant(Instant.ofEpochMilli(doc['@timestamp'].value),ZoneId.of('Europe/Paris')).getHour() I used this script because of the Timezone I'm using : Europe/Paris ; it…