drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sateesh Karuturi <sateesh.karutu...@gmail.com>
Subject Getting Exception while running Drill-mondrian cube
Date Tue, 13 Jun 2017 19:18:49 GMT
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.

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message