You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@kylin.apache.org by taylor zhang <ch...@163.com> on 2015/12/28 11:51:36 UTC

FAILED: ClassCastException org.apache.hadoop.hive.ql.plan.ConditionalWork cannot be cast to org.apache.hadoop.hive.ql.plan.MapredWork

hi all

I got below error when ran example cude 'kylin_sales_cube', it seems that
hive cannot insert data into external table? i have no idea and cannot get
help from internet ....can you please help?


hive> INSERT OVERWRITE TABLE
kylin_intermediate_kylin_sales_cube_desc_19700101000000_20140101000000_abd5658e_303f_4d5f_b2f6_61cac37fc782
SELECT
    > KYLIN_SALES.PART_DT
    > ,KYLIN_SALES.LEAF_CATEG_ID
    > ,KYLIN_SALES.LSTG_SITE_ID
    > ,KYLIN_CATEGORY_GROUPINGS.META_CATEG_NAME
    > ,KYLIN_CATEGORY_GROUPINGS.CATEG_LVL2_NAME
    > ,KYLIN_CATEGORY_GROUPINGS.CATEG_LVL3_NAME
    > ,KYLIN_SALES.LSTG_FORMAT_NAME
    > ,KYLIN_SALES.PRICE
    > ,KYLIN_SALES.SELLER_ID
    > FROM DEFAULT.KYLIN_SALES as KYLIN_SALES 
    > INNER JOIN DEFAULT.KYLIN_CAL_DT as KYLIN_CAL_DT
    > ON KYLIN_SALES.PART_DT = KYLIN_CAL_DT.CAL_DT
    > INNER JOIN DEFAULT.KYLIN_CATEGORY_GROUPINGS as
KYLIN_CATEGORY_GROUPINGS
    > ON KYLIN_SALES.LEAF_CATEG_ID = KYLIN_CATEGORY_GROUPINGS.LEAF_CATEG_ID
AND KYLIN_SALES.LSTG_SITE_ID = KYLIN_CATEGORY_GROUPINGS.SITE_ID;

FAILED: ClassCastException org.apache.hadoop.hive.ql.plan.ConditionalWork
cannot be cast to org.apache.hadoop.hive.ql.plan.MapredWork

--
View this message in context: http://apache-kylin.74782.x6.nabble.com/FAILED-ClassCastException-org-apache-hadoop-hive-ql-plan-ConditionalWork-cannot-be-cast-to-org-apachk-tp2944.html
Sent from the Apache Kylin mailing list archive at Nabble.com.

Re: FAILED: ClassCastException org.apache.hadoop.hive.ql.plan.ConditionalWork cannot be cast to org.apache.hadoop.hive.ql.plan.MapredWork

Posted by yu feng <ol...@gmail.com>.
execute this sql with hive -e 'sql' and check the result, I think this is
something error with you hive env, maybe hive version problem...

2015-12-28 18:51 GMT+08:00 taylor zhang <ch...@163.com>:

> hi all
>
> I got below error when ran example cude 'kylin_sales_cube', it seems that
> hive cannot insert data into external table? i have no idea and cannot get
> help from internet ....can you please help?
>
>
> hive> INSERT OVERWRITE TABLE
>
> kylin_intermediate_kylin_sales_cube_desc_19700101000000_20140101000000_abd5658e_303f_4d5f_b2f6_61cac37fc782
> SELECT
>     > KYLIN_SALES.PART_DT
>     > ,KYLIN_SALES.LEAF_CATEG_ID
>     > ,KYLIN_SALES.LSTG_SITE_ID
>     > ,KYLIN_CATEGORY_GROUPINGS.META_CATEG_NAME
>     > ,KYLIN_CATEGORY_GROUPINGS.CATEG_LVL2_NAME
>     > ,KYLIN_CATEGORY_GROUPINGS.CATEG_LVL3_NAME
>     > ,KYLIN_SALES.LSTG_FORMAT_NAME
>     > ,KYLIN_SALES.PRICE
>     > ,KYLIN_SALES.SELLER_ID
>     > FROM DEFAULT.KYLIN_SALES as KYLIN_SALES
>     > INNER JOIN DEFAULT.KYLIN_CAL_DT as KYLIN_CAL_DT
>     > ON KYLIN_SALES.PART_DT = KYLIN_CAL_DT.CAL_DT
>     > INNER JOIN DEFAULT.KYLIN_CATEGORY_GROUPINGS as
> KYLIN_CATEGORY_GROUPINGS
>     > ON KYLIN_SALES.LEAF_CATEG_ID = KYLIN_CATEGORY_GROUPINGS.LEAF_CATEG_ID
> AND KYLIN_SALES.LSTG_SITE_ID = KYLIN_CATEGORY_GROUPINGS.SITE_ID;
>
> FAILED: ClassCastException org.apache.hadoop.hive.ql.plan.ConditionalWork
> cannot be cast to org.apache.hadoop.hive.ql.plan.MapredWork
>
> --
> View this message in context:
> http://apache-kylin.74782.x6.nabble.com/FAILED-ClassCastException-org-apache-hadoop-hive-ql-plan-ConditionalWork-cannot-be-cast-to-org-apachk-tp2944.html
> Sent from the Apache Kylin mailing list archive at Nabble.com.
>