forked from crate/crate
-
Notifications
You must be signed in to change notification settings - Fork 0
/
CHANGES.txt
1428 lines (847 loc) · 38.2 KB
/
CHANGES.txt
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
966
967
968
969
970
971
972
973
974
975
976
977
978
979
980
981
982
983
984
985
986
987
988
989
990
991
992
993
994
995
996
997
998
999
1000
======================
Changes for Crate Data
======================
Unreleased
==========
- fix: columns referenced by positional arguments in a ORDER BY or
GROUP BY clause are now validated for their data types.
- fixed wrong geo_point definition in documentation
- added insert by query support
- fix: if partitioned tables exists, information_schema queries did
not work properly
- updated crash to 0.9.13 which includes the following changes
- fix: avoid stripping arbitrative whitespaces from
commands passed via stdin
- fix: with a very large number of shards, queries on ``sys.shards`` could
overflow the threadpools.
- added ``distance`` and ``within`` geo scalar functions
- updated crate-admin to 0.8.4 with includes following changes
- 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
- implemented ``sys.cluster.master_node`` expression.
- it is now possible to use `is null` on columns of any data type.
- fix: creating a table with arrays as primary key now correctly results in an
error as it is not supported.
- added support for ``alter table add column``
2014/06/16 0.39.0
=================
- upgraded elasticsearch to 1.1.2
- implemented `sys.shards.orphan_partition` expression
- updated crate-admin to 0.8.3
- display developer news notifications
- added ``substr`` scalar function
- added the ``sys.jobs``, ``sys.jobs_log``, ``sys.operations`` and
``sys.operations_log`` tables
- implemented ``SET`` and ``RESET`` statements
- implemented ``sys.nodes.thread_pools`` expressions
- implemented ``LIKE`` and ``NOT LIKE`` operators on string arrays and sets.
- improved error messages
- added arithmetic operators
- implemented partition support for ``copy`` statements
- implemented alter table to operate on single partitions
- implemented object and array literals
- changed refresh table for partitioned tables.
- the ordering of null values can now be influenced using the ``NULLS { FIRST
| LAST }`` keywords.
2014/06/16 0.38.6
=================
- fixed an NPE that could occur when retrieving shard stats from a blob table
- updated crate-admin to 0.7.4 which includes following changes:
- fixed ui glitch that caused right column content to be cut off
- 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
2014/06/14 0.38.5
=================
- fix: validation for ``array`` and ``object`` typed partition
columns were broken
- updated crash to 0.9.12 which includes following changes:
- fixed output encoding when LC_CTYPE locale is not UTF-8
- fix: queries for ``_version=0`` have no match and do not execute as
``_version`` can never be ``0``
2014/06/07 0.38.4
=================
- fix: querying ``sys.shards`` could result in an exception if one of the
shards was initializing
- fix: where is null / is not null didn't work correctly on system tables
- fix: log error instead of recurring exception throwing if shard of
orphaned partition is started
- updated crate-admin to 0.7.4 which includes following changes:
- fix: make table list and node list available in mobile view
- fix: in some cases ``format`` function returned bytes instead of string
- fix: columns of type "ip" are now returned in the string representation
instead of the internal long format when returned as part of a group by
query.
2014/06/03 0.38.3
=================
- updated crash to 0.9.10 which includes following changes:
- NULL values are handled correctly
- fix: increased precision of float formatting
- crash renders complex types as json instead of their python representation
- return -1 for rowcount if rowcount is unknown
- fix: `date_trunc` will now accept literals of type long or string and
attempt to convert them to a timestamp.
- fix: ``count(*)`` on a table which has unavailable records will now result
in a failure instead of returning only the available records
- fix: insert statements with a large number of multi-values didn't insert all
rows if the internal threading queues run full.
- fix: display nested columns correctly in ``information_schema.table_partitions.values``
- fix: id generation on import via `COPY FROM` were wrong if multiple
primary key constraints and clustered-by were used.
WARNING: records must be re-imported otherwise queries with filter
on primary key columns will not match any record
2014/05/23 0.38.2
=================
- updated crash to 0.9.7 which includes following changes:
- return exit code 1 if the execution of a single command fails
2014/05/23 0.38.1
2014/05/23 0.37.5
=================
- fix: fixed schema update issues with partitioned tables.
- fix: DELETE on an empty partitioned table caused an error.
- fix: ORDER BY/GROUP BY clauses with ordinal numbers now work correctly
- fixed the glob pattern matching for S3 imports using the ``COPY FROM``
statement.
- fix: creating tables with nested primary keys and nested partitioned by columns
did not work correctly
- fix: insert and update partitioned tables with nested partition columns did not work
- fix: dynamic columns of partitioned tables did not show up in ``information_schema.columns``
when only one partition existed
2014/05/20 0.37.4
=================
- updated crash to 0.9.6 which includes the following changes:
- crash exited immediately with an exception if a query result
contained an object or array
- the size of the history file is now limited to 10000 lines
- stdin is no longer read completely into memory
2014/05/19 0.38.0
=================
- fix: default settings of crate client have been applied incorrect
- added support for select statements on blob tables. This can be used to list
the blobs that are stored inside a blob table.
- removed developer and installation instructions from documentation
- added the ``geo_point`` type.
- the data type of every responded column can now be returned via
REST using the optional parameter ``types`` or via transport by
defining it at the ``SQLRequest`` object
- improved building of client jar, also added maven upload task
2014/05/19 0.37.3
=================
- updated crate-admin version to 0.7.3 including following changes:
- fix: prevent selected node/table item from being out of viewport
- document data aggregation behaviour on fields in columns with disabled
indexing.
- updated crash to 0.9.5 which includes the following change:
- SQL statements passed in via the --command switch take precedence over stdin
- the ``CREATE TABLE`` statement now doesn't silently ignore analyzer
specifications on column types that don't support them.
2014/05/16 0.37.2
=================
- fix: allow aliased subscript expressions
- fix: allow single character blob table names
- fix: ``count(*)`` on empty partitioned tables threw a TableUnknownException.
- S3 authentication using ENV variables now also defaults to HTTP in order to
avoid certificate issues.
- updated crash version to 0.9.4 including following changes:
- updated crate-python to 0.10.0
- fix: crash exited immediately with an exception if a query result
contained two or more equal field names
- fix: if crash was started while one of the specified hosts was
not available crash exited immediately
- updated crate-admin version to 0.7.2 including following changes:
- improved handling of error responses from server
2014/05/09 0.37.1
2014/05/09 0.36.5
=================
- fix: raise an error if same column is defined more than once on
table creation
2014/05/08 0.37.0
=================
- documentation is no longer included in the distribution but available online only
- refactored exceptions, ``SQLActionException`` is now the only one thrown
via transport + REST
- forbid querying arrays inside object arrays in where clause or as select column
- increase debug output to show SQLRequests and errors in server log
- aliases for tables in SELECT, UPDATE, and DELETE clauses are now supported.
- renamed ``ANY`` aggregation function to ``ARBITRARY``
- implemented ``ANY`` / ``SOME`` operator for array containment checks
2014/05/12 0.36.6
=================
- improved error reporting for COPY operations using Amazon S3
2014/05/09 0.36.5
=================
- fix: raise an error if same column is defined more than once on
table creation
2014/05/07 0.36.4
=================
- fix: forbid order by on compound types (array, set, object)
- fix: transport serialization of set columns did not work correctly
2014/05/05 0.36.3
=================
- fix: date range queries (``WHERE ts > '1970-02-01'``) were misinterpreted
2014/04/29 0.36.2
=================
- updated crate-admin to 0.6.3 which includes the following fixes:
- 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
- feature: implemented version in sys.nodes
- fix: the version check for update statements that contain a ``_version``
column in the where clause is now atomic.
- minor documentation improvements
2014/04/24 0.36.1
=================
- fix: throw appropriate exceptions when using unsupported expressions
2014/04/22 0.36.0
=================
- feature: updated crash to 0.9.0 which now uses urllib3 instead of requests.
- fix: updated crate-admin to 0.6.1 to prevent display glitches
- feature: implemented partitioned tables
- feature: added table 'information_schema.table_partitions'
- feature: added column 'partitioned_by' to table 'information_schema.tables'
- feature: added s3 support for COPY TO
- feature: It is now possible to specify the columns that should be exported
when using the COPY TO statement.
- feature: added the ``DIRECTORY`` keyword to COPY TO
- feature: added sys.nodes.heap expression
- upgraded to ES 1.1.0
- fix: elect one shard as primary shard for unassigned shards
- fix: Items of string arrays now get transformed to strings
- fix: updated crate-theme to 0.0.15 to fix documentation link in the admin-ui
2014/04/30 0.35.8
=================
- fix: upgrade crate-admin to hotfix release 0.5.3
- fix: the version check for update statements that contain a ``_version``
column in the where clause is now atomic.
2014/04/24 0.35.7
=================
- fix: throw appropriate exceptions when using unsupported expressions
2014/04/22 0.35.6
=================
- fix: queries like "select sys.nodes.name, * from sys.shards" now also work
correctly if there are unassigned shards
2014/04/14 0.35.5
=================
- updated crate-admin to hotfix release 0.5.2
- fix: it is not possible anymore to create a (blob) table with number of
shards smaller than 1.
- fix: all unassigned shards are now considered in ``sys.shards`` table
- updated crate-theme to 0.0.15 to fix documentation link in the admin-ui
2014/04/10 0.35.4
=================
- fixed a serialization error that occured if COUNT(distinct <col>) was used
on a column of type LONG
- fixed a NPE that could occur using COPY FROM
2014/04/08 0.35.3
=================
- downgraded crate-theme to fix a doc rendering bug
2014/04/08 0.35.2
=================
- updated crate-admin to 0.5.1
2014/04/08 0.35.1
=================
- updated crate-admin to 0.5.0
- fixed an issue where sometimes ``COPY TO`` ignores settings.
- fixed a NullPointerException that could occur using the COPY TO statement if
the target directory doesn't exist.
2014/04/07 0.35.0
=================
- updated crate-admin to 0.4.3
- tables can now be exported using the COPY TO statement.
- S3 support added to COPY FROM statement
- various new options in COPY statements
- COPY FROM now supports globs and expressions in uris.
- feature: added support to set 'refresh_interval' for tables
- fix: AND operator normalization was wrong if one of the arguments
is a boolean
2014/04/04 0.34.1
=================
- fix: do not display internal blob table names in ``sys.shards.table_name``
- fix: detect nested primary keys and clustered by values in insert analysis
- fix: correctly update ``ping_counters`` for udc
- update crash_standalone to 0.8.3
2014/03/26 0.34.0
=================
- feature: added table information_schema.routines
- feature: support global DISTINCT select statements
- upgrade bundled crash to 0.8.1
- fix: allow ``PRIMARY KEY`` constraint and compound index definition
to appear anywhere in the table element list
- fix: proper boolean column handling in where clause of select statements
- fix: first parts of qualified name in ORDER BY were ignored
- fix: unassigned shards must return NULL by default for the `primary` column
- fix: error messages will no longer show the 'return type' of a function and
aggregation
- fix: prevent select or filter of system columns if query has not a
group-by or global aggregate clause and used table is not a system table
- fix: fixed global 'group by' analysis. analyzer now returns an improved
error message if a statement contains aggregates and column references but
missing the corresponding group by expression
- fix: table names may not contain '.'
2014/03/24 0.33.0
=================
- upgraded crate-python and crash to 0.8.0
- optimize sets of compound primary keys in where clause to multi gets
- fixed schema creation for nested objects.
- added the ``format`` scalar function.
- support primary key constraint with multiple columns
- support clustered-by key without primary key constraint
2014/03/20 0.32.3
=================
- fix: windows compatibilty (sys.nodes.load, crash_standalone)
- fixed a threading issue that could occur when executing ``COPY`` statements.
- fix: prevent updating of system, primary key and clustered-by column
2014/03/17 0.32.2
=================
- bugfix: the rowcount returned from `copy <table> from <path>` was sometimes
wrong.
- log the current version of Crate Data
2014/03/17 0.32.1
=================
- updated crate-admin to 0.3.0 - to no longer depend on elasticsearch REST API
2014/03/17 0.32.0
=================
- upgraded included crash to 0.7.1
- introduced setting ``es.api.enabled`` (Boolean) to enable
the elasticsearch HTTP REST API
- elasticsearch HTTP REST API now disabled by default
2014/03/13 0.31.0
=================
- updated crate-admin to 0.2.9
- optimized global count aggregations.
- now downloading current ``crash.zip.py`` during build
- added the sql `ALTER [BLOB] TABLE` clause.
2014/03/12 0.30.0
=================
- streamlined ``CREATE ANALYZER`` syntax to only use the ``WITH`` keyword
on properties
- implemented refresh sql command ``REFRESH TABLE <tableName>`` to make previous
changes to this table available for further commands.
2014/03/12 0.29.0
=================
- update crate-admin to 0.2.6
- The `number_of_replicas` column in `information_schema.tables` is now a
string instead of a number as it might also return ranges like '0-all'.
- blobs can now only be used on a ``BLOB TABLE`` created using sql,
also the REST endpoint changed from ``/<tableName>/_blobs`` to ``/_blobs/<tableName>``
- updated fulltext utilities documentation
- Fixed exceptions on ``sys.shards.num_docs`` when shard is not started yet.
Return ``null`` in this case.
2014/03/10 0.28.0
=================
- fix null ordering in non 'group by' queries.
- added column ``schema_name`` to ``sys.shards`` table
- implemented blob shards on ``sys.shards`` table
- updated crate-admin to 0.2.4
- fix bug with empty lists or lists only containing ``null`` as parameter
- delay Parameter resolving until expected type is known.
- BREAKING CHANGE: replaced the `REPLICAS` table setting with the table
property `number_of_replicas`.
2014/03/04 0.27.0
=================
- date_trunc: implemented optional parameter 'timezone'.
- corrected sys.nodes.mem percentages
- bin/crate will now start crate in the foreground by default.
In order to start it in the background add `-d`
- add support for implicit type casts on set literals.
2014/03/04 0.26.0
=================
- removed obsolete akiban sql parser and related code
2014/03/04 0.25.0
=================
- updated crate-admin to 0.2.2
- added ``information_schema.table_constraints``
- added support for array types.
2014/03/04 0.24.0
=================
- updated crate-admin to 0.1.2
- upgraded elasticsearch to 1.0.1
- added scalar function date_trunc
- fixed several issues with certain locales
- new parser is now used for create table and drop table
2014/02/26 0.23.2
=================
- fixed a synchronization issue that could cause invalid results
- cleaned up exception messages to be more useful for the users.
- fixed a bug that caused an exception in case the request was "primary key
optimized" and the cluster state wasn't yet fully synchronized.
- added missing state description in docs/sql/stats
- closed tables are now longer shown in the information schema.
- fixed various random test failures that were caused by a flaky test setup.
2014/02/25 0.23.1
=================
- improved error handling and fixed an error that caused group by to hang
sometimes.
- added back support for parameter substitution for the LIMIT and OFFSET
clause
- use crate-admin 0.0.4
2014/02/24 0.23.0.Beta0
=======================
- changed the sql-parser from a javacc/akiban derived parser to a presto
derived antrl based parser.
- added sys.nodes and sys.cluster tables which can be queried to get
information about the cluster and nodes.
- BREAKING: the core data types are now more strict and so it is for example
no longer possible to save a string array into a string field.
This functionality will be added back later with explicit multi value
types.
2014/01/29 0.22.2
=================
- updated .gitignore and renamed heading in README.rst
2014/01/29 0.22.2
=================
- fix: `_search_into` now works again with `targetNodes`
- updated README.rst
- Moved 'create_tag.sh' to 'devtools'.
Attention: Because of relative paths, you _have_ to invoke the script as
follows: './devtools/create_tag.sh'.
2014/01/23 0.22.1
=================
- admin-ui: implemented basic cluster view with list of nodes
- updated default config files crate.yml and logging.yml
2014/01/20 0.22.0
=================
- disabled logging of udc at info level
- fix: udc ssl truststore was not found at JAR's
- fix: distinct count aggregation should return 0 when hitting no column
- upgraded elasticsearch to 0.90.10
2014/01/15 0.21.1
=================
- fix Double URL encoding of udc parameters
- fix NPE on close of UDCService
2014/01/15 0.21.0
=================
- changed default port ranges for http to 4200-4300 and for transport 4300-4400
- added ssl truststore including StartCom CA, fixes UDC
- fixed default cluster name (especially on linux platforms)
- implemented UDC module
- implemented generation of an unique ClusterId on cluster start-up
- added parameter expressions to presto based sql-parser
- added support for subscript expressions to the new presto based sql-parser
2014/01/10 0.20.4
=================
- admin-ui: fixed number format, fixed table missing + underreplicated shards count,
show first table if selected table was deleted/closed
- ignore unknown types in legacy mappings
2014/01/09 0.20.3
=================
- admin-ui: fixed table css + data reload flickering + sidebar button
re-enabled blender font at docu
- added presto based sql-parser to the source tree
2014/01/08 0.20.2
=================
- admin-ui: implemented tables overview page
2014/01/08 0.20.1
=================
- admin-ui: fixed display/number of under-replicated docs while cluster state is red
- admin-ui: display long numbers as rounded units
- implemented ``object`` type within ``CREATE TABLE`` statements
allowing to create nested tables/documents with SQL
- renamed all occurrences of ``craty`` to ``object``
- fix irregular deadlock while collect with ScriptValuesExpression
2013/12/20 0.20.0
=================
- admin-ui: implemented general overview page
- optimized serialization performance for `count(distinct colName)`
- fix: fix NPE on ``stats.shards`` with unknown column in where clause
- now an error is thrown if the DISTINCT keyword is used globally. Currently
only `count(DISTINCT colName)` is supported. Other queries have to be
re-written to use the `group by` clause.
- removed inline junit-benchmarks sources and added dependency
- crate.yml configuration file is now also read without specifying
`-Des.config` in the start script.
- new global expression ``sys.cluster.name`` created.
Can be queried in group by queries and global aggregate queries.
- removed inline junit-benchmarks sources and added dependency
- crate.yml configuration file is now also read without specifying
`-Des.config` in the start script.
- admin-ui: added simple loading indicator on submitting a SQL query via console,
also display query result status including query duration
- optimized group by performance
2013/12/17 0.19.14
==================
- fix: ignore closed tables at `information_schema`
- fix: forbid references to other tables
- fix: more stability for InformationSchemaServiceTest
2013/12/17 0.19.13
==================
- admin-ui: resolve cluster health state using SQL now
also display empty values at status-bar if cluster is not reachable/disconnected
- allow nested columns in aggregate functions
2013/12/16 0.19.12
==================
- the `order by` clause now works on both alias and non-alias as long as the
columns/alias are unique within the statement.
- fix COUNT(*) requests on "virtual" tables like ``information_schema`` and ``stats.shards``
2013/12/13 0.19.11
==================
- fixed an error that occured if a blob is uploaded using a client that chunks
the request but doesn't support 100-Continue.
2013/12/11 0.19.10
==================
- implemented basic version of new admin-ui
- fixed a thread deadlock that could occur if many group by queries run in
parallel
- changed threadpool settings to avoid handler blocking each other on group by queries
2013/12/05 0.19.9
=================
- benchmark test setup improvements
- removed randomness from test setup
- renamed crate admin plugin to `admin-ui`
- updated elasticsearch to 0.90.7
- Queries on the shard stats table using aggregates without group by are supported now.
- Also list unassigned shards when querying shard stats table.
- fix: fixed stalled cluster on using more than one COUNT(DISTINCT col) in a statement
- performance-tuning: faster ANY processing in ``group by`` requests
- Shard stats table is using a pool for it's MemoryIndex now.
- Implemented ``stats`` schema with virtual table ``shards``, usable for gathering real-time
statistics of shards.
- performance-tuning: concrete serialization of aggstates
- ``COUNT`` aggregate function can now be used on column names, counting all rows with values that
are not ``NULL``.
- ``ANY`` aggregate function
- the `COUNT` aggregation function now supports the `DISTINCT` keyword.
- aggregations are now allowed on normal ``SELECT`` statements, not only ``GROUP BY`` statements
- ``AVG`` aggregate function
- ``SUM`` aggregate function
- ``MAX`` aggregate function
- minor group by optimization (replaced idxMap with value extractors)
- grouping performance tuning
- added more trace logs
- ``MIN`` aggregate function, basic infrastructure for column/value based aggregation
2013/11/26 0.19.8
=================
- added more trace logs
- fixed classpath overloading issue.
2013/11/25 0.19.7
=================
- fixed a bug that occured if the offset in a group by query was larger then
the number of rows in the result-set
- fix: group by did not work correctly on nested columns due to missing mapping
- group by performance improvements.
- the `group by` clause now also works if information_schema tables are
queried.
2013/11/22 0.19.6
=================
- fix: added sql query duration to SQL xcontent response
2013/11/22 0.19.5
=================
- fix: offset didn't work correctly for group by queries.
- fixed primary key handling in inout plugin
- fixed a bug where special fields might not get applied in inout
plugin import when a sub-object occurs in a row
- error that group by doesn't work on columns that contain arrays is now
already raised in the query parsing step if possible.
- improved test-run speed by not starting nodes unnecessarily
- further optimization of the internal data structure serialization used while
executing a group by query.
- Implemented Crate Version & Build class
- use Crate version number at main rest endpoint
- use ES version as `es_version`
- use Version.CURRENT for distribution & create_tag.sh
- removed static versions.json, read it from main rest endpoint instead
- Throw a proper error if a multi-value field is encountered during group by
instead of returning an incorrect result.
- refactoring of Doctest TestCases
- internal: support for mapping ip-types (stored as string)
- Added ``duration`` property to SQLResponse, reflecting the duration of a SQL query.
- optimized internal data structures that are used when executing a group by
query. This should reduce memory consumption and speed up serialization.
- map builtin column ``_score`` explicitly to double
- type guessing on added columns (as root column or in dynamic object/craty)
- interpret nested types in indexmapping as craty
- Increased default ``SELECT`` limit to 10000.
Also use this default limit on ``GROUP BY`` queries if no limit is defined explicit.
- Fix: NPE was thrown when using a star select on an index with no defined mappings
- new es upstream commit: new setting ``index.mapper.map_source`` to control whether source
values get mapped when returning
- fix: correct type validation and mapping on all handler nodes, even on nodes without table-shard
according to table definition
- nested columns of object types now listed in ``information_schema.columns``
2013/11/18 0.19.4
=================
- Fix: proper error handling while uploading files to an index with disabled blob support
- test hickup fixes and speed improvements
- proper Error handling when issuing statements against a table-alias
- rename column ``expressions`` of ``information_schema.indices`` to ``columns``
and change type to array of strings
2013/11/14 0.19.3
=================
- Schema check for table aliases can be disabled by config now.
2013/11/13 0.19.2
=================
- Added support for table alias usage on ``SELECT`` queries. Only possible if all tables are
using the same schema.
- Windows build: favor crate jars over all other jars at classpath
- Fix: make test-setup create data dirs as temporary directories
that get deleted after test runs
- Fix: use nodeName instead of nodeId for path var ${node} on ``COPY`` SQL command
- Added support for ${node}, ${cluster} and ${table} variables inside the `path` value of a
``COPY`` SQL command
- Fix: using regex pattern on ``COPY`` did not work properly
2013/11/13 0.19.1
=================
- added column ``routing_column`` to table ``information_schema.tables``,
listing the column whose value determines on which shard a document gets stored
2013/11/12 0.19.0
=================