[jira] [Commented] (FLINK-6780) ExternalTableSource fails to add the processing time and the event time attribute in the row type

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

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

sunjincheng commented on FLINK-6780:
------------------------------------

HI, [~wheat9] If I understand you correctly, your meant currently the external table source not implement both {{DefinedRowtimeAttribute}} and  {{DefinedProctimeAttribute}} interface. e.g: {{CsvTableSource}}, when we using {{CsvTableSource}} by register {{registerExternalCatalog}}, {{FlinkLogicalTableSourceScan#deriveRowType}} will get None {{XXXtimeAttribute}}.  Please tell me if i understand you incorrectly. 

And it's great if you can add test case for the error above.

Thanks,
SunJincheng

> ExternalTableSource fails to add the processing time and the event time attribute in the row type
> -------------------------------------------------------------------------------------------------
>
>                 Key: FLINK-6780
>                 URL: https://issues.apache.org/jira/browse/FLINK-6780
>             Project: Flink
>          Issue Type: Bug
>            Reporter: Haohui Mai
>            Assignee: Haohui Mai
>            Priority: Critical
>
> We observed that all streaming queries that refer to external tables fail when the Volcano planner converting {{LogicalTableScan}} to {{FlinkLogicalTableSourceScan}}:
> {noformat}
> Type mismatch:
> rowtype of new rel:
> RecordType(<table schema>, TIMESTAMP(3) NOT NULL proctime) NOT NULL
> rowtype of set:
> RecordType(<table schema>, ...) NOT NULL
> {noformat}
> Tables that are registered through {{StreamTableEnvironment#registerTableSource()}} do not suffer from this problem as {{StreamTableSourceTable}} adds the processing time / event time attribute automatically.



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)