You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@iotdb.apache.org by 김천구 <ck...@gmail.com> on 2024/04/03 02:28:32 UTC
Inconsistency in query results based on the environment
Hi all,
I'm currently using version 1.2.2 of iotdb, and there seems to be an issue
with the database query results. The results from executing queries via the
Python API and running queries in the CLI environment using start-cli.sh
are inconsistent. In the CLI environment, executing the query "time >=
2008-02-02T14:00:40 and time < 2008-02-02T14:00:41" returns 38 results,
while when executed via Python, it returns 33 results.
[image: image.png]
[image: 27387e12-f71a-4af3-acca-b594000ed146.png]
Conversely, when applying the condition "time >= 2008-02-02T17:30:00 and
time < 2008-02-02T17:30:01," the CLI environment returns 44 results,
whereas Python returns 50 results.
[image: image.png]
[image: image.png]
As you can see, the timestamp 120194460049 ("2008-02-02T18:30:00.049") is
not included in the output of the CLI query. However, when searching with
the condition "time = 1201944600049," the corresponding tuple is returned.
[image: image.png]
I don't understand why this issue is occurring. Would changing the version
resolve the issue?
Best,
Cheongu Kim
Re: Inconsistency in query results based on the environment
Posted by Haonan Hou <ha...@apache.org>.
Hi Cheongu,
The images are not allowed to show on the email list, therefore we cannot see them here.
Would you like to repost your issue on github [1]? Thanks.
Best,
Haonan Hou
[1] https://github.com/apache/iotdb/issues
On 2024/04/03 02:28:32 김천구 wrote:
> Hi all,
>
> I'm currently using version 1.2.2 of iotdb, and there seems to be an issue
> with the database query results. The results from executing queries via the
> Python API and running queries in the CLI environment using start-cli.sh
> are inconsistent. In the CLI environment, executing the query "time >=
> 2008-02-02T14:00:40 and time < 2008-02-02T14:00:41" returns 38 results,
> while when executed via Python, it returns 33 results.
> [image: image.png]
> [image: 27387e12-f71a-4af3-acca-b594000ed146.png]
>
> Conversely, when applying the condition "time >= 2008-02-02T17:30:00 and
> time < 2008-02-02T17:30:01," the CLI environment returns 44 results,
> whereas Python returns 50 results.
> [image: image.png]
> [image: image.png]
> As you can see, the timestamp 120194460049 ("2008-02-02T18:30:00.049") is
> not included in the output of the CLI query. However, when searching with
> the condition "time = 1201944600049," the corresponding tuple is returned.
> [image: image.png]
> I don't understand why this issue is occurring. Would changing the version
> resolve the issue?
>
> Best,
>
> Cheongu Kim
>