回复： kylin 1.6 Not sorted! last error when sending select query on ui

[nice <zh...@qq.com>]

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_Zhang@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 <zhengzeh_0@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; <FE3A6B36@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;