[
https://issues.apache.org/jira/browse/DRILL-6195?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Arina Ielchiieva updated DRILL-6195:
------------------------------------
Reviewer: Arina Ielchiieva
> 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
> Priority: Major
> 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)
