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

Schema mismatch between the Hive table definition and the "hive.sql.query" Parameter

    XMLWordPrintableJSON

    Details

    • Type: Improvement
    • Status: Resolved
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: 3.1.0
    • Fix Version/s: 4.0.0
    • Component/s: Hive, HiveServer2
    • Labels:
      None

      Description

      The problem is that, for certain types of schema mismatch between the Hive table definition and the "hive.sql.query" parameter, Hive simply returns no rows rather than throwing an error when queried.

      Ideally Hive would check for schema compatibility during table definition and throw an error if there's a problem - the earlier the better. But even if that cannot be made a requirement, I'd definitely expect an error rather than a silent failure (i.e. zero rows returned) at runtime.

      I'm attaching investigation of this issue in "Hive-JDBC schema matching sensitivity.txt".

        Attachments

        1. Hive-JDBC schema matching sensitivity.txt
          7 kB
          Krishnadevan Purushothaman
        2. HIVE-22357.patch
          0.9 kB
          Rajkumar Singh

          Activity

            People

            • Assignee:
              Rajkumar Singh Rajkumar Singh
              Reporter:
              Krishna93 Krishnadevan Purushothaman
            • Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: