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)