haoyuebju2 commented on issue #15846: URL: https://github.com/apache/iotdb/issues/15846#issuecomment-3018494695
`IoTDB> SELECT * from root.CME.ES.ES2509.tick where time > 2025-06-30
15:30:00 limit 10
17:43:51.783 [main] DEBUG org.apache.iotdb.rpc.AutoResizingBuffer -
org.apache.iotdb.rpc.AutoResizingBuffer@3de8f619 expand from 1024 to 2716,
request: 2716
+-----------------------------+----------------------------+------------------------------+----------------------------------+--------------------------------------+------------------------------------+-------------------------------------+------------------------------+------------------------------+----------------------------+------------------------------------+------------------------------------+---------------------------+------------------------------+--------------------------------+-----------------------------------+-----------------------------+----------------------------------+--------------------------------+
|
Time|root.CME.ES.ES2509.tick.High|root.CME.ES.ES2509.tick.BidVol|root.CME.ES.ES2509.tick.BestBidQty|root.CME.ES.ES2509.tick.PreSettlePrice|root.CME.ES.ES2509.tick.BestAskPrice|root.CME.ES.ES2509.tick.TotalTurnover|root.CME.ES.ES2509.tick.Change|root.CME.ES.ES2509.tick.AskVol|root.CME.ES.ES2509.tick.Open|root.CME.ES.ES2509.tick.OpenInterest|root.CME.ES.ES2509.tick.BestBidPrice|root.CME.ES.ES2509.tick.Low|root.CME.ES.ES2509.tick.Volume|root.CME.ES.ES2509.tick.PreClose|root.CME.ES.ES2509.tick.TotalVolume|root.CME.ES.ES2509.tick.Close|root.CME.ES.ES2509.tick.BestAskQty|root.CME.ES.ES2509.tick.Contract|
+-----------------------------+----------------------------+------------------------------+----------------------------------+--------------------------------------+------------------------------------+-------------------------------------+------------------------------+------------------------------+----------------------------+------------------------------------+------------------------------------+---------------------------+------------------------------+--------------------------------+-----------------------------------+-----------------------------+----------------------------------+--------------------------------+
|2025-06-30T15:31:38.048+08:00| 6255.0|
0.0| 20.0|
6223.75| 6245.75|
0.0| 21.75| 0.0|
6223.25| 1868068.0|
6245.25| 6223.25| 1.0|
6223.75| 77047.0|
6245.5| 16.0| ES2509|
|2025-06-30T15:31:40.135+08:00| 6255.0|
1.0| 5.0|
6223.75| 6245.75|
0.0| 21.75| 0.0|
6223.25| 1868068.0|
6245.5| 6223.25| 1.0|
6223.75| 77047.0|
6245.5| 15.0| ES2509|
|2025-06-30T15:31:41.100+08:00| 6255.0|
1.0| 9.0|
6223.75| 6245.75|
0.0| 21.75| 0.0|
6223.25| 1868068.0|
6245.5| 6223.25| 1.0|
6223.75| 77047.0|
6245.5| 13.0| ES2509|
|2025-06-30T15:31:41.850+08:00| 6255.0|
1.0| 1.0|
6223.75| 6245.75|
0.0| 21.75| 0.0|
6223.25| 1868068.0|
6245.5| 6223.25| 1.0|
6223.75| 77047.0|
6245.5| 18.0| ES2509|
|2025-06-30T15:31:43.019+08:00| 6255.0|
1.0| 2.0|
6223.75| 6245.75|
0.0| 21.75| 0.0|
6223.25| 1868068.0|
6245.5| 6223.25| 1.0|
6223.75| 77047.0|
6245.5| 18.0| ES2509|
|2025-06-30T15:31:45.196+08:00| 6255.0|
1.0| 10.0|
6223.75| 6245.75|
0.0| 21.75| 0.0|
6223.25| 1868068.0|
6245.5| 6223.25| 1.0|
6223.75| 77047.0|
6245.5| 14.0| ES2509|
|2025-06-30T15:31:46.009+08:00| 6255.0|
8.0| 12.0|
6223.75| 6246.0|
0.0| 22.0| 0.0|
6223.25| 1868068.0|
6245.75| 6223.25| 8.0|
6223.75| 77055.0|
6245.75| 27.0| ES2509|
|2025-06-30T15:31:47.185+08:00| 6255.0|
8.0| 12.0|
6223.75| 6246.0|
0.0| 22.0| 0.0|
6223.25| 1868068.0|
6245.75| 6223.25| 8.0|
6223.75| 77055.0|
6245.75| 25.0| ES2509|
|2025-06-30T15:31:48.469+08:00| 6255.0|
8.0| 15.0|
6223.75| 6246.0|
0.0| 22.0| 0.0|
6223.25| 1868068.0|
6245.75| 6223.25| 8.0|
6223.75| 77055.0|
6245.75| 25.0| ES2509|
|2025-06-30T15:31:56.245+08:00| 6255.0|
0.0| 18.0|
6223.75| 6246.0|
0.0| 22.0| 0.0|
6223.25| 1868068.0|
6245.5| 6223.25| 1.0|
6223.75| 77066.0|
6245.75| 26.0| ES2509|
+-----------------------------+----------------------------+------------------------------+----------------------------------+--------------------------------------+------------------------------------+-------------------------------------+------------------------------+------------------------------+----------------------------+------------------------------------+------------------------------------+---------------------------+------------------------------+--------------------------------+-----------------------------------+-----------------------------+----------------------------------+--------------------------------+
Total line number = 10
It costs 0.203s
IoTDB> delete from root.CME.ES.ES2509.tick where time >= 2025-06-29T15:31:00;
Msg: The statement is executed successfully.
IoTDB> SELECT * from root.CME.ES.ES2509.tick where time > 2025-06-30
15:30:00 limit 10
+-----------------------------+----------------------------+------------------------------+----------------------------------+--------------------------------------+------------------------------------+-------------------------------------+------------------------------+------------------------------+----------------------------+------------------------------------+------------------------------------+---------------------------+------------------------------+--------------------------------+-----------------------------------+-----------------------------+----------------------------------+--------------------------------+
|
Time|root.CME.ES.ES2509.tick.High|root.CME.ES.ES2509.tick.BidVol|root.CME.ES.ES2509.tick.BestBidQty|root.CME.ES.ES2509.tick.PreSettlePrice|root.CME.ES.ES2509.tick.BestAskPrice|root.CME.ES.ES2509.tick.TotalTurnover|root.CME.ES.ES2509.tick.Change|root.CME.ES.ES2509.tick.AskVol|root.CME.ES.ES2509.tick.Open|root.CME.ES.ES2509.tick.OpenInterest|root.CME.ES.ES2509.tick.BestBidPrice|root.CME.ES.ES2509.tick.Low|root.CME.ES.ES2509.tick.Volume|root.CME.ES.ES2509.tick.PreClose|root.CME.ES.ES2509.tick.TotalVolume|root.CME.ES.ES2509.tick.Close|root.CME.ES.ES2509.tick.BestAskQty|root.CME.ES.ES2509.tick.Contract|
+-----------------------------+----------------------------+------------------------------+----------------------------------+--------------------------------------+------------------------------------+-------------------------------------+------------------------------+------------------------------+----------------------------+------------------------------------+------------------------------------+---------------------------+------------------------------+--------------------------------+-----------------------------------+-----------------------------+----------------------------------+--------------------------------+
|2025-06-30T15:31:38.048+08:00| 6255.0|
0.0| 20.0|
6223.75| 6245.75|
0.0| 21.75| 0.0|
6223.25| 1868068.0|
6245.25| 6223.25| 1.0|
6223.75| 77047.0|
6245.5| 16.0| ES2509|
|2025-06-30T15:31:40.135+08:00| 6255.0|
1.0| 5.0|
6223.75| 6245.75|
0.0| 21.75| 0.0|
6223.25| 1868068.0|
6245.5| 6223.25| 1.0|
6223.75| 77047.0|
6245.5| 15.0| ES2509|
|2025-06-30T15:31:41.100+08:00| 6255.0|
1.0| 9.0|
6223.75| 6245.75|
0.0| 21.75| 0.0|
6223.25| 1868068.0|
6245.5| 6223.25| 1.0|
6223.75| 77047.0|
6245.5| 13.0| ES2509|
|2025-06-30T15:31:41.850+08:00| 6255.0|
1.0| 1.0|
6223.75| 6245.75|
0.0| 21.75| 0.0|
6223.25| 1868068.0|
6245.5| 6223.25| 1.0|
6223.75| 77047.0|
6245.5| 18.0| ES2509|
|2025-06-30T15:31:43.019+08:00| 6255.0|
1.0| 2.0|
6223.75| 6245.75|
0.0| 21.75| 0.0|
6223.25| 1868068.0|
6245.5| 6223.25| 1.0|
6223.75| 77047.0|
6245.5| 18.0| ES2509|
|2025-06-30T15:31:45.196+08:00| 6255.0|
1.0| 10.0|
6223.75| 6245.75|
0.0| 21.75| 0.0|
6223.25| 1868068.0|
6245.5| 6223.25| 1.0|
6223.75| 77047.0|
6245.5| 14.0| ES2509|
|2025-06-30T15:31:46.009+08:00| 6255.0|
8.0| 12.0|
6223.75| 6246.0|
0.0| 22.0| 0.0|
6223.25| 1868068.0|
6245.75| 6223.25| 8.0|
6223.75| 77055.0|
6245.75| 27.0| ES2509|
|2025-06-30T15:31:47.185+08:00| 6255.0|
8.0| 12.0|
6223.75| 6246.0|
0.0| 22.0| 0.0|
6223.25| 1868068.0|
6245.75| 6223.25| 8.0|
6223.75| 77055.0|
6245.75| 25.0| ES2509|
|2025-06-30T15:31:48.469+08:00| 6255.0|
8.0| 15.0|
6223.75| 6246.0|
0.0| 22.0| 0.0|
6223.25| 1868068.0|
6245.75| 6223.25| 8.0|
6223.75| 77055.0|
6245.75| 25.0| ES2509|
|2025-06-30T15:31:56.245+08:00| 6255.0|
0.0| 18.0|
6223.75| 6246.0|
0.0| 22.0| 0.0|
6223.25| 1868068.0|
6245.5| 6223.25| 1.0|
6223.75| 77066.0|
6245.75| 26.0| ES2509|
+-----------------------------+----------------------------+------------------------------+----------------------------------+--------------------------------------+------------------------------------+-------------------------------------+------------------------------+------------------------------+----------------------------+------------------------------------+------------------------------------+---------------------------+------------------------------+--------------------------------+-----------------------------------+-----------------------------+----------------------------------+--------------------------------+
Total line number = 10
It costs 0.146s`
--
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]
