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