Sqoop hive import shows numRows=0 in message

hive
sqoop

#1

Hello. I am running this command to import order_items data into a new hive table:

sqoop import
–connect jdbc:mysql://ms.itversity.com/retail_db
–username retail_user
–password itversity
–table order_items
–hive-import
–hive-table devfactor_sqoop_import.order_items
–create-hive-table
–num-mappers 3

And then this command to append the same data to the existing hive table:

sqoop import
–connect jdbc:mysql://ms.itversity.com/retail_db
–username retail_user
–password itversity
–table order_items
–hive-import
–hive-table devfactor_sqoop_import.order_items
–num-mappers 3

And both work fine. However, I noticed that the message at the end of the import command shows numRows = 0:


Loading data to table devfactor_sqoop_import.order_items
Table devfactor_sqoop_import.order_items stats: [numFiles=6, numRows=0, totalSize=10817760, rawDataSize=0]
OK
Time taken: 0.686 seconds


The totalSize is changing, and different on the second import. However, the number of rows loaded each time is 172198. So I wanted to ask what the numRows represents.

Also, what is the Add a rating checkbox actually rating? Is it the importance of the question?

Thanks for your help!
Srini