Can you paste the detailed hive table description. (desc formatted .....) Balaji.V On Friday, October 9, 2020, 12:37:19 AM PDT, Ranganath Tirumala <ranganath.tirum...@gmail.com> wrote: Hi Balaji,
I cannot get this to work on hive / hue. It works as expected using spark shell. Any idea how I can get this to work in hive / hue? Regards, Ranganath On Thu, 1 Oct 2020 at 09:45, Balaji Varadarajan <v.bal...@ymail.com.invalid> wrote: > Assuming commit1 happened before commit2, this is what you should expect > when running a standard query through query engines. > Balaji.V > > On Tuesday, September 29, 2020, 03:04:17 PM PDT, Ranganath Tirumala < > ranganath.tirum...@gmail.com> wrote: > > Hi, > > Is there a way we can query to get the latest record across commits? > > e.g. > commit-1 > Record-1, Value A > Record-2, Value A > > commit-2 > Record-1, Value B > Record-3, Value B > > desired output > Record-1, Value B > Record-2, Value A > Record-3, Value B > > -- > Regards, > > Ranganath Tirumala > -- Regards, Ranganath Tirumala