[Bug] Inconsistency in query results based on the environment

[ckim1009]

Search before asking

• I searched in the issues and found nothing similar.

Version

Apache IoTDB : 1.2.2
Java : 1.8.0_402
Ubuntu : 20.04.6 LTS

Python : 3.8.3
Apache Iotdb python API : 1.3.0

Describe the bug and provide the minimal reproduce step

The results from executing queries via the Python API and running queries in the CLI environment using start-cli.sh are inconsistent.

While inspecting the results of queries executed in both environments against the data stored in IoTDB, I came across this issue.
The format of the stored data is defined as follows: create timeseries root.T_drive.taxi.value with datatype=TEXT.

What did you expect to see?

I expect the same number of query results from both environments.

What did you see instead?

CLI result 1

IoTDB> select * from root.T_drive.** where time >= 2008-02-02T14:00:40 and time < 2008-02-02T14:00:41 align by device
+-----------------------------+-----------------+--------------------------------------------------------------------------------------------------------------+
|                         Time|           Device|                                                                                                         value|
+-----------------------------+-----------------+--------------------------------------------------------------------------------------------------------------+
|2008-02-02T14:00:40.000+09:00|root.T_drive.taxi|{'taxi_num' : 10206, 'location.type' : Point, 'location.latitude' : 39.91293,'location.longitude' : 116.33298}|
|2008-02-02T14:00:40.001+09:00|root.T_drive.taxi| {'taxi_num' : 8172, 'location.type' : Point, 'location.latitude' : 39.69912,'location.longitude' : 115.97816}|
|2008-02-02T14:00:40.002+09:00|root.T_drive.taxi| {'taxi_num' : 7146, 'location.type' : Point, 'location.latitude' : 39.97511,'location.longitude' : 116.34658}|
|2008-02-02T14:00:40.003+09:00|root.T_drive.taxi| {'taxi_num' : 5983, 'location.type' : Point, 'location.latitude' : 39.96683,'location.longitude' : 116.36796}|
|2008-02-02T14:00:40.004+09:00|root.T_drive.taxi|  {'taxi_num' : 6945, 'location.type' : Point, 'location.latitude' : 39.92247,'location.longitude' : 116.2707}|
|2008-02-02T14:00:40.005+09:00|root.T_drive.taxi|  {'taxi_num' : 7785, 'location.type' : Point, 'location.latitude' : 39.9577,'location.longitude' : 116.40772}|
|2008-02-02T14:00:40.006+09:00|root.T_drive.taxi| {'taxi_num' : 8364, 'location.type' : Point, 'location.latitude' : 39.95855,'location.longitude' : 116.43344}|
|2008-02-02T14:00:40.007+09:00|root.T_drive.taxi| {'taxi_num' : 4844, 'location.type' : Point, 'location.latitude' : 39.91453,'location.longitude' : 116.42682}|
|2008-02-02T14:00:40.008+09:00|root.T_drive.taxi|  {'taxi_num' : 7220, 'location.type' : Point, 'location.latitude' : 39.8522,'location.longitude' : 116.44267}|
|2008-02-02T14:00:40.009+09:00|root.T_drive.taxi| {'taxi_num' : 6920, 'location.type' : Point, 'location.latitude' : 39.96821,'location.longitude' : 116.32778}|
|2008-02-02T14:00:40.010+09:00|root.T_drive.taxi| {'taxi_num' : 2238, 'location.type' : Point, 'location.latitude' : 39.86399,'location.longitude' : 116.31599}|
|2008-02-02T14:00:40.011+09:00|root.T_drive.taxi| {'taxi_num' : 3866, 'location.type' : Point, 'location.latitude' : 39.92463,'location.longitude' : 116.42858}|
|2008-02-02T14:00:40.012+09:00|root.T_drive.taxi|    {'taxi_num' : 34, 'location.type' : Point, 'location.latitude' : 39.84808,'location.longitude' : 116.4273}|
|2008-02-02T14:00:40.013+09:00|root.T_drive.taxi| {'taxi_num' : 9949, 'location.type' : Point, 'location.latitude' : 39.96853,'location.longitude' : 116.37264}|
|2008-02-02T14:00:40.014+09:00|root.T_drive.taxi| {'taxi_num' : 5056, 'location.type' : Point, 'location.latitude' : 39.79289,'location.longitude' : 116.45688}|
|2008-02-02T14:00:40.015+09:00|root.T_drive.taxi|{'taxi_num' : 10281, 'location.type' : Point, 'location.latitude' : 39.80758,'location.longitude' : 116.19144}|
|2008-02-02T14:00:40.016+09:00|root.T_drive.taxi| {'taxi_num' : 6399, 'location.type' : Point, 'location.latitude' : 39.82959,'location.longitude' : 116.35333}|
|2008-02-02T14:00:40.017+09:00|root.T_drive.taxi| {'taxi_num' : 2546, 'location.type' : Point, 'location.latitude' : 39.90436,'location.longitude' : 116.32284}|
|2008-02-02T14:00:40.018+09:00|root.T_drive.taxi|    {'taxi_num' : 55, 'location.type' : Point, 'location.latitude' : 39.88176,'location.longitude' : 116.3736}|
|2008-02-02T14:00:40.019+09:00|root.T_drive.taxi| {'taxi_num' : 2191, 'location.type' : Point, 'location.latitude' : 39.88359,'location.longitude' : 116.45002}|
|2008-02-02T14:00:40.020+09:00|root.T_drive.taxi| {'taxi_num' : 8855, 'location.type' : Point, 'location.latitude' : 39.92793,'location.longitude' : 116.40284}|
|2008-02-02T14:00:40.021+09:00|root.T_drive.taxi| {'taxi_num' : 7499, 'location.type' : Point, 'location.latitude' : 39.91571,'location.longitude' : 116.42116}|
|2008-02-02T14:00:40.022+09:00|root.T_drive.taxi| {'taxi_num' : 7499, 'location.type' : Point, 'location.latitude' : 39.91571,'location.longitude' : 116.42116}|
|2008-02-02T14:00:40.023+09:00|root.T_drive.taxi| {'taxi_num' : 7499, 'location.type' : Point, 'location.latitude' : 39.91571,'location.longitude' : 116.42116}|
|2008-02-02T14:00:40.024+09:00|root.T_drive.taxi| {'taxi_num' : 8789, 'location.type' : Point, 'location.latitude' : 39.89597,'location.longitude' : 116.32227}|
|2008-02-02T14:00:40.025+09:00|root.T_drive.taxi| {'taxi_num' : 6438, 'location.type' : Point, 'location.latitude' : 39.93127,'location.longitude' : 116.34917}|
|2008-02-02T14:00:40.026+09:00|root.T_drive.taxi| {'taxi_num' : 7535, 'location.type' : Point, 'location.latitude' : 39.90521,'location.longitude' : 116.32272}|
|2008-02-02T14:00:40.027+09:00|root.T_drive.taxi|  {'taxi_num' : 236, 'location.type' : Point, 'location.latitude' : 40.13322,'location.longitude' : 117.10498}|
|2008-02-02T14:00:40.028+09:00|root.T_drive.taxi| {'taxi_num' : 7154, 'location.type' : Point, 'location.latitude' : 39.88832,'location.longitude' : 116.33361}|
|2008-02-02T14:00:40.029+09:00|root.T_drive.taxi|  {'taxi_num' : 729, 'location.type' : Point, 'location.latitude' : 39.90781,'location.longitude' : 116.42465}|
|2008-02-02T14:00:40.030+09:00|root.T_drive.taxi| {'taxi_num' : 1842, 'location.type' : Point, 'location.latitude' : 39.90692,'location.longitude' : 116.42854}|
|2008-02-02T14:00:40.031+09:00|root.T_drive.taxi| {'taxi_num' : 5075, 'location.type' : Point, 'location.latitude' : 39.97525,'location.longitude' : 116.32753}|
|2008-02-02T14:00:40.032+09:00|root.T_drive.taxi| {'taxi_num' : 4842, 'location.type' : Point, 'location.latitude' : 39.99367,'location.longitude' : 116.38084}|
|2008-02-02T14:00:40.033+09:00|root.T_drive.taxi| {'taxi_num' : 9125, 'location.type' : Point, 'location.latitude' : 39.98634,'location.longitude' : 116.40628}|
|2008-02-02T14:00:40.034+09:00|root.T_drive.taxi| {'taxi_num' : 6989, 'location.type' : Point, 'location.latitude' : 39.90793,'location.longitude' : 116.35167}|
|2008-02-02T14:00:40.035+09:00|root.T_drive.taxi|  {'taxi_num' : 2490, 'location.type' : Point, 'location.latitude' : 39.8818,'location.longitude' : 116.30496}|
|2008-02-02T14:00:40.036+09:00|root.T_drive.taxi|  {'taxi_num' : 1536, 'location.type' : Point, 'location.latitude' : 39.9483,'location.longitude' : 116.34067}|
|2008-02-02T14:00:40.037+09:00|root.T_drive.taxi| {'taxi_num' : 6128, 'location.type' : Point, 'location.latitude' : 39.98653,'location.longitude' : 116.48347}|
+-----------------------------+-----------------+--------------------------------------------------------------------------------------------------------------+
Total line number = 38
It costs 0.035s

Python API result 1

#cursor.execute("select * from root.T_drive.** where time >= 2008-02-02T14:00:40 and time < 2008-02-02T14:00:41 align by device")
[1201932040000, 'root.T_drive.taxi', "{'taxi_num' : 6787, 'location.type' : Point, 'location.latitude' : 39.89945,'location.longitude' : 116.43008}"]
[1201932040001, 'root.T_drive.taxi', "{'taxi_num' : 3890, 'location.type' : Point, 'location.latitude' : 39.90651,'location.longitude' : 116.29607}"]
[1201932040002, 'root.T_drive.taxi', "{'taxi_num' : 7146, 'location.type' : Point, 'location.latitude' : 40.03701,'location.longitude' : 116.41954}"]
[1201932040003, 'root.T_drive.taxi', "{'taxi_num' : 3667, 'location.type' : Point, 'location.latitude' : 39.90921,'location.longitude' : 116.32355}"]
[1201932040004, 'root.T_drive.taxi', "{'taxi_num' : 2195, 'location.type' : Point, 'location.latitude' : 39.90232,'location.longitude' : 116.22312}"]
[1201932040005, 'root.T_drive.taxi', "{'taxi_num' : 4844, 'location.type' : Point, 'location.latitude' : 39.91454,'location.longitude' : 116.42679}"]
[1201932040006, 'root.T_drive.taxi', "{'taxi_num' : 9993, 'location.type' : Point, 'location.latitude' : 39.96439,'location.longitude' : 116.31045}"]
[1201932040007, 'root.T_drive.taxi', "{'taxi_num' : 416, 'location.type' : Point, 'location.latitude' : 39.9251,'location.longitude' : 116.4279}"]
[1201932040008, 'root.T_drive.taxi', "{'taxi_num' : 9949, 'location.type' : Point, 'location.latitude' : 39.96858,'location.longitude' : 116.373}"]
[1201932040009, 'root.T_drive.taxi', "{'taxi_num' : 3039, 'location.type' : Point, 'location.latitude' : 40.06282,'location.longitude' : 116.55542}"]
[1201932040010, 'root.T_drive.taxi', "{'taxi_num' : 6579, 'location.type' : Point, 'location.latitude' : 39.97147,'location.longitude' : 116.38463}"]
[1201932040011, 'root.T_drive.taxi', "{'taxi_num' : 6275, 'location.type' : Point, 'location.latitude' : 39.85803,'location.longitude' : 116.42572}"]
[1201932040012, 'root.T_drive.taxi', "{'taxi_num' : 3944, 'location.type' : Point, 'location.latitude' : 39.95627,'location.longitude' : 116.28271}"]
[1201932040013, 'root.T_drive.taxi', "{'taxi_num' : 8738, 'location.type' : Point, 'location.latitude' : 39.95905,'location.longitude' : 116.45007}"]
[1201932040014, 'root.T_drive.taxi', "{'taxi_num' : 5454, 'location.type' : Point, 'location.latitude' : 39.93279,'location.longitude' : 116.43019}"]
[1201932040015, 'root.T_drive.taxi', "{'taxi_num' : 2478, 'location.type' : Point, 'location.latitude' : 39.85591,'location.longitude' : 116.40784}"]
[1201932040016, 'root.T_drive.taxi', "{'taxi_num' : 1992, 'location.type' : Point, 'location.latitude' : 40.07182,'location.longitude' : 116.56571}"]
[1201932040017, 'root.T_drive.taxi', "{'taxi_num' : 7279, 'location.type' : Point, 'location.latitude' : 39.93951,'location.longitude' : 116.39986}"]
[1201932040018, 'root.T_drive.taxi', "{'taxi_num' : 6899, 'location.type' : Point, 'location.latitude' : 39.8955,'location.longitude' : 116.3227}"]
[1201932040019, 'root.T_drive.taxi', "{'taxi_num' : 8855, 'location.type' : Point, 'location.latitude' : 40.00306,'location.longitude' : 116.39841}"]
[1201932040020, 'root.T_drive.taxi', "{'taxi_num' : 3342, 'location.type' : Point, 'location.latitude' : 39.9068,'location.longitude' : 116.43474}"]
[1201932040021, 'root.T_drive.taxi', "{'taxi_num' : 8192, 'location.type' : Point, 'location.latitude' : 39.95674,'location.longitude' : 116.34908}"]
[1201932040022, 'root.T_drive.taxi', "{'taxi_num' : 5038, 'location.type' : Point, 'location.latitude' : 39.93945,'location.longitude' : 116.42962}"]
[1201932040023, 'root.T_drive.taxi', "{'taxi_num' : 9431, 'location.type' : Point, 'location.latitude' : 39.95559,'location.longitude' : 116.34894}"]
[1201932040024, 'root.T_drive.taxi', "{'taxi_num' : 236, 'location.type' : Point, 'location.latitude' : 40.11177,'location.longitude' : 117.01871}"]
[1201932040025, 'root.T_drive.taxi', "{'taxi_num' : 1842, 'location.type' : Point, 'location.latitude' : 39.86453,'location.longitude' : 116.40759}"]
[1201932040026, 'root.T_drive.taxi', "{'taxi_num' : 9125, 'location.type' : Point, 'location.latitude' : 39.98677,'location.longitude' : 116.40656}"]
[1201932040027, 'root.T_drive.taxi', "{'taxi_num' : 7310, 'location.type' : Point, 'location.latitude' : 39.95184,'location.longitude' : 116.35543}"]
[1201932040028, 'root.T_drive.taxi', "{'taxi_num' : 1866, 'location.type' : Point, 'location.latitude' : 39.95611,'location.longitude' : 116.27992}"]
[1201932040029, 'root.T_drive.taxi', "{'taxi_num' : 9992, 'location.type' : Point, 'location.latitude' : 39.89198,'location.longitude' : 116.45472}"]
[1201932040030, 'root.T_drive.taxi', "{'taxi_num' : 5411, 'location.type' : Point, 'location.latitude' : 39.99613,'location.longitude' : 116.3728}"]
[1201932040031, 'root.T_drive.taxi', "{'taxi_num' : 9934, 'location.type' : Point, 'location.latitude' : 39.85958,'location.longitude' : 116.34235}"]
[1201932040032, 'root.T_drive.taxi', "{'taxi_num' : 3235, 'location.type' : Point, 'location.latitude' : 39.93808,'location.longitude' : 116.31186}"]
33

CLI result 2

IoTDB> select * from root.T_drive.** where time >= 2008-02-02T17:30:00 and time < 2008-02-02T17:30:01 align by device
+-----------------------------+-----------------+-------------------------------------------------------------------------------------------------------------+
|                         Time|           Device|                                                                                                        value|
+-----------------------------+-----------------+-------------------------------------------------------------------------------------------------------------+
|2008-02-02T17:30:00.000+09:00|root.T_drive.taxi|{'taxi_num' : 7156, 'location.type' : Point, 'location.latitude' : 39.84487,'location.longitude' : 116.27759}|
|2008-02-02T17:30:00.001+09:00|root.T_drive.taxi|{'taxi_num' : 8796, 'location.type' : Point, 'location.latitude' : 39.83174,'location.longitude' : 116.44078}|
|2008-02-02T17:30:00.002+09:00|root.T_drive.taxi|{'taxi_num' : 7146, 'location.type' : Point, 'location.latitude' : 39.96144,'location.longitude' : 116.44041}|
|2008-02-02T17:30:00.003+09:00|root.T_drive.taxi|{'taxi_num' : 5372, 'location.type' : Point, 'location.latitude' : 39.91123,'location.longitude' : 116.32837}|
|2008-02-02T17:30:00.004+09:00|root.T_drive.taxi|{'taxi_num' : 6007, 'location.type' : Point, 'location.latitude' : 39.79931,'location.longitude' : 116.49981}|
|2008-02-02T17:30:00.005+09:00|root.T_drive.taxi| {'taxi_num' : 8626, 'location.type' : Point, 'location.latitude' : 39.93524,'location.longitude' : 116.4839}|
|2008-02-02T17:30:00.006+09:00|root.T_drive.taxi| {'taxi_num' : 4819, 'location.type' : Point, 'location.latitude' : 39.95032,'location.longitude' : 116.4455}|
|2008-02-02T17:30:00.007+09:00|root.T_drive.taxi|{'taxi_num' : 6508, 'location.type' : Point, 'location.latitude' : 39.92775,'location.longitude' : 116.46081}|
|2008-02-02T17:30:00.008+09:00|root.T_drive.taxi|{'taxi_num' : 8647, 'location.type' : Point, 'location.latitude' : 39.89669,'location.longitude' : 116.36831}|
|2008-02-02T17:30:00.009+09:00|root.T_drive.taxi|{'taxi_num' : 8647, 'location.type' : Point, 'location.latitude' : 39.89669,'location.longitude' : 116.36831}|
|2008-02-02T17:30:00.010+09:00|root.T_drive.taxi|{'taxi_num' : 6457, 'location.type' : Point, 'location.latitude' : 39.99265,'location.longitude' : 116.33411}|
|2008-02-02T17:30:00.011+09:00|root.T_drive.taxi| {'taxi_num' : 9779, 'location.type' : Point, 'location.latitude' : 39.98624,'location.longitude' : 116.3838}|
|2008-02-02T17:30:00.012+09:00|root.T_drive.taxi|{'taxi_num' : 6057, 'location.type' : Point, 'location.latitude' : 39.95477,'location.longitude' : 116.25437}|
|2008-02-02T17:30:00.013+09:00|root.T_drive.taxi|{'taxi_num' : 6275, 'location.type' : Point, 'location.latitude' : 39.86408,'location.longitude' : 116.41397}|
|2008-02-02T17:30:00.014+09:00|root.T_drive.taxi|{'taxi_num' : 3781, 'location.type' : Point, 'location.latitude' : 39.95669,'location.longitude' : 116.36604}|
|2008-02-02T17:30:00.015+09:00|root.T_drive.taxi| {'taxi_num' : 3579, 'location.type' : Point, 'location.latitude' : 39.8188,'location.longitude' : 115.82216}|
|2008-02-02T17:30:00.016+09:00|root.T_drive.taxi| {'taxi_num' : 6358, 'location.type' : Point, 'location.latitude' : 40.0092,'location.longitude' : 116.47623}|
|2008-02-02T17:30:00.017+09:00|root.T_drive.taxi|{'taxi_num' : 3360, 'location.type' : Point, 'location.latitude' : 39.80641,'location.longitude' : 116.50143}|
|2008-02-02T17:30:00.018+09:00|root.T_drive.taxi|{'taxi_num' : 5466, 'location.type' : Point, 'location.latitude' : 39.98469,'location.longitude' : 116.33486}|
|2008-02-02T17:30:00.019+09:00|root.T_drive.taxi|{'taxi_num' : 4236, 'location.type' : Point, 'location.latitude' : 39.91463,'location.longitude' : 116.41505}|
|2008-02-02T17:30:00.020+09:00|root.T_drive.taxi|{'taxi_num' : 7414, 'location.type' : Point, 'location.latitude' : 39.85015,'location.longitude' : 116.37533}|
|2008-02-02T17:30:00.021+09:00|root.T_drive.taxi|{'taxi_num' : 2525, 'location.type' : Point, 'location.latitude' : 40.01122,'location.longitude' : 116.49207}|
|2008-02-02T17:30:00.022+09:00|root.T_drive.taxi|{'taxi_num' : 3964, 'location.type' : Point, 'location.latitude' : 39.89629,'location.longitude' : 116.36857}|
|2008-02-02T17:30:00.023+09:00|root.T_drive.taxi|{'taxi_num' : 6761, 'location.type' : Point, 'location.latitude' : 39.96756,'location.longitude' : 116.39495}|
|2008-02-02T17:30:00.024+09:00|root.T_drive.taxi|{'taxi_num' : 9754, 'location.type' : Point, 'location.latitude' : 39.82609,'location.longitude' : 116.68158}|
|2008-02-02T17:30:00.025+09:00|root.T_drive.taxi|{'taxi_num' : 9773, 'location.type' : Point, 'location.latitude' : 39.90752,'location.longitude' : 116.45506}|
|2008-02-02T17:30:00.026+09:00|root.T_drive.taxi|{'taxi_num' : 8336, 'location.type' : Point, 'location.latitude' : 40.07124,'location.longitude' : 116.56657}|
|2008-02-02T17:30:00.027+09:00|root.T_drive.taxi|{'taxi_num' : 9085, 'location.type' : Point, 'location.latitude' : 39.96309,'location.longitude' : 116.30792}|
|2008-02-02T17:30:00.028+09:00|root.T_drive.taxi|{'taxi_num' : 5566, 'location.type' : Point, 'location.latitude' : 39.77284,'location.longitude' : 116.53029}|
|2008-02-02T17:30:00.029+09:00|root.T_drive.taxi| {'taxi_num' : 10253, 'location.type' : Point, 'location.latitude' : 39.86846,'location.longitude' : 116.413}|
|2008-02-02T17:30:00.030+09:00|root.T_drive.taxi|{'taxi_num' : 7023, 'location.type' : Point, 'location.latitude' : 39.88997,'location.longitude' : 116.45891}|
|2008-02-02T17:30:00.031+09:00|root.T_drive.taxi|{'taxi_num' : 9706, 'location.type' : Point, 'location.latitude' : 39.90865,'location.longitude' : 116.64896}|
|2008-02-02T17:30:00.032+09:00|root.T_drive.taxi|{'taxi_num' : 7105, 'location.type' : Point, 'location.latitude' : 39.84706,'location.longitude' : 116.38783}|
|2008-02-02T17:30:00.033+09:00|root.T_drive.taxi|{'taxi_num' : 3815, 'location.type' : Point, 'location.latitude' : 40.07091,'location.longitude' : 116.56689}|
|2008-02-02T17:30:00.034+09:00|root.T_drive.taxi|{'taxi_num' : 1757, 'location.type' : Point, 'location.latitude' : 39.90465,'location.longitude' : 116.35488}|
|2008-02-02T17:30:00.035+09:00|root.T_drive.taxi| {'taxi_num' : 6665, 'location.type' : Point, 'location.latitude' : 39.9398,'location.longitude' : 116.40218}|
|2008-02-02T17:30:00.036+09:00|root.T_drive.taxi|{'taxi_num' : 8395, 'location.type' : Point, 'location.latitude' : 39.96244,'location.longitude' : 116.31629}|
|2008-02-02T17:30:00.037+09:00|root.T_drive.taxi|{'taxi_num' : 8025, 'location.type' : Point, 'location.latitude' : 39.98576,'location.longitude' : 116.36959}|
|2008-02-02T17:30:00.038+09:00|root.T_drive.taxi|{'taxi_num' : 6715, 'location.type' : Point, 'location.latitude' : 39.95685,'location.longitude' : 116.34158}|
|2008-02-02T17:30:00.039+09:00|root.T_drive.taxi| {'taxi_num' : 1332, 'location.type' : Point, 'location.latitude' : 39.94277,'location.longitude' : 116.3037}|
|2008-02-02T17:30:00.040+09:00|root.T_drive.taxi|{'taxi_num' : 5520, 'location.type' : Point, 'location.latitude' : 39.93019,'location.longitude' : 116.40273}|
|2008-02-02T17:30:00.041+09:00|root.T_drive.taxi|{'taxi_num' : 8546, 'location.type' : Point, 'location.latitude' : 39.97889,'location.longitude' : 116.44836}|
|2008-02-02T17:30:00.042+09:00|root.T_drive.taxi|{'taxi_num' : 8711, 'location.type' : Point, 'location.latitude' : 40.07865,'location.longitude' : 116.58662}|
|2008-02-02T17:30:00.043+09:00|root.T_drive.taxi|{'taxi_num' : 8662, 'location.type' : Point, 'location.latitude' : 39.89013,'location.longitude' : 116.31994}|
+-----------------------------+-----------------+-------------------------------------------------------------------------------------------------------------+
Total line number = 44
It costs 0.038s

Python API result 2

#cursor.execute("select * from root.T_drive.** where time >= 2008-02-02T17:30:00 and time < 2008-02-02T17:30:01 align by device")
[1201944600000, 'root.T_drive.taxi', "{'taxi_num' : 7146, 'location.type' : Point, 'location.latitude' : 39.94656,'location.longitude' : 116.44922}"]
[1201944600001, 'root.T_drive.taxi', "{'taxi_num' : 7559, 'location.type' : Point, 'location.latitude' : 39.90567,'location.longitude' : 116.30603}"]
[1201944600002, 'root.T_drive.taxi', "{'taxi_num' : 7218, 'location.type' : Point, 'location.latitude' : 39.92847,'location.longitude' : 116.15337}"]
[1201944600003, 'root.T_drive.taxi', "{'taxi_num' : 3144, 'location.type' : Point, 'location.latitude' : 39.95332,'location.longitude' : 116.3555}"]
[1201944600004, 'root.T_drive.taxi', "{'taxi_num' : 2369, 'location.type' : Point, 'location.latitude' : 39.86724,'location.longitude' : 116.439}"]
[1201944600005, 'root.T_drive.taxi', "{'taxi_num' : 224, 'location.type' : Point, 'location.latitude' : 39.81087,'location.longitude' : 116.20021}"]
[1201944600006, 'root.T_drive.taxi', "{'taxi_num' : 5682, 'location.type' : Point, 'location.latitude' : 39.87,'location.longitude' : 116.26347}"]
[1201944600007, 'root.T_drive.taxi', "{'taxi_num' : 2771, 'location.type' : Point, 'location.latitude' : 40.11643,'location.longitude' : 116.60644}"]
[1201944600008, 'root.T_drive.taxi', "{'taxi_num' : 5414, 'location.type' : Point, 'location.latitude' : 39.8445,'location.longitude' : 116.37382}"]
[1201944600009, 'root.T_drive.taxi', "{'taxi_num' : 8828, 'location.type' : Point, 'location.latitude' : 39.97489,'location.longitude' : 116.37292}"]
[1201944600010, 'root.T_drive.taxi', "{'taxi_num' : 8677, 'location.type' : Point, 'location.latitude' : 39.84581,'location.longitude' : 116.35878}"]
[1201944600011, 'root.T_drive.taxi', "{'taxi_num' : 4397, 'location.type' : Point, 'location.latitude' : 39.90628,'location.longitude' : 116.29842}"]
[1201944600012, 'root.T_drive.taxi', "{'taxi_num' : 3099, 'location.type' : Point, 'location.latitude' : 39.91157,'location.longitude' : 116.47125}"]
[1201944600013, 'root.T_drive.taxi', "{'taxi_num' : 7656, 'location.type' : Point, 'location.latitude' : 39.97177,'location.longitude' : 116.463}"]
[1201944600014, 'root.T_drive.taxi', "{'taxi_num' : 6275, 'location.type' : Point, 'location.latitude' : 39.92207,'location.longitude' : 116.45506}"]
[1201944600015, 'root.T_drive.taxi', "{'taxi_num' : 3781, 'location.type' : Point, 'location.latitude' : 39.9522,'location.longitude' : 116.34911}"]
[1201944600016, 'root.T_drive.taxi', "{'taxi_num' : 3579, 'location.type' : Point, 'location.latitude' : 39.77101,'location.longitude' : 115.77468}"]
[1201944600017, 'root.T_drive.taxi', "{'taxi_num' : 42, 'location.type' : Point, 'location.latitude' : 39.94717,'location.longitude' : 116.36718}"]
[1201944600018, 'root.T_drive.taxi', "{'taxi_num' : 3512, 'location.type' : Point, 'location.latitude' : 39.87224,'location.longitude' : 116.3478}"]
[1201944600019, 'root.T_drive.taxi', "{'taxi_num' : 10192, 'location.type' : Point, 'location.latitude' : 39.8498,'location.longitude' : 116.36517}"]
[1201944600020, 'root.T_drive.taxi', "{'taxi_num' : 4924, 'location.type' : Point, 'location.latitude' : 39.958,'location.longitude' : 116.42228}"]
[1201944600021, 'root.T_drive.taxi', "{'taxi_num' : 5466, 'location.type' : Point, 'location.latitude' : 39.90387,'location.longitude' : 116.48299}"]
[1201944600022, 'root.T_drive.taxi', "{'taxi_num' : 2875, 'location.type' : Point, 'location.latitude' : 39.99487,'location.longitude' : 116.41108}"]
[1201944600023, 'root.T_drive.taxi', "{'taxi_num' : 6372, 'location.type' : Point, 'location.latitude' : 39.96201,'location.longitude' : 116.30368}"]
[1201944600024, 'root.T_drive.taxi', "{'taxi_num' : 2525, 'location.type' : Point, 'location.latitude' : 40.01117,'location.longitude' : 116.49205}"]
[1201944600025, 'root.T_drive.taxi', "{'taxi_num' : 1106, 'location.type' : Point, 'location.latitude' : 39.97712,'location.longitude' : 116.45299}"]
[1201944600026, 'root.T_drive.taxi', "{'taxi_num' : 6580, 'location.type' : Point, 'location.latitude' : 39.9192,'location.longitude' : 116.42017}"]
[1201944600027, 'root.T_drive.taxi', "{'taxi_num' : 9285, 'location.type' : Point, 'location.latitude' : 39.86989,'location.longitude' : 116.41418}"]
[1201944600028, 'root.T_drive.taxi', "{'taxi_num' : 9085, 'location.type' : Point, 'location.latitude' : 39.9844,'location.longitude' : 116.44087}"]
[1201944600029, 'root.T_drive.taxi', "{'taxi_num' : 2450, 'location.type' : Point, 'location.latitude' : 39.84745,'location.longitude' : 116.47913}"]
[1201944600030, 'root.T_drive.taxi', "{'taxi_num' : 748, 'location.type' : Point, 'location.latitude' : 40.10581,'location.longitude' : 116.53796}"]
[1201944600031, 'root.T_drive.taxi', "{'taxi_num' : 9706, 'location.type' : Point, 'location.latitude' : 39.90858,'location.longitude' : 116.64897}"]
[1201944600032, 'root.T_drive.taxi', "{'taxi_num' : 7105, 'location.type' : Point, 'location.latitude' : 39.84685,'location.longitude' : 116.3878}"]
[1201944600033, 'root.T_drive.taxi', "{'taxi_num' : 3815, 'location.type' : Point, 'location.latitude' : 40.0701,'location.longitude' : 116.56376}"]
[1201944600034, 'root.T_drive.taxi', "{'taxi_num' : 2199, 'location.type' : Point, 'location.latitude' : 39.9313,'location.longitude' : 116.2224}"]
[1201944600035, 'root.T_drive.taxi', "{'taxi_num' : 5078, 'location.type' : Point, 'location.latitude' : 39.96234,'location.longitude' : 116.30494}"]
[1201944600036, 'root.T_drive.taxi', "{'taxi_num' : 6665, 'location.type' : Point, 'location.latitude' : 39.95774,'location.longitude' : 116.40038}"]
[1201944600037, 'root.T_drive.taxi', "{'taxi_num' : 1391, 'location.type' : Point, 'location.latitude' : 39.91382,'location.longitude' : 116.18063}"]
[1201944600038, 'root.T_drive.taxi', "{'taxi_num' : 7327, 'location.type' : Point, 'location.latitude' : 39.90237,'location.longitude' : 116.29603}"]
[1201944600039, 'root.T_drive.taxi', "{'taxi_num' : 5075, 'location.type' : Point, 'location.latitude' : 40.03202,'location.longitude' : 116.39154}"]
[1201944600040, 'root.T_drive.taxi', "{'taxi_num' : 8095, 'location.type' : Point, 'location.latitude' : 40.37752,'location.longitude' : 116.81925}"]
[1201944600041, 'root.T_drive.taxi', "{'taxi_num' : 7411, 'location.type' : Point, 'location.latitude' : 39.94655,'location.longitude' : 116.28205}"]
[1201944600042, 'root.T_drive.taxi', "{'taxi_num' : 1123, 'location.type' : Point, 'location.latitude' : 39.92159,'location.longitude' : 116.326}"]
[1201944600043, 'root.T_drive.taxi', "{'taxi_num' : 7443, 'location.type' : Point, 'location.latitude' : 39.91841,'location.longitude' : 116.59962}"]
[1201944600044, 'root.T_drive.taxi', "{'taxi_num' : 3834, 'location.type' : Point, 'location.latitude' : 39.96148,'location.longitude' : 116.37869}"]
[1201944600045, 'root.T_drive.taxi', "{'taxi_num' : 950, 'location.type' : Point, 'location.latitude' : 39.87016,'location.longitude' : 116.27383}"]
[1201944600046, 'root.T_drive.taxi', "{'taxi_num' : 1059, 'location.type' : Point, 'location.latitude' : 39.97799,'location.longitude' : 116.45115}"]
[1201944600047, 'root.T_drive.taxi', "{'taxi_num' : 9323, 'location.type' : Point, 'location.latitude' : 39.93803,'location.longitude' : 116.31375}"]
[1201944600048, 'root.T_drive.taxi', "{'taxi_num' : 8662, 'location.type' : Point, 'location.latitude' : 39.90553,'location.longitude' : 116.37014}"]
[1201944600049, 'root.T_drive.taxi', "{'taxi_num' : 1847, 'location.type' : Point, 'location.latitude' : 39.94553,'location.longitude' : 116.46388}"]
50

Anything else?

In result 2, the timestamp 1201944600049 ("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.

IoTDB> select * from root.T_drive.** where time = 1201944600049
+-----------------------------+-------------------------------------------------------------------------------------------------------------+
|                         Time|                                                                                      root.T_drive.taxi.value|
+-----------------------------+-------------------------------------------------------------------------------------------------------------+
|2008-02-02T18:30:00.049+09:00|{'taxi_num' : 1847, 'location.type' : Point, 'location.latitude' : 39.94553,'location.longitude' : 116.46388}|
+-----------------------------+-------------------------------------------------------------------------------------------------------------+
Total line number = 1
It costs 0.070s

I'm curious why the tuple is not returned in the time range query.

Are you willing to submit a PR?

• I'm willing to submit a PR!

[github-actions]

Hi, this is your first issue in IoTDB project. Thanks for your report. Welcome to join the community!

[HTHou]

Hi, I think the issue is related with the timezone.
The first timestamp from your Python API result 1 is 1201932040000, which is actually 2008-02-02 14:00:40+08:00.
You may need to set the timezone manually in you Python code.