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

A UDTF to show schema (column names and types) of given query

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

    Details

    • Type: New Feature
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 4.0.0
    • Fix Version/s: 4.0.0
    • Component/s: UDF

      Description

      We can get ResultSet metadata using ResultSet#getMetaData() but JDBC provides no way of getting nested data types(of columns) associated with it. This UDTF helps to retrieve each column name and it's data type.

        Attachments

        1. HIVE-21270.7.patch
          19 kB
          Shubham Chaurasia
        2. HIVE-21270.6.patch
          19 kB
          Shubham Chaurasia
        3. HIVE-21270.5.patch
          15 kB
          Shubham Chaurasia
        4. HIVE-21270.4.patch
          11 kB
          Shubham Chaurasia
        5. HIVE-21270.3.patch
          11 kB
          Shubham Chaurasia
        6. HIVE-21270.2.patch
          11 kB
          Shubham Chaurasia
        7. HIVE-21270.1.patch
          10 kB
          Shubham Chaurasia

        Issue Links

        is related to

        Improvement - An improvement or enhancement to an existing feature or task. HIVE-21373 Expose query result cache info as a UDTF

        • Minor - Minor loss of function, or other problem where easy workaround is present.
        • Open
        links to

        Web Link GitHub Pull Request #534

          Activity
          $i18n.getText('security.level.explanation', $currentSelection) Viewable by All Users
          Cancel

            People

            • Assignee:
              ShubhamChaurasia Shubham Chaurasia Assign to me
              Reporter:
              ShubhamChaurasia Shubham Chaurasia

              Dates

              • Created:
                Updated:
                Resolved:

              Time Tracking

              Estimated:
              Original Estimate - Not Specified
              Not Specified
              Remaining:
              Remaining Estimate - 0h
              0h
              Logged:
              Time Spent - 2h 10m
              2h 10m

                Issue deployment