Re: FAILED: ClassCastException org.apache.hadoop.hive.ql.plan.ConditionalWork cannot be cast to org.apache.hadoop.hive.ql.plan.MapredWork
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 <chaoqun@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_1970010100_2014010100_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. >
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_1970010100_2014010100_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.