phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Randy Hu <ruw...@gmail.com>
Subject Re: View timestamp on existing table (potential defect)
Date Tue, 02 May 2017 23:05:35 GMT
After poking around the Phoenix code (thanks  Ankit for the starting point).
Seems there is way to set up a default HBase timestamp, which suites my need
to query existing HBase tables:

https://phoenix.apache.org/faq.html#Can_phoenix_work_on_tables_with_arbitrary_timestamp_as_flexible_as_HBase_API

Here is the command line to pass the property when using sqlline.py:

sqlline.py "localhost;CurrentSCN=9223372036854775807"

and JDBC URL when using other JDBC client, like Squirrel SQL:

jdbc:phoenix:localhost;CurrentSCN=9223372036854775807

FYI, 9223372036854775807 is the the max long value in Java.

This will guaranty the latest value returned from query. Using it cautiously
if there are updates in Phoenix as well.



--
View this message in context: http://apache-phoenix-user-list.1124778.n5.nabble.com/View-timestamp-on-existing-table-potential-defect-tp3475p3507.html
Sent from the Apache Phoenix User List mailing list archive at Nabble.com.

Mime
View raw message