Primay key in Phoenix returns Null when decleared as bigint

Question

I am using Phoenix to run SQL on my HBase, but when I try bigint for primary key it returns NULL for that columns in select but varchar return correct result

Anish Nair · Answer 1 · 2019-09-17T21:14:13.633

1

This is plainly because the primary key in Hbase/Phoenix is stored as an integer, which by definition can be 0,1,-1. If it is 0, it is nullable which a primary key cannot be. Hence, we need to keep it as a VARCHAR.

edited Sep 17 '19 at 21:14

answered Sep 17 '19 at 03:37

Anish Nair

79
2
11

Primay key in Phoenix returns Null when decleared as bigint

1 Answers1