You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "James Turton (Jira)" <ji...@apache.org> on 2022/01/06 13:11:00 UTC

[jira] [Commented] (DRILL-7044) drill kudu query dose not support range + hash multilevel partition

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

James Turton commented on DRILL-7044:
-------------------------------------

Hi, thanks for this report.  Are you still able to reproduce this issue in a current version?

> drill kudu query dose not support range + hash multilevel partition
> -------------------------------------------------------------------
>
>                 Key: DRILL-7044
>                 URL: https://issues.apache.org/jira/browse/DRILL-7044
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Storage - Other
>    Affects Versions: 1.13.0, 1.14.0, 1.15.0
>         Environment: drill : 1.13.0
> kudu : 1.8.0
>            Reporter: fireapp
>            Assignee: James Turton
>            Priority: Critical
>              Labels: kudu
>         Attachments: 002.png, 003.png
>
>
> drill kudu query dose not support range + hash multilevel partition
> kudu table :
> CREATE TABLE test1 (
>   id int ,
>   name string,
>   value string,
>   prmary key(id, name)
> ),
> PARTITION BY HASH (name) PARTITIONS 8,
> PARTITION BY RANGE (id) (
>     PARTITION 0 <= VALUES < 10000,
>     PARTITION 10000 <= VALUES < 20000,
>     PARTITION 20000 <= VALUES < 30000,
>     PARTITION 30000 <= VALUES < 40000
> );
> and then insert 20002 rows into test1, but query not support.
> query sql : select count(1) kudu.table_name, result : `No result found.`



--
This message was sent by Atlassian Jira
(v8.20.1#820001)