imay opened a new issue #1236: Bad performance when query a table which has 
many columns(100+)
URL: https://github.com/apache/incubator-doris/issues/1236
 
 
   **Describe the bug**
   
   When query two columns in a wide table (`table1`) which has many columns, in 
this case is 178 columns.
   I found that `BlockConvertTime` in query profile takes majority of query 
time. The information is like following picture.
   
   
![image](https://user-images.githubusercontent.com/1249159/58787694-e6bf1700-861c-11e9-89dc-29a291a78292.png)
   
   But when I create a new table (`table2`) which has only 5 columns and has 
the same number of rows with `table1`. And a same query is executed for 
`table2`, `BlockConvertTime` becomes extremely low. 
   
   
![image](https://user-images.githubusercontent.com/1249159/58788287-2c301400-861e-11e9-82df-272fabec150b.png)
   
   So, there is some space which can be improved when Doris handle wide table. 
   

----------------------------------------------------------------
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:
[email protected]


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to