Hi team, how do I quote a reserved word like “time...
# troubleshootingt
troywinter
03/22/2021, 2:47 PMHi team, how do I quote a reserved word like “timestamp” when querying pinot in Presto? I tried using double quotes but it’s not working, any workarounds ?
k
Kishore G
03/22/2021, 4:46 PM
whats the error? @Xiang Fu ^^
x
Xiang Fu
03/22/2021, 5:30 PM
TIMESTAMP is a reserved keyword in presto for data type, try to avoid using that for your own convenient
Xiang Fu
03/22/2021, 5:30 PM
you can try if using ` will help
t
troywinter
03/23/2021, 2:57 AM``backtick is not working,
Copy code
line 1:8: backquoted identifiers are not supported; use double quotes to quote identifierstroywinter
03/23/2021, 2:59 AMAnd when using double quotes, the error is from pinot server, not from presto
Copy code
Parsing error with on Server_pinot-server-2.pinot-server-headless.pinot.svc.cluster.local_8098, Error = org.apache.calcite.sql.parser.SqlParseException: Encountered "timestamp FROM" at line 1, column 8.2 Views