flyingsand008 commented on issue #2256: URL: https://github.com/apache/iotdb/issues/2256#issuecomment-745878394
Hi,I'm sorry.Some steps are missing,please try again: 1. in sync sender > IoTDB> insert into root.ln.wf01.wt01(timestamp,temperature) values(2020-11-01 00:00:00.000,21.113817) Msg: The statement is executed successfully. IoTDB> insert into root.ln.wf01.wt01(timestamp,temperature) values(2020-11-02 00:00:00.000,20.653296) Msg: The statement is executed successfully. IoTDB> flush Msg: The statement is executed successfully. IoTDB> select * from root.ln.wf01.wt01 +-----------------------------+-----------------------------+ | Time|root.ln.wf01.wt01.temperature| +-----------------------------+-----------------------------+ |2020-11-01T00:00:00.000+08:00| 21.113817| |2020-11-02T00:00:00.000+08:00| 20.653296| +-----------------------------+-----------------------------+ Total line number = 2 It costs 0.196s IoTDB> select last * from root.ln.wf01.wt01 +-----------------------------+-----------------------------+---------+ | Time| timeseries| value| +-----------------------------+-----------------------------+---------+ |2020-11-02T00:00:00.000+08:00|root.ln.wf01.wt01.temperature|20.653296| +-----------------------------+-----------------------------+---------+ Total line number = 1 It costs 0.040s 2. after sync in sync receiver > IoTDB> select * from root.ln.wf01.wt01 +-----------------------------+-----------------------------+ | Time|root.ln.wf01.wt01.temperature| +-----------------------------+-----------------------------+ |2020-11-01T00:00:00.000+08:00| 21.113817| |2020-11-02T00:00:00.000+08:00| 20.653296| +-----------------------------+-----------------------------+ Total line number = 2 It costs 1.645s IoTDB> select last * from root.ln.wf01.wt01 +-----------------------------+-----------------------------+---------+ | Time| timeseries| value| +-----------------------------+-----------------------------+---------+ |2020-11-02T00:00:00.000+08:00|root.ln.wf01.wt01.temperature|20.653296| +-----------------------------+-----------------------------+---------+ Total line number = 1 It costs 0.087s 3. in sync sender > IoTDB> insert into root.ln.wf01.wt01(timestamp,temperature) values(2020-11-04 00:00:00.000,24.588139) Msg: The statement is executed successfully. IoTDB> flush Msg: The statement is executed successfully. IoTDB> select * from root.ln.wf01.wt01 +-----------------------------+-----------------------------+ | Time|root.ln.wf01.wt01.temperature| +-----------------------------+-----------------------------+ |2020-11-01T00:00:00.000+08:00| 21.113817| |2020-11-02T00:00:00.000+08:00| 20.653296| |2020-11-04T00:00:00.000+08:00| 24.588139| +-----------------------------+-----------------------------+ Total line number = 3 It costs 0.020s IoTDB> select last * from root.ln.wf01.wt01 +-----------------------------+-----------------------------+---------+ | Time| timeseries| value| +-----------------------------+-----------------------------+---------+ |2020-11-04T00:00:00.000+08:00|root.ln.wf01.wt01.temperature|24.588139| +-----------------------------+-----------------------------+---------+ Total line number = 1 It costs 0.009s 4. after sync in sync receiver > IoTDB> select * from root.ln.wf01.wt01 +-----------------------------+-----------------------------+ | Time|root.ln.wf01.wt01.temperature| +-----------------------------+-----------------------------+ |2020-11-01T00:00:00.000+08:00| 21.113817| |2020-11-02T00:00:00.000+08:00| 20.653296| |2020-11-04T00:00:00.000+08:00| 24.588139| +-----------------------------+-----------------------------+ Total line number = 3 It costs 0.039s IoTDB> select last * from root.ln.wf01.wt01 +-----------------------------+-----------------------------+---------+ | Time| timeseries| value| +-----------------------------+-----------------------------+---------+ |2020-11-02T00:00:00.000+08:00|root.ln.wf01.wt01.temperature|20.653296| +-----------------------------+-----------------------------+---------+ Total line number = 1 It costs 0.019s the second last query is the same as the first ---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: [email protected]
