Re: [Announce] Apache Kylin 2.3.0 released

[deva namaste]

 I able to correct the issue by deleting intermediate files.
http://kylin.apache.org/docs23/howto/howto_cleanup_storage.html


On Tue, Mar 6, 2018 at 11:18 AM, deva namaste  wrote:

> Thanks Billy.
>
> After I upgrade to 2.3 I am getting following error (
> org.apache.kylin.rest.exception.InternalErrorException: Storage Engine
> (id=0) ) during query.
>
> 2018-03-06 09:43:04,607 ERROR [http-bio-7070-exec-9]
> controller.BasicController:61 :
> org.apache.kylin.rest.exception.InternalErrorException: Storage Engine
> (id=0) is not supported any more
> while executing SQL: "select * from  FACT_TABLE LIMIT 5"
>
> Any help is appreciated.
>
>
> On Sun, Mar 4, 2018 at 1:44 AM, Billy Liu  wrote:
>
>> Hello Kylin & Apache community,
>>
>> The Apache Kylin team is pleased to announce the immediate
>> availability of the 2.3.0 release.
>>
>> This is a major release after 2.2.0, with more than 250 bug fixes and
>> enhancements; All of the changes in this release can be found in:
>> https://kylin.apache.org/docs23/release_notes.html
>>
>> You can download the source release and binary packages from Apache
>> 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
>> Apache 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 or snowflake schema data set on Hadoop.
>> 2. Build Cube on Hadoop/Spark.
>> 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 2.3.0 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/
>>
>>
>> With Warm regards
>>
>> Billy Liu
>>
>
>

Re: v 2.3 Storage Engine (id=0) is not supported error

[deva namaste]

I able to correct the issue by deleting intermediate files.
http://kylin.apache.org/docs23/howto/howto_cleanup_storage.html

On Tue, Mar 6, 2018 at 10:46 AM, deva namaste  wrote:

>
>
>
> After I upgrade to latest release I am getting following error -
>
> 2018-03-06 09:43:04,607 ERROR [http-bio-7070-exec-9]
> controller.BasicController:61 :
> org.apache.kylin.rest.exception.InternalErrorException: Storage Engine
> (id=0) is not supported any more
> while executing SQL: "select * from  FACT_TABLE LIMIT 5"
>
> Any help is appreciated.
>

v 2.3 Storage Engine (id=0) is not supported error

[deva namaste]

After I upgrade to latest release I am getting following error -

2018-03-06 09:43:04,607 ERROR [http-bio-7070-exec-9]
controller.BasicController:61 :
org.apache.kylin.rest.exception.InternalErrorException: Storage Engine
(id=0) is not supported any more
while executing SQL: "select * from  FACT_TABLE LIMIT 5"

Any help is appreciated.

Re: RAW Measure kylin 2.3

[deva namaste]

Thanks Alberto.  Now I fixed the problem by enabling RAW measures. but now
when I query fact table I get following error with 2.3 release. Any ideas
how to fix this? Thanks

 Storage Engine (id=0) is not supported any more

On Tue, Mar 6, 2018 at 10:24 AM, Alberto Ramón 
wrote:

> From this mailList: questions about 'RAW'  measures
>
> MailList
> 
> : Kylin 3062  v2.3
> Propose to disable RAW from UI
>
> On 6 Mar 2018 1:38 p.m., "deva namaste"  wrote:
>
>> Hello,
>>
>> I do not see RAW measure after I upgraded to kylin version 2.3.
>>
>> Any other alternative measure we should use to show the raw data as is?
>> (Instead of RAW measure, any other alternative which can be used?)
>>
>> Thanks
>> Deva
>>
>

Re: RAW Measure kylin 2.3

[Alberto Ramón]

>From this mailList: questions about 'RAW'  measures

MailList

: Kylin 3062  v2.3
Propose to disable RAW from UI

On 6 Mar 2018 1:38 p.m., "deva namaste"  wrote:

> Hello,
>
> I do not see RAW measure after I upgraded to kylin version 2.3.
>
> Any other alternative measure we should use to show the raw data as is?
> (Instead of RAW measure, any other alternative which can be used?)
>
> Thanks
> Deva
>

RAW Measure kylin 2.3

[deva namaste]

Hello,

I do not see RAW measure after I upgraded to kylin version 2.3.

Any other alternative measure we should use to show the raw data as is?
(Instead of RAW measure, any other alternative which can be used?)

Thanks
Deva

Re: Auto merge problem

[xixin]

Hi Shaofeng,

Thanks a lot


> 在 2018年3月6日，16:37，ShaoFeng Shi  写道：
> 
> Kylin 2.2.0 has a bug which causing auto-merge failure. Please check 
> https://issues.apache.org/jira/browse/KYLIN-3165 
> 
> You can manually apply the patch to 2.2, or upgrade to latest 2.3.0.
> 
> 2018-03-06 16:34 GMT+08:00 xixin >:
> Hi Shaofeng,
> 
> Kylin 2.2.0
> 
> other Information: 
> I manually merged two segments successfully.
> Resouce code check segment “isOffsetCube()” first in CubeManagement.java, but 
> I don’t know what’s mean of this?
> Also this propertie comments like this :
>  // Hide the 4 confusing fields: dateRangeStart, dateRangeEnd, 
> sourceOffsetStart, sourceOffsetEnd.
> // They are now managed via SegmentRange and TSRange.
> 
> in CubeSegmentAdvisor.java
> 
>> 在 2018年3月6日，16:09，ShaoFeng Shi > > 写道：
>> 
>> -
> 
> 
> 
> 
> -- 
> Best regards,
> 
> Shaofeng Shi 史少锋
> 

Re: Auto merge problem

[ShaoFeng Shi]

Kylin 2.2.0 has a bug which causing auto-merge failure. Please check
https://issues.apache.org/jira/browse/KYLIN-3165
You can manually apply the patch to 2.2, or upgrade to latest 2.3.0.

2018-03-06 16:34 GMT+08:00 xixin :

> Hi Shaofeng,
>
> Kylin 2.2.0
>
> other Information:
> I *manually* merged two segments successfully.
> Resouce code check segment “isOffsetCube()” first in CubeManagement.java,
> but I don’t know what’s mean of this?
> Also this propertie comments like this :
>  // Hide the 4 confusing fields: dateRangeStart, dateRangeEnd,
> sourceOffsetStart, sourceOffsetEnd.
> // They are now managed via SegmentRange and TSRange.
>
> in CubeSegmentAdvisor.java
>
> 在 2018年3月6日，16:09，ShaoFeng Shi  写道：
>
> -
>
>
>


-- 
Best regards,

Shaofeng Shi 史少锋

Re: Auto merge problem

[xixin]

Hi Shaofeng,

Kylin 2.2.0

other Information: 
I manually merged two segments successfully.
Resouce code check segment “isOffsetCube()” first in CubeManagement.java, but I 
don’t know what’s mean of this?
Also this propertie comments like this :
 // Hide the 4 confusing fields: dateRangeStart, dateRangeEnd, 
sourceOffsetStart, sourceOffsetEnd.
// They are now managed via SegmentRange and TSRange.

in CubeSegmentAdvisor.java

> 在 2018年3月6日，16:09，ShaoFeng Shi  写道：
> 
> -

Re: Auto merge problem

[ShaoFeng Shi]

Hi xin, what's your Kylin version?

2018-03-06 15:15 GMT+08:00 xixin :

> Hi Kylin team,
> I config the Refresh Setting as below when I create a Cube
> Auto Merge Thresholds 7 days/30days
> Retension Thresholds 63
> Then I make addition segment every day. But after 7days later no auto
> merge happens.
> Do you have some ideas about this? Thanks a lot
>



-- 
Best regards,

Shaofeng Shi 史少锋