[Question] how to get spark sql explain

[cowcomic]

Before asking

• I have read the How to ask for help (我已阅读如何寻求帮助指引文档).

Your environment

有两个环境，一个是新版本，如下：

• Linkis version used: 1.3.2
• Environment name and version:
  • spark-3.1.1
  • jdk 1.8.0_121

一个是旧版本

• Linkis version used: 0.9
• Environment name and version:
  • spark-2.4

Describe your questions

Q1. 执行spark sql的时候如何能够查看explain的结果
如在spark-shell中这样的语句
sql("select count(*) from test_agg").explain(true)

https://linkis.staged.apache.org/zh-CN/docs/1.3.2/user-guide/linkiscli-manual#4-支持的参数列表
shell的文档里没有相关说明

Eureka service list

No response

Some logs info or acctch file

无

[github-actions]

😊 Welcome to the Apache Linkis community!!

We are glad that you are contributing by opening this issue.

Please make sure to include all the relevant context.
We will be here shortly.

If you are interested in contributing to our website project, please let us know!
You can check out our contributing guide on
👉 How to Participate in Project Contribution.

Community

WeChat Assistant	WeChat Public Account

Mailing Lists

Name	Description	Subscribe	Unsubscribe	Archive
[email protected]	community activity information	subscribe	unsubscribe	archive

[aiceflower]

This is supported, you can refer to the following ways to use.
val s=sql("select count(*) from test_agg").explain(true) ; show(s)

[casionone]

This question has not been answered for a long time, I will close it first, if necessary, you can re-open it.

[cowcomic]

I mean how to get the result of the explain in the IDE instead of using the shell
@casionone