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:

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

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

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

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

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

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

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

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,

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.

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

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

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

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.

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

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

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

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:

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.

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.

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:

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

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.

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

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.

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.