> On Oct 9, 2016, at 7:56 AM, Ashta <sewa...@gmail.com> wrote: > > I am trying to query data from Hive service and create a variable. > > > dbGetQuery(hivecon,"select date1, date2 from dateTable limit 10") > date1, date2, Diif > 4/5/1999, 6/14/2000 > 7/2/1999, 6/26/2000 > 8/14/1999, 8/19/2000 > 11/10/1999, 9/18/2000 > 8/25/2000, 6/5/2001 > 3/14/2012, 3/15/2004 > > > Here is what I wanted to do. While I am querying I want create a > variable diff= dat1e1-date2. > I may use this variable "diff" to do some statistics (mean, mode, > etc) and also in the where clause l like as the following. > > test_date=dbGetQuery(hivecon,"select date1, date2 from dateTable > where diff gt 1000 limit 10") > > I would appreciate if you suggest me how to do this. > > > > Here is the sample of the data and result > > date1, date2, Diif > 4/5/1999, 6/14/2000, -436 > 7/2/1999, 6/26/2000, -360 > 8/14/1999, 8/19/2000, -371 > 11/10/1999, 9/18/2000, -313 > 8/25/2000, 6/5/2001, -284 > 3/14/2012, 3/15/2004, 2921 > > Thank you in advance > > ______________________________________________ > R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see > https://stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide http://www.R-project.org/posting-guide.html > and provide commented, minimal, self-contained, reproducible code.
David Winsemius Alameda, CA, USA ______________________________________________ R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
