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

When two tables have the same field, do not specify the table name,Exception will be thrown:SqlValidatorException :Column 'currency' is ambiguous

    XMLWordPrintableJSON

Details

    Description

      When two tables are join, the two tables have the same field. When querying select, an exception will be thrown if the table name is not specified

      exception content

      Column 'currency' is ambiguous。

       

      Attachments

        1. image-2022-09-28-21-00-01-302.png
          27 kB
          ZuoYan
        2. image-2022-09-28-21-00-09-054.png
          51 kB
          ZuoYan
        3. image-2022-09-28-21-00-22-733.png
          139 kB
          ZuoYan

        Activity

          People

            zmm_flink ZuoYan
            zmm_flink ZuoYan
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: