https://community.cloudera.com/t5/Archives-of-Support-Questions/Running-phoenix-flashback-queries-setting-currentSCN/m-p/173465#M58033 <P>Ok thanks I have finally got it working. It can be run like this for example:</P><PRE>sqlline.py "sandbox:2181/hbase-secure;currentSCN=1490372958713"</PRE> Mon, 27 Mar 2017 17:01:13 GMT David_Tam 2017-03-27T17:01:13Z https://community.cloudera.com/t5/Archives-of-Support-Questions/Running-phoenix-flashback-queries-setting-currentSCN/m-p/173463#M58031 <P>Hello in <A href="https://phoenix.apache.org/faq.html#Can_phoenix_work_on_tables_with_arbitrary_timestamp_as_flexible_as_HBase_API">phoenix doc here</A> it suggested one can run a flashback query by setting "currenSCN" settings in connection properties.</P><P>How do one set this properties in :</P><UL><LI>sqlline.py command line utility?</LI></UL><P>I am using HDP 2.5.3 / Phoenix 4.7</P><P>Thank you!!</P> Fri, 24 Mar 2017 20:22:47 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/Running-phoenix-flashback-queries-setting-currentSCN/m-p/173463#M58031 David_Tam 2017-03-24T20:22:47Z https://community.cloudera.com/t5/Archives-of-Support-Questions/Running-phoenix-flashback-queries-setting-currentSCN/m-p/173464#M58032 <P>For sqlline, you can give something like:</P><PRE> ./sqlline.py "host;CurrentSCN=&lt;ts&gt;"</PRE> Sat, 25 Mar 2017 09:11:57 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/Running-phoenix-flashback-queries-setting-currentSCN/m-p/173464#M58032 namaheshwari 2017-03-25T09:11:57Z https://community.cloudera.com/t5/Archives-of-Support-Questions/Running-phoenix-flashback-queries-setting-currentSCN/m-p/173465#M58033 <P>Ok thanks I have finally got it working. It can be run like this for example:</P><PRE>sqlline.py "sandbox:2181/hbase-secure;currentSCN=1490372958713"</PRE> Mon, 27 Mar 2017 17:01:13 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/Running-phoenix-flashback-queries-setting-currentSCN/m-p/173465#M58033 David_Tam 2017-03-27T17:01:13Z