[DRILL-6195] Quering Hive non-partitioned transactional tables via Drill

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.12.0
• Fix Version/s: 1.13.0
• Component/s: Storage - Hive
• Labels: ready-to-commit
• Assignee: Vitalii Diravka
• Reporter: Vitalii Diravka
• Reviewer: Arina Ielchiieva
• Created: 28/Feb/18 14:14
• Updated: 03/Mar/18 18:50
• Resolved: 03/Mar/18 18:50

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

Issue Links

• is related to: DRILL-6196 Upgrade HiveTestDataGenerator to leverage "schematool"
• links to: GitHub Pull Request #1140