elect channel_id from keyword_impressions_log where
> header_date_partition='2013-08-21' and channel_id*10=290640 limit 10
>
> From: Justin Workman
> Reply-To: "user@hive.apache.org"
> Date: Thursday, August 22, 2013 7:17 AM
> To: "user@hive.apache.org"
> Subject
;user@hive.apache.org<mailto:user@hive.apache.org>"
mailto:user@hive.apache.org>>
Date: Thursday, August 22, 2013 7:17 AM
To: "user@hive.apache.org<mailto:user@hive.apache.org>"
mailto:user@hive.apache.org>>
Subject: Re: How to perform arithmetic operations
Try
select emp_name, (emp_no * 10) from emp_table;
Sent from my iPhone
On Aug 22, 2013, at 8:14 AM, Sandeep Nemuri wrote:
Hi all ,
Can we perform arithmetic operator on *select* command.
I have a table emp_table with columns emp_name and emp_no
i want to multiply the data in a emp_no
