Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

Running phoenix flashback queries / setting currentSCN properties for sqlline

avatar
Super Collaborator

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!!

1 ACCEPTED SOLUTION

avatar
Super Collaborator

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

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

View solution in original post

2 REPLIES 2

avatar

For sqlline, you can give something like:

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

avatar
Super Collaborator

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

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