You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@kylin.apache.org by "liyang (JIRA)" <ji...@apache.org> on 2018/06/09 23:46:00 UTC
[jira] [Commented] (KYLIN-3389) intersect_count error
[ https://issues.apache.org/jira/browse/KYLIN-3389?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16507204#comment-16507204 ]
liyang commented on KYLIN-3389:
-------------------------------
We need the cube_desc json to help. Also before certain it is a bug, better post in mailing list to ask. That is where get most people's attention.
> 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)