Hi All, I need confirm that to use filters I have to use the alias defined in the SQL that will be created by Kylin for the flat table and not the table name.
So that if I have a cube with Facts tabe 'facttable' and a lookup table 'products', and I want to select high priced products, I cannot use products.price > 50 mydb.products.price > 50 I am forced to use lookup_1.price > 50 And the number # on the lookup_# will depend on the order of the input. Since this is a Hive Query, I will be forced to use the alias without any workarounds?! Thanks in advance, Shashank
