public interface SQLExecutor
Modifier and Type | Method and Description |
---|---|
void |
cancel()
取消当前查询
|
void |
close()
默认行为关闭该executor,若为连接池模式,则归还Executor到连接池中
|
List<String> |
getExecutionLog()
获取当前查询的执行日志
|
String |
getId()
获取Executor的ID
|
Instance |
getInstance()
获取当前查询Instance
|
String |
getLogView()
获取当前query Logview
|
List<Instance.StageProgress> |
getProgress()
获取当前查询的进度信息
|
List<Record> |
getResult()
通过InstanceTunnel获取所有结果
|
List<Record> |
getResult(Long countLimit)
通过InstanceTunnel获取有限集结果
|
List<Record> |
getResult(Long countLimit,
Long sizeLimit)
通过InstanceTunnel获取有限集结果
|
List<Record> |
getResult(Long offset,
Long countLimit,
Long sizeLimit)
通过InstanceTunnel获取有限集结果
|
List<Record> |
getResult(Long offset,
Long countLimit,
Long sizeLimit,
boolean limitEnabled)
通过InstanceTunnel获取有限集结果
|
ResultSet |
getResultSet()
通过InstanceTunnel获取结果的迭代器
|
ResultSet |
getResultSet(Long countLimit)
通过InstanceTunnel获取有限集结果的迭代器
|
ResultSet |
getResultSet(Long countLimit,
Long sizeLimit)
通过InstanceTunnel获取有限集结果的迭代器
|
ResultSet |
getResultSet(Long offset,
Long countLimit,
Long sizeLimit)
通过InstanceTunnel获取有限集结果的迭代器
|
ResultSet |
getResultSet(Long offset,
Long countLimit,
Long sizeLimit,
boolean limitEnabled)
通过InstanceTunnel获取有限集结果的迭代器
|
int |
getSubqueryId()
获取当前query ID
|
String |
getSummary()
获取当前查询的Summary信息
|
String |
getTaskName()
获取当前query taskName
|
boolean |
hasResultSet()
从语法结构上判断执行的sql是否具备结果集
不判断也不保证是否有数据
|
boolean |
isActive()
检查该Executor是否活跃
|
boolean |
isRunningInInteractiveMode()
判断当前执行的sql是否在 Interactive Mode
|
void |
run(String sql,
Map<String,String> hint)
提交一个query
|
void close()
String getId()
String getTaskName()
int getSubqueryId()
String getLogView()
boolean isActive()
void cancel() throws OdpsException
OdpsException
Instance getInstance()
List<Instance.StageProgress> getProgress() throws OdpsException
OdpsException
List<String> getExecutionLog()
OdpsException
String getSummary() throws OdpsException
OdpsException
List<Record> getResult() throws OdpsException, IOException
OdpsException,
- IOExceptionOdpsException
IOException
ResultSet getResultSet() throws OdpsException, IOException
OdpsException,
- IOExceptionOdpsException
IOException
List<Record> getResult(Long countLimit) throws OdpsException, IOException
countLimit
- 返回结果数量List
, 数据量较大时会带来较多内存开销
大数据量下载建议直接使用getResultSet(Long)
;OdpsException,
- IOExceptionOdpsException
IOException
List<Record> getResult(Long countLimit, Long sizeLimit) throws OdpsException, IOException
countLimit
- 返回结果数量sizeLimit
- 返回结果大小List
, 数据量较大时会带来较多内存开销
大数据量下载建议直接使用getResultSet(Long, Long)
;OdpsException,
- IOExceptionOdpsException
IOException
List<Record> getResult(Long offset, Long countLimit, Long sizeLimit) throws OdpsException, IOException
offset
- 返回结果的开始行数, 从第几行开始取结果countLimit
- 返回结果数量sizeLimit
- 返回结果大小List
, 数据量较大时会带来较多内存开销
大数据量下载建议直接使用getResultSet(Long, Long, Long)
;OdpsException,
- IOExceptionOdpsException
IOException
List<Record> getResult(Long offset, Long countLimit, Long sizeLimit, boolean limitEnabled) throws OdpsException, IOException
offset
- 返回结果的开始行数, 从第几行开始取结果countLimit
- 返回结果数量sizeLimit
- 返回结果大小limitEnabled
- 是否启用project设置的READ_TABLE_MAX_ROW, 启用后countLimit设置不再生效(被READ_TABLE_MAX_ROW覆盖)
不启用则取countLimit数量的结果, 但会进行权限校验, 需要提前在policy中为对应SQL中涉及的相应表和视图添加exception, 否则无权下载List
, 数据量较大时会带来较多内存开销
大数据量下载建议直接使用getResultSet(Long, Long, Long, boolean)
;OdpsException,
- IOExceptionOdpsException
IOException
ResultSet getResultSet(Long countLimit) throws OdpsException, IOException
countLimit
- 返回结果数量OdpsException,
- IOExceptionOdpsException
IOException
ResultSet getResultSet(Long countLimit, Long sizeLimit) throws OdpsException, IOException
countLimit
- 返回结果数量sizeLimit
- 返回结果大小OdpsException,
- IOExceptionOdpsException
IOException
ResultSet getResultSet(Long offset, Long countLimit, Long sizeLimit) throws OdpsException, IOException
offset
- 返回结果的开始行数, 从第几行开始取结果countLimit
- 返回结果数量sizeLimit
- 返回结果大小OdpsException,
- IOExceptionOdpsException
IOException
ResultSet getResultSet(Long offset, Long countLimit, Long sizeLimit, boolean limitEnabled) throws OdpsException, IOException
offset
- 返回结果的开始行数, 从第几行开始取结果countLimit
- 返回结果数量sizeLimit
- 返回结果大小limitEnabled
- 是否启用project设置的READ_TABLE_MAX_ROW, 启用后countLimit设置不再生效(被READ_TABLE_MAX_ROW覆盖)
不启用则取countLimit数量的结果, 但会进行权限校验, 需要提前在policy中为对应SQL中涉及的相应表和视图添加exception, 否则无权下载OdpsException,
- IOExceptionOdpsException
IOException
void run(String sql, Map<String,String> hint) throws OdpsException
sql
- sql语句hint
- query需要的hint参数OdpsException
boolean hasResultSet()
boolean isRunningInInteractiveMode()
Copyright © 2023 Alibaba Cloud Computing. All rights reserved.