Apache Pinot

Essentially, I can’t figure out how to specify a time literal that is compatible with my timestamp column for doing math on it

As in, your app doesn't know the time unit?

It seems like a good feature ask. Should be easy to add, <@UGRJA9TEH> wdyt?

Let me rephrase - how can I subtract time from the value returned by NOW(), if it’s possible? It seems like a common use case.

i think now() is supported as millisseonds epoch value

I’m happy to directly modify NOW() as well, but it errors out on me for that, too

```SELECT COUNT(*) FROM myTable WHERE eventTimestamp &gt;= (NOW() - 10000)```

(e.g., give me everything in the last 10 seconds)

```[
  {
    "errorCode": 200,
    "message": "QueryExecutionError:\norg.apache.pinot.core.query.exception.BadQueryRequestException: Cannot convert value: '1.608319112661E12' to type: LONG\n\tat org.apache.pinot.core.query.pruner.ColumnValueSegmentPruner.convertValue(ColumnValueSegmentPruner.java:261)\n\tat org.apache.pinot.core.query.pruner.ColumnValueSegmentPruner.pruneRangePredicate(ColumnValueSegmentPruner.java:185)\n\tat org.apache.pinot.core.query.pruner.ColumnValueSegmentPruner.pruneSegment(ColumnValueSegmentPruner.java:105)\n\tat org.apache.pinot.core.query.pruner.ColumnValueSegmentPruner.prune(ColumnValueSegmentPruner.java:76)\n\tat ```

```select * from mytable where eventTimestamp &gt; cast(now() - 10000 as long) limit 10```


can you create an issue  for this : <@U01AWAZ6M53>

<@U01AWAZ6M53> Please create a ticket with detailed description (and maybe a few examples) of the feature and I will look into implementing it.

<@U01F5BQFW84> in the query below, the request is to support INTERVAL;
```"SELECT dim1, dim2, DISTINCTCOUNTHLL(dim3) FROM myTable WHERE eventTimestamp &gt;= NOW() - INTERVAL 10 MINUTES"```

Also, `select * from mytable where eventTimestamp &gt; cast(now() - 10000 as long) limit 10` requires cast, may be we can see if that can be fixed (assuming other SQL engines don't requrie)

ok, so seems like there is a bug fix here and along with that I will look into supporting <https://docs.teradata.com/r/kmuOwjp1zEYg98JsB8fu_A/GJA85atQlfixEFi~byL_aw|ANSI INTERVAL syntax>.