[jira] [Assigned] (KYLIN-4011) Kyling grouping function
[
https://issues.apache.org/jira/browse/KYLIN-4011?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Yaqian Zhang reassigned KYLIN-4011:
---
Assignee: Yaqian Zhang
> Kyling grouping function
>
>
> Key: KYLIN-4011
> URL: https://issues.apache.org/jira/browse/KYLIN-4011
> Project: Kylin
> Issue Type: Bug
> Components: Query Engine
>Affects Versions: v2.6.2
>Reporter: tag
>Assignee: Yaqian Zhang
>Priority: Major
>
> {{```}}
> {{select dim1, case grouping(dim2) when 1 then 'ALL' else dim2 end, sum(col)
> as metric1 from table group by grouping sets((dim1, dim2), (dim1));}}
> {{```}}
> {{`case grouping(dim2) when 2 then 'All' else dim2 end` can work in version
> v2.5.2, but invalid in version v2.6.2. }}
> {{How to query aggregate by grouping sets?}}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
[jira] [Commented] (KYLIN-4011) Kyling grouping function
[
https://issues.apache.org/jira/browse/KYLIN-4011?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16967405#comment-16967405
]
Yaqian Zhang commented on KYLIN-4011:
-
Hi:
I tested GROUPING function in kylin 2.6.3 and it works well.
!image-2019-11-05-18-04-46-639.png|width=405,height=319!
> Kyling grouping function
>
>
> Key: KYLIN-4011
> URL: https://issues.apache.org/jira/browse/KYLIN-4011
> Project: Kylin
> Issue Type: Bug
> Components: Query Engine
>Affects Versions: v2.6.2
>Reporter: tag
>Assignee: Yaqian Zhang
>Priority: Major
> Attachments: image-2019-11-05-18-04-46-639.png
>
>
> {{```}}
> {{select dim1, case grouping(dim2) when 1 then 'ALL' else dim2 end, sum(col)
> as metric1 from table group by grouping sets((dim1, dim2), (dim1));}}
> {{```}}
> {{`case grouping(dim2) when 2 then 'All' else dim2 end` can work in version
> v2.5.2, but invalid in version v2.6.2. }}
> {{How to query aggregate by grouping sets?}}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
[jira] [Updated] (KYLIN-4011) Kyling grouping function
[
https://issues.apache.org/jira/browse/KYLIN-4011?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Yaqian Zhang updated KYLIN-4011:
Attachment: image-2019-11-05-18-04-46-639.png
> Kyling grouping function
>
>
> Key: KYLIN-4011
> URL: https://issues.apache.org/jira/browse/KYLIN-4011
> Project: Kylin
> Issue Type: Bug
> Components: Query Engine
>Affects Versions: v2.6.2
>Reporter: tag
>Assignee: Yaqian Zhang
>Priority: Major
> Attachments: image-2019-11-05-18-04-46-639.png
>
>
> {{```}}
> {{select dim1, case grouping(dim2) when 1 then 'ALL' else dim2 end, sum(col)
> as metric1 from table group by grouping sets((dim1, dim2), (dim1));}}
> {{```}}
> {{`case grouping(dim2) when 2 then 'All' else dim2 end` can work in version
> v2.5.2, but invalid in version v2.6.2. }}
> {{How to query aggregate by grouping sets?}}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
[jira] [Assigned] (KYLIN-4077) Kylin does not handle queries with GROUP BY constant.
[
https://issues.apache.org/jira/browse/KYLIN-4077?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Yaqian Zhang reassigned KYLIN-4077:
---
Assignee: Yaqian Zhang
> Kylin does not handle queries with GROUP BY constant.
> --
>
> Key: KYLIN-4077
> URL: https://issues.apache.org/jira/browse/KYLIN-4077
> Project: Kylin
> Issue Type: Bug
> Environment: Apache Kylin 2.6.2-hadoop3
>Reporter: Krzysztof Zarzycki
>Assignee: Yaqian Zhang
>Priority: Major
>
> I connect Tableau to Kylin and one of the queries it generates has a clause
> {{GROUP BY 1.10001}} , that Kylin cannot handle.
> {code:java}
> From line 1, column 8 to line 1, column 15: Aggregate expression is illegal
> in GROUP BY clause while executing SQL: "select count(*) from
> report_sales.kylin_sales_model GROUP BY 1.101 LIMIT 5" {code}
> Alternatively, I connected to Kylin with Hive JdbcStorageHandler and it
> translates the query to {{GROUP BY TRUE}} and that is also not handled.
> {code:java}
> No DataTypeSerializer for type _literal_type while executing SQL: "select
> count(*) from report_sales.kylin_sales_model GROUP BY TRUE LIMIT 5"
> {code}
> Expected behavior:
> Kylin supports queries with {{GROUP BY }}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
[GitHub] [kylin] bigxiaochu commented on issue #899: KYLIN-4205 configuration support set hive.intermediate-table-prefix
bigxiaochu commented on issue #899: KYLIN-4205 configuration support set hive.intermediate-table-prefix URL: https://github.com/apache/kylin/pull/899#issuecomment-549798802 @lshmouse https://github.com/apache/kylin/pull/919 is only website document, and this pr is features code . Because the document has been merged, should the code be merged together？ Thanks 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] Markz666 opened a new pull request #921: Fix streaming model broken when kylin.source.hive.database-for-flat-t…
Markz666 opened a new pull request #921: Fix streaming model broken when kylin.source.hive.database-for-flat-t… URL: https://github.com/apache/kylin/pull/921 …able set to value other than default. 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] asf-ci commented on issue #921: Fix streaming model broken when kylin.source.hive.database-for-flat-t…
asf-ci commented on issue #921: Fix streaming model broken when kylin.source.hive.database-for-flat-t… URL: https://github.com/apache/kylin/pull/921#issuecomment-549803285 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
[GitHub] [kylin] codecov-io commented on issue #921: Fix streaming model broken when kylin.source.hive.database-for-flat-t…
codecov-io commented on issue #921: Fix streaming model broken when kylin.source.hive.database-for-flat-t… URL: https://github.com/apache/kylin/pull/921#issuecomment-549813614 # [Codecov](https://codecov.io/gh/apache/kylin/pull/921?src=pr&el=h1) Report > :exclamation: No coverage uploaded for pull request base (`master@b6a0064`). [Click here to learn what that means](https://docs.codecov.io/docs/error-reference#section-missing-base-commit). > The diff coverage is `n/a`. [](https://codecov.io/gh/apache/kylin/pull/921?src=pr&el=tree) ```diff @@Coverage Diff@@ ## master #921 +/- ## = Coverage ? 25.44% Complexity? 6110 = Files ? 1412 Lines ?85030 Branches ?11921 = Hits ?21636 Misses?61305 Partials ? 2089 ``` -- [Continue to review full report at Codecov](https://codecov.io/gh/apache/kylin/pull/921?src=pr&el=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/921?src=pr&el=footer). Last update [b6a0064...6aaa16d](https://codecov.io/gh/apache/kylin/pull/921?src=pr&el=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 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-4232) add sql function date_from_now
[ https://issues.apache.org/jira/browse/KYLIN-4232?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ZhouKang updated KYLIN-4232: Description: SELECT "DATE", count(1) from table WHERE "DATE" = 'date_from_now(-1, '-MM-dd') group by "DATE" (was: SELECT \"DATE\", count(1) from table WHERE \"DATE\" = ''date_from_now(-1, '-MM-dd') group by \"DATE\") > add sql function date_from_now > --- > > Key: KYLIN-4232 > URL: https://issues.apache.org/jira/browse/KYLIN-4232 > Project: Kylin > Issue Type: New Feature >Reporter: ZhouKang >Priority: Major > > SELECT "DATE", count(1) from table WHERE "DATE" = 'date_from_now(-1, > '-MM-dd') group by "DATE" -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Updated] (KYLIN-4232) add sql function date_from_now
[ https://issues.apache.org/jira/browse/KYLIN-4232?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ZhouKang updated KYLIN-4232: Description: SELECT "DATE", count(1) from table WHERE "DATE" = date_from_now(-1, '-MM-dd') group by "DATE" (was: SELECT "DATE", count(1) from table WHERE "DATE" = 'date_from_now(-1, '-MM-dd') group by "DATE") > add sql function date_from_now > --- > > Key: KYLIN-4232 > URL: https://issues.apache.org/jira/browse/KYLIN-4232 > Project: Kylin > Issue Type: New Feature >Reporter: ZhouKang >Priority: Major > > SELECT "DATE", count(1) from table WHERE "DATE" = date_from_now(-1, > '-MM-dd') group by "DATE" -- This message was sent by Atlassian Jira (v8.3.4#803005)
