The hardware and bandwidth for this mirror is donated by METANET, the Webhosting and Full Service-Cloud Provider.
If you wish to report a bug, or if you are interested in having us mirror your free-software or open-source project, please feel free to contact us at mirror[@]metanet.ch.

sergeant 0.9.0

• 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 to Suggests 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 BIGINT warnings. Use options(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 and drill_connection() pure REST interface

sergeant 0.5.2

• Make rJava & RJDBC optional (WIP)
• Hack to remove “;” at end of queries sent to drill_query()
• Added dbplyr windows functions to sql_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)

sergeant 0.2.1.9000

• implemented a large subset of Drill SQL Functions https://drill.apache.org/docs/about-sql-function-examples/

sergeant 0.2.0.9000

• experimental alpha dplyr driver

sergeant 0.1.2.9000

• can pass RJDBC connections made with drill_jdbc() to drill_query()
• finally enaled nodes parameter to be a multi-element character vector as it said in the function description

sergeant 0.1.2.9000

• support embedded drill JDBC connection

sergeant 0.1.1.9000

• tweaked drill_query() and drill_version()

sergeant 0.1.0.9000

• Added JDBC connector and included JDBC driver in the package (for now)
• Changed idiom to piping in a connection object
• Added a NEWS.md file to track changes to the package.

These binaries (installable software) and packages are in development.
They may not be fully stable and should be used with caution. We make no claims about them.