Hi: You can setting the encoding type to ‘dict’ and rebuild this cube. Then try this SQL again.
> 在 2020年9月2日，15:35，nice <[email protected]> 写道： > > Hi, my cube set column REPORT_DATE as time encoding when setting rowkeys. > And it was built sucessfully. > > But when i query on ui, it throws error "Not sorted! last" > > > Error while executing SQL "select report_date, count(1) from > PCT_ODS_SAFE.DMD_GPUB_CLAIM_CASE_D_DIM_PYCL_CASE_D_VIEW group by report_date > LIMIT 500": Not sorted! last: REPORT_DATE=60902150400000,COUNT__=1, fetched: > REPORT_DATE=751218759000,COUNT__=1, > > > <[email protected]> > > json cube is > { > "uuid": "383a0df2-c98b-4c6e-9e34-7f8881dd5a05", > "last_modified": 1599028445780, > "version": "1.6.0", > "name": "time_test", > "model_name": "GPUB_CLAIM_CASE_D_DIM_PYCL_CASE_D", > "description": "", > "null_string": null, > "dimensions": [ > { > "name": "REPORT_DATE", > "table": "PCT_ODS_SAFE.DMD_GPUB_CLAIM_CASE_D_DIM_PYCL_CASE_D_VIEW", > "column": "REPORT_DATE", > "derived": null > } > ], > "measures": [ > { > "name": "_COUNT_", > "function": { > "expression": "COUNT", > "parameter": { > "type": "constant", > "value": "1", > "next_parameter": null > }, > "returntype": "bigint" > }, > "dependent_measure_ref": null > } > ], > "dictionaries": [], > "rowkey": { > "rowkey_columns": [ > { > "column": "REPORT_DATE", > "encoding": "time", > "isShardBy": false > } > ] > }, > "hbase_mapping": { > "column_family": [ > { > "name": "F1", > "columns": [ > { > "qualifier": "M", > "measure_refs": [ > "_COUNT_" > ] > } > ] > } > ] > }, > "aggregation_groups": [ > { > "includes": [ > "REPORT_DATE" > ], > "select_rule": { > "hierarchy_dims": [], > "mandatory_dims": [], > "joint_dims": [] > } > } > ], > "signature": "Cntz5Wab+zlnnnvWXFmCRQ==", > "notify_list": [], > "status_need_notify": [ > "ERROR", > "DISCARDED", > "SUCCEED" > ], > "partition_date_start": 0, > "partition_date_end": 3153600000000, > "auto_merge_time_ranges": [ > 604800000, > 2419200000 > ], > "retention_range": 0, > "engine_type": 2, > "storage_type": 2, > "override_kylin_properties": { > "kylin.hive.config.override.mapreduce.job.queuename": "queue_9999_01", > "kylin.job.mr.config.override.mapreduce.job.queuename": "queue_9999_01" > } > } > > >
