You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@iceberg.apache.org by "JFinis (via GitHub)" <gi...@apache.org> on 2024/02/12 19:55:47 UTC
[I] Truncate does not support long widths [iceberg]
JFinis opened a new issue, #9716:
URL: https://github.com/apache/iceberg/issues/9716
### Apache Iceberg version
1.4.3 (latest release)
### Query engine
Spark
### Please describe the bug 🐞
This bug is related to https://github.com/apache/iceberg/issues/9715, but it triggers yet another error and is actually more severe.
It turns out that it is not possible to use a bigint as truncate width in SparkSQL. It will error out with
`java.lang.IllegalArgumentException: Unsupported width for transform: truncate(x, 1000000000000)`
However, the code definitly looks as if it should support such long widths (larger than int, but fitting into long), it just seems to go into the wrong path, treating the literal as int instead of long. The grammar does not allow to cast the literal to bigint or do oether shenaningans to help the code recognize the literal as a long instead of an int.
Repro:
```
CREATE TABLE foobar (x bigint) PARTITIONED BY(truncate(x,1000000000000))
TBLPROPERTIES(`format-version`=2);
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: issues-unsubscribe@iceberg.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@iceberg.apache.org
For additional commands, e-mail: issues-help@iceberg.apache.org
Re: [I] Truncate does not support long widths [iceberg]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] closed issue #9716: Truncate does not support long widths
URL: https://github.com/apache/iceberg/issues/9716
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: issues-unsubscribe@iceberg.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@iceberg.apache.org
For additional commands, e-mail: issues-help@iceberg.apache.org
Re: [I] Truncate does not support long widths [iceberg]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on issue #9716:
URL: https://github.com/apache/iceberg/issues/9716#issuecomment-2448718228
This issue has been closed because it has not received any activity in the last 14 days since being marked as 'stale'
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: issues-unsubscribe@iceberg.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@iceberg.apache.org
For additional commands, e-mail: issues-help@iceberg.apache.org
Re: [I] Truncate does not support long widths [iceberg]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on issue #9716:
URL: https://github.com/apache/iceberg/issues/9716#issuecomment-2418196523
This issue has been automatically marked as stale because it has been open for 180 days with no activity. It will be closed in next 14 days if no further activity occurs. To permanently prevent this issue from being considered stale, add the label 'not-stale', but commenting on the issue is preferred when possible.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: issues-unsubscribe@iceberg.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@iceberg.apache.org
For additional commands, e-mail: issues-help@iceberg.apache.org