You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@iotdb.apache.org by "changxue (Jira)" <ji...@apache.org> on 2022/12/21 03:22:00 UTC
[jira] [Created] (IOTDB-5258) [export tsfile] timeout occurred when the sql return big data
changxue created IOTDB-5258:
-------------------------------
Summary: [export tsfile] timeout occurred when the sql return big data
Key: IOTDB-5258
URL: https://issues.apache.org/jira/browse/IOTDB-5258
Project: Apache IoTDB
Issue Type: Improvement
Reporter: changxue
Assignee: Haonan Hou
[export tsfile] timeout occurred when the sql return big data
root.test.g_0.d_0 has 1000 timeseries and contains 2592000 records.
actual:
{code}
[atmos@i-ra9cbhah tools]$ ./export-tsfile.sh -h iotdb-44 -p 6667 -u root -pw root -td /data/ -f s_0 -q "select * from root.test.g_0.d_0"
------------------------------------------
Starting IoTDB Client Export Script
------------------------------------------
9366 [main] WARN o.a.i.t.c.conf.TSFileDescriptor - not found iotdb-common.properties, use the default configs.
15734 [main] INFO o.a.iotdb.tsfile.write.TsFileWriter - start close file
16750 [main] INFO o.a.i.t.write.writer.TsFileIOWriter - Time for flushing metadata is 40 ms
Cannot dump result because: 301: FragmentInstance 20221221_031055_00307_1.1.0 is aborted by timeout
{code}
expect:
1. split the sql automatically and make it possible to process
2. it could be slowly but could not return error or timeout
3. tell the user the process of output, like how many sensors, devices, lines or points have been processed.
4. print the time when the command started and ended.
5. print the statistics of processing. e.g. how many output files , how many points etc.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)