phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From David Auclair <d.aucl...@utoronto.ca>
Subject Problem with ROW_TIMESTAMP
Date Fri, 07 Jun 2019 17:31:41 GMT
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



Mime
View raw message