[
https://issues.apache.org/jira/browse/KYLIN-5728?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17790609#comment-17790609
]
Sonu Kumar Singh commented on KYLIN-5728:
-----------------------------------------
Hi [~xxyu], Yes, it's a Spark-related issue and only comes for view with BigInt
columns during loading tables from the hive source.
View DDL -
CREATE OR REPLACE VIEW `DB1.view1` AS
SELECT
`Table1.`column1` as `column1`,
`Table2`.`column2` as `column2`
FROM
`DB2`.`Table2`;
> 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)
