Hi guys I have an append-offline table with time c...
# pinot-devj
Juan Gomez
08/31/2023, 8:10 PMHi guys I have an append-offline table with time column format YYYY-MM-DD-HH and when I do time range queries of the form: WHERE ((\"time_stamp\" >= 2023-08-02-00 AND \"time_stamp\" <= 2023-08-31-23)) Pinot fails to find the proper entries, if I keep the low bound then the proper records are produced: WHERE (\"time_stamp\" >= 2023-08-02-00): Is this a known issue? any workaround? any other formats for the time column that work properly?
Juan Gomez
08/31/2023, 9:18 PMI just realized that if the timestamps are singled quoted the query works fine, sad part is I am working here with autogenerated queries, anything we can do in pinot side to work around this?
k
Ken Krugler
09/04/2023, 6:24 PMHi @Juan Gomez - I think you meant to post this to the #C011C9JHN7R channel…#pinot-dev is for developers working on Pinot code.
j
Juan Gomez
09/04/2023, 7:49 PMyes, sure I think I might gave a pointer on whether fixing this is simple or not. Seems a bug to me that we have to quote timestamps that are string based...