https://community.cloudera.com/t5/Support-Questions/HBASE-only-storing-3-versions/m-p/224811#M186674 <A rel="user" href="https://community.cloudera.com/users/10115/sahmad43.html" nodeid="10115">@Sami Ahmad</A><P>Unfortunately, i'm not able to reproduce the scenario in my end.<BR />i have created countries table in hbase with <STRONG>40</STRONG> versions</P><P>Then ran sqoop import to this table with 1 mapper</P><PRE>sqoop import --connect '**' --username root--password 'root' --query "SELECT '1' as CountryID,CountryCode from countries where \$CONDITIONS" -m 1 --hbase-table countries --column-family c --hbase-row-key CountryID</PRE><P>i'm assigning value '1' for each countryid and i'm having 241 records in counties table once the import got finished even though i'm having table with 40 versions hbase only showing the last record(that means <STRONG>sqoop import to hbase table</STRONG> will not store all the versions but from <STRONG>hbase shell it will store all the versions</STRONG>)</P><PRE>hbase&gt; scan 'countries',{ VERSIONS =&gt;40} ROW COLUMN+CELL 1 column=c:CountryCode, timestamp=1525221297408, value=ZW</PRE><P>I ran the same sqoop import again to this table then i'm able to see 2 versions of as shown below.</P><PRE>hbase&gt;scan 'countries',{ VERSIONS =&gt;40} ROW COLUMN+CELL 1 column=c:CountryCode, timestamp=1525221408212, value=ZW 1 column=c:CountryCode, timestamp=1525221297408, value=ZW</PRE><P>for third run i'm able to see 3 versions</P><PRE>hbase&gt; scan 'countries',{ VERSIONS =&gt;40} ROW COLUMN+CELL 1 column=c:CountryCode, timestamp=1525221470733, value=ZW 1 column=c:CountryCode, timestamp=1525221408212, value=ZW 1 column=c:CountryCode, timestamp=1525221297408, value=ZW</PRE><P>if i run same sqoop import for 40 times then i'm having 40 versions with same value as zw in hbase table.<BR />My hbase version is <STRONG>1.1.2.2.5.3.0-37 and </STRONG>sqoop<STRONG> </STRONG><STRONG>1.4.6.2.5.3.0-37</STRONG><B>, </B></P><P><B></B>For your case even for first import you are able to see 3 versions(i think because of -m 4 argument is doing 3 versions instead of 1).</P><P>Try this</P><PRE>hbase&gt; disable 'PUR_ACCT_PHX1'</PRE><PRE>hbase&gt; drop 'PUR_ACCT_PHX1'</PRE><PRE>hbase&gt; create 'PUR_ACCT_PHX1',{NAME =&gt;'cf1', VERSIONS =&gt;40}</PRE><P>run sqoop import with 1 mapper</P><PRE>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_PHX1 --column-family cf1 --hbase-row-key "ACCT_NUM"-m 1</PRE><PRE>hbase(main):001:0&gt; scan 'PUR_ACCT_PHX1',{VERSIONS=&gt;40}</PRE><P>I think with this scan command you have to see only 1 version instead of 3 versions.</P> Wed, 02 May 2018 08:10:41 GMT Shu_ashu 2018-05-02T08:10:41Z