JOOQ and TimescaleDB - How to implement a basic time_bucket statement in JOOQ
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 Nov 19 '18 at 11:08
Lukas Eder
134k70437962
asked Nov 14 '18 at 15:05
Sören LinnemannSören Linnemann
185
add a comment |
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 Nov 19 '18 at 11:08
Lukas Eder
134k70437962
asked Nov 14 '18 at 15:05
Sören LinnemannSören Linnemann
185
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
Nov 19 '18 at 11:09
add a comment |
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 Nov 19 '18 at 11:08
Lukas Eder
134k70437962
asked Nov 14 '18 at 15:05
Sören LinnemannSören Linnemann
185
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 Nov 19 '18 at 11:08
Lukas Eder
134k70437962
asked Nov 14 '18 at 15:05
Sören LinnemannSören Linnemann
185
edited Nov 19 '18 at 11:08
Lukas Eder
134k70437962
asked Nov 14 '18 at 15:05
Sören LinnemannSören Linnemann
185
edited Nov 19 '18 at 11:08
Lukas Eder
134k70437962
edited Nov 19 '18 at 11:08
Lukas Eder
134k70437962
edited Nov 19 '18 at 11:08
Lukas Eder
134k70437962
134k70437962
asked Nov 14 '18 at 15:05
Sören LinnemannSören Linnemann
185
asked Nov 14 '18 at 15:05
Sören LinnemannSören Linnemann
185
asked Nov 14 '18 at 15:05
Sören LinnemannSören Linnemann
185
185
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
Nov 19 '18 at 11:09
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
Nov 19 '18 at 11:09
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
Nov 19 '18 at 11:09
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
Nov 19 '18 at 11:09
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
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
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
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
Nov 19 '18 at 11:09