The difference since used encode column names that support in 4.10 version(Also see PHOENIX-1598 <https://issues.apache.org/jira/browse/PHOENIX-1598>). You can config COLUMN_ENCODED_BYTES property to keep the original column names in the create table SQL, an example for:
create table test( id varchar primary key, col varchar )COLUMN_ENCODED_BYTES =0 ; ---------------------------------------- Jaanai Zhang Best regards! Anil <anilk...@gmail.com> 于2018年12月11日周二 下午1:24写道: > HI, > > We have upgraded phoenix to Phoenix-4.11.0-cdh5.11.2 from phoenix 4.7. > > Problem - When a table is created in phoenix, underlying hbase column > names and phoenix column names are different. Tables created in 4.7 version > looks good. Looks > > CREATE TABLE TST_TEMP (TID VARCHAR PRIMARY KEY ,PRI VARCHAR,SFLG > VARCHAR,PFLG VARCHAR,SOLTO VARCHAR,BILTO VARCHAR) COMPRESSION = 'SNAPPY'; > > 0: jdbc:phoenix:dq-13.labs.> select TID,PRI,SFLG from TST_TEMP limit 2; > +-------------+------------+-----------+ > | TID | PRI | SFLG | > +-------------+------------+-----------+ > | 0060189122 | 0.00 | | > | 0060298478 | 13390.26 | | > +-------------+------------+-----------+ > > > hbase(main):011:0> scan 'TST_TEMP', {LIMIT => 2} > ROW COLUMN+CELL > 0060189122 column=0:\x00\x00\x00\x00, > timestamp=1544296959236, value=x > 0060189122 column=0:\x80\x0B, > timestamp=1544296959236, value=0.00 > 0060298478 column=0:\x00\x00\x00\x00, > timestamp=1544296959236, value=x > 0060298478 column=0:\x80\x0B, > timestamp=1544296959236, value=13390.26 > > > hbase columns names are completely different than phoenix column names. > This change observed only post up-gradation. all existing tables created in > earlier versions looks good and alter statements to existing tables also > looks good. > > Is there any workaround to avoid this difference? we could not run hbase > mapreduce jobs on hbase tables created by phoenix. Thanks. > > Thanks > > > > > > >