Re: Encounter cube merge error when deploy kylin on stand alone hbase cluster

Hi Billy: I have create an issue at https://issues.apache.org/jira/browse/KYLIN-2648 -- View this message in context: http://apache-kylin.74782.x6.nabble.com/Encounter-cube-merge-error-when-deploy-kylin-on-stand-alone-hbase-cluster-tp8093p809

[jira] [Created] (KYLIN-2648) Encounter cube merge error when deploy kylin on stand alone hbase cluster

suheng.cloud created KYLIN-2648: --- Summary: Encounter cube merge error when deploy kylin on stand alone hbase cluster Key: KYLIN-2648 URL: https://issues.apache.org/jira/browse/KYLIN-2648 Project: Kylin

Re: Encounter cube merge error when deploy kylin on stand alone hbase cluster

It seems a bug. Could you open a JIRA for issue? 2017-05-26 11:03 GMT+08:00 suheng.cloud : > Hi all : > > I try to deploy kylin on one node of a stand alone hbase > cluster(hdfs://cdh5-mini/) which seperate from main hive > cluster(hdfs://cdh5/), > According to the blog "Deploy Apache Kylin with

Re: How can I use substr function in query or find an alternative way

Except that PERIOD becomes a reserved keyword in the next version of Calcite. :) On Thu, May 25, 2017 at 6:33 PM, Billy Liu wrote: > A better way is to define PERIOD in your Hive view, and load the Hive view > as the fact table. > > 2017-05-25 14:47 GMT+08:00 jiawei chen : > >> Hi kylin's develop

Encounter cube merge error when deploy kylin on stand alone hbase cluster

Hi all : I try to deploy kylin on one node of a stand alone hbase cluster(hdfs://cdh5-mini/) which seperate from main hive cluster(hdfs://cdh5/), According to the blog "Deploy Apache Kylin with Standalone HBase Cluster" : make sure the configurations of hadoop and hive points to main cluster, I cl

?????? java.lang.NoClassDefFoundError: org/apache/hadoop/hive/ql/session/SessionState

Hi ShaoFeng I can not get answer to solve the problem, Can you help solve the problem? Thanks. I create EMR Cluster in the aws console. Application??Hive 2.1.1, Tez 0.8.4, HBase 1.3.0, ZooKeeper 3.4.10, Spark 2.1.0, HCatalog 2.1.1 -- -- ??: "ShaoF

Re: How can I use substr function in query or find an alternative way

A better way is to define PERIOD in your Hive view, and load the Hive view as the fact table. 2017-05-25 14:47 GMT+08:00 jiawei chen : > Hi kylin's developers, > I am using kylin-1.6.0 now. I have to use a sql query like: > > SELECT > SUBSTR(TO_CHAR(`time`,'MMDDHH24MISS'),9,2) AS PERIOD,

Re: [jira] [Created] (KYLIN-2638) Cannot install Kylin

Hi Shailesh, thanks for the reporting. I reopend the JIRA. Would you like to provide more information about your env? Such as the OS, JDK version. 2017-05-24 0:09 GMT+08:00 kylinuser2017 : > Same issue. Fails to start kylin as get-properties returns empty string > for > all properties defined i

Re: java.lang.NoClassDefFoundError: org/apache/hadoop/hive/ql/session/SessionState

Hi Zhang Lei, Did you solve the problem? 2017-05-17 17:13 GMT+08:00 ShaoFeng Shi : > Kylin runs good with EMR 5.5 on AWS Oregon zone, I verfied that today; > also Spark engine runs well. > > 2017-05-16 23:02 GMT+08:00 ShaoFeng Shi : > >> Hi Lei, >> >> How did you create the EMR cluster? did you

Re: It does not work use Kylin-2.0-spark-1.5.2-hadoop-2.7

Yes Kylin 2.0 is compiled with Spark 1.6.3, so please use the embeded Spark in Kylin binary. Using other versions may got such mis-matched errors. 2017-05-23 18:15 GMT+08:00 hger : > System: Kylin-2.0 spark-cluster-1.5.2 HDP2.3:hadoop-2.7.1.2 lib > spark-assembly-1.5.2.2.3.4.7.4-hadoop2.7.1.2.3.4

Re: How can I use substr function in query or find an alternative way

Hi Jiawei, did you check Apache Calcite's SQL grammer? Kylin uses Calcite to parse SQL, it can help: https://calcite.apache.org/docs/reference.html 2017-05-25 14:47 GMT+08:00 jiawei chen : > Hi kylin's developers, > I am using kylin-1.6.0 now. I have to use a sql query like: > > SELECT > SUBS

[jira] [Created] (KYLIN-2647) Should get FileSystem from HBaseConfiguration in HBaseResourceStore

kangkaisen created KYLIN-2647: - Summary: Should get FileSystem from HBaseConfiguration in HBaseResourceStore Key: KYLIN-2647 URL: https://issues.apache.org/jira/browse/KYLIN-2647 Project: Kylin

How can I use substr function in query or find an alternative way

Hi kylin's developers, I am using kylin-1.6.0 now. I have to use a sql query like: SELECT SUBSTR(TO_CHAR(`time`,'MMDDHH24MISS'),9,2) AS PERIOD, COUNT(*) AS LL, FROM table_name GROUP BY SUBSTR(TO_CHAR(`time`,'MMDDHH24MISS'),9,2); and I got a failed response that shows no match found fo

Re: [jira] [Created] (KYLIN-2638) Cannot install Kylin

Same issue. Fails to start kylin as get-properties returns empty string for all properties defined in kylin.properties CDH 5.11 Kylin 2.0.0 -bash-4.1$ ./get-properties.sh kylin.metadata.url -bash-4.1$ -- View this message in context: http://apache-kylin.74782.x6.nabble.com/jira-Created-KYLIN

Review Request 59521: KYLIN-2644 When I refresh the insight page and click "Add Project" button, but the new project pop-up page is not showing.

--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/59521/ --- Review request for kylin, Dayue Gao, Dong Li, hongbin ma, and Wang Xiaoyu. Bugs

Review Request 59488: KYLIN-2641 The current selected project is incorrect after we delete a project.

--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/59488/ --- Review request for kylin, Dayue Gao, Dong Li, hongbin ma, and Wang Xiaoyu. Bugs

It does not work use Kylin-2.0-spark-1.5.2-hadoop-2.7

System: Kylin-2.0 spark-cluster-1.5.2 HDP2.3:hadoop-2.7.1.2 lib spark-assembly-1.5.2.2.3.4.7.4-hadoop2.7.1.2.3.4.7.jar Error occured when I build the cube with kylin-engine while the job has added to the kylin-history webUI 17/05/23 17:26:04 INFO CubeManager: Reloaded cube DFAD being CUBE[name=DF

RE: The problem of Kylin version

Did you have any issue by starting the UI? I am trying to install it on CDH5.11 and the UI won’t start. HAve you made any configuration change / path export or it just worked? Thanks, Gergely From: Billy Liu [mailto:billy...@apache.org] Sent: Tuesday, May 23, 2017 10:08 AM To: dev Cc: use

[jira] [Created] (KYLIN-2646) Project level query authorization

hongbin ma created KYLIN-2646: - Summary: Project level query authorization Key: KYLIN-2646 URL: https://issues.apache.org/jira/browse/KYLIN-2646 Project: Kylin Issue Type: Improvement