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