You are viewing a plain text version of this content. The canonical link for it is here.
Posted to reviews@iotdb.apache.org by GitBox <gi...@apache.org> on 2020/06/29 08:29:30 UTC

[GitHub] [incubator-iotdb] jixuan1989 commented on pull request #1367: [IOTDB-749] Handle select * from root OOM

jixuan1989 commented on pull request #1367:
URL: https://github.com/apache/incubator-iotdb/pull/1367#issuecomment-651013673


   I register 10_000_000 timeseries by:
   ```java
     public static void main(String[] args) throws ClassNotFoundException, SQLException {
       Class.forName("org.apache.iotdb.jdbc.IoTDBDriver");
       try (Connection connection = DriverManager
           .getConnection("jdbc:iotdb://127.0.0.1:6667/", "root", "root");
           Statement statement = connection.createStatement()) {
         int total = 10_000_000;
         try {
           statement.execute("SET STORAGE GROUP TO root.sg1");
           for (int i = 0; i < total; i++) {
             statement.execute(
                 "CREATE TIMESERIES root.sg1.d1.s" + i
                     + " WITH DATATYPE=INT64, ENCODING=RLE, COMPRESSOR=SNAPPY");
             if (i % 10_000 == 0) {
               System.out.println((double) i / total * 100 + "%");
             }
           }
         } catch (IoTDBSQLException e) {
           System.out.println(e.getMessage());
         }
         
       } catch (IoTDBSQLException e) {
         System.out.println(e.getMessage());
       }
     }
   ```
   
   And then call `select * from root`;
   The CLI hangs..
   
   


----------------------------------------------------------------
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.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org