Limit rows while fetching records using QueryDatabase Table using NiFi
I am trying to use QueryDatabase processor using Apache NiFi
Is there any way I can limit the records something like : “select * from table limit 100”
Any other processor in NiFi which supports this operation?
database apache-nifi
add a comment |
I am trying to use QueryDatabase processor using Apache NiFi
Is there any way I can limit the records something like : “select * from table limit 100”
Any other processor in NiFi which supports this operation?
database apache-nifi
add a comment |
I am trying to use QueryDatabase processor using Apache NiFi
Is there any way I can limit the records something like : “select * from table limit 100”
Any other processor in NiFi which supports this operation?
database apache-nifi
I am trying to use QueryDatabase processor using Apache NiFi
Is there any way I can limit the records something like : “select * from table limit 100”
Any other processor in NiFi which supports this operation?
database apache-nifi
database apache-nifi
asked Nov 20 '18 at 8:23
Apurw
247
247
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
Use ExecuteSQL processor for this case.
Configure/Enable DBCP connection pool
In
SQL select query
property value keep your select query
select * from table limit 100
Now processor runs the configured sql select query and outputs the results of the query as a flowfile in AVRO
format
Thanks a lot Shu... it worked. I have a Question though I cannot see these many options in my ExecuteSql processor. I have 1.7.0 version, is it something new on 1.8.0?
– Apurw
Nov 21 '18 at 9:45
@Apurw,Yes i'm using 1.8.0executesql
processor and there are lot of options added in latest version. issues.apache.org/jira/browse/NIFI-1251
– Shu
Nov 21 '18 at 13:38
add a comment |
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%2f53388859%2flimit-rows-while-fetching-records-using-querydatabase-table-using-nifi%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
Use ExecuteSQL processor for this case.
Configure/Enable DBCP connection pool
In
SQL select query
property value keep your select query
select * from table limit 100
Now processor runs the configured sql select query and outputs the results of the query as a flowfile in AVRO
format
Thanks a lot Shu... it worked. I have a Question though I cannot see these many options in my ExecuteSql processor. I have 1.7.0 version, is it something new on 1.8.0?
– Apurw
Nov 21 '18 at 9:45
@Apurw,Yes i'm using 1.8.0executesql
processor and there are lot of options added in latest version. issues.apache.org/jira/browse/NIFI-1251
– Shu
Nov 21 '18 at 13:38
add a comment |
Use ExecuteSQL processor for this case.
Configure/Enable DBCP connection pool
In
SQL select query
property value keep your select query
select * from table limit 100
Now processor runs the configured sql select query and outputs the results of the query as a flowfile in AVRO
format
Thanks a lot Shu... it worked. I have a Question though I cannot see these many options in my ExecuteSql processor. I have 1.7.0 version, is it something new on 1.8.0?
– Apurw
Nov 21 '18 at 9:45
@Apurw,Yes i'm using 1.8.0executesql
processor and there are lot of options added in latest version. issues.apache.org/jira/browse/NIFI-1251
– Shu
Nov 21 '18 at 13:38
add a comment |
Use ExecuteSQL processor for this case.
Configure/Enable DBCP connection pool
In
SQL select query
property value keep your select query
select * from table limit 100
Now processor runs the configured sql select query and outputs the results of the query as a flowfile in AVRO
format
Use ExecuteSQL processor for this case.
Configure/Enable DBCP connection pool
In
SQL select query
property value keep your select query
select * from table limit 100
Now processor runs the configured sql select query and outputs the results of the query as a flowfile in AVRO
format
edited Nov 20 '18 at 12:39
answered Nov 20 '18 at 12:28
Shu
4,4862418
4,4862418
Thanks a lot Shu... it worked. I have a Question though I cannot see these many options in my ExecuteSql processor. I have 1.7.0 version, is it something new on 1.8.0?
– Apurw
Nov 21 '18 at 9:45
@Apurw,Yes i'm using 1.8.0executesql
processor and there are lot of options added in latest version. issues.apache.org/jira/browse/NIFI-1251
– Shu
Nov 21 '18 at 13:38
add a comment |
Thanks a lot Shu... it worked. I have a Question though I cannot see these many options in my ExecuteSql processor. I have 1.7.0 version, is it something new on 1.8.0?
– Apurw
Nov 21 '18 at 9:45
@Apurw,Yes i'm using 1.8.0executesql
processor and there are lot of options added in latest version. issues.apache.org/jira/browse/NIFI-1251
– Shu
Nov 21 '18 at 13:38
Thanks a lot Shu... it worked. I have a Question though I cannot see these many options in my ExecuteSql processor. I have 1.7.0 version, is it something new on 1.8.0?
– Apurw
Nov 21 '18 at 9:45
Thanks a lot Shu... it worked. I have a Question though I cannot see these many options in my ExecuteSql processor. I have 1.7.0 version, is it something new on 1.8.0?
– Apurw
Nov 21 '18 at 9:45
@Apurw,Yes i'm using 1.8.0
executesql
processor and there are lot of options added in latest version. issues.apache.org/jira/browse/NIFI-1251– Shu
Nov 21 '18 at 13:38
@Apurw,Yes i'm using 1.8.0
executesql
processor and there are lot of options added in latest version. issues.apache.org/jira/browse/NIFI-1251– Shu
Nov 21 '18 at 13:38
add a comment |
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.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- 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%2f53388859%2flimit-rows-while-fetching-records-using-querydatabase-table-using-nifi%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