thanks shaofeng, yang, yes, it puzzled me a lot, since I the structure of table test1 under "QUERY" table differs from that of the table test1 under "Tables", but it is the same with structure of the CUBE "test1" I built, thus, I think it as a CUBE till now~
in addition, if I drop the cube test1, what will shown under "QUERY" tab for the syncd hive table "test1", what's the rule of the tables shown under "QUERY" tab? 2015-05-12 11:39 GMT+08:00 Li Yang <[email protected]>: > I see the question now.. well, what lists on "Query" tab is tables not > cubes. You have 10 cubes, but they all from one table. So for analyst (who > don't care about cube), all they know is there's a table called test1, > he/she can query. > > And yes, you can drop the test1 cube which does not contain any filter. > > On Tue, May 12, 2015 at 11:30 AM, dong wang <[email protected]> > wrote: > > > 0, I have a fact table named test1 > > 1, I build a cube with no filter and the same name 'test1' as that of the > > fact table, the cube 'test1' is shown on the "Query" tab > > 2, then I build 10 little cube with FILTERs(different where) and with > > different names based on the SAME fact tables test1, the names of 10 > little > > cubes seperately are : test1_sub1, test1_sub2, test1_sub3, ... , > > test1_sub10, after all of the 10 cubes are built successfully, it > shocked > > me a lot, I cannot see any test1_subx under "Query" tab > > > > however, when I do some queries, I can find the log shows that it hit the > > cube correctly which I want with the info "Realization Names:", which > seems > > satisfy what Luke talked to me last time, but I still wonder, can I drop > > the above cube "test1", since I only want the query to hit test1_subx > > >
