date:20170815

[jira] [Created] (KYLIN-2791) Fix bug in readLong function in BytesUtil

2017-08-15 Thread Xiaqing Wang (JIRA)

Xiaqing Wang created KYLIN-2791:
---

 Summary: Fix bug in readLong function in BytesUtil
 Key: KYLIN-2791
 URL: https://issues.apache.org/jira/browse/KYLIN-2791
 Project: Kylin
  Issue Type: Bug
Reporter: Xiaqing Wang


A bug was found in readLong function in BytesUtil, which might cause error when 
deserializing a Long type object. 



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

[jira] [Created] (KYLIN-2790) Add an Extending point to support other types of column family

2017-08-15 Thread Xiaqing Wang (JIRA)

Xiaqing Wang created KYLIN-2790:
---

 Summary: Add an Extending point to support other types of column 
family 
 Key: KYLIN-2790
 URL: https://issues.apache.org/jira/browse/KYLIN-2790
 Project: Kylin
  Issue Type: Improvement
Reporter: Xiaqing Wang


For storage systems whose column families have concepts different from HBase, 
we should digest HBaseMapping information in metadata to deal with such 
differences. 



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

Re: Kylin 主从同步经常失败

2017-08-15 Thread Li Yang

pls provide more info or people cannot help

On Tue, Aug 8, 2017 at 3:12 PM, lichaojacobs 
wrote:

> I am sure it's not the network problem. Because some changes can
> successfully
> send to other nodes.
> So, I think it's the program sometimes can not reponse status with 200,
> perhaps 500. But there are no more specific error message to verify that.
> So
> I suggest if you can add retry logic and narrow the try catch scope to log
> more detailed message
>
> --
> View this message in context: http://apache-kylin.74782.x6.
> nabble.com/Kylin-tp8640p8663.html
> Sent from the Apache Kylin mailing list archive at Nabble.com.
>

Re: How to migrate cube from one Kylin to another (for example, Kylin QA to Kylin Production) within the different Hadoop Cluster

2017-08-15 Thread Li Yang

Then pls following Shaofeng's answer.

On Tue, Aug 8, 2017 at 4:51 PM, wangzy24  wrote:

> Not to do the whole data migration, it is iterative development, the demand
> upgrade, the part of the metadata that we want to migrate, what could be
> the
> solution?
>
>
>
> shaofengshi wrote
> > Kylin metadata migration is very simple, just follow the "backup/restore
> > metadata" guide.
> >
> > But if you want to have the Cube data also be moved to new cluster, you
> > need migrate:
> >
> > 1) Hive tables (metadata and files);
> > 2) Files in Kylin HDFS working dir;
> > 3) HBase tables (KYLIN_.*)
> >
> > There is no a tool to automate these steps. You need do that by your own.
> >
> > 2017-08-03 15:06 GMT+08:00 wangzy24 
>
> > wangzy24@
>
> > :
> >
> >> What would you do if you wanted to do metadata migration between
> >> completely
> >> independent environments within the different Hadoop Cluster?
> >>
> >> --
> >> View this message in context: http://apache-kylin.74782.x6.
> >> nabble.com/How-to-migrate-cube-from-one-Kylin-to-
> >> another-for-example-Kylin-QA-to-Kylin-Production-within-
> >> the-dir-tp8628.html
> >> Sent from the Apache Kylin mailing list archive at Nabble.com.
> >>
> >
> >
> >
> > --
> > Best regards,
> >
> > Shaofeng Shi 史少锋
>
>
>
> --
> View this message in context: http://apache-kylin.74782.x6.
> nabble.com/How-to-migrate-cube-from-one-Kylin-to-
> another-for-example-Kylin-QA-to-Kylin-Production-within-
> the-dir-tp8628p8666.html
> Sent from the Apache Kylin mailing list archive at Nabble.com.
>

Re: The REST query request failed

2017-08-15 Thread Li Yang

This is known issue https://issues.apache.org/jira/browse/KYLIN-2787

Thanks for reporting.

Yang

On Tue, Aug 8, 2017 at 3:53 PM, shendandan 
wrote:

> Hello!
>  I use tableau as kylin's visualization tool. And I want to know can I
> create calculated field in tableau to select?
> " if [还款逾期天数] >90 then [本息余额_1] ELSE 0 END " this is my calculated
> field but there is a error when I used the calculated field.
> the error is :
>[Kylin][ODBC 1.0(w) Driver]The REST query request failed, the error
> message is: Error while executing SQL "SELECT SUM((CASE WHEN
> ("BASEINFO_REPAY_HIS_FACT_PARTATION"."CUR_LATEDAYS" > 90) THEN
> "BASEINFO_REPAY_HIS_FACT_PARTATION"."REMAIN_CAPITAL_INTEREST" ELSE 0
> END)) AS "sum_Calculation_FCFAIAHBFAGFBCEH_ok" FROM
> "TN_QUERY"."BASEINFO_REPAY_HIS_FACT_PARTATION" 
> "BASEINFO_REPAY_HIS_FACT_PARTATION"
> LEFT JOIN "TN_QUERY"."DIM_BP_PRODUCT" "DIM_BP_PRODUCT" ON
> ("BASEINFO_REPAY_HIS_FACT_PARTATION"."PRODUCT_CODE" =
> "DIM_BP_PRODUCT"."PRODUCT_CODE") LEFT JOIN "TN_QUERY"."DIM_BP_SALES_CHANNEL"
> "DIM_BP_SALES_CHANNEL" ON ("BASEINFO_REPAY_HIS_FACT_PARTATION"."BUSINESS_TYPE"
> = "DIM_BP_SALES_CHANNEL"."CHANNEL_CODE") LEFT JOIN
> "TN_QUERY"."DIM_FUND_CHANNEL" "DIM_FUND_CHANNEL" ON
> ("BASEINFO_REPAY_HIS_FACT_PARTATION"."ROOT_CODE" =
> "DIM_FUND_CHANNEL"."FUND_CHANNEL_CODE") LEFT JOIN "TN_QUERY"."DIM_ORG"
> "DIM_ORG" ON ("BASEINFO_REPAY_HIS_FACT_PARTATION"."BRANCH_CODE" =
> "DIM_ORG"."BRANCH_CODE") ": Can't find any realization. Please confirm with
> providers. SQL digest: fact table 
> TN_QUERY.BASEINFO_REPAY_HIS_FACT_PARTATION,group
> by [],filter on [],with aggregates[FunctionDesc [expression=SUM,
> parameter=null, returnType=null]].

[jira] [Created] (KYLIN-2789) Cube's last build time is wrong

2017-08-15 Thread Hongtao He (JIRA)

Hongtao He created KYLIN-2789:
-

 Summary: Cube's last build time is wrong
 Key: KYLIN-2789
 URL: https://issues.apache.org/jira/browse/KYLIN-2789
 Project: Kylin
  Issue Type: Bug
  Components: REST Service
Affects Versions: v1.6.0
Reporter: Hongtao He
Assignee: Zhong,Jason
Priority: Minor
 Fix For: v1.6.0
 Attachments: cubeListModel.js.js

Firstly, we create a segment in a cube, then we can get the attributes of this 
segment，such as
 { "date_range_start " : 2017-08-02 00:00:00,
"date_range_end" : 2017-08-03 00:00:00,
"last_build_time": 2017-08-16 01:00:00
}
Secondly, we create another segment in this cube, which has an earlier data 
range，such as
 { "date_range_start " : 2017-08-01 00:00:00,
"date_range_end" : 2017-08-02 00:00:00,
"last_build_time": 2017-08-16 02:00:00
}
Under these circumstances, the Cube's last creation time should be 2017-08-16 
02:00:00, not 2017-08-16 01:00:00.However, we get the opposite answer  in kylin 
1.6.0.
the realization of cube's last build time is  :
 if(cube.name){
if (cube.segments && cube.segments.length > 0) {
for(var i= cube.segments.length-1;i>=0;i--){
if(cube.segments[i].status==="READY"){
   {color:red} cube.last_build_time = 
cube.segments[i].last_build_time;
break;{color}
}else if(i===0){
cube.last_build_time = undefined;
}
}
} else {
cube.last_build_time = undefined;
}
}
(the code is in kylin/webapp/app/js/model/cubeListModel.js)
The last build time may come from any segment，I changed the code to the 
following:
if(cube.name){
cube.last_build_time = undefined;
if (cube.segments && cube.segments.length > 0) {
for(var i= cube.segments.length-1;i>=0;i--){
if(cube.segments[i].status==="READY"){
if(cube.last_build_time===undefined || 
cube.last_build_time

Re: [DISCUSS] On removing Cube ACL

2017-08-15 Thread Luke Han

Data Model level is better than Cube level.

How about to leave extend point there for people who want to keep Cube
Level ACL?




Best Regards!
-

Luke Han

On Tue, Aug 15, 2017 at 5:30 PM, Li Yang  wrote:

> So we can still control who can (or cannot) access a cube by defining ACL
> on tables, right?
>
> On Mon, Aug 7, 2017 at 2:26 PM, ShaoFeng Shi 
> wrote:
>
> > It makes sense for me. Will the Cube ACL info be migrated (from Cube to
> > Table) when it is done?
> >
> > 2017-08-07 10:37 GMT+08:00 hongbin ma :
> >
> > > Current ACL design is based on very early versions where kylin merely
> had
> > > simple concepts like projects and cubes.
> > > With the advent of Kylin v2.0, and several new concepts like Data
> Model (
> > > http://kylin.apache.org/docs/gettingstarted/concepts.html) and Query
> > > Pushdown (KYLIN-2515), the original cube-centric ACL design is becoming
> > > outdated. The reasons are two-fold: 1. cubes are no longer the only
> > > entities we want to take control within each projects.  2. Cube-level
> ACL
> > > cannot protect underlying tables from being queries by unwanted users.
> > >
> > > In fact, cubes is merely a special kind of index on the original table.
> > > It's not straightforward to apply ACL on indexes rather than original
> > > tables. That said, we need table-level ACL instead of cube-level ACL.
> We
> > > have elaborated the detailed plans in KYLIN-2760 and KYLIN-2761. Please
> > > comment on those issues or reply this email if you have any concerns.
> > >
> > > --
> > > Regards,
> > >
> > > *Bin Mahone | 马洪宾*
> > >
> >
> >
> >
> > --
> > Best regards,
> >
> > Shaofeng Shi 史少锋
> >
>

Re: [VOTE] Release apache-kylin-2.1.0 (RC2)

2017-08-15 Thread Luke Han

+1 (binding)

mvn test passed
gpg/md5/sha1 verified


Best Regards!
-

Luke Han

On Tue, Aug 15, 2017 at 9:13 PM, 康凯森  wrote:

> +1.
>
>
> Thanks Shaofeng.
>
>
> -- 原始邮件 --
> 发件人: "ShaoFeng Shi";;
> 发送时间: 2017年8月13日(星期天) 下午2:45
> 收件人: "dev";
>
> 主题: [VOTE] Release apache-kylin-2.1.0 (RC2)
>
>
>
> Hi all,
>
> I have created a build for Apache Kylin 2.1.0, release candidate 2.
>
> Changes highlights:
> KYLIN-2506 - Refactor global dictionary
> KYLIN-2515 - Route unsupported query back to query its source directly
> KYLIN-2579 KYLIN-2580  - Improvement on subqueries
> KYLIN-2633 - Upgrade Spark to 2.1
> KYLIN-2646 - Project level query authorization
>
> And more than 100 bug fixes and enhancements.
>
> Thanks to everyone who has contributed to this release. Here’s release
> notes:
> https://issues.apache.org/jira/secure/ReleaseNote.jspa?
> projectId=12316121=12340443
>
> The commit to be voted upon:
>
> https://github.com/apache/kylin/commit/562dd173aaf6b398be8e053f896755
> b3afe8137f
>
> Its hash is 562dd173aaf6b398be8e053f896755b3afe8137f.
>
> The artifacts to be voted on are located here:
> https://dist.apache.org/repos/dist/dev/kylin/apache-kylin-2.1.0-rc2/
>
> The hashes of the artifacts are as follows:
> apache-kylin-2.1.0-src.tar.gz.md5 44cab3240772dd1b2e717b48105b416c
> apache-kylin-2.1.0-src.tar.gz.sha1 a3470589523cfa9046d70123d78059
> b913f31b9f
>
> (The binary packages for HBase 1.x and CDH 5.7are also provided for
> testing)
>
> A staged Maven repository is available for review at:
> https://repository.apache.org/content/repositories/orgapachekylin-1043/
>
> Release artifacts are signed with the following key:
> https://people.apache.org/keys/committer/shaofengshi.asc
>
> Please vote on releasing this package as Apache Kylin 2.1.0.
>
> The vote is open for the next 72 hours and passes if a majority of
> at least three +1 PPMC votes are cast.
>
> [ ] +1 Release this package as Apache Kylin 2.1.0
> [ ]  0 I don't feel strongly about it, but I'm okay with the release
> [ ] -1 Do not release this package because...
>
> Here is my vote:
>
> +1 (binding)
>
>
> --
> Best regards,
>
> Shaofeng Shi 史少锋
>

Get data from bigint column error

2017-08-15 Thread jimmy

Hi,

 

I want to get data from kylin sample data.

But,It return error message.

 



SQL: 

 

select KYLIN_ACCOUNT.ACCOUNT_BUYER_LEVEL from KYLIN_ACCOUNT

 

Error Message:

 

Error while executing SQL "select KYLIN_ACCOUNT.ACCOUNT_BUYER_LEVEL from
KYLIN_ACCOUNT LIMIT 5": java.lang.Integer cannot be cast to
java.lang.Long

 

Has any suggestion?

 

Thanks a lot.

 

Jimmy.

??????[VOTE] Release apache-kylin-2.1.0 (RC2)

2017-08-15 Thread ??????

+1.


Thanks Shaofeng.


--  --
??: "ShaoFeng Shi";;
: 2017??8??13??(??) 2:45
??: "dev"; 

: [VOTE] Release apache-kylin-2.1.0 (RC2)



Hi all,

I have created a build for Apache Kylin 2.1.0, release candidate 2.

Changes highlights:
KYLIN-2506 - Refactor global dictionary
KYLIN-2515 - Route unsupported query back to query its source directly
KYLIN-2579 KYLIN-2580  - Improvement on subqueries
KYLIN-2633 - Upgrade Spark to 2.1
KYLIN-2646 - Project level query authorization

And more than 100 bug fixes and enhancements.

Thanks to everyone who has contributed to this release. Here??s release
notes:
https://issues.apache.org/jira/secure/ReleaseNote.jspa?projectId=12316121=12340443

The commit to be voted upon:

https://github.com/apache/kylin/commit/562dd173aaf6b398be8e053f896755b3afe8137f

Its hash is 562dd173aaf6b398be8e053f896755b3afe8137f.

The artifacts to be voted on are located here:
https://dist.apache.org/repos/dist/dev/kylin/apache-kylin-2.1.0-rc2/

The hashes of the artifacts are as follows:
apache-kylin-2.1.0-src.tar.gz.md5 44cab3240772dd1b2e717b48105b416c
apache-kylin-2.1.0-src.tar.gz.sha1 a3470589523cfa9046d70123d78059b913f31b9f

(The binary packages for HBase 1.x and CDH 5.7are also provided for testing)

A staged Maven repository is available for review at:
https://repository.apache.org/content/repositories/orgapachekylin-1043/

Release artifacts are signed with the following key:
https://people.apache.org/keys/committer/shaofengshi.asc

Please vote on releasing this package as Apache Kylin 2.1.0.

The vote is open for the next 72 hours and passes if a majority of
at least three +1 PPMC votes are cast.

[ ] +1 Release this package as Apache Kylin 2.1.0
[ ]  0 I don't feel strongly about it, but I'm okay with the release
[ ] -1 Do not release this package because...

Here is my vote:

+1 (binding)


-- 
Best regards,

Shaofeng Shi ??

Re: [VOTE] Release apache-kylin-2.1.0 (RC2)

2017-08-15 Thread George Ni (Chunen Ni)

+1(no binding) 
mvn test passed 
build success 
md5 verified
Best regards,
 
Chun’en Ni(倪春恩)
Mail: chunen...@kyligence.io 
Shanghai Kyligence Information Technology Co., Ltd
上海市浦东新区亮秀路112号Y1座405室
 

在 2017/8/15 下午6:10，“roger shi” 写入:

+1 (non-binding)

mvn test passed
md5 & sha1 verified

Apache Maven 3.5.0 (ff8f5e7444045639af65f6095c62210b5713f426; 
2017-04-04T03:39:06+08:00)
Maven home: /usr/local/Cellar/maven/3.5.0/libexec
Java version: 1.8.0_91, vendor: Oracle Corporation
Java home: 
/Library/Java/JavaVirtualMachines/jdk1.8.0_91.jdk/Contents/Home/jre
Default locale: en_US, platform encoding: UTF-8
OS name: "mac os x", version: "10.12.6", arch: "x86_64", family: "mac"

On 13/08/2017, 2:45 PM, "ShaoFeng Shi"  wrote:

Hi all,

I have created a build for Apache Kylin 2.1.0, release candidate 2.

Changes highlights:
KYLIN-2506 - Refactor global dictionary
KYLIN-2515 - Route unsupported query back to query its source directly
KYLIN-2579 KYLIN-2580  - Improvement on subqueries
KYLIN-2633 - Upgrade Spark to 2.1
KYLIN-2646 - Project level query authorization

And more than 100 bug fixes and enhancements.

Thanks to everyone who has contributed to this release. Here’s release
notes:

https://issues.apache.org/jira/secure/ReleaseNote.jspa?projectId=12316121=12340443

The commit to be voted upon:


https://github.com/apache/kylin/commit/562dd173aaf6b398be8e053f896755b3afe8137f

Its hash is 562dd173aaf6b398be8e053f896755b3afe8137f.

The artifacts to be voted on are located here:
https://dist.apache.org/repos/dist/dev/kylin/apache-kylin-2.1.0-rc2/

The hashes of the artifacts are as follows:
apache-kylin-2.1.0-src.tar.gz.md5 44cab3240772dd1b2e717b48105b416c
apache-kylin-2.1.0-src.tar.gz.sha1 
a3470589523cfa9046d70123d78059b913f31b9f

(The binary packages for HBase 1.x and CDH 5.7are also provided for 
testing)

A staged Maven repository is available for review at:
https://repository.apache.org/content/repositories/orgapachekylin-1043/

Release artifacts are signed with the following key:
https://people.apache.org/keys/committer/shaofengshi.asc

Please vote on releasing this package as Apache Kylin 2.1.0.

The vote is open for the next 72 hours and passes if a majority of
at least three +1 PPMC votes are cast.

[ ] +1 Release this package as Apache Kylin 2.1.0
[ ]  0 I don't feel strongly about it, but I'm okay with the release
[ ] -1 Do not release this package because...

Here is my vote:

+1 (binding)


-- 
Best regards,

Shaofeng Shi 史少锋

Re: [VOTE] Release apache-kylin-2.1.0 (RC2)

2017-08-15 Thread roger shi

+1 (non-binding)

mvn test passed
md5 & sha1 verified

Apache Maven 3.5.0 (ff8f5e7444045639af65f6095c62210b5713f426; 
2017-04-04T03:39:06+08:00)
Maven home: /usr/local/Cellar/maven/3.5.0/libexec
Java version: 1.8.0_91, vendor: Oracle Corporation
Java home: /Library/Java/JavaVirtualMachines/jdk1.8.0_91.jdk/Contents/Home/jre
Default locale: en_US, platform encoding: UTF-8
OS name: "mac os x", version: "10.12.6", arch: "x86_64", family: "mac"

On 13/08/2017, 2:45 PM, "ShaoFeng Shi"  wrote:

Hi all,

I have created a build for Apache Kylin 2.1.0, release candidate 2.

Changes highlights:
KYLIN-2506 - Refactor global dictionary
KYLIN-2515 - Route unsupported query back to query its source directly
KYLIN-2579 KYLIN-2580  - Improvement on subqueries
KYLIN-2633 - Upgrade Spark to 2.1
KYLIN-2646 - Project level query authorization

And more than 100 bug fixes and enhancements.

Thanks to everyone who has contributed to this release. Here’s release
notes:

https://issues.apache.org/jira/secure/ReleaseNote.jspa?projectId=12316121=12340443

The commit to be voted upon:


https://github.com/apache/kylin/commit/562dd173aaf6b398be8e053f896755b3afe8137f

Its hash is 562dd173aaf6b398be8e053f896755b3afe8137f.

The artifacts to be voted on are located here:
https://dist.apache.org/repos/dist/dev/kylin/apache-kylin-2.1.0-rc2/

The hashes of the artifacts are as follows:
apache-kylin-2.1.0-src.tar.gz.md5 44cab3240772dd1b2e717b48105b416c
apache-kylin-2.1.0-src.tar.gz.sha1 a3470589523cfa9046d70123d78059b913f31b9f

(The binary packages for HBase 1.x and CDH 5.7are also provided for testing)

A staged Maven repository is available for review at:
https://repository.apache.org/content/repositories/orgapachekylin-1043/

Release artifacts are signed with the following key:
https://people.apache.org/keys/committer/shaofengshi.asc

Please vote on releasing this package as Apache Kylin 2.1.0.

The vote is open for the next 72 hours and passes if a majority of
at least three +1 PPMC votes are cast.

[ ] +1 Release this package as Apache Kylin 2.1.0
[ ]  0 I don't feel strongly about it, but I'm okay with the release
[ ] -1 Do not release this package because...

Here is my vote:

+1 (binding)


-- 
Best regards,

Shaofeng Shi 史少锋

Re: [VOTE] Release apache-kylin-2.1.0 (RC2)

2017-08-15 Thread Cheng Wang

+1 (Upgrade Spark to 2.1 should bring more capability to accelerate cubing.)





On 8/13/17, 2:45 PM, "ShaoFeng Shi"  wrote:

>Hi all,
>
>I have created a build for Apache Kylin 2.1.0, release candidate 2.
>
>Changes highlights:
>KYLIN-2506 - Refactor global dictionary
>KYLIN-2515 - Route unsupported query back to query its source directly
>KYLIN-2579 KYLIN-2580  - Improvement on subqueries
>KYLIN-2633 - Upgrade Spark to 2.1
>KYLIN-2646 - Project level query authorization
>
>And more than 100 bug fixes and enhancements.
>
>Thanks to everyone who has contributed to this release. Here’s release
>notes:
>https://issues.apache.org/jira/secure/ReleaseNote.jspa?projectId=12316121=12340443
>
>The commit to be voted upon:
>
>https://github.com/apache/kylin/commit/562dd173aaf6b398be8e053f896755b3afe8137f
>
>Its hash is 562dd173aaf6b398be8e053f896755b3afe8137f.
>
>The artifacts to be voted on are located here:
>https://dist.apache.org/repos/dist/dev/kylin/apache-kylin-2.1.0-rc2/
>
>The hashes of the artifacts are as follows:
>apache-kylin-2.1.0-src.tar.gz.md5 44cab3240772dd1b2e717b48105b416c
>apache-kylin-2.1.0-src.tar.gz.sha1 a3470589523cfa9046d70123d78059b913f31b9f
>
>(The binary packages for HBase 1.x and CDH 5.7are also provided for testing)
>
>A staged Maven repository is available for review at:
>https://repository.apache.org/content/repositories/orgapachekylin-1043/
>
>Release artifacts are signed with the following key:
>https://people.apache.org/keys/committer/shaofengshi.asc
>
>Please vote on releasing this package as Apache Kylin 2.1.0.
>
>The vote is open for the next 72 hours and passes if a majority of
>at least three +1 PPMC votes are cast.
>
>[ ] +1 Release this package as Apache Kylin 2.1.0
>[ ]  0 I don't feel strongly about it, but I'm okay with the release
>[ ] -1 Do not release this package because...
>
>Here is my vote:
>
>+1 (binding)
>
>
>-- 
>Best regards,
>
>Shaofeng Shi 史少锋

Re: [DISCUSS] On removing Cube ACL

2017-08-15 Thread Li Yang

So we can still control who can (or cannot) access a cube by defining ACL
on tables, right?

On Mon, Aug 7, 2017 at 2:26 PM, ShaoFeng Shi  wrote:

> It makes sense for me. Will the Cube ACL info be migrated (from Cube to
> Table) when it is done?
>
> 2017-08-07 10:37 GMT+08:00 hongbin ma :
>
> > Current ACL design is based on very early versions where kylin merely had
> > simple concepts like projects and cubes.
> > With the advent of Kylin v2.0, and several new concepts like Data Model (
> > http://kylin.apache.org/docs/gettingstarted/concepts.html) and Query
> > Pushdown (KYLIN-2515), the original cube-centric ACL design is becoming
> > outdated. The reasons are two-fold: 1. cubes are no longer the only
> > entities we want to take control within each projects.  2. Cube-level ACL
> > cannot protect underlying tables from being queries by unwanted users.
> >
> > In fact, cubes is merely a special kind of index on the original table.
> > It's not straightforward to apply ACL on indexes rather than original
> > tables. That said, we need table-level ACL instead of cube-level ACL. We
> > have elaborated the detailed plans in KYLIN-2760 and KYLIN-2761. Please
> > comment on those issues or reply this email if you have any concerns.
> >
> > --
> > Regards,
> >
> > *Bin Mahone | 马洪宾*
> >
>
>
>
> --
> Best regards,
>
> Shaofeng Shi 史少锋
>

Re: Dictionary not found

2017-08-15 Thread Li Yang

Hard to troubleshot from the description. Is there a way to reproduce the
problem using sample cube?

On Wed, Aug 2, 2017 at 11:47 PM, bk_180  wrote:

> Hi all,
>
> We have a cube that needs to get two partitions refreshed, so we run one
> job
> to refresh the first partition and then run other job to refresh the other
> partition. This procedure was working fine, but recently the second job got
> failed.
>
> This is the error found in kyling.log for the second job:
> 2017-08-01 16:40:08,575 INFO  [pool-8-thread-10]
> common.AbstractHadoopJob:506 : tempMetaFileString is : null
> 2017-08-01 16:40:08,576 ERROR [pool-8-thread-10]
> common.MapReduceExecutable:127 : error execute
> MapReduceExecutable{id=41eaa576-1dde-4f7d-9fd6-423127a9be95-03,
> name=Extract
> Fact Table Distinct Columns, state=RUNNING}
> java.lang.IllegalStateException: No resource found at --
> /dict/VIEW_CREDITO/COD_LOJISTA/68ad8c2f-d511-4ce7-ae35-bb139e075750.dict
>
> For the first job, we can see that the dictionary was built successfully:
> 2017-08-01 16:11:40,866 INFO  [pool-8-thread-10] dict.DictionaryManager:404
> : Saving dictionary at
> /dict/VIEW_CREDITO/COD_LOJISTA/68ad8c2f-d511-4ce7-ae35-bb139e075750.dict
> 2017-08-01 16:11:40,866 DEBUG [pool-8-thread-10]
> persistence.ResourceStore:207 : Directly saving resource
> /dict/VIEW_CREDITO/COD_LOJISTA/68ad8c2f-d511-4ce7-ae35-bb139e075750.dict
> (Store kylin_metadata@hbase)
>
>
>
>
> --
> View this message in context: http://apache-kylin.74782.x6.
> nabble.com/Dictionary-not-found-tp8626.html
> Sent from the Apache Kylin mailing list archive at Nabble.com.
>

Re: Re: Leap Month calculate error

2017-08-15 Thread apache_...@163.com


Run :

select date '2011-03-31'  - INTERVAL '1' month from KYLIN_CAL_DT  

got same result :2011-03-01

The result is incorrect 



apache_...@163.com
 
From: Alberto Ramón
Date: 2017-08-15 16:21
To: dev
Subject: Re: Leap Month calculate error
Try to use  DATE statement
 
http://apache-kylin.74782.x6.nabble.com/about-kylin-sql-key-words-IN-td5908.html
 
On 15 August 2017 at 08:59, apache_...@163.com  wrote:
 
> Hi,
>
> when i run sql by kyline GUI,Right result is  2011-02-28,but i got
> 2011-03-01,is bug?
>
> select cast('2011-03-31' as date)  - INTERVAL '1' month from KYLIN_CAL_DT
>
>
>
>
>
> apache_...@163.com
>

Re: Leap Month calculate error

2017-08-15 Thread Alberto Ramón

Try to use  DATE statement

http://apache-kylin.74782.x6.nabble.com/about-kylin-sql-key-words-IN-td5908.html

On 15 August 2017 at 08:59, apache_...@163.com  wrote:

> Hi,
>
> when i run sql by kyline GUI,Right result is  2011-02-28,but i got
> 2011-03-01,is bug?
>
> select cast('2011-03-31' as date)  - INTERVAL '1' month from KYLIN_CAL_DT
>
>
>
>
>
> apache_...@163.com
>

Leap Month calculate error

2017-08-15 Thread apache_...@163.com

Hi,

when i run sql by kyline GUI,Right result is  2011-02-28,but i got  
2011-03-01,is bug?

select cast('2011-03-31' as date)  - INTERVAL '1' month from KYLIN_CAL_DT 





apache_...@163.com

[jira] [Created] (KYLIN-2791) Fix bug in readLong function in BytesUtil

[jira] [Created] (KYLIN-2790) Add an Extending point to support other types of column family

Re: Kylin 主从同步经常失败

Re: How to migrate cube from one Kylin to another (for example, Kylin QA to Kylin Production) within the different Hadoop Cluster

Re: The REST query request failed

[jira] [Created] (KYLIN-2789) Cube's last build time is wrong

Re: [DISCUSS] On removing Cube ACL

Re: [VOTE] Release apache-kylin-2.1.0 (RC2)

Get data from bigint column error

??????[VOTE] Release apache-kylin-2.1.0 (RC2)

Re: [VOTE] Release apache-kylin-2.1.0 (RC2)

Re: [VOTE] Release apache-kylin-2.1.0 (RC2)

Re: [VOTE] Release apache-kylin-2.1.0 (RC2)

Re: [DISCUSS] On removing Cube ACL

Re: Dictionary not found

Re: Re: Leap Month calculate error

Re: Leap Month calculate error

Leap Month calculate error

18 matches

Site Navigation

Mail list logo

Footer information