Sorry for my late reply.
Actually it was not dependent on the query i ran. For example:
The following query runs twice. I can see in the hive server log. The second and absolutely same job was started immediately after the first job finished. It takes about 40 seconds.
`select * from openquery(hive, ‘select column1, column2 from table_name limit 200′)`
Strangely, when I run the same query immediately after the first query finished in SQL Server, the query
runs only once on the hive side.
But when i run the same query long time after the first query finished in SQL Server, the query runs twice again on the hive side.