phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Amit Shah <amits...@gmail.com>
Subject Missing Rows In Table After Bulk Load
Date Fri, 08 Apr 2016 15:21:07 GMT
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

Mime
View raw message