[ 
https://issues.apache.org/jira/browse/PHOENIX-4816?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16547277#comment-16547277
 ] 

cherish peng commented on PHOENIX-4816:
---------------------------------------

Hi! Taylor, Thank you so much! It's work!

{color:#FF0000}I am a newbie{color}, I read some docs but not contain the 
"storage format", there only one similar problem in China's forum when they 
upgrade the version from 4.9 to 4.10, We did not review the document carefully!

About "Another couple of things", my table's DDL: 

CREATE TABLE IF NOT EXISTS events (
 domain VARCHAR(24) NOT NULL,
 name VARCHAR(24) NOT NULL,
 sid VARCHAR(24) NOT NULL,
 epoch TIMESTAMP NOT NULL,
 msec TIMESTAMP NOT NULL,
 event.PLACEHOLDER VARCHAR,
 element.PLACEHOLDER VARCHAR,
 performance.PLACEHOLDER VARCHAR,
 thrown.PLACEHOLDER VARCHAR,
 ajax.PLACEHOLDER VARCHAR,
 CONSTRAINT pk PRIMARY KEY (domain, name, sid, epoch, msec)
)IMMUTABLE_ROWS=true,COLUMN_ENCODED_BYTES=NONE;

event,element,performance,thrown,ajax are column families, they accept unknown 
dynamic columns(A lots of), if i use view as alternative at this scenario, i 
should create one view for each dynamic column, 1v1, then i need to maintain 
the associations.

All my scenarios, I only use VIEW as the intermediate table.

You are doing a great job! 

Thank you again! 

Best Regards!

> When select dynamic columns throw InvalidQualifierBytesException
> ----------------------------------------------------------------
>
>                 Key: PHOENIX-4816
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-4816
>             Project: Phoenix
>          Issue Type: Bug
>            Reporter: cherish peng
>            Priority: Blocker
>              Labels: dynamic-schema
>   Original Estimate: 336h
>  Remaining Estimate: 336h
>




--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Reply via email to