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

JDBC ResultSet fails to get value by qualified projection name

Log workAgile BoardRank to TopRank to BottomVotersWatch issueWatchersCreate sub-taskConvert to sub-taskMoveLinkCloneLabelsUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • 0.12.0
    • 0.13.0
    • HiveServer2

    Description

      Getting value from result set using fully qualified name would throw exception. Only solution today is to use position of the column as opposed to column label.

      String sql = "select r1.x, r2.x from r1 join r2 on r1.y=r2.y";
      ResultSet res = stmt.executeQuery(sql);
      res.getInt("r1.x");
      

      res.getInt("r1.x"); would throw exception unknown column even though sql specifies it.

      Fix is to fix resultsetschema in semantic analyzer.

      Attachments

        1. HIVE-6687.4.patch
          8 kB
          Laljo John Pullokkaran

        Issue Links

        Activity

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            jpullokkaran Laljo John Pullokkaran Assign to me
            jpullokkaran Laljo John Pullokkaran
            Votes:
            0 Vote for this issue
            Watchers:
            6 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Issue deployment