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.
|