Apache Pinot

Hello, do you have any news on this issue <https://github.com/apache/pinot/issues/7461> ? I have a column named `timestamp` and I’m unable to use PrestoDB since double quotes are removed

Just curious <@U01K4UW2MUG>, does single quote work?

nope since single quotes are used for values, so Presto returns an error

```'&gt;=' cannot be applied to varchar(9), timestamp with time zone```

```SELECT count(*) FROM pinot.default.datasource_607ec74cd839000300105f34 WHERE "timestamp" &gt;= from_iso8601_timestamp('2021-12-24T00:00:00.000Z') AND "timestamp" &lt;= from_iso8601_timestamp('2021-12-30T23:59:59.999Z') LIMIT 5000```

which is translated to
```SELECT count(*) FROM datasource_607ec74cd839000300105f34 WHERE ((timestamp &gt;= 1640304000000) AND (timestamp &lt;= 1640908799999))```

Timestamp is presto reserved keyword, we suggest not to have it as column name

same in Pinot, but I have it and I can’t change my column name

You can try to create a derived column with a different column name then reload segment 

In the transform function, you just put timestamp column name there

Or maybe some simple expression like timestamp + 0

<https://docs.pinot.apache.org/developers/advanced/ingestion-level-transformations|https://docs.pinot.apache.org/developers/advanced/ingestion-level-transformations>

(btw this is a bug on presto side or on yours?)

It's on presto side to handle escape for Pinot 

Though the presto connector code is also maintained by me :joy: 

oh, and do you plan to fix this? or maybe you could tell me where I can fix this and I’ll try to open a PR