I give a suggestion: When creating a view, you must **mark** each fact table, and then add the **add** where clause when you aggregate the query. example: select sum(measure), dims from flat_tbl where flat_tbl.tbl_marker = tb1 group by dims;
On Mon, May 25, 2020 at 2:14 PM my is mine <[email protected]> wrote: > i have already join the two tables,i mean when i use sum,i calcutated the > duplicated rows,how i avoid this > > > ------------------ 原始邮件 ------------------ > *发件人:* "yongjie zhao"<[email protected]>; > *发送时间:* 2020年5月25日(星期一) 下午2:12 > *收件人:* "user"<[email protected]>; > *主题:* Re: multi fact tables > > try creating table view in Hive. > > On Mon, May 25, 2020 at 2:00 PM my is mine <[email protected]> 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 >> >
