?????? kylin 1.6 Not sorted! last error when sending select query on ui

[nice]

i have set the column to 'dict' and save the cube config.
but when i open the cube config again, it turn back to 'time' encoding again.
it seems to be that kylin would auto change the column encoding type to 'time' 
, even i manually changed it to 'dict'.
the column name is report_date




------------------ ???????? ------------------
??????:                                                                         
                                               "user"                           
                                                         
<yaqian_zh...@126.com&gt;;
????????:&nbsp;2020??9??4??(??????) ????2:43
??????:&nbsp;"user"<user@kylin.apache.org&gt;;

????:&nbsp;Re: kylin 1.6 Not sorted! last  error when sending select query on ui



Hi:

You can setting the encoding type to ??dict?? and rebuild this cube. Then try 
this SQL again.

&gt; ?? 2020??9??2????15:35??nice <zhengze...@qq.com&gt; ??????
&gt; 
&gt; Hi, my cube set column REPORT_DATE as time encoding when setting rowkeys.
&gt; And it was built sucessfully.
&gt; 
&gt; But when i query on ui, it throws error "Not sorted! last"
&gt; 
&gt; 
&gt; 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,
&gt; 
&gt; 
&gt; <fe3a6...@b8544415.5d4b4f5f.jpg.jpg&gt;
&gt; 
&gt; json cube is
&gt; {
&gt;&nbsp;&nbsp; "uuid": "383a0df2-c98b-4c6e-9e34-7f8881dd5a05",
&gt;&nbsp;&nbsp; "last_modified": 1599028445780,
&gt;&nbsp;&nbsp; "version": "1.6.0",
&gt;&nbsp;&nbsp; "name": "time_test",
&gt;&nbsp;&nbsp; "model_name": "GPUB_CLAIM_CASE_D_DIM_PYCL_CASE_D",
&gt;&nbsp;&nbsp; "description": "",
&gt;&nbsp;&nbsp; "null_string": null,
&gt;&nbsp;&nbsp; "dimensions": [
&gt;&nbsp;&nbsp;&nbsp;&nbsp; {
&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "name": "REPORT_DATE",
&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "table": 
"PCT_ODS_SAFE.DMD_GPUB_CLAIM_CASE_D_DIM_PYCL_CASE_D_VIEW",
&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "column": "REPORT_DATE",
&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "derived": null
&gt;&nbsp;&nbsp;&nbsp;&nbsp; }
&gt;&nbsp;&nbsp; ],
&gt;&nbsp;&nbsp; "measures": [
&gt;&nbsp;&nbsp;&nbsp;&nbsp; {
&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "name": "_COUNT_",
&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "function": {
&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "expression": "COUNT",
&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "parameter": {
&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "type": 
"constant",
&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "value": "1",
&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
"next_parameter": null
&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; },
&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "returntype": "bigint"
&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; },
&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "dependent_measure_ref": null
&gt;&nbsp;&nbsp;&nbsp;&nbsp; }
&gt;&nbsp;&nbsp; ],
&gt;&nbsp;&nbsp; "dictionaries": [],
&gt;&nbsp;&nbsp; "rowkey": {
&gt;&nbsp;&nbsp;&nbsp;&nbsp; "rowkey_columns": [
&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; {
&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "column": "REPORT_DATE",
&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "encoding": "time",
&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "isShardBy": false
&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }
&gt;&nbsp;&nbsp;&nbsp;&nbsp; ]
&gt;&nbsp;&nbsp; },
&gt;&nbsp;&nbsp; "hbase_mapping": {
&gt;&nbsp;&nbsp;&nbsp;&nbsp; "column_family": [
&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; {
&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "name": "F1",
&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "columns": [
&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; {
&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
"qualifier": "M",
&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
"measure_refs": [
&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
 "_COUNT_"
&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ]
&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }
&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ]
&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }
&gt;&nbsp;&nbsp;&nbsp;&nbsp; ]
&gt;&nbsp;&nbsp; },
&gt;&nbsp;&nbsp; "aggregation_groups": [
&gt;&nbsp;&nbsp;&nbsp;&nbsp; {
&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "includes": [
&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "REPORT_DATE"
&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ],
&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "select_rule": {
&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "hierarchy_dims": [],
&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "mandatory_dims": [],
&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "joint_dims": []
&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }
&gt;&nbsp;&nbsp;&nbsp;&nbsp; }
&gt;&nbsp;&nbsp; ],
&gt;&nbsp;&nbsp; "signature": "Cntz5Wab+zlnnnvWXFmCRQ==",
&gt;&nbsp;&nbsp; "notify_list": [],
&gt;&nbsp;&nbsp; "status_need_notify": [
&gt;&nbsp;&nbsp;&nbsp;&nbsp; "ERROR",
&gt;&nbsp;&nbsp;&nbsp;&nbsp; "DISCARDED",
&gt;&nbsp;&nbsp;&nbsp;&nbsp; "SUCCEED"
&gt;&nbsp;&nbsp; ],
&gt;&nbsp;&nbsp; "partition_date_start": 0,
&gt;&nbsp;&nbsp; "partition_date_end": 3153600000000,
&gt;&nbsp;&nbsp; "auto_merge_time_ranges": [
&gt;&nbsp;&nbsp;&nbsp;&nbsp; 604800000,
&gt;&nbsp;&nbsp;&nbsp;&nbsp; 2419200000
&gt;&nbsp;&nbsp; ],
&gt;&nbsp;&nbsp; "retention_range": 0,
&gt;&nbsp;&nbsp; "engine_type": 2,
&gt;&nbsp;&nbsp; "storage_type": 2,
&gt;&nbsp;&nbsp; "override_kylin_properties": {
&gt;&nbsp;&nbsp;&nbsp;&nbsp; 
"kylin.hive.config.override.mapreduce.job.queuename": "queue_9999_01",
&gt;&nbsp;&nbsp;&nbsp;&nbsp; 
"kylin.job.mr.config.override.mapreduce.job.queuename": "queue_9999_01"
&gt;&nbsp;&nbsp; }
&gt; }
&gt; 
&gt; 
&gt;