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楼 >