forked from crate/crate
-
Notifications
You must be signed in to change notification settings - Fork 0
/
CHANGES.txt
3109 lines (1900 loc) · 91.6 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
=================
Unreleased
==========
- The ``jobs.keep_alive_timeout`` value can now be configured and the default has been
changed to 0 (deactivated) from ``5m``
- Allow creating the CrateClient with settings and servers at the same time
- Expose shard recovery information in sys.shards table
- Expose relocating shards in sys.shards table
Note that relocating shards are shown additionally to their already assigned
source shards.
- Removed the limitation that all selected columns must also appear in the
ORDER BY clause for joins.
- Added support for explicit INNER JOIN .. ON syntax.
- added os and jvm infos to sys.nodes table
- sort columns in ``sys`` and `` information_schema`` tables
alphabetically when selecting all columns with ``*``
2015/12/02 0.53.1
=================
- Updated Crash to 0.14.3, which includes the following change:
- Python2.6/2.7 output now prints unicode strings correctly when using
csv output format
- Improved the speed of group by queries which contain tables with more
than 1 shard per node.
- Updated crate-admin to 0.16.1 which includes following changes:
- fix: column headers where not shown in result table on console page
when two or more columns with the same name were selected
- Fix: insert into a partitioned primary key column of type long
could fail under some circumstances
- Fix: missing characters when concatenating string under some
rare circumstances
- Internal optimization: Avoid writing partition values to the source.
- Updated crate certificates in the ssl truststore.
- Fixed an issue that could cause bulk update requests to fail if the
``bulkArgs`` contained only one item
2015/11/16 0.53.0
=================
- Updated crate-admin to 0.16.0 which includes following changes:
- 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.
- implement ``intersects`` scalar function
- fix: properly restrict partitioned by columns to primitive types
during analysis
- added functionality to index and match geo shapes
- restrict WITHIN function to only accept geo_point (and compatible types)
as first argument
- Added snapshot and restore functionality
- Changed crate launch scripts to no longer support extending the
CRATE_CLASSPATH environment variable
- Added initial limited cross and inner join support
- Updated crate/elasticsearch for improved logging on graceful shutdown errors
- Added ``array_cat``, ``array_unique`` and ``array_difference`` scalar
functions. Also modified ``concat`` function to resolve to ``array_cat`` when
``concat`` function is called with 2 array args, so the operator ``||`` will
work with arrays.
2015/11/11 0.52.2
=================
- Updated crate-admin to 0.15.3 which includes following changes:
- 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
- Updated crash to 0.14.2 which contains following changes:
- Fixed an assertion error that could occur under python2.7
2015/11/04 0.52.1
=================
- Fixed an issue that caused orphaned partitions with an remaining alias to
not be recognized correctly
- Fix: clean up file descriptors in case of exceptions when retrieving blobs
over the REST api
- Fixed an issue that was causing like queries to fail if using a special regex
character
- Upgraded Elasticsearch to 1.7.3
- Fixed the issue which causes overloading of the first configured node in
the cluster when multiple clients connections are established
- Fixed a possible race condition that could lead to queries getting stuck
(Only affected SELECT queries with a limit/offset > 500000)
- Fix: Crate won't start properly if a plugin loading error occurs
(e.g. through a misconfigured plugin)
- Fixed an issue that was introduced in 0.52.0 which could cause a
FetchContext to remain open longer than necessary in an error case.
This could then lead to failures if an attempt was made to move shards to
which the FetchContext hold onto.
- Updated crate-admin to 0.15.2 which includes following changes:
- 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 bug that displays a zero value as NULL value
- fixed URL to download in dropdown that notifies about old Crate version
- fixed a visual bug that let an item in the node/table list partly disappear
if scrolling gets enabled
- Updated crash to version 0.14.1 which contains the following changes:
- Floating point values are no longer rounded to 6 places under python2.7 if
output using the tabular or mixed output format.
Now the behaviour for all output formats is the same and consistent with
the python3 output format.
Python2.6 will still display rounded values.
- Fixed the issue casuing parsing error while using internal ``non-sql``
crash commands with semicolon.
2015/10/13 0.52.0
=================
- The client will now accept IPv6 literals as server addresses
- Updated crate-admin to 0.15.0 which includes following changes:
- display cluster checks on overview page
- display relative Crate process CPU usage as bar chart and show number of
cores per node
- Allow quoted subscript expressions in SQL statement. This will allow
supporting various client applications on Windows that use ODBC.
- Added ``try_cast`` scalar function.
- Added cluster checks which are exposed via the ``sys.checks`` table.
- Added ``os_info`` column to ``sys.nodes`` table.
Currently the column only lists the number of available processors in the JVM
(which is usually equal to the number of cores of the CPU).
- Upgraded Elasticsearch to 1.7.2
This update changes the default value for delayed allocation of unassigned
shards (see: `https://crate.io/docs/en/latest/configuration.html#unassigned`_).
Also updated the upstream of EC2 discovery module
2015/10/09 0.51.6
=================
- Fix check if setting is settable/resettable on runtime for nested settings
- Exposed missing cluster gateway settings
- Throw an exception when someone attempts to change non-runtime changeable
settings
- Fixed a race condition that could cause COPY FROM operations to get stuck if
shards were to be relocated.
- Fixed a race condition that could cause the re-creation of an already
existing table partition and therefore potential dataloss when creating
a lot of partitions simultaniously using COPY FROM or bulk inserts.
2015/10/07 0.51.5
=================
- Updated crate-admin to 0.14.6 which includes following changes:
- 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
- Fixed a bug in SHOW CREATE TABLE statement that leads to a wrong table
schema if the table contains nested objects
- Fix: Prevent NPE in COPY FROM and INSERT FROM SUBQUERY queries
when newly created shards are not available yet
- Fixed an issue that causes a ClosedChannelException during BLOB download
- Fixed a bug that causes a NaN response on _score system column in select
statement that uses an ORDER BY clause
- Fix: in some rare cases tables were not updated on every node after table
schema changes
- If the same table appears more than once in the FROM clause now an error is
thrown instead of silently ignoring it.
- Fixed a rare bug that leads to serialization issues when a ShardBulkRequest
was serialized more than once
- Fixed a bug that could cause imports from s3 result in an error instead of
importing the data if the URI contained wildcards.
- Improve performance of LIKE and Regexp queries
- Fix: Order by ``_raw`` and/or ``_id`` did not work.
- Fix: support compressed ``_source``
2015/09/18 0.51.4
=================
- Fixed calculation of the EC2 discovery retry delay in order to prevent
exceeding of the AWS API request limit.
- Updated crate-admin to 0.14.5 which includes following changes:
- display ``NULL`` instead of empty cell in console results table
2015/09/15 0.51.3
=================
- Display column names that contain a dot correctly in information schema
and result column headers
2015/08/09 0.51.2
=================
- Updated crate-admin to 0.14.4 which includes the following changes:
- updated Intercom to support new messaging features. The Intercom service is
disabled if UDC is disabled on the Crate server.
- Fixed handling of non-deterministic functions
- Added Usage Data Collector ``udc`` column to ``sys.cluster`` table to
indicate its configured settings.
- Updated crash to version 0.14.0 which contains the following changes:
- Fixed output tabular format bug which results in wrong representation
of a string containing a floating point value.
- Updated wording of the cluster check command output.
- Added the check command which queries the ``sys.checks`` table for
cluster checks
- updated crate-python to 0.13.4
- Fixed an issue that could kill long running queries on shards with few
segments containing huge amounts of documents
2015/08/13 0.51.1
=================
- Improved retry logic of EC2 unicast host discovery mechanism
- Fixed a deadlock that could occur if queries with high offset or limit were
executed concurrently
2015/08/06 0.50.3
=================
- Updated crate-admin to 0.14.3 which includes the following changes:
- fixed line wrapping in console result table
- Fixed an issue which could cause the blob recovery process to hang under some
rare circumstances
- Fixed an issue that caused ``COPY TO .. s3`` statements to leave the cluster
in an inaccessible state
- Fixed an issue that could cause a count function on partitioned tables
to cause an error if a partition was deleted concurrently.
2015/07/29 0.51.0
=================
- Added the ``KILL 'job_id'`` statement.
- Fixed a bug with the kill of collectors when ``KILL ALL`` is called.
- Added support for unicast host discovery via EC2 API
- BREAKING CHANGE
Connections to AWS S3 for ``COPY FROM`` and ``COPY TO`` are now using HTTPS.
If you have previously blocked outgoing connections on ``443``, please update
your firewall settings!
- Improved handling of /_blobs REST URIs to prevent invalid URIs from being
passed to main handler where they raise missleading error messages
- Updated crate-admin to 0.14.2 which includes the following changes:
- added support for line breaks in console result table
- Added column policy as column to ``information_schema.tables`` table
- Added SHOW CREATE TABLE statement to dump the schema of a user created table
- Updated crash to 0.13.1 which contains following changes:
- added multiline support for tabular output format
- Expose missing refresh_interval table setting in information_schema.tables.
- Added support for multiple tables in refresh statement.
- Added ``date_format`` scalar function
2015/07/29 0.50.2
=================
- Fix: reduced the amount of unnecessary data handled on select queries
- Fixed an issue which prevented column updates to be noticed in the cluster
on tables in custom schemas.
- Fix: issuing ``KILL ALL`` when a ``SELECT`` statement hung due to a node
becoming unavailable during execution could result in error response
- Improved the error handling: In case threadpools are exhausted (due to very
high load on the cluster) queries could get stuck instead of being aborted
right away.
- Fixed a bug where a job entry wasn't cleaned up on any parser/analyzer errors.
- Fixed an issue that caused queries on blob tables to cause a
NullPointerException if the filter in the WHERE CLAUSE resulted in a
``null`` value.
- Fix: fixed an issue which caused an error if one selects a setting
which is not set
- Fix: fixed an issue which caused TypeConversion errors if a setting was
selected which represents a byte size
(e.g. indices[‘store’][‘throttle’][‘my_bytes_per_sec’])
- Fixed a rare bug which could cause a MapperParsingException if one creates
a new dynamic array concurrently
2015/07/16 0.50.1
=================
- Updated crate-admin to 0.14.1 which includes following changes:
- 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
- Fixed a bug which prevented a retry, or caused a retry to fail if a shard
was closed because of relocation
- Fixed an issue which could cause an error if a ``group by`` query was killed
- Added a limitation notice that `COPY TO` doesn't work with system tables and
attempting to do so will result in a more meaningful error.
- Fixed bulk delete for partitioned tables where partition column was part
of the where clause
- Fixed an issue that could lead to unclosed contexts when issuing bulk requests
2015/07/16 0.49.6
=================
- Fixed an issue which caused `array (string)` types to be interpreted as
`string` if an analyzer was also used
- Fixed an issue due to which bulk partition creation operations wouldn't
timeout correctly
- Corrected the default value of the `bulk.partition_creation_timeout`
setting. It was incorrectly reported as `0s` instead of `10s`.
- Fixed an issue that could cause concurrent queries on sys tables to
return inconsistent results if the table contains unassigned shards
- Fixed an issue that could cause a `SELECT` statement to cause a missleading
error if the table was deleted concurrently.
- Fixed an issue that could cause a `SELECT` statement on partitioned tables
to cause an error if all partitions were deleted concurrently.
- Fixed a race condition that could cause a `REFRESH TABLE` statement to fail
on partitioned tables
- Fixed a race condition that could cause `DROP TABLE IF EXISTS` statements to
get stuck
- Fixed a race condition that could cause queries with a high limit to fail
due to a missing job context.
- Fixed an issue that caused COPY TO `s3` statements to get stuck
- Fixed an issue which results in _id queries not matching on
partitioned and clustered tables without primary key columns.
2015/07/07 0.49.5
=================
- Fixed issue that could lead to a NullPointerException
caused by reporting row results to handler node before merge phase on handler
was started
- Fixed an issue that could cause concurrent queries on information_schema or
sys tables to return inconsistent results
- Fixed a rare race condition that could cause some queries with offset + limit higher
than 1_000_000 to return too few rows
- Fixed a possible race condition which leads to the execution of a
non-distributed group by instead of a distributed one.
- Fix: IS NULL predicate in query could return records that have already been
marked for deletion
- Fixed hash collide in fetch requests to avoid collision of node identifiers
2015/06/30 0.49.4
=================
- Fixed issue that could lead to deadlock and therefore freezing of a node
when there where too many queries asking for routing information in parallel.
- Fix: Querying from information_schema while a table is created could
cause an error
- only log amazon s3 client stuff on level ``WARN``
- log failing uri on COPY FROM
- Fixed a NPE that was thrown if a SELECT statement contained `_score` in the
result columns and an ORDER BY clause.
- Fix: selecting error from sys.jobs_log caused a NPE in some cases
- Fix: If a query would fail because a shard starts to relocate during
query time, the query is retried now
- Fix: load Crate plugins only once on node start
- Fixed an issue that caused `sys.shards` queries to omit unassigned shards
if the query was made against a node that has `node.data` set to false
- Fix: Fixed a bug where some searchers were not properly closed
- Fixed a race condition that could cause `DROP TABLE IF EXISTS` to fail if
the table was concurrently dropped.
- Fixed a race condition in `ALTER TABLE <partitioned_table>` that could occur
if a `DELETE FROM <partitioned_table>` was invoked immediately before the
`ALTER TABLE` statement.
2015/06/16 0.50.0
=================
NOTE: Upgrading from 0.49 or earlier versions requires a full cluster restart
- Updated crate-admin to 0.13.2 which includes following changes:
- improved layout for smaller screens
- 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
- Added ``probe_timestamp`` child expressions for os, process, heap, mem, and
network columns to sys.nodes table
- Added ``process['cpu']`` column to sys.nodes table
- Added ``ALTER TABLE ONLY`` statement support.
- Added unicast host discovery via SRV DNS records
- Added the ``KILL ALL`` statement which can be used to cancel running
operations
- Added new table settings that can be set on ``CREATE TABLE``
and changed/reset with ``ALTER TABLE``.
- Added the ``concat`` scalar function and the concat operator ``||``.
- Updated Elasticsearch to 1.5.2
- Added the ``IF NOT EXISTS`` clause to the ``CREATE TABLE`` statement
2015/06/16 0.49.3
=================
- Fixed an issue where ``_raw`` and ``_doc`` in primary key queries
returned ``NULL``
- Updated crash to 0.13.0 which includes following changes:
- Added `dynamic` as output format option
- Added ``--version`` to cli interface to show crash version and exit
- Display command help in case the command is not used correctly
- Display NULL values in mixed mode correctly
- Fixed broken 'mixed' output style due to overriding import
- Improved readability of sql syntax highlighting
- Attempting to use unknown command now results in an error
- Fix: return correct status for ``GET`` requests on ``/`` REST endpoint
when cluster is starting up
- Fixed a race condition that could cause a `CREATE TABLE` statement
immediately after a `DROP TABLE` statement to fail.
- Fixed a minor memory leak that occurred if custom schemas were deleted.
- Fixed incorrect comparison in query by IP type
- Fix: make sure sys.nodes expressions that utilize os/process/network/jvm
services use the same stats probe per row; previously values derived from
these services could have been from different probes
2015/06/03 0.49.2
=================
- Fix: Accounted RAM wasn't freed after distributed grouping queries finished.
- Added missing cluster settings for request circuit breaker
and expose them via information schema
- Made circuit breaker cluster settings settable on runtime
and renamed the missleading prefix ``node`` to ``indices``.
Note: This is a backward incompatibility change!
- Fix: Row count was wrong when a `DELETE FROM` statement on a
partitioned table hit exact 1 partition.
- Updated crate-admin to 0.12.1 which includes following changes:
- updated logo and icons
- Fixed an error that could occur if the same ``delete from
<partitoned_table>`` or ``drop table <partitioned_table>`` statement is
executed concurrently
2015/05/21 0.49.1
=================
- Fix: Do not throw exception on querying `sys.shards` while
unassigned shards are changing
- Fix: Removed unnecessary close context calls on CollectContext
- Support to register a plugin with different settings to multiple crate
instances using the same JVM
2015/05/20 0.48.6
=================
- Optimized ``DELETE FROM <partitioned_table>``
- Fix: Handle concurrently dropped partitions while collecting rows
- Fix: Updated es/upstream to prevent errors caused by too many cluster
state updates when dropping tables with a huge amount of partitions
- Fixed an issue that caused a node stop to always take up at least 10 seconds
- Further improved bulk partition creation which can occur during ``COPY
FROM`` or INSERTS with multi-values into partitioned tables
2015/05/15 0.48.5
=================
- Fix: Deleting a partitioned table could return a succesful query result
even if some partitions were not deleted correctly
- ``COPY FROM``: imports from S3 will now retry the import in case of a
read timeout.
- Select queries will now wait a bit longer before throwing an error in case
the shards of a table aren't fully active.
- Fix: In some cases a ``DROP TABLE`` statment does not delete all
partitions. Now it's possible to repeat the statement in order
to delete the orphaned partitions.
2015/05/07 0.49.0
=================
- Fix: performing queries on a partitioned table could cause unnecessary
``execution rejected`` errors
- Add plugin support
- Removed the limitation that the WHERE clause couldn't contain certain
expressions in `select count(*)` queries.
- update crate-admin to 0.12.0 which contains the following changes:
- display ``rest_url`` from sys.nodes table on node detail view
- Expose REST URL of node in ``sys.nodes`` table
- Increased speed and reduced amount of used memory on sorted queries
- Ordering by `_score` must be defined explictly now even when using a
`match` predicate.
Note: This is a backward incompatibility change.
2015/05/07 0.48.4
=================
NOTE: Upgrading from 0.47 or earlier versions requires a full cluster restart
- Fix: fix update queries on partitioned tables which are partitioned
by part of the primary key
- Fix: correctly display initial and reset settings in ``sys.cluster.settings``
- add dynamic settings ``bulk.request_timeout`` and ``bulk.partition_creation_timeout``
- make the ``sys.shards.size`` expression refresh all 10 seconds maximum
- Fixed an issue that caused GROUP BY queries with multiple group keys, no
order by and limit to hang.
- Increased performance of ``hostname`` and ``id`` expression for ``sys.nodes`` table
2015/04/28 0.48.3
=================
- Added possibility to create a single jar which contains all crate packages
without dependencies
- Include java client in crate distributions
- Optimized queries that use ``IN`` or ``ANY``
- Fix: Prevent COPY FROM or INSERT into a partitioned table to run into timeouts
when creating many partitions at once
- Fix: In some cases too few threads where started which could slow
down queries
- Fix: Option http.enabled=false caused UDC module to crash on startup
2015/04/21 0.48.2
2015/04/21 0.47.9
=================
- Fixed an issue with GROUP BY queries on partitioned tables which could lead
to wrong results
- Optimized retry logic in bulk and COPY operations to handle
and coordinate retries once per node
- Fix: Add transparent retry logic to UPDATE execution
- Using unsupported URI schema in COPY FROM statement now results in an error.
- Fixed an issue with the LIKE predicate if used on a system table where it
wouldn't match if the content contains newline characters
2015/04/21 0.47.9
=================
- Fix: documented minimum required java version
2015/04/09 0.48.1
=================
- Updated crate-admin to version 0.11.5 which contains following changes:
- fix: concurrent ajax requests caused partition information
in table detail view to be mixed up between tables
- Added support for setting the default schema name in the SQLRequest class
- Attempting to refresh a system table will now result in an error as system
tables are read-only and don't need to be refreshed.
- Fix: documented minimum required java version
- Updated crash to version 0.11.5 which contains the following changes:
- Fixed an issue with pasting multi-line statements from clipboard.
- Added argcomplete support. If argcomplete is available bash argument
completion will work if argcomplete is loaded.
- Fix: COPY FROM is now skipping empty lines.
- Fix: allow more than 1k elements in the IN query
- allow to use ANY expression to compare primitive values against an array literal
- Fix: ip type conversion did not allow NULL values
- Fix: Grouping or sorting on a dynamically created column of a partitioned
table could cause a NullPointerException
- include jts and spatial4j in client jar in order to properly use
the ``geopoint`` type
- produce a crate-client with all dependencies included under the 'io.crate'
package namespace in order to avoid conflicts
- Fix: Filtering by `_score` wasn't recognized on group-by queries.
- Fix: Do not shutdown the BulkShardProcessor while there are pending requests
anymore
- Fix: The ``format`` scalar function now always uses Locale.ENGLISH
- Fixed misleading error message for trying to group by invalid data type.
2015/04/03 0.47.8
=================
- Updated crash to version 0.11.5 which contains the following changes:
- Fixed an issue with pasting multi-line statements from clipboard.
- Added argcomplete support. If argcomplete is available bash argument
completion will work if argcomplete is loaded.
- Fix: COPY FROM is now skipping empty lines.
- Fix: allow more than 1k elements in the IN query
- allow to use ANY expression to compare primitive values against an array literal
- Fix an issue while analyzing nested aggregations.
- Fix: ip type conversion did not allow NULL values
- Fix: Grouping or sorting on a dynamically created column of a partitioned
table could cause a NullPointerException
- include jts and spatial4j in client jar in order to properly use
the ``geopoint`` type
- produce a crate-client with all dependencies included under the 'io.crate'
package namespace in order to avoid conflicts
- Fix: select queries querying for the primary key on custom schemas did now
return the correct results
- Fixed an issue that caused ``where somefield in (null)`` to match all rows
- Fix: Do not shutdown the BulkShardProcessor while there are pending requests
anymore
- Fix: The ``format`` scalar function now always uses Locale.ENGLISH
- Fixed misleading error message for trying to group by invalid data type.
2015/03/17 0.48.0
=================
- Fixed misleading error message for trying to group by invalid data type.
- COPY FROM / COPY TO will now automatically create a quoted URI if only a
path is given.
- Updated crash to version 0.11.4 which contains following changes:
- Fix: print stacktrace when crash is launched in verbose mode
- Fix: query duration was rounded incorrectly to second precision
- added ``--format`` command line option
to support different response output formats such as
``tabular``, ``raw``, ``json``, ``csv`` and ``mixed``
- BREAKING CHANGE
the ``CONNECT <host>`` client command was changed to ``\connect <host>``
see documentation for further details
- alternative cli implementation using prompt_toolkit
- added coloured printing when in interactive shell
- Support `ON DUPLICATE KEY UPDATE` while inserting using a query.
- Fix: Parameter substitution within subscript notation is not
allowed anymore
- Optimize OR queries which involve the cluster column.
- Removed support for ``_version`` column in where clause if no
primary key is specified in a query.
- Added support for the ``IF EXISTS`` clause to ``DROP TABLE`` and
``DROP BLOB TABLE``
2015/03/13 0.47.7
=================
- Fixed an issue where statements wouldn't work correctly if tables of a
custom schema are involved
- IN operator NULL literals bug fix
- Fixed an ip validator bug that marked some valid ip's as invalid.
- Fixed an issue with concurrent INSERT requests that could fail due to using
a shared state internally.
2015/03/11 0.47.6
=================
- Fixed an issue with custom schemas that could cause select statements on the
``information_schema.tables`` table to result in a NPE.
- Fixed an issue that could cause the response to contain the wrong types
(e.g. integer instead of long)
- Fix: Sorting on a scalar with a column containing NULL values as
argument no longer throws an NPE
- Fix: group by on clustered by column on a partitioned table now produces
correct results for groups spanning different partitions
- Fixed an issue that caused errors to be swallowed and caused queries to not
terminate correctly.
- Fix: COPY FROM and INSERT from subquery into a partitioned table created
separate tables with a wrong name instead of correct partitions
2015/03/09 0.47.5
=================
- Upgrade Elasticsearch to v1.4.4
- Updated crate-admin to version 0.11.4 which contains following changes:
- fix: calculate health for each partition of a partitioned table
based on the number of shards of that partition
- Fix: number_of_shards and number_of_replicas are now correctly applied
through the whole lifetime of a partitioned table and its partitions
- Added columns ``number_of_shards`` and ``number_of_replicas`` to
table ``information_schema.table_partitions``
2015/02/18 0.47.4
=================
- Fixed a race condition where some statements would break because of
using a shared state internally.
- Made zero length string routing consistent and route by the actual
hash of an empty string instead of handling it as null. CAUTION: If
you are using emtpy strings as routing values, affected records
need to be re-inserted.
2015/02/17 0.47.3
=================
- Fix: Inserting from a query which contains aggregation functions failed in some
cases
2015/02/13 0.47.2
=================
- Fix regression introduced in ``0.47.0``: It is now again possible to refer
to columns using the fully qualified name including table name or alias in
the WHERE clause of an Update statement.
- Added a new option ``overwrite_duplicates`` to COPY FROM. This option can be
used to make COPY FROM behave the same as it did in versions prior to
``0.47.0``
- Fix: Sorting on a function that returns a boolean value could cause an error.
2015/02/10 0.47.1
=================
- Improved performance of queries that use generic scalar functions (like
equals comparison on arrays)
- COPY FROM now skips rows with the same primary key instead of overriding them
2015/02/06 0.47.0
=================
- Added support for array comparisons using the equals ``=`` operator.
- Support `INSERT ... ON DUPLICATE KEY UPDATE` statement
- Added case-insensitive regex operator ~*
- Support PCRE compatible regular expressions
- updated crate-admin version to 0.11.3 which contains following changes:
- fixed bug that showed custom schemas in the table list
as often as the amount of tables in that custom schema
- Added support for the ``std_dev``, ``variance`` and ``geometric_mean``
aggregation functions
- Added support for the CURRENT_TIMESTAMP expression
- Throw an error while using unknown column references in ``SELECT``
statements while parent's policy is not of type ``ignored``
- Added support for the datetime function ``extract (field from source)``
- Support column referencing in ``Update`` statement assignment
expression
- Removed undocumented feature: It is no longer possible to use sys
expressions in any context.
- don’t allow full qualified names in UPDATE assignments, INSERT and
INSERT INTO
- The ``sys.operations`` table has now a ``_nodes`` system column
which exposes information about the node the operation runs on.
2015/02/06 0.46.5
=================
- Upgrade Elasticsearch to v1.4.2
- Fix: Hard wire utf-8 encoding in init scripts, so unicode filenames work
- Fix: COPY FROM PARTITION failed if the source contained a ``partitioned by`` column
- Fix: ALTER TABLE could break existing tables under some conditions
- Fix: Improved value validation for nested primary key and clustered by
columns in INSERT statements.
- Fix: IP column validation is now done in analysis
2015/02/06 0.46.5
2015/02/06 0.45.9