Mixing
JOOQ and TimescaleDB - How to implement a basic time_bucket statement in JOOQ
up vote
3
down vote
favorite
I would like to implement a basic time_bucket statement in JOOQ.
If I run this Statement in the console it works perfekly fine:
SELECT time_bucket('5 minutes', time) as t, avg(average)
from TABLE
GROUP BY t
If i try to implement it with JOOQ I have the Problem that the generated routines do not work, because I cannot add the intervals.
I want something like the following code, but the Interval '5 minutes' doesn't work:
dslContext.select(timeBucket('5 minutes', TABLE.TIME), avg(TABLE.AVERAGE))
.from(TABLE)
.groupBy(timeBucket8('5 minutes', TABLE.TIME))
.fetch())
Is there a simple way to implement the Intervals?
java postgresql kotlin jooq timescaledb
edited 2 days ago
Lukas Eder
130k69423916
asked Nov 14 at 15:05
Sören Linnemann
162
add a comment |
up vote
3
down vote
favorite
I would like to implement a basic time_bucket statement in JOOQ.
If I run this Statement in the console it works perfekly fine:
SELECT time_bucket('5 minutes', time) as t, avg(average)
from TABLE
GROUP BY t
If i try to implement it with JOOQ I have the Problem that the generated routines do not work, because I cannot add the intervals.
I want something like the following code, but the Interval '5 minutes' doesn't work:
dslContext.select(timeBucket('5 minutes', TABLE.TIME), avg(TABLE.AVERAGE))
.from(TABLE)
.groupBy(timeBucket8('5 minutes', TABLE.TIME))
.fetch())
Is there a simple way to implement the Intervals?
java postgresql kotlin jooq timescaledb
edited 2 days ago
Lukas Eder
130k69423916
asked Nov 14 at 15:05
Sören Linnemann
162
1
What exactly doesn't work? I'm assuming you've written some plain SQL templating functions liketimeBucket(). What's the implementation there?
– Lukas Eder
2 days ago
add a comment |
up vote
3
down vote
favorite
up vote
3
down vote
favorite
I would like to implement a basic time_bucket statement in JOOQ.
If I run this Statement in the console it works perfekly fine:
SELECT time_bucket('5 minutes', time) as t, avg(average)
from TABLE
GROUP BY t
If i try to implement it with JOOQ I have the Problem that the generated routines do not work, because I cannot add the intervals.
I want something like the following code, but the Interval '5 minutes' doesn't work:
dslContext.select(timeBucket('5 minutes', TABLE.TIME), avg(TABLE.AVERAGE))
.from(TABLE)
.groupBy(timeBucket8('5 minutes', TABLE.TIME))
.fetch())
Is there a simple way to implement the Intervals?
java postgresql kotlin jooq timescaledb
edited 2 days ago
Lukas Eder
130k69423916
asked Nov 14 at 15:05
Sören Linnemann
162
I would like to implement a basic time_bucket statement in JOOQ.
If I run this Statement in the console it works perfekly fine:
SELECT time_bucket('5 minutes', time) as t, avg(average)
from TABLE
GROUP BY t
If i try to implement it with JOOQ I have the Problem that the generated routines do not work, because I cannot add the intervals.
I want something like the following code, but the Interval '5 minutes' doesn't work:
dslContext.select(timeBucket('5 minutes', TABLE.TIME), avg(TABLE.AVERAGE))
.from(TABLE)
.groupBy(timeBucket8('5 minutes', TABLE.TIME))
.fetch())
Is there a simple way to implement the Intervals?
java postgresql kotlin jooq timescaledb
java postgresql kotlin jooq timescaledb
edited 2 days ago
Lukas Eder
130k69423916
asked Nov 14 at 15:05
Sören Linnemann
162
edited 2 days ago
Lukas Eder
130k69423916
asked Nov 14 at 15:05
Sören Linnemann
162
edited 2 days ago
Lukas Eder
130k69423916
edited 2 days ago
Lukas Eder
130k69423916
edited 2 days ago
Lukas Eder
130k69423916
130k69423916
asked Nov 14 at 15:05
Sören Linnemann
162
asked Nov 14 at 15:05
Sören Linnemann
162
asked Nov 14 at 15:05
Sören Linnemann
162
162
1
What exactly doesn't work? I'm assuming you've written some plain SQL templating functions liketimeBucket(). What's the implementation there?
– Lukas Eder
2 days ago
add a comment |
1
What exactly doesn't work? I'm assuming you've written some plain SQL templating functions liketimeBucket(). What's the implementation there?
– Lukas Eder
2 days ago
1
1
What exactly doesn't work? I'm assuming you've written some plain SQL templating functions like
timeBucket(). What's the implementation there?– Lukas Eder
2 days ago
What exactly doesn't work? I'm assuming you've written some plain SQL templating functions like
timeBucket(). What's the implementation there?– Lukas Eder
2 days ago
add a comment |
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53303207%2fjooq-and-timescaledb-how-to-implement-a-basic-time-bucket-statement-in-jooq%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
1
What exactly doesn't work? I'm assuming you've written some plain SQL templating functions like
timeBucket(). What's the implementation there?– Lukas Eder
2 days ago