Discussion:
Getting Exception while running Drill-mondrian cube
Add Reply
Sateesh Karuturi
2017-06-13 19:18:49 UTC
Reply
Permalink
Raw Message
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.
Aman Sinha
2017-06-13 20:20:20 UTC
Reply
Permalink
Raw Message
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 <
Post by Sateesh Karuturi
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.
*<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.
Loading...