[ https://issues.jboss.org/browse/TEIID-4284?page=com.atlassian.jira.plugin... ] sameer P edited comment on TEIID-4284 at 10/10/16 11:16 AM: ------------------------------------------------------------ I got your point [~shawkins], here, the query should be {code:java} SELECT /*+ sh sf:'bulk' */ * FROM "source"."test_table_vz__c" {code} Correct? . I ran it . And the only concern is that the query runs for a really long time (never stopped on its own still) with the below statements in the log: {code:java} 17:15:51,743 DEBUG [org.teiid.BUFFER_MGR] (Worker4_QueryProcessorQueue1010) gL9WQ/EygEZA gL9WQ/EygEZA.10.0.2 Blocking on DataNotAvailableException gL9WQ/EygEZA.10.0.2 17:15:51,744 DEBUG [org.teiid.BUFFER_MGR] (Worker4_QueryProcessorQueue1010) gL9WQ/EygEZA gL9WQ/EygEZA.10 Blocking on source request(s). 17:15:51,744 DEBUG [org.teiid.PROCESSOR] (Worker4_QueryProcessorQueue1010) gL9WQ/EygEZA Request Thread gL9WQ/EygEZA.10 - processor blocked {code} was (Author: sameerp): I got your point [~shawkins], here, the query should be {code:java} SELECT /*+ sh sf:'bulk' */ * FROM "source"."test_table_vz__c" {code} Correct? . I ran it . And the only concern is that the query runs for a really long time (never stopped on its own still) with the below statements in the log: {code:java} 17:12:59,116 DEBUG [org.teiid.BUFFER_MGR] (Worker3_QueryProcessorQueue578) gL9WQ/EygEZA gL9WQ/EygEZA.9 Blocking on source request(s). 17:12:59,116 DEBUG [org.teiid.PROCESSOR] (Worker3_QueryProcessorQueue578) gL9WQ/EygEZA Request Thread gL9WQ/EygEZA.9 - processor blocke {code} -- This message was sent by Atlassian JIRA (v6.4.11#64026)