Performance troubleshoot is complicated and requires much information. If you can share a diagnosis pack, people maybe able to help.
On Sat, Aug 13, 2016 at 10:32 PM, Yiming Liu <[email protected]> wrote: > What's kind of queries? How many records supposed to be returned? Could you > send out the query log together? > > 2016-08-12 10:28 GMT+08:00 Mars J <[email protected]>: > > > Hi, > > I have run Kylin 1.5.2.1 and build a cube successfully,the cube size > is > > 3.2G for fact table and dimensional table have 1.5 million records > > seperately.HTable count is about 200 billion. > > My Cube Design includes 3 Derived Dims and 5 Normal Dims which formed > a > > hierachy dim in agg. Rowkeys are generated automatically,the first and > > second rowkey is the highest cardinality column in fact table and one dim > > table seperately. > > > > When I query it from kylin insight, it costs 11s,and the second same > > query is also 10+s, How can I optimize this ? > > > > > > -- > With Warm regards > > Yiming Liu (刘一鸣) >
