[
https://issues.apache.org/jira/browse/DRILL-6195?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16380690#comment-16380690
]
ASF GitHub Bot commented on DRILL-6195:
---------------------------------------
GitHub user vdiravka opened a pull request:
https://github.com/apache/drill/pull/1140
DRILL-6195: Quering Hive non-partitioned transactional tables via Drill
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/vdiravka/drill DRILL-6195
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/drill/pull/1140.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #1140
----
commit 655075f9cea5f41e2770924ceabee79a57ea323e
Author: Vitalii Diravka <vitalii.diravka@...>
Date: 2018-02-28T14:16:17Z
DRILL-6195: Quering Hive non-partitioned transactional tables via Drill
----
> 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)
