You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@kylin.apache.org by fan_gw <fa...@sina.com> on 2021/02/24 07:10:01 UTC
Why Cube Size is diffrent with Storage?
Hi
I Build a Cube. Source Table Size is 274.68m, Cube storage is 594M. But Cube Size is 14.29T. I build this cube many many times. And run clean storage many time. But The Cube Size is Always Grow Up.
What should I Do To Make The Cube Size = Storage Size?
Re: Why Cube Size is diffrent with Storage?
Posted by fan_gw <fa...@sina.com>.
Yes. The other cube had the same problem. When I drop one of them or all of the cube and clean storage and recreate cube , the problem is still there.
> 在 2021年2月26日，17:13，Yaqian Zhang <Ya...@126.com> 写道：
>
> Hi:
> I tested kylin 3.1.1 in my cdh57 environment and built kylin_sales_cube many times. At last, the values of the cube size and the cube storage are basically the same, although there are some differences.
> This problem may have something to do with your local special operation or configuration. Is there any similar phenomenon in other cubes?
>
>> 在 2021年2月25日，14:25，fan_gw <fa...@sina.com> 写道：
>>
>>
>> kylin 3.1.1
>>
>>
>>>> 在 2021年2月25日，10:32，Yaqian Zhang <Ya...@126.com> 写道：
>>>
>>> Hi:
>>> Theoretically, Cube storage and Cube size should be consistent. Can you provide the kylin version you use? which is convenient to reproduce the problem.
>>>
>>>> 在 2021年2月24日，15:10，fan_gw <fa...@sina.com> 写道：
>>>>
>>>> Hi
>>>>
>>>> I Build a Cube. Source Table Size is 274.68m, Cube storage is 594M. But Cube Size is 14.29T. I build this cube many many times. And run clean storage many time. But The Cube Size is Always Grow Up.
>>>>
>>>> What should I Do To Make The Cube Size = Storage Size?
>>>>
>>>>
>>>> <image0.png>
>>>>
>>>
>>>
>
>
Re: Why Cube Size is diffrent with Storage?
Posted by fan_gw <fa...@sina.com>.
When I build cube, there is a little more data addin source table.
> 在 2021年2月26日，17:13，Yaqian Zhang <Ya...@126.com> 写道：
>
> Hi:
> I tested kylin 3.1.1 in my cdh57 environment and built kylin_sales_cube many times. At last, the values of the cube size and the cube storage are basically the same, although there are some differences.
> This problem may have something to do with your local special operation or configuration. Is there any similar phenomenon in other cubes?
>
>> 在 2021年2月25日，14:25，fan_gw <fa...@sina.com> 写道：
>>
>>
>> kylin 3.1.1
>>
>>
>>>> 在 2021年2月25日，10:32，Yaqian Zhang <Ya...@126.com> 写道：
>>>
>>> Hi:
>>> Theoretically, Cube storage and Cube size should be consistent. Can you provide the kylin version you use? which is convenient to reproduce the problem.
>>>
>>>> 在 2021年2月24日，15:10，fan_gw <fa...@sina.com> 写道：
>>>>
>>>> Hi
>>>>
>>>> I Build a Cube. Source Table Size is 274.68m, Cube storage is 594M. But Cube Size is 14.29T. I build this cube many many times. And run clean storage many time. But The Cube Size is Always Grow Up.
>>>>
>>>> What should I Do To Make The Cube Size = Storage Size?
>>>>
>>>>
>>>> <image0.png>
>>>>
>>>
>>>
>
>
Re: Why Cube Size is diffrent with Storage?
Posted by Yaqian Zhang <Ya...@126.com>.
Hi:
I tested kylin 3.1.1 in my cdh57 environment and built kylin_sales_cube many times. At last, the values of the cube size and the cube storage are basically the same, although there are some differences.
This problem may have something to do with your local special operation or configuration. Is there any similar phenomenon in other cubes?
> 在 2021年2月25日，14:25，fan_gw <fa...@sina.com> 写道：
>
>
> kylin 3.1.1
>
>
>> 在 2021年2月25日，10:32，Yaqian Zhang <Ya...@126.com> 写道：
>>
>> Hi:
>> Theoretically, Cube storage and Cube size should be consistent. Can you provide the kylin version you use? which is convenient to reproduce the problem.
>>
>>> 在 2021年2月24日，15:10，fan_gw <fa...@sina.com> 写道：
>>>
>>> Hi
>>>
>>> I Build a Cube. Source Table Size is 274.68m, Cube storage is 594M. But Cube Size is 14.29T. I build this cube many many times. And run clean storage many time. But The Cube Size is Always Grow Up.
>>>
>>> What should I Do To Make The Cube Size = Storage Size?
>>>
>>>
>>> <image0.png>
>>>
>>
>>
Re: Why Cube Size is diffrent with Storage?
Posted by fan_gw <fa...@sina.com>.
kylin 3.1.1
> 在 2021年2月25日，10:32，Yaqian Zhang <Ya...@126.com> 写道：
>
> Hi:
> Theoretically, Cube storage and Cube size should be consistent. Can you provide the kylin version you use? which is convenient to reproduce the problem.
>
>> 在 2021年2月24日，15:10，fan_gw <fa...@sina.com> 写道：
>>
>> Hi
>>
>> I Build a Cube. Source Table Size is 274.68m, Cube storage is 594M. But Cube Size is 14.29T. I build this cube many many times. And run clean storage many time. But The Cube Size is Always Grow Up.
>>
>> What should I Do To Make The Cube Size = Storage Size?
>>
>>
>> <image0.png>
>>
>
>
Re: Why Cube Size is diffrent with Storage?
Posted by Yaqian Zhang <Ya...@126.com>.
Hi:
Theoretically, Cube storage and Cube size should be consistent. Can you provide the kylin version you use? which is convenient to reproduce the problem.
> 在 2021年2月24日，15:10，fan_gw <fa...@sina.com> 写道：
>
> Hi
>
> I Build a Cube. Source Table Size is 274.68m, Cube storage is 594M. But Cube Size is 14.29T. I build this cube many many times. And run clean storage many time. But The Cube Size is Always Grow Up.
>
> What should I Do To Make The Cube Size = Storage Size?
>
>
> <image0.png>
>