Skip to content

Releases: NLPchina/elasticsearch-sql

Scripts ,ReverseNested CSVs and more!

30 Dec 23:02
Compare
Choose a tag to compare

New:

  • #120 new hint to ignore unavailable indices . wiki
  • reverse_nested aggregation support! wiki
  • script filter support wiki
  • #127 literals within brackets.
  • #114 experimental feature CSV support on rest api wiki

Enhancements:

  • terms aggregation - more parameters support

Breaking Changes:

  • #126 no more docs return on aggregations - if you want to preserve this feature - there is a hint for that. wiki

Elastic 2.1.0 Support!

28 Nov 16:08
Compare
Choose a tag to compare

All the features from 2.0.2
But with Elastic 2.1.0 support! #119

NestedTypes support

28 Nov 16:06
Compare
Choose a tag to compare

New:

  • Nested types support: read about it on our wiki
  • Filter aggregation support

Enhancments:

  • Scroll & order by combination are allowed now!
  • Join &order by queries on first table are working also!
  • Site - when clicking explain - remove results.

Fixes:

  • double nots - #109

NestedTypes support

28 Nov 16:00
Compare
Choose a tag to compare

New:

  • Nested types support: read about it on our wiki
  • Filter aggregation support

Enhancments:

  • Scroll & order by combination are allowed now!
  • Join &order by queries on first table are working also!
  • Site - when clicking explain - remove results.

New Site Version

08 Nov 22:35
Compare
Choose a tag to compare

New:

  • Site:
    • scrolling was never easier! read here
    • able to select command and run only it
    • being able to save settings (using localStorage)
    • It looks better now :)

New Site version + Join enhancments

08 Nov 22:33
Compare
Choose a tag to compare

New:

  • Site:
    • scrolling was never easier! read here
    • able to select command and run only it
    • being able to save settings (using localStorage)
    • It looks better now :)
  • Join - improvement on join connected conditions:
    • HashJoin Implementation when using OR and all EQUALS
    • Any condition on connected condition when using NestedLoops
  • scripted_metric parameters support (using '@x'=value will give you accesses to parameter x on your script)

Fixes:

  • Site - table presenter bug on ordering . #108

Elastic 2.0.0 support

06 Nov 22:54
Compare
Choose a tag to compare

Important:

  • Only install it with elastic 2.0 version #105 , #106
  • Does NOT support DELETE commands. read here

New:

  • improvement on join connected conditions:
  • HashJoin Implementation when using OR and all EQUALS
  • Any condition on connected condition when using NestedLoops

Fixes:

  • Site - table presenter bug on ordering . #108

Scripting + New Site Features

30 Oct 21:13
Compare
Choose a tag to compare

New:

  • Scripting is now possible! you can manipulate data on search! read about it here
  • scripted_metric aggregation is available also, read about it here
  • Site - new Table you can search and sort after fetching!
  • Site - you can flat the results from elastic and auto download results
  • Site - when using scroll and auto download it will fetch until finish and direct download the csv

Fixes:

  • correct ordering on aggregation #103
  • on date_histogram aggregations on site - now shows key_as_string for bulks (date value and not integer)
  • show command for type with more than 2 hierarchy
  • inner queries on join

Enhancements:

  • when using /*! USE_SCROLL */ hint, defaults to 50 docs per shard instead of 1000.before

Show Commands and Multiple aggregations

17 Oct 06:04
Compare
Choose a tag to compare
  1. New:
    • #99 - multiple aggregations
    • #33 - show commands , read about it here
    • #100 - supports min and max on date field on web interface
  2. Fixes:
    • #101 - delete command
    • #102 - 'NOT' bug fix
    • bug fix on aggregations on fields starting with '@'

New Aggregations

06 Oct 18:18
Compare
Choose a tag to compare
  • percentiles aggregation support
  • extended_stats aggregation support
  • web interface support for extended_stats, percentiles and stat aggregations