Data set:
CASE1:
kamini,mishrapriya,CASE2:
kamini,mishrapriya,nullCode:(for both the case)
CREATE TABLE Table2(name STRING, lastname STRING)ROW FORMAT DELIMITED FIELDS TERMINATED BY ',';LOAD DATA LOCAL INPATH '/home/edureka/Desktop/kk' INTO table Table2;SELECT * from table where lastname=""; // FOR null values where null is given and blank both.SELECT * from table where lastname="null"; // FOR null values where null is given.
Hive- blank values Print
Modified on: Wed, 6 Jul, 2016 at 12:46 PM
Did you find it helpful? Yes No
Send feedbackSorry we couldn't be helpful. Help us improve this article with your feedback.