Ananas Desktop Versions Save

New Features

• add new workspace setting disableCheckUpdateOnStart to disable the update check when start the app
• add Web API source. Now it is possible to explore, and analyze data from Web API
• add Excel data source.
• add SQL function TO_DATE to convert string type data to date type
• add Pie chart visualization step.
• improve Bar chart visualization step. Support stacked bar chart, horizontal bar chart and vertical bar chart
• add Find project in file explorer option in project selection view to locate project folder
• add new StringMap component for step editor. It allows editor to edit string-string type map
• add new CLI explore command to explore data source
• add new CLI view command to get visualization step result
• add new parameter host to start command to specify the server host
• add new example Temperature Forcast. See ananas-examples
• add new example MySQL. See ananas-examples
• add new example PostgreSQL. See ananas-examples
• add new example Excel. See ananas-examples

Bug fixes / Improvements

• Fix the issue that CLI exits with code 0 when meeting error in some cases
• Fix the issue that CLI start command listens to 0.0.0.0:3003 by default. Now it listen to 127.0.0.1:3003 by default
• Fix derby access issue when run a visualization step from CLI
• Upgrade sparkjava dependency to version 2.9.1
• Fix a issue that keep loading the project that is deleted from disk
• Fix Linux & Window new version update dialog has no acknowledge button issue
• Fix ananas process not being killed when close app on MacOS issue
• Improve postgres schema auto detection
• Improve several error messages
• Improve tests

Release 0.8.2 is a bug fix release

• improve data explore error message, instead of showing null
• fix unsupported date format in CSV return null issue
• rename duplicated CSV columns to avoid conflict
• add 4 separator choices for Local CSV source (semicolon, comma, vertical bar, and tab)
• fix Linux & window version detection issue
• fix an issue that data view query only recognizes uppercase column with the default database

• support concat (union) up-to 5 inputs on one single concat step
• fix Flink concat type not match issue
• change default gcs source and destination download sample size to 0 (no limit)
• improve error message when exploring data source and destination.
• fix the issue that LIMIT clause is ignored in visualization SQL query

Supported Sources

• Local CSV
• Local JSON log
• Google Cloud Storage
• Google BigQuery
• PostgreSQL
• MySQL

Supported Transforms

• SQL transform
• JOIN
• Concat (Union)

Supported Destinations

• Local CSV
• Google Cloud Storage
• Google BigQuery
• PostgreSQL
• MySQL

Supported Visualization

• Bar Chart
• Line Chart
• Big Number

Supported Execution Engine

• Flink
• Spark
• Google Dataflow