Hello.., I am trying to execute the mondrian schema which is integrated with Apache Drill. While running this schema i am getting *customer_w_ter *table not found exception.
here is my schema example: *<Schema name="SteelWheels">* * <Cube name="SteelWheelsSales" cache="true" enabled="true">* * <Table name="orderfact">* * </Table>* * <Dimension foreignKey="CUSTOMERNUMBER" name="Markets">* * <Hierarchy hasAll="true" allMemberName="All Markets" primaryKey="CUSTOMERNUMBER" primaryKeyTable="">* * <Table name="hive.customer_w_ter">* * </Table>* * <Level name="Territory" column="TERRITORY" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">* * </Level>* * <Level name="Country" column="COUNTRY" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">* * </Level>* * <Level name="State Province" column="STATE" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">* * </Level>* * <Level name="City" column="CITY" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">* * </Level>* * </Hierarchy>* * </Dimension>* * <Measure name="Quantity" column="QUANTITYORDERED" formatString="#,###" aggregator="sum">* * </Measure>* * <Measure name="Sales" column="TOTALPRICE" formatString="#,###" aggregator="sum">* * </Measure>* * </Cube>* *</Schema>* Please help me out.