ckim1009 opened a new issue, #12287: URL: https://github.com/apache/iotdb/issues/12287
### Search before asking - [X] I searched in the [issues](https://github.com/apache/iotdb/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 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. ``` 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! -- 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. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
