Skip to content

Insert into bucketed, unpartioned Hive table not allowed #1088

@springjd

Description

@springjd

Up through 316 when inserting into a Hive table that is bucketed, but not partitioned, e.g.

 user_id bigint, 
firstname varchar, 
lastname varchar, 
city varchar ) 
with ( 
bucketed_by = ARRAY['user_id'] ,
bucket_count=25);

insert into table hive.default.test_table (
11,
'Juan',
'Carlos',
'Madrid');

Presto give the error:
Query 20190705_191449_00002_f53b3 failed: Cannot insert into bucketed unpartitioned Hive table

Inserting into a partitioned, bucketed table works as expected.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions