[jira] [Commented] (KYLIN-4682) java.lang.IndexOutOfBoundsException due to not setting havingFilter correctly

Sun, 03 Jan 2021 18:55:05 -0800 


    [ 
https://issues.apache.org/jira/browse/KYLIN-4682?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17257911#comment-17257911
 ] 

ASF GitHub Bot commented on KYLIN-4682:
---------------------------------------

zzcclp edited a comment on pull request #1529:
URL: https://github.com/apache/kylin/pull/1529#issuecomment-753724772


   Verified passed. LGTM.
   
   ## Before this pr:
   
   **'OPS_USER_ID' is shard by column.**
   
   ```
   SELECT SELLER_ID,
       CASE WHEN OPS_USER_ID = 'MODELER' THEN OPS_USER_ID
            ELSE OPS_REGION
       END AS dyna_GROUP,
       SUM(PRICE)
   FROM KYLIN_SALES
   GROUP BY 1, 2
   HAVING SELLER_id is not null and SUM(PRICE)>10
   ```
   
![image](https://user-images.githubusercontent.com/9430290/103496992-21350980-4e7b-11eb-84e4-ca6da566acd6.png)
   
   
   ```
   select LSTG_FORMAT_NAME, OPS_USER_ID, sum(price) as gmv
   from KYLIN_SALES
   group by LSTG_FORMAT_NAME, OPS_USER_ID
   having OPS_USER_ID = 'MODELER'
   ```
   
![image](https://user-images.githubusercontent.com/9430290/103495689-9d791e00-4e76-11eb-95af-5dd45f90c50a.png)
   
   ## After this pr:
   
   **The sql shown above are executed successfully.**
   
   
![image](https://user-images.githubusercontent.com/9430290/103496961-0cf10c80-4e7b-11eb-879c-65029df7f26c.png)
   
   
   
![image](https://user-images.githubusercontent.com/9430290/103495950-71aa6800-4e77-11eb-8663-4f83fcc7f45e.png)
   
   
   
   
   
   
   
   
   


----------------------------------------------------------------
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:
[email protected]


> java.lang.IndexOutOfBoundsException due to not setting havingFilter correctly
> -----------------------------------------------------------------------------
>
>                 Key: KYLIN-4682
>                 URL: https://issues.apache.org/jira/browse/KYLIN-4682
>             Project: Kylin
>          Issue Type: Improvement
>            Reporter: Zhong Yanghong
>            Assignee: Zhong Yanghong
>            Priority: Major
>
> SQL:
> {code}
> select LSTG_FORMAT_NAME, LEAF_CATEG_ID, sum(price) as gmv
> from TEST_KYLIN_FACT 
> group by LSTG_FORMAT_NAME, LEAF_CATEG_ID
> having LSTG_FORMAT_NAME = 'Auction'
> {code}
> Error stack trace:
> {code}
> Caused by: java.lang.IndexOutOfBoundsException: Index: 3, Size: 1
>       at java.util.ArrayList.rangeCheck(ArrayList.java:657)
>       at java.util.ArrayList.get(ArrayList.java:433)
>       at 
> org.apache.kylin.storage.gtrecord.GTCubeStorageQueryBase.checkHavingCanPushDown(GTCubeStorageQueryBase.java:553)
>       at 
> org.apache.kylin.storage.gtrecord.GTCubeStorageQueryBase.getStorageQueryRequest(GTCubeStorageQueryBase.java:196)
>       at 
> org.apache.kylin.storage.gtrecord.GTCubeStorageQueryBase.searchInner(GTCubeStorageQueryBase.java:98)
>       at 
> org.apache.kylin.storage.gtrecord.GTCubeStorageQueryBase.search(GTCubeStorageQueryBase.java:90)
>       at 
> org.apache.kylin.storage.hybrid.HybridStorageQuery.search(HybridStorageQuery.java:53)
>       at 
> org.apache.kylin.query.enumerator.OLAPEnumerator.queryStorage(OLAPEnumerator.java:117)
>       at 
> org.apache.kylin.query.enumerator.OLAPEnumerator.moveNext(OLAPEnumerator.java:60)
>       at Baz$1$1.moveNext(Unknown Source)
>       at 
> org.apache.calcite.linq4j.EnumerableDefaults.groupBy_(EnumerableDefaults.java:825)
>       at 
> org.apache.calcite.linq4j.EnumerableDefaults.groupBy(EnumerableDefaults.java:761)
>       at 
> org.apache.calcite.linq4j.DefaultEnumerable.groupBy(DefaultEnumerable.java:302)
>       at Baz.bind(Unknown Source)
>       at 
> org.apache.calcite.jdbc.CalcitePrepare$CalciteSignature.enumerable(CalcitePrepare.java:365)
>       at 
> org.apache.calcite.jdbc.CalciteConnectionImpl.enumerable(CalciteConnectionImpl.java:301)
>       at 
> org.apache.calcite.jdbc.CalciteMetaImpl._createIterable(CalciteMetaImpl.java:559)
>       at 
> org.apache.calcite.jdbc.CalciteMetaImpl.createIterable(CalciteMetaImpl.java:550)
>       at 
> org.apache.calcite.avatica.AvaticaResultSet.execute(AvaticaResultSet.java:182)
>       at 
> org.apache.calcite.jdbc.CalciteResultSet.execute(CalciteResultSet.java:67)
>       at 
> org.apache.calcite.jdbc.CalciteResultSet.execute(CalciteResultSet.java:44)
>       at 
> org.apache.calcite.avatica.AvaticaConnection$1.execute(AvaticaConnection.java:667)
>       at 
> org.apache.calcite.jdbc.CalciteMetaImpl.prepareAndExecute(CalciteMetaImpl.java:619)
>       at 
> org.apache.calcite.avatica.AvaticaConnection.prepareAndExecuteInternal(AvaticaConnection.java:675)
>       at 
> org.apache.calcite.avatica.AvaticaStatement.executeInternal(AvaticaStatement.java:156)
>       ... 81 more
> {code}



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

Reply via email to