You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Jared Leable (JIRA)" <ji...@apache.org> on 2017/01/26 13:26:24 UTC
[jira] [Updated] (HIVE-15728) Empty table returns result when
querying partitioned field with a function
[ https://issues.apache.org/jira/browse/HIVE-15728?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jared Leable updated HIVE-15728:
--------------------------------
Description:
If a partitioned table contained data and is then truncated a query will still return a result when using a function on a partitioned field.
create table test1 (
field string
)
partitioned by(dt string);
set hive.exec.dynamic.partition.mode=nonstrict;
insert into test1
partition(dt)
select 'a','2017-01-01';
-- to view inserted records
select * from test1;
-- to delete all records from the table
truncate table test1;
-- to view 0 records in the table
select * from test1;
-- still returns a result of '2017-01-01'
select max(dt) from test1;
was:
If a partitioned table contained data and is then truncated a query will still return a result when using a function on a partitioned field.
create table test1 (
field string
)
partitioned by(dt string);
set hive.exec.dynamic.partition.mode=nonstrict;
insert into test1
partition(dt)
select 'a','2017-01-01';
-- to view inserted records
select * from test1;
-- to delete all records from the table
truncate table test1;
-- to view 0 records in the table
select * from test1;
-- still returns a result for the partitioned field
select max(dt) from test1;
> Empty table returns result when querying partitioned field with a function
> --------------------------------------------------------------------------
>
> Key: HIVE-15728
> URL: https://issues.apache.org/jira/browse/HIVE-15728
> Project: Hive
> Issue Type: Bug
> Components: Hive
> Affects Versions: 1.1.0
> Reporter: Jared Leable
>
> If a partitioned table contained data and is then truncated a query will still return a result when using a function on a partitioned field.
> create table test1 (
> field string
> )
> partitioned by(dt string);
> set hive.exec.dynamic.partition.mode=nonstrict;
> insert into test1
> partition(dt)
> select 'a','2017-01-01';
> -- to view inserted records
> select * from test1;
> -- to delete all records from the table
> truncate table test1;
> -- to view 0 records in the table
> select * from test1;
> -- still returns a result of '2017-01-01'
> select max(dt) from test1;
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)