Hi Dhruv, 1. Could you give me an example to describe what you want to query? e.g., there are two time series:
+-----------------------------+---------------+---------------+ | Time|root.demo.d1.m1|root.demo.d2.m2| +-----------------------------+---------------+---------------+ |1970-01-01T08:00:00.001+08:00| 1.0| 2.0| |2019-12-11T10:00:00.000+08:00| 1.0| NULL| |2020-12-18T11:45:14.519+08:00| 2.0| 2.0| +-----------------------------+---------------+---------------+ or, What you want to query? (you can consider it as a table in MySQL, and just write the sqls you need in mysql.) 2. Ah, we are testing the performance of v0.12. maybe 2-3 weeks, I think. Best, ----------------------------------- Xiangdong Huang School of Software, Tsinghua University 黄向东 清华大学 软件学院 Dhruv Garg <[email protected]> 于2021年3月8日周一 下午4:11写道： > Hello Xiangdong, > > Thanks for your response. > > 1. I have the same use-case: I want to run a join query on two time > series but I think I am getting the syntax wrong. > I tried a few SQL-like join queries on IoTDB v0.11.2 and got the following > error: "mismatched input 'JOIN' expecting {<EOF>, WHERE, ORDER, SLIMIT, > LIMIT, OFFSET, SOFFSET, FILL, GROUP, DISABLE, ALIGN, ',', '.'}" > Could you please refer me to some documentation or provide a simple example > join query for IoTDB? > > 2. I am also excited to try out the cluster version. Is there an > approximate timeline for v0.12 rollout? > > Thanks in advance. > > Regards, > dgargcs > > On Tue, 2 Mar 2021 at 17:24, Xiangdong Huang <[email protected]> wrote: > > > Hi Dhruv, > > > > Welcome! > > > > 1. "join" for what requirements? > > > > IoTDB supports JOIN two time series ON their timestamp, i.e., time series > > alignment. > > > > 2. I think the cluster version is coming... In the coming v0.12, I think > a > > cluster version (that does > > not support dynamically scale-out) will be released, and the scale-out > > feature may be released in v0.13 or 0.14. > > > > Best, > > ----------------------------------- > > Xiangdong Huang > > School of Software, Tsinghua University > > > > Dhruv Garg <[email protected]> 于2021年3月2日周二 下午3:54写道： > > > > > Hello, > > > > > > I am a researcher and a new user of IoTDB. I was excited when I saw the > > > performance numbers of IoTDB compared to InfluxDB, and I have set it up > > on > > > a few workstations and a Raspberry Pi device. > > > > > > I am becoming familiar with it and have a few queries: > > > > > > 1. Does IoTDB support Join queries? - I tried looking up some > > > documentation on it, but could not find any. If the feature is > > > available, > > > could you please provide a sample query or the predicates for join > > > queries? > > > 2. I also browsed through the IoTDB Jira issues page. I saw that the > > > distributed / cluster version is being developed. Approximately how > > much > > > time would it take to get a stable / working version of the cluster > > > IoTDB? > > > > > > It would be great if someone can respond to my queries. I would be > > > waiting for a reply. Thanks in advance. > > > > > > Regards, > > > dgargcs > > > > > >
