sqoop-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Abraham Elmahrek <...@cloudera.com>
Subject Re: Sqoop eval function
Date Tue, 31 Dec 2013 18:24:52 GMT
Hey user,

You should be able to use the "tee" command for something like that.

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

-Abe


On Tue, Dec 31, 2013 at 2:17 AM, yogesh kumar <yogeshsqoop@gmail.com> wrote:

> 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