[jira] [Commented] (KYLIN-3966) Metric multiplication and metric division not working in query
[ https://issues.apache.org/jira/browse/KYLIN-3966?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16826680#comment-16826680 ] hejian commented on KYLIN-3966: --- i think the measure columns can not be used directly without any measuring expression that you defined in building cube stage > Metric multiplication and metric division not working in query > -- > > Key: KYLIN-3966 > URL: https://issues.apache.org/jira/browse/KYLIN-3966 > Project: Kylin > Issue Type: Bug > Components: Query Engine >Reporter: Gladson Vas >Priority: Blocker > > When i try to multiply or divide 2 metric columns in a query > eg: select col1*col2 from table > select col1/col2 from table. > it throws the following errors > That both of the two sides of the BinaryTupleExpression own columns is not > supported for * while executing SQL > That both of the two sides of the BinaryTupleExpression own columns is not > supported for / while executing SQL. > But when i use the + or - operators in the query it seems to be working fine. > Is there any way to support these 2 operators as well? > Thanks, > Gladson > -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Comment Edited] (KYLIN-3976) Failed to find metadata store by url: kylin_metadata@hbase
[ https://issues.apache.org/jira/browse/KYLIN-3976?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16826622#comment-16826622 ] ZhangXihao edited comment on KYLIN-3976 at 4/26/19 4:05 AM: I changed the version.hadoop-2.6.0-cdh5.10.0+hive-1.1.0-cdh5.10.0+hbase-1.2.0-cdh5.10.0+zookeeper-3.4.5-cdh5.10.0+apache-kylin-2.3.2-bin.And I succeeded in starting Kylin, but I would report an error if I restarted it. [main] hbase.HBaseConnection:307 : HTable 'kylin_metadata' already existsException in thread "main" java.lang.IllegalArgumentException: Failed to find metadata store by url: kylin_metadata@hbase = I really don't know what's wrong.Please help me.Please Please Please Please Please Please Please Please Please Please Please Please Please Please Please Please Please Please Please Please Please Please was (Author: rickmdb): I changed the version.hadoop-2.6.0-cdh5.10.0+hive-1.1.0-cdh5.10.0+hbase-1.2.0-cdh5.10.0+zookeeper-3.4.5-cdh5.10.0+apache-kylin-2.3.2-bin.If I restart kylin, I will report an error. [main] hbase.HBaseConnection:307 : HTable 'kylin_metadata' already existsException in thread "main" java.lang.IllegalArgumentException: Failed to find metadata store by url: kylin_metadata@hbase = I really don't know what's wrong.Please help me.Please Please Please Please Please Please Please Please Please Please Please Please Please Please Please Please Please Please Please Please Please Please > Failed to find metadata store by url: kylin_metadata@hbase > -- > > Key: KYLIN-3976 > URL: https://issues.apache.org/jira/browse/KYLIN-3976 > Project: Kylin > Issue Type: Bug > Components: Metadata > Environment: > kylin2.3.2+hadoop3.1.2+hive2.3.4+hbase1.2.0+zookeeper3.4.5 >Reporter: ZhangXihao >Priority: Blocker > Original Estimate: 48h > Remaining Estimate: 48h > > 2019-04-24 17:30:01,894 DEBUG [main] hbase.HBaseConnection:337 : Creating > HTable 'kylin_metadata' > 2019-04-24 17:30:01,936 INFO [main] Configuration.deprecation:1174 : > hadoop.native.lib is deprecated. Instead, use io.native.lib.available > 2019-04-24 17:30:02,089 DEBUG [main] util.ZookeeperDistributedLock:223 : > 7116@ambari02 trying to unlock > /kylin/kylin_metadata/create_htable/kylin_metadata/lock > 2019-04-24 17:30:02,099 INFO [main] util.ZookeeperDistributedLock:234 : > 7116@ambari02 released lock at > /kylin/kylin_metadata/create_htable/kylin_metadata/lock > Exception in thread "main" java.lang.IllegalArgumentException: Failed to find > metadata store by url: kylin_metadata@hbase > at > org.apache.kylin.common.persistence.ResourceStore.createResourceStore(ResourceStore.java:96) > at > org.apache.kylin.common.persistence.ResourceStore.getStore(ResourceStore.java:108) > at > org.apache.kylin.rest.service.AclTableMigrationTool.checkIfNeedMigrate(AclTableMigrationTool.java:94) > at > org.apache.kylin.tool.AclTableMigrationCLI.main(AclTableMigrationCLI.java:41) > Caused by: java.lang.reflect.InvocationTargetException > at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) > at > sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) > at > sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) > at java.lang.reflect.Constructor.newInstance(Constructor.java:423) > at > org.apache.kylin.common.persistence.ResourceStore.createResourceStore(ResourceStore.java:90) > ... 3 more > Caused by: java.lang.NoSuchMethodError: > org.apache.hadoop.hbase.HTableDescriptor.addFamily(Lorg/apache/hadoop/hbase/HColumnDescriptor;)Lorg/apache/hadoop/hbase/HTableDescriptor; > at > org.apache.kylin.storage.hbase.HBaseConnection.createHTableIfNeeded(HBaseConnection.java:344) > at > org.apache.kylin.storage.hbase.HBaseResourceStore.createHTableIfNeeded(HBaseResourceStore.java:111) > at > org.apache.kylin.storage.hbase.HBaseResourceStore.(HBaseResourceStore.java:92) > ... 8 more > 2019-04-24 17:30:02,105 INFO [close-hbase-conn] hbase.HBaseConnection:137 : > Closing HBase connections... > 2019-04-24 17:30:02,107 INFO [close-hbase-conn] > client.ConnectionManager$HConnectionImplementation:1830 : Closing zookeeper > sessionid=0x16a4c1bd0c80008 > 2019-04-24 17:30:02,111 INFO [close-hbase-conn] zookeeper.ZooKeeper:684 : > Session: 0x16a4c1bd0c80008 closed > 2019-04-24 17:30:02,111 INFO [main-EventThread] zookeeper.ClientCnxn:512 : > EventThread shut down > 2019-04-24 17:30:02,114 INFO [Thread-7] z
[jira] [Commented] (KYLIN-3976) Failed to find metadata store by url: kylin_metadata@hbase
[ https://issues.apache.org/jira/browse/KYLIN-3976?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16826622#comment-16826622 ] ZhangXihao commented on KYLIN-3976: --- I changed the version.hadoop-2.6.0-cdh5.10.0+hive-1.1.0-cdh5.10.0+hbase-1.2.0-cdh5.10.0+zookeeper-3.4.5-cdh5.10.0+apache-kylin-2.3.2-bin.If I restart kylin, I will report an error. [main] hbase.HBaseConnection:307 : HTable 'kylin_metadata' already existsException in thread "main" java.lang.IllegalArgumentException: Failed to find metadata store by url: kylin_metadata@hbase = I really don't know what's wrong.Please help me.Please Please Please Please Please Please Please Please Please Please Please Please Please Please Please Please Please Please Please Please Please Please > Failed to find metadata store by url: kylin_metadata@hbase > -- > > Key: KYLIN-3976 > URL: https://issues.apache.org/jira/browse/KYLIN-3976 > Project: Kylin > Issue Type: Bug > Components: Metadata > Environment: > kylin2.3.2+hadoop3.1.2+hive2.3.4+hbase1.2.0+zookeeper3.4.5 >Reporter: ZhangXihao >Priority: Blocker > Original Estimate: 48h > Remaining Estimate: 48h > > 2019-04-24 17:30:01,894 DEBUG [main] hbase.HBaseConnection:337 : Creating > HTable 'kylin_metadata' > 2019-04-24 17:30:01,936 INFO [main] Configuration.deprecation:1174 : > hadoop.native.lib is deprecated. Instead, use io.native.lib.available > 2019-04-24 17:30:02,089 DEBUG [main] util.ZookeeperDistributedLock:223 : > 7116@ambari02 trying to unlock > /kylin/kylin_metadata/create_htable/kylin_metadata/lock > 2019-04-24 17:30:02,099 INFO [main] util.ZookeeperDistributedLock:234 : > 7116@ambari02 released lock at > /kylin/kylin_metadata/create_htable/kylin_metadata/lock > Exception in thread "main" java.lang.IllegalArgumentException: Failed to find > metadata store by url: kylin_metadata@hbase > at > org.apache.kylin.common.persistence.ResourceStore.createResourceStore(ResourceStore.java:96) > at > org.apache.kylin.common.persistence.ResourceStore.getStore(ResourceStore.java:108) > at > org.apache.kylin.rest.service.AclTableMigrationTool.checkIfNeedMigrate(AclTableMigrationTool.java:94) > at > org.apache.kylin.tool.AclTableMigrationCLI.main(AclTableMigrationCLI.java:41) > Caused by: java.lang.reflect.InvocationTargetException > at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) > at > sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) > at > sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) > at java.lang.reflect.Constructor.newInstance(Constructor.java:423) > at > org.apache.kylin.common.persistence.ResourceStore.createResourceStore(ResourceStore.java:90) > ... 3 more > Caused by: java.lang.NoSuchMethodError: > org.apache.hadoop.hbase.HTableDescriptor.addFamily(Lorg/apache/hadoop/hbase/HColumnDescriptor;)Lorg/apache/hadoop/hbase/HTableDescriptor; > at > org.apache.kylin.storage.hbase.HBaseConnection.createHTableIfNeeded(HBaseConnection.java:344) > at > org.apache.kylin.storage.hbase.HBaseResourceStore.createHTableIfNeeded(HBaseResourceStore.java:111) > at > org.apache.kylin.storage.hbase.HBaseResourceStore.(HBaseResourceStore.java:92) > ... 8 more > 2019-04-24 17:30:02,105 INFO [close-hbase-conn] hbase.HBaseConnection:137 : > Closing HBase connections... > 2019-04-24 17:30:02,107 INFO [close-hbase-conn] > client.ConnectionManager$HConnectionImplementation:1830 : Closing zookeeper > sessionid=0x16a4c1bd0c80008 > 2019-04-24 17:30:02,111 INFO [close-hbase-conn] zookeeper.ZooKeeper:684 : > Session: 0x16a4c1bd0c80008 closed > 2019-04-24 17:30:02,111 INFO [main-EventThread] zookeeper.ClientCnxn:512 : > EventThread shut down > 2019-04-24 17:30:02,114 INFO [Thread-7] zookeeper.ZooKeeper:684 : Session: > 0x16a4c1bd0c80009 closed > 2019-04-24 17:30:02,114 INFO [main-EventThread] zookeeper.ClientCnxn:512 : > EventThread shut down -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (KYLIN-3964) segment overlapped, the status is "NEW", last_build_job_id is null, can not refresh/delete/build this segment
[ https://issues.apache.org/jira/browse/KYLIN-3964?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16826619#comment-16826619 ] hejian commented on KYLIN-3964: --- ACID > segment overlapped, the status is "NEW", last_build_job_id is null, can not > refresh/delete/build this segment > -- > > Key: KYLIN-3964 > URL: https://issues.apache.org/jira/browse/KYLIN-3964 > Project: Kylin > Issue Type: Bug > Environment: kylin-2.4.0 >Reporter: hejian >Priority: Major > Attachments: image-2019-04-22-10-07-06-737.png, > image-2019-04-23-16-51-34-805.png, image-2019-04-23-16-52-55-756.png > > > *Any action* *involved* *this segment can not be excute by requesting api due > to no job_id provided.* > !image-2019-04-22-10-07-06-737.png! > merge/refresh/rebuild/delete does not work > !image-2019-04-23-16-51-34-805.png!!image-2019-04-23-16-52-55-756.png! -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[GitHub] [kylin] GinaZhai commented on issue #620: KYLIN-3981 Auto Merge Job failed to execute on windows
GinaZhai commented on issue #620: KYLIN-3981 Auto Merge Job failed to execute on windows URL: https://github.com/apache/kylin/pull/620#issuecomment-486911783 Jenkins, test this please. This is an automated message from the Apache Git Service. To respond to the message, please log on to 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 With regards, Apache Git Services
[jira] [Commented] (KYLIN-3961) Optimize TopN measure merge function to reduce TopNCounter errors
[ https://issues.apache.org/jira/browse/KYLIN-3961?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16826545#comment-16826545 ] zhao jintao commented on KYLIN-3961: There are 3 query result about 3 cubes search the same datasource. All of them use the same sql. The first result of cube is without TopN measure. !image001.png! The second result of cube has topN measure with current version code. !image002.png! The third result of cube has topN measure with my modified code. !image003.png! I think that the third optimized cube may be better than the second current code cube. > Optimize TopN measure merge function to reduce TopNCounter errors > - > > Key: KYLIN-3961 > URL: https://issues.apache.org/jira/browse/KYLIN-3961 > Project: Kylin > Issue Type: Improvement > Components: Measure - TopN >Affects Versions: v2.5.2 > Environment: Huawei FusionInsight >Reporter: zhao jintao >Assignee: zhao jintao >Priority: Major > Labels: easyfix > Original Estimate: 168h > Remaining Estimate: 168h > > Hi Team: > I use "Top-N "measure to query such sql "select sum(AAA) from BBB group by > CCC,DDD", It is much better than a cube without "Top-N". > In my system, kylin cost just 0.2s to query sql with "Top-N" measure cube; If > without "Top-N" measure it may be cost 10s. > But I find that Top-N measure can be optimized to reduce errors. > I use kylin demo to test "TopN". > I build two cube using "KYLIN_SALES". The first cube has three > dimentions:"SELLER_ID","BUYER_ID" and "PART_DT", has one measures: > "SUM(PRICE)" . The second cube has one dimention:"PART_DT", has twon > measures: "SUM(PRICE)" and "TOPN(10)", the "ORDER|SUM by Column" of > "TOPN(10)" is "PRICE", the "Group by Column" of “TOPN(10)” is "SELLER_ID" > and "BUYER_ID",the "Return Type" of "TOPN(10)" is "Top 10". Then I build cube > from "2012-01-01" to "2014-01-01". > I use same sql to query two cube. I find that 2 cubes have a larger error. > The top5 "SUM PRICE" of first cube without "TopN" is "167.7269", "99.9908", > "99.9888","99.9865","99.978". > The top5 "SUM PRICE" of second cube with "TopN" is > "179.27699...","167.6320...","167.3050...","167.2069...","166.7429...". > Does any one meet same problem? > > Best regards. > -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (KYLIN-3967) sum along with case expression does not work in query
[ https://issues.apache.org/jira/browse/KYLIN-3967?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Gladson Vas updated KYLIN-3967: --- Attachment: notworkingcase.jpg > sum along with case expression does not work in query > - > > Key: KYLIN-3967 > URL: https://issues.apache.org/jira/browse/KYLIN-3967 > Project: Kylin > Issue Type: Bug > Components: Query Engine >Reporter: Gladson Vas >Priority: Blocker > Attachments: notworkingcase.jpg, workingcase.jpg > > > When i try to run a query with a sum case expression combination, > eg: select sum(case when col1<0 then 0 else col1 end ) from table > i get the following error: > No realization found for OLAPContext, CUBE_UNMATCHED_AGGREGATION[FunctionDesc > [expression=SUM, parameter=CASE(<($8, 0), 0, $8), returnType=null]], > rel#36838:OLAPTableScan.OLAP.[](table=[DEFAULT, table],ctx=,fields=[0, 1, 2, > 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, > 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, > 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, > 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, > 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, > 100, 101, 102, 103, 104, 105, 106]) while executing SQL: "select sum (case > when col1 <0 then 0 else col1 end ) from table LIMIT 5" > > is there any way to support this sum case expression in the query engine? > Also I get the same error when the sum operation is done on a column derived > from a case expression in a subquery. > eg: select sum(a.col1) from (select case when col1<0 then 0 else col1 end as > col1 from table) a > Thanks, > Gladson > -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (KYLIN-3967) sum along with case expression does not work in query
[ https://issues.apache.org/jira/browse/KYLIN-3967?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16825993#comment-16825993 ] Gladson Vas commented on KYLIN-3967: Hi, When kylin.query.enable-dynamic-column=true the sum case expression works but gives wrong results when the where clause is on the aliased column, tried it in the sample cube of kylin 2.6.1 *Working case:* select sum(case when trans_id_alias in(11,12,13) then price_alias else 0 end) as price_case_sum,part_dt_alias from (select price as price_alias ,trans_id as trans_id_alias,part_dt as part_dt_alias from kylin_sales where trans_id>10) group by part_dt_alias order by price_case_sum desc !workingcase.jpg! *Not working case:* select sum(case when trans_id_alias in(11,12,13) then price_alias else 0 end) as price_case_sum,part_dt_alias from (select price_alias,trans_id_alias,part_dt_alias from (select price as price_alias ,trans_id as trans_id_alias,part_dt as part_dt_alias from kylin_sales) where trans_id_alias>10) group by part_dt_alias order by price_case_sum desc !notworkingcase.jpg! > sum along with case expression does not work in query > - > > Key: KYLIN-3967 > URL: https://issues.apache.org/jira/browse/KYLIN-3967 > Project: Kylin > Issue Type: Bug > Components: Query Engine >Reporter: Gladson Vas >Priority: Blocker > Attachments: notworkingcase.jpg, workingcase.jpg > > > When i try to run a query with a sum case expression combination, > eg: select sum(case when col1<0 then 0 else col1 end ) from table > i get the following error: > No realization found for OLAPContext, CUBE_UNMATCHED_AGGREGATION[FunctionDesc > [expression=SUM, parameter=CASE(<($8, 0), 0, $8), returnType=null]], > rel#36838:OLAPTableScan.OLAP.[](table=[DEFAULT, table],ctx=,fields=[0, 1, 2, > 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, > 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, > 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, > 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, > 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, > 100, 101, 102, 103, 104, 105, 106]) while executing SQL: "select sum (case > when col1 <0 then 0 else col1 end ) from table LIMIT 5" > > is there any way to support this sum case expression in the query engine? > Also I get the same error when the sum operation is done on a column derived > from a case expression in a subquery. > eg: select sum(a.col1) from (select case when col1<0 then 0 else col1 end as > col1 from table) a > Thanks, > Gladson > -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (KYLIN-3967) sum along with case expression does not work in query
[ https://issues.apache.org/jira/browse/KYLIN-3967?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Gladson Vas updated KYLIN-3967: --- Attachment: workingcase.jpg > sum along with case expression does not work in query > - > > Key: KYLIN-3967 > URL: https://issues.apache.org/jira/browse/KYLIN-3967 > Project: Kylin > Issue Type: Bug > Components: Query Engine >Reporter: Gladson Vas >Priority: Blocker > Attachments: workingcase.jpg > > > When i try to run a query with a sum case expression combination, > eg: select sum(case when col1<0 then 0 else col1 end ) from table > i get the following error: > No realization found for OLAPContext, CUBE_UNMATCHED_AGGREGATION[FunctionDesc > [expression=SUM, parameter=CASE(<($8, 0), 0, $8), returnType=null]], > rel#36838:OLAPTableScan.OLAP.[](table=[DEFAULT, table],ctx=,fields=[0, 1, 2, > 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, > 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, > 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, > 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, > 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, > 100, 101, 102, 103, 104, 105, 106]) while executing SQL: "select sum (case > when col1 <0 then 0 else col1 end ) from table LIMIT 5" > > is there any way to support this sum case expression in the query engine? > Also I get the same error when the sum operation is done on a column derived > from a case expression in a subquery. > eg: select sum(a.col1) from (select case when col1<0 then 0 else col1 end as > col1 from table) a > Thanks, > Gladson > -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Issue Comment Deleted] (KYLIN-3967) sum along with case expression does not work in query
[ https://issues.apache.org/jira/browse/KYLIN-3967?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Gladson Vas updated KYLIN-3967: --- Comment: was deleted (was: Hi, When kylin.query.enable-dynamic-column=true the sum case expression works but gives wrong results when the where clause is on the aliased column, tried it in the sample cube of kylin 2.6.1. *Working case:* select sum(case when trans_id_alias in(11,12,13) then price_alias else 0 end) as price_case_sum,part_dt_alias from (select price as price_alias ,trans_id as trans_id_alias,part_dt as part_dt_alias from kylin_sales where trans_id>10) group by part_dt_alias order by price_case_sum desc !workingcase.png! *Not working case:* select sum(case when trans_id_alias in(11,12,13) then price_alias else 0 end) as price_case_sum,part_dt_alias from (select price_alias,trans_id_alias,part_dt_alias from (select price as price_alias ,trans_id as trans_id_alias,part_dt as part_dt_alias from kylin_sales) where trans_id_alias>10) group by part_dt_alias order by price_case_sum desc !notworkingcase.png! Thanks Gladson ) > sum along with case expression does not work in query > - > > Key: KYLIN-3967 > URL: https://issues.apache.org/jira/browse/KYLIN-3967 > Project: Kylin > Issue Type: Bug > Components: Query Engine >Reporter: Gladson Vas >Priority: Blocker > > When i try to run a query with a sum case expression combination, > eg: select sum(case when col1<0 then 0 else col1 end ) from table > i get the following error: > No realization found for OLAPContext, CUBE_UNMATCHED_AGGREGATION[FunctionDesc > [expression=SUM, parameter=CASE(<($8, 0), 0, $8), returnType=null]], > rel#36838:OLAPTableScan.OLAP.[](table=[DEFAULT, table],ctx=,fields=[0, 1, 2, > 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, > 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, > 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, > 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, > 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, > 100, 101, 102, 103, 104, 105, 106]) while executing SQL: "select sum (case > when col1 <0 then 0 else col1 end ) from table LIMIT 5" > > is there any way to support this sum case expression in the query engine? > Also I get the same error when the sum operation is done on a column derived > from a case expression in a subquery. > eg: select sum(a.col1) from (select case when col1<0 then 0 else col1 end as > col1 from table) a > Thanks, > Gladson > -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (KYLIN-3967) sum along with case expression does not work in query
[ https://issues.apache.org/jira/browse/KYLIN-3967?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16825988#comment-16825988 ] Gladson Vas commented on KYLIN-3967: Hi, When kylin.query.enable-dynamic-column=true the sum case expression works but gives wrong results when the where clause is on the aliased column, tried it in the sample cube of kylin 2.6.1. *Working case:* select sum(case when trans_id_alias in(11,12,13) then price_alias else 0 end) as price_case_sum,part_dt_alias from (select price as price_alias ,trans_id as trans_id_alias,part_dt as part_dt_alias from kylin_sales where trans_id>10) group by part_dt_alias order by price_case_sum desc !workingcase.png! *Not working case:* select sum(case when trans_id_alias in(11,12,13) then price_alias else 0 end) as price_case_sum,part_dt_alias from (select price_alias,trans_id_alias,part_dt_alias from (select price as price_alias ,trans_id as trans_id_alias,part_dt as part_dt_alias from kylin_sales) where trans_id_alias>10) group by part_dt_alias order by price_case_sum desc !notworkingcase.png! Thanks Gladson > sum along with case expression does not work in query > - > > Key: KYLIN-3967 > URL: https://issues.apache.org/jira/browse/KYLIN-3967 > Project: Kylin > Issue Type: Bug > Components: Query Engine >Reporter: Gladson Vas >Priority: Blocker > > When i try to run a query with a sum case expression combination, > eg: select sum(case when col1<0 then 0 else col1 end ) from table > i get the following error: > No realization found for OLAPContext, CUBE_UNMATCHED_AGGREGATION[FunctionDesc > [expression=SUM, parameter=CASE(<($8, 0), 0, $8), returnType=null]], > rel#36838:OLAPTableScan.OLAP.[](table=[DEFAULT, table],ctx=,fields=[0, 1, 2, > 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, > 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, > 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, > 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, > 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, > 100, 101, 102, 103, 104, 105, 106]) while executing SQL: "select sum (case > when col1 <0 then 0 else col1 end ) from table LIMIT 5" > > is there any way to support this sum case expression in the query engine? > Also I get the same error when the sum operation is done on a column derived > from a case expression in a subquery. > eg: select sum(a.col1) from (select case when col1<0 then 0 else col1 end as > col1 from table) a > Thanks, > Gladson > -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (KYLIN-3981) Auto Merge Job failed to execute on windows
[ https://issues.apache.org/jira/browse/KYLIN-3981?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16825982#comment-16825982 ] ASF GitHub Bot commented on KYLIN-3981: --- GinaZhai commented on pull request #620: KYLIN-3981 Auto Merge Job failed to execute on windows URL: https://github.com/apache/kylin/pull/620 This is an automated message from the Apache Git Service. To respond to the message, please log on to 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 > Auto Merge Job failed to execute on windows > --- > > Key: KYLIN-3981 > URL: https://issues.apache.org/jira/browse/KYLIN-3981 > Project: Kylin > Issue Type: Bug >Affects Versions: v2.6.1 >Reporter: Na Zhai >Assignee: Na Zhai >Priority: Major > Fix For: v2.6.2 > > > Auto Merge Job failed to execute on windows. It will throw the following > errors. > {code:none} > java.lang.IllegalStateException: Metadata uri : > C:\Users\NAD096~1.ZHA\AppData\Local\Temp\kylin_job_meta1467762575939435363\meta > is not recognized > at org.apache.kylin.common.KylinConfig.decideUriType(KylinConfig.java:211) > at > org.apache.kylin.common.KylinConfig.createInstanceFromUri(KylinConfig.java:221) > at > org.apache.kylin.engine.mr.common.JobRelatedMetaUtil.dumpResources(JobRelatedMetaUtil.java:68) > at > org.apache.kylin.engine.mr.common.JobRelatedMetaUtil.dumpAndUploadKylinPropsAndMetadata(JobRelatedMetaUtil.java:87) > at > org.apache.kylin.engine.mr.common.AbstractHadoopJob.attachSegmentsMetadataWithDict(AbstractHadoopJob.java:572) > at > org.apache.kylin.engine.mr.steps.MergeDictionaryJob.run(MergeDictionaryJob.java:104) > at > org.apache.kylin.engine.mr.common.MapReduceExecutable.doWork(MapReduceExecutable.java:131) > at > org.apache.kylin.job.execution.AbstractExecutable.execute(AbstractExecutable.java:179) > at > org.apache.kylin.job.execution.DefaultChainedExecutable.doWork(DefaultChainedExecutable.java:71) > at > org.apache.kylin.job.execution.AbstractExecutable.execute(AbstractExecutable.java:179) > at > org.apache.kylin.job.impl.threadpool.DefaultScheduler$JobRunner.run(DefaultScheduler.java:114) > at > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) > at java.lang.Thread.run(Thread.java:748) > Suppressed: java.io.FileNotFoundException: File does not exist: > C:\Users\NAD096~1.ZHA\AppData\Local\Temp\kylin_job_meta1467762575939435363\meta > at org.apache.commons.io.FileUtils.forceDelete(FileUtils.java:2275) > at > org.apache.kylin.common.persistence.AutoDeleteDirectory.close(AutoDeleteDirectory.java:56) > at > org.apache.kylin.engine.mr.common.JobRelatedMetaUtil.dumpAndUploadKylinPropsAndMetadata(JobRelatedMetaUtil.java:103) > ... 10 more > Caused by: java.lang.IllegalStateException: Metadata uri : > C:\Users\NAD096~1.ZHA\AppData\Local\Temp\kylin_job_meta1467762575939435363\meta > is not a valid REST URI address > at org.apache.kylin.common.KylinConfig.decideUriType(KylinConfig.java:208) > ... 13 more > {code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[GitHub] [kylin] GinaZhai opened a new pull request #620: KYLIN-3981 Auto Merge Job failed to execute on windows
GinaZhai opened a new pull request #620: KYLIN-3981 Auto Merge Job failed to execute on windows URL: https://github.com/apache/kylin/pull/620 This is an automated message from the Apache Git Service. To respond to the message, please log on to 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 With regards, Apache Git Services
[GitHub] [kylin] asfgit commented on issue #620: KYLIN-3981 Auto Merge Job failed to execute on windows
asfgit commented on issue #620: KYLIN-3981 Auto Merge Job failed to execute on windows URL: https://github.com/apache/kylin/pull/620#issuecomment-486636723 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 to 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 With regards, Apache Git Services
[jira] [Updated] (KYLIN-3981) Auto Merge Job failed to execute on windows
[ https://issues.apache.org/jira/browse/KYLIN-3981?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Na Zhai updated KYLIN-3981: --- Description: Auto Merge Job failed to execute on windows. It will throw the following errors. {code:none} java.lang.IllegalStateException: Metadata uri : C:\Users\NAD096~1.ZHA\AppData\Local\Temp\kylin_job_meta1467762575939435363\meta is not recognized at org.apache.kylin.common.KylinConfig.decideUriType(KylinConfig.java:211) at org.apache.kylin.common.KylinConfig.createInstanceFromUri(KylinConfig.java:221) at org.apache.kylin.engine.mr.common.JobRelatedMetaUtil.dumpResources(JobRelatedMetaUtil.java:68) at org.apache.kylin.engine.mr.common.JobRelatedMetaUtil.dumpAndUploadKylinPropsAndMetadata(JobRelatedMetaUtil.java:87) at org.apache.kylin.engine.mr.common.AbstractHadoopJob.attachSegmentsMetadataWithDict(AbstractHadoopJob.java:572) at org.apache.kylin.engine.mr.steps.MergeDictionaryJob.run(MergeDictionaryJob.java:104) at org.apache.kylin.engine.mr.common.MapReduceExecutable.doWork(MapReduceExecutable.java:131) at org.apache.kylin.job.execution.AbstractExecutable.execute(AbstractExecutable.java:179) at org.apache.kylin.job.execution.DefaultChainedExecutable.doWork(DefaultChainedExecutable.java:71) at org.apache.kylin.job.execution.AbstractExecutable.execute(AbstractExecutable.java:179) at org.apache.kylin.job.impl.threadpool.DefaultScheduler$JobRunner.run(DefaultScheduler.java:114) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748) Suppressed: java.io.FileNotFoundException: File does not exist: C:\Users\NAD096~1.ZHA\AppData\Local\Temp\kylin_job_meta1467762575939435363\meta at org.apache.commons.io.FileUtils.forceDelete(FileUtils.java:2275) at org.apache.kylin.common.persistence.AutoDeleteDirectory.close(AutoDeleteDirectory.java:56) at org.apache.kylin.engine.mr.common.JobRelatedMetaUtil.dumpAndUploadKylinPropsAndMetadata(JobRelatedMetaUtil.java:103) ... 10 more Caused by: java.lang.IllegalStateException: Metadata uri : C:\Users\NAD096~1.ZHA\AppData\Local\Temp\kylin_job_meta1467762575939435363\meta is not a valid REST URI address at org.apache.kylin.common.KylinConfig.decideUriType(KylinConfig.java:208) ... 13 more {code} was: Auto Merge Job failed to execute on windows. It will throw the following errors. > Auto Merge Job failed to execute on windows > --- > > Key: KYLIN-3981 > URL: https://issues.apache.org/jira/browse/KYLIN-3981 > Project: Kylin > Issue Type: Bug >Affects Versions: v2.6.1 >Reporter: Na Zhai >Assignee: Na Zhai >Priority: Major > Fix For: v2.6.2 > > > Auto Merge Job failed to execute on windows. It will throw the following > errors. > {code:none} > java.lang.IllegalStateException: Metadata uri : > C:\Users\NAD096~1.ZHA\AppData\Local\Temp\kylin_job_meta1467762575939435363\meta > is not recognized > at org.apache.kylin.common.KylinConfig.decideUriType(KylinConfig.java:211) > at > org.apache.kylin.common.KylinConfig.createInstanceFromUri(KylinConfig.java:221) > at > org.apache.kylin.engine.mr.common.JobRelatedMetaUtil.dumpResources(JobRelatedMetaUtil.java:68) > at > org.apache.kylin.engine.mr.common.JobRelatedMetaUtil.dumpAndUploadKylinPropsAndMetadata(JobRelatedMetaUtil.java:87) > at > org.apache.kylin.engine.mr.common.AbstractHadoopJob.attachSegmentsMetadataWithDict(AbstractHadoopJob.java:572) > at > org.apache.kylin.engine.mr.steps.MergeDictionaryJob.run(MergeDictionaryJob.java:104) > at > org.apache.kylin.engine.mr.common.MapReduceExecutable.doWork(MapReduceExecutable.java:131) > at > org.apache.kylin.job.execution.AbstractExecutable.execute(AbstractExecutable.java:179) > at > org.apache.kylin.job.execution.DefaultChainedExecutable.doWork(DefaultChainedExecutable.java:71) > at > org.apache.kylin.job.execution.AbstractExecutable.execute(AbstractExecutable.java:179) > at > org.apache.kylin.job.impl.threadpool.DefaultScheduler$JobRunner.run(DefaultScheduler.java:114) > at > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) > at java.lang.Thread.run(Thread.java:748) > Suppressed: java.io.FileNotFoundException: File does not exist: > C:\Users\NAD096~1.ZHA\AppData\Local\Temp\kylin_job_meta1467762575939435363\meta > at org.apache.commons.io.FileUtils.forceDelete(FileUtils.java:2275) > at > org.apache.kylin.common.persistence.AutoDeleteDirectory.close(AutoDeleteDirectory.java:56) > at > org.apache.kylin.engine.mr.common.JobRelatedMetaUtil.dumpAndUploadKylinPropsAndMetadata(JobRelatedMetaUtil.java:103) > ... 10 more >
[jira] [Created] (KYLIN-3981) Auto Merge Job failed to execute on windows
Na Zhai created KYLIN-3981: -- Summary: Auto Merge Job failed to execute on windows Key: KYLIN-3981 URL: https://issues.apache.org/jira/browse/KYLIN-3981 Project: Kylin Issue Type: Bug Affects Versions: v2.6.1 Reporter: Na Zhai Assignee: Na Zhai Fix For: v2.6.2 Auto Merge Job failed to execute on windows. It will throw the following errors. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[GitHub] [kylin] nichunen commented on issue #579: KYLIN-3926 set sourceRecordCount when updating statistics
nichunen commented on issue #579: KYLIN-3926 set sourceRecordCount when updating statistics URL: https://github.com/apache/kylin/pull/579#issuecomment-486569346 @kyotoYaho Hi, would you please update the pr? This is an automated message from the Apache Git Service. To respond to the message, please log on to 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 With regards, Apache Git Services
[jira] [Commented] (KYLIN-3939) Open csv files from query exported, the Chinese characters are garbled
[ https://issues.apache.org/jira/browse/KYLIN-3939?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16825806#comment-16825806 ] ASF GitHub Bot commented on KYLIN-3939: --- nichunen commented on pull request #602: KYLIN-3939 add BOM character,slove the bug that it shows Chinese garb… URL: https://github.com/apache/kylin/pull/602 This is an automated message from the Apache Git Service. To respond to the message, please log on to 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 > Open csv files from query exported, the Chinese characters are garbled > > > Key: KYLIN-3939 > URL: https://issues.apache.org/jira/browse/KYLIN-3939 > Project: Kylin > Issue Type: Bug > Components: REST Service >Affects Versions: v2.5.2 >Reporter: zhao jintao >Assignee: zhao jintao >Priority: Minor > > Hi team; > I query sql in kylin portal and then press "Export" button to download the > result; the result is csv files. I open the csv file using excel to get the > query results. > But I find that if the result has Chinese characters, the excel will show > Chinese characters garbled. > Does any one face this problem? -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (KYLIN-3939) Open csv files from query exported, the Chinese characters are garbled
[ https://issues.apache.org/jira/browse/KYLIN-3939?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16825807#comment-16825807 ] ASF subversion and git services commented on KYLIN-3939: Commit c42aafd0bd58935b5ac5836103f05e5208e84ef2 in kylin's branch refs/heads/master from zhaojintaozhao [ https://gitbox.apache.org/repos/asf?p=kylin.git;h=c42aafd ] KYLIN-3939 Add BOM character to the exported csv (#602) > Open csv files from query exported, the Chinese characters are garbled > > > Key: KYLIN-3939 > URL: https://issues.apache.org/jira/browse/KYLIN-3939 > Project: Kylin > Issue Type: Bug > Components: REST Service >Affects Versions: v2.5.2 >Reporter: zhao jintao >Assignee: zhao jintao >Priority: Minor > > Hi team; > I query sql in kylin portal and then press "Export" button to download the > result; the result is csv files. I open the csv file using excel to get the > query results. > But I find that if the result has Chinese characters, the excel will show > Chinese characters garbled. > Does any one face this problem? -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[GitHub] [kylin] nichunen merged pull request #602: KYLIN-3939 add BOM character,slove the bug that it shows Chinese garb…
nichunen merged pull request #602: KYLIN-3939 add BOM character,slove the bug that it shows Chinese garb… URL: https://github.com/apache/kylin/pull/602 This is an automated message from the Apache Git Service. To respond to the message, please log on to 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 With regards, Apache Git Services
[jira] [Comment Edited] (KYLIN-3940) Exception in thread "main" java.lang.IllegalArgumentException: Failed to find metadata store by url: kylin_metadata@hbase
[ https://issues.apache.org/jira/browse/KYLIN-3940?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16825803#comment-16825803 ] praveenece edited comment on KYLIN-3940 at 4/25/19 7:13 AM: No not yet resolved. Still having the same problem. was (Author: praveenece): No not yet resolved. > Exception in thread "main" java.lang.IllegalArgumentException: Failed to find > metadata store by url: kylin_metadata@hbase > - > > Key: KYLIN-3940 > URL: https://issues.apache.org/jira/browse/KYLIN-3940 > Project: Kylin > Issue Type: Task > Components: Environment >Affects Versions: v2.5.2 > Environment: apache-hive-2.3.4-bin > hbase-1.4.9 > hadoop-3.1.0 > apache-kylin-2.5.2-bin-hadoop3 >Reporter: praveenece >Priority: Critical > > I am getting the below error. This error occurred when use > apache-kylin-2.5.2-bin-hadoop3. if we use apache-kylin-2.5.2-bin-hbase1x > kylin gets started. > apache-hive-2.3.4-bin > hbase-1.4.9 > hadoop-3.1.0 > apache-kylin-2.5.2-bin-hadoop3 > Exception in thread "main" java.lang.IllegalArgumentException: Failed to find > metadata store by url: kylin_metadata@hbase > at > org.apache.kylin.common.persistence.ResourceStore.createResourceStore(ResourceStore.java:98) > at > org.apache.kylin.common.persistence.ResourceStore.getStore(ResourceStore.java:110) > at > org.apache.kylin.rest.service.AclTableMigrationTool.checkIfNeedMigrate(AclTableMigrationTool.java:98) > at > org.apache.kylin.tool.AclTableMigrationCLI.main(AclTableMigrationCLI.java:41) > Caused by: java.lang.reflect.InvocationTargetException > at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native > Method) > at > sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) > at > sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) > at java.lang.reflect.Constructor.newInstance(Constructor.java:423) > at > org.apache.kylin.common.persistence.ResourceStore.createResourceStore(ResourceStore.java:92) > ... 3 more > Caused by: java.lang.NoClassDefFoundError: > org/apache/hadoop/hbase/client/ColumnFamilyDescriptor > at > org.apache.kylin.storage.hbase.HBaseResourceStore.getConnection(HBaseResourceStore.java:86) > at > org.apache.kylin.storage.hbase.HBaseResourceStore.createHTableIfNeeded(HBaseResourceStore.java:112) > at > org.apache.kylin.storage.hbase.HBaseResourceStore.(HBaseResourceStore.java:93) > ... 8 more > Caused by: java.lang.ClassNotFoundException: > org.apache.hadoop.hbase.client.ColumnFamilyDescriptor > at java.net.URLClassLoader.findClass(URLClassLoader.java:381) > at java.lang.ClassLoader.loadClass(ClassLoader.java:424) > at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:335) > at java.lang.ClassLoader.loadClass(ClassLoader.java:357) -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (KYLIN-3940) Exception in thread "main" java.lang.IllegalArgumentException: Failed to find metadata store by url: kylin_metadata@hbase
[ https://issues.apache.org/jira/browse/KYLIN-3940?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16825803#comment-16825803 ] praveenece commented on KYLIN-3940: --- No not yet resolved. > Exception in thread "main" java.lang.IllegalArgumentException: Failed to find > metadata store by url: kylin_metadata@hbase > - > > Key: KYLIN-3940 > URL: https://issues.apache.org/jira/browse/KYLIN-3940 > Project: Kylin > Issue Type: Task > Components: Environment >Affects Versions: v2.5.2 > Environment: apache-hive-2.3.4-bin > hbase-1.4.9 > hadoop-3.1.0 > apache-kylin-2.5.2-bin-hadoop3 >Reporter: praveenece >Priority: Critical > > I am getting the below error. This error occurred when use > apache-kylin-2.5.2-bin-hadoop3. if we use apache-kylin-2.5.2-bin-hbase1x > kylin gets started. > apache-hive-2.3.4-bin > hbase-1.4.9 > hadoop-3.1.0 > apache-kylin-2.5.2-bin-hadoop3 > Exception in thread "main" java.lang.IllegalArgumentException: Failed to find > metadata store by url: kylin_metadata@hbase > at > org.apache.kylin.common.persistence.ResourceStore.createResourceStore(ResourceStore.java:98) > at > org.apache.kylin.common.persistence.ResourceStore.getStore(ResourceStore.java:110) > at > org.apache.kylin.rest.service.AclTableMigrationTool.checkIfNeedMigrate(AclTableMigrationTool.java:98) > at > org.apache.kylin.tool.AclTableMigrationCLI.main(AclTableMigrationCLI.java:41) > Caused by: java.lang.reflect.InvocationTargetException > at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native > Method) > at > sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) > at > sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) > at java.lang.reflect.Constructor.newInstance(Constructor.java:423) > at > org.apache.kylin.common.persistence.ResourceStore.createResourceStore(ResourceStore.java:92) > ... 3 more > Caused by: java.lang.NoClassDefFoundError: > org/apache/hadoop/hbase/client/ColumnFamilyDescriptor > at > org.apache.kylin.storage.hbase.HBaseResourceStore.getConnection(HBaseResourceStore.java:86) > at > org.apache.kylin.storage.hbase.HBaseResourceStore.createHTableIfNeeded(HBaseResourceStore.java:112) > at > org.apache.kylin.storage.hbase.HBaseResourceStore.(HBaseResourceStore.java:93) > ... 8 more > Caused by: java.lang.ClassNotFoundException: > org.apache.hadoop.hbase.client.ColumnFamilyDescriptor > at java.net.URLClassLoader.findClass(URLClassLoader.java:381) > at java.lang.ClassLoader.loadClass(ClassLoader.java:424) > at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:335) > at java.lang.ClassLoader.loadClass(ClassLoader.java:357) -- This message was sent by Atlassian JIRA (v7.6.3#76005)