[
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)
