?????? multi fact tables

[my is mine]

i have already join the two tables,i mean when i use sum,i calcutated the 
duplicated rows,how i avoid this




------------------ ???????? ------------------
??????:&nbsp;"yongjie zhao"<yongjie.z...@gmail.com&gt;;
????????:&nbsp;2020??5??25??(??????) ????2:12
??????:&nbsp;"user"<user@kylin.apache.org&gt;;

????:&nbsp;Re: multi fact tables



try creating&nbsp; table view in Hive.


On Mon, May 25, 2020 at 2:00 PM my is mine <7946...@qq.com&gt; wrote:

i join two fact tables with a wide fact tables,but there are duplicated rows in 
it, it affects the funcation like sum, any suggest, how i sum the column