phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From David Auclair <>
Subject Problem with ROW_TIMESTAMP
Date Fri, 07 Jun 2019 17:31:41 GMT

I'm having a problem with ROW_TIMESTAMP not producing proper output:

Versions (Based on HDP 2.6.5):
HBase Shell = Version (assuming HBase is the same version?)
Phoenix = phoenix-
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":""}

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

Via Phoenix sqlline:
Select * from "threatintel" limit 1;

Results in:
| 292264620-05-14 12:29:06.783  | {"ip":""}  |

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

View raw message