-
Notifications
You must be signed in to change notification settings - Fork 4.8k
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Are temporary result sets supported for nested queries? #25482
Labels
Comments
foow123
added
help wanted
Extra attention is needed
question
Further information is requested
labels
Apr 25, 2024
danielclow
changed the title
嵌套查询是否支持构造临时结果集?
Are temporary result sets supported for nested queries?
Apr 26, 2024
可以看下嵌套查询是否满足。 |
是,嵌套查询可以完成,我现在就是这么处理的,但这需要先创建一个临时表,然后将数据写入,再进行嵌套查询,最后再将临时表删除,而我仅仅只需要生成一个结果集进行数据处理而已,现在这种处理方式感觉太麻烦了 |
不好意思,没有太理解哈。嵌套查询不会创建临时表,再删除呢。不可以直接用select xxx from (select xxx ) 直接返回最终结果集吗? |
中间查询的那部分临时数据并不保存在TDEngine中,只是其它模块请求时使用的参数,查询语句是从postgresql移植过来的,所以向问下是否有相应的查询方法 |
这个确实没有 |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Labels
例如如下SQL语法:
SELECT * FROM ( VALUES ( 1 ), ( 2 ) ) AS temp(col1) ........
TDEngine中似乎找不到对应的语法,请问TDEngine中是否有对应构建临时结果集的方法,或者以后有没有计划添加?
The text was updated successfully, but these errors were encountered: