You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@kudu.apache.org by "Andrew Wong (Jira)" <ji...@apache.org> on 2020/06/02 18:28:00 UTC

[jira] [Commented] (KUDU-1271) Column ordering constraint in Kudu

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

Andrew Wong commented on KUDU-1271:
-----------------------------------

Todd posted a more recent WIP for this here:

[https://gerrit.cloudera.org/c/15748/]

> Column ordering constraint in Kudu
> ----------------------------------
>
>                 Key: KUDU-1271
>                 URL: https://issues.apache.org/jira/browse/KUDU-1271
>             Project: Kudu
>          Issue Type: Improvement
>          Components: master
>    Affects Versions: 0.5.0
>         Environment: Cloudera CDH 5.4.x
>            Reporter: Abhi Basu
>            Priority: Major
>              Labels: roadmap-candidate
>
> I get this error when I am attempting to create a Kudu table as a select from an existing Impala/Hive table. The last column of the table is rowid (int) that is going to be used as primary key for this table. 
> Error: llegalArgumentException: Got out-of-order primary key column: Column name: rowid, type:
> SQL example:
> CREATE TABLE newtable_kudu
> TBLPROPERTIES(
>  'storage_handler' = 'com.cloudera.kudu.hive.KuduStorageHandler',
>   'kudu.table_name' = 'newtable_kudu',
>   'kudu.master_addresses' = 'hostname:7051',
>   'kudu.key_columns' = 'rowid'
>  ) AS SELECT * FROM oldtable_impala;



--
This message was sent by Atlassian Jira
(v8.3.4#803005)