Uploaded image for project: 'Flink'
  1. Flink
  2. FLINK-32188

Support to "where" query with a fixed-value array and simplify condition for an array-type filed.

    XMLWordPrintableJSON

Details

    Description

      When I customized a data source connector which assumed as image-connector, I met issues while creating a table with ddl to specify a field "URL" as an array type. When submitting an SQL task with Flink, I specified query of this field with a fixed array. For example, "select * from image source where URL=ARRAY ['/flink. jpg', '/flink_1. jpg']", but it couldn't obtain the corresponding predicate filters at all.

      Does the custom connector not support to query fields of array type with "where"?

      Attachments

        1. screenshot-1.png
          134 kB
          Xin Chen
        2. image-2023-05-25-17-16-02-288.png
          239 kB
          Xin Chen
        3. screenshot-2.png
          254 kB
          Xin Chen
        4. screenshot-3.png
          154 kB
          Xin Chen
        5. screenshot-4.png
          51 kB
          Xin Chen
        6. screenshot-5.png
          182 kB
          Xin Chen
        7. screenshot-6.png
          135 kB
          Xin Chen
        8. image-2023-05-25-20-44-08-834.png
          129 kB
          Xin Chen
        9. image-2023-05-25-20-44-47-581.png
          122 kB
          Xin Chen
        10. screenshot-7.png
          97 kB
          Xin Chen
        11. screenshot-8.png
          182 kB
          Xin Chen
        12. screenshot-9.png
          137 kB
          Xin Chen
        13. screenshot-10.png
          137 kB
          Xin Chen
        14. screenshot-11.png
          269 kB
          Xin Chen
        15. screenshot-12.png
          257 kB
          Xin Chen
        16. image-2023-06-06-16-50-10-805.png
          75 kB
          Xin Chen
        17. image-2023-06-06-16-50-54-467.png
          141 kB
          Xin Chen

        Issue Links

          Activity

            People

              Unassigned Unassigned
              xinchen147 Xin Chen
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated: