Search code examples
hbaseclouderaimpalabigdata

Create a table on HBase through Impala

Hello I want to create database schema and some tables on HBase, I would like to do so through Impala for example

CREATE  TABLE media.post
(RowKey string, 
 HashTag string,
 PostID string,
 PostImpact int,
 PostSentiment string,
 CreationDateTime timestamp);

when I do so, I get a table created but on HDFS not on HBase, thus I cannot connect to it through HBase...is that even possible to run such sql on HBase?

Solution

  • This is not possible..

    Hbase is schema less and from Hbase you can create Impala or hive external tables. But not in the reverse way i.e from Impala table you cant create Hbase table. Its due to the fact that, nosql and sql datamodels are different

    For more understanding go through