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

PhoenixObjectInspector doesn't have information on length of the column.

    Details

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

      Description

      PhoenixObjectInspector doesn't have information on length of the column. this causes making incorrect constant valuesfor char columns in select statement because of padding spaces with max length(255), and get wrong results because of invalid filter conditions.

      ex) column : r_name char(6),
      hive query : select * from r_name = 'EUROPE',
      phoenix query : select * from r_name = 'EUROPE ' (with 249(255 - 6) tailing white spaces)

        Attachments

          Activity

            People

            • Assignee:
              Jeongdae Kim Jeongdae Kim
              Reporter:
              Jeongdae Kim Jeongdae Kim
            • Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: