[jira] [Comment Edited] (SPARK-24631) Cannot up cast column from bigint to smallint as it may truncate

["vaquar khan (JIRA)" <ji...@apache.org>]

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

vaquar khan edited comment on SPARK-24631 at 6/22/18 3:57 PM:
--------------------------------------------------------------

Can you add complete error logs and if possible smalll code example with test data ( data you can find in your prod table where it's failing )


was (Author: vaquar.khan@gmail.com):
Can you add complete error logs and if possible smalll code example with test data ( data you can find in your prod table where it's failing 

> Cannot up cast column from bigint to smallint as it may truncate
> ----------------------------------------------------------------
>
>                 Key: SPARK-24631
>                 URL: https://issues.apache.org/jira/browse/SPARK-24631
>             Project: Spark
>          Issue Type: New JIRA Project
>          Components: Spark Core, Spark Submit
>    Affects Versions: 2.2.1
>            Reporter: Sivakumar
>            Priority: Major
>
> Getting the below error when executing the simple select query,
> Sample:
> Table Description:
> name: String, id: BigInt
> val df=spark.sql("select name,id from testtable")
> ERROR: {color:#FF0000}Cannot up cast column "id" from bigint to smallint as it may truncate.{color}
> I am not doing any transformation's, I am just trying to query a table ,But still I am getting the error.
> I am getting this error only on production cluster and only for a single table, other tables are running fine.
>  



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org