[
https://issues.apache.org/jira/browse/KYLIN-5728?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17789125#comment-17789125
]
Sonu Kumar Singh edited comment on KYLIN-5728 at 11/24/23 5:37 AM:
-------------------------------------------------------------------
Hi [~xxyu], The table name is different; I gave the table name as table for
reference.
This issue I am seeing with only Hive View with BigInt column and its working
with Normal Hive table.
Exception is thrown from below method from NSparkTableMetaExplorer class:
private void checkTableIsValid(CatalogTable tableMetadata, TableIdentifier
tableIdentifier, String tableName) {
if (CatalogTableType.VIEW().equals(tableMetadata.tableType())) {
try {
Installer.setURLStreamHandlerFactory(new
FsUrlStreamHandlerFactory());
SparderEnv.getSparkSession().table(tableIdentifier).queryExecution().analyzed();
} catch (Throwable e) {
logger.error("Error for parser view: " + tableName, e);
throw new RuntimeException("Error for parser view: " +
tableName + ", " + e.getMessage()
+ "(There are maybe syntactic differences between HIVE
and SparkSQL)", e);
}
}
}
was (Author: sonusingh):
Hi [~xxyu], The table name is different; I gave the table name as table for
reference.
This issue I am seeing with only Hive View with BigInt column and its working
with Normal Hive table.
> 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)
