[
https://issues.apache.org/jira/browse/KYLIN-3389?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
QingLi updated KYLIN-3389:
--------------------------
Description:
select
city_name,
intersect_count(server_user, dt,array['2018-05-10'] ) aaa
from
table
where dt>='2018-05-10'
group by city_name
return: Error while compiling statement: FAILED: SemanticException [Error
10025]: Line 3:0 Expression not in GROUP BY key ''2018-05-10''
here is cube json:
{
"uuid": "5fe19005-7b31-4225-b7b3-62fde2c72256",
"last_modified": 1527489049614,
"version": "2.2.0.0",
"name": "CUBE_RETENTION_RD_LQ",
"owner": "SY_DW_U_RD",
"descriptor": "CUBE_RETENTION_RD_LQ",
"cost": 50,
"status": "READY",
"segments": [
{
"uuid": "75336a8d-a7b6-4465-bb63-fc3ff59b379e",
"name": "20180301000000_20180528000000",
"storage_location_identifier": "KYLIN_JVERXYS4CG",
"date_range_start": 1519862400000,
"date_range_end": 1527465600000,
"source_offset_start": 0,
"source_offset_end": 0,
"status": "READY",
"size_kb": 99,
"input_records": 7534006,
"input_records_size": 136364517,
"last_build_time": 1527489049614,
"last_build_job_id": "729f584e-66aa-46e3-a5b5-837aef69253c",
"create_time_utc": 1527488801260,
"cuboid_shard_nums": {},
"total_shards": 1,
"blackout_cuboids": [],
"binary_signature": null,
"dictionaries": {
"M_ORDER_DETAIL.CITY_NAME":
"/dict/SY_MART_KYLIN.M_ORDER_DETAIL/CITY_NAME/e7373276-ee9a-4308-93cf-ba5f3fafcf23.dict",
"M_ORDER_DETAIL.DT":
"/dict/SY_MART_KYLIN.M_ORDER_DETAIL/DT/29ec1575-8497-4df2-bb51-dcb9e7dda1a1.dict"
},
"snapshots": null,
"rowkey_stats": [
[
"M_ORDER_DETAIL.CITY_NAME",
336,
2
],
[
"M_ORDER_DETAIL.DT",
57,
1
]
]
}
],
"create_time_utc": 1527488778311,
"cuboid_bytes": null,
"cuboid_bytes_recommend": null,
"cuboid_last_optimized": 0,
"size_kb": 99,
"input_records_count": 7534006,
"input_records_size": 136364517
}
what's the problem?
was:
select
city_name,
intersect_count(server_user, dt,array['2018-05-10'] ) aaa
from
table
where dt>='2018-05-10'
group by city_name
提示 Error while compiling statement: FAILED: SemanticException [Error 10025]:
Line 3:0 Expression not in GROUP BY key ''2018-05-10''
Summary: intersect_count error (was: intersect_count使用问题)
> intersect_count error
> ---------------------
>
> Key: KYLIN-3389
> URL: https://issues.apache.org/jira/browse/KYLIN-3389
> Project: Kylin
> Issue Type: Bug
> Components: Measure - Count Distinct
> Affects Versions: v2.2.0
> Environment: hive+kylin+hbase
> Reporter: QingLi
> Priority: Major
> Labels: easyfix
> Fix For: Future
>
> Original Estimate: 168h
> Remaining Estimate: 168h
>
> select
> city_name,
> intersect_count(server_user, dt,array['2018-05-10'] ) aaa
> from
> table
> where dt>='2018-05-10'
> group by city_name
> return: Error while compiling statement: FAILED: SemanticException [Error
> 10025]: Line 3:0 Expression not in GROUP BY key ''2018-05-10''
>
>
>
> here is cube json:
> {
> "uuid": "5fe19005-7b31-4225-b7b3-62fde2c72256",
> "last_modified": 1527489049614,
> "version": "2.2.0.0",
> "name": "CUBE_RETENTION_RD_LQ",
> "owner": "SY_DW_U_RD",
> "descriptor": "CUBE_RETENTION_RD_LQ",
> "cost": 50,
> "status": "READY",
> "segments": [
> {
> "uuid": "75336a8d-a7b6-4465-bb63-fc3ff59b379e",
> "name": "20180301000000_20180528000000",
> "storage_location_identifier": "KYLIN_JVERXYS4CG",
> "date_range_start": 1519862400000,
> "date_range_end": 1527465600000,
> "source_offset_start": 0,
> "source_offset_end": 0,
> "status": "READY",
> "size_kb": 99,
> "input_records": 7534006,
> "input_records_size": 136364517,
> "last_build_time": 1527489049614,
> "last_build_job_id": "729f584e-66aa-46e3-a5b5-837aef69253c",
> "create_time_utc": 1527488801260,
> "cuboid_shard_nums": {},
> "total_shards": 1,
> "blackout_cuboids": [],
> "binary_signature": null,
> "dictionaries": {
> "M_ORDER_DETAIL.CITY_NAME":
> "/dict/SY_MART_KYLIN.M_ORDER_DETAIL/CITY_NAME/e7373276-ee9a-4308-93cf-ba5f3fafcf23.dict",
> "M_ORDER_DETAIL.DT":
> "/dict/SY_MART_KYLIN.M_ORDER_DETAIL/DT/29ec1575-8497-4df2-bb51-dcb9e7dda1a1.dict"
> },
> "snapshots": null,
> "rowkey_stats": [
> [
> "M_ORDER_DETAIL.CITY_NAME",
> 336,
> 2
> ],
> [
> "M_ORDER_DETAIL.DT",
> 57,
> 1
> ]
> ]
> }
> ],
> "create_time_utc": 1527488778311,
> "cuboid_bytes": null,
> "cuboid_bytes_recommend": null,
> "cuboid_last_optimized": 0,
> "size_kb": 99,
> "input_records_count": 7534006,
> "input_records_size": 136364517
> }
>
>
> what's the problem?
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
