FYI, I added Gabriel's excellent answer to our FAQs here: https://phoenix.apache.org/faq.html#Why_empty_key_value
On Fri, Mar 11, 2016 at 4:10 AM, Ankit Singhal <[email protected]> wrote: > You may check discussion from below mail chain. > https://www.mail-archive.com/[email protected]/msg19448.html > > > On Fri, Mar 11, 2016 at 3:20 PM, Divya Gehlot <[email protected]> > wrote: > >> >> 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 >> >> >> >> >> >
