<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>question HBASE only storing 3 versions in Support Questions</title>
    <link>https://community.cloudera.com/t5/Support-Questions/HBASE-only-storing-3-versions/m-p/224802#M186665</link>
    <description>&lt;P&gt;Hbase is not saving all the versions of imported data despite versions set to 40 ?&lt;/P&gt;&lt;P&gt;1- create table with cf versions 40 &lt;/P&gt;&lt;PRE&gt;create 'PUR_ACCT_PHX','cf1'
&lt;/PRE&gt;
&lt;PRE&gt;alter 'PUR_ACCT_PHX',{NAME =&amp;gt; 'cf1', VERSIONS =&amp;gt; 40}
&lt;/PRE&gt;
&lt;PRE&gt;hbase(main):004:0&amp;gt; describe 'PUR_ACCT_PHX'
Table PUR_ACCT_PHX is ENABLED
PUR_ACCT_PHX
COLUMN FAMILIES DESCRIPTION
{NAME =&amp;gt; 'cf1', BLOOMFILTER =&amp;gt; 'ROW', VERSIONS =&amp;gt; '40', IN_MEMORY =&amp;gt; 'false', KEEP_DELETED_CELLS =&amp;gt; 'FALSE', DATA_BLOCK_ENCODING =&amp;gt; 'NONE', TTL =&amp;gt; 'FOREVER', COMPR
ESSION =&amp;gt; 'NONE', MIN_VERSIONS =&amp;gt; '0', BLOCKCACHE =&amp;gt; 'true', BLOCKSIZE =&amp;gt; '65536', REPLICATION_SCOPE =&amp;gt; '0'}
&lt;/PRE&gt;&lt;P&gt;2- sqoop import table data consisting of 38 records&lt;/P&gt;&lt;PRE&gt;SQL&amp;gt; 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)&lt;/PRE&gt;&lt;PRE&gt;SQL&amp;gt; select count(*) from tab4;
  COUNT(*)
----------
        38&lt;/PRE&gt;&lt;PRE&gt;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
&lt;/PRE&gt;&lt;P&gt;3- scan hbase for all 38 versions but shows only 3 values/column &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="68568-capture.jpg" style="width: 1152px;"&gt;&lt;img src="https://community.cloudera.com/t5/image/serverpage/image-id/15469i37A3F0ACEB9B338C/image-size/medium?v=v2&amp;amp;px=400" role="button" title="68568-capture.jpg" alt="68568-capture.jpg" /&gt;&lt;/span&gt;&lt;/P&gt;</description>
    <pubDate>Sun, 18 Aug 2019 01:40:09 GMT</pubDate>
    <dc:creator>aliyesami</dc:creator>
    <dc:date>2019-08-18T01:40:09Z</dc:date>
  </channel>
</rss>

