from:"Li Feng"

Re: 回复：查询无结果

2019-02-07 Thread Li Feng

Hi 立伟，

根据之前的讨论，这个问题应该出在源数据前后有空格，软件层面并没有问题。
有两个解决方法：
1， 在源数据进Kylin前取一下trim，去除空格；比如在hive上建一张视图进行中间处理，把视图作为新的事实表。
2， Tableau层面进行处理，新增一个可计算字段为trim(EXCHANGE_NAME)

BR,
Lee


在 19/2/8 上午11:49，“廉立伟” 写入:

我这里不能这样处理，因为tableau里没有trim还有就是你们试试   所有的字符串直接写＝可以吗   是不是都需要处理  这是你们的bug吗

获取 Outlook for iOS<https://aka.ms/o0ukef>


    收件人: Li Feng 
发送时间: 星期五, 二月 8, 2019 11:36
收件人: dev@kylin.apache.org
主题: Re: 回复： 查询无结果

Hi 立伟，

前后有空格的数据后来你处理过了么？
前面那个查询同样改成：
where trim(HUOBI_YUNYING_DW_KYLIN_USER_INDEX_DAILY.EXCHANGE_NAME) = 'b11' 
试一下
BR，
Lee

在 19/2/6 下午12:28，“廉立伟” 写入:

trim(HUOBI_YUNYING_DW_KYLIN_USER_INDEX_DAILY.EXCHANGE_NAME)

Re: 回复：查询无结果

2019-02-07 Thread Li Feng

Hi 立伟，

前后有空格的数据后来你处理过了么？
前面那个查询同样改成：
where trim(HUOBI_YUNYING_DW_KYLIN_USER_INDEX_DAILY.EXCHANGE_NAME) = 'b11' 试一下
BR，
Lee

在 19/2/6 下午12:28，“廉立伟” 写入:

 trim(HUOBI_YUNYING_DW_KYLIN_USER_INDEX_DAILY.EXCHANGE_NAME)

Re: 查询无结果

2019-01-29 Thread Li Feng

Hi Liwei
Try 
select
count(*),EXCHANGE_NAME
from HUOBI_GLOBAL.HUOBI_YUNYING_DW_KYLIN_USER_INDEX_DAILY
group by EXCHANGE_NAME
order by EXCHANGE_NAME
and check whether there exists 'b11' value.
BR,
Lee
在 19/1/30 下午1:08，“廉立伟” 写入:

怎么没结果  你们解决下呀

获取 Outlook for iOS


收件人: 廉立伟 
发送时间: 星期三, 一月 30, 2019 10:23
收件人: dev@kylin.apache.org
主题: Re: 查询无结果

这样查询结果为0，但是我的数据中确实有EXCHANGE_NAME = 'b11'，怎么查不出来呢
select
count(*)
from HUOBI_GLOBAL.HUOBI_YUNYING_DW_KYLIN_USER_INDEX_DAILY
where HUOBI_YUNYING_DW_KYLIN_USER_INDEX_DAILY.EXCHANGE_NAME = 'b11'


在 2019/1/30 上午10:21，“JiaTao Tao” 写入:

select
count(*)
from HUOBI_GLOBAL.HUOBI_YUNYING_DW_KYLIN_USER_INDEX_DAILY
where HUOBI_YUNYING_DW_KYLIN_USER_INDEX_DAILY.EXCHANGE_NAME = 'b11'

Re: 回复：回复： about kylin

2017-09-29 Thread Li Feng

Hi Enjun，

Kylin 2.1 has updated Spark Engine to 
2.1：https://issues.apache.org/jira/browse/KYLIN-2633
Kylin 2.0 is using Spark 1.6.3

BR,
Lee.

在 17/9/29 17:26，“enjun.zhu”<727865...@qq.com> 写入:

HI，
kylin 2.1 can together with spark1.6


thanks，，




-- 原始邮件 --
发件人: "enjun.zhu";<727865...@qq.com>;
发送时间: 2017年9月29日(星期五) 下午3:44
收件人: "dev"<dev@kylin.apache.org>;

主题: 回复： 回复： about kylin



Hi Lee，
yeah，the error is


Caused by: java.lang.ClassNotFoundException: 
org.apache.hive.hcatalog.mapreduce.HCatInputFormat
at 
org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1858)
at 
org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1701)



I've solved the problem，first vim kylin.sh  and turn to


export 
HBASE_CLASSPATH_PREFIX=${KYLIN_HOME}/conf:${KYLIN_HOME}/lib/*:${KYLIN_HOME}/tool/*:${KYLIN_HOME}/ext/*:${HBASE_CLASSPATH_PREFIX}


then spell   :${hive_dependency}
but i don't know why it is need do thatmy kylin version is 
2.0.0，，
thanks your help  …。。


------ 原始邮件 --
发件人: "Li Feng";<li.f...@kyligence.io>;
发送时间: 2017年9月29日(星期五) 下午3:24
收件人: "dev@kylin.apache.org"<dev@kylin.apache.org>;

主题: Re: 回复： about kylin



Hi Enjun，

Thank you for your respect.
This mail list can’t  show screenshots. Can you paste the error logs in 
$KYLIN_HOME/logs/kylin.log where you click the sync button?

BR.
Lee.

发件人: "enjun.zhu" <727865...@qq.com>
答复: "dev@kylin.apache.org" <dev@kylin.apache.org>
日期: 2017年9月29日 星期五 15:06
至: dev <dev@kylin.apache.org>
主题: 回复： about kylin

Hi，
I know it syncstables from Hive，but when i input hive table name，then 
click button of Sync,window will tell me error which mean of 'Fail to take 
action'...


   thanks, i real support Kylin, it is one of the first chinese project in 
apache,I want use it in our company..

  by enjun
[cid:2B03FB16@C687035C.04F1CD59]

-- 原始邮件 --
发件人: "Li Feng";<li.f...@kyligence.io>;
发送时间: 2017年9月29日(星期五) 下午2:40
收件人: 
"dev@kylin.apache.org"<dev@kylin.apache.org>;"dev"<d...@kylin.incubator.apache.org>;
主题: Re: about kylin

HI Enjun，

Kylin can’t ‘create’ Hive table,it syncstables from Hive.
Pls refer to this link: http://kylin.apache.org/docs21/tutorial/web.html 
for how to sync tables.

BR,
Lee.




发件人: "enjun.zhu" <727865...@qq.com>
答复: "dev@kylin.apache.org" <dev@kylin.apache.org>
日期: 2017年9月29日 星期五 14:24
至: dev <d...@kylin.incubator.apache.org>
主题: about kylin


我有问题，首先我创建hive表，但是当我登录kylin并创建项目时，我无法看到我在哪里hive表创建... ...



[cid:155E849A@525B740F.1DE7CD59]


[cid:B79A1497@C2617E36.1DE7CD59]

Re: 回复： about kylin

2017-09-29 Thread Li Feng

Hi Enjun，

Thank you for your respect.
This mail list can’t  show screenshots. Can you paste the error logs in 
$KYLIN_HOME/logs/kylin.log where you click the sync button?

BR.
Lee.

发件人: "enjun.zhu" <727865...@qq.com>
答复: "dev@kylin.apache.org" <dev@kylin.apache.org>
日期: 2017年9月29日 星期五 15:06
至: dev <dev@kylin.apache.org>
主题: 回复： about kylin

Hi，
I know it syncstables from Hive，but when i input hive table name，then click 
button of Sync,window will tell me error which mean of 'Fail to take 
action'...


   thanks, i real support Kylin, it is one of the first chinese project in 
apache,I want use it in our company..

  by enjun
[cid:2B03FB16@C687035C.04F1CD59]

------ 原始邮件 --
发件人: "Li Feng";<li.f...@kyligence.io>;
发送时间: 2017年9月29日(星期五) 下午2:40
收件人: 
"dev@kylin.apache.org"<dev@kylin.apache.org>;"dev"<d...@kylin.incubator.apache.org>;
主题: Re: about kylin

HI Enjun，

Kylin can’t ‘create’ Hive table,it syncstables from Hive.
Pls refer to this link: http://kylin.apache.org/docs21/tutorial/web.html for 
how to sync tables.

BR,
Lee.




发件人: "enjun.zhu" <727865...@qq.com>
答复: "dev@kylin.apache.org" <dev@kylin.apache.org>
日期: 2017年9月29日 星期五 14:24
至: dev <d...@kylin.incubator.apache.org>
主题: about kylin


我有问题，首先我创建hive表，但是当我登录kylin并创建项目时，我无法看到我在哪里hive表创建... ...



[cid:155E849A@525B740F.1DE7CD59]


[cid:B79A1497@C2617E36.1DE7CD59]

Re: about kylin

2017-09-29 Thread Li Feng

HI Enjun，

Kylin can’t ‘create’ Hive table,it syncstables from Hive.
Pls refer to this link: http://kylin.apache.org/docs21/tutorial/web.html for 
how to sync tables.

BR,
Lee.




发件人: "enjun.zhu" <727865...@qq.com>
答复: "dev@kylin.apache.org" 
日期: 2017年9月29日 星期五 14:24
至: dev 
主题: about kylin


我有问题，首先我创建hive表，但是当我登录kylin并创建项目时，我无法看到我在哪里hive表创建... ...



[cid:155E849A@525B740F.1DE7CD59]


[cid:B79A1497@C2617E36.1DE7CD59]

Re: build cube error

2017-07-19 Thread Li Feng

Hi,

This may due to metadata disruption ,try to purge the cube and build again.

BR,
Lee.

发件人: "apache_...@163.com" 
答复: "dev@kylin.apache.org" 
日期: 2017年7月19日 星期三 21:24
至: dev 
主题: build cube error

Hi,

  After i created model(m01) and cube(c001 base m01),when i build the c001 
cube, get a error, "cube c001 doesn't contain and ready segment",What's the 
reason, please?




[cid:_Foxmail.1@f8e61157-9c33-38bc-bac6-a28719c81571]




apache_...@163.com

Error when Redistribute Flat Hive Table in Kylin 2.0

2017-05-22 Thread Li Feng

Hi guys，

I installed kylin2.0 on a CDH  cluster which also have other kylin instances.
When I start to build sample cube，I find such error in logs in ‘Redistribute 
Flat Hive Table’step. Have you ever met such errors?

Caused by: ERROR XJ040: Failed to start database 
'/var/lib/hive/metastore/metastore_db' with class loader 
sun.misc.Launcher$AppClassLoader@6aa5c9f1, see the next exception for details.
   at org.apache.derby.iapi.error.StandardException.newException(Unknown 
Source)
   at 
org.apache.derby.impl.jdbc.SQLExceptionFactory.wrapArgsForTransportAcrossDRDA(Unknown
 Source)
   ... 65 more
Caused by: ERROR XSLAN: Database at /var/lib/hive/metastore/metastore_db has an 
incompatible format with the current version of the software.  The database was 
created by or upgraded by version 10.12.
   at org.apache.derby.iapi.error.StandardException.newException(Unknown 
Source)
   at org.apache.derby.iapi.error.StandardException.newException(Unknown 
Source)
   at org.apache.derby.impl.store.raw.log.LogToFile.readControlFile(Unknown 
Source)
   at org.apache.derby.impl.store.raw.log.LogToFile.boot(Unknown Source)
   at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown 
Source)
   at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown 
Source)
   at 
org.apache.derby.impl.services.monitor.BaseMonitor.startModule(Unknown Source)
   at 
org.apache.derby.impl.services.monitor.FileMonitor.startModule(Unknown Source)
   at 
org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Unknown Source)
   at 
org.apache.derby.impl.store.raw.data.BaseDataFileFactory.bootLogFactory(Unknown 
Source)
   at 
org.apache.derby.impl.store.raw.data.BaseDataFileFactory.setRawStoreFactory(Unknown
 Source)
   at org.apache.derby.impl.store.raw.RawStore.boot(Unknown Source)
   at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown 
Source)
   at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown 
Source)
   at 
org.apache.derby.impl.services.monitor.BaseMonitor.startModule(Unknown Source)
   at 
org.apache.derby.impl.services.monitor.FileMonitor.startModule(Unknown Source)
   at 
org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Unknown Source)
   at org.apache.derby.impl.store.access.RAMAccessManager.boot(Unknown 
Source)
   at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown 
Source)
   at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown 
Source)
   at 
org.apache.derby.impl.services.monitor.BaseMonitor.startModule(Unknown Source)
   at 
org.apache.derby.impl.services.monitor.FileMonitor.startModule(Unknown Source)
   at 
org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Unknown Source)
   at org.apache.derby.impl.db.BasicDatabase.bootStore(Unknown Source)
   at org.apache.derby.impl.db.BasicDatabase.boot(Unknown Source)
   at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown 
Source)
   at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown 
Source)
   at 
org.apache.derby.impl.services.monitor.BaseMonitor.bootService(Unknown Source)
   at 
org.apache.derby.impl.services.monitor.BaseMonitor.startProviderService(Unknown 
Source)
   at 
org.apache.derby.impl.services.monitor.BaseMonitor.findProviderAndStartService(Unknown
 Source)
   at 
org.apache.derby.impl.services.monitor.BaseMonitor.startPersistentService(Unknown
 Source)
   at 
org.apache.derby.iapi.services.monitor.Monitor.startPersistentService(Unknown 
Source)
   ... 62 more
BR,
Lee.


[cid:image001.jpg@01D2D3B6.CEEE0660]
上海跬智信息技术有限公司
http://kyligence.io

Re: How do I deploy kylin when I have a Hadoop environment！

2017-05-03 Thread Li Feng

Hi John,

Pls refer to this install guide: 
http://kylin.apache.org/cn/docs20/install/index.html

BR,
Lee.

在 17/5/4 12:48，“john-126” 写入:

Dear Dev：

   How do I deploy kylin when I have a Hadoop environment！Please give
me a plan and suggestion。

   

   My Hadoop environment：

   hadoop version：2.6.4

   Linux OS：centos 6.8

   JDK：1.8.131

 

--

Best regards！

John.xiong

Re: 回复：查询无结果

Re: 回复：查询无结果

Re: 查询无结果

Re: 回复：回复： about kylin

Re: 回复： about kylin

Re: about kylin

Re: build cube error

Error when Redistribute Flat Hive Table in Kylin 2.0

Re: How do I deploy kylin when I have a Hadoop environment！

9 matches

Site Navigation

Mail list logo

Footer information