sqoop-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From VKing Gorri <vkinggo...@yahoo.com>
Subject Capture record cound using sqoop eval
Date Fri, 09 Aug 2013 00:00:57 GMT
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