You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@nifi.apache.org by "Ravi (Jira)" <ji...@apache.org> on 2021/09/27 12:05:00 UTC
[jira] [Commented] (NIFI-2782) Add with (nolock) pre-processing
option to QueryDatabaseTable Processor
[ https://issues.apache.org/jira/browse/NIFI-2782?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17420695#comment-17420695 ]
Ravi commented on NIFI-2782:
----------------------------
I also had same issue. Do we have any other workaround or solution for this?
Some queries runs with NOLOCK hint only. When I try to add (NOLOCK) with query Database table processor its giving error like below.
QueryDatabaseTable[id=f2713e01-d134-1bf5-0f11-1301fad6986f] Unable to execute SQL select query SELECT UpdDate,updoperation,KeyEvent FROM Events (NOLOCK) due to Error during database query or conversion of records.: org.apache.nifi.processor.exception.ProcessException: Error during database query or conversion of records.
> Add with (nolock) pre-processing option to QueryDatabaseTable Processor
> -----------------------------------------------------------------------
>
> Key: NIFI-2782
> URL: https://issues.apache.org/jira/browse/NIFI-2782
> Project: Apache NiFi
> Issue Type: Improvement
> Affects Versions: 1.0.0, 0.7.0, 0.6.1
> Environment: MSSQL Source
> Reporter: Guillaume Pool
> Priority: Major
>
> Add an option to add "WITH (NOLOCK)" to the query statement when working with MSSQL to read uncommitted data and to avoid read locks on busy tables in MSSQL.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)