Re: Urgent!!! exact sum of values are not coming in kylin when executed query in Insight

2017-02-02 Thread ShaoFeng Shi
In the first step of cube build, Kylin creates an intermediate flat table; did you compare the result between this intermediate table and Kylin? If they are matched, then you need investigate the source hive table and this intermediate table. Inner joins, time condition and other factors will cause

Re: Re: build cube and hbase coprocessor not avaliable

2017-02-02 Thread ShaoFeng Shi
Hi Ye, Could you please provide the following information for check?: 1) your Kylin and Hadoop/HBase version 2) log output when Kylin executes the "Create HTable" step; 3) the description of such a table in hbase shell : "describe KYLIN_A"; 4) the file lists in $KYLIN_HOME/lib 2017-02-01 22:

Re: Does Kylin support percent function?

2017-02-02 Thread ShaoFeng Shi
It is simple; You can define a view over the fact table, in which adding a new column to materialize the calculation of "CASE WHEN (host="local") then 1 else 0 end", say its name is IS_LOCAL; Then use the view to as the fact table in cube, adding SUM(IS_LOCAL) as a measure, that's it!; After the c

Re: Hive and Kylin synchronization

2017-02-02 Thread Alberto Ramón
no, isn't sync you can sync metadata from Model > Data Source, > Arrow> Sync Changes in metadata may involve a invalid data model 2017-02-02 5:53 GMT+01:00 rahulsingh : > how kylin tables are synchronized with hive. if we drop table from hive > then > what would happen? > > -- > View this messag

Re: Does Kylin support percent function?

2017-02-02 Thread Alberto Ramón
short answer: no nowadays: We have Sum, count, Max , min, Avg, count distinct, TopN Deprecated: Raw Future: Percentile (see Kylin 2396) Alternative solutions: http://apache-kylin.74782.x6.nabble.com/Derived-measures-in-Kylin-td5513.html Tip: See this bug Kylin 2341, I think can be important for