You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@spark.apache.org by "melin (Jira)" <ji...@apache.org> on 2022/07/14 03:25:00 UTC
[jira] [Commented] (SPARK-39774) [BUG] char(n) type cannot be directly compared with string equals and needs to be cast to String. hive sql can be compared without conversion
[ https://issues.apache.org/jira/browse/SPARK-39774?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17566622#comment-17566622 ]
melin commented on SPARK-39774:
-------------------------------
{code:java}
create table tpcds_2g_parquet.reason;
CREATE TABLE `tpcds_2g_parquet`.`reason` (
`r_reason_sk` BIGINT,
`r_reason_id` CHAR(16),
`r_reason_desc` CHAR(100))
USING parquet
TBLPROPERTIES (
'transient_lastDdlTime' = '1645440621'){code}
!image-2022-07-14-11-24-24-247.png!!image-2022-07-14-11-23-15-606.png!
> [BUG] char(n) type cannot be directly compared with string equals and needs to be cast to String. hive sql can be compared without conversion
> ---------------------------------------------------------------------------------------------------------------------------------------------
>
> Key: SPARK-39774
> URL: https://issues.apache.org/jira/browse/SPARK-39774
> Project: Spark
> Issue Type: Improvement
> Components: SQL
> Affects Versions: 3.4.0
> Reporter: melin
> Priority: Major
> Attachments: image-2022-07-14-11-23-15-606.png, image-2022-07-14-11-24-24-247.png
>
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org