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
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                 |