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
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:
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
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
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