[jira] [Created] (DRILL-6195) Quering Hive non-partitioned transactional tables via Drill

["Vitalii Diravka (JIRA)" <ji...@apache.org>]

Vitalii Diravka created DRILL-6195:
--------------------------------------

             Summary: Quering Hive non-partitioned transactional tables via Drill
                 Key: DRILL-6195
                 URL: https://issues.apache.org/jira/browse/DRILL-6195
             Project: Apache Drill
          Issue Type: Bug
          Components: Storage - Hive
    Affects Versions: 1.12.0
            Reporter: Vitalii Diravka
            Assignee: Vitalii Diravka
             Fix For: 1.13.0


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:
{code}
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);
{code}
{code}
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
{code}



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)