[ https://issues.apache.org/jira/browse/KYLIN-5728?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17790466#comment-17790466 ]
Xiaoxiang Yu commented on KYLIN-5728: ------------------------------------- Looks like it is a Spark related issues. Could you please provided your ddl of original table and view? Do you tried to add "cast" in the ddl of the view? > Kylin 5 Hive Data source - sync issue with hive view's column type BigInt > -------------------------------------------------------------------------- > > Key: KYLIN-5728 > URL: https://issues.apache.org/jira/browse/KYLIN-5728 > Project: Kylin > Issue Type: Bug > Components: Spark Engine > Affects Versions: 5.0-beta > Reporter: Sonu Kumar Singh > Priority: Critical > Fix For: 5.0.0 > > > traceId: 4bc0af5c-f138-5507-4c42-9cdb1f17fe03 2023-11-22T06:15:01,594 ERROR > [xxxx] [http-nio-9000-exec-6] source.NSparkTableMetaExplorer : Error for > parser view: table > org.apache.spark.sql.AnalysisException: Cannot up cast column1 from bigint to > int. > The type path of the target object is: > You can either add an explicit cast to the input data or choose a higher > precision type of the field in the target object -- This message was sent by Atlassian Jira (v8.20.10#820010)