sqoop-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From yogesh kumar <yogeshsq...@gmail.com>
Subject Re: Sqoop eval function
Date Tue, 31 Dec 2013 10:17:18 GMT
Thanks Abe.

I have tried this

   VAR=$(sqoop-eval
--query "select max(Salary) from emp..." \
--username ${user} \
--password ${Pass} \
>> ${SQOOP_LOG} 2>&1 | awk '/([0-9]+)/{print $2}')

echo "The vale of VAR is "
echo $VAR

It dosen't store the vale into VAR, It shows it into a Log file i have used
by passing through a config file

*In here If if do remove  " >> ${SQOOP_LOG} 2>&1 "  it shows the result and
store the value into VAR but also the messages from sqoop to the consol.*
I put all sqoop messages in a log file by using this .

I was trying to put sqoop messages into a file and the result into a VAR,

Pls suggest whats I am missing here or how to get it

Many thanks in advance and a very happy new year

Thanks
Yogesh



On Tue, Dec 31, 2013 at 2:55 AM, Abraham Elmahrek <abe@cloudera.com> wrote:

> Sorry,
>
> To be more clear... you should be able to do something like:
>
> MYVAL=$(sqoop-eval -query "SELECT COUNT(*) FROM test" ... |  awk
> '/([0-9]+)/{print $2}')
>
> or
>
> MYVAL=$(sqoop-eval -query "SELECT COUNT(*) FROM test" ... |  grep -Po
> "\d+")
>
> -Abe
>
>
> On Mon, Dec 30, 2013 at 1:17 PM, Abraham Elmahrek <abe@cloudera.com>wrote:
>
>> Hey There,
>>
>> The Sqoop eval command is more for verification and preview purposes than
>> actual usage. With that being said... you can definitely pipe the result of
>> sqoop eval into a file and perform what ever formatting you see fit (ie
>> with AWK).
>>
>> -Abe
>>
>>
>> On Mon, Dec 30, 2013 at 2:09 AM, yogesh kumar <yogeshsqoop@gmail.com>wrote:
>>
>>> Hello all,
>>>
>>> I am doing some select operation with sqoop evel function. like
>>>
>>> sqoop eval -libjars ..
>>> --query "select max(salary) from employe where dept = HR"
>>> -- username abc
>>> --password abc
>>>
>>>
>>> Its working fine, I want to store the result of this query into a unix
>>> shell script variable..
>>>  for using this vale for further operations...
>>>
>>>
>>> Pls help and suggest how to stroe the value into a vriable.
>>>
>>> Thanks & Regards
>>> Yogesh Kumar
>>>
>>>
>>
>>
>

Mime
View raw message