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

melin edited comment on SPARK-39774 at 7/14/22 3:26 AM:
--------------------------------------------------------

{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!

[~hyukjin.kwon] 


was (Author: melin):
{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-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org

Reply via email to