Spark SQL doesn't produce output while hive does

[mayangyang02]

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楼