这种你不是应该将需要查询的列设置成维度，然后预计算存储到cube么？cube的维度数据，如果不做刷新，那么就不会变化。
On Wed, Aug 2, 2023 at 11:35 李甜彪 <[email protected]> wrote: > 大神，能帮我解决一下我碰到的问题吗？维度表的快照怎么能不让取最新的， > 在kylin4.0.3的使用过程中，在同一天构建不同日期分区数据时，维度表需要切换，但是当天的最后一次构建会导致今天构建的其他天数据也使用了最后一次所关联的维度表，现在的想法是每次构建关联维度表的数据在变，但是也要让当天已经构建过的数据不发生变化，有什么方法可以实现。 > 李甜彪 > [email protected] > > <https://dashi.163.com/projects/signature-manager/detail/index.html?ftlId=1&name=%E6%9D%8E%E7%94%9C%E5%BD%AA&uid=ltb1028%40163.com&iconUrl=https%3A%2F%2Fmail-online.nosdn.127.net%2Fsm8788d5844515319904345e01d58862c9.jpg&items=%5B%22ltb1028%40163.com%22%5D> > ---- Replied Message ---- > From Xiaoxiang Yu<[email protected]> <[email protected]> > Date 8/2/2023 11:31 > To <[email protected]> , > <[email protected]> <[email protected]> <[email protected]> > 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" <[email protected]> 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 ?? > > > >
