Re: Re: kylin前端业务查询问题

The conf of ''kylin.query.timeout-seconds" may help to stop long query 在 2017年12月29日 下午3:13，chenping...@keruyun.com 写道： > 多谢你的及时回复 > > -- > > 陈平 DBA工程师 > > > > 成都时时客科技有限责任公司 > > 地址：成都市高新区天府大道1268号1栋3层 > > 邮编：610041 > > 手机：15108456581 > >

Re: how big cardinal of a column if we want to code a column as dict?

19 > > Please check whether it works on your side. > > 2017-11-29 16:01 GMT+08:00 杨浩 <yangha...@gmail.com>: > >> I have generated the dict data size on TrieDictionaryForestBenchmark. >> If cardinality is less than 2, the dict size will be less than 802KB. >> W

Re: how big cardinal of a column if we want to code a column as dict?

? cardinality 0 1 2 3 4 5 6 7 dict size 64B 406KB 802KB 1MB 1MB 1MB 2MB 2MB 2017-11-25 22:42 GMT+08:00 杨浩 <yangha...@gmail.com>: > Thanks. The biggest number has been writen in "Kylin Guide", but it may > affect query performance for

Re: how big cardinal of a column if we want to code a column as dict?

er, But it's better to control that less than > 1 million. > > 2017-11-24 20:33 GMT+08:00 杨浩 <yangha...@gmail.com>: > >> There are many cubes in our kylin env. Can any one give the numer of how >> big cardinal of a column if we want to code a column as dict? >> > > > > -- > Best regards, > > Shaofeng Shi 史少锋 > >

how big cardinal of a column if we want to code a column as dict?

There are many cubes in our kylin env. Can any one give the numer of how big cardinal of a column if we want to code a column as dict?

Re: Shall we define the base cuboid?

| Cuboid 000101001110101100, est row: 9857, >> est MB: 165.09, shrink: 98.4% > > | Cuboid 00011110101100, est row: >> 9865, est MB: 165.22, shrink: 100.08% > > | Cuboid 0001110011, est row: 990

Re: Shall we define the base cuboid?

So, shall we change the document to delete the AGG1 , and says it is computed by default? 2017-11-20 8:55 GMT+08:00 ShaoFeng Shi <shaofeng...@apache.org>: > Yes, the base cuboid is the cuboid of all dimensions on rowkey. It is the > parent of all AGG. > > 2017-11-19 16:06 GM

Re: how to change the order of rowkey_columns

Thanks for that 2017-11-14 22:50 GMT+08:00 Billy Liu <billy...@apache.org>: > You could change the rowkey order by drag-and-drop from GUI directly. > > 2017-11-14 10:52 GMT+08:00 杨浩 <yangha...@gmail.com>: > >>To speed up the query, we should position the fr

how to change the order of rowkey_columns

To speed up the query, we should position the frequent column before others, such as partition column date should be at the first for every query would contain it. Then how to change the order of rowkey_columns, or in other words, what decides the order of rowkey_columns?

what's the best practice for choosing machine for kylin

What's the best practice for choosing machine for kylin?

question about joint dimensions

I have used aggregation groups to reduce cuboids, but it seems not take effect. A table has dimension A, B, C, D, E, and set this aggregation groups: group 1: A,B,C which has joint dimensions A,B,C group 2: A,B,D which has joint dimensions A,B,D group 3: A,B,E which has joint dimensions A,B,E but

Re: [Announce] New Apache Kylin PMC Billy Liu

Congratuolations to Bill, Guosheng and Cheng Wang !! 2017-10-16 20:41 GMT+08:00 Alberto Ramón : > Congratuolations to Bill, Guosheng and Cheng Wang !! > > On 16 October 2017 at 11:33, Luke Han wrote: > >> On behalf of the Apache Kylin PMC, I am

How to remove error model?

There are some error model/cube in kylin, it cannot be seen in the website, and I cannot genereate the same model named that, How to delete it? Command bin/metastore.sh clean --delete true cannot delete the dirty model.

Re: how to filter long tail data

ot;_COUNT_" after all cuboid generated I have a question for the topN measure: does it also filter data for default measure _COUNT_ which is not in the TopN ? 2017-09-05 15:28 GMT+08:00 ShaoFeng Shi <shaofeng...@apache.org>: > Cool, that is the case of top N. > > 2017-09-0

Re: how to filter long tail data

-N measure is amied to filter the long tail data. Besides, in Data > model, there is a "filter condition", where you can add a filtering > condition to exclude those tail data. > > 2017-09-04 10:54 GMT+08:00 杨浩 <yangha...@gmail.com>: > >> Okay, our team want to u

How to filter the long tail data?

If a index is less than 2, we don't want to store it in hbase . How to filter the long tail data ?

how to filter long tail data

If a index is less than 2, we don't want to store it in hbase . How to filter the long tail data ?

Re: use standalone secure Hive and MR

http-bio-7070-exec-10] HiveMetaStore.audit: ugi=grid > ip=unknown-ip-addr cmd=get_all_databases * 2017-06-27 20:10 GMT+08:00 Billy Liu <billy...@apache.org>: > Are you looking for this http://kylin.apache.org/ > blog/2016/06/10/standalone-hbase-cluster/? > > > 2017-06-

use standalone secure Hive and MR

Our company have used a hadoop version different from Apache Hadoop, and kerberos is used to keep secure. Our group want to use Kylin, using hive and MR from our company , but the hbase maintained by our team using Apache HBase. We have used Hive beeline but it cannot read meta info from Hive.