[ https://issues.apache.org/jira/browse/IOTDB-5258?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Haonan Hou reassigned IOTDB-5258: --------------------------------- Assignee: Zhijia Cao (was: Haonan Hou) > [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: Zhijia Cao > Priority: Major > > [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)