Can you provide more details ? e.g what query did you run ? The schema entry <Table name="hive.customer_w_ter">* indicates this is a Hive table. Is the Hive plugin enabled in the Drill storage plugin UI ?
Does the simple query 'Select count(*) from hive.`customer_w_ter` ' run ? On Tue, Jun 13, 2017 at 12:18 PM, Sateesh Karuturi < sateesh.karutu...@gmail.com> wrote: > 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. >
