Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 Search Hadoop and all its subprojects:

Switch to Threaded View
Sqoop >> mail # user >> Capture record cound using sqoop eval


Copy link to this message
-
Re: Capture record cound using sqoop eval
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 <[EMAIL PROTECTED]> 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!
>
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB