[jira] [Updated] (PHOENIX-2565) Store data for immutable tables in single KeyValue
[ https://issues.apache.org/jira/browse/PHOENIX-2565?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Thomas D'Silva updated PHOENIX-2565: Attachment: PHOENIX-2565-v2.patch Attached final patch. > Store data for immutable tables in single KeyValue > -- > > Key: PHOENIX-2565 > URL: https://issues.apache.org/jira/browse/PHOENIX-2565 > Project: Phoenix > Issue Type: Improvement >Reporter: James Taylor >Assignee: Thomas D'Silva > Fix For: 4.9.0 > > Attachments: PHOENIX-2565-v2.patch, PHOENIX-2565-wip.patch, > PHOENIX-2565.patch > > > Since an immutable table (i.e. declared with IMMUTABLE_ROWS=true) will never > update a column value, it'd be more efficient to store all column values for > a row in a single KeyValue. We could use the existing format we have for > variable length arrays. > For backward compatibility, we'd need to support the current mechanism. Also, > you'd no longer be allowed to transition an existing table to/from being > immutable. I think the best approach would be to introduce a new IMMUTABLE > keyword and use it like this: > {code} > CREATE IMMUTABLE TABLE ... > {code} -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (PHOENIX-2565) Store data for immutable tables in single KeyValue
[ https://issues.apache.org/jira/browse/PHOENIX-2565?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Thomas D'Silva updated PHOENIX-2565: Attachment: PHOENIX-2565.patch [~jamestaylor] [~samarthjain] I have attached a patch. Please review when you get a chance. Thanks, Thomas > Store data for immutable tables in single KeyValue > -- > > Key: PHOENIX-2565 > URL: https://issues.apache.org/jira/browse/PHOENIX-2565 > Project: Phoenix > Issue Type: Improvement >Reporter: James Taylor >Assignee: Thomas D'Silva > Fix For: 4.9.0 > > Attachments: PHOENIX-2565-wip.patch, PHOENIX-2565.patch > > > Since an immutable table (i.e. declared with IMMUTABLE_ROWS=true) will never > update a column value, it'd be more efficient to store all column values for > a row in a single KeyValue. We could use the existing format we have for > variable length arrays. > For backward compatibility, we'd need to support the current mechanism. Also, > you'd no longer be allowed to transition an existing table to/from being > immutable. I think the best approach would be to introduce a new IMMUTABLE > keyword and use it like this: > {code} > CREATE IMMUTABLE TABLE ... > {code} -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (PHOENIX-2565) Store data for immutable tables in single KeyValue
[ https://issues.apache.org/jira/browse/PHOENIX-2565?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Thomas D'Silva updated PHOENIX-2565: Attachment: PHOENIX-2565-wip.patch Parking WIP patch. > Store data for immutable tables in single KeyValue > -- > > Key: PHOENIX-2565 > URL: https://issues.apache.org/jira/browse/PHOENIX-2565 > Project: Phoenix > Issue Type: Improvement >Reporter: James Taylor >Assignee: Thomas D'Silva > Fix For: 4.9.0 > > Attachments: PHOENIX-2565-wip.patch > > > Since an immutable table (i.e. declared with IMMUTABLE_ROWS=true) will never > update a column value, it'd be more efficient to store all column values for > a row in a single KeyValue. We could use the existing format we have for > variable length arrays. > For backward compatibility, we'd need to support the current mechanism. Also, > you'd no longer be allowed to transition an existing table to/from being > immutable. I think the best approach would be to introduce a new IMMUTABLE > keyword and use it like this: > {code} > CREATE IMMUTABLE TABLE ... > {code} -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (PHOENIX-2565) Store data for immutable tables in single KeyValue
[ https://issues.apache.org/jira/browse/PHOENIX-2565?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Taylor updated PHOENIX-2565: -- Fix Version/s: (was: 4.8.0) 4.9.0 > Store data for immutable tables in single KeyValue > -- > > Key: PHOENIX-2565 > URL: https://issues.apache.org/jira/browse/PHOENIX-2565 > Project: Phoenix > Issue Type: Improvement >Reporter: James Taylor >Assignee: Thomas D'Silva > Fix For: 4.9.0 > > > Since an immutable table (i.e. declared with IMMUTABLE_ROWS=true) will never > update a column value, it'd be more efficient to store all column values for > a row in a single KeyValue. We could use the existing format we have for > variable length arrays. > For backward compatibility, we'd need to support the current mechanism. Also, > you'd no longer be allowed to transition an existing table to/from being > immutable. I think the best approach would be to introduce a new IMMUTABLE > keyword and use it like this: > {code} > CREATE IMMUTABLE TABLE ... > {code} -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (PHOENIX-2565) Store data for immutable tables in single KeyValue
[ https://issues.apache.org/jira/browse/PHOENIX-2565?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Taylor updated PHOENIX-2565: -- Fix Version/s: 4.8.0 > Store data for immutable tables in single KeyValue > -- > > Key: PHOENIX-2565 > URL: https://issues.apache.org/jira/browse/PHOENIX-2565 > Project: Phoenix > Issue Type: Improvement >Reporter: James Taylor >Assignee: Thomas D'Silva > Fix For: 4.8.0 > > > Since an immutable table (i.e. declared with IMMUTABLE_ROWS=true) will never > update a column value, it'd be more efficient to store all column values for > a row in a single KeyValue. We could use the existing format we have for > variable length arrays. > For backward compatibility, we'd need to support the current mechanism. Also, > you'd no longer be allowed to transition an existing table to/from being > immutable. I think the best approach would be to introduce a new IMMUTABLE > keyword and use it like this: > {code} > CREATE IMMUTABLE TABLE ... > {code} -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (PHOENIX-2565) Store data for immutable tables in single KeyValue
[ https://issues.apache.org/jira/browse/PHOENIX-2565?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Taylor updated PHOENIX-2565: -- Assignee: Thomas D'Silva (was: ramkrishna.s.vasudevan) > Store data for immutable tables in single KeyValue > -- > > Key: PHOENIX-2565 > URL: https://issues.apache.org/jira/browse/PHOENIX-2565 > Project: Phoenix > Issue Type: Improvement >Reporter: James Taylor >Assignee: Thomas D'Silva > > Since an immutable table (i.e. declared with IMMUTABLE_ROWS=true) will never > update a column value, it'd be more efficient to store all column values for > a row in a single KeyValue. We could use the existing format we have for > variable length arrays. > For backward compatibility, we'd need to support the current mechanism. Also, > you'd no longer be allowed to transition an existing table to/from being > immutable. I think the best approach would be to introduce a new IMMUTABLE > keyword and use it like this: > {code} > CREATE IMMUTABLE TABLE ... > {code} -- This message was sent by Atlassian JIRA (v6.3.4#6332)