Hive and Kylin synchronization

how kylin tables are synchronized with hive. if we drop table from hive then what would happen? -- View this message in context: http://apache-kylin.74782.x6.nabble.com/Hive-and-Kylin-synchronization-tp7060.html Sent from the Apache Kylin mailing list archive at Nabble.com.

Re: Hive and Kylin synchronization

thanks -- View this message in context: http://apache-kylin.74782.x6.nabble.com/Hive-and-Kylin-synchronization-tp7060p7099.html Sent from the Apache Kylin mailing list archive at Nabble.com.

Getting this exception at step 18 Build Cube

Error: java.io.IOException: Failed to build cube in mapper 0 at org.apache.kylin.engine.mr.steps.InMemCuboidMapper.cleanup(InMemCuboidMapper.java:145) at org.apache.hadoop.mapreduce.Mapper.run(Mapper.java:148) at org.apache.hadoop.mapred.MapTask.runNewMapper(MapTask.java:787) at org.apache.hadoop.m

Re: Getting this exception at step 18 Build Cube

apache-kylin-1.6.0-cdh5.7-bin -- View this message in context: http://apache-kylin.74782.x6.nabble.com/Getting-this-exception-at-step-18-Build-Cube-tp7108p7112.html Sent from the Apache Kylin mailing list archive at Nabble.com.

Re: URGENT !!! Help needed - Issue executing query in Kylin

You have to set the KYLIN_HOME first before starting the kylin -- View this message in context: http://apache-kylin.74782.x6.nabble.com/URGENT-Help-needed-Issue-executing-query-in-Kylin-tp7046p7114.html Sent from the Apache Kylin mailing list archive at Nabble.com.

Re: Getting this exception at step 18 Build Cube

When I build with only fact table it build successfully. But when I work with fact table and lookup table it will throw the above exception. Please give if you have solution for this. thank you -- View this message in context: http://apache-kylin.74782.x6.nabble.com/Getting-this-exception-at-step

Re: Getting this exception at step 18 Build Cube

thank you -- View this message in context: http://apache-kylin.74782.x6.nabble.com/Getting-this-exception-at-step-18-Build-Cube-tp7108p7127.html Sent from the Apache Kylin mailing list archive at Nabble.com.

Kylin with Node JS

Can we connect kylin with Node Js?? like kylin with JDBC.. -- View this message in context: http://apache-kylin.74782.x6.nabble.com/Kylin-with-Node-JS-tp7180.html Sent from the Apache Kylin mailing list archive at Nabble.com.

about cube building?

what are ideal way to build cube? Like what are the parameters we should keep in mind before building cube? how much data(in days) can be stored in cube? What is the best incremental period for cube? -- View this message in context: http://apache-kylin.74782.x6.nabble.com/about-cube-building-tp71

Re: about cube building?

Thank you for the solution. But I have already gone through this documentation. Now my scenario is that i am building cube of 30 days data is first build then again other 30 days data in second build, then i m merging the cube, while merging it is taking around 150 mins to merge, the i have added

Re: about cube building?

Yes, it is a full date in the format of -MM-DD -- View this message in context: http://apache-kylin.74782.x6.nabble.com/about-cube-building-tp7181p7187.html Sent from the Apache Kylin mailing list archive at Nabble.com.

Re: about cube building?

Around 700 MB we are adding per day. -- View this message in context: http://apache-kylin.74782.x6.nabble.com/about-cube-building-tp7181p7190.html Sent from the Apache Kylin mailing list archive at Nabble.com.

Re: Help needed - Issue when build the cube

At which step of cube building you are getting this exception? -- View this message in context: http://apache-kylin.74782.x6.nabble.com/Help-needed-Issue-when-build-the-cube-tp7191p7192.html Sent from the Apache Kylin mailing list archive at Nabble.com.

Re: [jira] [Created] (KYLIN-2445) UI: select cube engine in "Advanced setting" page

In which version of Kylin this is applied? -- View this message in context: http://apache-kylin.74782.x6.nabble.com/jira-Created-KYLIN-2445-UI-select-cube-engine-in-Advanced-setting-page-tp7193p7194.html Sent from the Apache Kylin mailing list archive at Nabble.com.

Re: about cube building?

And how much data(in size) we can keep in cube? -- View this message in context: http://apache-kylin.74782.x6.nabble.com/about-cube-building-tp7181p7195.html Sent from the Apache Kylin mailing list archive at Nabble.com.

Re: Kylie Cube Building,Merging and Refreshing getting stucked at Create HFile Step

Check the logs where it get stucked. -- View this message in context: http://apache-kylin.74782.x6.nabble.com/Kylie-Cube-Building-Merging-and-Refreshing-getting-stucked-at-Create-HFile-Step-tp7199p7200.html Sent from the Apache Kylin mailing list archive at Nabble.com.

Re: about cube building?

thank you for your response.. but still i am little bit confused about cube merging time. Thank You -- View this message in context: http://apache-kylin.74782.x6.nabble.com/about-cube-building-tp7181p7203.html Sent from the Apache Kylin mailing list archive at Nabble.com.

Re: about cube building?

need some clarification. 1. Is there any kylin package for nodejs? 2. Can we use nodejs as backend with kylin? Thank you -- View this message in context: http://apache-kylin.74782.x6.nabble.com/about-cube-building-tp7181p7204.html Sent from the Apache Kylin mailing list archive at Nabble.com.

Re: about cube building?

Thank you -- View this message in context: http://apache-kylin.74782.x6.nabble.com/about-cube-building-tp7181p7208.html Sent from the Apache Kylin mailing list archive at Nabble.com.

Re: Kylin with Node JS

i am facing this error when i am trying to connect kylin to nodejs. { [Error: write EPROTO 140375442388864:error:140770FC:SSL routines:SSL23_GET_SERVER_HELLO:unknown protocol:../deps/openssl/openssl/ssl/s23_clnt.c:794: ] code: 'EPROTO', errno: 'EPROTO', syscall: 'write' } can anyone help. Thank

Straming Cube is not building

Hi all, My streaming cube is not building from GUI build option. I have also tried to build it from Postman but the same exception getting. Exception is startoffset must be smaller than endoffset. And my cube startoffset is smaller than endoffset. Then also it is giving same exception. Plz help

get

Hi all, getting this error while building a cube Please help. Thanks org.apache.hadoop.mapred.YarnChild: Exception running child : java.io.IOException: Failed to build cube in mapper 9 at org.apache.kylin.engine.mr.steps.InMemCuboidMapper.cleanup(InMemCuboidMapper.java:145) at org

Which cubing algorithm is better for building a cube

hi, which cubing algorithm should be used for extreme high level of data for eg: i have 54 millions rows. Thanks -- View this message in context: http://apache-kylin.74782.x6.nabble.com/Which-cubing-algorithm-is-better-for-building-a-cube-tp7382.html Sent from the Apache Kylin mailing list arc

Re: get

hi, thanks for replying. Cube consist 57 measure in which some have integer data type and some have double. Thank You -- View this message in context: http://apache-kylin.74782.x6.nabble.com/Getting-this-exception-at-step-18-Build-Cube-tp7378p7385.html Sent from the Apache Kylin mailing list ar

Kylin job killed by admin

hi all, A kylin job failed with message: killed by admin MAP capability required is more than the supported max container capability in the cluster. Killing the Job. mapResourceRequest: maxContainerCapability: Job received Kill while in RUNNING state. Thank You -- View this message in context:

Re: 答复: Kylin job killed by admin

hi 答复, Thank you for the solution. Now the cube is building properly without any issue. Thank You. -- View this message in context: http://apache-kylin.74782.x6.nabble.com/Kylin-job-killed-by-admin-tp7390p7397.html Sent from the Apache Kylin mailing list archive at Nabble.com.

Hbase Region server goes down

Hi all, I am facing this exception while building the cube. Whenever I build the cube the region server goes down. I am not understanding this exception. Please explain is anyone know about this exception. Thank You, Rahul Singh java.net.SocketTimeoutException: callTimeout=6, callDuration=87

Re: Hbase Region server goes down

Yes. My HBase RS is running on same node as YARN NodeManager is running. But I have'nt faced this issue on previously builded cube on same cluster. Thank You -- View this message in context: http://apache-kylin.74782.x6.nabble.com/Hbase-Region-server-goes-down-tp7437p7441.html Sent from the Apac

Re: get

hi, Still i am facing the above exception. Please, give me if you have any solution for this. Thank You, Rahul Singh -- View this message in context: http://apache-kylin.74782.x6.nabble.com/Getting-this-exception-at-step-18-Build-Cube-tp7378p7444.html Sent from the Apache Kylin mailing list arc

Re: get

Hi shaofengshi, I have attached the Cube Metadata file in the attachment. Thank You cube_metadata.txt -- View this message in context: http://apache-kylin.74782.x6.nabble.com/Getting-this-exception-at-step-18-Build-Cube-t

About Aggregation Group

Hi all, I have an issue regarding aggregation group of Kylin. I have built cube two times with two differrent scenarios that are. In first time I have mentioned the Id's dimensions as Mandatory dimensions, then the cube built in just 25 mins and size of Htable is also less.(size in MB) But, In se

Kylin job failed due to memory

Hello All, I am facing this exception at step 18 build cube. I have increased yarn mapreduce.map.memory.mb to 10GB and mapreduce.reduce.memory.mb to 14GB and accordingly i have increased the heap size. But no solution found. Thank You Rahul Singh This is the exception: Container [pid=17394,con

Rowkey in Advance Setting of Cube

Hi All, I am totally confused about Rowkey in Advance Setting of Cube. I am deleting some dimensions from Rowkey and save the Cube, then I see the cube after saving, it remains same. My question is what will happen if I remove the dimensions from the Rowkey. Will everything work correctly? UI al

Re: Rowkey in Advance Setting of Cube

Thank You shaofengshi, Actually I was confused because of the minus(-) . in front of the every Rowkey. So, I was deleting the dimensions from the Rowkeys section.. :) Thank You, Rahul Singh -- View this message in context: http://apache-kylin.74782.x6.nabble.com/Rowkey-in-Advance-Setting-of-Cub

Server goes down while Tableau query is running

Hi all, I am facing issue when Tableau 10.2 runs query, the kylin node going down whenever Tableau runs query. I am not understanding what is the actual issue? Should we load the whole data in Tableau then prepare a sheet or something other than this. Whenever I check the kylin logs I am getting

BadQueryDetector (Please ignore the last post)

Hi all, We are using Tableau Desktop 10.2.1 with Kylin 1.6. We got success to connect kylin with tableau wia ODBC driver. We have one table in kylin having 41 columns and around 5 milion records. And we use this table as a data source in tableau. When we prepare report in Tableau with some rows a

Please set kylin.env.hdfs-working-dir in kylin.properties Error

Hi All, I have installed hadoop cluster with CDH - 5.9 and I am running apache-kylin-2.1.0-bin-cdh57. While using bin/check-env.sh or kylin.sh start command its giving as, Retrieving hadoop conf dir... KYLIN_HOME is set to /opt/apache-kylin-2.1.0-bin-cdh57 Please set kylin.env.hdfs-working-dir in

Query Problem

Hello All, I am not able to fetch measures data using select * from "table_name", I got proper data when I used sum on the specific measures. I don't know why it is giving blank data on all measures. Please help if anyone has faced this issue. Thanks, Rahul -- Sent from: http://apache-kylin.747