v3.9.0-rc4

What's Changed

Full Changelog: v3.9.0-rc2...v3.9.0-rc4

v3.8.1

update version to 3.8.1 and sdk version to 0.50.6-public

v3.9.0-rc2

chore(pom.xml): 更新项目版本号至3.9.0-rc2

v3.9.0-rc1

update version to 3.9.0-rc1

v3.9.0-rc0

Full Changelog: v3.8.0...v3.9.0-rc0

ODPS-JDBC 3.8.0

Changelog

[3.8.0] - 2024-10-09

Welcome to the MCQA 2.0 Era!

New Features

• Support for submitting MCQA 2.0 jobs. Enable MCQA 2.0 mode by setting quotaName to interactive quota and turning on interactiveMode=true.
• New parameter useInstanceTunnel, which specifies whether to use Tunnel to retrieve data. The default value is true, consistent with previous behavior.
  If instanceTunnel is turned off, the system will use RESTful API to retrieve data under this mode:
  • Execution speed will be faster.
  • Only 10,000 results can be returned; if this limit is exceeded, the data will be truncated.
  • Return values are of String type, suitable only for display-type jobs.
• New executable class JdbcRunner, which allows executing JDBC tasks via a connection string and SQL file. The usage is as follows:

 java -cp odps-jdbc-version-jar-with-dependencies.jar com.aliyun.odps.jdbc.JdbcRunner <jdbc_url> <sql_file>

• Added some debug settings that modify the current Connection configuration (effectively re-acquiring the Connection to replace the current one).
  • set tunnelEndpoint = xxx; modifies the tunnelEndpoint parameter of the current Connection.
  • set useTunnel = true/false; modifies the useInstanceTunnel parameter of the current Connection.
  • set interactiveMode = true/false; modifies the interactiveMode parameter of the current Connection.

Changes

• Removed handling of # comment in the removeComment method: it no longer removes comments after the #. This change resolves many issues where valid SQL statements were incorrect due to the removal of #.
• Updated odps-sdk version to 0.50.0-public.

---

更新日志

[3.8.0] - 2024-10-9

欢迎进入 MCQA 2.0 时代！

新功能

• 支持提交 MCQA 2.0 作业。通过指定 quotaName 为交互式 quota，并开启 interactiveMode=true 即可开启 MCQA 2.0 模式。

• 新增参数 useInstanceTunnel，用于指定是否使用 Tunnel 来获取数据，默认值为 true，与原行为一致。

  如关闭 instanceTunnel，则会使用 Restful API 来获取数据，在这个模式下

  • 执行速度会更快。
  • 只能返回 10000 条结果，如超出这个限制，数据会被截断。
  • 返回值均为String类型，仅适合屏显型作业。

• 新增 JdbcRunner 可执行类，可以通过链接串和SQL文件，执行JDBC任务。使用方式如下

 java -cp odps-jdbc-version-jar-with-dependencies.jar com.aliyun.odps.jdbc.JdbcRunner <jdbc_url> <sql_file>

• 新增一些调试用 settings，这些 setting 会修改当前 Connection 的配置（相当于重新获取一次 Connection 并替代当前的 Connection）。
  • set tunnelEndpoint = xxx; 修改当前 Connection 的 tunnelEndpoint 参数
  • set useTunnel = true/false; 修改当前 Connection 的 useInstanceTunnel 参数
  • set interactiveMode = true/false; 修改当前 Connection 的 interactiveMode 参数

变更

• 移除 removeComment 方法中的 # 注释处理：现已不再去除 # 后的注释，这一改动解决了许多正常 SQL 语句因 # 而被误删的问题。
• 更新 odps-sdk 版本到 0.50.0-public

v3.8.0-rc2

Full Changelog: v3.8.0-rc1...v3.8.0-rc2

v3.8.0-rc1

Full Changelog: v3.8.0-rc0...v3.8.0-rc1

v3.8.0-rc0

Full Changelog: v3.7.0...v3.8.0-rc0

ODPS-JDBC 3.7.0

Changelog

[3.7.0] - 2024-08-29

Compatibility with Metabase!

Learn how to connect MaxCompute to Metabase

Important Changes

• Optimized the DatabaseMetadata.getColumns Logic: Enhanced compatibility for three-tier and two-tier model users as follows:
  • Three-tier model (project.schema.table):
    • Ignores the passed catalog, using the project name from the JDBC connection, along with the schemaPattern and tableNamePattern parameters to compose the table reference.
  • Two-tier model (project.table):
    • Ignores the schemaPattern, treating the catalog as the project name, and combines it with the tableNamePattern parameter to form the table reference.

  Three-tier model: catalog.schemaPattern.tableNamePattern -> project.schemaPattern.tableNamePattern
  Two-tier model: schemaPattern.tableNamePattern -> catalog.tableNamePattern
  

Changes

• Enhanced SQLException Messages: The exception message now includes the correct ErrorMessage.
• Updated odps-sdk Version: Updated to 0.48.8-public.

---

更新日志

[3.7.0] - 2024-08-29

兼容 Metabase!

了解如何连接 MaxCompute 与 Metabase

重要变更

• 优化 DatabaseMetadata.getColumns 逻辑：增强了三层模型和两层模型使用者的兼容性，具体如下：

  • 三层模型（project.schema.table）：
    • 忽略传入的 catalog，使用 JDBC 链接中的项目名，以及参数中的 schemaPattern 和 tableNamePattern 组合表引用。
  • 两层模型（project.table）：
    • 忽略 schemaPattern，将 catalog 视为项目名，并结合参数中的 tableNamePattern 组成表引用。

  三层模型：catalog.schemaPattern.tableNamePattern -> project.schemaPattern.tableNamePattern
  两层模型：schemaPattern.tableNamePattern -> catalog.tableNamePattern
  

变更

• 增强 SQLException 异常信息：异常信息中新增了正确的 ErrorMessage。
• 更新 odps-sdk 版本：已更新至 0.48.8-public。