[
https://issues.apache.org/jira/browse/FLINK-21424?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
HideOnBush updated FLINK-21424:
-------------------------------
Description:
{code:java}
Flink view cannot use hive temporal{code}
The kafka table can temporal join Hive Table.
CREATE TABLE kfk_fact_bill_master_pup (
payLst ROW(groupID int, shopID int, shopName String, isJoinReceived int),
proctime as PROCTIME()
) WITH (
'connector' = 'kafka',
'topic' = 'topic_name',
'format' = 'json',
);
But the next operation will report an error。e.g..
create view test_view as
select * from kfk_fact_bill_master_pup;
use test_view temporal join Hive Table will report error. and view have
proctime field.
This is Error Message.
!企业微信截图_35dfdc08-4f3f-4f34-962f-6db9afcf7cb0.png!
was:
{code:java}
Flink view cannot use hive temporal{code}
The kafka table can temporal join Hive Table.
CREATE TABLE kfk_fact_bill_master_pup (
payLst ROW(groupID int, shopID int, shopName String, isJoinReceived int),
proctime as PROCTIME()
) WITH (
'connector' = 'kafka',
'topic' = 'topic_name',
'format' = 'json',
);
But the next operation will report an error。e.g..
create view test_view as
select * from kfk_fact_bill_master_pup;
use test_view temporal join Hive Table will report error. and view have
proctime field.
!企业微信截图_86542a7e-9bab-4078-82c5-583b79f01670.png!
!企业微信截图_35dfdc08-4f3f-4f34-962f-6db9afcf7cb0.png!
> Flink view cannot use hive temporal
> -----------------------------------
>
> Key: FLINK-21424
> URL: https://issues.apache.org/jira/browse/FLINK-21424
> Project: Flink
> Issue Type: Wish
> Components: Table SQL / API
> Affects Versions: 1.12.0
> Reporter: HideOnBush
> Priority: Major
> Attachments: 企业微信截图_35dfdc08-4f3f-4f34-962f-6db9afcf7cb0.png
>
>
> {code:java}
> Flink view cannot use hive temporal{code}
> The kafka table can temporal join Hive Table.
> CREATE TABLE kfk_fact_bill_master_pup (
> payLst ROW(groupID int, shopID int, shopName String, isJoinReceived int),
> proctime as PROCTIME()
> ) WITH (
> 'connector' = 'kafka',
> 'topic' = 'topic_name',
> 'format' = 'json',
> );
>
> But the next operation will report an error。e.g..
> create view test_view as
> select * from kfk_fact_bill_master_pup;
>
> use test_view temporal join Hive Table will report error. and view have
> proctime field.
>
> This is Error Message.
>
> !企业微信截图_35dfdc08-4f3f-4f34-962f-6db9afcf7cb0.png!
>
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
