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.

Reply via email to