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