Re: measure column showing 1 as values instead of the actual values in Kylin SQL Query answer table
大神，能帮我解决一下我碰到的问题吗？维度表的快照怎么能不让取最新的，在kylin4.0.3的使用过程中，在同一天构建不同日期分区数据时，维度表需要切换，但是当天的最后一次构建会导致今天构建的其他天数据也使用了最后一次所关联的维度表，现在的想法是每次构建关联维度表的数据在变，但是也要让当天已经构建过的数据不发生变化，有什么方法可以实现。 | | 李甜彪 | | ltb1...@163.com | Replied Message | From | Xiaoxiang Yu | | Date | 8/2/2023 11:31 | | To | , | | Subject | Re:measure column showing 1 as values instead of the actual values in Kylin SQL Query answer table | 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? -- Best wishes to you ! From ：Xiaoxiang Yu At 2023-08-02 04:35:04, "marc nicole" 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 ??
Re:measure column showing 1 as values instead of the actual values in Kylin SQL Query answer table
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? -- Best wishes to you ! From ：Xiaoxiang Yu At 2023-08-02 04:35:04, "marc nicole" 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 ??
measure column showing 1 as values instead of the actual values in Kylin SQL Query answer table
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 ??
