Re: Hive Update : Null Pointer Exception while using If statement

2015-07-24 Thread Shashi Vishwakarma
It is string. Here is output from describe command. hive> describe employee; OK id string ename string On Fri, Jul 24, 2015 at 12:33 PM, @Sanjiv Singh wrote: > What is the type of employee.id ? it is integer , then change insert > statement to : > > > ins

Re: Hive Update : Null Pointer Exception while using If statement

2015-07-24 Thread @Sanjiv Singh
What is the type of employee.id ? it is integer , then change insert statement to : insert overwrite table employee_incr select employee.id,employee.ename,if( employee.id= 1 ,12,employee.id ) as employee.id from employee; Regards Sanjiv Singh Mob : +091 9990-447-339 On Fri, Jul 24, 2015 at 11:

Hive Update : Null Pointer Exception while using If statement

2015-07-23 Thread Shashi Vishwakarma
Hi Experts, I have table in hive in which i have to update certain records. I am using hive 0.13 version. I did bit of googling and found that i can use If-Else statement with insert overwrite for doing this but after running a query it is throwing null pointer exception. Here is my Employee tabl