as you see I am using the right jar which has the HbaseConfiguration but why its not finding it ? #java -classpath /usr/hdp/2.6.4.0-91/hadoop/client/hadoop-common.jar:. RetriveData Exception in thread "main" java.lang.NoClassDefFoundError: org/apache/hadoop/hbase/HBaseConfiguration at RetriveData.main(RetriveData.java:16) Caused by: java.lang.ClassNotFoundException: org.apache.hadoop.hbase.HBaseConfiguration at java.net.URLClassLoader.findClass(URLClassLoader.java:381) at java.lang.ClassLoader.loadClass(ClassLoader.java:424) at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:331) at java.lang.ClassLoader.loadClass(ClassLoader.java:357) ... 1 more # jar tvf /usr/hdp/2.6.4.0-91/hbase/lib/hbase-common.jar | grep "org/apache/hadoop/hbase/HBaseConfiguration" 9678 Thu Jan 04 10:27:46 EST 2018 org/apache/hadoop/hbase/HBaseConfiguration.class ... View more

hi Shu you wrote and you are right ..its importing only one record with m1 on each run . I tried 4 sqoop loads and got 4 versions. that means sqoop import to hbase table will not store all the versions but from hbase shell it will store all the versions) is it a bug or feature ? is Hortonworks aware of this and what is their comment ? ... View more

can anyone from Hortonworks please take a look at this issue ? ... View more

any suggestions on what I am doing wrong ? ... View more

no still I see 3 version. can someone try to reproduce this on their end ? hbase(main):001:0> scan 'PUR_ACCT_PHX1',{VERSIONS=>40} ROW COLUMN+CELL 1001181 column=cf1:ACCTSTAT_ACCT_STATUS_CODE, timestamp=1524501493799, value=01 1001181 column=cf1:ACCTSTAT_ACCT_STATUS_CODE, timestamp=1524501436206, value=01 1001181 column=cf1:ACCTSTAT_ACCT_STATUS_CODE, timestamp=1524501358930, value=01 1001181 column=cf1:ACCTTYPE_ACCT_TYPE_CODE, timestamp=1524501493799, value=01 1001181 column=cf1:ACCTTYPE_ACCT_TYPE_CODE, timestamp=1524501436206, value=01 1001181 column=cf1:ACCTTYPE_ACCT_TYPE_CODE, timestamp=1524501358930, value=01 1001181 column=cf1:EMP_EMP_CODE, timestamp=1524501493799, value=9999 1001181 column=cf1:EMP_EMP_CODE, timestamp=1524501436206, value=9999 1001181 column=cf1:EMP_EMP_CODE, timestamp=1524501358930, value=9999 ... View more

also share your sqoop command please ... View more

hi Harald your command gives the same output as mine with three versions only. there is something else going on here than the command syntax I think. btw if I create any other table locally I can store more than 3 versions , so it has something to do with how sqoop is loading data into hbase ... View more

no this command is not correct hbase(main):023:0> scan 'PUR_ACCT_PHX',{VERSIONS >=40} SyntaxError: (hbase):23: odd number list for Hash.scan 'PUR_ACCT_PHX',{VERSIONS >=40} ... View more