Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

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


Copy link to this message
-
Capture record cound using sqoop eval
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!