[jira] [Updated] (KYLIN-3290) Avoid calling Class#newInstance
[ https://issues.apache.org/jira/browse/KYLIN-3290?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ted Yu updated KYLIN-3290: -- Description: Class#newInstance is deprecated starting in Java 9 - https://bugs.openjdk.java.net/browse/JDK-6850612 - because it may throw undeclared checked exceptions. The suggested replacement is getDeclaredConstructor().newInstance(), which wraps the checked exceptions in InvocationException. was: Class::newInstance is deprecated starting in Java 9 - https://bugs.openjdk.java.net/browse/JDK-6850612 - because it may throw undeclared checked exceptions. The suggested replacement is getDeclaredConstructor().newInstance(), which wraps the checked exceptions in InvocationException. > Avoid calling Class#newInstance > --- > > Key: KYLIN-3290 > URL: https://issues.apache.org/jira/browse/KYLIN-3290 > Project: Kylin > Issue Type: Task >Reporter: Ted Yu >Priority: Minor > > Class#newInstance is deprecated starting in Java 9 - > https://bugs.openjdk.java.net/browse/JDK-6850612 - because it may throw > undeclared checked exceptions. > The suggested replacement is getDeclaredConstructor().newInstance(), which > wraps the checked exceptions in InvocationException. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (KYLIN-3287) When a shard by column is in dict encoding, dict building error.
[ https://issues.apache.org/jira/browse/KYLIN-3287?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jiatao.tao updated KYLIN-3287: -- Description: When a shard by column is in dict encoding, query this column will result null. > When a shard by column is in dict encoding, dict building error. > > > Key: KYLIN-3287 > URL: https://issues.apache.org/jira/browse/KYLIN-3287 > Project: Kylin > Issue Type: Bug >Affects Versions: v2.3.0 >Reporter: jiatao.tao >Assignee: jiatao.tao >Priority: Major > Fix For: v2.3.1 > > Attachments: image-2018-03-12-14-14-50-112.png, > image-2018-03-12-14-14-59-193.png, image-2018-03-12-14-15-42-046.png, > image-2018-03-12-14-16-38-657.png, image-2018-03-12-14-17-46-780.png > > > When a shard by column is in dict encoding, query this column will result > null. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (KYLIN-3287) When a shard by column is in dict encoding, dict building error.
[ https://issues.apache.org/jira/browse/KYLIN-3287?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jiatao.tao updated KYLIN-3287: -- Description: (was: In dict encoding. !image-2018-03-12-14-14-50-112.png|width=544,height=84! !image-2018-03-12-14-14-59-193.png|width=535,height=631! In int encoding !image-2018-03-12-14-15-42-046.png|width=544,height=87! !image-2018-03-12-14-16-38-657.png!) > When a shard by column is in dict encoding, dict building error. > > > Key: KYLIN-3287 > URL: https://issues.apache.org/jira/browse/KYLIN-3287 > Project: Kylin > Issue Type: Bug >Affects Versions: v2.3.0 >Reporter: jiatao.tao >Assignee: jiatao.tao >Priority: Major > Fix For: v2.3.1 > > Attachments: image-2018-03-12-14-14-50-112.png, > image-2018-03-12-14-14-59-193.png, image-2018-03-12-14-15-42-046.png, > image-2018-03-12-14-16-38-657.png, image-2018-03-12-14-17-46-780.png > > -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Created] (KYLIN-3290) Avoid calling Class#newInstance
Ted Yu created KYLIN-3290: - Summary: Avoid calling Class#newInstance Key: KYLIN-3290 URL: https://issues.apache.org/jira/browse/KYLIN-3290 Project: Kylin Issue Type: Task Reporter: Ted Yu Class::newInstance is deprecated starting in Java 9 - https://bugs.openjdk.java.net/browse/JDK-6850612 - because it may throw undeclared checked exceptions. The suggested replacement is getDeclaredConstructor().newInstance(), which wraps the checked exceptions in InvocationException. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (KYLIN-3270) Add integration test for Optimize Job
[ https://issues.apache.org/jira/browse/KYLIN-3270?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16396389#comment-16396389 ] Shaofeng SHI commented on KYLIN-3270: - +1 LGTM > Add integration test for Optimize Job > - > > Key: KYLIN-3270 > URL: https://issues.apache.org/jira/browse/KYLIN-3270 > Project: Kylin > Issue Type: Sub-task > Components: Tools, Build and Test >Reporter: Zhong Yanghong >Assignee: Zhong Yanghong >Priority: Critical > Fix For: v2.3.1 > > Attachments: APACHE-KYLIN-3270.patch > > -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (KYLIN-3084) File not found Exception when processing union-all in TEZ mode
[ https://issues.apache.org/jira/browse/KYLIN-3084?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16396384#comment-16396384 ] Le Anh Vu commented on KYLIN-3084: -- Using distribute by makes Create flat table step run slower in kylin 2.3.0 compare to previous versions. Can you guys have another solution for this issue? I've already made a comment here on github: [https://github.com/apache/kylin/commit/849faec]. Thanks > File not found Exception when processing union-all in TEZ mode > -- > > Key: KYLIN-3084 > URL: https://issues.apache.org/jira/browse/KYLIN-3084 > Project: Kylin > Issue Type: Bug >Reporter: Wang Cheng >Assignee: Wang Cheng >Priority: Minor > Fix For: v2.3.0 > > > If hive.execution.engine=TEZ and hql contains union all, it causes exception > like: file not found when materializing the view or redistributing flat hive > table. > Here is the reason: > http://grokbase.com/t/hive/user/162r80a2g9/anyway-to-avoid-creating-subdirectories-by-insert-with-union > i.e. "The Tez execution of UNION is entirely parallel & > the task-ids overlaps - so the files created have to have unique names. > But the total counts for "Map 1" and "Map 2" are only available as the job > runs, so they write to different dirs." > -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (KYLIN-3285) "Value NNN not exists" error run executing query
[ https://issues.apache.org/jira/browse/KYLIN-3285?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16396308#comment-16396308 ] Shaofeng SHI commented on KYLIN-3285: - This should be the same issue as KYLIN-3287 > "Value NNN not exists" error run executing query > - > > Key: KYLIN-3285 > URL: https://issues.apache.org/jira/browse/KYLIN-3285 > Project: Kylin > Issue Type: Bug > Components: Query Engine >Affects Versions: v2.3.0 >Reporter: Shaofeng SHI >Priority: Major > Fix For: v2.3.1 > > Attachments: cube (1).json, kylin.log > > > Reported by community user zxxb...@163.com: > > {color:#b94a48}Kylin version update from 2.2.0 to 2.3.0; cube was build > before update, and query without error.{color} > {color:#b94a48}After updatge to version 2.3.0 and query {color}"select > count(userid) num,day_time from record_ap group by day_time LIMIT > 1000{color:#b94a48}”{color} > {color:#b94a48}show errors below:{color} > Column 0 value '2018-03-06' met dictionary error: Value '2018-03-06' > (2018-03-06) not exists! while executing SQL: "select count(userid) > num,day_time from record_ap group by day_time LIMIT 1000” > > {color:#b94a48}Where {color}{color:#b94a48}'2018-03-06’ come from? I was > fully confused.{color} > {color:#b94a48}Cube have several segments:{color} > {color:#b94a48}Starttime-endtime{color} > {color:#b94a48}20180101-20180225{color} > 20180225-20180304 > > Attached the log and cube JSON. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (KYLIN-3280) The delete button should not be enabled without any segment in cube segment delete confirm dialog
[ https://issues.apache.org/jira/browse/KYLIN-3280?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16396303#comment-16396303 ] ASF subversion and git services commented on KYLIN-3280: Commit 066ac49a34f9c31aa0e500c9d80c4dbd56cf5d92 in kylin's branch refs/heads/2.3.x from [~xingpeng1] [ https://gitbox.apache.org/repos/asf?p=kylin.git;h=066ac49 ] KYLIN-3280 The delete button should not be enabled without any segment in cube segment delete confirm dialog > The delete button should not be enabled without any segment in cube segment > delete confirm dialog > - > > Key: KYLIN-3280 > URL: https://issues.apache.org/jira/browse/KYLIN-3280 > Project: Kylin > Issue Type: Bug > Components: Web >Affects Versions: v2.3.0 >Reporter: Peng Xing >Assignee: Peng Xing >Priority: Minor > Fix For: v2.3.1 > > Attachments: delete_segment.png > > > 1. Open cube list, choose one disabled cube, then select 'Delete Segment'; > 2. The Delete button is enabled without any segment, and if you click it, it > has no prompt. > please see the attachment picture. > -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (KYLIN-3236) The function 'reGenerateAdvancedDict()' has an error logical judgment, which will cause an exception when you edit the cube.
[ https://issues.apache.org/jira/browse/KYLIN-3236?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16396298#comment-16396298 ] ASF subversion and git services commented on KYLIN-3236: Commit 2a72dadd0b785c4bd18210230398471013eb1293 in kylin's branch refs/heads/2.3.x from [~xingpeng1] [ https://gitbox.apache.org/repos/asf?p=kylin.git;h=2a72dad ] KYLIN-3236 The function 'reGenerateAdvancedDict()' has an error logical judgment, which will cause an exception when you edit the cube. Signed-off-by: xingpeng1> The function 'reGenerateAdvancedDict()' has an error logical judgment, which > will cause an exception when you edit the cube. > > > Key: KYLIN-3236 > URL: https://issues.apache.org/jira/browse/KYLIN-3236 > Project: Kylin > Issue Type: Bug > Components: Web >Affects Versions: v2.3.0 >Reporter: Peng Xing >Assignee: Peng Xing >Priority: Major > Labels: patch > Fix For: v2.3.1 > > Attachments: > 0001-KYLIN-3236-The-function-reGenerateAdvancedDict-has-a.patch, 1.PNG, > 2.PNG, 3.PNG > > > # When remove deprecated distinct measures, the code has an error logical > judgment In function 'reGenerateAdvancedDict()', as follows: > {code:java} > //remove deprecated distinct measures > angular.forEach($scope.cubeMetaFrame.dictionaries, function (dict, index) > { > if (distinctMeasures.indexOf(dict.column) === -1 && > reuseColumns.indexOf(dict.column) === -1) { > $scope.cubeMetaFrame.dictionaries.splice(index, 1); > } > }); > {code} > This will result in accidental deletion of advanced dictionaries. > Please review the patch, thanks! -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (KYLIN-3233) CacheController can not handle if cacheKey has "/"
[ https://issues.apache.org/jira/browse/KYLIN-3233?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16396300#comment-16396300 ] ASF subversion and git services commented on KYLIN-3233: Commit f989aa57c0aa21ec7a0705a007b0bf652e0b31e1 in kylin's branch refs/heads/2.3.x from [~Aron.tao] [ https://gitbox.apache.org/repos/asf?p=kylin.git;h=f989aa5 ] KYLIN-3233, fix CacheController if cacheKey has "/". > CacheController can not handle if cacheKey has "/" > -- > > Key: KYLIN-3233 > URL: https://issues.apache.org/jira/browse/KYLIN-3233 > Project: Kylin > Issue Type: Improvement >Reporter: jiatao.tao >Assignee: jiatao.tao >Priority: Minor > Fix For: v2.3.1 > > -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (KYLIN-3119) A few bugs in the function 'massageSql' of 'QueryUtil.java'
[ https://issues.apache.org/jira/browse/KYLIN-3119?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16396302#comment-16396302 ] ASF subversion and git services commented on KYLIN-3119: Commit 348e73d762e0eee7165c1b70984e0f8d4586eab9 in kylin's branch refs/heads/2.3.x from pengjianhua [ https://gitbox.apache.org/repos/asf?p=kylin.git;h=348e73d ] KYLIN-3119 Fix bugs in the function 'massageSql' of 'QueryUtil.java' > A few bugs in the function 'massageSql' of 'QueryUtil.java' > --- > > Key: KYLIN-3119 > URL: https://issues.apache.org/jira/browse/KYLIN-3119 > Project: Kylin > Issue Type: Bug > Components: Query Engine >Reporter: peng.jianhua >Assignee: peng.jianhua >Priority: Major > Fix For: v2.3.1 > > Attachments: > 0001-KYLIN-3119-A-few-bugs-in-the-function-massageSql-of-.patch, > 0001-KYLIN-3119-add-test-cases.patch, > 0001-kylin-3119-add-more-test-cases-with-enter-and-space.patch, > 0001-kylin-3119.patch, 01.PNG, 02.PNG > > > in the function 'massageSql' of 'QueryUtil.java',there are a few bugs: > 01: > {code:java} > while (sql.endsWith(";")) > sql = sql.substring(0, sql.length() - 1); > {code} > if the sql end with ';' and after the ';' still has comments,will be > error.Because the sql will add ("\nLIMIT " + limit) at the end. > 02: > {code:java} > if (limit > 0 && !sql.toLowerCase().contains("limit")) { > sql += ("\nLIMIT " + limit); > } > if (offset > 0 && !sql.toLowerCase().contains("offset")) { > sql += ("\nOFFSET " + offset); > } > {code} > if the sql already has word 'limit' in it,such as Alias,Subquery,Comments,the > ‘limit’ in the Input box will be invalid. > for example,the sql has subquery,and there is 'limit' in subquery. > {code:java} > select KYLIN_SALES.PART_DT, count(KYLIN_SALES.PRICE) > from KYLIN_SALES > inner join (select ACCOUNT_ID, ACCOUNT_BUYER_LEVEL from KYLIN_ACCOUNT where > ACCOUNT_COUNTRY = 'US' limit 1) as TT > on KYLIN_SALES.BUYER_ID = TT.ACCOUNT_ID > group by KYLIN_SALES.PART_DT > {code} > the ‘limit’ in the Input box will be invalid.please refer to 01.png and > 02.png. > 03: > {code:java} > // https://issues.apache.org/jira/browse/KYLIN-2649 > if (kylinConfig.getForceLimit() > 0 && > !sql.toLowerCase().contains("limit") > && sql.toLowerCase().contains("*")) { > sql += ("\nLIMIT " + kylinConfig.getForceLimit()); > } > {code} > Because KYLIN-2649 is still unresolved,so I didn't change the code,but it > has same 'limit' word bugs like above. > And there are some situations that the sql contains \*,such as > {code:java}count(*),kylin_sales.*{code} > Maybe the \* in subquery too. > it seems improperly to deal with the sql just use {code:java} > sql.toLowerCase().contains("*") > {code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (KYLIN-3287) When a shard by column is in dict encoding, dict building error.
[ https://issues.apache.org/jira/browse/KYLIN-3287?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16396301#comment-16396301 ] ASF subversion and git services commented on KYLIN-3287: Commit 80d01612462bcca129bc950fe101db4c8e9cf6f4 in kylin's branch refs/heads/2.3.x from [~Aron.tao] [ https://gitbox.apache.org/repos/asf?p=kylin.git;h=80d0161 ] KYLIN-3287, fix when a shard by column is in dict encoding, dict building error. > When a shard by column is in dict encoding, dict building error. > > > Key: KYLIN-3287 > URL: https://issues.apache.org/jira/browse/KYLIN-3287 > Project: Kylin > Issue Type: Bug >Affects Versions: v2.3.0 >Reporter: jiatao.tao >Assignee: jiatao.tao >Priority: Major > Fix For: v2.3.1 > > Attachments: image-2018-03-12-14-14-50-112.png, > image-2018-03-12-14-14-59-193.png, image-2018-03-12-14-15-42-046.png, > image-2018-03-12-14-16-38-657.png, image-2018-03-12-14-17-46-780.png > > > In dict encoding. > !image-2018-03-12-14-14-50-112.png|width=544,height=84! > !image-2018-03-12-14-14-59-193.png|width=535,height=631! > In int encoding > !image-2018-03-12-14-15-42-046.png|width=544,height=87! > !image-2018-03-12-14-16-38-657.png! -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Resolved] (KYLIN-3280) The delete button should not be enabled without any segment in cube segment delete confirm dialog
[ https://issues.apache.org/jira/browse/KYLIN-3280?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Billy Liu resolved KYLIN-3280. -- Resolution: Fixed > The delete button should not be enabled without any segment in cube segment > delete confirm dialog > - > > Key: KYLIN-3280 > URL: https://issues.apache.org/jira/browse/KYLIN-3280 > Project: Kylin > Issue Type: Bug > Components: Web >Affects Versions: v2.3.0 >Reporter: Peng Xing >Assignee: Peng Xing >Priority: Minor > Fix For: v2.3.1 > > Attachments: delete_segment.png > > > 1. Open cube list, choose one disabled cube, then select 'Delete Segment'; > 2. The Delete button is enabled without any segment, and if you click it, it > has no prompt. > please see the attachment picture. > -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (KYLIN-3280) The delete button should not be enabled without any segment in cube segment delete confirm dialog
[ https://issues.apache.org/jira/browse/KYLIN-3280?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Billy Liu updated KYLIN-3280: - Affects Version/s: (was: v2.4.0) v2.3.0 > The delete button should not be enabled without any segment in cube segment > delete confirm dialog > - > > Key: KYLIN-3280 > URL: https://issues.apache.org/jira/browse/KYLIN-3280 > Project: Kylin > Issue Type: Bug > Components: Web >Affects Versions: v2.3.0 >Reporter: Peng Xing >Assignee: Peng Xing >Priority: Minor > Fix For: v2.3.1 > > Attachments: delete_segment.png > > > 1. Open cube list, choose one disabled cube, then select 'Delete Segment'; > 2. The Delete button is enabled without any segment, and if you click it, it > has no prompt. > please see the attachment picture. > -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (KYLIN-3280) The delete button should not be enabled without any segment in cube segment delete confirm dialog
[ https://issues.apache.org/jira/browse/KYLIN-3280?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16396295#comment-16396295 ] ASF GitHub Bot commented on KYLIN-3280: --- yiming187 closed pull request #113: KYLIN-3280 URL: https://github.com/apache/kylin/pull/113 This is a PR merged from a forked repository. As GitHub hides the original diff on merge, it is displayed below for the sake of provenance: As this is a foreign pull request (from a fork), the diff is supplied below (as it won't show otherwise due to GitHub magic): diff --git a/webapp/app/partials/cubes/cube_delete_segment.html b/webapp/app/partials/cubes/cube_delete_segment.html index 8500f3f7a9..93356eeeae 100644 --- a/webapp/app/partials/cubes/cube_delete_segment.html +++ b/webapp/app/partials/cubes/cube_delete_segment.html @@ -83,7 +83,7 @@ CUBE SEGMENT DELETE CONFIRM Close -Delete +Delete \ No newline at end of file This is an automated message from the Apache Git Service. To respond to the message, please log on GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: us...@infra.apache.org > The delete button should not be enabled without any segment in cube segment > delete confirm dialog > - > > Key: KYLIN-3280 > URL: https://issues.apache.org/jira/browse/KYLIN-3280 > Project: Kylin > Issue Type: Bug > Components: Web >Affects Versions: v2.4.0 >Reporter: Peng Xing >Assignee: Peng Xing >Priority: Minor > Fix For: v2.3.1 > > Attachments: delete_segment.png > > > 1. Open cube list, choose one disabled cube, then select 'Delete Segment'; > 2. The Delete button is enabled without any segment, and if you click it, it > has no prompt. > please see the attachment picture. > -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (KYLIN-3280) The delete button should not be enabled without any segment in cube segment delete confirm dialog
[ https://issues.apache.org/jira/browse/KYLIN-3280?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16396296#comment-16396296 ] ASF subversion and git services commented on KYLIN-3280: Commit ef89806e67145f771aedbb60585e2db05d42076e in kylin's branch refs/heads/master from [~xingpeng1] [ https://gitbox.apache.org/repos/asf?p=kylin.git;h=ef89806 ] KYLIN-3280 The delete button should not be enabled without any segment in cube segment delete confirm dialog > The delete button should not be enabled without any segment in cube segment > delete confirm dialog > - > > Key: KYLIN-3280 > URL: https://issues.apache.org/jira/browse/KYLIN-3280 > Project: Kylin > Issue Type: Bug > Components: Web >Affects Versions: v2.4.0 >Reporter: Peng Xing >Assignee: Peng Xing >Priority: Minor > Fix For: v2.3.1 > > Attachments: delete_segment.png > > > 1. Open cube list, choose one disabled cube, then select 'Delete Segment'; > 2. The Delete button is enabled without any segment, and if you click it, it > has no prompt. > please see the attachment picture. > -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Resolved] (KYLIN-3119) A few bugs in the function 'massageSql' of 'QueryUtil.java'
[ https://issues.apache.org/jira/browse/KYLIN-3119?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Billy Liu resolved KYLIN-3119. -- Resolution: Fixed > A few bugs in the function 'massageSql' of 'QueryUtil.java' > --- > > Key: KYLIN-3119 > URL: https://issues.apache.org/jira/browse/KYLIN-3119 > Project: Kylin > Issue Type: Bug > Components: Query Engine >Reporter: peng.jianhua >Assignee: peng.jianhua >Priority: Major > Fix For: v2.3.1 > > Attachments: > 0001-KYLIN-3119-A-few-bugs-in-the-function-massageSql-of-.patch, > 0001-KYLIN-3119-add-test-cases.patch, > 0001-kylin-3119-add-more-test-cases-with-enter-and-space.patch, > 0001-kylin-3119.patch, 01.PNG, 02.PNG > > > in the function 'massageSql' of 'QueryUtil.java',there are a few bugs: > 01: > {code:java} > while (sql.endsWith(";")) > sql = sql.substring(0, sql.length() - 1); > {code} > if the sql end with ';' and after the ';' still has comments,will be > error.Because the sql will add ("\nLIMIT " + limit) at the end. > 02: > {code:java} > if (limit > 0 && !sql.toLowerCase().contains("limit")) { > sql += ("\nLIMIT " + limit); > } > if (offset > 0 && !sql.toLowerCase().contains("offset")) { > sql += ("\nOFFSET " + offset); > } > {code} > if the sql already has word 'limit' in it,such as Alias,Subquery,Comments,the > ‘limit’ in the Input box will be invalid. > for example,the sql has subquery,and there is 'limit' in subquery. > {code:java} > select KYLIN_SALES.PART_DT, count(KYLIN_SALES.PRICE) > from KYLIN_SALES > inner join (select ACCOUNT_ID, ACCOUNT_BUYER_LEVEL from KYLIN_ACCOUNT where > ACCOUNT_COUNTRY = 'US' limit 1) as TT > on KYLIN_SALES.BUYER_ID = TT.ACCOUNT_ID > group by KYLIN_SALES.PART_DT > {code} > the ‘limit’ in the Input box will be invalid.please refer to 01.png and > 02.png. > 03: > {code:java} > // https://issues.apache.org/jira/browse/KYLIN-2649 > if (kylinConfig.getForceLimit() > 0 && > !sql.toLowerCase().contains("limit") > && sql.toLowerCase().contains("*")) { > sql += ("\nLIMIT " + kylinConfig.getForceLimit()); > } > {code} > Because KYLIN-2649 is still unresolved,so I didn't change the code,but it > has same 'limit' word bugs like above. > And there are some situations that the sql contains \*,such as > {code:java}count(*),kylin_sales.*{code} > Maybe the \* in subquery too. > it seems improperly to deal with the sql just use {code:java} > sql.toLowerCase().contains("*") > {code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (KYLIN-3119) A few bugs in the function 'massageSql' of 'QueryUtil.java'
[ https://issues.apache.org/jira/browse/KYLIN-3119?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16396288#comment-16396288 ] ASF subversion and git services commented on KYLIN-3119: Commit a74cb8a8258d46e2021aacd63c3a6d131b09ede1 in kylin's branch refs/heads/master from pengjianhua [ https://gitbox.apache.org/repos/asf?p=kylin.git;h=a74cb8a ] KYLIN-3119 Fix bugs in the function 'massageSql' of 'QueryUtil.java' > A few bugs in the function 'massageSql' of 'QueryUtil.java' > --- > > Key: KYLIN-3119 > URL: https://issues.apache.org/jira/browse/KYLIN-3119 > Project: Kylin > Issue Type: Bug > Components: Query Engine >Reporter: peng.jianhua >Assignee: peng.jianhua >Priority: Major > Fix For: v2.3.1 > > Attachments: > 0001-KYLIN-3119-A-few-bugs-in-the-function-massageSql-of-.patch, > 0001-KYLIN-3119-add-test-cases.patch, > 0001-kylin-3119-add-more-test-cases-with-enter-and-space.patch, > 0001-kylin-3119.patch, 01.PNG, 02.PNG > > > in the function 'massageSql' of 'QueryUtil.java',there are a few bugs: > 01: > {code:java} > while (sql.endsWith(";")) > sql = sql.substring(0, sql.length() - 1); > {code} > if the sql end with ';' and after the ';' still has comments,will be > error.Because the sql will add ("\nLIMIT " + limit) at the end. > 02: > {code:java} > if (limit > 0 && !sql.toLowerCase().contains("limit")) { > sql += ("\nLIMIT " + limit); > } > if (offset > 0 && !sql.toLowerCase().contains("offset")) { > sql += ("\nOFFSET " + offset); > } > {code} > if the sql already has word 'limit' in it,such as Alias,Subquery,Comments,the > ‘limit’ in the Input box will be invalid. > for example,the sql has subquery,and there is 'limit' in subquery. > {code:java} > select KYLIN_SALES.PART_DT, count(KYLIN_SALES.PRICE) > from KYLIN_SALES > inner join (select ACCOUNT_ID, ACCOUNT_BUYER_LEVEL from KYLIN_ACCOUNT where > ACCOUNT_COUNTRY = 'US' limit 1) as TT > on KYLIN_SALES.BUYER_ID = TT.ACCOUNT_ID > group by KYLIN_SALES.PART_DT > {code} > the ‘limit’ in the Input box will be invalid.please refer to 01.png and > 02.png. > 03: > {code:java} > // https://issues.apache.org/jira/browse/KYLIN-2649 > if (kylinConfig.getForceLimit() > 0 && > !sql.toLowerCase().contains("limit") > && sql.toLowerCase().contains("*")) { > sql += ("\nLIMIT " + kylinConfig.getForceLimit()); > } > {code} > Because KYLIN-2649 is still unresolved,so I didn't change the code,but it > has same 'limit' word bugs like above. > And there are some situations that the sql contains \*,such as > {code:java}count(*),kylin_sales.*{code} > Maybe the \* in subquery too. > it seems improperly to deal with the sql just use {code:java} > sql.toLowerCase().contains("*") > {code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Resolved] (KYLIN-3287) When a shard by column is in dict encoding, dict building error.
[ https://issues.apache.org/jira/browse/KYLIN-3287?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Billy Liu resolved KYLIN-3287. -- Resolution: Fixed > When a shard by column is in dict encoding, dict building error. > > > Key: KYLIN-3287 > URL: https://issues.apache.org/jira/browse/KYLIN-3287 > Project: Kylin > Issue Type: Bug >Affects Versions: v2.3.0 >Reporter: jiatao.tao >Assignee: jiatao.tao >Priority: Major > Fix For: v2.3.1 > > Attachments: image-2018-03-12-14-14-50-112.png, > image-2018-03-12-14-14-59-193.png, image-2018-03-12-14-15-42-046.png, > image-2018-03-12-14-16-38-657.png, image-2018-03-12-14-17-46-780.png > > > In dict encoding. > !image-2018-03-12-14-14-50-112.png|width=544,height=84! > !image-2018-03-12-14-14-59-193.png|width=535,height=631! > In int encoding > !image-2018-03-12-14-15-42-046.png|width=544,height=87! > !image-2018-03-12-14-16-38-657.png! -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Assigned] (KYLIN-3262) Produce jacoco exec files for integration test
[ https://issues.apache.org/jira/browse/KYLIN-3262?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Billy Liu reassigned KYLIN-3262: Assignee: Zhong Yanghong > Produce jacoco exec files for integration test > -- > > Key: KYLIN-3262 > URL: https://issues.apache.org/jira/browse/KYLIN-3262 > Project: Kylin > Issue Type: Task >Reporter: Zhong Yanghong >Assignee: Zhong Yanghong >Priority: Major > Attachments: APACHE-KYLIN-3262.patch > > > Currently to calculate code coverage, kylin only considers UT. However, IT > also covers lots of code. It's better to include this for code coverage. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (KYLIN-3278) Kylin should not distribute hive table by random at Step1
[ https://issues.apache.org/jira/browse/KYLIN-3278?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Billy Liu updated KYLIN-3278: - Fix Version/s: v2.3.1 > Kylin should not distribute hive table by random at Step1 > - > > Key: KYLIN-3278 > URL: https://issues.apache.org/jira/browse/KYLIN-3278 > Project: Kylin > Issue Type: Improvement > Components: Job Engine >Affects Versions: v2.3.0 >Reporter: Chuqian Yu >Assignee: Wang Cheng >Priority: Major > Fix For: v2.3.1 > > > Hi,Kylin team. > When I upgrade from 2.2.0 to 2.3.0 ,I found that the step.1 "Create > Intermediate Flat Hive Table" of cube build was much slower than before, > because Kylin distribute hive table by random when created it in version > 2.3.0 . I wander is it necessary? Because > kylin.source.hive.redistribute-flat-table was set to true by default, so we > will do the distribution job at Step.2 "Redistribute Flat Hive Table". > Best regards, > Chuqian Yu -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Resolved] (KYLIN-3275) Add unit test for StorageCleanupJob
[ https://issues.apache.org/jira/browse/KYLIN-3275?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Billy Liu resolved KYLIN-3275. -- Resolution: Fixed Fix Version/s: v2.4.0 > Add unit test for StorageCleanupJob > --- > > Key: KYLIN-3275 > URL: https://issues.apache.org/jira/browse/KYLIN-3275 > Project: Kylin > Issue Type: Improvement >Reporter: jiatao.tao >Assignee: jiatao.tao >Priority: Trivial > Fix For: v2.4.0 > > -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Resolved] (KYLIN-3174) Default scheduler enhancement
[ https://issues.apache.org/jira/browse/KYLIN-3174?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Billy Liu resolved KYLIN-3174. -- Resolution: Fixed Fix Version/s: v2.4.0 > Default scheduler enhancement > - > > Key: KYLIN-3174 > URL: https://issues.apache.org/jira/browse/KYLIN-3174 > Project: Kylin > Issue Type: Improvement >Reporter: jiatao.tao >Assignee: jiatao.tao >Priority: Minor > Fix For: v2.4.0 > > -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Resolved] (KYLIN-3271) Optimize sub-path check of ResourceTool
[ https://issues.apache.org/jira/browse/KYLIN-3271?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Billy Liu resolved KYLIN-3271. -- Resolution: Fixed > Optimize sub-path check of ResourceTool > --- > > Key: KYLIN-3271 > URL: https://issues.apache.org/jira/browse/KYLIN-3271 > Project: Kylin > Issue Type: Improvement > Components: Metadata >Affects Versions: v2.2.0 >Reporter: nichunen >Assignee: nichunen >Priority: Minor > Fix For: v2.4.0 > > > kylin uses class org.apache.kylin.common.persistence.ResourceTool to do > metadata download, upload, remove, etc. The algorithm for resource > transversal is not very effective. For instance, for an "execute_output" with > key "/execute_output/\{uuid}", the algorithm will try to check whether it's a > folder with sub-resources, this makes un-necessary time cost, and in cases of > metadata with lots of jobs, it may last for a long time before the finish. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Resolved] (KYLIN-3248) Add batch grant API for project ACL.
[ https://issues.apache.org/jira/browse/KYLIN-3248?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Billy Liu resolved KYLIN-3248. -- Resolution: Fixed Fix Version/s: v2.4.0 > Add batch grant API for project ACL. > > > Key: KYLIN-3248 > URL: https://issues.apache.org/jira/browse/KYLIN-3248 > Project: Kylin > Issue Type: Improvement >Reporter: jiatao.tao >Assignee: jiatao.tao >Priority: Major > Fix For: v2.4.0 > > > Project ACL stored in one file, and leads to adding huge ACLs inefficient. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Resolved] (KYLIN-3266) Improve CI coverage
[ https://issues.apache.org/jira/browse/KYLIN-3266?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Billy Liu resolved KYLIN-3266. -- Resolution: Fixed Fix Version/s: v2.4.0 > Improve CI coverage > --- > > Key: KYLIN-3266 > URL: https://issues.apache.org/jira/browse/KYLIN-3266 > Project: Kylin > Issue Type: Improvement >Affects Versions: v2.4.0 >Reporter: liyang >Assignee: liyang >Priority: Major > Fix For: v2.4.0 > > > The current CI, aka BuildCubeWithEngine, only test merge on the MR engine. > The merge operation is not tested on Spark engine. Need to improve the test > coverage. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Resolved] (KYLIN-3220) Add manager for project ACL.
[ https://issues.apache.org/jira/browse/KYLIN-3220?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Billy Liu resolved KYLIN-3220. -- Resolution: Fixed Fix Version/s: v2.4.0 > Add manager for project ACL. > > > Key: KYLIN-3220 > URL: https://issues.apache.org/jira/browse/KYLIN-3220 > Project: Kylin > Issue Type: Improvement >Reporter: jiatao.tao >Assignee: jiatao.tao >Priority: Major > Fix For: v2.4.0 > > > AclRecord need to be cached. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Resolved] (KYLIN-3251) Add a hook that can customer made test_case_data
[ https://issues.apache.org/jira/browse/KYLIN-3251?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Billy Liu resolved KYLIN-3251. -- Resolution: Fixed Fix Version/s: v2.4.0 > Add a hook that can customer made test_case_data > > > Key: KYLIN-3251 > URL: https://issues.apache.org/jira/browse/KYLIN-3251 > Project: Kylin > Issue Type: Improvement >Reporter: jiatao.tao >Assignee: jiatao.tao >Priority: Minor > Fix For: v2.4.0 > > -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Resolved] (KYLIN-3267) add override MR config at project/cube level only for mem-hungry build steps
[ https://issues.apache.org/jira/browse/KYLIN-3267?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Billy Liu resolved KYLIN-3267. -- Resolution: Fixed Fix Version/s: v2.4.0 > add override MR config at project/cube level only for mem-hungry build steps > - > > Key: KYLIN-3267 > URL: https://issues.apache.org/jira/browse/KYLIN-3267 > Project: Kylin > Issue Type: Improvement >Reporter: Yifei Wu >Assignee: Yifei Wu >Priority: Major > Fix For: v2.4.0 > > > Currently, users can override MR config at project/cube level via kylin > properties {{kylin.engine.mr.config-override.}} > However, this applies to all MR steps. It is more reasonable to add > override-configs only for certain memory-hungry steps like in-mem cubing. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Resolved] (KYLIN-3233) CacheController can not handle if cacheKey has "/"
[ https://issues.apache.org/jira/browse/KYLIN-3233?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Billy Liu resolved KYLIN-3233. -- Resolution: Fixed Fix Version/s: v2.3.1 > CacheController can not handle if cacheKey has "/" > -- > > Key: KYLIN-3233 > URL: https://issues.apache.org/jira/browse/KYLIN-3233 > Project: Kylin > Issue Type: Improvement >Reporter: jiatao.tao >Assignee: jiatao.tao >Priority: Minor > Fix For: v2.3.1 > > -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Resolved] (KYLIN-3234) ResourceStore should add a API that can recursively list path.
[ https://issues.apache.org/jira/browse/KYLIN-3234?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Billy Liu resolved KYLIN-3234. -- Resolution: Fixed Fix Version/s: v2.4.0 > ResourceStore should add a API that can recursively list path. > -- > > Key: KYLIN-3234 > URL: https://issues.apache.org/jira/browse/KYLIN-3234 > Project: Kylin > Issue Type: Improvement >Reporter: jiatao.tao >Assignee: jiatao.tao >Priority: Minor > Fix For: v2.4.0 > > -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (KYLIN-3236) The function 'reGenerateAdvancedDict()' has an error logical judgment, which will cause an exception when you edit the cube.
[ https://issues.apache.org/jira/browse/KYLIN-3236?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Billy Liu updated KYLIN-3236: - Fix Version/s: (was: v2.4.0) v2.3.1 > The function 'reGenerateAdvancedDict()' has an error logical judgment, which > will cause an exception when you edit the cube. > > > Key: KYLIN-3236 > URL: https://issues.apache.org/jira/browse/KYLIN-3236 > Project: Kylin > Issue Type: Bug > Components: Web >Affects Versions: v2.3.0 >Reporter: Peng Xing >Assignee: Peng Xing >Priority: Major > Labels: patch > Fix For: v2.3.1 > > Attachments: > 0001-KYLIN-3236-The-function-reGenerateAdvancedDict-has-a.patch, 1.PNG, > 2.PNG, 3.PNG > > > # When remove deprecated distinct measures, the code has an error logical > judgment In function 'reGenerateAdvancedDict()', as follows: > {code:java} > //remove deprecated distinct measures > angular.forEach($scope.cubeMetaFrame.dictionaries, function (dict, index) > { > if (distinctMeasures.indexOf(dict.column) === -1 && > reuseColumns.indexOf(dict.column) === -1) { > $scope.cubeMetaFrame.dictionaries.splice(index, 1); > } > }); > {code} > This will result in accidental deletion of advanced dictionaries. > Please review the patch, thanks! -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (KYLIN-3119) A few bugs in the function 'massageSql' of 'QueryUtil.java'
[ https://issues.apache.org/jira/browse/KYLIN-3119?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Billy Liu updated KYLIN-3119: - Fix Version/s: v2.3.1 > A few bugs in the function 'massageSql' of 'QueryUtil.java' > --- > > Key: KYLIN-3119 > URL: https://issues.apache.org/jira/browse/KYLIN-3119 > Project: Kylin > Issue Type: Bug > Components: Query Engine >Reporter: peng.jianhua >Assignee: peng.jianhua >Priority: Major > Fix For: v2.3.1 > > Attachments: > 0001-KYLIN-3119-A-few-bugs-in-the-function-massageSql-of-.patch, > 0001-KYLIN-3119-add-test-cases.patch, > 0001-kylin-3119-add-more-test-cases-with-enter-and-space.patch, > 0001-kylin-3119.patch, 01.PNG, 02.PNG > > > in the function 'massageSql' of 'QueryUtil.java',there are a few bugs: > 01: > {code:java} > while (sql.endsWith(";")) > sql = sql.substring(0, sql.length() - 1); > {code} > if the sql end with ';' and after the ';' still has comments,will be > error.Because the sql will add ("\nLIMIT " + limit) at the end. > 02: > {code:java} > if (limit > 0 && !sql.toLowerCase().contains("limit")) { > sql += ("\nLIMIT " + limit); > } > if (offset > 0 && !sql.toLowerCase().contains("offset")) { > sql += ("\nOFFSET " + offset); > } > {code} > if the sql already has word 'limit' in it,such as Alias,Subquery,Comments,the > ‘limit’ in the Input box will be invalid. > for example,the sql has subquery,and there is 'limit' in subquery. > {code:java} > select KYLIN_SALES.PART_DT, count(KYLIN_SALES.PRICE) > from KYLIN_SALES > inner join (select ACCOUNT_ID, ACCOUNT_BUYER_LEVEL from KYLIN_ACCOUNT where > ACCOUNT_COUNTRY = 'US' limit 1) as TT > on KYLIN_SALES.BUYER_ID = TT.ACCOUNT_ID > group by KYLIN_SALES.PART_DT > {code} > the ‘limit’ in the Input box will be invalid.please refer to 01.png and > 02.png. > 03: > {code:java} > // https://issues.apache.org/jira/browse/KYLIN-2649 > if (kylinConfig.getForceLimit() > 0 && > !sql.toLowerCase().contains("limit") > && sql.toLowerCase().contains("*")) { > sql += ("\nLIMIT " + kylinConfig.getForceLimit()); > } > {code} > Because KYLIN-2649 is still unresolved,so I didn't change the code,but it > has same 'limit' word bugs like above. > And there are some situations that the sql contains \*,such as > {code:java}count(*),kylin_sales.*{code} > Maybe the \* in subquery too. > it seems improperly to deal with the sql just use {code:java} > sql.toLowerCase().contains("*") > {code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (KYLIN-3258) No check for duplicate cube name when creating a hybrid cube
[ https://issues.apache.org/jira/browse/KYLIN-3258?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Billy Liu updated KYLIN-3258: - Fix Version/s: v2.3.1 > No check for duplicate cube name when creating a hybrid cube > > > Key: KYLIN-3258 > URL: https://issues.apache.org/jira/browse/KYLIN-3258 > Project: Kylin > Issue Type: Bug > Components: Metadata >Affects Versions: v2.2.0 > Environment: HDP 2.5.6, Kylin 2.2 >Reporter: Vsevolod Ostapenko >Priority: Minor > Fix For: v2.3.1 > > > When loading hybrid cube definitions via REST API, there is no check for > duplicate cube names is the list. If due to a user error or incorrectly > generated list of cubes by an external application/script the same cube name > is listed more than once, new or updated hybrid cube will contain the same > cube listed multiple times. > It does not seem to cause any immediate issues with querying, but it's just > not right. REST API should throw and exception, when the same cube name is > listed multiple times. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (KYLIN-3267) add override MR config at project/cube level only for mem-hungry build steps
[ https://issues.apache.org/jira/browse/KYLIN-3267?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Billy Liu updated KYLIN-3267: - Issue Type: Improvement (was: Bug) > add override MR config at project/cube level only for mem-hungry build steps > - > > Key: KYLIN-3267 > URL: https://issues.apache.org/jira/browse/KYLIN-3267 > Project: Kylin > Issue Type: Improvement >Reporter: Yifei Wu >Assignee: Yifei Wu >Priority: Major > > Currently, users can override MR config at project/cube level via kylin > properties {{kylin.engine.mr.config-override.}} > However, this applies to all MR steps. It is more reasonable to add > override-configs only for certain memory-hungry steps like in-mem cubing. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (KYLIN-3270) Add integration test for Optimize Job
[ https://issues.apache.org/jira/browse/KYLIN-3270?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Billy Liu updated KYLIN-3270: - Fix Version/s: v2.3.1 > Add integration test for Optimize Job > - > > Key: KYLIN-3270 > URL: https://issues.apache.org/jira/browse/KYLIN-3270 > Project: Kylin > Issue Type: Sub-task > Components: Tools, Build and Test >Reporter: Zhong Yanghong >Assignee: Zhong Yanghong >Priority: Critical > Fix For: v2.3.1 > > Attachments: APACHE-KYLIN-3270.patch > > -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (KYLIN-3277) Kylin should override hiveconf settings when connecting to hive using jdbc
[ https://issues.apache.org/jira/browse/KYLIN-3277?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Billy Liu updated KYLIN-3277: - Fix Version/s: v2.3.1 > Kylin should override hiveconf settings when connecting to hive using jdbc > -- > > Key: KYLIN-3277 > URL: https://issues.apache.org/jira/browse/KYLIN-3277 > Project: Kylin > Issue Type: Bug >Reporter: Chuqian Yu >Priority: Major > Labels: patch > Fix For: v2.3.1 > > Attachments: 0001-KYLIN-3277.patch > > > Hi, kylin developers. My cube building procedure failing at Step 2 > "Redistribute Flat Hive Table" because Kylin always trying to submit a mr job > to the default yarn queue. > > I have overrided the mapred.job.queue.name property in both > kylin_hive_conf.xml and kylin.properties but it doesn't work. > > kylin.properties > ``` > kylin.source.hive.beeline-params=-n hive -p hive --hiveconf > mapred.job.queue.name=myQueue -u > "jdbc:hive2://myZk:2181/;serviceDiscoveryMode=zooKeeper;" > ``` > > kylin_hive_conf.xml > ``` > > mapred.job.queue.name > myQueue > > ``` > > After digging into the source code ,I found that kylin try to get the row > count of hive table before redistributing it. But it dose not override the > hive configuration when using jdbc to connect to hive server. > > > -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (KYLIN-3276) query with dynamic parameter get the same query result
[ https://issues.apache.org/jira/browse/KYLIN-3276?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Billy Liu updated KYLIN-3276: - Fix Version/s: v2.3.1 > query with dynamic parameter get the same query result > -- > > Key: KYLIN-3276 > URL: https://issues.apache.org/jira/browse/KYLIN-3276 > Project: Kylin > Issue Type: Bug > Components: Driver - JDBC, Query Engine >Affects Versions: v2.2.0 > Environment: Kylin 2.2.0, JDK 1.8 >Reporter: ZHAOXIXIN >Assignee: nichunen >Priority: Major > Fix For: v2.3.1 > > > sql:"select distinct uid from table where daytime=? limit 70" > ps.setString(1,"2018-01-03") > store the result to ArrayList, and print the size of ArrayList. > when I set the daytime to different dates, the same result I got. > I changed the sql, just change limit value for example > sql:"select distinct uid from table where daytime=? limit 60" > then I got the right value the same like query from GUI:count (distinct uid) -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (KYLIN-3285) "Value NNN not exists" error run executing query
[ https://issues.apache.org/jira/browse/KYLIN-3285?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Billy Liu updated KYLIN-3285: - Fix Version/s: v2.3.1 > "Value NNN not exists" error run executing query > - > > Key: KYLIN-3285 > URL: https://issues.apache.org/jira/browse/KYLIN-3285 > Project: Kylin > Issue Type: Bug > Components: Query Engine >Affects Versions: v2.3.0 >Reporter: Shaofeng SHI >Priority: Major > Fix For: v2.3.1 > > Attachments: cube (1).json, kylin.log > > > Reported by community user zxxb...@163.com: > > {color:#b94a48}Kylin version update from 2.2.0 to 2.3.0; cube was build > before update, and query without error.{color} > {color:#b94a48}After updatge to version 2.3.0 and query {color}"select > count(userid) num,day_time from record_ap group by day_time LIMIT > 1000{color:#b94a48}”{color} > {color:#b94a48}show errors below:{color} > Column 0 value '2018-03-06' met dictionary error: Value '2018-03-06' > (2018-03-06) not exists! while executing SQL: "select count(userid) > num,day_time from record_ap group by day_time LIMIT 1000” > > {color:#b94a48}Where {color}{color:#b94a48}'2018-03-06’ come from? I was > fully confused.{color} > {color:#b94a48}Cube have several segments:{color} > {color:#b94a48}Starttime-endtime{color} > {color:#b94a48}20180101-20180225{color} > 20180225-20180304 > > Attached the log and cube JSON. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (KYLIN-3280) The delete button should not be enabled without any segment in cube segment delete confirm dialog
[ https://issues.apache.org/jira/browse/KYLIN-3280?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Billy Liu updated KYLIN-3280: - Fix Version/s: v2.3.1 > The delete button should not be enabled without any segment in cube segment > delete confirm dialog > - > > Key: KYLIN-3280 > URL: https://issues.apache.org/jira/browse/KYLIN-3280 > Project: Kylin > Issue Type: Bug > Components: Web >Affects Versions: v2.4.0 >Reporter: Peng Xing >Assignee: Peng Xing >Priority: Minor > Fix For: v2.3.1 > > Attachments: delete_segment.png > > > 1. Open cube list, choose one disabled cube, then select 'Delete Segment'; > 2. The Delete button is enabled without any segment, and if you click it, it > has no prompt. > please see the attachment picture. > -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (KYLIN-3288) "Sqoop To Flat Hive Table" step should specify "mapreduce.queue.name"
[ https://issues.apache.org/jira/browse/KYLIN-3288?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Billy Liu updated KYLIN-3288: - Fix Version/s: v2.3.1 > "Sqoop To Flat Hive Table" step should specify "mapreduce.queue.name" > - > > Key: KYLIN-3288 > URL: https://issues.apache.org/jira/browse/KYLIN-3288 > Project: Kylin > Issue Type: Bug > Components: RDBMS Source >Reporter: Shaoxiong Zhan >Assignee: Shaoxiong Zhan >Priority: Major > Fix For: v2.3.1 > > -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (KYLIN-3287) When a shard by column is in dict encoding, dict building error.
[ https://issues.apache.org/jira/browse/KYLIN-3287?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Billy Liu updated KYLIN-3287: - Fix Version/s: v2.3.1 > When a shard by column is in dict encoding, dict building error. > > > Key: KYLIN-3287 > URL: https://issues.apache.org/jira/browse/KYLIN-3287 > Project: Kylin > Issue Type: Bug >Affects Versions: v2.3.0 >Reporter: jiatao.tao >Assignee: jiatao.tao >Priority: Major > Fix For: v2.3.1 > > Attachments: image-2018-03-12-14-14-50-112.png, > image-2018-03-12-14-14-59-193.png, image-2018-03-12-14-15-42-046.png, > image-2018-03-12-14-16-38-657.png, image-2018-03-12-14-17-46-780.png > > > In dict encoding. > !image-2018-03-12-14-14-50-112.png|width=544,height=84! > !image-2018-03-12-14-14-59-193.png|width=535,height=631! > In int encoding > !image-2018-03-12-14-15-42-046.png|width=544,height=87! > !image-2018-03-12-14-16-38-657.png! -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (KYLIN-3287) When a shard by column is in dict encoding, dict building error.
[ https://issues.apache.org/jira/browse/KYLIN-3287?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Billy Liu updated KYLIN-3287: - Affects Version/s: v2.3.0 > When a shard by column is in dict encoding, dict building error. > > > Key: KYLIN-3287 > URL: https://issues.apache.org/jira/browse/KYLIN-3287 > Project: Kylin > Issue Type: Bug >Affects Versions: v2.3.0 >Reporter: jiatao.tao >Assignee: jiatao.tao >Priority: Major > Attachments: image-2018-03-12-14-14-50-112.png, > image-2018-03-12-14-14-59-193.png, image-2018-03-12-14-15-42-046.png, > image-2018-03-12-14-16-38-657.png, image-2018-03-12-14-17-46-780.png > > > In dict encoding. > !image-2018-03-12-14-14-50-112.png|width=544,height=84! > !image-2018-03-12-14-14-59-193.png|width=535,height=631! > In int encoding > !image-2018-03-12-14-15-42-046.png|width=544,height=87! > !image-2018-03-12-14-16-38-657.png! -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Created] (KYLIN-3288) "Sqoop To Flat Hive Table" step should specify "mapreduce.queue.name"
Shaoxiong Zhan created KYLIN-3288: - Summary: "Sqoop To Flat Hive Table" step should specify "mapreduce.queue.name" Key: KYLIN-3288 URL: https://issues.apache.org/jira/browse/KYLIN-3288 Project: Kylin Issue Type: Bug Components: RDBMS Source Reporter: Shaoxiong Zhan Assignee: Shaoxiong Zhan -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (KYLIN-3287) When a shard by column is in dict encoding, dict building error.
[ https://issues.apache.org/jira/browse/KYLIN-3287?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16395175#comment-16395175 ] ASF GitHub Bot commented on KYLIN-3287: --- coveralls commented on issue #114: KYLIN-3287, fix when a shard by column is in dict encoding, dict buil… URL: https://github.com/apache/kylin/pull/114#issuecomment-372295747 ## Pull Request Test Coverage Report for [Build 3036](https://coveralls.io/builds/15926510) * **0** of **1** **(0.0%)** changed or added relevant line in **1** file are covered. * **12** unchanged lines in **3** files lost coverage. * Overall coverage decreased (**-0.02%**) to **23.885%** --- | Changes Missing Coverage | Covered Lines | Changed/Added Lines | % | | :-|--||---: | | [engine-mr/src/main/java/org/apache/kylin/engine/mr/steps/CreateDictionaryJob.java](https://coveralls.io/builds/15926510/source?filename=engine-mr%2Fsrc%2Fmain%2Fjava%2Forg%2Fapache%2Fkylin%2Fengine%2Fmr%2Fsteps%2FCreateDictionaryJob.java#L85) | 0 | 1 | 0.0% | Files with Coverage Reduction | New Missed Lines | % | | :-|--|--: | | [core-cube/src/main/java/org/apache/kylin/cube/cuboid/TreeCuboidScheduler.java](https://coveralls.io/builds/15926510/source?filename=core-cube%2Fsrc%2Fmain%2Fjava%2Forg%2Fapache%2Fkylin%2Fcube%2Fcuboid%2FTreeCuboidScheduler.java#L129) | 1 | 68.5% | | [core-metadata/src/main/java/org/apache/kylin/metadata/cachesync/Broadcaster.java](https://coveralls.io/builds/15926510/source?filename=core-metadata%2Fsrc%2Fmain%2Fjava%2Forg%2Fapache%2Fkylin%2Fmetadata%2Fcachesync%2FBroadcaster.java#L149) | 1 | 60.7% | | [storage-hbase/src/main/java/org/apache/kylin/storage/hbase/HBaseConnection.java](https://coveralls.io/builds/15926510/source?filename=storage-hbase%2Fsrc%2Fmain%2Fjava%2Forg%2Fapache%2Fkylin%2Fstorage%2Fhbase%2FHBaseConnection.java#L81) | 10 | 17.28% | | Totals | [![Coverage Status](https://coveralls.io/builds/15926510/badge)](https://coveralls.io/builds/15926510) | | :-- | --: | | Change from base [Build 3033](https://coveralls.io/builds/15913920): | -0.02% | | Covered Lines: | 14329 | | Relevant Lines: | 59992 | --- # - [Coveralls](https://coveralls.io) This is an automated message from the Apache Git Service. To respond to the message, please log on GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: us...@infra.apache.org > When a shard by column is in dict encoding, dict building error. > > > Key: KYLIN-3287 > URL: https://issues.apache.org/jira/browse/KYLIN-3287 > Project: Kylin > Issue Type: Bug >Reporter: jiatao.tao >Assignee: jiatao.tao >Priority: Major > Attachments: image-2018-03-12-14-14-50-112.png, > image-2018-03-12-14-14-59-193.png, image-2018-03-12-14-15-42-046.png, > image-2018-03-12-14-16-38-657.png, image-2018-03-12-14-17-46-780.png > > > In dict encoding. > !image-2018-03-12-14-14-50-112.png|width=544,height=84! > !image-2018-03-12-14-14-59-193.png|width=535,height=631! > In int encoding > !image-2018-03-12-14-15-42-046.png|width=544,height=87! > !image-2018-03-12-14-16-38-657.png! -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (KYLIN-3287) When a shard by column is in dict encoding, dict building error.
[ https://issues.apache.org/jira/browse/KYLIN-3287?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16395171#comment-16395171 ] ASF GitHub Bot commented on KYLIN-3287: --- codecov-io commented on issue #114: KYLIN-3287, fix when a shard by column is in dict encoding, dict buil… URL: https://github.com/apache/kylin/pull/114#issuecomment-372295252 # [Codecov](https://codecov.io/gh/apache/kylin/pull/114?src=pr=h1) Report > Merging [#114](https://codecov.io/gh/apache/kylin/pull/114?src=pr=desc) into [master](https://codecov.io/gh/apache/kylin/commit/06f497eb603134a6b0ddbfd88739ccaddab007fb?src=pr=desc) will **decrease** coverage by `0.02%`. > The diff coverage is `0%`. [![Impacted file tree graph](https://codecov.io/gh/apache/kylin/pull/114/graphs/tree.svg?token=JawVgbgsVo=pr=650=150)](https://codecov.io/gh/apache/kylin/pull/114?src=pr=tree) ```diff @@ Coverage Diff @@ ## master #114 +/- ## - Coverage 21.86% 21.84% -0.03% + Complexity 3887 3886 -1 Files 996 996 Lines 5999259992 Branches 8665 8665 - Hits 1311913106 -13 - Misses4565345665 +12 - Partials 1220 1221 +1 ``` | [Impacted Files](https://codecov.io/gh/apache/kylin/pull/114?src=pr=tree) | Coverage Δ | Complexity Δ | | |---|---|---|---| | [...che/kylin/engine/mr/steps/CreateDictionaryJob.java](https://codecov.io/gh/apache/kylin/pull/114/diff?src=pr=tree#diff-ZW5naW5lLW1yL3NyYy9tYWluL2phdmEvb3JnL2FwYWNoZS9reWxpbi9lbmdpbmUvbXIvc3RlcHMvQ3JlYXRlRGljdGlvbmFyeUpvYi5qYXZh) | `0% <0%> (ø)` | `0 <0> (ø)` | :arrow_down: | | [...org/apache/kylin/rest/util/QueryRequestLimits.java](https://codecov.io/gh/apache/kylin/pull/114/diff?src=pr=tree#diff-c2VydmVyLWJhc2Uvc3JjL21haW4vamF2YS9vcmcvYXBhY2hlL2t5bGluL3Jlc3QvdXRpbC9RdWVyeVJlcXVlc3RMaW1pdHMuamF2YQ==) | `35.71% <0%> (-4.77%)` | `5% <0%> (-1%)` | | | [...rg/apache/kylin/storage/hbase/HBaseConnection.java](https://codecov.io/gh/apache/kylin/pull/114/diff?src=pr=tree#diff-c3RvcmFnZS1oYmFzZS9zcmMvbWFpbi9qYXZhL29yZy9hcGFjaGUva3lsaW4vc3RvcmFnZS9oYmFzZS9IQmFzZUNvbm5lY3Rpb24uamF2YQ==) | `13.08% <0%> (-4.72%)` | `6% <0%> (ø)` | | | [...g/apache/kylin/metadata/cachesync/Broadcaster.java](https://codecov.io/gh/apache/kylin/pull/114/diff?src=pr=tree#diff-Y29yZS1tZXRhZGF0YS9zcmMvbWFpbi9qYXZhL29yZy9hcGFjaGUva3lsaW4vbWV0YWRhdGEvY2FjaGVzeW5jL0Jyb2FkY2FzdGVyLmphdmE=) | `54.22% <0%> (-1.5%)` | `21% <0%> (ø)` | | | [.../apache/kylin/cube/cuboid/TreeCuboidScheduler.java](https://codecov.io/gh/apache/kylin/pull/114/diff?src=pr=tree#diff-Y29yZS1jdWJlL3NyYy9tYWluL2phdmEvb3JnL2FwYWNoZS9reWxpbi9jdWJlL2N1Ym9pZC9UcmVlQ3Vib2lkU2NoZWR1bGVyLmphdmE=) | `64.56% <0%> (-0.79%)` | `0% <0%> (ø)` | | | [...rg/apache/kylin/cube/inmemcubing/MemDiskStore.java](https://codecov.io/gh/apache/kylin/pull/114/diff?src=pr=tree#diff-Y29yZS1jdWJlL3NyYy9tYWluL2phdmEvb3JnL2FwYWNoZS9reWxpbi9jdWJlL2lubWVtY3ViaW5nL01lbURpc2tTdG9yZS5qYXZh) | `70.21% <0%> (+0.6%)` | `7% <0%> (ø)` | :arrow_down: | -- [Continue to review full report at Codecov](https://codecov.io/gh/apache/kylin/pull/114?src=pr=continue). > **Legend** - [Click here to learn more](https://docs.codecov.io/docs/codecov-delta) > `Δ = absolute (impact)`, `ø = not affected`, `? = missing data` > Powered by [Codecov](https://codecov.io/gh/apache/kylin/pull/114?src=pr=footer). Last update [06f497e...f26969c](https://codecov.io/gh/apache/kylin/pull/114?src=pr=lastupdated). Read the [comment docs](https://docs.codecov.io/docs/pull-request-comments). This is an automated message from the Apache Git Service. To respond to the message, please log on GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: us...@infra.apache.org > When a shard by column is in dict encoding, dict building error. > > > Key: KYLIN-3287 > URL: https://issues.apache.org/jira/browse/KYLIN-3287 > Project: Kylin > Issue Type: Bug >Reporter: jiatao.tao >Assignee: jiatao.tao >Priority: Major > Attachments: image-2018-03-12-14-14-50-112.png, > image-2018-03-12-14-14-59-193.png, image-2018-03-12-14-15-42-046.png, > image-2018-03-12-14-16-38-657.png, image-2018-03-12-14-17-46-780.png > > > In dict encoding. > !image-2018-03-12-14-14-50-112.png|width=544,height=84! >
[jira] [Commented] (KYLIN-3287) When a shard by column is in dict encoding, dict building error.
[ https://issues.apache.org/jira/browse/KYLIN-3287?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16395156#comment-16395156 ] ASF GitHub Bot commented on KYLIN-3287: --- liyang-gmt8 closed pull request #114: KYLIN-3287, fix when a shard by column is in dict encoding, dict buil… URL: https://github.com/apache/kylin/pull/114 This is a PR merged from a forked repository. As GitHub hides the original diff on merge, it is displayed below for the sake of provenance: As this is a foreign pull request (from a fork), the diff is supplied below (as it won't show otherwise due to GitHub magic): diff --git a/engine-mr/src/main/java/org/apache/kylin/engine/mr/steps/CreateDictionaryJob.java b/engine-mr/src/main/java/org/apache/kylin/engine/mr/steps/CreateDictionaryJob.java index a4576774aa..dab4880390 100644 --- a/engine-mr/src/main/java/org/apache/kylin/engine/mr/steps/CreateDictionaryJob.java +++ b/engine-mr/src/main/java/org/apache/kylin/engine/mr/steps/CreateDictionaryJob.java @@ -82,7 +82,7 @@ public IReadableTable getDistinctValuesFor(TblColRef col) { List uhcColumns = cube.getDescriptor().getAllUHCColumns(); Path colDir; -if (uhcColumns.contains(col)) { +if (config.isBuildUHCDictWithMREnabled() && uhcColumns.contains(col)) { colDir = new Path(dictPath, col.getIdentity()); } else { colDir = new Path(factColumnsInputPath, col.getIdentity()); diff --git a/examples/test_case_data/localmeta/cube_desc/ci_inner_join_cube.json b/examples/test_case_data/localmeta/cube_desc/ci_inner_join_cube.json index 809e188ee3..ec1100a1da 100644 --- a/examples/test_case_data/localmeta/cube_desc/ci_inner_join_cube.json +++ b/examples/test_case_data/localmeta/cube_desc/ci_inner_join_cube.json @@ -342,7 +342,8 @@ }, { "column": "TEST_KYLIN_FACT.LEAF_CATEG_ID", -"encoding": "dict" +"encoding": "dict", +"isShardBy" : true }, { "column": "TEST_CATEGORY_GROUPINGS.META_CATEG_NAME", This is an automated message from the Apache Git Service. To respond to the message, please log on GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: us...@infra.apache.org > When a shard by column is in dict encoding, dict building error. > > > Key: KYLIN-3287 > URL: https://issues.apache.org/jira/browse/KYLIN-3287 > Project: Kylin > Issue Type: Bug >Reporter: jiatao.tao >Assignee: jiatao.tao >Priority: Major > Attachments: image-2018-03-12-14-14-50-112.png, > image-2018-03-12-14-14-59-193.png, image-2018-03-12-14-15-42-046.png, > image-2018-03-12-14-16-38-657.png, image-2018-03-12-14-17-46-780.png > > > In dict encoding. > !image-2018-03-12-14-14-50-112.png|width=544,height=84! > !image-2018-03-12-14-14-59-193.png|width=535,height=631! > In int encoding > !image-2018-03-12-14-15-42-046.png|width=544,height=87! > !image-2018-03-12-14-16-38-657.png! -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (KYLIN-3287) When a shard by column is in dict encoding, dict building error.
[ https://issues.apache.org/jira/browse/KYLIN-3287?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16395157#comment-16395157 ] ASF subversion and git services commented on KYLIN-3287: Commit f26969cca2157fe4001714676d8ff5c11e59cf8b in kylin's branch refs/heads/master from [~Aron.tao] [ https://gitbox.apache.org/repos/asf?p=kylin.git;h=f26969c ] KYLIN-3287, fix when a shard by column is in dict encoding, dict building error. > When a shard by column is in dict encoding, dict building error. > > > Key: KYLIN-3287 > URL: https://issues.apache.org/jira/browse/KYLIN-3287 > Project: Kylin > Issue Type: Bug >Reporter: jiatao.tao >Assignee: jiatao.tao >Priority: Major > Attachments: image-2018-03-12-14-14-50-112.png, > image-2018-03-12-14-14-59-193.png, image-2018-03-12-14-15-42-046.png, > image-2018-03-12-14-16-38-657.png, image-2018-03-12-14-17-46-780.png > > > In dict encoding. > !image-2018-03-12-14-14-50-112.png|width=544,height=84! > !image-2018-03-12-14-14-59-193.png|width=535,height=631! > In int encoding > !image-2018-03-12-14-15-42-046.png|width=544,height=87! > !image-2018-03-12-14-16-38-657.png! -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (KYLIN-3287) When a shard by column is in dict encoding, dict building error.
[ https://issues.apache.org/jira/browse/KYLIN-3287?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16395158#comment-16395158 ] ASF subversion and git services commented on KYLIN-3287: Commit ac0573840929eb888cf7b55a545d8c4a19cbc89c in kylin's branch refs/heads/master from Li Yang [ https://gitbox.apache.org/repos/asf?p=kylin.git;h=ac05738 ] Merge pull request #114 from tttMelody/master KYLIN-3287, fix when a shard by column is in dict encoding, dict buil… > When a shard by column is in dict encoding, dict building error. > > > Key: KYLIN-3287 > URL: https://issues.apache.org/jira/browse/KYLIN-3287 > Project: Kylin > Issue Type: Bug >Reporter: jiatao.tao >Assignee: jiatao.tao >Priority: Major > Attachments: image-2018-03-12-14-14-50-112.png, > image-2018-03-12-14-14-59-193.png, image-2018-03-12-14-15-42-046.png, > image-2018-03-12-14-16-38-657.png, image-2018-03-12-14-17-46-780.png > > > In dict encoding. > !image-2018-03-12-14-14-50-112.png|width=544,height=84! > !image-2018-03-12-14-14-59-193.png|width=535,height=631! > In int encoding > !image-2018-03-12-14-15-42-046.png|width=544,height=87! > !image-2018-03-12-14-16-38-657.png! -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (KYLIN-3287) When a shard by column is in dict encoding, dict building error.
[ https://issues.apache.org/jira/browse/KYLIN-3287?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16395155#comment-16395155 ] liyang commented on KYLIN-3287: --- +1 patch verified > When a shard by column is in dict encoding, dict building error. > > > Key: KYLIN-3287 > URL: https://issues.apache.org/jira/browse/KYLIN-3287 > Project: Kylin > Issue Type: Bug >Reporter: jiatao.tao >Assignee: jiatao.tao >Priority: Major > Attachments: image-2018-03-12-14-14-50-112.png, > image-2018-03-12-14-14-59-193.png, image-2018-03-12-14-15-42-046.png, > image-2018-03-12-14-16-38-657.png, image-2018-03-12-14-17-46-780.png > > > In dict encoding. > !image-2018-03-12-14-14-50-112.png|width=544,height=84! > !image-2018-03-12-14-14-59-193.png|width=535,height=631! > In int encoding > !image-2018-03-12-14-15-42-046.png|width=544,height=87! > !image-2018-03-12-14-16-38-657.png! -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (KYLIN-3287) When a shard by column is in dict encoding, dict building error.
[ https://issues.apache.org/jira/browse/KYLIN-3287?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16395142#comment-16395142 ] ASF GitHub Bot commented on KYLIN-3287: --- asfgit commented on issue #114: KYLIN-3287, fix when a shard by column is in dict encoding, dict buil… URL: https://github.com/apache/kylin/pull/114#issuecomment-372291210 Can one of the admins verify this patch? This is an automated message from the Apache Git Service. To respond to the message, please log on GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: us...@infra.apache.org > When a shard by column is in dict encoding, dict building error. > > > Key: KYLIN-3287 > URL: https://issues.apache.org/jira/browse/KYLIN-3287 > Project: Kylin > Issue Type: Bug >Reporter: jiatao.tao >Assignee: jiatao.tao >Priority: Major > Attachments: image-2018-03-12-14-14-50-112.png, > image-2018-03-12-14-14-59-193.png, image-2018-03-12-14-15-42-046.png, > image-2018-03-12-14-16-38-657.png, image-2018-03-12-14-17-46-780.png > > > In dict encoding. > !image-2018-03-12-14-14-50-112.png|width=544,height=84! > !image-2018-03-12-14-14-59-193.png|width=535,height=631! > In int encoding > !image-2018-03-12-14-15-42-046.png|width=544,height=87! > !image-2018-03-12-14-16-38-657.png! -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (KYLIN-3287) When a shard by column is in dict encoding, dict building error.
[ https://issues.apache.org/jira/browse/KYLIN-3287?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16395141#comment-16395141 ] ASF GitHub Bot commented on KYLIN-3287: --- tttMelody opened a new pull request #114: KYLIN-3287, fix when a shard by column is in dict encoding, dict buil… URL: https://github.com/apache/kylin/pull/114 …ding error. This is an automated message from the Apache Git Service. To respond to the message, please log on GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: us...@infra.apache.org > When a shard by column is in dict encoding, dict building error. > > > Key: KYLIN-3287 > URL: https://issues.apache.org/jira/browse/KYLIN-3287 > Project: Kylin > Issue Type: Bug >Reporter: jiatao.tao >Assignee: jiatao.tao >Priority: Major > Attachments: image-2018-03-12-14-14-50-112.png, > image-2018-03-12-14-14-59-193.png, image-2018-03-12-14-15-42-046.png, > image-2018-03-12-14-16-38-657.png, image-2018-03-12-14-17-46-780.png > > > In dict encoding. > !image-2018-03-12-14-14-50-112.png|width=544,height=84! > !image-2018-03-12-14-14-59-193.png|width=535,height=631! > In int encoding > !image-2018-03-12-14-15-42-046.png|width=544,height=87! > !image-2018-03-12-14-16-38-657.png! -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (KYLIN-3287) When a shard by column is in dict encoding, dict building error.
[ https://issues.apache.org/jira/browse/KYLIN-3287?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jiatao.tao updated KYLIN-3287: -- Summary: When a shard by column is in dict encoding, dict building error. (was: When a shard by column is in dict encoding, dict buildin error.) > When a shard by column is in dict encoding, dict building error. > > > Key: KYLIN-3287 > URL: https://issues.apache.org/jira/browse/KYLIN-3287 > Project: Kylin > Issue Type: Bug >Reporter: jiatao.tao >Assignee: jiatao.tao >Priority: Major > Attachments: image-2018-03-12-14-14-50-112.png, > image-2018-03-12-14-14-59-193.png, image-2018-03-12-14-15-42-046.png, > image-2018-03-12-14-16-38-657.png, image-2018-03-12-14-17-46-780.png > > > In dict encoding. > !image-2018-03-12-14-14-50-112.png|width=544,height=84! > !image-2018-03-12-14-14-59-193.png|width=535,height=631! > In int encoding > !image-2018-03-12-14-15-42-046.png|width=544,height=87! > !image-2018-03-12-14-16-38-657.png! -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (KYLIN-3287) When a shard by column is in dict encoding, dict buildin error.
[ https://issues.apache.org/jira/browse/KYLIN-3287?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jiatao.tao updated KYLIN-3287: -- Summary: When a shard by column is in dict encoding, dict buildin error. (was: When a shard by column is in dict encoding, dict building is error.) > When a shard by column is in dict encoding, dict buildin error. > --- > > Key: KYLIN-3287 > URL: https://issues.apache.org/jira/browse/KYLIN-3287 > Project: Kylin > Issue Type: Bug >Reporter: jiatao.tao >Assignee: jiatao.tao >Priority: Major > Attachments: image-2018-03-12-14-14-50-112.png, > image-2018-03-12-14-14-59-193.png, image-2018-03-12-14-15-42-046.png, > image-2018-03-12-14-16-38-657.png, image-2018-03-12-14-17-46-780.png > > > In dict encoding. > !image-2018-03-12-14-14-50-112.png|width=544,height=84! > !image-2018-03-12-14-14-59-193.png|width=535,height=631! > In int encoding > !image-2018-03-12-14-15-42-046.png|width=544,height=87! > !image-2018-03-12-14-16-38-657.png! -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (KYLIN-3287) When a shard by column is in dict encoding, dict building is error.
[ https://issues.apache.org/jira/browse/KYLIN-3287?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16394845#comment-16394845 ] jiatao.tao commented on KYLIN-3287: --- This is the root clause. !image-2018-03-12-14-17-46-780.png|width=579,height=318! > When a shard by column is in dict encoding, dict building is error. > --- > > Key: KYLIN-3287 > URL: https://issues.apache.org/jira/browse/KYLIN-3287 > Project: Kylin > Issue Type: Bug >Reporter: jiatao.tao >Priority: Major > Attachments: image-2018-03-12-14-14-50-112.png, > image-2018-03-12-14-14-59-193.png, image-2018-03-12-14-15-42-046.png, > image-2018-03-12-14-16-38-657.png, image-2018-03-12-14-17-46-780.png > > > In dict encoding. > !image-2018-03-12-14-14-50-112.png|width=544,height=84! > !image-2018-03-12-14-14-59-193.png|width=535,height=631! > In int encoding > !image-2018-03-12-14-15-42-046.png|width=544,height=87! > !image-2018-03-12-14-16-38-657.png! -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Assigned] (KYLIN-3287) When a shard by column is in dict encoding, dict building is error.
[ https://issues.apache.org/jira/browse/KYLIN-3287?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jiatao.tao reassigned KYLIN-3287: - Assignee: jiatao.tao > When a shard by column is in dict encoding, dict building is error. > --- > > Key: KYLIN-3287 > URL: https://issues.apache.org/jira/browse/KYLIN-3287 > Project: Kylin > Issue Type: Bug >Reporter: jiatao.tao >Assignee: jiatao.tao >Priority: Major > Attachments: image-2018-03-12-14-14-50-112.png, > image-2018-03-12-14-14-59-193.png, image-2018-03-12-14-15-42-046.png, > image-2018-03-12-14-16-38-657.png, image-2018-03-12-14-17-46-780.png > > > In dict encoding. > !image-2018-03-12-14-14-50-112.png|width=544,height=84! > !image-2018-03-12-14-14-59-193.png|width=535,height=631! > In int encoding > !image-2018-03-12-14-15-42-046.png|width=544,height=87! > !image-2018-03-12-14-16-38-657.png! -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (KYLIN-3287) When a shard by column is in dict encoding, dict building is error.
[ https://issues.apache.org/jira/browse/KYLIN-3287?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jiatao.tao updated KYLIN-3287: -- Description: In dict encoding. !image-2018-03-12-14-14-50-112.png|width=544,height=84! !image-2018-03-12-14-14-59-193.png|width=535,height=631! In int encoding !image-2018-03-12-14-15-42-046.png|width=544,height=87! !image-2018-03-12-14-16-38-657.png! > When a shard by column is in dict encoding, dict building is error. > --- > > Key: KYLIN-3287 > URL: https://issues.apache.org/jira/browse/KYLIN-3287 > Project: Kylin > Issue Type: Bug >Reporter: jiatao.tao >Priority: Major > Attachments: image-2018-03-12-14-14-50-112.png, > image-2018-03-12-14-14-59-193.png, image-2018-03-12-14-15-42-046.png, > image-2018-03-12-14-16-38-657.png, image-2018-03-12-14-17-46-780.png > > > In dict encoding. > !image-2018-03-12-14-14-50-112.png|width=544,height=84! > !image-2018-03-12-14-14-59-193.png|width=535,height=631! > In int encoding > !image-2018-03-12-14-15-42-046.png|width=544,height=87! > !image-2018-03-12-14-16-38-657.png! -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (KYLIN-3287) When a shard by column is in dict encoding, dict building is error.
[ https://issues.apache.org/jira/browse/KYLIN-3287?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jiatao.tao updated KYLIN-3287: -- Attachment: image-2018-03-12-14-17-46-780.png > When a shard by column is in dict encoding, dict building is error. > --- > > Key: KYLIN-3287 > URL: https://issues.apache.org/jira/browse/KYLIN-3287 > Project: Kylin > Issue Type: Bug >Reporter: jiatao.tao >Priority: Major > Attachments: image-2018-03-12-14-14-50-112.png, > image-2018-03-12-14-14-59-193.png, image-2018-03-12-14-15-42-046.png, > image-2018-03-12-14-16-38-657.png, image-2018-03-12-14-17-46-780.png > > > In dict encoding. > !image-2018-03-12-14-14-50-112.png|width=544,height=84! > !image-2018-03-12-14-14-59-193.png|width=535,height=631! > In int encoding > !image-2018-03-12-14-15-42-046.png|width=544,height=87! > !image-2018-03-12-14-16-38-657.png! -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (KYLIN-3287) When a shard by column is in dict encoding, dict building is error.
[ https://issues.apache.org/jira/browse/KYLIN-3287?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jiatao.tao updated KYLIN-3287: -- Attachment: image-2018-03-12-14-16-38-657.png > When a shard by column is in dict encoding, dict building is error. > --- > > Key: KYLIN-3287 > URL: https://issues.apache.org/jira/browse/KYLIN-3287 > Project: Kylin > Issue Type: Bug >Reporter: jiatao.tao >Priority: Major > Attachments: image-2018-03-12-14-14-50-112.png, > image-2018-03-12-14-14-59-193.png, image-2018-03-12-14-15-42-046.png, > image-2018-03-12-14-16-38-657.png > > -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (KYLIN-3287) When a shard by column is in dict encoding, dict building is error.
[ https://issues.apache.org/jira/browse/KYLIN-3287?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jiatao.tao updated KYLIN-3287: -- Attachment: image-2018-03-12-14-15-42-046.png > When a shard by column is in dict encoding, dict building is error. > --- > > Key: KYLIN-3287 > URL: https://issues.apache.org/jira/browse/KYLIN-3287 > Project: Kylin > Issue Type: Bug >Reporter: jiatao.tao >Priority: Major > Attachments: image-2018-03-12-14-14-50-112.png, > image-2018-03-12-14-14-59-193.png, image-2018-03-12-14-15-42-046.png > > -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (KYLIN-3287) When a shard by column is in dict encoding, dict building is error.
[ https://issues.apache.org/jira/browse/KYLIN-3287?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jiatao.tao updated KYLIN-3287: -- Attachment: image-2018-03-12-14-14-59-193.png > When a shard by column is in dict encoding, dict building is error. > --- > > Key: KYLIN-3287 > URL: https://issues.apache.org/jira/browse/KYLIN-3287 > Project: Kylin > Issue Type: Bug >Reporter: jiatao.tao >Priority: Major > Attachments: image-2018-03-12-14-14-50-112.png, > image-2018-03-12-14-14-59-193.png, image-2018-03-12-14-15-42-046.png > > -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (KYLIN-3287) When a shard by column is in dict encoding, dict building is error.
[ https://issues.apache.org/jira/browse/KYLIN-3287?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jiatao.tao updated KYLIN-3287: -- Attachment: image-2018-03-12-14-14-50-112.png > When a shard by column is in dict encoding, dict building is error. > --- > > Key: KYLIN-3287 > URL: https://issues.apache.org/jira/browse/KYLIN-3287 > Project: Kylin > Issue Type: Bug >Reporter: jiatao.tao >Priority: Major > Attachments: image-2018-03-12-14-14-50-112.png, > image-2018-03-12-14-14-59-193.png, image-2018-03-12-14-15-42-046.png > > -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Created] (KYLIN-3287) When a shard by column is in dict encoding, dict building is error.
jiatao.tao created KYLIN-3287: - Summary: When a shard by column is in dict encoding, dict building is error. Key: KYLIN-3287 URL: https://issues.apache.org/jira/browse/KYLIN-3287 Project: Kylin Issue Type: Bug Reporter: jiatao.tao -- This message was sent by Atlassian JIRA (v7.6.3#76005)