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
VKing Gorri 2013-08-09, 00:00
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                 |