Re:Load HFile to HBase Table Error

2021-01-17 Thread lk_hadoop
It's because the kylin.storage.hbase.cluster-fs I configed with a port number ,and the habse root.dir property dosn't hava a nameservice port number. The real ERROR message is not on master but on region server. At 2021-01-15 17:58:25, "lk_hadoop" wrote: hi,all: I'm using

Load HFile to HBase Table Error

2021-01-15 Thread lk_hadoop
hi,all: I'm using apache-kylin-3.1.0-bin-cdh57 under 5.16.1-1.cdh5.16.1.p0.3 and deploy as standalone-hbase-cluster. I got error : org.apache.kylin.engine.mr.exception.HadoopShellException: java.io.IOException: Retry attempted 10 times without completing, bailing out at

Re: cube build failing in step 3 -memory heap issue

2021-01-13 Thread ShaoFeng Shi
Hi, You can check the "Extract Fact Table Distinct Columns" section in https://kylin.apache.org/docs/howto/howto_optimize_build.html Usually it may be caused by: 1) cube may have too many dimensions; 2) there is ultra high cardinality column in the dimension list (e.g, a UUID column, timestamp

??????why cannot use more than 2 elements in SQL IN clause? This problem is threaten my business logic...I cannot use in clause

2021-01-11 Thread ????
maybe you use kylin the wrong way, check your cube design, follow the kylin docs instruction, read the document once more. ---- ??:

why cannot use more than 2 elements in SQL IN clause? This problem is threaten my business logic...I cannot use in clause

2021-01-09 Thread ????
dear users, I'm stuck by this problem more than 3 days, cannot find any usefull message by searched everywhere. If use more then 2 elements in IN clause, the query is failed. any ideas, thanks!! Timeout visiting cube! Check why coprocessor exception is not sent back? In

??????kylin??????????????

2021-01-08 Thread ????
Hi, Have you ever check "Why I got an error when running a ??select * ?? query?" in Kylin FAQ? Check this link :http://kylin.apache.org/docs/gettingstarted/faq.html. -- Why I got an error when running a ??select * ?? query? The cube only has aggregated data, so all your queries should be

?????? Problematic thread 0x3a Query be55b109-e1f2-32ff-f8fa-7e5b3948e42 f-58, query id: be55b109-e1f2-32ff-f8fa-7e5b3948e42f

2021-01-08 Thread ????
when use two (116,113) the query is ok, but when use three (106 , 116, 113) the query is error. it's strenge.. below is ok: SELECT COUNT(*) frequency, COUNT(DISTINCT sponsor) visitor FROM mt_trace_behavior WHERE staffid = 116 AND subtype IN (116,113) AND day_start = '2021-01-08'

Problematic thread 0x3a Query be55b109-e1f2-32ff-f8fa-7e5b3948e42 f-58, query id: be55b109-e1f2-32ff-f8fa-7e5b3948e42f

2021-01-08 Thread ????
dear users, when I use in clause,I got this error. but when not use in cluase, the query is ok. SELECT COUNT(*) frequency, COUNT(DISTINCT sponsor) visitor FROM mt_trace_behavior WHERE staffid = 116 AND subtype =106 AND day_start = '2021-01-08' AND day_start <= '2021-01-08'

Re:query result is not consistence

2021-01-07 Thread Xiaoxiang Yu
Hi, Have you ever check "Why I got an error when running a “select * “ query?" in Kylin FAQ? Check this link : http://kylin.apache.org/docs/gettingstarted/faq.html. -- Best wishes to you ! From :Xiaoxiang Yu 在 2021-01-06 14:53:35,"刘波" <1091643...@qq.com> 写道: dear users, I face the same

Re:答复: 来自li_cong521的邮件

2021-01-07 Thread li_cong521
Thanks for your replay. The HDFS space is 1.7T*10, may be is the parameter set in hadoop or kylin error? such as this ? the full error log is At 2021-01-08 10:39:57, "Wang rupeng" wrote: Hi, Isn’t this mean the out of space of your system disk or HDFS? The log “System

答复: 来自li_cong521的邮件

2021-01-07 Thread Wang rupeng
Hi, Isn’t this mean the out of space of your system disk or HDFS? The log “System free space”may not be printed by Kylin. Or you can show the detailed log so that we can find out the root cause. --- Best wishes, Rupeng Wang 发件人: li_cong521 日期: 星期三, 2021年1月6日 18:48 收件人: kylin

[no subject]

2021-01-06 Thread ????????

来自li_cong521的邮件

2021-01-06 Thread li_cong521
hello kylin创建cube的时候,在第四步出现了错误: org.apache.kylin.engine.mr.exception.HadoopShellException: java.lang.IllegalStateException: Table snapshot should be no greater than 300 MB, but TableDesc{name='TIME_TABLE', columns=[ColumnDesc{id='1', name='VIN_TIME', datatype='varchar(256)', comment='null'},

Re:query result is not consistence

2021-01-05 Thread ????
dear users, I face the same problem, it makes me confused. I'm use the kafka stream datasource. query fact sql less 1 record then query count sql. --Original-- From:

create htable failed

2021-01-05 Thread my is mine
when i build the cube,the step create htable failed,the error message below,why the reason org.apache.kylin.engine.mr.exception.HadoopShellException: java.lang.NullPointerException at org.apache.kylin.engine.mr.common.CubeStatsReader.getCuboidSizeMapFromRowCount(CubeStatsReader.java:227)

query result is not consistence

2021-01-04 Thread my is mine
when the club is built,no errors,query the fact table in kylin and datasource,the sql is select count(*) from fact_XX,there is a big difference,in kylin,the record is 253317772,in datasource the record is 264977088,why the different is so big

回复: When adjust rowkey order, for dim used by 'GROUP BY', should it be the front of rowkey?

2020-12-30 Thread Shiao Gabriel
OK, I found the answer: high cardinality dim first. 发件人: Shiao Gabriel 发送时间: 2020年12月31日 2:46 收件人: user@kylin.apache.org 主题: When adjust rowkey order, for dim used by 'GROUP BY', should it be the front of rowkey? Hi, I bought the book "Apache Kylin 权威指南", in

When adjust rowkey order, for dim used by 'GROUP BY', should it be the front of rowkey?

2020-12-30 Thread Shiao Gabriel
Hi, I bought the book "Apache Kylin 权威指南", in the page 56 for adjusting rowkey order rules, it said: 对于不会出现在过滤条件的维度,按照基数高低,优先将低基数维度放在rowkey的后面。(I tried to translate: For the dimenstion which wont be in where condition, based on the cardinality, the dimension which has lower cadinality shoud

?????? confused by multi model and cube in a project

2020-12-28 Thread ????
Thank you~ Maybe the best practice is: one project ,one model, one cube. Hope more books written about Kylin will be out. for example : Apache Kylin Cookbook Apache Kylin Best Practice Real world Kylin Kylin Optimization etc... ---- ??:

Re: confused by multi model and cube in a project

2020-12-28 Thread Yaqian Zhang
Hi: "There's only one table under the "DEFAULT” database” is normal,because the data source of two cubes is the same table. 1、"I found the first model and cube missing some demessions, so I create the second model and cube, add some demessions.” is correct. Or you can edit the original model

kylin??????????????

2020-12-27 Thread my is mine
cube??insighthive shell??hive??2.61cube??2.49??cube??

??????kylin 404

2020-12-25 Thread ????????????
thank you 712679031 ---- ??: "user"

Re:回复:kylin 404

2020-12-25 Thread Johnson
hi, Can you leave a WeChat ID,I'll try to help you solve the problem! 在 2020-12-25 16:38:00,"~夜的钢琴曲" <712679...@qq.com> 写道: I tried It's still not working. It's amazing thank you -- 原始邮件 -- 发件人: "user" <1091643...@qq.com>; 发送时间:

??????kylin 404

2020-12-25 Thread ????????????
I triedIt's still not working. It's amazing thank you ---- ??: "user"

??????kylin 404

2020-12-25 Thread ????
found this line in the output: -Dkylin.server.host-address=node01:7070 try: curl http://node01:7070/kylin/login login into node01: curl http://localhost:7070/kylin/login If still 404, it's out of my knowledge, I'm done. good luck bro. ----

??????kylin 404

2020-12-25 Thread ????????????
yesI'm sure Kylin is up ps -ef |grep kylin root 17562 20193 0 16:21 pts/0 00:00:00 grep --color=auto kylin root 24848 1 4 16:01 pts/0 00:00:53 /export/servers/jdk1.8.0_141/bin/java -Dproc_-Xms1024M -XX:OnOutOfMemoryError=kill -9 %p -XX:+UseConcMarkSweepGC

??????kylin 404

2020-12-25 Thread ????
does the kylin daemon really started successfully? ps -ef |grep kylin can this command see the kylin process ---- ??: "user"

??????kylin 404

2020-12-25 Thread ????????????
It's amazing I changed several servers Several versions are like this ---- ??: "user"

??????kylin 404

2020-12-25 Thread ????????????
http://localhost:7070/kylin/login -- -- ??: "user"

??????kylin 404

2020-12-25 Thread ????
what about curl the login url on localhost machine? curl http://localhost:7070/kylin/login ---- ??: "user"

??????kylin 404

2020-12-25 Thread ????????????
kylin.logIs empty kylin.outIn the attachment ---- ??: "user"

??????kylin 404

2020-12-25 Thread ????
under logs directory: less kylin.log less kylin.out any messages? ---- ??: "user"

??????kylin 404

2020-12-25 Thread ????????????
And the most amazing thing is that His log is empty and out doesn't report an error But it works ---- ??: "user"

??????kylin 404

2020-12-24 Thread ????
any logs? hadoop stack is a huge montain, has a lot of components with chaos versions. I'm used HDP3.0 and Kylin3.1.1 on three node installation, but finally failed make kylin to build kafka cube, I'm stucked on a hadoop's jetty classNotFound errorI give up it , now I'm using docker to

kylin 404

2020-12-24 Thread ????????????
I followed the normal steps to install KylinBut page 404 The log did not report an error I've tried it on multiple servers and it's 404 what's going on It can start normallytomcat 404

public static class Record2_0 implements java.io.Serializable*

2020-12-23 Thread 刘建新
Dear all, Query the sql in kylin, it shows error. Do you have any ideas ``` Error while compiling generated Java code: public static class Record5_0 implements java.io.Serializable { public long f0; public boolean f1; public long f2; public boolean f3; public long f4; public Record5_0() {}

public static class Record2_0 implements java.io.Serializable*

2020-12-21 Thread shylinzhang
Dear all, Query the sql in kylin, it shows error. Do you have any ideas? ``` Error while compiling generated Java code: public static class Record2_0 implements java.io.Serializable { public long f0; public boolean f1; public Record2_0() {} public boolean equals(Object o) { if (this ==

?????? kafka table cube build, first step error

2020-12-21 Thread ????
[root@hadoop3 hdp]# ls 3.0.1.0-187 current share there doesn't have apps in hdp folder. I'm using the Ambari to install HDP. where to find themapreduce.tar.gz file? ---- ??:

?????? kafka table cube build, first step error

2020-12-21 Thread ????
thanks very much hdp dirs with apps.wheremapreduce.tar.gz is it ? or you zip it yourself? like this: tar zcf mapreduce.tar.gz /usr/hdp/3.0.1.0-187/hadoop-mapreduce ## remove kafka-clients-0.8.2.1.jar in mapreduce.tar.gz(HDFS) hadoop fs -copyToLocal

Re: kafka table cube build, first step error

2020-12-21 Thread Xiaoxiang Yu
Please check https://issues.apache.org/jira/browse/KYLIN-3970 . -- Best wishes to you ! From :Xiaoxiang Yu 在 2020-12-21 20:02:53,"刘波" <1091643...@qq.com> 写道: Env kylin apache-kylin-3.1.1-bin-hadoop3 | HDFS | 3.1.1 | | YARN | 3.1.1 | | MapReduce2 | 3.1.1 | | Hive | 3.1.0 | | HBase | 2.0.0 |

??????kafka table cube build, first step error

2020-12-21 Thread ????
according to the kylin download site: Binary for Hadoop 3 download: for Hadoop 3.1 + HBase 2.0 (includes Hortonworks HDP 3.0) -apache-kylin-3.1.1-bin-hadoop3.tar.gz[asc] [sha256] I'm use the right verison HDP for kylin. why this jar coflict error still occurs?

??????kafka table cube build, first step error

2020-12-21 Thread ????
Env kylinapache-kylin-3.1.1-bin-hadoop3 HDFS3.1.1 YARN3.1.1 MapReduce23.1.1 Hive3.1.0 HBase2.0.0 ZooKeeper3.4.6 HDP3.0.1.0 ---- ??:

??????????: kylin sample cube build error

2020-12-21 Thread ????
---- ??: "user"

kafka table cube build, first step error

2020-12-21 Thread ????
kafka stream table as input. where to find detailed error message? thanks very much... org.apache.kylin.engine.mr.exception.MapReduceException: no counters for job job_1608275027445_0017Job Diagnostics:Task failed task_1608275027445_0017_m_00 Job failed as tasks failed.

Re: kylin sample cube build error

2020-12-20 Thread Yaqian Zhang
Hi; It looks like there's something wrong with your MapReduce configuration, you can check it. > 在 2020年12月21日,09:29,chengya...@idengyun.com 写道: > > Error: Error while processing statement: Cannot modify mapreduce.job.name at > runtime. It is not in list of params that are allowed to be

????: kylin sample cube build error

2020-12-20 Thread chengya...@idengyun.com
Error: Error while processing statement: Cannot modify mapreduce.job.name at runtime. It is not in list of params that are allowed to be modified at runtime (state=42000,code=1) ?? 2020-12-18 11:45 user ?? kylin sample cube build error java.io.IOException: OS

??????kylin sample cube build error

2020-12-18 Thread ????
Ambari--Hive--CONFIGS--ADVANCED--Custom hive-site http://www.slf4j.org/codes.html#multiple_bindings for an explanation. SLF4J: Actual binding is of type [org.apache.logging.slf4j.Log4jLoggerFactory] Connecting to

kylin sample cube build error

2020-12-17 Thread ????
java.io.IOException: OS command error exit with return code: 1, error message: SLF4J: Class path contains multiple SLF4J bindings. SLF4J: Found binding in [jar:file:/usr/hdp/3.0.1.0-187/hive/lib/log4j-slf4j-impl-2.10.0.jar!/org/slf4j/impl/StaticLoggerBinder.class] SLF4J: Found binding in

public static class Record2_0 implements java.io.Serializable*

2020-12-17 Thread shylinzhang
Dear all, Query the sql in kylin, it shows error. Do you have any ideas? ``` Error while compiling generated Java code: public static class Record2_0 implements java.io.Serializable { public long f0; public boolean f1; public Record2_0() {} public boolean equals(Object o) { if (this ==

Re:

2020-12-17 Thread ShaoFeng Shi
Please send an email to user-unsubscr...@kylin.apache.org, and then it will send an email to you for confirmation, then reply that to confirm... Best regards, Shaofeng Shi 史少锋 Apache Kylin PMC Email: shaofeng...@apache.org Apache Kylin FAQ: https://kylin.apache.org/docs/gettingstarted/faq.html

public static class Record2_0 implements java.io.Serializable*

2020-12-16 Thread shylinzhang
Dear all, Query the sql in kylin, it shows error. Do you have any ideas ``` Error while compiling generated Java code: public static class Record2_0 implements java.io.Serializable { public long f0; public boolean f1; public Record2_0() {} public boolean equals(Object o) { if (this == o)

Re: kylin cannt start

2020-12-06 Thread Yaqian Zhang
Hi: You can try this: Download guava 28.jar from https://repo1.maven.org/maven2/com/google/guava/guava/28.0-jre/guava-28.0-jre.jar and put the package into $KYLIN_HOME/tool/ and $KYLIN_HOME/tomcat/lib/, then

kylin cannt start

2020-12-03 Thread ????
ambari 2.7.4 hdp3.1.4 kylinapache-kylin-3.1.1-bin-hadoop3 [root@hadoop5 ~]# kylin.sh start Retrieving hadoop conf dir... ...[PASS] KYLIN_HOME is set to /root/apache-kylin-3.1.1-bin-hadoop3 Checking HBase

[no subject]

2020-11-28 Thread ????????
?? :[hidden email]

kylin启动时出现错误

2020-11-28 Thread li_cong521
大家好,有没有小伙伴遇到过这个错误: hbase的集群是master1,master2,slave3,slave4,slave5,在kylin的配置文件中也指定了这几个的7070端口,zookeeper也开起来了,也有hbase的节点,很奇怪。 环境检查没有出现错误 kylin.sh start的错误日志: 2020-11-28 20:28:35,655 INFO [main] zookeeper.ZooKeeper:438 : Initiating client connection,

Re: Apache Kylin - Tableau connectivity with MacOS

2020-11-24 Thread Yaqian Zhang
Hi Priyanshu Kumar: Kylin ODBC driver does not support Mac. I don't think you can use Kyligence ODBC driver to replace it, because Apache kylin and kyligence Enterprise are different. If you want to use Tableau to connect to kylin on Mac, you can use kylin JDBC driver. Kylin 3.0.0 supports

Unsubscribe

2020-11-24 Thread deva namaste
Sent from my iPhone > On Nov 24, 2020, at 8:47 AM, dan young wrote: > > 

Unsubscribe

2020-11-24 Thread dan young

Re: Start Kylin Error

2020-11-24 Thread Yaqian Zhang
Hi: It looks like your HBase server failed. You can check the health of your Hadoop cluster. > 在 2020年11月22日,16:25,lxk2...@163.com 写道: > > Hey guys > Recently, there was an error when I started Kylin. The information is as > follows > > > > > > Have you ever been met this

Re: different meta data store

2020-11-14 Thread lec ssmi
And why kylin stores meta data in two different places at the same time ? lec ssmi 于2020年11月15日周日 下午1:29写道: > Hi: > Recently, in the process of transforming kylin, I found a problem. > My kylin's version is 2.6.2, the building engine used is spark . When > building the dimensional

different meta data store

2020-11-14 Thread lec ssmi
Hi: Recently, in the process of transforming kylin, I found a problem. My kylin's version is 2.6.2, the building engine used is spark . When building the dimensional dictionary, kylin server will start a shell process separately to start the spark program. After spark creates the dictionary

Re: Performance tunning guide for Kylin 4

2020-11-05 Thread Xiaoxiang Yu
Hello, I am glad to share with you that Zhichao has writen a performance tunning guide for cube building and query of Kylin 4. I wonder it is not ao late for those users who is trying to learn more about Kylin 4.0.0-alpha (first early-access version of Kylin 4), feel free to comment if you

Re: Data refresh

2020-11-05 Thread ShaoFeng Shi
Hi Chaymaa, you're correct, I think the resource is limited, you need to add more resources to improve the build performance. Best regards, Shaofeng Shi 史少锋 Apache Kylin PMC Email: shaofeng...@apache.org Apache Kylin FAQ: https://kylin.apache.org/docs/gettingstarted/faq.html Join Kylin user

Re: stay at 20 Step Name: Load HFile to HBase Table

2020-10-26 Thread ShaoFeng Shi
That's good. Thanks for the update. Best regards, Shaofeng Shi 史少锋 Apache Kylin PMC Email: shaofeng...@apache.org Apache Kylin FAQ: https://kylin.apache.org/docs/gettingstarted/faq.html Join Kylin user mail group: user-subscr...@kylin.apache.org Join Kylin dev mail group:

Re:stay at 20 Step Name: Load HFile to HBase Table

2020-10-26 Thread li_cong521
hello the error has been solved. function: set the hbase-site.xml hbase.rootdir=hdfs://master2/hbase thanks~ At 2020-10-26 14:45:18, "li_cong521" wrote: hello: anbody miss this error? the cube build stay at 20 step, the value i set in kylin.properties

stay at 20 Step Name: Load HFile to HBase Table

2020-10-26 Thread li_cong521
hello: anbody miss this error? the cube build stay at 20 step, the value i set in kylin.properties kylin.storage.hbase.cluster-fs=hdfs://mycluster/hbase the hadoop values fs.defaultFS is hdfs://master2 the log follows: org.apache.kylin.engine.mr.exception.HadoopShellException:

Re:Kylin-Spark Cube Build Issue

2020-10-22 Thread Xiaoxiang Yu
Hi, did you set/export SPARK_HOME in your system variable? -- Best wishes to you ! From :Xiaoxiang Yu At 2020-10-22 20:28:01, "Kumar, Priyanshu" wrote: >Hi Team, > >I have installed and setup Kylin on my HDP 2.6 cluster as per the Kylin >documentation. I am able to build the cubes using

[SECURITY][CVE-2020-13937] Unauthenticated Configuration Disclosure

2020-10-19 Thread Xiaoxiang Yu
Versions Affected: Kylin 2.0.0, 2.1.0, 2.2.0, 2.3.0, 2.3.1, 2.3.2, 2.4.0, 2.4.1, 2.5.0, 2.5.1, 2.5.2, 2.6.0, 2.6.1, 2.6.2, 2.6.3, 2.6.4, 2.6.5, 2.6.6, 3.0.0-alpha, 3.0.0-alpha2, 3.0.0-beta, 3.0.0, 3.0.1, 3.0.2, 3.1.0, 4.0.0-alpha. Description: Kylin has one restful api which exposed

Re: [Announce] Apache Kylin 3.1.1 released

2020-10-18 Thread ShaoFeng Shi
This is great! Thank you Xiaoxiang! Best regards, Shaofeng Shi 史少锋 Apache Kylin PMC Email: shaofeng...@apache.org Apache Kylin FAQ: https://kylin.apache.org/docs/gettingstarted/faq.html Join Kylin user mail group: user-subscr...@kylin.apache.org Join Kylin dev mail group:

[Announce] Apache Kylin 3.1.1 released

2020-10-18 Thread Xiaoxiang Yu
The Apache Kylin team is pleased to announce the immediate availability of the 3.1.1 release. This is a bugfix release after 3.1.0, with 21 bug fixes and 37 enhancements. All of the changes in this release can be found in: https://kylin.apache.org/docs/release_notes.html You can

Re: stay at second step,thanks

2020-10-12 Thread Yaqian Zhang
Hi: Is useful to discard the job and resubmit the build job? > 在 2020年10月12日,20:56,li_cong521 写道: > > hello,if any body miss this error,the table exists in the hive,but the error > stay at the second step say this table not exists. > I have seen a error which has puted by any other,but not

stay at second step,thanks

2020-10-12 Thread li_cong521
hello,if any body miss this error,the table exists in the hive,but the error stay at the second step say this table not exists. I have seen a error which has puted by any other,but not given the solved way. thanks. the error folllow:

kylin2.4.1 RowKeyWritable is not class ImmutableBytesWritable

2020-10-12 Thread nice
hi allI encountered a problem when the step of convert cuboid data to HFile. the error message is wrong key class: org.apache.kylin.storage.hbase.steps.rowkeywritable is not class org.apache.hadoop.hbase.io.ImmutableBytesWritable kylin2.4.1 hbase 1.2.0 hadoop2.6.0 how to fix this?

Re: 【求助!】sql报错问题

2020-10-10 Thread Yaqian Zhang
I can’t reproduce this error in my environment, Can you reproduce this in kylin_sales and provide the reproduce step? This can help us find the root cause. > 在 2020年9月29日,12:08,guojial...@smartbi.com.cn 写道: > > <报错信息.txt>

回复: 回复: 【求助!】sql报错问题

2020-10-09 Thread guojial...@smartbi.com.cn
您好: 请问您有什么发现吗? Jaylin 发件人: guojial...@smartbi.com.cn 发送时间: 2020-10-09 14:45 收件人: Yaqian Zhang; user@kylin.apache.org 抄送: 赵尉余 主题: 回复: Re: 【求助!】sql报错问题 hello, kylin version:2.6.5 hadoop version: Yes, it just encountered when executing through JDBC. Jaylin 发件人: Yaqian

Re: Kylin and Yarn configuration

2020-10-09 Thread Omid Vahdaty
? On Thu, Oct 8, 2020 at 10:04 PM eran grin wrote: > Hi, > I run dbgen tool on a scale of 100. > I saw know that whatever I changed in yarn configuration ( jvm ) It > always work at a max of 6G RAM. > What I need to configure in order to build this amount of data in Kylin in > time that makes

回复: Re: 【求助!】sql报错问题

2020-10-09 Thread guojial...@smartbi.com.cn
hello, kylin version:2.6.5 hadoop version: Yes, it just encountered when executing through JDBC. Jaylin 发件人: Yaqian Zhang 发送时间: 2020-10-09 14:01 收件人: user; guojialing 主题: Re: 【求助!】sql报错问题 Hi: It's a strange error that I haven't seen before, can you provide your Hadoop

Re: Kylin and Yarn configuration

2020-10-09 Thread Yaqian Zhang
Hi: Maybe you should config yarn memory in kylin.properties and you can refer to doc http://kylin.apache.org/docs/install/configuration.html . > 在 2020年10月9日,03:03,eran grin 写道: > > Hi, > I run dbgen tool on a scale of 100. > I saw

Re: 【求助!】sql报错问题

2020-10-09 Thread Yaqian Zhang
Hi: It's a strange error that I haven't seen before, can you provide your Hadoop version and Kylin version to reproduce this error? And you mentioned using JDBC, is this error only encountered when executing through JDBC? > 在 2020年10月9日,10:07,guojial...@smartbi.com.cn 写道: > > 请问有没有哪位知道为什么呢?

回复: 【求助!】sql报错问题

2020-10-08 Thread guojial...@smartbi.com.cn
请问有没有哪位知道为什么呢? 发件人: guojial...@smartbi.com.cn 发送时间: 2020-09-29 12:08 收件人: user@kylin.apache.org 主题: 【求助!】sql报错问题 各位大大好, 我有一个让我非常困惑的问题 像下面这个sql,执行的时候会报错。 select T59780.F1126 as F59781, '_Insight_Total' as F59782, case when (

Kylin and Yarn configuration

2020-10-08 Thread eran grin
Hi, I run dbgen tool on a scale of 100. I saw know that whatever I changed in yarn configuration ( jvm ) It always work at a max of 6G RAM. What I need to configure in order to build this amount of data in Kylin in time that makes sense. Now it's running for a few days... Thanks, Eran

Re:来自li_cong521的邮件

2020-10-07 Thread Xiaoxiang Yu
Hi, Are you using Kylin4.0.0-alpha? As far as I know, CardinalityExecutable is removed in Kylin4. If so, this error message can be ignored and I guess it will be removed in next release. -- Best wishes to you ! From :Xiaoxiang Yu At 2020-10-05 16:14:34, "li_cong521"

来自li_cong521的邮件

2020-10-05 Thread li_cong521
how can do to handle this error? thanks. 2020-10-05 16:09:53,909 ERROR [http-bio-7070-exec-1] execution.ExecutableManager:622 : Unknown executable type 'org.apache.kylin.job.execution.CardinalityExecutable', using BrokenExecutable 2020-10-05 16:09:53,910 ERROR [http-bio-7070-exec-1]

who can help me ,thanks

2020-10-04 Thread li_cong521
您好,我最近在创建cube的时候遇到了一个问题,解决了好几天一直没有进展。非常感谢谁来帮助我一下,项目一直卡在这里。 问题描述:我的三张hive里面的表格中的数据量非常大,有一个能达到45万行,在构建cube的时候会一直卡到第一步,本来以为会因为数据量大而时间长,结果1520分钟过去进度还是0.我又重新换成小数据试验了一下,结果原来可以构建成功的小数据量的cube也失败了,是同样的问题。 日志: 一开始是这样: 2020-09-30 08:40:16,787 WARN [FetcherRunner 1998130220-53] threadpool.FetcherRunner:56 :

【求助!】sql报错问题

2020-09-28 Thread guojial...@smartbi.com.cn
各位大大好, 我有一个让我非常困惑的问题 像下面这个sql,执行的时候会报错。 select T59780.F1126 as F59781, '_Insight_Total' as F59782, case when ( sum(T59780.F1152) - sum(T59780.F1163) ) = 0 then 0 else ( sum(case when T59780.F1169='1' then

Unsubscribe

2020-09-20 Thread dan young

Re: RAM alloaction

2020-09-20 Thread Omid Vahdaty
Hi, Yes, I tried to overwrite the following: kylin.job.mr.config.override.mapreduce.map.java.opts -Xmx256000m kylin.job.mr.config.override.mapreduce.map.memory.mb 32 kylin.job.mr.config.override.mapreduce.reduce.memory.mb 64

Re: kylin-3.1.0 webUI 报404错误,求助各位

2020-09-17 Thread Yaqian Zhang
Hi: Hadoop3.3 and hive3 is not supported. Maybe you can use Hadoop3.1+ and hive2.x to try again. > 在 2020年9月15日,17:35,杨建伟 <310209...@qq.com> 写道: > > > Hello,各位, 想问一下, 我安装的是 kylin-3.1.0 版本, 进程正常起来, 监听端口OK, 但是 访问webui 页面, 出现404 > 错误, 查看Kylin 和 tomcat 日志,并没有报错信息。 > > kylin版本如下: > for Hadoop

"union all" will query cube many times?

2020-09-16 Thread star
I converted column to row through union all. It took only 0.3 seconds without union all and 24 seconds with union all. From the explain, It seems that "union all" will query cube many times. "without union all": User: ADMIN Success: true Duration: 0.303 Project: cloud_brain Realization Names:

Re: Docker image for Apache Kylin 4.0 Alpha

2020-09-15 Thread Sabat, Susant
Great!. I will try this. On 9/15/20, 5:13 AM, "Xiucheng Gong" wrote: CAUTION: This email originated from outside of the organization. Do not click links or open attachments unless you can confirm the sender and know the content is safe. awsome ~ > 在 2020年9月15日,17:39,Zhichao

Re: Docker image for Apache Kylin 4.0 Alpha

2020-09-15 Thread Luke Han
awesome Best Regards! - Luke Han On Tue, Sep 15, 2020 at 7:11 PM Xiucheng Gong wrote: > awsome ~ > > > 在 2020年9月15日,17:39,Zhichao Zhang <441586...@qq.com> 写道: > > > > Hi all: > >Apache Kylin 4.0 Alpha has released recently, and today Apache Kylin > community

Re: Docker image for Apache Kylin 4.0 Alpha

2020-09-15 Thread Xiucheng Gong
awsome ~ > 在 2020年9月15日,17:39,Zhichao Zhang <441586...@qq.com> 写道: > > Hi all: >Apache Kylin 4.0 Alpha has released recently, and today Apache Kylin > community published docker image for Apache Kylin 4.0 Alpha to docker hub, > welcome to use this docker image to have a try on Apache

Docker image for Apache Kylin 4.0 Alpha

2020-09-15 Thread Zhichao Zhang
Hi all: Apache Kylin 4.0 Alpha has released recently, and today Apache Kylin community published docker image for Apache Kylin 4.0 Alpha to docker hub, welcome to use this docker image to have a try on Apache Kylin 4.0, use below command to run this docker image: docker run -d \ -m 8G \

Re: [Announce] Apache Kylin 4.0.0-alpha released

2020-09-14 Thread JiaTao Tao
Congratulations! I've been waiting for this day for a long time. Truly thanks for the community's hard work. Regards! Aron Tao George Ni 于2020年9月13日周日 下午7:57写道: The Apache Kylin team is pleased to announce the immediate availability of the 4.0.0-alpha release. This is a major release after

[Announce] Apache Kylin 4.0.0-alpha released

2020-09-13 Thread George Ni
The Apache Kylin team is pleased to announce the immediate availability of the 4.0.0-alpha release. This is a major release after 3.1.0, with 35 new features and 22 bug fixes. All of the changes in this release can be found in: https://kylin.apache.org/docs/release_notes.html You can download

????????????,????????, ??????????,????????????,????snapshot table, duplicate key

2020-09-10 Thread nice
,, ??,,snapshot table duplicate key kylin??? lookup table??,??where,

Re: kylin 2.4 hbase 1.2 Coprocessor UnknownHostException

2020-09-10 Thread Lucien
hosts映射的问题,根据hdfs01-shyp-cx找不到对应ip nice 于2020年9月10日周四 下午3:05写道: > hbase独立集群的方案. 官方文档 > http://kylin.apache.org/blog/2016/06/10/standalone-hbase-cluster/ > 参考官方修改了 > 1. kylin.properties中的 kylin.hbase.cluster.fs > 2. 与NN-HA有关的配置写入kylin_job_conf.xml > > 但是构建cube有时ok, 有时不可以. > 不可以的时候,

kylin 2.4 hbase 1.2 Coprocessor UnknownHostException

2020-09-10 Thread nice
hbase??. http://kylin.apache.org/blog/2016/06/10/standalone-hbase-cluster/ ?? 1. kylin.propertieskylin.hbase.cluster.fs 2.??NN-HA??kylin_job_conf.xml cubeok, ??. , createHTable??,

?????? kylin 1.6 Not sorted! last error when sending select query on ui

2020-09-10 Thread nice
i have set the column to 'dict' and save the cube config. but when i open the cube config again, it turn back to 'time' encoding again. it seems to be that kylin would auto change the column encoding type to 'time' , even i manually changed it to 'dict'. the column name is report_date

Re:关于hadoop3文件访问的bug

2020-09-08 Thread Xiaoxiang Yu
Hi, As far as I know, Kylin did not support Hive3 ACID table offically. Maybe you turn off ACID feature as a workaround. (I guess you are using Hive3) -- Best wishes to you ! From :Xiaoxiang Yu 在 2020-09-08 15:33:38,"wuguo1501" 写道: 在使用kylin3访问hive3的表时,一直会报 duplicate

<    1   2   3   4   5   6   7   8   9   10   >