Database Reference
In-Depth Information
WITH SERDEPROPERTIES (
"hbase.columns.mapping" =
":key,strings:UserID, strings:UserName,
ints:UserAge, strings:UserBob )
TBLPROPERTIES("hbase.table.name" =
"hivetableforhbase");
4. Now we can issue the following query in the Impala shell:
-- When row key is mapped as string
column, range predicates are applied in
the scan
SELECT * FROM hivetableforhbase_useragg
WHERE UserId = '10';
-- When row key is not transformed into
scan parameter (not mapped as string)
SELECT * FROM hivetableforhbase WHERE id
= 10;
Search WWH ::




Custom Search