Re: No of arguments passing issue in kylin query

2017-06-22 Thread suresh m
) and AL_PROD.CLNDR_DT BETWEEN '2017-06-20' and '2017-06-20' order by AL_PROD.CLNDR_DT On Thu, Jun 22, 2017 at 2:45 PM, suresh m <suresh.m8...@gmail.com> wrote: > Hi, > > Facing an issue with passing no of arguments in Kylin Query. > > When I am querying with less than or eaqual to 5 arguemen

No of arguments passing issue in kylin query

2017-06-22 Thread suresh m
Hi, Facing an issue with passing no of arguments in Kylin Query. When I am querying with less than or eaqual to 5 arguements result is coming properly. If i pass more than 5 arguments result showing as 0 even though records there in cube. sending you the query as well, SELECT

How to change kylin execution engine from Mapreduce to Tez

2017-04-28 Thread suresh m
Hi, I can see here my kylin job executing threw Mapreduce, i think this is one of the reason for taking more time to build cube. Is there any chance to change execution engine as Tez. Attaching screen shot for reference.

cube building with huge memory, for 5000 records 2.3GB

2017-04-28 Thread suresh m
Hi, My kylin cube taking huge memory just for few records. Even i changed compression property as Snappy but still occupying huge memory. Attaching screenshot for your reference. Suggestions are welcome to reduce cube size. Regards, Suresh

Re: cube building taking 8 hours just for 6 thousands records

2017-04-28 Thread suresh m
uring build phase (you can see how many Mappers > and > > reduce, RAM and CPU are you using) > > > > 2017-04-18 13:45 GMT+01:00 suresh m <suresh.m8...@gmail.com>: > > > > > sorry it is for all 3 nodes. > > > > > > each node 55gb ram and 1

Re: cube building taking 8 hours just for 6 thousands records

2017-04-18 Thread suresh m
yarn.nodemanager.resource.cpu-vcores > > During Build process, you can open YARN UI how many map-reduce are you > using. > > 2017-04-18 13:21 GMT+01:00 suresh m <suresh.m8...@gmail.com>: > > > Hi, > > > > I can see 150gb ram and 36 cpu in our cluster.

Re: cube building taking 8 hours just for 6 thousands records

2017-04-18 Thread suresh m
n.apache.org/docs20/howto/howto_optimize_ > build.html > > > > > -- 原始邮件 ------ > 发件人: "suresh m";<suresh.m8...@gmail.com>; > 发送时间: 2017年4月17日(星期一) 晚上7:05 > 收件人: "dev"<dev@kylin.apache.org>; > > 主题: cube build

Re: Is there any limitation of columns in Fact table in kylin

2017-03-29 Thread suresh m
Hi Could you please respond on this very urgent for me. Regards, Suresh On Tue, Mar 28, 2017 at 7:13 AM, suresh m <suresh.m8...@gmail.com> wrote: > Hi, > > > One of my fact table contains 125 columns and while creating the cube > showing attached error. > > Pleas

error while refreshing cube with curl script

2017-03-06 Thread suresh m
Hi, Please find the curl script what i am using for refreshing cube. curl -u ADMIN:KYLIN -X PUT -H "Content-Type: application/json" -d '{"startTime": 140479590,"endTime": 224061090,"buildType": "REFRESH"}' http://*.*.*.*:7070/kylin/api/cubes/AL_RPT_PROD/rebuild

Re: Error while cube refreshing using REST API

2017-03-06 Thread suresh m
rameter and figure out which segment you were > refreshing. > > One more thing, please do not open JIRA for questions. > > 2017-02-28 19:06 GMT+08:00 suresh m <suresh.m8...@gmail.com>: > > > Hi, > > > > Getting below error While refreshing cube with REST API. &

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

2017-01-31 Thread suresh m
Hi, I am facing one issue where i need customised sum of values, but i can see there is a mismatch in actual sum and sum in kylin. and as i observed if there is repeated value its taking only once for summery. But in hive i can see exact result and only issue with kylin For ex: i have my

Re: Is kylin not support Hive ORC tables with ACID properties.

2016-11-27 Thread suresh m
Please find detail as requested, Log Type: syslog Log Upload Time: Fri Nov 25 15:16:35 +0530 2016 Log Length: 107891 2016-11-25 15:15:35,185 INFO [main] org.apache.hadoop.mapreduce.v2.app.MRAppMaster: Created MRAppMaster for application appattempt_1479580915733_0167_01 2016-11-25

Re: how to refresh cube automatically in kylin 1.5.4.1

2016-11-25 Thread suresh m
e.org/mod_mbox/kylin-user/ > 201607.mbox/%3CCAF7etTns%3DO%2BA5iN9vB8BGxGM6HQT- > EieUiqGh3msTm9zaEaUiQ%40mail.gmail.com%3E > > 2016-11-10 7:53 GMT+01:00 suresh m <suresh.m8...@gmail.com>: > > > Hi, > > > > I have a requirement where i need to refresh cube daily automa

how to refresh cube automatically in kylin 1.5.4.1

2016-11-09 Thread suresh m
Hi, I have a requirement where i need to refresh cube daily automatically. But i don't see any property or options in kylin 1.5.4.1. for ex: my hive fact and dimensions keep on loading daily basis, so that changes should reflect in kylin cube automatically. Please provide me solution to resolve.