You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@paimon.apache.org by "seekforshell (via GitHub)" <gi...@apache.org> on 2026/07/15 03:13:39 UTC

[I] [Bug] Relational expression xxx belongs to a different planner than is currently being used [paimon]

seekforshell opened a new issue, #8633:
URL: https://github.com/apache/paimon/issues/8633

   ### Search before asking
   
   - [x] I searched in the [issues](https://github.com/apache/paimon/issues) and found nothing similar.
   
   
   ### Paimon version
   
   1.4.1
   
   ### Compute Engine
   
   flink 1.14 + Hadoop 3.1.1
   
   ### Minimal reproduce step
   
   -- 1.create paimon catalog
   CREATE CATALOG pc WITH (
       'type' = 'paimon',
       'warehouse' = 'file:///tmp/paimon-warehouse'
   );
   
   -- 2. test case, first create three base table 
   CREATE TABLE IF NOT EXISTS pc.test.user_info (
       user_id BIGINT,
       user_name STRING,
       age INT,
       PRIMARY KEY (user_id) NOT ENFORCED
   );
   
   CREATE TABLE IF NOT EXISTS pc.test.user_ext_info (
       user_id BIGINT,
       address STRING,
       phone STRING,
       PRIMARY KEY (user_id) NOT ENFORCED
   );
   
   CREATE TABLE IF NOT EXISTS pc.test.user_level (
       user_id BIGINT,
       level STRING,
       score INT,
       PRIMARY KEY (user_id) NOT ENFORCED
   ) WITH (
       'bucket' = '10',
       'bucket-key' = 'user_id'
   );
   
   -- 3. create union view 
   CREATE VIEW IF NOT EXISTS view_user_union AS
   SELECT 
       user_id, 
       user_name, 
       age, 
       CAST(NULL AS STRING) AS address,
       CAST(NULL AS STRING) AS phone
   FROM pc.test.user_info
   
   UNION ALL
   
   SELECT 
       user_id, 
       CAST(NULL AS STRING) AS user_name,
       CAST(NULL AS INT) AS age,
       address, 
       phone
   FROM pc.test.user_ext_info;
   
   -- 4. assert found
   SELECT 
       u.user_id,
       u.user_name,
       u.age,
       u.address,
       u.phone,
       l.level,
       l.score
   FROM view_user_union u
   LEFT JOIN pc.test.user_level l ON u.user_id = l.user_id;
   
   
   ### What doesn't meet your expectations?
   
   The SELECT statement is expected to execute normally
   
   ### Anything else?
   
   _No response_
   
   ### Are you willing to submit a PR?
   
   - [ ] I'm willing to submit a PR!


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: issues-unsubscribe@paimon.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


Re: [I] [Bug] Relational expression xxx belongs to a different planner than is currently being used [paimon]

Posted by "seekforshell (via GitHub)" <gi...@apache.org>.
seekforshell closed issue #8633: [Bug] Relational expression xxx belongs to a different planner than is currently being used
URL: https://github.com/apache/paimon/issues/8633


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: issues-unsubscribe@paimon.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


Re: [I] [Bug] Relational expression xxx belongs to a different planner than is currently being used [paimon]

Posted by "lilei1128 (via GitHub)" <gi...@apache.org>.
lilei1128 commented on issue #8633:
URL: https://github.com/apache/paimon/issues/8633#issuecomment-5018323190

   update flink version to 1.16+ ?


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: issues-unsubscribe@paimon.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org