Uploaded image for project: 'Phoenix'
  1. Phoenix
  2. PHOENIX-3749

ERROR 502 (42702): Column reference ambiguous when order by duplicate names

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Duplicate
    • Affects Version/s: 4.8.0
    • Fix Version/s: 4.9.0
    • Labels:
      None
    • Environment:

      CentOS6 JDK1.7.0_79
      x86_64

      Description

      Tableau generates queries that alias a fully-qualified column name to its shortened name.
      Similar to:
      select room_id, sum(error_code403) as error_code403
      from dla_node_main
      group by room_id
      order by error_code403

      Phoenix reports:
      Error: ERROR 502 (42702): Column reference ambiguous or duplicate names. columnName=ERROR_CODE403
      SQLState: 42702
      ErrorCode: 502

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              cwh643 chen weihua
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: