search

taosdata / TDengine

TDengine is an open source, high-performance, cloud native time-series database optimized for Internet of Things (IoT), Connected Cars, Industrial IoT and DevOps.
https://tdengine.com
GNU Affero General Public License v3.0
22.87k stars 4.81k forks source link

table join - left.ts = right.ts is expected in join expression #25117

Closed gujinzhi closed 5 days ago

gujinzhi commented 2 months ago

1、建立普通表； 2、插入数据； 3、进行表关联查询的时候 ，返回异常 left.ts = right.ts is expected in join expression； 捕获 为何无法进行关联查询呢？

gujinzhi commented 2 months ago

版本为 3.2.3.0

pinksmallpig commented 1 month ago

他的join必须要你把两个表的ts主键加入到on的条件上去，所以这个join功能基本废的

yu285 commented 5 days ago

这个是针对时序数据场景的join ,所以必须要有ts作为连接条件。后续会支持其他列的连接