drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Aman Sinha <amansi...@apache.org>
Subject Re: Getting Exception while running Drill-mondrian cube
Date Tue, 13 Jun 2017 20:20:20 GMT
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.karuturi9@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.
>

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