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