kylin-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "liyang (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (KYLIN-3389) intersect_count error
Date Sat, 09 Jun 2018 23:46:00 GMT

    [ 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)

Mime
View raw message