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