Hbase is not saving all the versions of imported data despite versions set to 40 ?
1- create table with cf versions 40
create 'PUR_ACCT_PHX','cf1'
alter 'PUR_ACCT_PHX',{NAME => 'cf1', VERSIONS => 40}
hbase(main):004:0> describe 'PUR_ACCT_PHX'
Table PUR_ACCT_PHX is ENABLED
PUR_ACCT_PHX
COLUMN FAMILIES DESCRIPTION
{NAME => 'cf1', BLOOMFILTER => 'ROW', VERSIONS => '40', IN_MEMORY => 'false', KEEP_DELETED_CELLS => 'FALSE', DATA_BLOCK_ENCODING => 'NONE', TTL => 'FOREVER', COMPR
ESSION => 'NONE', MIN_VERSIONS => '0', BLOCKCACHE => 'true', BLOCKSIZE => '65536', REPLICATION_SCOPE => '0'}
2- sqoop import table data consisting of 38 records
SQL> desc tab4
Name Null? Type
----------------------------------------- -------- ----------------------------
ACCT_NUM NOT NULL NUMBER(8)
PUR_ID NUMBER(10)
PUR_DET_ID NOT NULL NUMBER(10)
PRODUCT_PUR_PRODUCT_CODE VARCHAR2(2)
PROD_AMT NUMBER(10,2)
PUR_TRANS_DATE DATE
ACCTTYPE_ACCT_TYPE_CODE VARCHAR2(2)
ACCTSTAT_ACCT_STATUS_CODE VARCHAR2(2)
EMP_EMP_CODE CHAR(4)
PLAZA_PLAZA_ID CHAR(6)
PURSTAT_PUR_STATUS_CODE CHAR(2)
SQL> select count(*) from tab4;
COUNT(*)
----------
38
sqoop import --connect "jdbc:oracle:thin:@(description=(address=(protocol=tcp)(host=patronQA)(port=1526))(connect_data=(service_name=patron)))" --username PATRON --table PATRON.TAB4 --hbase-table PUR_ACCT_PHX --column-family cf1 --hbase-row-key "ACCT_NUM" -m 4
3- scan hbase for all 38 versions but shows only 3 values/column