Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-6195

Quering Hive non-partitioned transactional tables via Drill

Attach filesAttach ScreenshotVotersWatch issueWatchersCreate sub-taskLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

    Details

      Description

      After updating Hive client Drill can query Hive partitioned bucketed tables.
      The same logic can be used for Hive non-partitioned transnational bucketed tables.

      Use case:

      Hive
      CREATE TABLE test_txn_2 (userid VARCHAR(64), link STRING, came_from STRING)
      CLUSTERED BY (userid) INTO 8 BUCKETS STORED AS ORC
      TBLPROPERTIES (
       'transactional'='true'
      );
      INSERT INTO TABLE test_txn_2 VALUES ('jsmith', 'mail.com', 'sports.com'), ('jdoe', 'mail.com', null);
      
      0: jdbc:drill:> select * from hive.test_txn_2;
      Error: SYSTEM ERROR: IOException: Open failed for file: /user/hive/warehouse/test_txn_2, error: Invalid argument (22)
      
      Setup failed for null
      

        Attachments

        Issue Links

          Activity

            People

            • Assignee:
              vitalii Vitalii Diravka
              Reporter:
              vitalii Vitalii Diravka
              Reviewer:
              Arina Ielchiieva

              Dates

              • Created:
                Updated:
                Resolved:

                Issue deployment