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 <[email protected]> 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 <[email protected]>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
>>
>>
>
>
