Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

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"
2 REPLIES 2

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"
Don't have an account?
Coming from Hortonworks? Activate your account here