[jira] [Commented] (KYLIN-5278) Support Pivot feature of SQL

2022-10-22 Thread liyang (Jira)


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

liyang commented on KYLIN-5278:
---

So PIVOT function gets +1

Let's see it will get more votes.

> Support Pivot feature of SQL
> 
>
> Key: KYLIN-5278
> URL: https://issues.apache.org/jira/browse/KYLIN-5278
> Project: Kylin
>  Issue Type: Wish
>  Components: Query Engine
>Reporter: yoonsung.lee
>Priority: Major
>
> HI. I'm using Kylin 3.1.3 for OLAP.
> It seems that there is no feature of Pivot. (e.g. 
> https://docs.data.world/documentation/sql/concepts/advanced/PIVOT.html ,
> https://calcite.apache.org/javadocAggregate/org/apache/calcite/sql/SqlPivot.html
> )
> I also tried to find source code related to Pivot, but there isn't. 
> Is there no feature for Pivot in Kylin(3 or 4)?
> If not, is there a plan?
> If not, is there a way to write a query like Pivot?
> Best regards :) 



--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Commented] (KYLIN-5278) Support Pivot feature of SQL

2022-10-20 Thread yoonsung.lee (Jira)


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

yoonsung.lee commented on KYLIN-5278:
-

OK. I see, thanks to response :) 

> Support Pivot feature of SQL
> 
>
> Key: KYLIN-5278
> URL: https://issues.apache.org/jira/browse/KYLIN-5278
> Project: Kylin
>  Issue Type: Wish
>  Components: Query Engine
>Reporter: yoonsung.lee
>Priority: Major
>
> HI. I'm using Kylin 3.1.3 for OLAP.
> It seems that there is no feature of Pivot. (e.g. 
> https://docs.data.world/documentation/sql/concepts/advanced/PIVOT.html ,
> https://calcite.apache.org/javadocAggregate/org/apache/calcite/sql/SqlPivot.html
> )
> I also tried to find source code related to Pivot, but there isn't. 
> Is there no feature for Pivot in Kylin(3 or 4)?
> If not, is there a plan?
> If not, is there a way to write a query like Pivot?
> Best regards :) 



--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Commented] (KYLIN-5278) Support Pivot feature of SQL

2022-10-19 Thread Xiaoxiang Yu (Jira)


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

Xiaoxiang Yu commented on KYLIN-5278:
-

As far as I know, there is no such plan.

> Support Pivot feature of SQL
> 
>
> Key: KYLIN-5278
> URL: https://issues.apache.org/jira/browse/KYLIN-5278
> Project: Kylin
>  Issue Type: Wish
>  Components: Query Engine
>Reporter: yoonsung.lee
>Priority: Major
>
> HI. I'm using Kylin 3.1.3 for OLAP.
> It seems that there is no feature of Pivot. (e.g. 
> https://docs.data.world/documentation/sql/concepts/advanced/PIVOT.html ,
> https://calcite.apache.org/javadocAggregate/org/apache/calcite/sql/SqlPivot.html
> )
> I also tried to find source code related to Pivot, but there isn't. 
> Is there no feature for Pivot in Kylin(3 or 4)?
> If not, is there a plan?
> If not, is there a way to write a query like Pivot?
> Best regards :) 



--
This message was sent by Atlassian Jira
(v8.20.10#820010)