[jira] [Updated] (SPARK-29667) implicitly convert mismatched datatypes on right side of "IN" operator
[ https://issues.apache.org/jira/browse/SPARK-29667?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Hyukjin Kwon updated SPARK-29667: - Description: Ran into error on this sql Mismatched columns: {code} [(a.`id`:decimal(28,0), db1.table1.`id`:decimal(18,0))] the sql and clause AND a.id in (select id from db1.table1 where col1 = 1 group by id) {code} Once I cast {{decimal(18,0)}} to {{decimal(28,0)}} explicitly above, the sql ran just fine. Can the sql engine cast implicitly in this case? was: Ran into error on this sql Mismatched columns: [(a.`id`:decimal(28,0), db1.table1.`id`:decimal(18,0))] the sql and clause AND a.id in (select id from db1.table1 where col1 = 1 group by id) Once I cast decimal(18,0) to decimal(28,0) explicitly above, the sql ran just fine. Can the sql engine cast implicitly in this case? > implicitly convert mismatched datatypes on right side of "IN" operator > -- > > Key: SPARK-29667 > URL: https://issues.apache.org/jira/browse/SPARK-29667 > Project: Spark > Issue Type: Improvement > Components: SQL >Affects Versions: 2.4.3 >Reporter: Jessie Lin >Priority: Minor > > Ran into error on this sql > Mismatched columns: > {code} > [(a.`id`:decimal(28,0), db1.table1.`id`:decimal(18,0))] > the sql and clause > AND a.id in (select id from db1.table1 where col1 = 1 group by id) > {code} > Once I cast {{decimal(18,0)}} to {{decimal(28,0)}} explicitly above, the sql > ran just fine. Can the sql engine cast implicitly in this case? > > > > -- This message was sent by Atlassian Jira (v8.3.4#803005) - To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org
[jira] [Updated] (SPARK-29667) implicitly convert mismatched datatypes on right side of "IN" operator
[ https://issues.apache.org/jira/browse/SPARK-29667?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Hyukjin Kwon updated SPARK-29667: - Description: Ran into error on this sql Mismatched columns: {code} [(a.`id`:decimal(28,0), db1.table1.`id`:decimal(18,0))] {code} the sql and clause {code} AND a.id in (select id from db1.table1 where col1 = 1 group by id) {code} Once I cast {{decimal(18,0)}} to {{decimal(28,0)}} explicitly above, the sql ran just fine. Can the sql engine cast implicitly in this case? was: Ran into error on this sql Mismatched columns: {code} [(a.`id`:decimal(28,0), db1.table1.`id`:decimal(18,0))] the sql and clause AND a.id in (select id from db1.table1 where col1 = 1 group by id) {code} Once I cast {{decimal(18,0)}} to {{decimal(28,0)}} explicitly above, the sql ran just fine. Can the sql engine cast implicitly in this case? > implicitly convert mismatched datatypes on right side of "IN" operator > -- > > Key: SPARK-29667 > URL: https://issues.apache.org/jira/browse/SPARK-29667 > Project: Spark > Issue Type: Improvement > Components: SQL >Affects Versions: 2.4.3 >Reporter: Jessie Lin >Priority: Minor > > Ran into error on this sql > Mismatched columns: > {code} > [(a.`id`:decimal(28,0), db1.table1.`id`:decimal(18,0))] > {code} > the sql and clause > {code} > AND a.id in (select id from db1.table1 where col1 = 1 group by id) > {code} > Once I cast {{decimal(18,0)}} to {{decimal(28,0)}} explicitly above, the sql > ran just fine. Can the sql engine cast implicitly in this case? > > > > -- This message was sent by Atlassian Jira (v8.3.4#803005) - To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org
[jira] [Updated] (SPARK-29667) implicitly convert mismatched datatypes on right side of "IN" operator
[ https://issues.apache.org/jira/browse/SPARK-29667?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Cheng Lian updated SPARK-29667: --- Environment: (was: spark-2.4.3-bin-dbr-5.5-snapshot-9833d0f) > implicitly convert mismatched datatypes on right side of "IN" operator > -- > > Key: SPARK-29667 > URL: https://issues.apache.org/jira/browse/SPARK-29667 > Project: Spark > Issue Type: Improvement > Components: SQL >Affects Versions: 2.4.3 >Reporter: Jessie Lin >Priority: Minor > > Ran into error on this sql > Mismatched columns: > [(a.`id`:decimal(28,0), db1.table1.`id`:decimal(18,0))] > the sql and clause > AND a.id in (select id from db1.table1 where col1 = 1 group by id) > Once I cast decimal(18,0) to decimal(28,0) explicitly above, the sql ran just > fine. Can the sql engine cast implicitly in this case? > > > > -- This message was sent by Atlassian Jira (v8.3.4#803005) - To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org
[jira] [Updated] (SPARK-29667) implicitly convert mismatched datatypes on right side of "IN" operator
[ https://issues.apache.org/jira/browse/SPARK-29667?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jessie Lin updated SPARK-29667: --- Priority: Minor (was: Major) > implicitly convert mismatched datatypes on right side of "IN" operator > -- > > Key: SPARK-29667 > URL: https://issues.apache.org/jira/browse/SPARK-29667 > Project: Spark > Issue Type: Improvement > Components: SQL >Affects Versions: 2.4.3 > Environment: spark-2.4.3-bin-dbr-5.5-snapshot-9833d0f >Reporter: Jessie Lin >Priority: Minor > > Ran into error on this sql > Mismatched columns: > [(a.`id`:decimal(28,0), db1.table1.`id`:decimal(18,0))] > the sql and clause > AND a.id in (select id from db1.table1 where col1 = 1 group by id) > Once I cast decimal(18,0) to decimal(28,0) explicitly above, the sql ran just > fine. Can the sql engine cast implicitly in this case? > > > > -- This message was sent by Atlassian Jira (v8.3.4#803005) - To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org