Peter Pringle
08/10/2021, 3:11 AMAnshu Bhowmik
08/10/2021, 5:35 PMJai Patel
08/10/2021, 7:18 PMKishore G
Anshu Bhowmik
08/11/2021, 7:07 PMBowen Wan
08/11/2021, 7:52 PMZsolt Takacs
08/11/2021, 9:19 PMRoberto Díaz
08/11/2021, 10:30 PMManish Soni
08/12/2021, 6:43 AMVikash Singh
08/16/2021, 9:13 AMVikash Singh
08/16/2021, 11:26 AMJai Patel
08/16/2021, 4:39 PMRoberto Díaz
08/16/2021, 11:10 PMElon
08/17/2021, 5:47 PMCharles
08/18/2021, 1:19 AMwentao jin
08/18/2021, 6:41 AMSanthosh CT
08/18/2021, 7:21 AMRoberto Díaz
08/18/2021, 11:44 AMfromDateTime(jsonPathString(json.path, '$.timestamp, ''), 'EEE MMM dd HH:mm:ss ZZZ yyyy')
I mean, is it supported to nest transformation functions? I’m trying to convert a json string date-time into a Long timestampCharles
08/19/2021, 1:59 PMtroywinter
08/23/2021, 6:34 AMGreg Simons
08/23/2021, 1:31 PMPeter Pringle
08/23/2021, 1:35 PMFritz Budiyanto
08/24/2021, 9:29 PMapachepinot/pinot:release-0.8.0
Peter Pringle
08/25/2021, 11:22 AMDavid Sonntag
08/25/2021, 7:22 PMNeil Teng
08/25/2021, 9:27 PMKen Krugler
08/25/2021, 11:04 PMQianbo Wang
08/26/2021, 11:17 PMcreated_at
which records the epoch time in seconds, we have a use case needs to search for entries created in the last 30 days, 60 days, 90 days, etc. I wonder if there is a best practice I could follow to optimize this, for example:
1. What type is best for this created_at
column? Timestamp, Long, etc.?
2. What kind of indexing would help? range index?
3. anything else could help?
Thanks in advance!Vibhor Jain
08/31/2021, 2:38 PMKarin Wolok