drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Aditya Kishore (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DRILL-680) INFORMATION_SCHEMA.COLUMNS does not display hbase column familes
Date Wed, 21 May 2014 22:56:40 GMT

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

Aditya Kishore commented on DRILL-680:
--------------------------------------

Each column family is of SQL MAP type with STRING => ANY mapping where the key (STRING)
is the column name and the value (ANY) is the column value. The output type of each column
is VARBINARY .

For example, assuming there are 3 columns(qualifiers), viz {{'name'}}, {{'age'}} and {{'sex'}}
in column family {{'info'}}, you can use the following query:

{noformat}
SELECT
    row_key, info['name'], info['age'], info['sex']
FROM
    hbase.student;
{noformat}

> INFORMATION_SCHEMA.COLUMNS does not display hbase column familes
> ----------------------------------------------------------------
>
>                 Key: DRILL-680
>                 URL: https://issues.apache.org/jira/browse/DRILL-680
>             Project: Apache Drill
>          Issue Type: Bug
>            Reporter: Rahul Challapalli
>            Assignee: Aditya Kishore
>         Attachments: DRILL-680-INFORMATION_SCHEMA.COLUMNS-does-not-displa.patch
>
>
> Hbase Column families are not being shown in INFORMATION_SCHEMA.COLUMNS table 
> hbase> create 'students', 'cf1', 'cf2', 'cf3'
> drill> SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA='hbase' AND TABLE_NAME='students';
> The above query should return one row for each column family and probably one more column
for the hbase rowkey.



--
This message was sent by Atlassian JIRA
(v6.2#6252)

Mime
View raw message