Re: [DISCUSSION] optimization of OrderBy sorted columns + Limit Query

2017-09-24 Thread simafengyun
Recently , I used the latest code done test as below 1. Create Table:          CREATE TABLE rx5_tbox_parquet_all(           carid STRING,           inputstime TIMESTAMP,           carsyspwrmod INT,           cardofrontpas INT,           cardofrontdrv INT,           cardorearleft INT,  

[DISCUSSION] optimization of OrderBy sorted columns + Limit Query

2017-09-23 Thread 马云
Hi Carbon Dev, We faced slow sqls when apply carbondata in business system. In our custom info management system, only 2 million data in carbondata. we need to fetch data sorting by the costum’s phone number field and paginate data on the web page. For example, when loading our system index