Support Questions
Find answers, ask questions, and share your expertise

Running phoenix flashback queries / setting currentSCN properties for sqlline

Solved Go to solution
Highlighted

Running phoenix flashback queries / setting currentSCN properties for sqlline

Expert Contributor

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

Accepted Solutions

Re: Running phoenix flashback queries / setting currentSCN properties for sqlline

Expert Contributor

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
Highlighted

Re: Running phoenix flashback queries / setting currentSCN properties for sqlline

For sqlline, you can give something like:

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

Re: Running phoenix flashback queries / setting currentSCN properties for sqlline

Expert Contributor

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