[jira] [Created] (KYLIN-2023) import source error

[panzhiwei (JIRA)]

panzhiwei created KYLIN-2023:


 Summary: import source error
 Key: KYLIN-2023
 URL: https://issues.apache.org/jira/browse/KYLIN-2023
 Project: Kylin
  Issue Type: Bug
  Components: Web 
Reporter: panzhiwei
Assignee: Zhong,Jason






--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

When does a submitted job start execution

[Joel Victor]

I am going through the Kylin code for when a build request is submitted. I
would like to know when the job starts execution i.e when is the execute
method called on the DeafultChainedExecutable returned by the JobBuilder?.
When a cube build request is made a DefaultChaninedExecutable is returned,
serialized and stored in HBase.


Thanks,
Joel

[jira] [Created] (KYLIN-2022) Kylin support change HBASE_HOME at runtime.

[Guohui LI (JIRA)]

Guohui LI created KYLIN-2022:


 Summary: Kylin support change HBASE_HOME at runtime.
 Key: KYLIN-2022
 URL: https://issues.apache.org/jira/browse/KYLIN-2022
 Project: Kylin
  Issue Type: New Feature
Reporter: Guohui LI


In multi-tenancy system. each tenant can create one or more hbase cluster.  
Different user may use different HBASE_HOME when using Kylin. So it's better 
for user to point out HBASE_HOME when operating Cube or query.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Created] (KYLIN-2021) Cognos Issues

[hongbin ma (JIRA)]

hongbin ma created KYLIN-2021:
-

 Summary: Cognos Issues
 Key: KYLIN-2021
 URL: https://issues.apache.org/jira/browse/KYLIN-2021
 Project: Kylin
  Issue Type: Improvement
Reporter: hongbin ma
Assignee: hongbin ma


cognos will generate some queries that kylin does not support yet



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Re: kylin 1.5.4 measure edit page error？

[ShaoFeng Shi]

hi tianshuo，
which binary package are you using, the hbase 0.98, hbase 1.x or CDH version?
Regards，

Shaofeng Shi

shaofeng...@gmail.com

>From Outlook Mobile




On Sun, Sep 18, 2016 at 9:38 AM +0800, "赵天烁"  wrote:
















I just update to 1.5.4 from 1.5.3 last night,bug when I try to add measure to a 
new cube , the following error show up:

page UI mess up too


I do the  update by create a new folder then unpack 1.5.4 into it ,and update 
hbase Coprocessor,that it ,is there anything else that I miss?






赵天烁



Kevin Zhao



zhaotians...@meizu.com



 



珠海市魅族科技有限公司



MEIZU Technology Co.,
 Ltd.



广东省珠海市科技创新海岸魅族科技楼



MEIZU Tech Bldg., Technology
 & Innovation Coast



Zhuhai, 519085, Guangdong,
 China



meizu.com

kylin 1.5.4 measure edit page error？

[赵天烁]

I just update to 1.5.4 from 1.5.3 last night,bug when I try to add measure to a 
new cube , the following error show up:
[cid:_Foxmail.1@a1cca05a-79e7-3d28-68ca-7db4fdf4f629]
page UI mess up too
[cid:_Foxmail.1@39d620ad-33a2-f770-c5fa-295c3d571bd9]
[cid:_Foxmail.1@72aaf3b4-872c-0a19-b459-5ca461518eda]
I do the  update by create a new folder then unpack 1.5.4 into it ,and update 
hbase Coprocessor,that it ,is there anything else that I miss?

赵天烁
Kevin Zhao
zhaotians...@meizu.com

珠海市魅族科技有限公司
MEIZU Technology Co., Ltd.
广东省珠海市科技创新海岸魅族科技楼
MEIZU Tech Bldg., Technology & Innovation Coast
Zhuhai, 519085, Guangdong, China
meizu.com

Re: Faild Query.

[Mars J]

OK ,Kylin version is 1.5.2.1, fact table has 200,000,000 records, my cube
is very simple, a fact table about transaction, a dimension table of
account, and a dimension table of branch. account table's cardinality is
240w records. they left join on a acct_no column.


2016-09-16 23:56 GMT+08:00 Luke Han :

> Hi Mars,
> You are trying to query data without group by, Kylin may not perform
> very well without tuning your cube.
>
> And we can't help you with just "log as below...", please offer more
> detail information about your kylin's version, source data, metadata and so
> on
>
>Thanks.
> Luke
>
>
> Best Regards!
> -
>
> Luke Han
>
> On Fri, Sep 9, 2016 at 5:40 PM, Mars J  wrote:
>
> > hello all,
> > My query sql 'SELECT
> > A.ACCT_NO,F.BRAN_CODE,F.SET_DATE,F.ACCT_NO,F.DC_FLAG,F.TRANS_AMT
> > FROM NY.TRANS_FACT F LEFT JOIN NY.ACCOUNT_DIM A ON F.ACCT_NO=A.ACCT_NO
> > LIMIT 100' to query a cube (size :3.6G ,and fact table has 200,000,000),
> > the query is failed.
> >
> > kylin log is as follow :
> >
> > Using project: TRANS_NO_DATE
> > 2016-09-09 17:32:15,705 INFO  [http-bio-7070-exec-7]
> > controller.QueryController:175 : The original query:  SELECT
> > A.ACCT_NO,F.BRAN_CODE,F.SET_DATE,F.ACCT_NO,F.DC_FLAG,F.TRANS_AMT
> > FROM NY.TRANS_FACT F LEFT JOIN NY.ACCOUNT_DIM A ON F.ACCT_NO=A.ACCT_NO
> > LIMIT 100
> > 2016-09-09 17:32:15,745 INFO  [http-bio-7070-exec-7]
> routing.QueryRouter:48
> > : The project manager's reference is
> > org.apache.kylin.metadata.project.ProjectManager@1aa81aff
> > 2016-09-09 17:32:15,745 INFO  [http-bio-7070-exec-7]
> routing.QueryRouter:60
> > : Find candidates by table NY.TRANS_FACT and project=TRANS_NO_DATE :
> > org.apache.kylin.query.routing.Candidate@62e0ac94
> > 2016-09-09 17:32:15,745 INFO  [http-bio-7070-exec-7]
> routing.QueryRouter:49
> > : Applying rule: class
> > org.apache.kylin.query.routing.rules.RemoveUncapableRealizationsRule,
> > realizations before: [TND1(CUBE)], realizations after: [TND1(CUBE)]
> > 2016-09-09 17:32:15,745 INFO  [http-bio-7070-exec-7]
> routing.QueryRouter:49
> > : Applying rule: class
> > org.apache.kylin.query.routing.rules.RealizationSortRule, realizations
> > before: [TND1(CUBE)], realizations after: [TND1(CUBE)]
> > 2016-09-09 17:32:15,746 INFO  [http-bio-7070-exec-7]
> routing.QueryRouter:72
> > : The realizations remaining: [TND1(CUBE)] And the final chosen one is
> the
> > first one
> > 2016-09-09 17:32:15,756 DEBUG [http-bio-7070-exec-7]
> > enumerator.OLAPEnumerator:107 : query storage...
> > 2016-09-09 17:32:15,756 INFO  [http-bio-7070-exec-7]
> > enumerator.OLAPEnumerator:181 : No group by and aggregation found in this
> > query, will hack some result for better look of output...
> > 2016-09-09 17:32:15,757 INFO  [http-bio-7070-exec-7]
> > v2.CubeStorageQuery:239 : exactAggregation is true
> > 2016-09-09 17:32:15,757 INFO  [http-bio-7070-exec-7]
> > v2.CubeStorageQuery:357 : Enable limit 100
> > 2016-09-09 17:32:15,757 INFO  [http-bio-7070-exec-7]
> > dict.DictionaryManager:393 : DictionaryManager(1238461247) loading
> > DictionaryInfo(loadDictObj:true) at
> > /dict/NY.TRANS_FACT/SET_DATE/d8379c72-dfc6-44d1-b429-9922cbd21091.dict
> > 2016-09-09 17:32:15,759 INFO  [http-bio-7070-exec-7]
> > dict.DictionaryManager:393 : DictionaryManager(1238461247) loading
> > DictionaryInfo(loadDictObj:true) at
> > /dict/NY.TRANS_FACT/DC_FLAG/e7cdf373-2379-4313-89da-0d9b44954cd6.dict
> > 2016-09-09 17:32:15,761 DEBUG [http-bio-7070-exec-7]
> > v2.CubeHBaseEndpointRPC:257 : New scanner for current segment
> > TND1[1970010100_2016100100] will use SCAN_FILTER_AGGR_CHECKMEM
> as
> > endpoint's behavior
> > 2016-09-09 17:32:15,762 DEBUG [http-bio-7070-exec-7]
> > v2.CubeHBaseEndpointRPC:313 : Serialized scanRequestBytes 684 bytes,
> > rawScanBytesString 50 bytes
> > 2016-09-09 17:32:15,762 INFO  [http-bio-7070-exec-7]
> > v2.CubeHBaseEndpointRPC:315 : The scan 38504673 for segment
> > TND1[1970010100_2016100100] is as below with 1 separate raw
> scans,
> > shard part of start/end key is set to 0
> > 2016-09-09 17:32:15,762 INFO  [http-bio-7070-exec-7] v2.CubeHBaseRPC:271
> :
> > Visiting hbase table KYLIN_SL43718YJF: cuboid exact match, from 15 to 15
> > Start: \x00\x00\x00\x00\x00\x00\x00\x00\x00\x0F\x00\x00\x00\x00\x00\x00
> > (\x00\x00\x00\x00\x00\x00\x00\x00\x00\x0F\x00\x00\x00\x00\x00\x00) Stop:
> >  \x00\x00\x00\x00\x00\x00\x00\x00\x00\x0F\xFF\xFF\xFF\xFF\xFF\xFF\x00
> > (\x00\x00\x00\x00\x00\x00\x00\x00\x00\x0F\xFF\xFF\xFF\xFF\xFF\xFF\x00),
> No
> > Fuzzy Key
> > 2016-09-09 17:32:15,762 DEBUG [http-bio-7070-exec-7]
> > v2.CubeHBaseEndpointRPC:320 : Submitting rpc to 2 shards starting from
> > shard 0, scan range count 1
> > 2016-09-09 17:32:15,763 INFO  [http-bio-7070-exec-7]
> > v2.CubeHBaseEndpointRPC:103 : Timeout for ExpectedSizeIterator is:
> 990
> > 2016-09-09 17:32:15,763 DEBUG [http-bio-7070-exec-7]
> > enumerator.OLAPEnumerator:127 : 

Re: [Announce] Apache Kylin 1.5.4 released

[hongbin ma]

thanks shaofeng!

On Fri, Sep 16, 2016 at 10:34 PM, Billy(Yiming) Liu  wrote:

> Thanks Shaofeng and our community.
>
> 2016-09-16 21:25 GMT+08:00 ShaoFeng Shi :
>
>> The Apache Kylin team is pleased to announce the immediate availability of
>> the 1.5.4 release.
>>
>> This is a bug fix release based on 1.5.3; All of the changes in this
>> release can be found in:
>> https://kylin.apache.org/docs15/release_notes.html
>>
>> You can download the source release and binary packages from
>> https://www.apache.org/dyn/closer.cgi?path=/kylin/apache-kylin-1.5.4/
>>
>> More information about the binary packages is on Kylin's download page
>> https://kylin.apache.org/download/
>>
>> Apache Kylin is an open source Distributed Analytics Engine designed to
>> provide SQL interface and multi-dimensional analysis (OLAP) on Hadoop,
>> supporting extremely large datasets.
>>
>> Apache Kylin lets you query massive data set at sub-second latency in 3
>> steps:
>> 1. Identify a Star Schema data on Hadoop.
>> 2. Build Cube on Hadoop.
>> 3. Query data with ANSI-SQL and get results in sub-second, via ODBC, JDBC
>> or RESTful API.
>>
>> Thanks everyone who have contributed to the 1.5.4 release.
>>
>> We welcome your help and feedback. For more information on how to
>> report problems, and to get involved, visit the project website at
>> https://kylin.apache.org/
>>
>> --
>> Best regards,
>>
>> Shaofeng Shi 史少锋
>>
>
>
>
> --
> With Warm regards
>
> Yiming Liu (刘一鸣)
>



-- 
Regards,

*Bin Mahone | 马洪宾*