Re: [I] [Bug] [Seatunnel Transform] FieldMapper是否支持对象.属性的映射关系 [seatunnel]

Thu, 23 May 2024 00:26:21 -0700 


liunaijie commented on issue #6888:
URL: https://github.com/apache/seatunnel/issues/6888#issuecomment-2126412547

   > 使用sql 确实可以解决了，但是又有了一个新的问题 
![QQ截图20240523141109](https://private-user-images.githubusercontent.com/170589378/333060107-d9398768-3997-4f6e-bba5-1e54b119ca93.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MTY0NDc5MzAsIm5iZiI6MTcxNjQ0NzYzMCwicGF0aCI6Ii8xNzA1ODkzNzgvMzMzMDYwMTA3LWQ5Mzk4NzY4LTM5OTctNGY2ZS1iYmE1LTFlNTRiMTE5Y2E5My5wbmc_WC1BbXotQWxnb3JpdGhtPUFXUzQtSE1BQy1TSEEyNTYmWC1BbXotQ3JlZGVudGlhbD1BS0lBVkNPRFlMU0E1M1BRSzRaQSUyRjIwMjQwNTIzJTJGdXMtZWFzdC0xJTJGczMlMkZhd3M0X3JlcXVlc3QmWC1BbXotRGF0ZT0yMDI0MDUyM1QwNzAwMzBaJlgtQW16LUV4cGlyZXM9MzAwJlgtQW16LVNpZ25hdHVyZT00N2FhNWM2Y2E2ZDRmOWZmNjkxNDZiMjlkYWEyYTU1YzQ2YTcxNThmYWJiZGIwNjc2YmQ4ZDRkNWJhMzQ1MGU0JlgtQW16LVNpZ25lZEhlYWRlcnM9aG9zdCZhY3Rvcl9pZD0wJmtleV9pZD0wJnJlcG9faWQ9MCJ9.Mhvup4Zw6pmyTYDlnnenj63_nTUDzTqwPwzVYO7T8uM)
 ![QQ截图20240523141254](https://private-user-images.githubusercontent.com/1
 
70589378/333060139-5af51dd0-cc89-4f33-9834-5675749925e7.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MTY0NDc5MzAsIm5iZiI6MTcxNjQ0NzYzMCwicGF0aCI6Ii8xNzA1ODkzNzgvMzMzMDYwMTM5LTVhZjUxZGQwLWNjODktNGYzMy05ODM0LTU2NzU3NDk5MjVlNy5wbmc_WC1BbXotQWxnb3JpdGhtPUFXUzQtSE1BQy1TSEEyNTYmWC1BbXotQ3JlZGVudGlhbD1BS0lBVkNPRFlMU0E1M1BRSzRaQSUyRjIwMjQwNTIzJTJGdXMtZWFzdC0xJTJGczMlMkZhd3M0X3JlcXVlc3QmWC1BbXotRGF0ZT0yMDI0MDUyM1QwNzAwMzBaJlgtQW16LUV4cGlyZXM9MzAwJlgtQW16LVNpZ25hdHVyZT00MWRkNTI2NzA5NjcwODk0MTU4MDg5ZTQ1ZWRjYmIxMDIxMTg1OTUxYTJlYzhkNmVlM2EyZmVjZWZlY2NmNWY0JlgtQW16LVNpZ25lZEhlYWRlcnM9aG9zdCZhY3Rvcl9pZD0wJmtleV9pZD0wJnJlcG9faWQ9MCJ9.KBvvJruoGL4soOtW5JyB-xopd7cSgLaCwBvTka0i_jY)
   
   
   when you use sql tranfrom.
   the `field_mapper` will ignore. the transform result will same with you 
query result.
   
   You can change to console sink to verify the result struct.
   
   
   
   And you can use multiple tranfroms to generate the result you wanted,
   like 
   ```
   transform {
     sql {
          query = ""
          result_table_name = "sql_res1"
      }
   
      sql {
         query = ""
          source_table_name = "sql_res1"
      }
   
   }
   
   
   ```
   
   
   
   
   


-- 
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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]

Reply via email to