[ABI 云体验] 数据整合和数据集的关系

截图202006121039555645.png (126.7 KB, 下载次数: )

下载附件

2020-6-12 10:39 上传

选择主题表输出，etl过程执行成功后，主题表会出现在数据集对应节点下

输出表不能是多表吗？怎么设置多个输出表到一个主题表呢

2020-06-12 11:09:58 开始执行ETL过程：[copyof_ETL过程13894878096]

2020-06-12 11:09:58 开始执行组件：am_accident
2020-06-12 11:09:58 结束执行组件：am_accident
2020-06-12 11:09:58 开始执行组件：多表聚合主题表
2020-06-12 11:09:58 组件对应的输入SQL：

SELECT T0.sid AS SID,T0.c_number AS C_NUMBER,T0.c_time AS C_TIME,T0.c_slight AS C_SLIGHT
FROM zhzy_dev.am_accident T0
2020-06-12 11:09:58 完成将数据插入到目标表：SUBJECTROUBG
2020-06-12 11:09:58 java.lang.RuntimeException: com.esen.jdbc.pool.impl.oracle.OraclePooledSQLException: ORA-00942: table or view does not exist

    at com.esen.jdbc.dialect.impl.TableMetaDataImpl.initCols(TableMetaDataImpl.java:126)
    at com.esen.jdbc.dialect.impl.TableMetaDataImpl.getColumnCount(TableMetaDataImpl.java:142)
    at com.esen.jdbc.dialect.impl.TableMetaDataCacheImpl.getColumnCount(TableMetaDataCacheImpl.java:61)
    at com.esen.ecore.sql.impl.PhysicalTableImpl.getAllFields(he:200)
    at com.esen.ecore.sql.impl.QueryImpl.addAllField(qn:28)
    at com.esen.edf.domain.job.widget.AbstractEtlWidgetTarget.createQueryFromTable(AbstractEtlWidgetTarget.java:553)
    at com.esen.edf.domain.job.widget.AbstractEtlWidgetTarget.process(AbstractEtlWidgetTarget.java:421)
    at com.esen.edf.domain.job.EtlJob.processEtlJob(EtlJob.java:554)
    at com.esen.edf.domain.job.EtlJob.process(EtlJob.java:450)
    at com.esen.edf.domain.job.EtlJobRequestTask.call(EtlJobRequestTask.java:69)
    at com.esen.edf.domain.job.EtlJobRequestTask.call(EtlJobRequestTask.java:26)
    at com.esen.ethreadpool.req.RequestTaskFutureImpl.call(RequestTaskFutureImpl.java:100)
    at com.esen.scheduling.LocaleTask.call(LocaleTask.java:56)
    at java.util.concurrent.FutureTask.run(FutureTask.java:266)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
    at java.lang.Thread.run(Thread.java:748)
Caused by: com.esen.jdbc.pool.impl.oracle.OraclePooledSQLException: ORA-00942: table or view does not exist

    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
    at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)
    at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)
    at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
    at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
    at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:193)
    at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:873)
    at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1167)
    at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1289)
    at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1491)
    at oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:406)
    at com.esen.jdbc.pool.PooledStatement.getQureyResultSet(PooledStatement.java:54)
    at com.esen.jdbc.pool.impl.oracle.OraclePooledStatement.executeQuery(OraclePooledStatement.java:22)
    at com.esen.jdbc.dialect.impl.oracle.OracleTableMetaData.analyseMeta(OracleTableMetaData.java:315)
    at com.esen.jdbc.dialect.impl.oracle.OracleTableMetaData.initColumns(OracleTableMetaData.java:264)
    at com.esen.jdbc.dialect.impl.TableMetaDataImpl.initCols(TableMetaDataImpl.java:123)
    ... 16 more

2020-06-12 11:09:58 执行ETL过程[copyof_ETL过程13894878096]出现异常：java.lang.RuntimeException: com.esen.jdbc.pool.impl.oracle.OraclePooledSQLException: ORA-00942: table or view does not exist

    at com.esen.jdbc.dialect.impl.TableMetaDataImpl.initCols(TableMetaDataImpl.java:126)
    at com.esen.jdbc.dialect.impl.TableMetaDataImpl.getColumnCount(TableMetaDataImpl.java:142)
    at com.esen.jdbc.dialect.impl.TableMetaDataCacheImpl.getColumnCount(TableMetaDataCacheImpl.java:61)
    at com.esen.ecore.sql.impl.PhysicalTableImpl.getAllFields(he:200)
    at com.esen.ecore.sql.impl.QueryImpl.addAllField(qn:28)
    at com.esen.edf.domain.job.widget.AbstractEtlWidgetTarget.createQueryFromTable(AbstractEtlWidgetTarget.java:553)
    at com.esen.edf.domain.job.widget.AbstractEtlWidgetTarget.process(AbstractEtlWidgetTarget.java:421)
    at com.esen.edf.domain.job.EtlJob.processEtlJob(EtlJob.java:554)
    at com.esen.edf.domain.job.EtlJob.process(EtlJob.java:450)
    at com.esen.edf.domain.job.EtlJobRequestTask.call(EtlJobRequestTask.java:69)
    at com.esen.edf.domain.job.EtlJobRequestTask.call(EtlJobRequestTask.java:26)
    at com.esen.ethreadpool.req.RequestTaskFutureImpl.call(RequestTaskFutureImpl.java:100)
    at com.esen.scheduling.LocaleTask.call(LocaleTask.java:56)
    at java.util.concurrent.FutureTask.run(FutureTask.java:266)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
    at java.lang.Thread.run(Thread.java:748)
Caused by: com.esen.jdbc.pool.impl.oracle.OraclePooledSQLException: ORA-00942: table or view does not exist

    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
    at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)
    at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)
    at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
    at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
    at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:193)
    at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:873)
    at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1167)
    at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1289)
    at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1491)
    at oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:406)
    at com.esen.jdbc.pool.PooledStatement.getQureyResultSet(PooledStatement.java:54)
    at com.esen.jdbc.pool.impl.oracle.OraclePooledStatement.executeQuery(OraclePooledStatement.java:22)
    at com.esen.jdbc.dialect.impl.oracle.OracleTableMetaData.analyseMeta(OracleTableMetaData.java:315)
    at com.esen.jdbc.dialect.impl.oracle.OracleTableMetaData.initColumns(OracleTableMetaData.java:264)
    at com.esen.jdbc.dialect.impl.TableMetaDataImpl.initCols(TableMetaDataImpl.java:123)
    ... 16 more

ORA-00942: table or view does not exist

数据库层面报错，检查表输入的表或视图是否存在