- Worked around an issue with Webpack and Angular 1.8.x that caused the Admin UI to not load correctly.
- Maintenance release, after updating a few runtime and build-time dependencies.
- Fixed minor grammar issue on the Spanish version of the Help page. Thanks, @hlcianfagna.
- Optimized images with
oxipng
. Thanks, @matkuliak. - Updated build-time dependencies.
- Copy-edited a few texts on the "Help" page
- Removed a superfluous whitespace shown for CrateDB snapshot versions
- Update versions of engine.io, socket.io, and socket.io-parser.
- Fixed monitoring statement for compatibility with CrateDB 5.2,
AVG(ended - started)
becomesAVG(ended::bigint - started::bigint)
.
- Added new keywords for functions added in CrateDB 5.2
- Maintenance release with dependency package updates, and updated toolchain.
- Added Italian translation.
- Updated a few dependency packages with critical updates.
- Fixed formatting of
TIMESTAMP WITHOUT TIME ZONE
values in query console result table.
- Console: Query results now fit within the view port, to make it easier to work with wide result sets.
- Updated a few JavaScript dependencies
- Fixed an issue at the views tab where selecting a concrete view immediately resulted in jumping back to the first view at the list.
- Updated web fonts (removed Open Sans & SourceCodePro, added Inter & Roboto Mono)
- Adjusted link colors
- Update static assets with new colors and logo
- Added various keywords and data types to console highlighting.
- Fixed issues with release 1.20.1.
- Fixed duplicate entries in query history.
- Side-Navigation: Adjusted size slightly, added hover-effect on selected item, added border on active item and fixed monitoring icon
- Move Monitoring to Overview and remove dedicated section. Monitoring now always shows last 15 minutes of QPS and query duration in 10 sec intervals. Slightly adjusted appearance of graphs.
- Fix: Added ability to correctly display nested arrays in OBJECT(IGNORED) columns
- Use correct binary prefixes (e.g. KiB, MiB, GiB) for units of data in UI. No change in calculation.
- Fix generated queries for views containing identifiers that need to be quoted
- Removed all analytics (UDC, Segment)
- Removed the "Notifications" section in the statusbar
- Removed min-width for columns in console to reduce scrolling
- Changed syntax highlighting in console. Keywords in double quotes are now longer highlighted. Types are highlighted with a different color.
- Activated codemirror code hints for keywords.
- Changed the look of the Scrollbar to appear more modern.
- Added length limit for
varchar(n)
andbit(n)
types in table view.
- Removed misguided redirects which may lose queries currently being typed.
- Made language selection sticky.
- Fixed translations. French now works again.
- Fixed missing whitespace.
- Improved usability of the "Console" page. The "submit query" button is now closer to the query statement.
- Improved translations once more.
- Aligned with license change. Enterprise features are now available to everyone.
- When navigating from table view to console, apply server-side
quote_ident
function to get better usability for column names within the manifested SQL statement. Also, added appropriate newlines.
- Fixed uppercase spelling of 'HTTP Endpoint' in cluster view.
- Removed the Tweet tutorial.
- Added console results formatting for the new Time with timezone data type.
- Fixed an issue where a nested column with a space in it would not be identified as one, resulting in an incorrect query when using the 'Query Table' feature.
- Fixed an issue that prevents the value for nested partitioned columns showing up in the table partitions overview.
- Fixed capitalization of
Shards
tab label - Updated keywords list so that they are recognised and painted in red.
- Upgraded
node-sass
's minor version, which introduces no changes for the end user, but improves maintenance. See release notes here node_sass_release_notes.
- Fixed an issue that caused a
0
value for the partitioned by column of a table to be displayed asNULL
instead. - Fixed an issue that caused the node health to not be displayed in the Cluster View when the node name was too large.
- Fixed an issue that caused the pagination
Previous
button to not display the whole list of results for that page in the Console view.
- Fixed an issue that caused the users list in the privileges tab to not displayed
when the CrateDB Admin UI is not served from
/
. - Fixed an issue that caused the pagination button styling to break.
- Fixed an issue that caused the result table to display incorrect results in certain columns after clicking the pagination buttons.
- Fixed an issue that caused the Twitter tutorial to not start automatically after the login redirect.
- Replaced the Slack icon with Discourse in the help section, updated nametags for all languages and translations for Spanish.
- Fixed the table/column display to no longer display all columns as being generated columns.
- Adapted a query for compatibility with the upcoming CrateDB 4.0 release.
- Adapted a query for compatibility with the upcoming CrateDB 4.0 release. This drops the compatibility with earlier CrateDB versions.
- Updated CrateDB & CrateDB CE logo images.
- Fixed display of unlimited license expiry dates.
- Removed usage of deprecated CrateDB cluster setting
license.enterprise
. Use license information available undersys.cluster.license
instead to distinguish between enterprise and community edition.
- Fixed an issue that caused timestamp to not be formatted correctly.
- Updated the license display to include the maximum number of nodes a license is valid for.
- Fixed an issue that caused the monitoring graph diagrams to be cut off.
- Fixed an issue that caused incorrectness in the navigation icons highlighting.
- Updated the license div to be more responsive
- Changed the license information (ident) to be taken from the sys.cluster.licence attribute instead of the license.ident setting which is @deprecated.
- Addition of French language files and menu options.
- Fixed an issue that caused the cluster and node checks to not be refreshed
when clicking on the
refresh
icon. - Fixed an issue that caused the Twitter importer to redirect to
/
instead of/help
. - Fixed the navigation component to allow opening URLs in new tabs.
- Fixed an issue where the configuration file for plugins was not loaded when
the UI was served from another location than
/
resulting in a blank browser canvas.
- Fixed an issue that caused the CrateDB process CPU calculation to be false.
- Show column data types in table schema in upper case.
- Fixed interface glitches that occurred on table tab when the last table was dropped.
- Added a new tab for views which lists available views and their properties.
- Updated
information_schema.tables
queries to return only tables, but not views, in order to be compatible with future versions of CrateDB.
- Fixed several bugs concerning filtering tables/views where table information would not be updated properly. Also fixed the clear filter button for both table and view filtering.
- Removed abbreviations in the overview and table view. Updated nodes view.
- Remove trailing space from column name in tables detail view.
- Adapted queries to be compatible with CrateDB 3.0+
- Fixed handling of
null
values correctly in Cluster Tab of the Admin UI.- Updated the
Size
label in the table detail toSize (Sum of primary shards)
- Updated the link to the stat collection in the monitoring plugin.
- Updated the table list search to filter tables only by table name and table schema.
- Fixed an issue that caused the table list to display wrong results.
- Fix an issue that caused the translation strings to not be loaded correctly.
- Fix an issue that caused the
Cluster
tab to not be loaded correctly.- Map the Tab key to insert spaces instead of a tab character.
- Fixed an issue that caused the user name to not be displayed.
- Updated CPU usage graph to use the value provided by
os['cpu']['used']
. The graph does not show system/user/idle/stolen values any more.
- Remove horizontal scroll from the console editor.
- Console results pagination is reset to 1 after each execution.
- Calculate "idle" process CPU usage correctly and show it in the "CrateDB CPU Usage" graph.
- Fixed an issue that caused the Admin UI to not display any tables when the file system data are not fetchable.
- Refresh Cluster Info after query execution in the console, to ensure that the cluster info is always up to date.
- The download url now links to the stable CrateDB version.
- Replicates shards in the
Unassigned
row of the Shards view are now grouped by id.- Fixed issue that caused closed partitions to show a
CRITICAL
data state.
- Remove horizontal scroll from the console editor.
- show all nodes in admin ui shard view, even those which have no shards.
- Fixed an issue that cause the statusbar to show an error if the user has an adblocker enabled.
- Fixed an issue that caused extra spaces to be added to the formatted console results.
- Fixed an issue that caused
NULL
generated column values not to be displayed in the tables view.- Show messages when in the Tables view when the table list is empty.
- Fixed an issue that delayed the overview chart's initial display.
- Fixed issue that caused the redirect to
/401
in case of unauthorized access to fail.- Fixed casting issue in the Monitoring query.
- Fixed issue that caused the cluster view to not redirect to the first node by default.
- Added pagination to Console results.
- Keep input of console when changing tabs.
- Added focus on textbox when the console view is loaded and after clicking on the Execute Query button.
- Shard and node details are now loaded on demand in the shards view.
- Fixed issue that caused the cluster check display to be delayed.
- Fix formating of strings in the console view.
- Update position of the navigation menu elements.
- Fixed left Join condition in shards query that previously caused duplicated shards to be displayed.
- Added loading indicator in shards view.
- Do not automatically execute the query when clicking on the "Query Table" button in the table view.
- Improve shards view performance
- Remove horizontal scroll from the console editor.
- Fixed an issue that caused the tooltip to have a wrong position in the Shards view.
- Added Shards plugin (Enterprise Feature). The shard plugin is a visualization that displays information about shards by table, partition and node.
- Added query table to Tables view.
- Implemented share query feature in the Console.
- Show generation expression for generated columns in Tables view.
- Added the row count number to the query status in the Console view.
- Fixed issue that caused the privileges view to not be scrollable.
- Fixed typo in privileges view.
- Fixed empty
account_user
-column in twitter tutorial plugin.
- Fixed issue that caused the Monitoring tab to redirect to
/401
when the user didn't have privileges forsys.cluster
orsys.jobs_log
.
- Added Privileges plugin (Enterprise Feature)
- The documentation link now points to the documentation for the major.minor (e.g. 2.1) version of CrateDB, instead of major.minor.hotfix (e.g. 2.1.1).
- Fix Tweet import for Twitter tutorial page
- Add
DENY
keyword to the console autocapitalization.- Display error message on the Tutorial plugin when the SQL query fails.
- Fixed the SQL query in the Tutorial plugin.
- Fix timestamp formatting in the console results.
- Display user name in the status bar when the Enterprise Edition is enabled.
- Cluster warning within the monitoring plugin, regarding stat collection being disabled, has been improved.
- Redirect to /401 when the admin-ui user does not have cluster privileges.
- Expanded the list of keywords used by autocapitalization.
- Fix toggle buttons UI, which was broken while zooming.
- Change color of keywords in the console to be more readable.
- Display long table names correctly.
- Licence ident wording has been corrected.
- Enterprise license ident is now displayed.
- Fixed
y-axis
number formating for long running queries in the monitoring plugin.
- Added
ms
to monitoring graph title.- Fixed issue where arrays in formatted objects were not displayed.
- Removed blog feed from side bar.
- Increase base font size.
- Fixed issue that caused tables to display a healthy status even though their partitions were in critical state
- Added fallback to unformatted results if no column types are returned.
- Display notification warning only when a new CrateDB version is released.
- Added
lineWrapping
option to console Editor.- Fixed issue that cause the console text to appear on top of the settings tab.
- Fixed load reading display when the readings were invalid (for example, on Windows).
- Added monitoring plugin (Enterprise Feature).
- Added Lazy loading of the stylesheet and plugins depending on the enterprise settings.
- Added buttons to collapse and expand all schemas in the tables view.
- The console now expands vertically to show the whole query if its size is larger than the standard size of the console.
- SQL console keywords are now CrateDB specific.
- Improved formatted results of the
geo_area
datatype to include an external link to a visualisation of thatgeo_area
.- Keywords in the SQL console are capitalised.
- Added node number to the status bar.
- Fixed issue that caused
Cluster Offline
message to not be displayed.- Fixed a console results issue that caused the results table not to be visible after horizontal scrolling.
- Fixed styling issue that caused the last element in the side bar list to be hidden.
- Fixed an issue that caused the notification date to be
null
in Safari.
- Fixed a console results issue that caused the results table not to be displayed after horizontal scrolling.
- Fixed an issue that caused the Admin UI to load only one plugin.
- Display warning in the console view when the query result contains an unsafe integer.
- Relocated the help resources section to be underneath the tweet import tutorial.
- Show loading indicator when
Execute Query
is in progress.
- BREAKING: Updated the admin UI build to be compatible with future crate versions which will serve the admin-ui from root /.
- Improved console results table, including data type based colorization, alternating row colorization, structured object/array formatting, human-readable timestamps, Google Maps link on geo-point results & lazy loading on result sets larger than 100 rows.
- Fixed getting started display issue on very wide screens.
- Added compatibility with future crate versions which will serve the admin-ui from /admin/ instead of /_plugins/crate-admin/.
- Removed pepper widget, support links are now in a Help section along width the Get Started tutorial.
- Changed read notification behaviour so that all items are marked as read upon opening the settings.
- Lowered opacity of placeholder query in the console.
- Fix intercom support that disappeared during the implementation of the new admin-ui layout.
- Fix Radio button position in load overview.
- Made schema tabs more distinguishable from tables in the table list.
- Updated link to support website in contact widget.
- Fixed an issue that caused incorrect URL paths if the project gets built.
- Implemented new layout for the admin-ui.
- Local development: do not store
base_uri
permanently in localStorage but keep it in URL.- Added Pepper contact widget which displays various Crate.IO support Channels in a user friendly way.
- The first node in the node list is selected by default.
- The first table in the table list is selected by default.
- Developer news from crate.io website are now loaded correctly into newsfeed.
- fixed bug that caused the cluster REST URL link in nodes view page to be unsafe.
- fixed incorrect sql query for creating the tweets table in the tutorial.
- Fix : Corrected the sql queries to display the table list in the tables view.
- Corrected the sql query in the tutorial to fix the error that occured when tweets table was already created.
- Added a button to clear the search field in the table list view.
- Added Spanish translation.
- Fix: removed chinese language from i18n configuration.
- Fix: added english as a fallback language for translation files.
- Fixed broken execute button in the console view.
- Fix : Reduced the amount of log output to browser console when issuing SQL statements.
- Fixed hyperlink on logo in navigation bar which incorreclty pointed to the Crate HTTP root.
- Fixed the chart error that occured when navigating between the overview and other pages.
- Fixed the logo URL which was not redirecting correctly.
- Fixed an issue that caused the query history in the console view to be inconsistent.
- Added a new console option to allow users to display the error trace when an error occurs.
- Added translation for tutorial plugin. This enables support for i18n for any admin ui plugin.
- Fix: number of underreplicated shards cannot be negative.
- Fix: fixed menu order.
- Display failing node checks on overview page and allow to dismiss them.
- Added German translation. This change also enables the possibility for further i18n.
- Resolve path to
/_sql
endpoint correctly when Crate is served at a different location than/
- Cluster check include now clickable links
- Load additional links in menu dynamically from news feed
- Fixed an issue which caused rendering errors in the node list if the cluster contains multiple nodes with the same name note: changes the url to the detail view of single nodes
- Added UTM tokens to links that link to the Crate.IO blog
- Updated news feed URL
- Label the master node in the cluster node list
- Fix: updated BlenderPro webfont This fixes CSS glitches in Firefox 44 which misinterpreted height of webfont.
- Fix: The recent update of the shard calculation for relocating shards caused problems with partitioned tables showing incorrect table health.
- Fix: Reading an undefined property while cluster is offline caused Javascript error.
- Fix: Rename cluster check indicator on statusbar to
Checks
.- Improved display of recovery percentage in table view
- Fix: relocating shards where previously displayed as "underreplicated" shards causing a yellow cluster state while relocating was in progress
- Fix: change in calculation of recovery percentage broke calculations for partitioned tables causing table partitions not showing up
- Fix: now also include unassigned shards (as 0% recovered) in calculation of recovery percentage which is displayed per table. Previously it could show '100% recovery done' even if there were still unassigned shards.
- Display current shard recovery status on table info page. It shows the percentage of done recovery.
- Updated calculation of underreplicated shards/records to work with the change in Crate server where shards in sys.shards table have a more fine granular state now and relocating shards are listed, too.
- fix: Unavailable dependency angular-truncate module caused blank Admin UI. Switched to angular-truncate-2 now.
- fix: column headers where not shown in result table on console page when two or more columns with the same name were selected
- The table list is now fully searchable and sorted by table name within its schemas.
- fix: charts are not correctly displayed in Microsoft Edge browser.
- UDC: identify anonymous user with cluster id. Both user id and cluster id are anonymous traits. Note: You can disable UDC via the udc.enabled setting on the Crate server.
- fix: REPLICATED DATA at the overview page showed incorrect percentage of of replicated data when number of undereplicated records was higher than number of total records
- fixed a bug that displays partitions that are not related to the selected table in the table-list.
- fixed a bug where cluster shows wrong state if the number of nodes gets smaller than the minimum master nodes.
- fixed a visual bug that let an item in the node/table list partly disappear if scrolling gets enabled
- fixed URL to download in dropdown that notifies about old Crate version
- fixed a bug that displays a zero value as NULL value
- display cluster checks on overview page
- display relative Crate process CPU usage as bar chart and show number of cores per node
- display
NULL
instead of empty cell in console results table
- updated Intercom to support new messaging features. The Intercom service is disabled if UDC is disabled on the Crate server.
- fixed line wrapping in console result table
- added support for line breaks in console result table
- fix: number of underreplicated shards were fetched and displayed incorrectly
- load plugins.json that can inject additional modules on app start the "Get Started" tutorial is now implemented as a plugin
- fix: approximate number of underreplicated and missing records per table was calculated incorrectly, which could have lead to different results when viewing table info on admin ui of different nodes
- fix: automatically refresh load history chart on overview page
- improved layout for smaller screens
- fix: highlight cluster navigation item also when node is selected
- fix: crate process cpu will now also display values greater than 100%
- fix: load graph was not displayed when no tables where available
- improved load graph on overview page
- display load, cpu usage, disk i/o, process stats and shard information on node detail page
- added columns with partition values on "Partitions" table on table detail view
- update logo, favicons
- display
rest_url
from sys.nodes table on node detail view
- fix: concurrent ajax requests caused partition information in table detail view to be mixed up between tables
- fix: calculate health for each partition of a partitioned table based on the number of shards of that partition
- fixed bug that showed custom schemas in the table list as often as the amount of tables in that custom schema
- removed usage of sys expressions in wrong context
- fixed a template rendering issue in cluster view in Safari
- de-register watches to decrease DOM updates and improve performance in cluster view
- fixed title of tables view if no tables exists or connection is down
- add support for tables with user defined schemas
- added Intercom integration
- Intercom allows you to ask questions and send messages to the Crate team directly from the admin interface. Click on the help button in the menu bar to enable personal support. Click on the icon in the bottom right corner to start writing your questions!
- fixed issue that caused clunky scrolling with trackpad in Safari that mainly occured when having a narrow browser width
- made console placeholder text darker so you can distinguish better between placeholder text and actually written statement
- fixed 'Execute Query' button in console view
- added hint to console: press shift+enter to submit query
- fix: UI showed partitions from wrong table after switching between tables this could also lead to 'red' partitions if the newly selected table also had partitions
- added syntax highlighting to sql console
- send cookies with cross-origin requests
- fix: display number of records and started shards correctly if table and blob table have the same name
- fix: do not append limit to insert by query statement
- use new sys.nodes.fs expression in order to calculate disk utilization of data disks correctly
- changed font in console for better readability
- fixed ui glitch that caused right column content to be cut off
- fix: include initializing shards in calculation for underreplicated shards
- fix: ui showed partitions from previously selected table
- fix: make table list and node list available in mobile view
- fix: round percentage of available and underreplicated data correctly
- make table that displays table partitions horizontally scrollable
- display developer news notifications
- fix: prevent selected node/table item from being out of viewport
- improved handling of error responses from server
- changed doc url to match doc url pattern
- removed docs menu item from sidebar and added link to external docs in statusbar
- make console history persistent by default
- display crate version of each node and show warning if cluster contains multiple versions
- display heap size instead of system memory in node detail view
- fix: make sure twitter import stops when user navigates away from tutorial view
- fix: allow horizontal scrolling in console result table
- fixed broken redirect after twitter authentication in 'get started' section
- force vertical scrollbar to prevent content column from flickering
- support for partitioned tables
- make node list sortable by health and name
- display number of nodes in status bar
- show node version number
- added history support in admin console
- fix: make sure twitter import stops when user navigates away from tutorial view
- fixed broken redirect after twitter authentication in 'get started' section
- fix: scrolling issues with node list/table list
- fix: immediately show node list on browser refresh
- fix: sorting of cluster list
- display blob tables
- fix: prevent logo from overlapping sidebar navigation
- fix: removed horizontal scrollbar in sidebar
- fix: UI glitch: load was off site
- fix: display values at overview if no table exists
- fix: default base_uri is current location
- fixed Angular version
- ported from Backbone to Angular
- show correct cluster status immediately after starting the admin
- compute correct numbers of missing primary shards and unassigned shards
- use sql to query clustername and nodes load
- removed note about yellow warning state in "get started"
- use '0-all' replicas in the twitter getting started tutorial
- Changed docs link to open in the same frame.
- Fix Safari font rendering
- Changed query to fetch table information. Group by wasn't necessary and sum on number_of_replicas won't work in the next crate version as it is changed to a string.
- Fix FF bug related to mixed-content on the tutorial view.
- Do not abort table info fetching when a node goes down and /_sql does not respond.
- Remove obsolete code and refactor ClusterStatus, Overview.
- Filter system tables differently.
- Fix display issues
- Add a "Get started" section that imports tweets
- Fix table ordering
- Insert new TableInfoView items in alphabetic order
- Fix TableInfoView when a displayed table is removed. Show/hide properly "No tables available" when a table is removed
- Handle edge case where there are no tables in overview, table view
- Fix load graph to behave with bootstrap/jQuery
- Allow for multiple views in the content area
- Fix visual glitches for different devices and screen widths
- Show graph of load over time on Overview view
- Handle add/remove events of nodes on the Cluster view
- Handle add/remove events of tables on the TableList view
- Use URL fragments for navigation, disable pushState
- Sort tables and cluster nodes by health then alphabetically
- Update logo
- Refactor top and left navbars
- Cluster list: Stop highlighting node names
- Improved responsive behaviour
- Repaired visual style glitches
- Refresh Table & Cluster views
- Auto select first item in Table and Cluster views
- Refresh Tables & Cluster views
- Display json objects on sql results
- Completed table info view
- Complete cluster view
- fixed error console not reseting on a new query
- fixed visual bug causing table info to not display properly.
- Introduced Tables view
- Introduced Cluster view
- bugfix in release management: create_tag.sh now checks for versions in both, package.json and bower.json.
- fix for overview
- fixed status bar
- bugfix in ./devtools/create_tag.sh
- initial project setup.