[jira] [Commented] (HIVE-15728) Empty table returns result when querying partitioned field with a function

["Fei Hui (JIRA)" <ji...@apache.org>]

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

Fei Hui commented on HIVE-15728:
--------------------------------

hi [~therandomsuit]
I have tested, and thereis no problem in hive lastest version.

Total MapReduce CPU Time Spent: 1 seconds 620 msec
OK
NULL

> 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.15#6346)