SparkSql中的ISNULL和CASE WHEN方法

• sqlContext.sql("select (CASE WHEN ISNULL(B.age)=false THEN B.age ELSE  A.age END  ) AS age , A.name AS name  from (select * from people01 ) A  left join  (select * from people02)  B  on A.name= B.name").show()
• spark.sql("""select *, case when rand <= %s then 1

                                when rand <= %s then 2
                                else 3 end as mod_val_test2
                        from temp"""%(0.35,0.7))
 

• spark.sql("CREATE TABLE day16_19 AS \

SELECT  user_id,item_id,behavior_type,case when substr(time,1,10)='2014-12-16' then 16 \
          when substr(time,1,10)='2014-12-17' then 17 \
          when substr(time,1,10)='2014-12-18' then 18 else 0 end as day  from user_test")