ScrollElasticsearchHttp processor Count in Nifi.

[#1]

Hi am trying to take simple count of "ScrollElasticsearchHttp" processor in nifi. and using QueryRecord after this processor. I have created one new variable and using below Sql

"select count(1) from FLOFILE"

I am expecting result.count value 10000 which is my record count but its always showing record.count value 1.

can someone suggest how should I take count of this ScrollElasticsearchHttp flow.

Thanks !!

[#2]

@Rohan44 maybe you have a typo above, but try:

SELECT COUNT(*) FROM FLOWFILE