Running phoenix flashback queries / setting currentSCN properties for sqlline

[#1]

Hello in phoenix doc here it suggested one can run a flashback query by setting "currenSCN" settings in connection properties.

How do one set this properties in :

• sqlline.py command line utility?

I am using HDP 2.5.3 / Phoenix 4.7

Thank you!!

[#2]

For sqlline, you can give something like:

 ./sqlline.py "host;CurrentSCN=<ts>"

[#3 · Accepted solution]

Ok thanks I have finally got it working. It can be run like this for example:

sqlline.py "sandbox:2181/hbase-secure;currentSCN=1490372958713"