You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@iotdb.apache.org by "Xiangdong Huang (Jira)" <ji...@apache.org> on 2020/02/25 18:19:00 UTC

[jira] [Created] (IOTDB-523) A potential query optimization for querying many measurements of a device

Xiangdong Huang created IOTDB-523:
-------------------------------------

             Summary: A potential query optimization for querying many measurements of a device
                 Key: IOTDB-523
                 URL: https://issues.apache.org/jira/browse/IOTDB-523
             Project: Apache IoTDB
          Issue Type: Improvement
          Components: Core/Engine
            Reporter: Xiangdong Huang


Hi,

Today when I run a SQL like `select * from root` and enable the debug log on server, I find so many DeviceMetaData and ChunkMetadata are read.

Considering that in TsFile, a device's multiply chunk data will be stored together, is that possible to have the following optimization?

If a user query many measurements (e.g., select *  from, or select more than 1/2 measurements of a device), maybe there is no need to read the ChunkMeatadata... because if we find a ChunkGroup, if one column is needed to be read, other columns are high probability to be read.

I am not sure whether my idea is correct. Please leave your opinions.

 

 



--
This message was sent by Atlassian Jira
(v8.3.4#803005)