New Site version + Join enhancments

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

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

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

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

• percentiles aggregation support
• extended_stats aggregation support
• web interface support for extended_stats, percentiles and stat aggregations

bugfixes - dots and newLine support

• new line support after select
• dots are allowed on indexname

Sub Queries (inner queries) and more

• Enhanced NOT functionality
• Bucket Aggregation alias support
• terms and term filter/query support
• ids query/filter support
• SubQueries support (works on IN , TERMS , IDS)

Limited Join support and more features

• Join between two indices!
• Scroll on single index
• Not Like
• Enable "@" ":" and space on fields name

Elasticsearch-SQL

Add ES geographic support

Elasticsearch-SQL

1.3.4

Merge branch 'add-elastic1.6-support'