drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Krystal (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DRILL-3215) Describe table from hive storage does not connect to "default" database
Date Mon, 14 Sep 2015 23:43:45 GMT

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

Krystal commented on DRILL-3215:
--------------------------------

git.commit.id.abbrev=b525692

Verified that bug is fixed.

> Describe table from hive storage does not connect to "default" database
> -----------------------------------------------------------------------
>
>                 Key: DRILL-3215
>                 URL: https://issues.apache.org/jira/browse/DRILL-3215
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Storage - Hive
>    Affects Versions: 1.0.0
>            Reporter: Krystal
>            Assignee: Venki Korukanti
>             Fix For: 1.1.0
>
>         Attachments: DRILL-3215-1.patch
>
>
> From sqlline, I connect to a hive storage without specifying a database and issued a
"describe <table>" command.  Drill returned an empty result.
> 0: jdbc:drill:schema=dfs.root> use hive;
> +-------+-----------------------------------+
> |  ok   |              summary              |
> +-------+-----------------------------------+
> | true  | Default schema changed to [hive]  |
> +-------+-----------------------------------+
> 1 row selected (0.149 seconds)
> 0: jdbc:drill:schema=dfs.root> show tables;
> +---------------+------------------+
> | TABLE_SCHEMA  |    TABLE_NAME    |
> +---------------+------------------+
> | hive.default  | timestamp_table  |
> | hive.default  | varchar_table    |
> | hive.default  | voter_hive       |
> | hive.default  | voter_hive_p     |
> +---------------+------------------+
> 0: jdbc:drill:schema=dfs.root> describe voter_hive;
> +--+
> |  |
> +--+
> +--+
> I need to specify the database in the describe command for it to work:
> 0: jdbc:drill:schema=dfs.root> describe `hive.default`.voter_hive;
> +----------------+------------+--------------+
> |  COLUMN_NAME   | DATA_TYPE  | IS_NULLABLE  |
> +----------------+------------+--------------+
> | voter_id       | SMALLINT   | YES          |
> | name           | VARCHAR    | YES          |
> | age            | TINYINT    | YES          |
> | registration   | VARCHAR    | YES          |
> | contributions  | DECIMAL    | YES          |
> | voterzone      | INTEGER    | YES          |
> | create_time    | TIMESTAMP  | YES          |
> +----------------+------------+--------------+



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message