sqoop-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Abraham Elmahrek <...@cloudera.com>
Subject Re: Capture record cound using sqoop eval
Date Fri, 09 Aug 2013 00:17:40 GMT
Hey User,

I don't think it's possible. Looking at EvalSqlTool.java, it looks like
"ResultSetPrinter" is used in all cases. You should be able to use grep or
awk to extract the result.

-Abe


On Thu, Aug 8, 2013 at 5:00 PM, VKing Gorri <vkinggorri@yahoo.com> wrote:

> Hi,
>
> I would like to store record count of a MySQL table in a variable using
> sqoop eval. How could I suppress the formatting from the QueryResult
> and just get count so that I could export the value to a variable?  Please
> suggest.
>
> sqoop eval --connect <> --username <> --password <> --query "select
count(1)
> from table_nm"
> ------------------------
> | count(1)             |
> ------------------------
> | 3768                 |
> ------------------------
> Thanks!
>

Mime
View raw message