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

Invisible views using ODBC

Log workAgile BoardRank to TopRank to BottomBulk Copy AttachmentsBulk Move AttachmentsVotersWatch issueWatchersCreate sub-taskConvert to sub-taskMoveLinkCloneLabelsUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Duplicate
    • 3.1.0
    • None
    • Database/Schema, Hive, ODBC, Views
    • None

    Description

      Hive show tables command does not list views  - they're invisible when we're using ODBC. 
      We could operate on this views, for example select records but they're invisible on list of data structures. We're connecting with Hive by using Hortonworks ODBC Driver for Apache Hive. Any of tools that we're using (Aginity for Hadoop, Microsoft Excel, Tableau Desktop) does not list views but only tables. This views are visible in HUE. 

      Attachments

        1. jiira.png
          68 kB
          Ernest Jaroń

        Issue Links

        Activity

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

          People

            Unassigned Unassigned Assign to me
            ernest.jaron Ernest Jaroń
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment