Hi Team, We are facing one issue in the query where one of our col values contains single quotes and we are getting CalciteSqlToPinotQuery exception. For example, one of the values is L'hôp Test. Since it contains a single quote, how to handle this and query the data for this value?

Have you tried escaping the single quote? If I am not wrong it would be something like

L''hop Test

?

Hi @Mayank, I see putting 2 single quotes is working. Is this the recommended way?

Yeh, that's the way to escape quotes. Have updated the documentation - https://docs.pinot.apache.org/users/user-guide-query/querying-pinot#identifier-vs-literal

Awesome, thanks @Mark Needham and @Mayank