uPortal IRC Logs-2013-03-08

Owned by Apereo Infrastructure
Last updated: Mar 08, 2013
2 min read

[11:49:29 CST(-0600)] <cwaymire> EricDalquist: you around?

[11:49:33 CST(-0600)] <EricDalquist> yes

[11:49:35 CST(-0600)] <EricDalquist> for about 15 minutes

[11:49:37 CST(-0600)] <cwaymire> got a quick question

[11:49:41 CST(-0600)] <EricDalquist> ok

[11:50:27 CST(-0600)] <cwaymire> regarding aggregation, specifically around creating custom typed queries. i'm noticing a quirk where if i execute a custom query for aggregations in 5 minute intervals over the last hour I get back the results I expect. If I execute the same query over the last 10 hours I get 0 results.

[11:50:44 CST(-0600)] <cwaymire> so i'm wondering if there is an issue with performing a query that goes back beyond the first date dimension that is populated in the db

[11:50:50 CST(-0600)] <EricDalquist> hrm

[11:50:53 CST(-0600)] <EricDalquist> that could be

[11:50:56 CST(-0600)] <cwaymire> the data base was initialized in the last few hours

[11:51:02 CST(-0600)] <EricDalquist> but it should populate date and time dimensions

[11:51:05 CST(-0600)] <EricDalquist> in a large range

[11:51:10 CST(-0600)] <EricDalquist> so all time dimensions (1440) are created

[11:51:23 CST(-0600)] <EricDalquist> then it should create date dimensions for +-1 year from now

[11:51:52 CST(-0600)] <cwaymire> I have concurrent user aggregations from the last 1-2hrs and if i search for aggregations in the last 60mins I get them, but if i search for aggregations from now going back to now - 10hrs I get nothing.

[11:52:00 CST(-0600)] <EricDalquist> hrm

[11:52:12 CST(-0600)] <EricDalquist> so it might be a problem for searching for less than 1 day but crossing a day boundary

[11:52:20 CST(-0600)] <EricDalquist> try searching going back 34 hours

[11:52:25 CST(-0600)] <EricDalquist> and see if that changes things

[11:52:32 CST(-0600)] <cwaymire> the odd thing is if i do now - 1 day it works

[11:52:38 CST(-0600)] <EricDalquist> yeah

[11:52:48 CST(-0600)] <cwaymire> but if i stay within the bounds of "today" it doesnt

[11:52:59 CST(-0600)] <EricDalquist> I bet it is a bug in the query builder for a query of a time span < 1 day but that crosses out of today

[11:53:36 CST(-0600)] <cwaymire> i'm basically taking the current time and subtracting the current number of hours/minutes

[11:53:38 CST(-0600)] <cwaymire> to go back to the start of the day

[11:53:42 CST(-0600)] <cwaymire> to get a representation of "today"

[11:53:55 CST(-0600)] <EricDalquist> hrm

[11:53:59 CST(-0600)] <cwaymire> not a huge deal. just curious really.

[11:54:16 CST(-0600)] <cwaymire> i'm sure i can work around it. I am still seeing that constraint bug as well.

[11:54:16 CST(-0600)] <EricDalquist> you could do new DateMidnight().toDateTime().plusSeconds(1)

[11:54:19 CST(-0600)] <EricDalquist> and see if that works

[11:54:34 CST(-0600)] <cwaymire> i'll give it a shot

[12:10:08 CST(-0600)] <cwaymire> that didnt work but new DateMidnight().toDateTime().minusSeconds(1) did work

[13:38:33 CST(-0600)] <EricDalquist> ok

[13:38:41 CST(-0600)] <EricDalquist> can you file a jira issue?

[13:41:44 CST(-0600)] <cwaymire> for which issue? the date thing?

[13:43:02 CST(-0600)] <EricDalquist> yeah

[13:43:14 CST(-0600)] <EricDalquist> there is already different handling for query of >1 day and <1 dat