Understanding Query Cache In Apache Kylin

2018-11-13 Thread Shrikant Bang
metrics). Will query go through query cached result (of D1,D2,D3) or runs a query on HBase Table? P.S. I am using Apache Kylin v2.5.1-hbase1.x Thank You, Shrikant Bang

Re: Kylin Cluster Mode Issue Overwriting conflict /user/ADMIN

2018-11-10 Thread Shrikant Bang
Thanks JiaTao for response. I have upgraded Kylin to v2.5.1-hbase1.x and issue resolved. Regards, Shrikant Bang. On Sat, Nov 10, 2018 at 7:22 AM JiaTao Tao wrote: > Seems the same with this JIRA: > https://issues.apache.org/jira/browse/KYLIN-3562. > > Shrikant Bang 于2018年11月10

Kylin Cluster Mode Issue Overwriting conflict /user/ADMIN

2018-11-09 Thread Shrikant Bang
) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:745) Thank You, Shrikant Bang.

Re: Default Bloom Filters for HTables

2018-10-29 Thread Shrikant Bang
Thank you Yichen, for response. Its a very informative! Regards, Shrikant Bang. On Mon, Oct 29, 2018 at 12:23 PM Yichen Zhou wrote: > Hi Shrikant, > > > Kylin use FuzzyRowFilter instead of Bloom Filter. FuzzyRowFilter can find > the row key which matches the specific pattern an

Default Bloom Filters for HTables

2018-10-25 Thread Shrikant Bang
reason using BloomType.NONE? Please correct me if I am wrong. Thank You, Shrikant Bang

Re: Re: Re: Slow Query Performance With 'WHERE' Clause

2018-10-24 Thread Shrikant Bang
while scanning rows from HBase at coprocessor end. This also clarified me importance of order of the dimensions in the rowkey. Regards, Shrikant Bang. On Wed, Oct 24, 2018 at 7:56 AM Ma Gang wrote: > Hi Shrikant, > Which Kylin version you used? By default, most of the filters will be &

Re: Re: Slow Query Performance With 'WHERE' Clause

2018-10-23 Thread Shrikant Bang
efault)? Thank You, Shrikant Bang On Tue, Oct 23, 2018 at 4:33 PM Shrikant Bang wrote: > Thank you Ma for response. > > I didn't find any logs about applying filters in co-processors. Also I > don't see logs for logical/physical query plans in kylin.log. Am I missing > anyth

Re: Re: Slow Query Performance With 'WHERE' Clause

2018-10-23 Thread Shrikant Bang
-- would you please suggest any classes which can provide me these details? Regards, Shrikant Bang. On Tue, Oct 23, 2018 at 3:09 PM Ma Gang wrote: > You may post your query related log here, there should be some query log > that indicated whether the filter is push down or not, at

Re: Problematic thread for Query, BadQueryDetector

2018-10-23 Thread Shrikant Bang
to solve the problem of snapshot and slow queries? Regards, Shrikant Bang. On Tue, Oct 23, 2018 at 3:42 PM Ma Gang wrote: > Hi Shrikant, > > The log indicated that your query needs data from a snapshot lookup > table(your query columns should contain some derived columns defined i

Problematic thread for Query, BadQueryDetector

2018-10-23 Thread Shrikant Bang
le.java:69) at org.apache.kylin.dict.lookup.LookupStringTable.init(LookupStringTable.java:80) at org.apache.kylin.dict.lookup.LookupTable.(LookupTable.java:57) at org.apache.kylin.dict.lookup.LookupStringTable.(LookupStringTable.java:66) Thank You, Shrikant Bang

Re: Slow Query Performance With 'WHERE' Clause

2018-10-22 Thread Shrikant Bang
me to design/tune my cube/queries for better response time. Regards, Shrikant Bang On Mon, Oct 22, 2018 at 8:01 PM ShaoFeng Shi wrote: > Hi Shrikant, > > What's the order of the dimensions in the rowkey? In this case, you need > to put "d3" at the heading position o

Slow Query Performance With 'WHERE' Clause

2018-10-22 Thread Shrikant Bang
not getting used when query runs ( in case of multiple times also) . 4. Any best practises to tune the queries with WHERE clause? Thank You, Shrikant Bang.

NPE In QueryMetricsFacade

2018-10-21 Thread Shrikant Bang
t.java:650) at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846) Thank You, Shrikant Bang.

Rollup Rate > 100%

2018-09-06 Thread Shrikant Bang
Hi Team, With Kylin v2.4, I have noticed roll up rate is 100.59% ( at level 1 cuboid). Is this issue already filed in JIRA? Below is reference screen shot. [image: image.png] Thank You, Shrikant Bang.

Re: Encrypting Cube's Data

2018-09-05 Thread Shrikant Bang
Thank you, Ashish! On Tue, Sep 4, 2018, 9:05 PM Ashish Singhi wrote: > Hi Shrikant, > > You can enable encryption at HBase side. > Refer https://hbase.apache.org/book.html#hbase.encryption.server for more > details. > > > HTH > Ashish > > On Tue, Sep 4, 2018 a

Encrypting Cube's Data

2018-09-04 Thread Shrikant Bang
Hi Team, In one of our use case, we need to have data encrypted on disk. Is there any feature which can help us to encrypt cube's data on HBase? If yes, would you please share reference docs/JIRA links? P.S. We are using Kylin v2.4 Thank You, Shrikant Bang.

Re: Changes In Dimensions And Historical Cube's Data

2018-08-20 Thread Shrikant Bang
You, Shrikant Bang. On Mon, Aug 20, 2018 at 3:29 PM Shrikant Bang wrote: > Hi Team, > > We have a use case where dimension's data may get modified ( slowly > changing dimension (SCD)). > > Here is example: > > Fact : >user_activity ( > user_id STRI

Changes In Dimensions And Historical Cube's Data

2018-08-20 Thread Shrikant Bang
we join cube data with other dimensions on runtime ( changing dimensions table) , something like look ups? Thank You, Shrikant Bang.

Re: Queries For Building Cube

2018-08-15 Thread Shrikant Bang
nces in tuning "fact distinct column" job for those reducer which have high cardinality. I am trying with increasing memory as of now as partitioning and number of reducers are depends on cuboids number. P.S. I am using v2.4 of Kylin with HBase 1.x Thank You, Shrikant Bang On Tue,

Queries For Building Cube

2018-08-13 Thread Shrikant Bang
) and (A) 2. Refresh Settings: How to specify partition column and format while building cube for fact table. e.g. user_activity is partitioned by date '-MM-dd' and cube should be refreshed everyday with previous day's computation. Thank You, Shrikant Bang