phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ankit Singhal <ankitsingha...@gmail.com>
Subject Re: Undefined column. columnName=IS_ROW_TIMESTAMP
Date Fri, 29 Apr 2016 09:47:15 GMT
Hi Arun,

Actually , we missed the quotes as shell will consider everything after ";"
as second command.

bin/sqlline.py "localhost;currentSCN=9"

So, can you fix the timestamp for these columns?
Steps you may follow(but request you to try first on non production cluster
as these are not tested by me).
- Take snapshot of your system.catalog( for backup)
- delete such cells from system.catalog at latest timestamp
- set keep_deleted_cells to false in SYSTEM.CATALOG(remember you should not
have any query running and using schema in point in time snapshots).
- do flush and major_compaction on SYSTEM.CATALOG
- when you don't see those columns and open connection at currentSCN=9 and
alter table to add both the columns.
- you may set keep_deleted_cells back to true in SYSTEM.CATALOG

Regards,
Ankit Singhal



Regards,
Ankit Singhal

On Tue, Apr 26, 2016 at 11:26 PM, Arun Kumaran Sabtharishi <
arun1087@gmail.com> wrote:

> James,
>
> Thanks for the answer. But, why was the currentSCN=9 on connection is not
> working in the first place? Do you have any pointers for us to look into?
>
> Thanks,
> Arun
>
> On Tue, Apr 26, 2016 at 11:12 AM, James Taylor <jamestaylor@apache.org>
> wrote:
>
>> Hi Arun,
>> Yes, this could cause problems, as we base the need to upgrade on the
>> time stamp of the system catalog table.
>> Thanks,
>> James
>>
>>
>> On Tuesday, April 26, 2016, Arun Kumaran Sabtharishi <arun1087@gmail.com>
>> wrote:
>>
>>> Hi Ankit,
>>>
>>> Just following with the question that when the alter statement was
>>> issued with CurrentSCN=9, the current timestamp was not set to 9.
>>> Will this cause an issue in the future if it has to compare the
>>> timestamps?
>>>
>>> Thanks,
>>> Arun
>>>
>>> On Mon, Apr 25, 2016 at 10:32 AM, Arun Kumaran Sabtharishi <
>>> arun1087@gmail.com> wrote:
>>>
>>>> Hi Ankit,
>>>>
>>>> Even though the ALTER TABLE SYSTEM.CATALOG ADD BASE_COLUMN_COUNT
>>>> INTEGER, IS_ROW_TIMESTAMP BOOLEAN; statement threw an exception, it
>>>> actually added the columns to the SYSTEM.CATALOG.
>>>> But, the ./sqlline.py localhost;CurrentSCN=9 did not work. The current
>>>> timestamp was not set to 9. Will this cause an issue in the future if it
>>>> has to compare the timestamps?
>>>>
>>>> After the alter statement was executed and when queried from HBase, the
>>>> following is the output.
>>>>
>>>> hbase(main):004:0> get
>>>> 'SYSTEM.CATALOG',"\x00SYSTEM\x00CATALOG\x00IS_ROW_TIMESTAMP\x000"
>>>> COLUMN                               CELL
>>>>  0 ATA_TYPE                         timestamp=1461362240655,
>>>> value=\x80\x00\x00\x10
>>>>  0:IS_VIEW_REFERENCED                timestamp=1461362240655, value=\x00
>>>>  0:NULLABLE                          timestamp=1461362240655,
>>>> value=\x80\x00\x00\x01
>>>>  0 RDINAL_POSITION                  timestamp=1461362240655,
>>>> value=\x80\x00\x004
>>>>  0 ORT_ORDER                        timestamp=1461362240655,
>>>> value=\x80\x00\x00\x02
>>>>
>>>>
>>>> Thanks,
>>>> Arun
>>>>
>>>>
>>>> On Mon, Apr 25, 2016 at 2:19 AM, Ankit Singhal <
>>>> ankitsinghal59@gmail.com> wrote:
>>>>
>>>>> Yes Arun, it seems fine to me.
>>>>> Can you do it for BASE_COLUMN_COUNT too so that the dependent features
>>>>> work correctly.(Remember use correct INTEGER byte representation for
>>>>> DATA_TYPE column).
>>>>>
>>>>> And, can you also please share output of
>>>>> > scan 'SYSTEM.SEQUENCE'
>>>>>
>>>>> Regards,
>>>>> Ankit
>>>>>
>>>>> On Fri, Apr 22, 2016 at 9:14 PM, Arun Kumaran Sabtharishi <
>>>>> arun1087@gmail.com> wrote:
>>>>>
>>>>>> Ankit,
>>>>>>
>>>>>> Though the ALTER in pheonix failed, a bunch of puts in HBase  did the
>>>>>> job.
>>>>>> Is it okay to do the following? These puts in HBase intends to do
>>>>>> what the ALTER command in phoenix supposed to do.
>>>>>>
>>>>>>    put 'SYSTEM.CATALOG',
>>>>>> "\x00SYSTEM\x00CATALOG\x00IS_ROW_TIMESTAMP\x000",'0:DATA_TYPE',"\x80\x00\x00\x10",9
>>>>>>
>>>>>>    put 'SYSTEM.CATALOG',
>>>>>> "\x00SYSTEM\x00CATALOG\x00IS_ROW_TIMESTAMP\x000",'0:IS_VIEW_REFERENCED',"\x00",9
>>>>>>
>>>>>>    put 'SYSTEM.CATALOG',
>>>>>> "\x00SYSTEM\x00CATALOG\x00IS_ROW_TIMESTAMP\x000",'0:NULLABLE',"\x80\x00\x00\x01",9
>>>>>>
>>>>>>    put 'SYSTEM.CATALOG',
>>>>>> "\x00SYSTEM\x00CATALOG\x00IS_ROW_TIMESTAMP\x000",'0:ORDINAL_POSITION',"\x80\x00\x001",9
>>>>>>
>>>>>>    put 'SYSTEM.CATALOG',
>>>>>> "\x00SYSTEM\x00CATALOG\x00IS_ROW_TIMESTAMP\x000",'0:SORT_ORDER',"\x80\x00\x00\x02",9
>>>>>>
>>>>>>    put 'SYSTEM.CATALOG',
>>>>>> "\x00SYSTEM\x00CATALOG\x00IS_ROW_TIMESTAMP\x000",'0:_0','',9
>>>>>>
>>>>>>
>>>>>> Thanks,
>>>>>>
>>>>>> Arun
>>>>>>
>>>>>> On Fri, Apr 22, 2016 at 10:22 AM, Arun Kumaran Sabtharishi <
>>>>>> arun1087@gmail.com> wrote:
>>>>>>
>>>>>>> Ankit,
>>>>>>>
>>>>>>> When tried executing the query, the following exception is thrown.
>>>>>>>
>>>>>>> Error: ERROR 301 (23000): Concurrent modification to table.
>>>>>>> tableName=SYSTEM.CATALOG (state=23000,code=301)
>>>>>>> org.apache.phoenix.schema.ConcurrentTableMutationException: ERROR
>>>>>>> 301 (23000): Concurrent modification to table. tableName=SYSTEM.CATALOG
>>>>>>>
>>>>>>>         at
>>>>>>> org.apache.phoenix.schema.MetaDataClient.processMutationResult(MetaDataClient.java:2339)
>>>>>>>         at
>>>>>>> org.apache.phoenix.schema.MetaDataClient.addColumn(MetaDataClient.java:2641)
>>>>>>>         at
>>>>>>> org.apache.phoenix.jdbc.PhoenixStatement$ExecutableAddColumnStatement$1.execute(PhoenixStatement.java:1106)
>>>>>>>         at
>>>>>>> org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:322)
>>>>>>>         at
>>>>>>> org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:314)
>>>>>>>         at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53)
>>>>>>>         at
>>>>>>> org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:312)
>>>>>>>         at
>>>>>>> org.apache.phoenix.jdbc.PhoenixStatement.execute(PhoenixStatement.java:1435)
>>>>>>>         at sqlline.Commands.execute(Commands.java:822)
>>>>>>>         at sqlline.Commands.sql(Commands.java:732)
>>>>>>>         at sqlline.SqlLine.dispatch(SqlLine.java:808)
>>>>>>>         at sqlline.SqlLine.begin(SqlLine.java:681)
>>>>>>>         at sqlline.SqlLine.start(SqlLine.java:398)
>>>>>>>
>>>>>>>
>>>>>>> Thank,
>>>>>>> Arun
>>>>>>>
>>>>>>> On Fri, Apr 22, 2016 at 8:59 AM, Ankit Singhal <
>>>>>>> ankitsinghal59@gmail.com> wrote:
>>>>>>>
>>>>>>>> Arun,
>>>>>>>> As per the system.catalog ,there seems no way that upgrade
>>>>>>>> code(adding new columns and view upgrade for version < v4.5) doesn't
>>>>>>>> execute.
>>>>>>>>
>>>>>>>> But anyways, let's add the required columns manually by following
>>>>>>>> below step;
>>>>>>>>
>>>>>>>> >  ./sqlline.py localhost;CurrentSCN=9
>>>>>>>> > ALTER TABLE SYSTEM.CATALOG ADD BASE_COLUMN_COUNT INTEGER,
>>>>>>>> IS_ROW_TIMESTAMP BOOLEAN;
>>>>>>>> >!quit
>>>>>>>>
>>>>>>>> Quit the shell and start new session without CurrentSCN.
>>>>>>>> >  ./sqlline.py localhost
>>>>>>>> > !describe system.catalog
>>>>>>>>
>>>>>>>> this should resolve the issue of missing column.
>>>>>>>>
>>>>>>>> Regards,
>>>>>>>> Ankit Singhal
>>>>>>>>
>>>>>>>>
>>>>>>>> On Fri, Apr 22, 2016 at 3:02 AM, Arun Kumaran Sabtharishi <
>>>>>>>> arun1087@gmail.com> wrote:
>>>>>>>>
>>>>>>>>> Ankit,James,
>>>>>>>>>
>>>>>>>>> Please find the results you have asked for in the attachment text
>>>>>>>>> document.
>>>>>>>>>
>>>>>>>>> Thanks,
>>>>>>>>> Arun
>>>>>>>>>
>>>>>>>>> On Thu, Apr 21, 2016 at 3:12 AM, Ankit Singhal <
>>>>>>>>> ankitsinghal59@gmail.com> wrote:
>>>>>>>>>
>>>>>>>>>> Arun,
>>>>>>>>>> the observations you had is understandable.
>>>>>>>>>> So, that's why we again requested the output of
>>>>>>>>>>
>>>>>>>>>> *echo "scan 'SYSTEM.CATALOG',{RAW=>true}"|bin/hbase shell|grep
>>>>>>>>>> CATALOG*
>>>>>>>>>>
>>>>>>>>>> So that we can help you in adding ROW_TIMESTAMP column in
>>>>>>>>>> system.catalog table so that your phoenix setup works properly and you can
>>>>>>>>>> also see it in !describe command.
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>> On Thu, Apr 21, 2016 at 4:20 AM, Arun Kumaran Sabtharishi <
>>>>>>>>>> arun1087@gmail.com> wrote:
>>>>>>>>>>
>>>>>>>>>>> Another observation:(After upgrading from Phoenix 4.4 to 4.6.1)
>>>>>>>>>>>
>>>>>>>>>>> In a new SYSTEM.CATALOG table , when connected from phoenix
>>>>>>>>>>> 4.6.1 client,
>>>>>>>>>>>
>>>>>>>>>>> !describe SYSTEM.CATALOG does not show IS_ROW_TIMESTAMP
>>>>>>>>>>>
>>>>>>>>>>> But, select * from SYSTEM.CATALOG shows the IS_ROW_TIMESTAMP
>>>>>>>>>>> column.
>>>>>>>>>>>
>>>>>>>>>>> Is this an expected behavior?
>>>>>>>>>>>
>>>>>>>>>>> If I have to see IS_ROW_TIMESTAMP when doing describe, what
>>>>>>>>>>> should I do? This issue is blocking us in the production environment. Any
>>>>>>>>>>> help to resolve or workaround is highly appreciated.
>>>>>>>>>>>
>>>>>>>>>>> Thanks,
>>>>>>>>>>> Arun
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>> On Wed, Apr 20, 2016 at 12:01 PM, Ankit Singhal <
>>>>>>>>>>> ankitsinghal59@gmail.com> wrote:
>>>>>>>>>>>
>>>>>>>>>>>> It's ok if you can just post after grep for CATALOG in a
>>>>>>>>>>>> command output (scan 'SYSTEM.CATALOG', {RAW=>true}).
>>>>>>>>>>>>
>>>>>>>>>>>> On Wed, Apr 20, 2016 at 10:07 PM, Arun Kumaran Sabtharishi <
>>>>>>>>>>>> arun1087@gmail.com> wrote:
>>>>>>>>>>>>
>>>>>>>>>>>>> One more question to add,
>>>>>>>>>>>>> Do we need to have 1000 versions, and KEEP_DELETED_CELL=true?
>>>>>>>>>>>>>
>>>>>>>>>>>>> I have limited the scan in HBase and here is the following
>>>>>>>>>>>>> data.
>>>>>>>>>>>>>
>>>>>>>>>>>>> \x00\x00TEST_TABLE_2 column=0:, timestamp=1460455162842,
>>>>>>>>>>>>> type=DeleteFamily
>>>>>>>>>>>>>
>>>>>>>>>>>>> _0_1460354090089
>>>>>>>>>>>>>
>>>>>>>>>>>>> \x00\x00TEST_TABLE_2 column=0:BASE_COLUMN_COUNT,
>>>>>>>>>>>>> timestamp=1460354090655, value=\x7F\xFF\xFF\xFF
>>>>>>>>>>>>>
>>>>>>>>>>>>> _0_1460354090089
>>>>>>>>>>>>>
>>>>>>>>>>>>> \x00\x00TEST_TABLE_2 column=0:COLUMN_COUNT,
>>>>>>>>>>>>> timestamp=1460354090655, value=\x80\x00\x00\x05
>>>>>>>>>>>>>
>>>>>>>>>>>>> _0_1460354090089
>>>>>>>>>>>>>
>>>>>>>>>>>>> \x00\x00TEST_TABLE_2 column=0:DATA_TABLE_NAME,
>>>>>>>>>>>>> timestamp=1460354090655, type=DeleteColumn
>>>>>>>>>>>>>
>>>>>>>>>>>>> _0_1460354090089
>>>>>>>>>>>>>
>>>>>>>>>>>>> \x00\x00TEST_TABLE_2 column=0:DEFAULT_COLUMN_FAMILY,
>>>>>>>>>>>>> timestamp=1460354090655, value=default
>>>>>>>>>>>>>
>>>>>>>>>>>>> _0_1460354090089
>>>>>>>>>>>>>
>>>>>>>>>>>>> \x00\x00TEST_TABLE_2 column=0:DISABLE_WAL,
>>>>>>>>>>>>> timestamp=1460354090655, value=\x00
>>>>>>>>>>>>>
>>>>>>>>>>>>> _0_1460354090089
>>>>>>>>>>>>>
>>>>>>>>>>>>> \x00\x00TEST_TABLE_2 column=0:IMMUTABLE_ROWS,
>>>>>>>>>>>>> timestamp=1460354090655, value=\x00
>>>>>>>>>>>>>
>>>>>>>>>>>>> _0_1460354090089
>>>>>>>>>>>>>
>>>>>>>>>>>>> \x00\x00TEST_TABLE_2 column=0:INDEX_STATE,
>>>>>>>>>>>>> timestamp=1460354090655, type=DeleteColumn
>>>>>>>>>>>>>
>>>>>>>>>>>>> _0_1460354090089
>>>>>>>>>>>>>
>>>>>>>>>>>>> \x00\x00TEST_TABLE_2 column=0:INDEX_TYPE,
>>>>>>>>>>>>> timestamp=1460354090655, type=DeleteColumn
>>>>>>>>>>>>>
>>>>>>>>>>>>> _0_1460354090089
>>>>>>>>>>>>>
>>>>>>>>>>>>> \x00\x00TEST_TABLE_2 column=0:MULTI_TENANT,
>>>>>>>>>>>>> timestamp=1460354090655, value=\x00
>>>>>>>>>>>>>
>>>>>>>>>>>>> _0_1460354090089
>>>>>>>>>>>>>
>>>>>>>>>>>>> \x00\x00TEST_TABLE_2 column=0:PK_NAME,
>>>>>>>>>>>>> timestamp=1460354090655, type=DeleteColumn
>>>>>>>>>>>>>
>>>>>>>>>>>>> _0_1460354090089
>>>>>>>>>>>>>
>>>>>>>>>>>>> \x00\x00TEST_TABLE_2 column=0:ROW_KEY_ORDER_OPTIMIZABLE,
>>>>>>>>>>>>> timestamp=1460354090655, value=\x01
>>>>>>>>>>>>>
>>>>>>>>>>>>> _0_1460354090089
>>>>>>>>>>>>>
>>>>>>>>>>>>> \x00\x00TEST_TABLE_2 column=0:SALT_BUCKETS,
>>>>>>>>>>>>> timestamp=1460354090655, type=DeleteColumn
>>>>>>>>>>>>>
>>>>>>>>>>>>> _0_1460354090089
>>>>>>>>>>>>>
>>>>>>>>>>>>> \x00\x00TEST_TABLE_2 column=0:STORE_NULLS,
>>>>>>>>>>>>> timestamp=1460354090655, value=\x00
>>>>>>>>>>>>>
>>>>>>>>>>>>> _0_1460354090089
>>>>>>>>>>>>>
>>>>>>>>>>>>> \x00\x00TEST_TABLE_2 column=0:TABLE_SEQ_NUM,
>>>>>>>>>>>>> timestamp=1460354090655, value=\x80\x00\x00\x00\x00\x00\x00\x00
>>>>>>>>>>>>>
>>>>>>>>>>>>> _0_1460354090089
>>>>>>>>>>>>>
>>>>>>>>>>>>> \x00\x00TEST_TABLE_2 column=0:TABLE_TYPE,
>>>>>>>>>>>>> timestamp=1460354090655, value=u
>>>>>>>>>>>>>
>>>>>>>>>>>>> _0_1460354090089
>>>>>>>>>>>>>
>>>>>>>>>>>>> \x00\x00TEST_TABLE_2 column=0:VIEW_INDEX_ID,
>>>>>>>>>>>>> timestamp=1460354090655, type=DeleteColumn
>>>>>>>>>>>>>
>>>>>>>>>>>>> _0_1460354090089
>>>>>>>>>>>>>
>>>>>>>>>>>>> \x00\x00TEST_TABLE_2 column=0:VIEW_STATEMENT,
>>>>>>>>>>>>> timestamp=1460354090655, type=DeleteColumn
>>>>>>>>>>>>>
>>>>>>>>>>>>> _0_1460354090089
>>>>>>>>>>>>>
>>>>>>>>>>>>> \x00\x00TEST_TABLE_2 column=0:VIEW_TYPE,
>>>>>>>>>>>>> timestamp=1460354090655, type=DeleteColumn
>>>>>>>>>>>>>
>>>>>>>>>>>>> _0_1460354090089
>>>>>>>>>>>>>
>>>>>>>>>>>>> \x00\x00TEST_TABLE_2 column=0:_0, timestamp=1460354090655,
>>>>>>>>>>>>> type=DeleteColumn
>>>>>>>>>>>>>
>>>>>>>>>>>>> _0_1460354090089
>>>>>>>>>>>>>
>>>>>>>>>>>>> \x00\x00TEST_TABLE_2 column=0:, timestamp=1460455162842,
>>>>>>>>>>>>> type=DeleteFamily
>>>>>>>>>>>>>
>>>>>>>>>>>>> _0_1460354090089\x00CDS_CLIENT_CORELATION_ID\
>>>>>>>>>>>>>
>>>>>>>>>>>>> x00default
>>>>>>>>>>>>>
>>>>>>>>>>>>> \x00\x00TEST_TABLE_2 column=0:ARRAY_SIZE,
>>>>>>>>>>>>> timestamp=1460354090655, type=DeleteColumn
>>>>>>>>>>>>>
>>>>>>>>>>>>> _0_1460354090089\x00CDS_CLIENT_CORELATION_ID\
>>>>>>>>>>>>>
>>>>>>>>>>>>> x00default
>>>>>>>>>>>>>
>>>>>>>>>>>>> \x00\x00TEST_TABLE_2 column=0:COLUMN_DEF,
>>>>>>>>>>>>> timestamp=1460354090655, type=DeleteColumn
>>>>>>>>>>>>>
>>>>>>>>>>>>> _0_1460354090089\x00CDS_CLIENT_CORELATION_ID\
>>>>>>>>>>>>>
>>>>>>>>>>>>> x00default
>>>>>>>>>>>>>
>>>>>>>>>>>>> \x00\x00TEST_TABLE_2 column=0:COLUMN_SIZE,
>>>>>>>>>>>>> timestamp=1460354090655, type=DeleteColumn
>>>>>>>>>>>>>
>>>>>>>>>>>>> _0_1460354090089\x00CDS_CLIENT_CORELATION_ID\
>>>>>>>>>>>>>
>>>>>>>>>>>>> x00default
>>>>>>>>>>>>>
>>>>>>>>>>>>> \x00\x00TEST_TABLE_2 column=0:DATA_TABLE_NAME,
>>>>>>>>>>>>> timestamp=1460354090655, type=DeleteColumn
>>>>>>>>>>>>>
>>>>>>>>>>>>> _0_1460354090089\x00CDS_CLIENT_CORELATION_ID\
>>>>>>>>>>>>>
>>>>>>>>>>>>> x00default
>>>>>>>>>>>>>
>>>>>>>>>>>>> \x00\x00TEST_TABLE_2 column=0:DATA_TYPE,
>>>>>>>>>>>>> timestamp=1460354090655, value=\x80\x00\x00\x0C
>>>>>>>>>>>>>
>>>>>>>>>>>>> _0_1460354090089\x00CDS_CLIENT_CORELATION_ID\
>>>>>>>>>>>>>
>>>>>>>>>>>>> x00default
>>>>>>>>>>>>>
>>>>>>>>>>>>> \x00\x00TEST_TABLE_2 column=0:DECIMAL_DIGITS,
>>>>>>>>>>>>> timestamp=1460354090655, type=DeleteColumn
>>>>>>>>>>>>>
>>>>>>>>>>>>> _0_1460354090089\x00CDS_CLIENT_CORELATION_ID\
>>>>>>>>>>>>>
>>>>>>>>>>>>> x00default
>>>>>>>>>>>>>
>>>>>>>>>>>>> \x00\x00TEST_TABLE_2 column=0:IS_ROW_TIMESTAMP,
>>>>>>>>>>>>> timestamp=1460354090655, value=\x00
>>>>>>>>>>>>>
>>>>>>>>>>>>> _0_1460354090089\x00CDS_CLIENT_CORELATION_ID\
>>>>>>>>>>>>>
>>>>>>>>>>>>> x00default
>>>>>>>>>>>>>
>>>>>>>>>>>>> \x00\x00TEST_TABLE_2 column=0:IS_VIEW_REFERENCED,
>>>>>>>>>>>>> timestamp=1460354090655, value=\x00
>>>>>>>>>>>>>
>>>>>>>>>>>>> _0_1460354090089\x00CDS_CLIENT_CORELATION_ID\
>>>>>>>>>>>>>
>>>>>>>>>>>>> x00default
>>>>>>>>>>>>>
>>>>>>>>>>>>> \x00\x00TEST_TABLE_2 column=0:KEY_SEQ,
>>>>>>>>>>>>> timestamp=1460354090655, type=DeleteColumn
>>>>>>>>>>>>>
>>>>>>>>>>>>> _0_1460354090089\x00CDS_CLIENT_CORELATION_ID\
>>>>>>>>>>>>>
>>>>>>>>>>>>> x00default
>>>>>>>>>>>>>
>>>>>>>>>>>>> \x00\x00TEST_TABLE_2 column=0:NULLABLE,
>>>>>>>>>>>>> timestamp=1460354090655, value=\x80\x00\x00\x01
>>>>>>>>>>>>>
>>>>>>>>>>>>> _0_1460354090089\x00CDS_CLIENT_CORELATION_ID\
>>>>>>>>>>>>>
>>>>>>>>>>>>> x00default
>>>>>>>>>>>>>
>>>>>>>>>>>>> \x00\x00TEST_TABLE_2 column=0:ORDINAL_POSITION,
>>>>>>>>>>>>> timestamp=1460354090655, value=\x80\x00\x00\x04
>>>>>>>>>>>>>
>>>>>>>>>>>>> _0_1460354090089\x00CDS_CLIENT_CORELATION_ID\
>>>>>>>>>>>>>
>>>>>>>>>>>>> x00default
>>>>>>>>>>>>>
>>>>>>>>>>>>> \x00\x00TEST_TABLE_2 column=0:PK_NAME,
>>>>>>>>>>>>> timestamp=1460354090655, type=DeleteColumn
>>>>>>>>>>>>>
>>>>>>>>>>>>> _0_1460354090089\x00CDS_CLIENT_CORELATION_ID\
>>>>>>>>>>>>>
>>>>>>>>>>>>> x00default
>>>>>>>>>>>>>
>>>>>>>>>>>>> \x00\x00TEST_TABLE_2 column=0:SORT_ORDER,
>>>>>>>>>>>>> timestamp=1460354090655, value=\x80\x00\x00\x02
>>>>>>>>>>>>>
>>>>>>>>>>>>> _0_1460354090089\x00CDS_CLIENT_CORELATION_ID\
>>>>>>>>>>>>>
>>>>>>>>>>>>> x00default
>>>>>>>>>>>>>
>>>>>>>>>>>>> \x00\x00TEST_TABLE_2 column=0:VIEW_CONSTANT,
>>>>>>>>>>>>> timestamp=1460354090655, type=DeleteColumn
>>>>>>>>>>>>>
>>>>>>>>>>>>> _0_1460354090089\x00CDS_CLIENT_CORELATION_ID\
>>>>>>>>>>>>>
>>>>>>>>>>>>> x00default
>>>>>>>>>>>>>
>>>>>>>>>>>>> \x00\x00TEST_TABLE_2 column=0:_0, timestamp=1460354090655,
>>>>>>>>>>>>> type=DeleteColumn
>>>>>>>>>>>>>
>>>>>>>>>>>>> _0_1460354090089\x00CDS_CLIENT_CORELATION_ID\
>>>>>>>>>>>>>
>>>>>>>>>>>>> x00default
>>>>>>>>>>>>>
>>>>>>>>>>>>> \x00\x00TEST_TABLE_2 column=0:, timestamp=1460455162842,
>>>>>>>>>>>>> type=DeleteFamily
>>>>>>>>>>>>>
>>>>>>>>>>>>> _0_1460354090089\x00CDS_PK
>>>>>>>>>>>>>
>>>>>>>>>>>>> \x00\x00TEST_TABLE_2 column=0:ARRAY_SIZE,
>>>>>>>>>>>>> timestamp=1460354090655, type=DeleteColumn
>>>>>>>>>>>>>
>>>>>>>>>>>>> _0_1460354090089\x00CDS_PK
>>>>>>>>>>>>>
>>>>>>>>>>>>> \x00\x00TEST_TABLE_2 column=0:COLUMN_DEF,
>>>>>>>>>>>>> timestamp=1460354090655, type=DeleteColumn
>>>>>>>>>>>>>
>>>>>>>>>>>>> _0_1460354090089\x00CDS_PK
>>>>>>>>>>>>>
>>>>>>>>>>>>> \x00\x00TEST_TABLE_2 column=0:COLUMN_SIZE,
>>>>>>>>>>>>> timestamp=1460354090655, type=DeleteColumn
>>>>>>>>>>>>>
>>>>>>>>>>>>> _0_1460354090089\x00CDS_PK
>>>>>>>>>>>>>
>>>>>>>>>>>>> \x00\x00TEST_TABLE_2 column=0:DATA_TABLE_NAME,
>>>>>>>>>>>>> timestamp=1460354090655, type=DeleteColumn
>>>>>>>>>>>>>
>>>>>>>>>>>>> _0_1460354090089\x00CDS_PK
>>>>>>>>>>>>>
>>>>>>>>>>>>> \x00\x00TEST_TABLE_2 column=0:DATA_TYPE,
>>>>>>>>>>>>> timestamp=1460354090655, value=\x80\x00\x00\x0C
>>>>>>>>>>>>>
>>>>>>>>>>>>> _0_1460354090089\x00CDS_PK
>>>>>>>>>>>>>
>>>>>>>>>>>>> \x00\x00TEST_TABLE_2 column=0:DECIMAL_DIGITS,
>>>>>>>>>>>>> timestamp=1460354090655, type=DeleteColumn
>>>>>>>>>>>>>
>>>>>>>>>>>>> _0_1460354090089\x00CDS_PK
>>>>>>>>>>>>>
>>>>>>>>>>>>> \x00\x00TEST_TABLE_2 column=0:IS_ROW_TIMESTAMP,
>>>>>>>>>>>>> timestamp=1460354090655, value=\x00
>>>>>>>>>>>>>
>>>>>>>>>>>>> _0_1460354090089\x00CDS_PK
>>>>>>>>>>>>>
>>>>>>>>>>>>> \x00\x00TEST_TABLE_2 column=0:IS_VIEW_REFERENCED,
>>>>>>>>>>>>> timestamp=1460354090655, value=\x00
>>>>>>>>>>>>>
>>>>>>>>>>>>> _0_1460354090089\x00CDS_PK
>>>>>>>>>>>>>
>>>>>>>>>>>>> \x00\x00TEST_TABLE_2 column=0:KEY_SEQ,
>>>>>>>>>>>>> timestamp=1460354090655, value=\x80\x01
>>>>>>>>>>>>>
>>>>>>>>>>>>> _0_1460354090089\x00CDS_PK
>>>>>>>>>>>>>
>>>>>>>>>>>>> \x00\x00TEST_TABLE_2 column=0:NULLABLE,
>>>>>>>>>>>>> timestamp=1460354090655, value=\x80\x00\x00\x00
>>>>>>>>>>>>>
>>>>>>>>>>>>> _0_1460354090089\x00CDS_PK
>>>>>>>>>>>>>
>>>>>>>>>>>>> \x00\x00TEST_TABLE_2 column=0:ORDINAL_POSITION,
>>>>>>>>>>>>> timestamp=1460354090655, value=\x80\x00\x00\x05
>>>>>>>>>>>>>
>>>>>>>>>>>>> _0_1460354090089\x00CDS_PK
>>>>>>>>>>>>>
>>>>>>>>>>>>> \x00\x00TEST_TABLE_2 column=0:PK_NAME,
>>>>>>>>>>>>> timestamp=1460354090655, type=DeleteColumn
>>>>>>>>>>>>>
>>>>>>>>>>>>> _0_1460354090089\x00CDS_PK
>>>>>>>>>>>>>
>>>>>>>>>>>>> \x00\x00TEST_TABLE_2 column=0:SORT_ORDER,
>>>>>>>>>>>>> timestamp=1460354090655, value=\x80\x00\x00\x02
>>>>>>>>>>>>>
>>>>>>>>>>>>> _0_1460354090089\x00CDS_PK
>>>>>>>>>>>>>
>>>>>>>>>>>>> \x00\x00TEST_TABLE_2 column=0:VIEW_CONSTANT,
>>>>>>>>>>>>> timestamp=1460354090655, type=DeleteColumn
>>>>>>>>>>>>>
>>>>>>>>>>>>> _0_1460354090089\x00CDS_PK
>>>>>>>>>>>>>
>>>>>>>>>>>>> \x00\x00TEST_TABLE_2 column=0:_0, timestamp=1460354090655,
>>>>>>>>>>>>> type=DeleteColumn
>>>>>>>>>>>>>
>>>>>>>>>>>>> _0_1460354090089\x00CDS_PK
>>>>>>>>>>>>>
>>>>>>>>>>>>> \x00\x00TEST_TABLE_2 column=0:, timestamp=1460455162842,
>>>>>>>>>>>>> type=DeleteFamily
>>>>>>>>>>>>>
>>>>>>>>>>>>> _0_1460354090089\x00CDS_SUB_ORG_ID\x00default
>>>>>>>>>>>>>
>>>>>>>>>>>>> \x00\x00TEST_TABLE_2 column=0:ARRAY_SIZE,
>>>>>>>>>>>>> timestamp=1460354090655, type=DeleteColumn
>>>>>>>>>>>>>
>>>>>>>>>>>>> _0_1460354090089\x00CDS_SUB_ORG_ID\x00default
>>>>>>>>>>>>>
>>>>>>>>>>>>> \x00\x00TEST_TABLE_2 column=0:COLUMN_DEF,
>>>>>>>>>>>>> timestamp=1460354090655, type=DeleteColumn
>>>>>>>>>>>>>
>>>>>>>>>>>>> _0_1460354090089\x00CDS_SUB_ORG_ID\x00default
>>>>>>>>>>>>>
>>>>>>>>>>>>> \x00\x00TEST_TABLE_2 column=0:COLUMN_SIZE,
>>>>>>>>>>>>> timestamp=1460354090655, type=DeleteColumn
>>>>>>>>>>>>>
>>>>>>>>>>>>> _0_1460354090089\x00CDS_SUB_ORG_ID\x00default
>>>>>>>>>>>>>
>>>>>>>>>>>>> \x00\x00TEST_TABLE_2 column=0:DATA_TABLE_NAME,
>>>>>>>>>>>>> timestamp=1460354090655, type=DeleteColumn
>>>>>>>>>>>>>
>>>>>>>>>>>>> _0_1460354090089\x00CDS_SUB_ORG_ID\x00default
>>>>>>>>>>>>>
>>>>>>>>>>>>> \x00\x00TEST_TABLE_2 column=0:DATA_TYPE,
>>>>>>>>>>>>> timestamp=1460354090655, value=\x80\x00\x00\x0C
>>>>>>>>>>>>>
>>>>>>>>>>>>> _0_1460354090089\x00CDS_SUB_ORG_ID\x00default
>>>>>>>>>>>>>
>>>>>>>>>>>>> \x00\x00TEST_TABLE_2 column=0:DECIMAL_DIGITS,
>>>>>>>>>>>>> timestamp=1460354090655, type=DeleteColumn
>>>>>>>>>>>>>
>>>>>>>>>>>>> _0_1460354090089\x00CDS_SUB_ORG_ID\x00default
>>>>>>>>>>>>>
>>>>>>>>>>>>> \x00\x00TEST_TABLE_2 column=0:IS_ROW_TIMESTAMP,
>>>>>>>>>>>>> timestamp=1460354090655, value=\x00
>>>>>>>>>>>>>
>>>>>>>>>>>>> _0_1460354090089\x00CDS_SUB_ORG_ID\x00default
>>>>>>>>>>>>>
>>>>>>>>>>>>> \x00\x00TEST_TABLE_2 column=0:IS_VIEW_REFERENCED,
>>>>>>>>>>>>> timestamp=1460354090655, value=\x00
>>>>>>>>>>>>>
>>>>>>>>>>>>> _0_1460354090089\x00CDS_SUB_ORG_ID\x00default
>>>>>>>>>>>>>
>>>>>>>>>>>>> \x00\x00TEST_TABLE_2 column=0:KEY_SEQ,
>>>>>>>>>>>>> timestamp=1460354090655, type=DeleteColumn
>>>>>>>>>>>>>
>>>>>>>>>>>>> _0_1460354090089\x00CDS_SUB_ORG_ID\x00default
>>>>>>>>>>>>>
>>>>>>>>>>>>> \x00\x00TEST_TABLE_2 column=0:NULLABLE,
>>>>>>>>>>>>> timestamp=1460354090655, value=\x80\x00\x00\x01
>>>>>>>>>>>>>
>>>>>>>>>>>>> _0_1460354090089\x00CDS_SUB_ORG_ID\x00default
>>>>>>>>>>>>>
>>>>>>>>>>>>> \x00\x00TEST_TABLE_2 column=0:ORDINAL_POSITION,
>>>>>>>>>>>>> timestamp=1460354090655, value=\x80\x00\x00\x01
>>>>>>>>>>>>>
>>>>>>>>>>>>> _0_1460354090089\x00CDS_SUB_ORG_ID\x00default
>>>>>>>>>>>>>
>>>>>>>>>>>>> \x00\x00TEST_TABLE_2 column=0:PK_NAME,
>>>>>>>>>>>>> timestamp=1460354090655, type=DeleteColumn
>>>>>>>>>>>>>
>>>>>>>>>>>>> _0_1460354090089\x00CDS_SUB_ORG_ID\x00default
>>>>>>>>>>>>>
>>>>>>>>>>>>> \x00\x00TEST_TABLE_2 column=0:SORT_ORDER,
>>>>>>>>>>>>> timestamp=1460354090655, value=\x80\x00\x00\x02
>>>>>>>>>>>>>
>>>>>>>>>>>>> _0_1460354090089\x00CDS_SUB_ORG_ID\x00default
>>>>>>>>>>>>>
>>>>>>>>>>>>> \x00\x00TEST_TABLE_2 column=0:VIEW_CONSTANT,
>>>>>>>>>>>>> timestamp=1460354090655, type=DeleteColumn
>>>>>>>>>>>>>
>>>>>>>>>>>>> _0_1460354090089\x00CDS_SUB_ORG_ID\x00default
>>>>>>>>>>>>>
>>>>>>>>>>>>> \x00\x00TEST_TABLE_2 column=0:_0, timestamp=1460354090655,
>>>>>>>>>>>>> type=DeleteColumn
>>>>>>>>>>>>>
>>>>>>>>>>>>> _0_1460354090089\x00CDS_SUB_ORG_ID\x00default
>>>>>>>>>>>>>
>>>>>>>>>>>>> \x00\x00TEST_TABLE_2 column=0:, timestamp=1460455162842,
>>>>>>>>>>>>> type=DeleteFamily
>>>>>>>>>>>>>
>>>>>>>>>>>>> _0_1460354090089\x00CDS_UPDATED_BY\x00default
>>>>>>>>>>>>>
>>>>>>>>>>>>> \x00\x00TEST_TABLE_2 column=0:ARRAY_SIZE,
>>>>>>>>>>>>> timestamp=1460354090655, type=DeleteColumn
>>>>>>>>>>>>>
>>>>>>>>>>>>> _0_1460354090089\x00CDS_UPDATED_BY\x00default
>>>>>>>>>>>>>
>>>>>>>>>>>>> \x00\x00TEST_TABLE_2 column=0:COLUMN_DEF,
>>>>>>>>>>>>> timestamp=1460354090655, type=DeleteColumn
>>>>>>>>>>>>>
>>>>>>>>>>>>> _0_1460354090089\x00CDS_UPDATED_BY\x00default
>>>>>>>>>>>>>
>>>>>>>>>>>>> \x00\x00TEST_TABLE_2 column=0:COLUMN_SIZE,
>>>>>>>>>>>>> timestamp=1460354090655, type=DeleteColumn
>>>>>>>>>>>>>
>>>>>>>>>>>>> _0_1460354090089\x00CDS_UPDATED_BY\x00default
>>>>>>>>>>>>>
>>>>>>>>>>>>> \x00\x00TEST_TABLE_2 column=0:DATA_TABLE_NAME,
>>>>>>>>>>>>> timestamp=1460354090655, type=DeleteColumn
>>>>>>>>>>>>>
>>>>>>>>>>>>> _0_1460354090089\x00CDS_UPDATED_BY\x00default
>>>>>>>>>>>>>
>>>>>>>>>>>>> \x00\x00TEST_TABLE_2 column=0:DATA_TYPE,
>>>>>>>>>>>>> timestamp=1460354090655, value=\x80\x00\x00\x0C
>>>>>>>>>>>>>
>>>>>>>>>>>>> _0_1460354090089\x00CDS_UPDATED_BY\x00default
>>>>>>>>>>>>>
>>>>>>>>>>>>> \x00\x00TEST_TABLE_2 column=0:DECIMAL_DIGITS,
>>>>>>>>>>>>> timestamp=1460354090655, type=DeleteColumn
>>>>>>>>>>>>>
>>>>>>>>>>>>> _0_1460354090089\x00CDS_UPDATED_BY\x00default
>>>>>>>>>>>>>
>>>>>>>>>>>>> \x00\x00TEST_TABLE_2 column=0:IS_ROW_TIMESTAMP,
>>>>>>>>>>>>> timestamp=1460354090655, value=\x00
>>>>>>>>>>>>>
>>>>>>>>>>>>> _0_1460354090089\x00CDS_UPDATED_BY\x00default
>>>>>>>>>>>>>
>>>>>>>>>>>>> \x00\x00TEST_TABLE_2 column=0:IS_VIEW_REFERENCED,
>>>>>>>>>>>>> timestamp=1460354090655, value=\x00
>>>>>>>>>>>>>
>>>>>>>>>>>>> _0_1460354090089\x00CDS_UPDATED_BY\x00default
>>>>>>>>>>>>>
>>>>>>>>>>>>> \x00\x00TEST_TABLE_2 column=0:KEY_SEQ,
>>>>>>>>>>>>> timestamp=1460354090655, type=DeleteColumn
>>>>>>>>>>>>>
>>>>>>>>>>>>> _0_1460354090089\x00CDS_UPDATED_BY\x00default
>>>>>>>>>>>>>
>>>>>>>>>>>>> \x00\x00TEST_TABLE_2 column=0:NULLABLE,
>>>>>>>>>>>>> timestamp=1460354090655, value=\x80\x00\x00\x01
>>>>>>>>>>>>>
>>>>>>>>>>>>> _0_1460354090089\x00CDS_UPDATED_BY\x00default
>>>>>>>>>>>>>
>>>>>>>>>>>>> \x00\x00TEST_TABLE_2 column=0:ORDINAL_POSITION,
>>>>>>>>>>>>> timestamp=1460354090655, value=\x80\x00\x00\x03
>>>>>>>>>>>>>
>>>>>>>>>>>>> _0_1460354090089\x00CDS_UPDATED_BY\x00default
>>>>>>>>>>>>>
>>>>>>>>>>>>> \x00\x00TEST_TABLE_2 column=0:PK_NAME,
>>>>>>>>>>>>> timestamp=1460354090655, type=DeleteColumn
>>>>>>>>>>>>>
>>>>>>>>>>>>> _0_1460354090089\x00CDS_UPDATED_BY\x00default
>>>>>>>>>>>>>
>>>>>>>>>>>>> \x00\x00TEST_TABLE_2 column=0:SORT_ORDER,
>>>>>>>>>>>>> timestamp=1460354090655, value=\x80\x00\x00\x02
>>>>>>>>>>>>>
>>>>>>>>>>>>> _0_1460354090089\x00CDS_UPDATED_BY\x00default
>>>>>>>>>>>>>
>>>>>>>>>>>>> \x00\x00TEST_TABLE_2 column=0:VIEW_CONSTANT,
>>>>>>>>>>>>> timestamp=1460354090655, type=DeleteColumn
>>>>>>>>>>>>>
>>>>>>>>>>>>> _0_1460354090089\x00CDS_UPDATED_BY\x00default
>>>>>>>>>>>>>
>>>>>>>>>>>>> \x00\x00TEST_TABLE_2 column=0:_0, timestamp=1460354090655,
>>>>>>>>>>>>> type=DeleteColumn
>>>>>>>>>>>>>
>>>>>>>>>>>>> _0_1460354090089\x00CDS_UPDATED_BY\x00default
>>>>>>>>>>>>>
>>>>>>>>>>>>> \x00\x00TEST_TABLE_2 column=0:, timestamp=1460455162842,
>>>>>>>>>>>>> type=DeleteFamily
>>>>>>>>>>>>>
>>>>>>>>>>>>> _0_1460354090089\x00CDS_UPDATED_DATE\x00defau
>>>>>>>>>>>>>
>>>>>>>>>>>>> lt
>>>>>>>>>>>>>
>>>>>>>>>>>>> \x00\x00TEST_TABLE_2 column=0:ARRAY_SIZE,
>>>>>>>>>>>>> timestamp=1460354090655, type=DeleteColumn
>>>>>>>>>>>>>
>>>>>>>>>>>>> _0_1460354090089\x00CDS_UPDATED_DATE\x00defau
>>>>>>>>>>>>>
>>>>>>>>>>>>> lt
>>>>>>>>>>>>>
>>>>>>>>>>>>> \x00\x00TEST_TABLE_2 column=0:COLUMN_DEF,
>>>>>>>>>>>>> timestamp=1460354090655, type=DeleteColumn
>>>>>>>>>>>>>
>>>>>>>>>>>>> _0_1460354090089\x00CDS_UPDATED_DATE\x00defau
>>>>>>>>>>>>>
>>>>>>>>>>>>> lt
>>>>>>>>>>>>>
>>>>>>>>>>>>> \x00\x00TEST_TABLE_2 column=0:COLUMN_SIZE,
>>>>>>>>>>>>> timestamp=1460354090655, type=DeleteColumn
>>>>>>>>>>>>>
>>>>>>>>>>>>> _0_1460354090089\x00CDS_UPDATED_DATE\x00defau
>>>>>>>>>>>>>
>>>>>>>>>>>>> lt
>>>>>>>>>>>>>
>>>>>>>>>>>>> \x00\x00TEST_TABLE_2 column=0:DATA_TABLE_NAME,
>>>>>>>>>>>>> timestamp=1460354090655, type=DeleteColumn
>>>>>>>>>>>>>
>>>>>>>>>>>>> _0_1460354090089\x00CDS_UPDATED_DATE\x00defau
>>>>>>>>>>>>>
>>>>>>>>>>>>> lt
>>>>>>>>>>>>>
>>>>>>>>>>>>> \x00\x00TEST_TABLE_2 column=0:DATA_TYPE,
>>>>>>>>>>>>> timestamp=1460354090655, value=\x80\x00\x00\x0C
>>>>>>>>>>>>>
>>>>>>>>>>>>> _0_1460354090089\x00CDS_UPDATED_DATE\x00defau
>>>>>>>>>>>>>
>>>>>>>>>>>>> lt
>>>>>>>>>>>>>
>>>>>>>>>>>>> \x00\x00TEST_TABLE_2 column=0:DECIMAL_DIGITS,
>>>>>>>>>>>>> timestamp=1460354090655, type=DeleteColumn
>>>>>>>>>>>>>
>>>>>>>>>>>>> _0_1460354090089\x00CDS_UPDATED_DATE\x00defau
>>>>>>>>>>>>>
>>>>>>>>>>>>> lt
>>>>>>>>>>>>>
>>>>>>>>>>>>> \x00\x00TEST_TABLE_2 column=0:IS_ROW_TIMESTAMP,
>>>>>>>>>>>>> timestamp=1460354090655, value=\x00
>>>>>>>>>>>>>
>>>>>>>>>>>>> _0_1460354090089\x00CDS_UPDATED_DATE\x00defau
>>>>>>>>>>>>>
>>>>>>>>>>>>> lt
>>>>>>>>>>>>>
>>>>>>>>>>>>> \x00\x00TEST_TABLE_2 column=0:IS_VIEW_REFERENCED,
>>>>>>>>>>>>> timestamp=1460354090655, value=\x00
>>>>>>>>>>>>>
>>>>>>>>>>>>> _0_1460354090089\x00CDS_UPDATED_DATE\x00defau
>>>>>>>>>>>>>
>>>>>>>>>>>>> lt
>>>>>>>>>>>>>
>>>>>>>>>>>>> \x00\x00TEST_TABLE_2 column=0:KEY_SEQ,
>>>>>>>>>>>>> timestamp=1460354090655, type=DeleteColumn
>>>>>>>>>>>>>
>>>>>>>>>>>>> _0_1460354090089\x00CDS_UPDATED_DATE\x00defau
>>>>>>>>>>>>>
>>>>>>>>>>>>> lt
>>>>>>>>>>>>>
>>>>>>>>>>>>> \x00\x00TEST_TABLE_2 column=0:NULLABLE,
>>>>>>>>>>>>> timestamp=1460354090655, value=\x80\x00\x00\x01
>>>>>>>>>>>>>
>>>>>>>>>>>>> _0_1460354090089\x00CDS_UPDATED_DATE\x00defau
>>>>>>>>>>>>>
>>>>>>>>>>>>> lt
>>>>>>>>>>>>>
>>>>>>>>>>>>> \x00\x00TEST_TABLE_2 column=0:ORDINAL_POSITION,
>>>>>>>>>>>>> timestamp=1460354090655, value=\x80\x00\x00\x02
>>>>>>>>>>>>>
>>>>>>>>>>>>> _0_1460354090089\x00CDS_UPDATED_DATE\x00defau
>>>>>>>>>>>>>
>>>>>>>>>>>>> lt
>>>>>>>>>>>>>
>>>>>>>>>>>>> \x00\x00TEST_TABLE_2 column=0:PK_NAME,
>>>>>>>>>>>>> timestamp=1460354090655, type=DeleteColumn
>>>>>>>>>>>>>
>>>>>>>>>>>>> _0_1460354090089\x00CDS_UPDATED_DATE\x00defau
>>>>>>>>>>>>>
>>>>>>>>>>>>> lt
>>>>>>>>>>>>>
>>>>>>>>>>>>> \x00\x00TEST_TABLE_2 column=0:SORT_ORDER,
>>>>>>>>>>>>> timestamp=1460354090655, value=\x80\x00\x00\x02
>>>>>>>>>>>>>
>>>>>>>>>>>>> _0_1460354090089\x00CDS_UPDATED_DATE\x00defau
>>>>>>>>>>>>>
>>>>>>>>>>>>> lt
>>>>>>>>>>>>>
>>>>>>>>>>>>> \x00\x00TEST_TABLE_2 column=0:VIEW_CONSTANT,
>>>>>>>>>>>>> timestamp=1460354090655, type=DeleteColumn
>>>>>>>>>>>>>
>>>>>>>>>>>>> _0_1460354090089\x00CDS_UPDATED_DATE\x00defau
>>>>>>>>>>>>>
>>>>>>>>>>>>> lt
>>>>>>>>>>>>>
>>>>>>>>>>>>> \x00\x00TEST_TABLE_2 column=0:_0, timestamp=1460354090655,
>>>>>>>>>>>>> type=DeleteColumn
>>>>>>>>>>>>>
>>>>>>>>>>>>> _0_1460354090089\x00CDS_UPDATED_DATE\x00defau
>>>>>>>>>>>>>
>>>>>>>>>>>>> lt
>>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>> Thanks,
>>>>>>>>>>>>>
>>>>>>>>>>>>> Arun
>>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>> On Wed, Apr 20, 2016 at 11:31 AM, Arun Kumaran Sabtharishi <
>>>>>>>>>>>>> arun1087@gmail.com> wrote:
>>>>>>>>>>>>>
>>>>>>>>>>>>>> James,
>>>>>>>>>>>>>>
>>>>>>>>>>>>>> Table SYSTEM.CATALOG is ENABLED
>>>>>>>>>>>>>> SYSTEM.CATALOG, {TABLE_ATTRIBUTES => {coprocessor$1 =>
>>>>>>>>>>>>>> '|org.apache.phoenix.coprocessor.ScanRegionObserver|1|', coprocessor$2 =>
>>>>>>>>>>>>>> '|org.apache
>>>>>>>>>>>>>>
>>>>>>>>>>>>>> .phoenix.coprocessor.UngroupedAggregateRegionObserver|1|',
>>>>>>>>>>>>>> coprocessor$3 =>
>>>>>>>>>>>>>> '|org.apache.phoenix.coprocessor.GroupedAggregateRegionObserver|1
>>>>>>>>>>>>>>
>>>>>>>>>>>>>> |', coprocessor$4 =>
>>>>>>>>>>>>>> '|org.apache.phoenix.coprocessor.ServerCachingEndpointImpl|1|',
>>>>>>>>>>>>>> coprocessor$5 => '|org.apache.phoenix.coprocessor.MetaDa
>>>>>>>>>>>>>>
>>>>>>>>>>>>>> taEndpointImpl|1|', coprocessor$6 =>
>>>>>>>>>>>>>> '|org.apache.phoenix.coprocessor.MetaDataRegionObserver|2|', METADATA =>
>>>>>>>>>>>>>> {'SPLIT_POLICY' => 'org.apache.
>>>>>>>>>>>>>>
>>>>>>>>>>>>>> phoenix.schema.MetaDataSplitPolicy', 'UpgradeTo30' =>
>>>>>>>>>>>>>> 'true'}}
>>>>>>>>>>>>>> COLUMN FAMILIES DESCRIPTION
>>>>>>>>>>>>>> {NAME => '0', DATA_BLOCK_ENCODING => 'FAST_DIFF', BLOOMFILTER
>>>>>>>>>>>>>> => 'ROW', REPLICATION_SCOPE => '0', COMPRESSION => 'NONE', VERSIONS =>
>>>>>>>>>>>>>> '1000',
>>>>>>>>>>>>>>
>>>>>>>>>>>>>> MIN_VERSIONS => '0', TTL => 'FOREVER', KEEP_DELETED_CELLS =>
>>>>>>>>>>>>>> 'true', BLOCKSIZE => '65536', IN_MEMORY => 'false', BLOCKCACHE => 'true'}
>>>>>>>>>>>>>>
>>>>>>>>>>>>>> 1 row in 0.6060 seconds
>>>>>>>>>>>>>>
>>>>>>>>>>>>>> The above is for describe SYSTEM.CATALOG. The output for scan
>>>>>>>>>>>>>> 'SYSTEM.CATALOG', {RAW=>true} is too huge.
>>>>>>>>>>>>>>
>>>>>>>>>>>>>> Thanks,
>>>>>>>>>>>>>> Arun
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>
>>>>>>>>>>>>>> On Wed, Apr 20, 2016 at 11:19 AM, James Taylor <
>>>>>>>>>>>>>> jamestaylor@apache.org> wrote:
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>> Arun,
>>>>>>>>>>>>>>> Please run the command Ankit mentioned in an HBase shell and
>>>>>>>>>>>>>>> post the output back here.
>>>>>>>>>>>>>>> Thanks,
>>>>>>>>>>>>>>> James
>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>> On Wednesday, April 20, 2016, Arun Kumaran Sabtharishi <
>>>>>>>>>>>>>>> arun1087@gmail.com> wrote:
>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>> !describe SYSTEM.CATALOG is not returning IS_ROW_TIMESTAMP
>>>>>>>>>>>>>>>> column.
>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>> But we do see this column from select statement:
>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>> select * from SYSTEM.CATALOG where
>>>>>>>>>>>>>>>> TABLE_NAME=’TEST_TABLE_1’ AND TABLE_SCHEM IS NULL AND TENANT_ID IS NULL ;
>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>> Thanks,
>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>> Arun
>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>> On Wed, Apr 20, 2016 at 1:37 AM, Ankit Singhal <
>>>>>>>>>>>>>>>> ankitsinghal59@gmail.com> wrote:
>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>> Hi Arun,
>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>> Do you see 'IS_ROW_TIMESTAMP' column in SYSTEM.CATALOG,
>>>>>>>>>>>>>>>>> by doing !describe on system.catalog.
>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>> if not,
>>>>>>>>>>>>>>>>> can you share the output of below command. As it seems
>>>>>>>>>>>>>>>>> SYSTEM.CATALOG was updated with timestamp greater v4.6 timestamp , and
>>>>>>>>>>>>>>>>> which stopping upgrade code to add a new column.
>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>> scan 'SYSTEM.CATALOG', {RAW=>true}
>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>> Regards,
>>>>>>>>>>>>>>>>> Ankit Singhal
>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>> On Wed, Apr 20, 2016 at 4:25 AM, Arun Kumaran Sabtharishi
>>>>>>>>>>>>>>>>> <arun1087@gmail.com> wrote:
>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>> After further investigation, we found that Phoenix Upsert
>>>>>>>>>>>>>>>>>> query SYSTEM.CATALOG has IS_ROW_TIMESTAMP column, but
>>>>>>>>>>>>>>>>>> PTableImpl.getColumn() is failing with error:"Undefined column.
>>>>>>>>>>>>>>>>>> columnName=IS_ROW_TIMESTAMP" . Does this mean that PTableImpl is reading
>>>>>>>>>>>>>>>>>> from cached entity of  SYSTEM.CATALOG  before 4.6 upgrade?"
>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>> We do see that clearCache() is being called for 4.7, and
>>>>>>>>>>>>>>>>>> 4.7 upgrades from ConnectionQueryServicesImpl class, but not for 4.6
>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>> Thanks,
>>>>>>>>>>>>>>>>>> Arun
>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>> On Tue, Apr 19, 2016 at 10:22 AM, Arun Kumaran
>>>>>>>>>>>>>>>>>> Sabtharishi <arun1087@gmail.com> wrote:
>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>> James,
>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>> To add more information on this issue, this happens in
>>>>>>>>>>>>>>>>>>> new phoenix views associated with brand new tables as well. So, this cannot
>>>>>>>>>>>>>>>>>>> be an upgrade/migration issue. Not figured out a specific way to reproduce
>>>>>>>>>>>>>>>>>>> this issue yet. Could you throw some ideas on what direction this problem
>>>>>>>>>>>>>>>>>>> could be approached from this point?
>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>> Thanks,
>>>>>>>>>>>>>>>>>>> Arun
>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>
>>>>>>>>
>>>>>>>
>>>>>>
>>>>>
>>>>
>>>
>

Mime
View raw message