Column order preserved in REST API & REST API DBI-based calls if using Apache Drill 1.15.0+ (Addresses #18)
New drill_functions() function to show all the available Apache Drill built-in functions & UDFs (Apache Drill 1.15.0+ required); this function has an option to display the functions in a widget and has added the DT package toSuggests in the DESCRIPTION file.
DBI & dbplyr-REST interface queries now return much better query error messages including original query text and a link to the Drill query profile (so users can do more in-depth debugging)
License change to GPL-3 since the pkg now uses code from bibrquery
New option() => “sergeant.bigint.warnonce” to control BIGINTwarnings. Useoptions(sergeant.bigint.warnonce = FALSE)
Fixed bug in dbListFields()(DrillConnection-class)
Added as.integer64()dplyr custom Drill function to convert columns to BIGINT
Added ctas_profile() to automagically create a CTAS query from a Drill tbl (Ref: #29 / inspired by David Severski)
Switched to the more diminuitive {tinytest}
Added more tests to cover DBI and extended/new d[b]plyr operations
sergeant 0.7.0-BETA
separated out Java-based functions (i.e. the JDBC driver) into a sibling package sergeant.caffeinated
sergeant 0.7.0-ALPHA
enhanced JDBC connectivity
updated REST API to handle new features in Drill 1.14.0
sergeant 0.6.0
Authentication support for DBI/dplyr anddrill_connection() pure REST interface
sergeant 0.5.2
Make rJava & RJDBC optional (WIP)
Hack to remove “;” at end of queries sent todrill_query()
Added dbplyr windows functions tosql_translate_env
sergeant 0.4.0
Getting ready for new dplyr (thx to Edward Visel)
Cleaned up roxygen docs so that src_drill is exported now.
sergeant 0.3.2
Finally got quoting done. I thought I had before but I guess I hadn’t.
Added documnentation for built-in and custom Drill function that are supported.
sergeant 0.3.1.9000
fixed src_drill() example
JDBC driver still in github repo but no longer included in pkg builds. See README.md or drill_jdbc() help for more information on using the JDBC driver with sergeant.
sergeant 0.3.0.9000
New DBI interface (to the REST API)
dplyr interface now uses the DBI interace to the REST API
CRAN checks pass besides size (removing JDBC driver in next dev iteration)