CODEWITHSUNDEEP
hadoophivehbase
dijin
dijin

Reputation: 61

Deleting values in Hbase-Hive Integration

I am using Hbase for data storage and I have Hive table to read data from Hbase using Storage Handler.

I am Using a Composite ROWKEY (Struct (region,country,date,id)).

Is there any way to delete specific data from Hbase-Hive Integaration ,either from Hbase or from HIve??

Can something like below be done using HBase shell commands or Hive queries

delete from table where region=EU and country=US and date=2015-06-11;

using Hive 0.14

Thanks in advance.

Upvotes: 1

Views: 929

Answers (1)

sebge2
sebge2

Reputation: 403

Based on https://cwiki.apache.org/confluence/display/Hive/Hive+Transactions#HiveTransactions-Limitations

Tables must be bucketed to make use of these features. Tables in the same system not using transactions and ACID do not need to be bucketed. External tables cannot be made ACID tables since the changes on external tables are beyond the control of the compactor (HIVE-13175).

So apparently there is no way to perform delete in HBase using Hive.

Upvotes: 0

Related Questions