- Queries with query parameters only returning first page of results
- Schema support for KiSQL command-invoked catalog queries
- Support for time zone override
- Failback to a primary cluster after failing over to a secondary cluster
- Updated underlying Java API to 7.2.2.3
- Upgraded Avro library to 1.11.4
- Error message for bad URLs with auto-discovery disabled
- Potential resource leaks upon connection errors
- Updated underlying Java API to 7.2.2.2
- Issue with lookup up server version when auto-discovery is disabled
- Reduced endpoint call overhead for connections and
RecordRetriever - Updated underlying Java API to 7.2.2.1
- OAuth2 authentication support
- Updated underlying Java API to 7.2.2.0
- Modified POM for publishing to Maven Central Repository
- Upgraded Jackson core library to 2.17.1
- Downgraded Logback library to 1.3.14
- Upgraded SLF4j library to 2.0.13
- Issue with
fullshadeddriver terminating with no linked Snappy library - Issue with default string column values overwriting blank user input
- Issue with
CREATE PROCEDUREpermission commands not being parsed properly
- Updated underlying Java API to 7.2.1.0
- Snappy error for
fullshadedJAR
- Better parsing of multi-line SQL terminating semicolon
- Updated underlying Java API to 7.2.0.5
- Returned Time and Timestamp objects will now always output 3 milliseconds in their toString() methods
- Out-of-memory error when downloading large files
- Added --stopOnFirstError option for kisql
- Thread-safety with JDBC Date fields
- getTime(column).toString() was not showing milliseconds
- Support for DataSource interface
- TimeZoneOverride setting
- Output now works with TimeZone's default
- Lowered default server connection timeout to 5 seconds
- Made server connection timeout (user-specified or default) govern connection timeouts in all cases of initially connecting to a server
- Updated underlying Java API to 7.2.0.4
- Support for unsigned long type in arrays
- Updated underlying Java API to 7.2.0.3
- Various timezone-related issues
- Added support for setArray() for query parameters
- Increased connection timeout from ~1 to 20 seconds to account for connections over high-traffic and public networks
- Upgraded Snappy library from 1.1.10.4 to 1.1.10.5
- Outputting floats in scientific notation with negative-two-digit exponents
- Upgraded Apache HTTPClient5 library from 5.3 to 5.3.1
- Updated underlying Java API to 7.2.0.0
- Snappy error for
fullshadedJAR
- Publishing to Maven Central Repository
- Dependency-reduced POM for
fullshadedJAR overwriting POM for unshaded JAR
- Several security-related dependency updates
- Updated underlying Java API to 7.1.10.2
- Updated underlying Java API to 7.1.10.1
- Returned Time and Timestamp objects will now always output 3 milliseconds in their toString() methods
- Out-of-memory error when downloading large files
- Added --stopOnFirstError option for kisql
- Thread-safety with JDBC Date fields
- getTime(column).toString() was not showing milliseconds
- TimeZoneOverride setting
- Output now works with TimeZone's default
- Lowered default server connection timeout to 5 seconds
- Made server connection timeout (user-specified or default) govern connection timeouts in all cases of initially connecting to a server
- Updated underlying Java API to 7.1.9.18
- Updated underlying Java API to 7.1.9.17
- Increased connection timeout from ~1 to 20 seconds to account for connections over high-traffic and public networks
- Upgraded Snappy library from 1.1.10.4 to 1.1.10.5
- Updated underlying Java API to 7.1.9.16
- Outputting floats in scientific notation with negative-two-digit exponents
- Upgraded Apache HTTPClient5 library from 5.3 to 5.3.1
- Updated underlying Java API to 7.1.9.15
- Fixed getting user's default schema to support external users
- Updated underlying Java API to 7.1.9.14
- Updated underlying Java API to 7.1.9.13
- Support for Connection.getSchema()
- Updated underlying Java API to 7.1.9.12
- Inserting TIMESTAMP column data using string formatted times with fractions of seconds
- Added "disableSnappy" option for JDBC and kisql
- Updated underlying Java API to 7.1.9.10
- Updated underlying Java API to 7.1.9.9
- Updated underlying Java API to 7.1.9.8
- Support more options in WITH OPTIONS on INSERT statements
- Updated underlying Java API to 7.1.9.7
- Bug in DOWNLOAD FILE
- Updated underlying Java API to 7.1.9.6
- Better handling when /show/tables returns a blank attribute_index
- Updated underlying Java API to 7.1.9.5
- SET USER and EXECUTE AS USER allow more characters in user's name.
- UUID support
- Updated underlying Java API
- Issue with ingesting Byte column data
- kisql password prompting (on some terminals)
- Removed setting of impersonate header when impersonate user is blank
- Updated underlying Java API
- Updated underlying Java API
- Added the following connection string options:
ErrorMode(values:Permissive,Skip,Abort)FileReadCommentCharFileReadDelimiterFileReadEscapeCharFileReadHasHeaderFileReadInitialClearFileReadLimitFileReadNullStringFileReadQuoteCharFileReadSkipImpersonateUserUseApproxCountDistinct
- Updated underlying Java API
- Added
BypassSslCertCheckconnection string option - Added
bypassSslCertCheckKiSQL option
- Updated underlying Java API
- Support for NULL values in query parameters (for non-multi-head-insert statements)
- Truncate Strings not handling Unicode characters properly
- Updated underlying Java API
- Support for
KI_HINT_IGNORE_EXISTING_PK - Added
IgnoreExistingPkconnection string options to make all statements act as ifKI_HINT_IGNORE_EXISTING_PKhad been specified - Streamlined KiSQL output
- Support for $ style query parameters (e.g., "$1", "$2", etc.)
- Support for BOOLEAN columns and data
- Support for BigDecimal query parameters
- Updated underlying Java API
- Reporting of Kinetica
DECIMALtype as SQLDECIMAL(18,4)
- New
DIRECTORYoption forUPLOADandDOWNLOADcommands - Support for
NoSyncconnection string option to override HA Sync Mode
FILEandDIRECTORYare now optional onUPLOADandDOWNLOADcommands
- Support for inequalities on indexed columns with key lookup
(i.e.,
KI_HINT_KEY_LOOKUP) - Added the following connection string options (to make all statements act as
if the associated hint had been specified):
UseKeyLookup(forKI_HINT_KEY_LOOKUP)TruncateStrings(forKI_HINT_TRUNCATE_STRINGS)UpdateOnExistingPk(forKI_HINT_UPDATE_ON_EXISTING_PK)
- Throw error on Prepare, if table or specified columns don't exist
- Inserting duplicate PK's in the same batch with
UPDATE_ON_EXISTING_PKis now a warning and not an error
- Support for
UIDandPWDconnection string options - New
CombineResultsconnection string option to return a single affected rows count when executing multiple commands that all return an affected rows count - New
FakeTransactionsconnection string option to not return an error and ignore any transaction calls
- Do not attempt to use key lookup when not all shard keys are specified (when SK=PK)
- Query Parameters now retain their types
- Connection String settings can include special characters using URL-style
encoding (e.g.,
%3bfor semicolon)
- Support for fast record retrieval with
KI_HINT_KEY_LOOKUP - New
DisableMultiheadInsertsetting to route all inserts to the head node - Relocation of shaded dependencies
- Improved reporting of
INSERTerrors - BLOB/CLOB support
- Updated underlying Java API, allowing for better perfomance in high-load environments
- Issue with thread safety in date/time parsing
- Updated underlying Java API
- Targeted Java 8 runtime
- Default to allowing self-signed certs
- Materialized views are no longer reported as schemas
- Updated underlying Java API
- Better caching and reuse of
BulkInserterobject
- KiSQL interactive mode now supports line editing, up arrow to see previous commands, etc.
- Support multiple files for
DOWNLOAD FILE
- Improved insert performance
- Improved error handling
- Swapped out Log4j dependence for SLF4J
- KiSQL shows abbreviated prompt (i.e.,
>) when continuing a SQL Command, in interactive mode - Add optional
WITH OPTIONSforINSERTstatements to matchLOAD INTOsyntax - KiSQL commands:
\columns(\u)\indices(\i)\meta-test\primarykeys(\k)\procedures(\p)\schemas(\s)\t(as a shortcut for\tables)
-
Changed
DOWNLOADsyntax to:DOWNLOAD FILES <kifs-files> INTO <local-path> [WITH OPTIONS (<comma_seperated_key_value_list>)] -
Retrun better errors and warnings from
INSERT -
Better handling of
\Nwhen it is the NULL string and\is the escape character, when reading CSV files -
Reduce output for CSV errors in files with extremely long lines
- Filtering of Metadata is now case insensitive
- Better handling of errors reading header line in CSV
- Better handling of mixed-case filenames
UPLOADandDOWNLOADcommands- Single-file executable versions of KiSQL, which can be run anywhere
- KiSQL output of very large and very small DOUBLE and FLOAT values now uses scientific notation
- Java API dependency version to be 7.1.2.2 and above to take advantage of recent security related fixes.
- Support for
DisableAutoDiscoveryandDisableFailoverconnection string options - Support for
--disableAutoDiscoveryand--disableFailoverKiSQL command-line parameter
- Support for
SET SCHEMAcommand -- only valid when connected to a 7.1 Kinetica instance - Support for
--schemaKiSQL command-line parameter - Support for
schemaparameter on JDBC Connection string - Support for
schemaparameter to ODBC
- Updated underlying API version
- Updated underlying API version
- Updated underlying API version
- Improved insert performance
- Issue with thread over-accumulation when inserting data
- Updated dependent library versions
- Better reporting of errors when inserting with prepared statements.
- Java API dependency version to be 7.0.20.3 and above to take advantage of recent security related fixes.
- Added Procedure metadata
- Server-side inserts do not waste time parsing on the client
SET USERsupport for external users (with leading "@")
- Added
META-INF/services/java.sql.Driver
supportsBatchUpdates()metadata returns true- Trust Store password supports empty environment variable for blank password.
- Added support for multi-line SQL Procedures
- Added
RowsPerInsertionconnection string parameter - Added
\metadataand\versioncommands to kisql
- Removed support for
passwordandtruststorepwdcommand-line parameters (and synonyms) - Use
KI_PWDenvironment variable, and user is prompted ifKI_PWDis not set - Changed
CSVParserto more closely match ODBC features - Updated reported metadata from JDBC Driver
- Updated Java API version dependency to 7.0.15.1.
- Fixed
SslAllowHostMismatchby now using Java API to do this
- Added support for
TimeZoneOverrideoption to JDBC Connection string - Added
--TimeZoneOverrideoption to kisql to pass this to JDBC - Added
--listalltimezonesto kisql to output the valid timezones
- JDBC now returns times in UTC/GMT
- kisql to use the timezone parameter correctly
- Updated the Java API version dependency to 7.0.12.1
- Having a Materialized View under construction will not cause problems when getting metadata about other tables
- KiSQL now returns a linux status code indicating an error, if running SQL from a command-line or file and there is an error
- Support for
CREATE PROCEDURE - Can now specify a URL as the first parameter on the JDBC Connection String
-- Can specify
httporhttps, but these are optional -- Starting with//is optional (whenhttporhttpsare not specified) -- May contain a path after the port, including slashes - Version info now includes API version and KiSQL version
- Documented the
--versionoption in the KiSQL--helptext
- Escape characters specified in
INSERT FROM FILEparameters - Inserting into a result table
- Insert was under reporting number of added rows, when the insert took multiple batches
- Fix for inserting NULL as blank string in CSV for DECIMAL, DATE, DATETIME, TIME, IPV4 and ULONG columns
- Minor KISQL command-line parameter parsing fixes
- Added support for
getPrimaryKeys()andgetIndexInfo - Enhanced support for INSERT from FILE:
-- Support globs to read from multiple files
-- Support default separator from file extension (
.psv=|,tsv=\t, else,) -- Support for comments in file -- Support for specifying the string to use for NULL -- Option to clear table before inserting -- Option to skip the first N rows -- Option to limit number rows to insert -- Support for specifying the quote character -- Support for specifying the escape character -- Support error handling modes: Skip, Permissive and Abort -- Syntax: INSERT INTO employee SELECT * FROM FILE.”” {[DELIMITER=’’] [COMMENT=’’] [SKIP=] [LIMIT=] [INITIAL_CLEAR] [QUOTE=’’] [BATCH_SIZE=] [HEADER={Yes|No}] [ESCAPE=’’] [NULL=’’] [ON_ERROR={Permissive|Skip|Abort}]}*
- Add support for
SETUSERand related commands.
- Support for specifying columns for both table and CSV file in INSERT command. -- E.g., INSERT INTO t(col1, col2) SELECT col3, col4 FROM FILE."/tmp/table.csv";
- Added DELIMITER support to CSV INSERT command. -- E.g., INSERT INTO t SELECT * FROM FILE."/tmp/table.csv" DELIMITER='\t';
CombinePrepareAndExecutesetting.
- Support for
PrimaryURLin KiSQL and JDBC Driver.
- Always show warnings.
- Updated connection error message (and others) to include more info.
- Changed the dependent Java API to be 7.0.3 to pick up latest changes around high availability failover support.
- Added
LIMITparameter to support limiting the maximum number of rows returned by a query. - Added KISQL
--connectionstringparameter.
- Support for truststore parameter.
- INSERT and Display of BYTE columns with NULL.
- JDBC now returns an error if unable to connect to GPUdb initially.
- KISQL now supports Unix-like parameters with double hyphens.
- KISQL now supports boolean parameters without values (default: true)
- KISQL now formats output with CR/LF better.
- Updated logging
- Support for clearing additional tables related to the paging table.
- Support for Multi-head INSERT.
- Support for INSERT from CSV files.
- Support for Java 7.
- Support for Java 10.
- Version release