Hive: isnotnull: Return true when the value of column is not null, else false

Signature

isnotnull(column)

 

Example

SELECT * FROM emp WHERE isnotnull(gender_age.age);

 

Return true if the value of column is not null, else false.

hive> SELECT * FROM emp;
OK
emp.id	emp.name	emp.hobbies	emp.technology_experience	emp.gender_age	emp.rating	emp.salary
1	Hari	["Football","Cricket"]	{"Java":"3.4Yrs","C":"4.5Yrs"}	{"gender":"Male","age":30}	-1.5	1000000.0
2	Chamu	["Trekking","Watching movies"]	{"Selenium":"5.6Yrs"}	{"gender":"Female","age":38}	3.0	2500000.0
3	Sailu	["Chess","Listening to music"]	{"EmbeddedC":"9Yrs"}	{"gender":"Female","age":32}	2.5	1300000.0
4	Gopi	["Cricket"]	{"Datastage":"11Yrs"}	{"gender":"Male","age":32}	-0.7	8.1E7
5	Rahim	[]	{}	{"gender":"Male","age":null}	-0.7	500000.0
Time taken: 0.049 seconds, Fetched: 5 row(s)
hive> ;
hive> ;
hive> SELECT * FROM emp WHERE isnotnull(gender_age.age);
OK
emp.id	emp.name	emp.hobbies	emp.technology_experience	emp.gender_age	emp.rating	emp.salary
1	Hari	["Football","Cricket"]	{"Java":"3.4Yrs","C":"4.5Yrs"}	{"gender":"Male","age":30}	-1.5	1000000.0
2	Chamu	["Trekking","Watching movies"]	{"Selenium":"5.6Yrs"}	{"gender":"Female","age":38}	3.0	2500000.0
3	Sailu	["Chess","Listening to music"]	{"EmbeddedC":"9Yrs"}	{"gender":"Female","age":32}	2.5	1300000.0
4	Gopi	["Cricket"]	{"Datastage":"11Yrs"}	{"gender":"Male","age":32}	-0.7	8.1E7
Time taken: 0.054 seconds, Fetched: 4 row(s)

 

Previous                                                    Next                                                    Home