Set the SQL flag - Connect to Maxcompute| Alibaba Cloud Documentation Center

This topic describes how to use MaxCompute SDK for Java to set the SQL flag.

Background information

You must set the SQL flag when you submit SQL statements in the DataWorks console or on the MaxCompute client. If you want to enable the MaxCompute V2.0 data type edition at the session level, you must execute the set odps.sql.type.system.odps2=true; statement to set the SQL flag before the SQL query statement that involves the new data type.

Example

When you use MaxCompute SDK for Java to submit SQL query statements, do not insert the statement that is used to set the SQL flag into the SQL query statements. You can use the following method to set the SQL flag:

String sql ="SELECT..." ;
HashMap<String, String> hints = new LinkedHashMap<String, String>();
hints.put("SQL flag name, e.g. odps.sql.type.system.odps2", "SQL flag value");
hints.put("SQL flag name, e.g. odps.sql.type.system.odps2", "SQL flag value");
hints.put("SQL flag name, e.g. odps.sql.type.system.odps2", "SQL flag value");
Instance i = SQLTask.run(odps, odps.getDefaultProject(), sql, hints, null);
i.waitForSuccess();