jsoniq 2.0.2 "Lemon Ironwood" beta

• Add MongoDB connection (mongodb-collection()). Requires including .withMongo() when creating the RumbleSession.

jsoniq 2.0.1 "Lemon Ironwood" beta

• Works with Spark 4.0.1.
• Add postgreSQL connection (postgresql-table()).

jsoniq 2.0.0 "Lemon Ironwood" beta

Official release aligned on the brand new RumbleDB 2.0 release.

• Improved display of pandas dataframes output with -pdf in Jupyter notebooks.
• if error info is activated in the configuration, then they are now printed in the notebook.
• JSON nulls are now by default conflated with absent upon validating for dataframe output, this can be deactivated in the configuration.
• The materialization error upon df/pdf output is now fixed.

jsoniq 2.0.0 alpha 1

• When returning a single-column DataFrame with atomic values, the name is now __value and not value to avoid collisions with user-defined columns.
• Improved schema inferrence: DataFrames can be returned in a wider range of cases.
• Improved error display in notebooks when errors happen upon collecting the results and not already upon calling jsoniq().

jsoniq 0.2.0 alpha 9

• Stability improvements.

jsoniq 0.2.0 alpha 8

• Variables can now be bound to JSON values, pandas DataFrames or pyspark DataFrames with extra parameters to the rumble.jsoniq() call. It is no longer necessary to explicitly call bind(). This is similar to how DataFrames can be attached to views with extra parameters to spark.sql().
• rumble.lastResult is now correctly assigned also when partial data is returned (only with the partial data).
• Fixed issue with empty array constructors.

jsoniq 0.2.0 alpha 7

• rumble.lastResult now returns a pyspark/pandas DataFrame or rdd or tuple and no longer the sequence object.
• Enhance schema detection. When the detected static type of the overall query is DataFrame-compatible, it is now automatically possible to obtain the output as a DataFrame without explicitly giving a schema.
• It is now possible to access a table previously registered as a view via a table() function call. This is an alternative to binding variables.
• Enhancements in the JSONiq Update Facility support to update delta files and Hive metastore tables.

jsoniq 0.2.0 alpha 6

• Fix a bug with the config() call of the builder.
• add withDelta() to configure Delta Lake tables and files, for use with the JSONiq Update Facility.

jsoniq 0.2.0 alpha 5

• If the initialization of the Spark session fails, we now check if SPARK_HOME is set and if it may be invalid or pointing to a different Spark version than 4.0, and output a more informative error message.

jsoniq 0.2.0 alpha 4

• Added parameters to the jsoniq magic to select the desired output to print: -j, -df, -pdf
• Added informative error message with a hint on how to fix when trying to get a DataFrame and there is no schema.
• Added parameter -t to the jsoniq magic to measure the response time
• The RumbleSession object now saves the latest result (sequence of items) in a field called lastResult. This is particularly useful in notebooks for post-processing a result in Python after obtained it through the jsoniq magic.
• Improved static type detection upon binding a pandas or pyspark DataFrame as an input variable to a JSONiq queries.
• Now also accepts pandas version 2.2.