[
https://issues.apache.org/jira/browse/KUDU-2076?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16100254#comment-16100254
]
Acharki Mohammed commented on KUDU-2076:
----------------------------------------
Hi, JD what do you mean by "composite row keys". did you mean to use more than
one column as a primary key? or you intend the using of hash/range partitioning.
> Deleting/updating is slow on single numeric row key tables
> ----------------------------------------------------------
>
> Key: KUDU-2076
> URL: https://issues.apache.org/jira/browse/KUDU-2076
> Project: Kudu
> Issue Type: Bug
> Components: tablet
> Affects Versions: 1.4.0
> Reporter: Jean-Daniel Cryans
>
> A user reported that deleting 50M rows on the simplest of tables, (id INT,
> text STRING, PRIMARY KEY (id)), doesn't complete.
> It reproduces locally and I was able to see that we're deleting 1.4 rows / ms
> which is awful considering that everything is cached.
> Todd found that we're spending most of our time decoding big blocks of
> bit-shuffled keys. Intuitively he though that having a composite row key
> would perform better and indeed adding a column set to 0 in front makes it
> 10x faster.
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
