[
https://issues.apache.org/jira/browse/HIVE-29637?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18086383#comment-18086383
]
Stamatis Zampetakis commented on HIVE-29637:
--------------------------------------------
Based on some existing test cases (and tickets like HIVE-16609) it seems that
we should be able to retrieve data from the default partition using queries
like:
{code:sql}
create table pcr_t1 (key string, value string) partitioned by (ds string);
SELECT * FROM pcr_t1 WHERE ds = '__HIVE_DEFAULT_PARTITION__';
{code}
It feels a bit strange the following query returns also the same answer:
{code:sql}
SELECT * FROM pcr_t1 WHERE ds is null;{code}
I am now starting to wonder what other things may be stored inside the default
partition.
[~dkuzmenko] Is it guaranteed to have only nulls or maybe there are other
things as well?
> Iceberg: Incorrect Results for NULL Predicate on Partition Column
> -----------------------------------------------------------------
>
> Key: HIVE-29637
> URL: https://issues.apache.org/jira/browse/HIVE-29637
> Project: Hive
> Issue Type: Bug
> Reporter: Denys Kuzmenko
> Priority: Major
> Labels: pull-request-available
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
