phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Arun Kumaran Sabtharishi <arun1...@gmail.com>
Subject Re: Undefined column. columnName=IS_ROW_TIMESTAMP
Date Tue, 26 Apr 2016 17:56:43 GMT
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