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)