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 <[email protected]>: > 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. >
