[
https://issues.apache.org/jira/browse/HUDI-4860?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Raymond Xu closed HUDI-4860.
----------------------------
Resolution: Fixed
> Presto/Trino Cannot parse partition value '\N' of type 'integer' for
> partition column
> -------------------------------------------------------------------------------------
>
> Key: HUDI-4860
> URL: https://issues.apache.org/jira/browse/HUDI-4860
> Project: Apache Hudi
> Issue Type: Bug
> Reporter: Sagar Sumit
> Assignee: Sagar Sumit
> Priority: Blocker
> Labels: hudi-on-call
> Fix For: 0.12.1
>
>
> Hudi has the new {{_{_}HIVE_DEFAULT_PARTITION{_}_}} as the fallback one.
> Presto/Trino seem to covert it to `\N`.
> [https://github.com/codope/trino/blob/f7c969c1cc6a10f601ca522a7161384a7bf56996/plugin/trino-hive/src/main/java/io/trino/plugin/hive/HivePartitionKey.java#L44]
> It works with this fix
> {code:java}
> git diff
> diff --git
> a/plugin/trino-hudi/src/main/java/io/trino/plugin/hudi/HudiPageSourceProvider.java
>
> b/plugin/trino-hudi/src/main/java/io/trino/plugin/hudi/HudiPageSourceProvider.java
> index 1c72175860..d10dbbaac7 100644
> ---
> a/plugin/trino-hudi/src/main/java/io/trino/plugin/hudi/HudiPageSourceProvider.java
> +++
> b/plugin/trino-hudi/src/main/java/io/trino/plugin/hudi/HudiPageSourceProvider.java
> @@ -159,7 +159,7 @@ public class HudiPageSourceProvider
> String partitionValue,
> TypeSignature partitionDataType)
> {
> - if (isNull(partitionValue)) {
> + if (isNull(partitionValue) || partitionValue.equals("\\N")) {
> return Optional.empty();
> }
> {code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
