Hi,
I'm having a problem with ROW_TIMESTAMP not producing proper output:
Versions (Based on HDP 2.6.5):
HBase Shell = Version 1.1.2.2.6.5.1100-53 (assuming HBase is the same version?)
Phoenix = phoenix-4.7.0.2.6.5.1100-53-client.jar
Phoenix Sqlline = 1.1.8
In the HBase shell, I create a table & cf:
hbase(main):001:0> create "threatintel","t"
Once I've loaded some data, I can see:
column=t:v, timestamp=1559914430391, value={"ip":"222.102.76.151"}
Via Phoenix I'm trying to create a mapping to the existing table:
create table "threatintel" (ts TIMESTAMP NOT NULL, "t"."v" varchar, CONSTRAINT
pk PRIMARY KEY (ts ROW_TIMESTAMP));
Via Phoenix sqlline:
Select * from "threatintel" limit 1;
Results in:
| 292264620-05-14 12:29:06.783 | {"ip":"203.198.118.221"} |
Pretty sure that timestamp is incorrect. (And no, that wasn't the same
datapoint, but the timestamps were all within a few seconds of each other from
a bulk import)
Did I do something wrong? Any other info I can provide?
Thanks in advance,
David Auclair
