Missing Rows In Table After Bulk Load

[Amit Shah]

Hi,

I am using phoenix 4.6 and hbase 1.0. After bulk loading 10 mil records
into a table using the psql.py utility, I tried querying the table using
the sqlline.py utility through a select count(*) query. I see only 0.1
million records.

What could be missing?

The psql.py logs are

python psql.py localhost -t TRANSACTIONS_TEST
../examples/Transactions_big.csv
csv columns from database.
Table row timestamp column position: -1
Table name:  SYSTEM.CATALOG
CSV Upsert complete. 10000000 rows upserted
Time: 4679.317 sec(s)


0: jdbc:phoenix:localhost> select count(*) from TRANSACTIONS_TEST;
Table row timestamp column position: -1
Table name:  TRANSACTIONS_TEST
Table row timestamp column position: -1
Table name:  SYSTEM.CATALOG
+------------------------------------------+
|                 COUNT(1)                 |
+------------------------------------------+
| 184402                                   |
+------------------------------------------+
1 row selected (2.173 seconds)

Thanks,
Amit