check the data schema especially for user_mobile

On Mon, Mar 4, 2019 at 1:18 AM mayangyang02 <mayangyan...@imdada.cn> wrote:

> Hi,
>
> We have a sql. When we ran it with Hive, it produced the result normally.
> But when we ran it with Spark, id didn’t produce any output.
>
> We found that what caused the problem is the where statement. The where
> statement is as following:
>
> where 1=1 and user_id <> '未知' and user_mobile <> -99
> Can anyone please tell what’s the problem and how can we avoid this
> problem?
>
> Thans a lot!
>
> Best
>     Regards
>
> 马阳阳
> Phone: 15021906687
> E-mail: mayangyan...@imdada.cn
> Address: 上海市杨浦区杨树浦路1088号东方渔人码头20楼
>

Reply via email to