[
https://issues.apache.org/jira/browse/HIVE-15089?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15614364#comment-15614364
]
Zoltan Haindrich commented on HIVE-15089:
-----------------------------------------
[~CLJ0918] can you check that, instead:{{LOCATE(A.fenci,B.gamename)}} , try
using {{LOCATE(A.fenci,B.gamename) > 0}}
> Error: java.lang.RuntimeException: Hive Runtime Error while closing
> operators: java.lang.Integer cannot be cast to java.lang.Boolean
> ------------------------------------------------------------------------------------------------------------------------------------
>
> Key: HIVE-15089
> URL: https://issues.apache.org/jira/browse/HIVE-15089
> Project: Hive
> Issue Type: Bug
> Reporter: chen cong
>
> SELECT userid , gamename , SUM(times) AS sumtimes
> FROM user_fenci_sumcount A
> RIGHT JOIN need_recommende_game B
> ON (TRUE)
> WHERE LOCATE(A.fenci,B.gamename)
> GROUP BY userid , gamename
> ORDER BY A.userid , sumtimes DESC
> Error: java.lang.RuntimeException: Hive Runtime Error while closing
> operators: java.lang.Integer cannot be cast to java.lang.Boolean
> How can I solve it ?
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
