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

Quering Hive non-partitioned transactional tables via Drill

    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
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: