You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@flink.apache.org by "zck (Jira)" <ji...@apache.org> on 2022/09/05 07:23:00 UTC

[jira] [Created] (FLINK-29190) flink hive left join mysql error

zck created FLINK-29190:
---------------------------

             Summary: flink hive left join mysql error
                 Key: FLINK-29190
                 URL: https://issues.apache.org/jira/browse/FLINK-29190
             Project: Flink
          Issue Type: Bug
          Components: Table SQL / Runtime
    Affects Versions: 1.14.0
            Reporter: zck


select * from hive_table left join mysql_table on hive_table.id=mysql_table .id where

mysql_table .name='kcz';

 

CREATE TABLE if not exists car_info
(
vin STRING,
battery_factory STRING
) WITH (
'connector' = 'jdbc',
'url' = 'url',
'table-name' = 'car_info',
'username' = 'name',
'password' = 'password'
);

hive table does not use flink's table building syntax, using the hive native table.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)