drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "ASF GitHub Bot (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DRILL-6195) Quering Hive non-partitioned transactional tables via Drill
Date Thu, 01 Mar 2018 09:23:00 GMT

    [ https://issues.apache.org/jira/browse/DRILL-6195?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16381726#comment-16381726
] 

ASF GitHub Bot commented on DRILL-6195:
---------------------------------------

Github user arina-ielchiieva commented on the issue:

    https://github.com/apache/drill/pull/1140
  
    +1


> 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)

Mime
View raw message