?????? measure column showing 1 as values instead of the actual values in Kylin SQL Query answer table

[????????]

??????????




------------------ ???????? ------------------
??????: "marc nicole"<mk1853...@gmail.com&gt;; 
????????: 2023??8??2??(??????) ????8:29
??????: "Xiaoxiang Yu"<x...@apache.org&gt;; "user"<user@kylin.apache.org&gt;; 
????: Re: measure column showing 1 as values instead of the actual values in 
Kylin SQL Query answer table



the dataset (csv) is in this form


att1



att2



count_measure










&nbsp;str1&nbsp; &nbsp;&nbsp;

str2&nbsp; &nbsp; &nbsp;

int1


...........
How to extract from it fact table (the count_measure column) and the dimensions 
? in the datasource / model definition in Kylin?


Le&nbsp;mer. 2 ao?0?4t 2023 ??&nbsp;13:32, marc nicole <mk1853...@gmail.com&gt; 
a ??crit&nbsp;:

in the model the measure definition is as&nbsp;follows (I don't understand 
chinese)

{       "name": "COUNT1",       "function": {         "expression": "COUNT",    
     "parameter": {           "type": "column",           "value": 
"attributeName.COUNT1"         },         "returntype": "bigint"       }     },


Le&nbsp;mer. 2 ao?0?4t 2023 ??&nbsp;05:31, Xiaoxiang Yu <x...@apache.org&gt; a 
??crit&nbsp;:

Do you check the answer by Hive/SparkSQL, do Hive/SparkSQL give the expected 
answer?
If you have checked, I think you can give us you cube defination(CubeDesc in 
Json) and the SQL statement you queried, so we can discuss in detail?&nbsp;







--
Best wishes to you !&nbsp;
From ??Xiaoxiang Yu







At 2023-08-02 04:35:04, "marc nicole" <mk1853...@gmail.com&gt; wrote:
The measure is of type column (not constant) and is bigint. I selected the 
measure from the dropdown corretly as well. measure column returns 1 for all 
column values instead of actual values when querying the cube. What could be 
the underlying problem? cube or model defining? or maybe data source attribute 
types?

Maybe I should create a lookup table with the fact table (which I am not doing 
so far)?

Why the measure column in query answer is showing only 1 as values ??