using "SET" with JDBC

[Guy Doulberg]

Hi

I am trying to use "SET" keyword in queries running using JDBC.

For example:
SET hive.exec.dynamic.partition.mode=nonstrict;
SET hive.exec.dynamic.partition=true;
SET hive.exec.max.created.files=1000000;
Select count(*) from table;


In order to do that , I split by ";"
And then execute each of the lines using a for loop

      for (String line : liness) {
                stmt.execute(query);
            }


I can see that the configuration do not passed correctly  to the job

I can see in the configuration of the job running these conf ( with the "set" 
keyword):

hive.exec.dynamic.partition.mode nonstrict
SET hive.exec.dynamic.partition true;
SET hive.exec.max.created.files 1000000

How should I pass "set " parameters using JDBC

Thanks,

Guy Doulberg,