Hi, I created a table in Phoenix with three column families and Inserted the values as shown below
Syntax : > CREATE TABLE TESTCF (MYKEY VARCHAR NOT NULL PRIMARY KEY, CF1.COL1 VARCHAR, > CF2.COL2 VARCHAR, CF3.COL3 VARCHAR) > UPSERT INTO TESTCF (MYKEY,CF1.COL1,CF2.COL2,CF3.COL3)values > ('Key2','CF1','CF2','CF3') > UPSERT INTO TESTCF (MYKEY,CF1.COL1,CF2.COL2,CF3.COL3)values > ('Key2','CF12','CF22','CF32') When I try to scan same table in Hbase hbase(main):010:0> scan "TESTCF" > ROW COLUMN+CELL > Key1 column=CF1:COL1, timestamp=1457682385805, value=CF1 > Key1 column=CF1:_0, timestamp=1457682385805, value= > Key1 column=CF2:COL2, timestamp=1457682385805, value=CF2 > Key1 column=CF3:COL3, timestamp=1457682385805, value=CF3 > Key2 column=CF1:COL1, timestamp=1457682426396, value=CF12 > Key2 column=CF1:_0, timestamp=1457682426396, value= > Key2 column=CF2:COL2, timestamp=1457682426396, value=CF22 > Key2 column=CF3:COL3, timestamp=1457682426396, value=CF32 > 2 row(s) in 0.0260 seconds My query is why I am getting CF1:_0 one extra column in each row with no value. Can any body explain me . Would really appreciate the help. Thanks, Divya