rockset-sqlcli 0.8.10
Rockset SQL REPL for `rock sql`
Keywords: Rockset serverless search and analytics

This package includes an interactive SQL REPL that can be invoked by running `rock sql` without any arguments:

- Depends on the main `rockset` module to be already installed.

- `rock-sql` command line utility to interact, manage and operate Rockset from a shell command line.

- Once installed `rock-sql` can also be invoked by simply running `rock sql`.

Rockset documentation is available at:
http://rockset.com/docs


Attribution
===========

The `rock sql` REPL is heavily derived from the https://github.com/dbcli/pgcli project.
Our sincere gratitude and admiration to the authors and contributors of that project.


Release Notes
-------------

.. Add a line for every user-facing feature change
.. rst syntax requires leaving an empty line before and after the sub-bullets

- 0.8.10

    - fix performance issue with fetching large result sets  

- 0.8.3

    - formatter changes 

- 0.8.2-beta.20220218

    - fix bug when processing exception

- 0.8.1-beta.20220111

    - when creating a SourceDynamo object using Source.dynamo() 'use_scan_api'
      will now be set to False by default, making export using S3 the default
      option.

- 0.7.119-beta.20211216

    - fix collection add_docs bug when referencing a workspace

- 0.7.117-beta.20211124

    - support Date parameters in queries

- 0.7.116-beta.20211015

    - support Dynamo v2 integration

- 0.7.105-beta.20210915

    - support Kafka v3 integration

- 0.7.104-beta.20210904

    - support python 3.8+

- 0.7.93-beta.20210625

    - support aws_region parameter in kinesis source

- 0.7.92-beta.20210622

    - support dms related parameters in kinesis source

- 0.7.89-beta.20210617

    - support aws_region parameter in dynamo integration

- 0.7.86-beta.20210519

    - support (add|patch|remove)_docs of type rockset.document.Document
    - bug fix for timeout parameter to be used for sql() methods.

- 0.7.68-beta.20210211

    - rename field_partitions to clustering_key

- 0.7.54-beta.20201216

    - support creating collections with field partitions

- 0.7.49-beta.20201117

    - add basic support for aliases

- 0.7.42-beta.20201014

    - fixes bug regarding collection object mutability

- 0.7.18-beta.20200724

    - add support for editing collections without first calling retrieve

- 0.7.12-beta.20200519

    - update version type for Query Lambdas

- 0.7.6-beta.20200422

    - add MongoDB support for the rock CLI

- 0.7.5-beta.20200421

    - add support for creating MongoDB collections and integrations

- 0.6.35-beta.20200303

    - add additional support for Query Lambdas and update client models

- 0.6.33-beta.20200131

    - add basic support for Query Lambdas

- 0.6.32-beta.20200116

    - fix query builder to support workspaces correctly

- 0.6.24-beta.20191202

    - map Rockset DATE, TIME, DATETIME, TIMESTAMP and MICROSECOND INTERVAL data types to Python's corresponding datetime types.
    - add patch_docs() API to collections to update any documents in a collection atomically without having to reingest the entire document.
    - improved SQLAlchemy support
    - improved support for Apache Superset

- 0.6.17-beta.20191026

    - fix bug: do not automatically check for updates in rockset.version()

- 0.6.16-beta.20191013

    - moved `rock sql` interactive REPL to a new Python package rockset_sqlcli

- 0.6.0-beta.20190617

    - move from cloud-level integrations to service-level integrations: DynamoDB, GCS, Kinesis, Redshift, S3

- 0.5.33-beta.20190530

    - fixed Windows environment issue

- 0.5.30-beta.20190517

    - add support for AWS Redshift
    - `rock upload` supports uploading multiple files

- 0.5.23-beta.20190225

    - `rock ls` shows creation time and size of collection
    - Better error handling
    - Add support for Workspaces

- 0.5.15-beta.20190124

    - Update User-Agent value passed in API request header

- 0.5.14-beta.20190121

    - Add support for Google Cloud Storage

- 0.5.13-beta.20190117

    - SQLAlchemy enhancements to support Apache Superset

- 0.5.10-beta.20190114

    - Added support for AWS External ID as a new type of integration.
    - Added support for `prefix` and `pattern` as parameters under rs.Source.s3()
    - Deprecated rs.Source.s3(...prefixes=[...]). This is still supported but it's recommended that you move to using `prefix` as soon as possible.
    - Fixed bug in `rock upload` to use current working directory.

- 0.5.9-beta.20190104

    - Add support for Amazon DynamoDB data source
    - Replace `rock add` with `rock upload`

- 0.5.6-beta.20181210

    - Support for creating collections from XML data files

- 0.5.0-beta.20181107

    - First beta release
    - Add support for kinesis data source
    - Better error messages when an account reaches resource limit
    - REST API over swagger_client instead of bravado

- 0.4.3-alpha.20181003-3eaa5c7cc7

    - Support for field masks.
    - Support for slow rollout of leaves based on healthz checks

- 0.4.3-alpha.20180916+57afbae46a

    - Support for creating collections from csv data files

- 0.4.2-alpha.20180910+cf9c623a49

    - Support for creating collections using integrations
    - Improved help text for rock create workflows

- 0.4.1-alpha.20180822+e806a29bab

    - Support for event time data and data retention during collection creation.
    - Changes to `rock create collection ...` commandline to improve readability
    - `rock drop ...` is now `rock drop collection ...`
    - `rock describe ...` is now `rock describe collection ...`

- 0.4.0-alpha.20180515+ecbe2a0

    - Moved to new /org/{org} REST API
    - Add SQL support that is accessible from `rock sql`
    - Field `_id` defines the unique identified for a document (`:id` deprecated)
    - Field `_meta` captures all other system generated fields in documents (`:collection` etc deprecated)

- 0.3.0-alpha.20180314+410b55e

    - Add py query builder support for <, <=, > and >= operators for string values

- v0.3.0-alpha.20180206+168be7d

    - Add ``F.collect()`` support to accumulate entire parent documents as part of a bucket aggregation

- v0.3.0-alpha.20171206+7debcb7

    - Add ``collect`` aggregate function to support bucket aggregations
    - Add support for ``F.count()`` to do equivalent of count(*)

- v0.3.0-alpha.20171121+d8c7961

    - Sensitive fields can now be masked or anonymized, when collections are created from AWS S3. See ``rock help create collection`` for more details.
    - AWS S3 bucket path prefixes can be provided to create a collection from only a subset of data in an AWS S3 bucket.
    - Support Parquet file format for loading data into collections.

- v0.3.0-alpha.20170919+49e62f5

    - Simpler REST API 0.3
    - Add fence API and write APIs returning commit markers
    - Add View creation progress indicator to describe view API
    - More user-friendly error messages and Python exception strings
    - Enforce and document various system-wide limits

- v0.2.2-alpha.20170824+dff8385

    - Support for next version of api_key and got rid of api_secrets
    - Added support for adding multiple documents in single API call
    - Added rockset.source to better support managing S3 sources while creating collections and collection sources while creating views.
    - Better client support for views with multiple analyzer mappings
    - py/client supports async_requests to have multiple concurrent queries pending
    - Support for sampling queries and queries on nested documents
    - Backend: better query optimization support

- v0.2.1-alpha.20170707+88ab952

    - Added support for views

- v0.2.1-alpha.20170629+4492c9a

    - py/client now respects HTTP_PROXY and HTTPS_PROXY ENV variables

- v0.2.1-alpha.20170629+7b050f5

    - Fix bug that made limit queries not composable

- v0.2.1-alpha.20170628+303f256

    - Added cursors with automatic pagination support
    - Added support for limit & skip queries

- v0.2.1-alpha.20170624+e6aee25

    - Added support for lookup operator for JOINs
    - Auth token auto refresh will support long lived Client() objects

- v0.2.1-alpha.20170615+f3df06e

    - Parallel aggregations for faster performance
    - Aggregation support for nested fields
    - Aggregation support over large data sets
    - Rewrote backend service discovery to make it elastic
    - User friendly messages for all py/client exceptions

- v0.1.1-alpha

    - First alpha release