Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-21754

Metastore schema different precision can cause comparision issues

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Open
    • Major
    • Resolution: Unresolved
    • 3.0.0
    • None
    • Metastore
    • None

    Description

      At least (but there could be others...) the avg_col_len statistic is defined with different data types in the schema for each sql flavor. This can cause comparison errors due to precision mismatch.

      E.g. the mysql schema has explicit 4 digit precision ( double(53,4) ) defined while the postgres has DOUBLE PRECISION type which has a much longer precision.

      This can cause issues like:

      EXPECTED: ['avg_col_len','1.9802'], ACTUAL: ['avg_col_len','1.9802041447571914']

      Preferably all schemas should use the same precision data types.

      Attachments

        Activity

          People

            Unassigned Unassigned
            bpusztahazi Bruno Pusztahazi
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated: