You are viewing a plain text version of this content. The canonical link for it is here.
Posted to reviews@iotdb.apache.org by GitBox <gi...@apache.org> on 2020/12/12 02:07:49 UTC
[GitHub] [iotdb] flyingsand008 opened a new issue #2256: sync last point query not right
flyingsand008 opened a new issue #2256:
URL: https://github.com/apache/iotdb/issues/2256
**To Reproduce**
Steps to reproduce the behavior:
1. in sync sender
insert into root.ln.wf01.wt01(timestamp,temperature) values(2020-11-01 00:00:00.000,21.113817)
insert into root.ln.wf01.wt01(timestamp,temperature) values(2020-11-02 00:00:00.000,20.653296)
flush
2. after sync
in sync sender
insert into root.ln.wf01.wt01(timestamp,temperature) values(2020-11-04 00:00:00.000,24.588139)
flush
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|
+-----------------------------+-----------------------------+
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|
+-----------------------------+-----------------------------+---------+
3. 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|
+-----------------------------+-----------------------------+
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|
+-----------------------------+-----------------------------+---------+
**Expected behavior**
in sync receiver
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|
+-----------------------------+-----------------------------+---------+
**Desktop (please complete the following information):**
- Version 0.11.0
----------------------------------------------------------------
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:
users@infra.apache.org
[GitHub] [iotdb] HTHou closed issue #2256: sync last point query not right
Posted by GitBox <gi...@apache.org>.
HTHou closed issue #2256:
URL: https://github.com/apache/iotdb/issues/2256
----------------------------------------------------------------
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:
users@infra.apache.org
[GitHub] [iotdb] jixuan1989 commented on issue #2256: sync last point query not right
Posted by GitBox <gi...@apache.org>.
jixuan1989 commented on issue #2256:
URL: https://github.com/apache/iotdb/issues/2256#issuecomment-752345833
@fanhualta any update?
----------------------------------------------------------------
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:
users@infra.apache.org
[GitHub] [iotdb] HTHou closed issue #2256: sync last point query not right
Posted by GitBox <gi...@apache.org>.
HTHou closed issue #2256:
URL: https://github.com/apache/iotdb/issues/2256
----------------------------------------------------------------
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:
users@infra.apache.org
[GitHub] [iotdb] fanhualta commented on issue #2256: sync last point query not right
Posted by GitBox <gi...@apache.org>.
fanhualta commented on issue #2256:
URL: https://github.com/apache/iotdb/issues/2256#issuecomment-745164469
Hi, I try to reproduce your case, but I just get the expected behavior.
----------------------------------------------------------------
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:
users@infra.apache.org
[GitHub] [iotdb] HTHou closed issue #2256: sync last point query not right
Posted by GitBox <gi...@apache.org>.
HTHou closed issue #2256:
URL: https://github.com/apache/iotdb/issues/2256
----------------------------------------------------------------
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:
users@infra.apache.org
[GitHub] [iotdb] flyingsand008 commented on issue #2256: sync last point query not right
Posted by GitBox <gi...@apache.org>.
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:
users@infra.apache.org