This is an automated email from the ASF dual-hosted git repository.
kxiao pushed a commit to branch branch-2.0
in repository https://gitbox.apache.org/repos/asf/doris.git
The following commit(s) were added to refs/heads/branch-2.0 by this push:
new d4af841159d [fix](parquet)fix can not read parquet lz4 compress.
(#27383) (#28457)
d4af841159d is described below
commit d4af841159dd92e8780224b5a4de7bb3ea0ba7f6
Author: Mingyu Chen <[email protected]>
AuthorDate: Sat Dec 16 11:57:02 2023 +0800
[fix](parquet)fix can not read parquet lz4 compress. (#27383) (#28457)
Fixed the problem of not being able to read parquet lz4 compressed format.
By default, it is decompressed according to the Hadoop lz4 format. If it fails,
it will fall back to the standard lz4 compression format.
Co-authored-by: daidai <[email protected]>
---
be/src/exec/decompressor.cpp | 140 ++++---
be/src/util/block_compression.cpp | 29 +-
.../external_table_p2/hive/test_compress_type.out | 439 +++++++++++++++++++++
.../hive/test_compress_type.groovy | 27 ++
4 files changed, 585 insertions(+), 50 deletions(-)
diff --git a/be/src/exec/decompressor.cpp b/be/src/exec/decompressor.cpp
index 964654132a3..1e7e3482234 100644
--- a/be/src/exec/decompressor.cpp
+++ b/be/src/exec/decompressor.cpp
@@ -22,6 +22,8 @@
#include <ostream>
#include "common/logging.h"
+#include "gutil/endian.h"
+#include "gutil/strings/substitute.h"
namespace doris {
@@ -339,66 +341,106 @@ Status Lz4BlockDecompressor::init() {
return Status::OK();
}
+// Hadoop lz4codec source :
+//
https://github.com/apache/hadoop/blob/trunk/hadoop-mapreduce-project/hadoop-mapreduce-client/hadoop-mapreduce-client-nativetask/src/main/native/src/codec/Lz4Codec.cc
+// Example:
+// OriginData(The original data will be divided into several large data
block.) :
+// large data block1 | large data block2 | large data block3 | ....
+// The large data block will be divided into several small data block.
+// Suppose a large data block is divided into three small blocks:
+// large data block1: | small block1 | small block2 | small block3 |
+// CompressData: <A [B1 compress(small block1) ] [B2 compress(small block1)
] [B3 compress(small block1)]>
+//
+// A : original length of the current block of large data block.
+// sizeof(A) = 4 bytes.
+// A = length(small block1) + length(small block2) + length(small block3)
+// Bx : length of small data block bx.
+// sizeof(Bx) = 4 bytes.
+// Bx = length(compress(small blockx))
Status Lz4BlockDecompressor::decompress(uint8_t* input, size_t input_len,
size_t* input_bytes_read,
uint8_t* output, size_t output_max_len,
size_t* decompressed_len, bool*
stream_end,
size_t* more_input_bytes, size_t*
more_output_bytes) {
- uint8_t* src = input;
- size_t remaining_input_size = input_len;
- int64_t uncompressed_total_len = 0;
- *input_bytes_read = 0;
+ auto* input_ptr = input;
+ auto* output_ptr = output;
- // The hadoop lz4 codec is as:
- // <4 byte big endian uncompressed size>
- // <4 byte big endian compressed size>
- // <lz4 compressed block>
- // ....
- // <4 byte big endian uncompressed size>
- // <4 byte big endian compressed size>
- // <lz4 compressed block>
- //
- // See:
- //
https://github.com/apache/hadoop/blob/trunk/hadoop-mapreduce-project/hadoop-mapreduce-client/hadoop-mapreduce-client-nativetask/src/main/native/src/codec/Lz4Codec.cc
- while (remaining_input_size > 0) {
- // Read uncompressed size
- uint32_t uncompressed_block_len = Decompressor::_read_int32(src);
- int64_t remaining_output_size = output_max_len -
uncompressed_total_len;
- if (remaining_output_size < uncompressed_block_len) {
- // Need more output buffer
- *more_output_bytes = uncompressed_block_len -
remaining_output_size;
- break;
+ while (input_len > 0) {
+ //if faild , fall back to large block begin
+ auto* large_block_input_ptr = input_ptr;
+ auto* large_block_output_ptr = output_ptr;
+
+ if (input_len < sizeof(uint32_t)) {
+ return Status::InvalidArgument(strings::Substitute(
+ "fail to do hadoop-lz4 decompress, input_len=$0",
input_len));
}
- // Read compressed size
- size_t tmp_src_size = remaining_input_size - sizeof(uint32_t);
- size_t compressed_len = Decompressor::_read_int32(src +
sizeof(uint32_t));
- if (compressed_len == 0 || compressed_len > tmp_src_size) {
- // Need more input data
- *more_input_bytes = compressed_len - tmp_src_size;
+ uint32_t remaining_decompressed_large_block_len =
BigEndian::Load32(input_ptr);
+
+ input_ptr += sizeof(uint32_t);
+ input_len -= sizeof(uint32_t);
+
+ std::size_t remaining_output_len = output_max_len - *decompressed_len;
+
+ if (remaining_output_len < remaining_decompressed_large_block_len) {
+ // Need more output buffer
+ *more_output_bytes = remaining_decompressed_large_block_len -
remaining_output_len;
+ input_ptr = large_block_input_ptr;
+ output_ptr = large_block_output_ptr;
+
break;
}
- src += 2 * sizeof(uint32_t);
- remaining_input_size -= 2 * sizeof(uint32_t);
+ std::size_t decompressed_large_block_len = 0;
+ do {
+ // Check that input length should not be negative.
+ if (input_len < sizeof(uint32_t)) {
+ *more_input_bytes = sizeof(uint32_t) - input_len;
+ break;
+ }
- // Decompress
- int uncompressed_len = LZ4_decompress_safe(reinterpret_cast<const
char*>(src),
-
reinterpret_cast<char*>(output), compressed_len,
- remaining_output_size);
- if (uncompressed_len < 0 || uncompressed_len !=
uncompressed_block_len) {
- return Status::InternalError(
- "lz4 block decompress failed. uncompressed_len: {},
expected: {}",
- uncompressed_len, uncompressed_block_len);
+ // Read the length of the next lz4 compressed block.
+ size_t compressed_small_block_len = BigEndian::Load32(input_ptr);
+
+ input_ptr += sizeof(uint32_t);
+ input_len -= sizeof(uint32_t);
+
+ if (compressed_small_block_len == 0) {
+ continue;
+ }
+
+ if (compressed_small_block_len > input_len) {
+ // Need more input buffer
+ *more_input_bytes = compressed_small_block_len - input_len;
+ break;
+ }
+
+ // Decompress this block.
+ auto decompressed_small_block_len = LZ4_decompress_safe(
+ reinterpret_cast<const char*>(input_ptr),
reinterpret_cast<char*>(output_ptr),
+ compressed_small_block_len, remaining_output_len);
+ if (decompressed_small_block_len < 0) {
+ return Status::InvalidArgument("fail to do LZ4 decompress,
error = {}",
+
LZ4F_getErrorName(decompressed_small_block_len));
+ }
+ input_ptr += compressed_small_block_len;
+ input_len -= compressed_small_block_len;
+
+ output_ptr += decompressed_small_block_len;
+ remaining_decompressed_large_block_len -=
decompressed_small_block_len;
+ decompressed_large_block_len += decompressed_small_block_len;
+
+ } while (remaining_decompressed_large_block_len > 0);
+
+ if (*more_input_bytes != 0) {
+ // Need more input buffer
+ input_ptr = large_block_input_ptr;
+ output_ptr = large_block_output_ptr;
+ break;
}
- output += uncompressed_len;
- src += compressed_len;
- remaining_input_size -= compressed_len;
- uncompressed_total_len += uncompressed_len;
+ *decompressed_len += decompressed_large_block_len;
}
-
- *input_bytes_read += (input_len - remaining_input_size);
- *decompressed_len = uncompressed_total_len;
+ *input_bytes_read += (input_ptr - input);
// If no more input and output need, means this is the end of a compressed
block
*stream_end = (*more_input_bytes == 0 && *more_output_bytes == 0);
@@ -440,10 +482,10 @@ Status SnappyBlockDecompressor::decompress(uint8_t*
input, size_t input_len,
while (remaining_input_size > 0) {
// Read uncompressed size
uint32_t uncompressed_block_len = Decompressor::_read_int32(src);
- int64_t remaining_output_size = output_max_len -
uncompressed_total_len;
- if (remaining_output_size < uncompressed_block_len) {
+ int64_t remaining_output_len = output_max_len - uncompressed_total_len;
+ if (remaining_output_len < uncompressed_block_len) {
// Need more output buffer
- *more_output_bytes = uncompressed_block_len -
remaining_output_size;
+ *more_output_bytes = uncompressed_block_len - remaining_output_len;
break;
}
diff --git a/be/src/util/block_compression.cpp
b/be/src/util/block_compression.cpp
index 3c051c240ef..58c75a0c433 100644
--- a/be/src/util/block_compression.cpp
+++ b/be/src/util/block_compression.cpp
@@ -44,7 +44,9 @@
#include <ostream>
#include "common/config.h"
+#include "exec/decompressor.h"
#include "gutil/strings/substitute.h"
+#include "util/bit_util.h"
#include "util/defer_op.h"
#include "util/faststring.h"
@@ -188,6 +190,31 @@ private:
static const int32_t ACCELARATION = 1;
};
+class HadoopLz4BlockCompression : public Lz4BlockCompression {
+public:
+ static HadoopLz4BlockCompression* instance() {
+ static HadoopLz4BlockCompression s_instance;
+ return &s_instance;
+ }
+ Status decompress(const Slice& input, Slice* output) override {
+
RETURN_IF_ERROR(Decompressor::create_decompressor(CompressType::LZ4BLOCK,
&_decompressor));
+ size_t input_bytes_read = 0;
+ size_t decompressed_len = 0;
+ size_t more_input_bytes = 0;
+ size_t more_output_bytes = 0;
+ bool stream_end = false;
+ auto st = _decompressor->decompress((uint8_t*)input.data, input.size,
&input_bytes_read,
+ (uint8_t*)output->data,
output->size, &decompressed_len,
+ &stream_end, &more_input_bytes,
&more_output_bytes);
+ //try decompress use hadoopLz4 ,if failed fall back lz4.
+ return (st != Status::OK() || stream_end != true)
+ ? Lz4BlockCompression::decompress(input, output)
+ : Status::OK();
+ }
+
+private:
+ Decompressor* _decompressor;
+};
// Used for LZ4 frame format, decompress speed is two times faster than LZ4.
class Lz4fBlockCompression : public BlockCompressionCodec {
private:
@@ -1086,7 +1113,7 @@ Status
get_block_compression_codec(tparquet::CompressionCodec::type parquet_code
break;
case tparquet::CompressionCodec::LZ4_RAW: // we can use LZ4 compression
algorithm parse LZ4_RAW
case tparquet::CompressionCodec::LZ4:
- *codec = Lz4BlockCompression::instance();
+ *codec = HadoopLz4BlockCompression::instance();
break;
case tparquet::CompressionCodec::ZSTD:
*codec = ZstdBlockCompression::instance();
diff --git a/regression-test/data/external_table_p2/hive/test_compress_type.out
b/regression-test/data/external_table_p2/hive/test_compress_type.out
index a95bf1f0dd3..ed88a8f6967 100644
--- a/regression-test/data/external_table_p2/hive/test_compress_type.out
+++ b/regression-test/data/external_table_p2/hive/test_compress_type.out
@@ -45,3 +45,442 @@
4611870011201662970 0 HD Tube 5* 1 2014-03-22T05:11:29
2014-03-22 598875 4243808759 92f6fe1be9b9773206d6b63e50feb470
196 2314158381335918424 0 3 3
http://public_search yandex.ru.livemaster 0 0
[] [4,15,333,3912,14512,12818] [18,348,1010] [] 1846 952
29 10 1 0.77 0 0 24 73d7 1 1
0 0 3238011 0 0 0 0
1119 641 157 2014-03-22T19:51:48 0 0 0 0
utf-8 330 0 0 0 7774109565808082252 11274076
0 0 0 0 0 E 2014-03-22T11:54:54 55
2 3 4 6 [105,11,9,88,45,14,98,72,3,925,2193,6,2 [...]
4611870011201662970 0 HD Tube 5* 1 2014-03-22T05:11:29
2014-03-22 598875 4243808759 92f6fe1be9b9773206d6b63e50feb470
196 2314158381335918424 0 3 3
http://public_search yandex.ru.livemaster 0 0
[] [4,15,333,3912,14512,12818] [18,348,1010] [] 1846 952
29 10 1 0.77 0 0 24 73d7 1 1
0 0 3238011 0 0 0 0
1119 641 157 2014-03-22T19:51:48 0 0 0 0
utf-8 330 0 0 0 7774109565808082252 11274076
0 0 0 0 0 E 2014-03-22T11:54:54 55
2 3 4 6 [105,11,9,88,45,14,98,72,3,925,2193,6,2 [...]
+-- !q42 --
+215
+
+-- !q43 --
+1 100 5 1000000000 10.5 20.75 true First A
Alpha 2023-10-06 2023-10-06T14:30 123.45
+1 578 55 2111222273 56.858597 82.38111658179561
true Random C LYDUG 2023-12-17 2023-12-05T13:04:58 1393.11
+1 979 44 10163954251 28.827957 57.56879940298416
true Random Q DNRGE 2023-12-09 2023-12-10T20:21:58 1581.25
+10 1000 50 10000000000 55.25 65.75 false Tenth J
Kappa 2023-10-15 2023-10-15T23:30 1012.34
+10 210 26 8549838179 23.438345 73.36477128189287
true Random N VVXIF 2023-11-24 2023-12-13T18:04:58 226.65
+10 386 51 1214815770 13.959902 36.64197990482059
false Random J ORLGI 2023-12-18 2023-11-27T17:13:58 852.62
+10 966 38 2203748112 45.555325 27.908447208440094
true Random W LFAGO 2023-12-14 2023-11-26T20:00:58 1898.68
+100 281 26 3174393241 51.05278 52.09566669589555
false Random F SLDWB 2023-12-14 2023-12-12T07:03:58 798.30
+100 289 71 4919981667 66.56684 69.73132704711037
true Random V QOLAP 2023-12-17 2023-12-23T09:38:58 217.05
+11 1100 55 11000000000 60.5 70.0 true Eleventh
K Lambda 2023-10-16 2023-10-16T01:45 1123.45
+11 426 67 8473986652 17.942455 71.80682514420877
true Random X FXDUV 2023-12-04 2023-12-22T07:51:58 129.81
+11 441 19 7370044350 74.261696 62.013817404758086
true Random D UYKZA 2023-12-23 2023-12-15T11:49:58 1805.14
+11 487 27 14556302216 85.33334 62.596750833474495
true Random E QMHJD 2023-12-23 2023-12-24T08:30:58 1491.22
+11 770 17 7962512669 12.508753 83.33847413902296
true Random P LHJRA 2023-12-06 2023-12-04T15:48:58 970.51
+12 1200 60 12000000000 65.75 75.25 false Twelfth L
Mu 2023-10-17 2023-10-17T02:15 1234.56
+12 751 8 12205294947 23.468674 64.35048302450815
true Random K FCSBV 2023-12-03 2023-12-17T01:10:58 325.26
+12 782 48 5080583047 75.55138 49.6324463213595
true Random N WYJDW 2023-12-16 2023-12-18T02:58:58 944.42
+12 987 73 1432735571 40.308147 43.5019559828596
true Random S MZUNG 2023-12-07 2023-12-03T13:42:58 215.12
+13 1300 65 13000000000 70.0 80.5 true Thirteenth
M Nu 2023-10-18 2023-10-18T03:30 1345.67
+13 335 39 13869202091 30.426075 39.02304533093442
true Random L AULCC 2023-12-08 2023-12-13T00:26:58 387.97
+13 402 30 10851194313 74.82481 74.90108005771035
false Random F GEMMK 2023-11-27 2023-12-21T15:03:58 1643.55
+13 503 34 6763884255 23.660393 63.9797872103468
true Random S POEBK 2023-12-22 2023-12-23T23:16:58 486.62
+13 696 74 3370487489 84.544014 88.69976219408227
true Random H RTFJI 2023-11-23 2023-11-25T07:32:58 1761.50
+13 745 48 13047949175 51.168613 85.21972389262197
true Random A AYBWQ 2023-12-22 2023-12-22T16:25:58 1192.48
+13 859 65 7433576046 56.136265 34.87823331022725
false Random L CRFUF 2023-12-23 2023-12-12T15:05:58 1037.15
+14 1400 70 14000000000 75.25 85.75 false Fourteenth
N Xi 2023-10-19 2023-10-19T04:45 1456.78
+14 195 17 2370700139 16.777058 64.81793301410002
false Random P IIGRE 2023-12-12 2023-12-14T22:40:58 1678.44
+14 966 65 7828602539 62.430664 68.85873133439297
true Random I VVOQH 2023-12-01 2023-12-06T00:54:58 1300.43
+14 968 16 11314514196 62.509666 33.1841427251225
false Random T WDEVJ 2023-11-24 2023-12-06T17:54:58 431.61
+15 1500 75 15000000000 80.5 90.0 true Fifteenth
O Omicron 2023-10-20 2023-10-20T05:15 1567.89
+15 703 67 4284267079 85.38059 91.41088583496226
true Random T PHZRC 2023-12-04 2023-12-08T15:54:58 185.19
+16 135 22 7901304568 43.944805 85.16901944253635
true Random K NUQEP 2023-11-29 2023-11-25T23:42:58 1440.74
+16 615 20 12294128025 77.37379 20.42772029677839
true Random U JHPOB 2023-11-30 2023-12-16T14:29:58 1105.33
+17 289 49 13560709243 39.952793 38.245306832599425
true Random Q QEYVY 2023-12-19 2023-12-07T00:35:58 500.19
+17 499 46 11230409207 51.632103 28.811164197154774
false Random V BVLUH 2023-12-13 2023-12-23T17:59:58 1387.62
+17 646 62 11234805830 76.40492 67.46425239009778
true Random N REHZC 2023-12-09 2023-11-28T02:06:58 365.15
+17 698 55 1807368797 20.17171 43.84496606184709
true Random P SHSJV 2023-12-01 2023-11-25T11:56:58 810.95
+17 794 14 8377523030 28.07663 52.3837762020057
false Random E WPMIN 2023-12-03 2023-11-26T04:59:58 239.42
+17 913 32 4647929554 78.91502 70.54487265463735
true Random S WFPNS 2023-11-27 2023-11-26T03:29:58 321.45
+18 690 17 1399456103 63.261967 42.964715823771236
true Random R BWSRS 2023-12-13 2023-12-23T08:33:58 1840.02
+18 835 17 14265814864 18.923101 80.53531451138412
true Random V PIKUZ 2023-12-20 2023-12-21T07:39:58 1167.09
+19 917 66 2340946367 89.035675 22.649362455875274
false Random D HWHMU 2023-11-30 2023-12-10T02:36:58 1960.07
+19 993 13 7039833438 79.769066 69.79049291517285
true Random X OFSUV 2023-12-11 2023-12-08T01:46:58 1958.95
+2 200 10 2000000000 15.75 25.5 false Second B
Beta 2023-10-07 2023-10-07T15:45 234.56
+2 850 75 7075823565 83.65178 62.56093886118189
false Random F RFHAG 2023-11-24 2023-12-03T01:06:58 495.12
+2 921 62 8557914543 78.52379 58.6849882881372
false Random D KBXXS 2023-12-07 2023-12-02T22:24:58 1782.88
+2 925 46 6013180177 41.107002 34.86561026061906
true Random L XLLXY 2023-12-06 2023-12-09T14:04:58 1246.26
+20 248 64 7704906572 35.089928 76.69128821479936
true Random T KQOMS 2023-11-30 2023-12-11T01:35:58 1799.26
+22 200 41 12163439252 64.621254 81.68574929661384
true Random U KGVNU 2023-12-20 2023-11-30T14:56:58 1915.47
+22 235 19 6963606423 65.68033 54.1995295752517
true Random E ENVRH 2023-12-22 2023-11-29T14:42:58 864.89
+23 192 8 5102667616 54.111057 40.85713971600841
false Random J EBXEB 2023-12-13 2023-12-10T11:32:58 1824.12
+27 452 74 4240215371 50.569168 75.68204627611644
true Random G AZOWU 2023-12-01 2023-11-26T06:24:58 201.31
+27 866 24 5531365994 72.77447 86.96690821165853
false Random S TZPFJ 2023-11-28 2023-12-13T15:31:58 1274.75
+28 655 21 14580233860 12.503378 48.60220286874443
false Random P DUBQQ 2023-12-12 2023-12-03T20:11:58 922.42
+29 157 34 2302882987 51.924015 20.311140937696468
true Random R MBOXJ 2023-12-02 2023-12-03T14:12:58 1620.80
+29 910 52 5544039917 22.179396 46.32732226806482
true Random C TIZAG 2023-11-28 2023-12-14T16:08:58 900.96
+29 923 57 1591814253 68.57371 33.342802789892986
true Random Q ZONGC 2023-12-20 2023-12-13T09:11:58 1465.38
+3 259 74 7422478791 22.291426 75.38227773520089
true Random S VWAXJ 2023-12-01 2023-12-05T21:23:58 1970.57
+3 300 15 3000000000 20.25 30.0 true Third C
Gamma 2023-10-08 2023-10-08T16:15 345.67
+3 422 25 5996825874 89.173584 62.758513798505824
false Random Z CDYAO 2023-12-14 2023-12-08T09:27:58 567.23
+3 668 60 1942550969 83.43451 87.15906153619602
true Random F QYSRS 2023-12-22 2023-12-10T22:17:58 320.22
+30 292 71 10308444223 63.039078 76.40649540444898
false Random G DRLHY 2023-12-19 2023-12-14T15:32:58 1165.14
+30 572 6 3022031043 57.813908 72.29244668177799
true Random X EHJDN 2023-12-11 2023-12-12T02:44:58 910.38
+30 830 65 12624057029 38.791172 59.72899174862661
false Random A LFPWP 2023-12-03 2023-12-17T00:10:58 1760.62
+31 395 22 6141426904 88.37914 52.0655270963123
false Random J DRPJV 2023-12-07 2023-11-29T03:15:58 1076.41
+31 990 5 13678786851 15.762894 85.24173385692956
false Random H THGIM 2023-12-14 2023-12-09T01:24:58 1834.37
+33 198 20 13225406950 67.7327 58.63863378877107 true
Random I ZKXRA 2023-12-07 2023-11-29T02:33:58 566.76
+33 321 39 12537851805 38.26871 32.6626492245712
true Random S OICCE 2023-12-02 2023-12-19T16:41:58 306.92
+33 916 53 5666674210 57.998173 61.774881852563475
true Random J WJAXA 2023-11-27 2023-12-05T19:58:58 976.13
+34 145 44 14060350663 73.02436 68.40544929600975
true Random S UUJFP 2023-11-23 2023-12-12T06:08:58 739.45
+34 585 43 1429300527 61.706585 80.88100239373303
false Random O JKJOH 2023-12-17 2023-12-07T11:00:58 468.11
+35 297 75 2468378214 51.353462 34.18114780065386
false Random C HBYZO 2023-12-05 2023-12-09T21:42:58 534.70
+37 438 39 6809169396 83.56728 40.90894521029911
true Random W GXPAY 2023-12-07 2023-12-18T06:35:58 383.18
+38 606 57 14585148556 82.67463 79.18300302689997
false Random E RSFUZ 2023-12-16 2023-11-27T18:55:58 970.25
+39 726 50 3865644066 26.225628 28.534393094364418
false Random F NIUCS 2023-12-05 2023-12-04T19:31:58 1953.82
+4 122 24 10738473173 81.15482 60.21481394154484
false Random Y PQJRK 2023-12-20 2023-12-09T02:38:58 1467.35
+4 400 20 4000000000 25.5 35.25 false Fourth D
Delta 2023-10-09 2023-10-09T17:30 456.78
+4 569 72 10560903405 50.255936 47.535145739285184
false Random O NRIRC 2023-12-05 2023-12-01T09:10:58 1986.99
+4 682 22 2040832636 60.33469 67.33499498711046
true Random W QUICJ 2023-11-24 2023-12-14T10:17:58 579.56
+40 230 34 10824964541 16.929768 53.812277279703366
false Random F YDQHF 2023-12-14 2023-12-03T17:42:58 1623.79
+40 693 69 13276482882 44.35974 82.57845708670757
true Random B RCCSU 2023-11-29 2023-12-01T20:11:58 183.64
+40 914 7 4902128502 19.442041 33.099787387344406
true Random Q KOCWA 2023-11-28 2023-12-21T09:20:58 1824.80
+41 344 34 14536795918 56.660946 84.15108995619764
false Random Q KYLCH 2023-12-10 2023-12-04T08:25:58 1902.09
+41 599 54 8095449906 22.58196 37.99742597458578
false Random T GTQXP 2023-12-12 2023-12-22T19:08:58 743.46
+41 697 21 1200243566 12.466168 68.57243624557165
true Random U JZGEG 2023-12-03 2023-12-10T04:51:58 1323.88
+41 708 64 11745827370 72.84812 35.31028363777645
true Random O WGSQC 2023-12-02 2023-11-25T17:07:58 1666.71
+41 840 65 8988241658 37.428593 42.25992474748068
false Random E HURYX 2023-12-22 2023-12-19T01:55:58 141.89
+42 143 42 3421815721 65.27691 87.91368867538209
true Random S AXGVL 2023-12-06 2023-11-29T07:36:58 575.01
+42 178 38 7559404453 69.69449 64.37154501388798
true Random G QUMUN 2023-12-14 2023-12-17T01:37:58 1190.44
+42 192 28 14454791024 35.465202 46.34876515635648
false Random W NQFGR 2023-12-04 2023-11-24T05:02:58 1428.02
+42 355 72 11536856285 74.42886 53.49032479461299
false Random I IQZEI 2023-12-10 2023-12-06T07:17:58 1098.14
+43 178 64 6969956763 40.980415 52.998828731408516
true Random C XQHYB 2023-12-11 2023-12-07T23:00:58 257.08
+43 828 24 12011396947 45.07647 54.2136449479346
true Random E HIDUO 2023-12-02 2023-12-19T01:14:58 233.10
+44 219 38 8596488294 73.52956 94.10797854680568
true Random E HMWBI 2023-12-15 2023-12-06T00:51:58 1907.47
+44 694 55 3626514138 62.504086 72.89799265418553
true Random Z JTDVF 2023-12-01 2023-11-29T12:08:58 1769.92
+44 912 63 8534761366 55.993538 50.235171557550416
false Random N OVQRQ 2023-12-08 2023-11-24T03:39:58 264.92
+44 928 7 1939079012 14.426672 68.86451571230457
false Random I EKVWY 2023-12-15 2023-12-09T10:43:58 846.74
+45 455 25 12639246000 47.011307 26.310712594958694
false Random Z GGEUA 2023-11-27 2023-12-01T20:41:58 1698.21
+45 492 43 3870916386 51.069588 42.652270406300794
true Random H JVZTB 2023-12-04 2023-12-09T21:06:58 1517.83
+47 508 48 1456473942 48.488297 20.377955902326608
false Random B CAOEY 2023-11-29 2023-12-10T14:49:58 1865.52
+47 566 50 1426586688 51.278687 40.47151456873397
true Random F YBOSH 2023-11-26 2023-12-15T03:44:58 1806.35
+47 838 73 14910230294 83.69784 82.28901816600579
true Random L SHXYL 2023-11-24 2023-12-05T22:19:58 1062.15
+48 898 59 12871187130 10.13838 70.19705104611333
true Random J WFXNN 2023-12-23 2023-12-17T02:53:58 1050.21
+49 165 38 4482178563 34.706547 69.17129468406594
false Random W CPZNY 2023-12-15 2023-11-23T19:56:58 512.60
+49 412 16 8300982793 56.263252 66.07893608061771
false Random K DWWJI 2023-12-08 2023-12-17T11:32:58 1718.54
+49 511 51 8602055259 88.1686 88.98712207285577 false
Random M ZDKEY 2023-12-10 2023-11-25T02:44:58 241.08
+49 568 70 2916596630 79.16303 56.114316916863025
false Random T ILLIU 2023-11-23 2023-12-07T11:05:58 1039.03
+5 500 25 5000000000 30.75 40.5 true Fifth E
Epsilon 2023-10-10 2023-10-10T18:45 567.89
+5 768 5 4152322228 41.128906 78.60686390712706
false Random J LXKRA 2023-12-05 2023-11-24T18:13:58 1941.98
+5 823 63 13328808917 77.768196 22.87975226738422
false Random F OIYPV 2023-12-11 2023-12-14T06:43:58 1144.38
+5 887 74 4082758600 22.797577 93.28246034891224
false Random V MPPGX 2023-12-01 2023-11-29T01:53:58 510.50
+50 126 58 4433111715 75.31828 43.28056186824247
false Random H UTDJF 2023-12-19 2023-12-10T08:24:58 368.42
+51 778 59 13914307584 27.48499 91.47665081887983
true Random X FGFHK 2023-12-01 2023-12-10T03:24:58 402.63
+51 898 32 13510411411 18.679659 21.406761033351007
false Random L FECUW 2023-12-10 2023-12-14T02:00:58 700.43
+52 811 31 14085958816 51.067017 65.01991893789116
true Random A CODYQ 2023-12-03 2023-12-07T23:25:58 1797.21
+53 505 52 9862728376 58.40501 57.60544454281924
false Random V WYCTZ 2023-11-24 2023-12-20T05:13:58 210.43
+53 667 49 10531976747 50.22229 49.64660893042742
false Random K WNRJE 2023-12-04 2023-12-19T14:57:58 680.97
+53 713 14 1464447148 23.474258 45.35056918414047
false Random Q UHMLT 2023-12-10 2023-11-30T02:07:58 286.70
+53 715 29 10917905565 41.83069 93.50885201221966
true Random U TRLSY 2023-12-03 2023-11-26T15:13:58 369.72
+54 467 42 13684826428 38.491455 90.10566649802195
true Random M ERFBG 2023-11-24 2023-12-02T16:23:58 211.00
+54 827 55 7054839267 58.555687 25.891004802115663
false Random O ASMLW 2023-12-13 2023-12-20T16:41:58 1369.32
+54 843 34 9547939940 38.66475 36.370944299232434
true Random P NTVIR 2023-12-12 2023-12-02T06:45:58 1628.37
+55 908 24 13623721787 40.06427 90.85281792731746
false Random B KFZGI 2023-11-27 2023-12-23T18:06:58 1124.95
+55 964 8 14038541765 70.24135 20.034551391620194
false Random J AYXIT 2023-12-13 2023-12-16T19:38:58 1476.73
+57 936 26 12164628867 56.541275 56.276679149397076
true Random O IPHPZ 2023-12-13 2023-11-30T22:36:58 603.68
+59 144 31 6208909394 67.417076 40.59765633709834
true Random D FLWNA 2023-12-12 2023-12-19T06:17:58 1870.24
+59 509 50 5501336408 39.94401 73.35770882761237
true Random I PVZNO 2023-12-04 2023-11-27T04:40:58 1177.33
+6 600 30 6000000000 35.25 45.75 false Sixth F
Zeta 2023-10-11 2023-10-11T19:15 678.90
+60 711 69 1493870104 22.574188 61.30347648465907
false Random E FHKVR 2023-11-27 2023-12-05T11:26:58 1981.61
+60 875 42 14283877167 48.811504 67.0706975606688
true Random P VJOZH 2023-12-06 2023-12-15T05:20:58 781.71
+61 267 61 11407448558 12.877184 42.144845857251944
true Random B NRWNW 2023-11-30 2023-11-25T09:34:58 859.85
+61 414 63 14506877706 12.540966 58.04557426323987
false Random H NUOAD 2023-12-10 2023-12-06T22:52:58 780.50
+62 451 50 12304139502 51.151623 22.46754141558852
false Random C SRRSV 2023-12-08 2023-12-20T02:48:58 1352.65
+62 793 46 7308804595 39.766644 48.88672198076526
true Random V TPENZ 2023-11-26 2023-12-23T17:51:58 388.46
+63 112 75 12197306353 85.90137 43.48931389222043
false Random C KKAIT 2023-11-27 2023-12-23T04:23:58 1954.90
+63 383 35 5161212745 39.455276 52.33267523851794
false Random X TMYMC 2023-11-29 2023-12-10T09:09:58 1442.54
+63 410 33 1767102777 72.260124 56.971483381024896
false Random B QXNSM 2023-12-12 2023-12-19T22:57:58 1660.73
+64 479 20 1710421528 53.324104 33.55443503561635
false Random Q ONZRK 2023-12-09 2023-12-01T22:29:58 252.13
+64 678 14 13681447851 74.83621 36.94143092647816
true Random J KELFB 2023-12-01 2023-12-07T18:14:58 308.26
+64 719 36 1224510454 64.237434 86.05689694804887
true Random E ZVQPU 2023-11-30 2023-12-03T04:56:58 1879.25
+64 822 26 1154241961 52.165447 26.779469377773403
true Random E YWNAD 2023-12-08 2023-12-19T19:08:58 731.15
+65 571 24 10523050555 45.865078 70.80680527390149
true Random Y DILBW 2023-12-17 2023-11-25T22:41:58 859.30
+66 306 5 14448160602 44.642223 50.24249889525751
false Random X OASEB 2023-12-11 2023-11-27T00:16:58 1345.69
+66 521 30 7757576974 69.440155 92.3562810104632
false Random H SSOCR 2023-12-19 2023-11-30T06:51:58 913.34
+67 484 65 10817432713 62.168163 77.02869166077757
true Random K SAJMG 2023-12-19 2023-12-14T19:47:58 488.01
+68 266 31 8183454755 69.19586 23.139304803938643
false Random S STCBM 2023-11-26 2023-12-22T13:42:58 1722.37
+68 554 33 3525526216 29.078024 29.6567390059356
false Random Y EUGOF 2023-11-23 2023-12-15T10:33:58 395.41
+68 591 60 4813122821 33.210274 54.464145718507616
false Random X EXROI 2023-12-07 2023-12-07T00:39:58 290.11
+68 756 63 5416393421 66.41538 76.32820339134415
false Random Y CUNAL 2023-12-23 2023-12-14T22:49:58 1109.25
+68 922 13 11664232196 72.683266 37.9910331525765
false Random W PPWBB 2023-11-26 2023-12-10T22:54:58 1968.89
+68 947 60 7257499958 45.661217 77.42577781358565
false Random F ENQGA 2023-11-24 2023-11-29T07:33:58 319.99
+69 416 14 7702410607 31.638903 89.5793904314531
true Random C URQMU 2023-11-25 2023-11-30T15:17:58 1379.22
+7 340 50 8934567449 83.79683 35.39446967734915
false Random L CWYFN 2023-12-05 2023-12-23T02:26:58 806.15
+7 700 35 7000000000 40.5 50.0 true Seventh G
Eta 2023-10-12 2023-10-12T20:30 789.01
+7 969 62 3451343234 57.17074 56.74513811095188
false Random G OWDSC 2023-12-19 2023-12-11T17:17:58 1874.22
+70 231 67 4547989149 35.103123 51.93622592177748
true Random V ZBCVY 2023-11-29 2023-12-22T11:41:58 1749.60
+70 421 23 3153379289 27.412096 79.32006404438445
false Random L VLJWK 2023-12-04 2023-12-12T05:31:58 1163.35
+70 751 56 7828222634 52.8313 55.7263634552559 true
Random B TFHMH 2023-11-30 2023-12-24T12:22:58 1166.13
+71 452 25 4464808420 18.155642 61.988641984596185
false Random K YXFVY 2023-12-15 2023-12-08T04:58:58 514.74
+71 594 26 1024634104 62.92234 37.216752731371386
true Random J SPUWU 2023-12-04 2023-12-23T08:50:58 779.97
+72 377 11 3042707243 55.289066 53.72552524152444
true Random Q BAPHV 2023-12-06 2023-11-30T07:14:58 119.39
+73 866 49 4618070115 46.803646 91.41305051885227
true Random H ROYYF 2023-12-07 2023-12-01T10:28:58 1817.67
+74 670 60 4783926122 23.513939 91.24357097091087
true Random Y YFPMC 2023-12-23 2023-12-22T22:29:58 943.62
+75 368 73 6944888766 31.500992 56.88267149430107
false Random H LEXKZ 2023-12-21 2023-12-14T01:12:58 443.91
+76 410 20 10425110604 66.26356 92.68329033006493
false Random L JHFYD 2023-11-23 2023-11-29T10:34:58 867.56
+76 504 70 14161652666 58.071503 67.99111956708262
true Random Y HAVCK 2023-11-27 2023-12-14T16:08:58 1864.98
+77 131 19 2964167114 33.23181 53.35246738882714
false Random G AHGFO 2023-12-19 2023-12-01T10:11:58 1837.90
+77 165 36 12887722637 19.729382 45.61157603163882
true Random S OZOLB 2023-12-02 2023-12-03T05:07:58 1576.79
+79 314 17 6823498005 22.562634 72.70049796639023
true Random K FPSNZ 2023-12-07 2023-12-15T11:52:58 211.50
+8 550 48 13655992126 52.90345 51.35114230137935
false Random X JTVSE 2023-12-13 2023-12-15T03:49:58 361.55
+8 800 40 8000000000 45.75 55.25 false Eighth H
Theta 2023-10-13 2023-10-13T21:45 890.12
+8 866 37 13672147880 81.28999 67.66548594336737
false Random H QDJIM 2023-12-14 2023-12-17T18:44:58 1112.05
+80 267 57 8797946135 35.604717 80.51381110359165
false Random K KQTEX 2023-12-09 2023-12-13T06:19:58 1769.15
+80 815 19 14529289205 19.769405 37.37008094684765
true Random Z WLALH 2023-12-11 2023-12-14T03:24:58 479.38
+81 726 66 9327218218 81.50363 39.9702863173827
true Random X WODRP 2023-11-28 2023-12-23T13:25:58 561.98
+82 107 51 1358006007 78.36581 46.09413324325159
true Random C IPNQU 2023-12-01 2023-12-14T05:41:58 417.17
+82 133 60 4616538638 88.8813 30.82745983013354 true
Random W KPIJE 2023-12-20 2023-12-01T07:57:58 583.41
+82 531 44 10642962933 26.818586 23.851865471979615
false Random F NMQOD 2023-12-13 2023-12-18T19:34:58 861.78
+82 603 60 9083469993 81.24088 44.46228092092543
true Random Y WTQGU 2023-11-30 2023-11-28T13:18:58 1448.45
+82 982 62 8955063933 81.2855 78.30439669511465 true
Random J SOCOT 2023-12-02 2023-12-02T21:17:58 814.60
+83 700 46 4569093424 50.063602 47.75811273142146
false Random R TEGAY 2023-12-19 2023-12-07T06:46:58 760.22
+84 427 60 9035762847 81.971306 28.37315065501099
true Random L FETYF 2023-12-01 2023-11-24T15:00:58 1267.12
+85 375 63 6797318130 85.47522 58.16330728665678
true Random E UNZLS 2023-12-01 2023-12-04T05:17:58 1949.48
+85 845 42 2373712244 74.551315 79.15491248184088
false Random B QJRKO 2023-11-29 2023-12-04T09:20:58 317.17
+85 873 18 7233488476 33.83051 31.655950581225508
false Random N RJTIB 2023-11-23 2023-12-11T15:07:58 1249.52
+86 398 27 13222936963 20.387327 44.51255195842424
true Random T ZCRFI 2023-12-21 2023-12-23T12:04:58 1801.53
+86 662 53 8875065706 28.64778 30.6775849729486
false Random N YNQAY 2023-12-15 2023-11-24T21:56:58 1108.35
+86 728 18 13390353484 61.060482 87.44751616093882
false Random J BUCVI 2023-12-07 2023-12-14T23:00:58 1611.17
+86 998 74 11080891106 82.568756 32.0122101203062
true Random K VAAMT 2023-12-23 2023-12-01T10:14:58 1708.39
+87 145 64 9022533179 37.80205 63.26081178595084
true Random T PEOPK 2023-12-08 2023-12-07T17:41:58 1167.05
+87 641 64 4786767059 14.765089 70.8793353664754
false Random W SQHGN 2023-12-12 2023-12-24T01:19:58 1316.61
+88 274 41 14108849690 73.74919 42.625751442467404
true Random X BVRFA 2023-12-01 2023-11-25T14:32:58 515.18
+88 728 59 8439434199 30.372904 59.410283344764366
false Random F JODWY 2023-12-04 2023-12-01T07:57:58 1753.88
+88 765 69 9753682777 83.42646 25.99260711248508
true Random M MEJAX 2023-11-25 2023-12-20T09:21:58 1647.22
+89 129 64 6400162051 67.910965 80.48074661432221
true Random Y ZXJWQ 2023-12-16 2023-12-19T10:23:58 1882.65
+89 377 22 14340881803 32.61157 82.5503801214006
false Random K ACYZU 2023-12-01 2023-11-27T02:05:58 672.13
+89 964 41 12706120446 69.484116 32.39048200771184
true Random J IIRNY 2023-12-16 2023-11-29T01:54:58 1298.71
+9 113 7 6162580854 11.346889 46.82839094332704
false Random A SJTAF 2023-12-14 2023-11-23T18:27:58 1610.49
+9 268 59 8149280252 86.66627 70.91298799618343
false Random E PVKYK 2023-12-21 2023-11-25T00:28:58 263.17
+9 900 45 9000000000 50.0 60.5 true Ninth I
Iota 2023-10-14 2023-10-14T22:15 901.23
+9 907 24 6113036809 66.06377 50.26485838775805
true Random X XLPOL 2023-11-23 2023-12-02T09:03:58 256.61
+90 391 26 12874761259 21.49042 53.46850617467312
true Random Q QTJPE 2023-12-17 2023-12-03T17:40:58 748.05
+91 389 11 14784237986 11.174142 27.692284427565397
true Random P DYILB 2023-12-14 2023-12-21T11:07:58 1175.73
+91 528 68 14588592231 77.4651 88.92064181463138 false
Random U JXZUA 2023-12-16 2023-12-21T02:28:58 1834.07
+92 344 29 5182139341 31.653255 44.26814517218887
true Random F NGHOS 2023-12-06 2023-12-09T21:25:58 1291.06
+93 887 20 13555948969 70.57364 32.621532934876804
false Random D SPMEK 2023-11-26 2023-12-20T18:11:58 258.86
+94 216 49 8773264156 81.617195 43.03983700523827
true Random D VHWYT 2023-12-13 2023-11-30T07:03:58 1178.27
+94 693 60 4818659234 26.04229 83.2975107272106
true Random B ENSQO 2023-12-22 2023-12-12T06:08:58 1283.81
+95 560 62 1389447643 19.202044 85.46518830161321
true Random S LQRRB 2023-12-16 2023-12-12T06:12:58 445.65
+96 595 72 11506136303 21.917727 74.74561804277158
true Random T SPLKA 2023-12-02 2023-11-30T00:39:58 1693.61
+96 637 39 5516035994 55.90832 60.522041012562816
true Random O YPETL 2023-12-02 2023-11-28T02:47:58 1175.16
+97 415 74 10346322649 21.667427 46.58901867647463
false Random R KWFOF 2023-12-21 2023-11-27T12:18:58 1157.72
+97 839 60 14818779777 46.17389 68.98285340004992
false Random W HMFPU 2023-12-01 2023-12-04T08:41:58 1683.48
+98 228 65 4782017237 55.10206 31.414570993700565
true Random P EOIFT 2023-12-07 2023-12-15T08:12:58 137.49
+99 632 39 8911195323 74.581276 78.2764804276292
false Random Q WTQCL 2023-12-02 2023-12-05T09:18:58 200.21
+
+-- !q44 --
+17 289 49 13560709243 39.952793 38.245306832599425
true Random Q QEYVY 2023-12-19 2023-12-07T00:35:58 500.19
+17 499 46 11230409207 51.632103 28.811164197154774
false Random V BVLUH 2023-12-13 2023-12-23T17:59:58 1387.62
+17 646 62 11234805830 76.40492 67.46425239009778
true Random N REHZC 2023-12-09 2023-11-28T02:06:58 365.15
+17 698 55 1807368797 20.17171 43.84496606184709
true Random P SHSJV 2023-12-01 2023-11-25T11:56:58 810.95
+17 794 14 8377523030 28.07663 52.3837762020057
false Random E WPMIN 2023-12-03 2023-11-26T04:59:58 239.42
+17 913 32 4647929554 78.91502 70.54487265463735
true Random S WFPNS 2023-11-27 2023-11-26T03:29:58 321.45
+
+-- !q45 --
+11 1100 55 11000000000 60.5 70.0 true Eleventh
K Lambda 2023-10-16 2023-10-16T01:45 1123.45
+11 487 27 14556302216 85.33334 62.596750833474495
true Random E QMHJD 2023-12-23 2023-12-24T08:30:58 1491.22
+12 1200 60 12000000000 65.75 75.25 false Twelfth L
Mu 2023-10-17 2023-10-17T02:15 1234.56
+12 751 8 12205294947 23.468674 64.35048302450815
true Random K FCSBV 2023-12-03 2023-12-17T01:10:58 325.26
+13 1300 65 13000000000 70.0 80.5 true Thirteenth
M Nu 2023-10-18 2023-10-18T03:30 1345.67
+13 335 39 13869202091 30.426075 39.02304533093442
true Random L AULCC 2023-12-08 2023-12-13T00:26:58 387.97
+13 402 30 10851194313 74.82481 74.90108005771035
false Random F GEMMK 2023-11-27 2023-12-21T15:03:58 1643.55
+13 745 48 13047949175 51.168613 85.21972389262197
true Random A AYBWQ 2023-12-22 2023-12-22T16:25:58 1192.48
+14 1400 70 14000000000 75.25 85.75 false Fourteenth
N Xi 2023-10-19 2023-10-19T04:45 1456.78
+14 968 16 11314514196 62.509666 33.1841427251225
false Random T WDEVJ 2023-11-24 2023-12-06T17:54:58 431.61
+15 1500 75 15000000000 80.5 90.0 true Fifteenth
O Omicron 2023-10-20 2023-10-20T05:15 1567.89
+16 615 20 12294128025 77.37379 20.42772029677839
true Random U JHPOB 2023-11-30 2023-12-16T14:29:58 1105.33
+17 289 49 13560709243 39.952793 38.245306832599425
true Random Q QEYVY 2023-12-19 2023-12-07T00:35:58 500.19
+17 499 46 11230409207 51.632103 28.811164197154774
false Random V BVLUH 2023-12-13 2023-12-23T17:59:58 1387.62
+17 646 62 11234805830 76.40492 67.46425239009778
true Random N REHZC 2023-12-09 2023-11-28T02:06:58 365.15
+18 835 17 14265814864 18.923101 80.53531451138412
true Random V PIKUZ 2023-12-20 2023-12-21T07:39:58 1167.09
+22 200 41 12163439252 64.621254 81.68574929661384
true Random U KGVNU 2023-12-20 2023-11-30T14:56:58 1915.47
+28 655 21 14580233860 12.503378 48.60220286874443
false Random P DUBQQ 2023-12-12 2023-12-03T20:11:58 922.42
+30 830 65 12624057029 38.791172 59.72899174862661
false Random A LFPWP 2023-12-03 2023-12-17T00:10:58 1760.62
+31 990 5 13678786851 15.762894 85.24173385692956
false Random H THGIM 2023-12-14 2023-12-09T01:24:58 1834.37
+33 198 20 13225406950 67.7327 58.63863378877107 true
Random I ZKXRA 2023-12-07 2023-11-29T02:33:58 566.76
+33 321 39 12537851805 38.26871 32.6626492245712
true Random S OICCE 2023-12-02 2023-12-19T16:41:58 306.92
+34 145 44 14060350663 73.02436 68.40544929600975
true Random S UUJFP 2023-11-23 2023-12-12T06:08:58 739.45
+38 606 57 14585148556 82.67463 79.18300302689997
false Random E RSFUZ 2023-12-16 2023-11-27T18:55:58 970.25
+4 122 24 10738473173 81.15482 60.21481394154484
false Random Y PQJRK 2023-12-20 2023-12-09T02:38:58 1467.35
+40 230 34 10824964541 16.929768 53.812277279703366
false Random F YDQHF 2023-12-14 2023-12-03T17:42:58 1623.79
+40 693 69 13276482882 44.35974 82.57845708670757
true Random B RCCSU 2023-11-29 2023-12-01T20:11:58 183.64
+41 344 34 14536795918 56.660946 84.15108995619764
false Random Q KYLCH 2023-12-10 2023-12-04T08:25:58 1902.09
+41 708 64 11745827370 72.84812 35.31028363777645
true Random O WGSQC 2023-12-02 2023-11-25T17:07:58 1666.71
+42 192 28 14454791024 35.465202 46.34876515635648
false Random W NQFGR 2023-12-04 2023-11-24T05:02:58 1428.02
+42 355 72 11536856285 74.42886 53.49032479461299
false Random I IQZEI 2023-12-10 2023-12-06T07:17:58 1098.14
+43 828 24 12011396947 45.07647 54.2136449479346
true Random E HIDUO 2023-12-02 2023-12-19T01:14:58 233.10
+45 455 25 12639246000 47.011307 26.310712594958694
false Random Z GGEUA 2023-11-27 2023-12-01T20:41:58 1698.21
+47 838 73 14910230294 83.69784 82.28901816600579
true Random L SHXYL 2023-11-24 2023-12-05T22:19:58 1062.15
+48 898 59 12871187130 10.13838 70.19705104611333
true Random J WFXNN 2023-12-23 2023-12-17T02:53:58 1050.21
+5 823 63 13328808917 77.768196 22.87975226738422
false Random F OIYPV 2023-12-11 2023-12-14T06:43:58 1144.38
+51 778 59 13914307584 27.48499 91.47665081887983
true Random X FGFHK 2023-12-01 2023-12-10T03:24:58 402.63
+51 898 32 13510411411 18.679659 21.406761033351007
false Random L FECUW 2023-12-10 2023-12-14T02:00:58 700.43
+52 811 31 14085958816 51.067017 65.01991893789116
true Random A CODYQ 2023-12-03 2023-12-07T23:25:58 1797.21
+53 715 29 10917905565 41.83069 93.50885201221966
true Random U TRLSY 2023-12-03 2023-11-26T15:13:58 369.72
+54 467 42 13684826428 38.491455 90.10566649802195
true Random M ERFBG 2023-11-24 2023-12-02T16:23:58 211.00
+55 908 24 13623721787 40.06427 90.85281792731746
false Random B KFZGI 2023-11-27 2023-12-23T18:06:58 1124.95
+55 964 8 14038541765 70.24135 20.034551391620194
false Random J AYXIT 2023-12-13 2023-12-16T19:38:58 1476.73
+57 936 26 12164628867 56.541275 56.276679149397076
true Random O IPHPZ 2023-12-13 2023-11-30T22:36:58 603.68
+60 875 42 14283877167 48.811504 67.0706975606688
true Random P VJOZH 2023-12-06 2023-12-15T05:20:58 781.71
+61 267 61 11407448558 12.877184 42.144845857251944
true Random B NRWNW 2023-11-30 2023-11-25T09:34:58 859.85
+61 414 63 14506877706 12.540966 58.04557426323987
false Random H NUOAD 2023-12-10 2023-12-06T22:52:58 780.50
+62 451 50 12304139502 51.151623 22.46754141558852
false Random C SRRSV 2023-12-08 2023-12-20T02:48:58 1352.65
+63 112 75 12197306353 85.90137 43.48931389222043
false Random C KKAIT 2023-11-27 2023-12-23T04:23:58 1954.90
+64 678 14 13681447851 74.83621 36.94143092647816
true Random J KELFB 2023-12-01 2023-12-07T18:14:58 308.26
+66 306 5 14448160602 44.642223 50.24249889525751
false Random X OASEB 2023-12-11 2023-11-27T00:16:58 1345.69
+67 484 65 10817432713 62.168163 77.02869166077757
true Random K SAJMG 2023-12-19 2023-12-14T19:47:58 488.01
+68 922 13 11664232196 72.683266 37.9910331525765
false Random W PPWBB 2023-11-26 2023-12-10T22:54:58 1968.89
+76 504 70 14161652666 58.071503 67.99111956708262
true Random Y HAVCK 2023-11-27 2023-12-14T16:08:58 1864.98
+77 165 36 12887722637 19.729382 45.61157603163882
true Random S OZOLB 2023-12-02 2023-12-03T05:07:58 1576.79
+8 550 48 13655992126 52.90345 51.35114230137935
false Random X JTVSE 2023-12-13 2023-12-15T03:49:58 361.55
+8 866 37 13672147880 81.28999 67.66548594336737
false Random H QDJIM 2023-12-14 2023-12-17T18:44:58 1112.05
+80 815 19 14529289205 19.769405 37.37008094684765
true Random Z WLALH 2023-12-11 2023-12-14T03:24:58 479.38
+86 398 27 13222936963 20.387327 44.51255195842424
true Random T ZCRFI 2023-12-21 2023-12-23T12:04:58 1801.53
+86 728 18 13390353484 61.060482 87.44751616093882
false Random J BUCVI 2023-12-07 2023-12-14T23:00:58 1611.17
+86 998 74 11080891106 82.568756 32.0122101203062
true Random K VAAMT 2023-12-23 2023-12-01T10:14:58 1708.39
+88 274 41 14108849690 73.74919 42.625751442467404
true Random X BVRFA 2023-12-01 2023-11-25T14:32:58 515.18
+89 377 22 14340881803 32.61157 82.5503801214006
false Random K ACYZU 2023-12-01 2023-11-27T02:05:58 672.13
+89 964 41 12706120446 69.484116 32.39048200771184
true Random J IIRNY 2023-12-16 2023-11-29T01:54:58 1298.71
+90 391 26 12874761259 21.49042 53.46850617467312
true Random Q QTJPE 2023-12-17 2023-12-03T17:40:58 748.05
+91 389 11 14784237986 11.174142 27.692284427565397
true Random P DYILB 2023-12-14 2023-12-21T11:07:58 1175.73
+91 528 68 14588592231 77.4651 88.92064181463138 false
Random U JXZUA 2023-12-16 2023-12-21T02:28:58 1834.07
+93 887 20 13555948969 70.57364 32.621532934876804
false Random D SPMEK 2023-11-26 2023-12-20T18:11:58 258.86
+96 595 72 11506136303 21.917727 74.74561804277158
true Random T SPLKA 2023-12-02 2023-11-30T00:39:58 1693.61
+97 839 60 14818779777 46.17389 68.98285340004992
false Random W HMFPU 2023-12-01 2023-12-04T08:41:58 1683.48
+
+-- !q46 --
+1 578 55 2111222273 56.858597 82.38111658179561
true Random C LYDUG 2023-12-17 2023-12-05T13:04:58 1393.11
+29 910 52 5544039917 22.179396 46.32732226806482
true Random C TIZAG 2023-11-28 2023-12-14T16:08:58 900.96
+3 300 15 3000000000 20.25 30.0 true Third C
Gamma 2023-10-08 2023-10-08T16:15 345.67
+43 178 64 6969956763 40.980415 52.998828731408516
true Random C XQHYB 2023-12-11 2023-12-07T23:00:58 257.08
+69 416 14 7702410607 31.638903 89.5793904314531
true Random C URQMU 2023-11-25 2023-11-30T15:17:58 1379.22
+82 107 51 1358006007 78.36581 46.09413324325159
true Random C IPNQU 2023-12-01 2023-12-14T05:41:58 417.17
+
+-- !q47 --
+1 578 55 2111222273 56.858597 82.38111658179561
true Random C LYDUG 2023-12-17 2023-12-05T13:04:58 1393.11
+1 979 44 10163954251 28.827957 57.56879940298416
true Random Q DNRGE 2023-12-09 2023-12-10T20:21:58 1581.25
+10 1000 50 10000000000 55.25 65.75 false Tenth J
Kappa 2023-10-15 2023-10-15T23:30 1012.34
+10 966 38 2203748112 45.555325 27.908447208440094
true Random W LFAGO 2023-12-14 2023-11-26T20:00:58 1898.68
+11 1100 55 11000000000 60.5 70.0 true Eleventh
K Lambda 2023-10-16 2023-10-16T01:45 1123.45
+11 441 19 7370044350 74.261696 62.013817404758086
true Random D UYKZA 2023-12-23 2023-12-15T11:49:58 1805.14
+11 487 27 14556302216 85.33334 62.596750833474495
true Random E QMHJD 2023-12-23 2023-12-24T08:30:58 1491.22
+12 1200 60 12000000000 65.75 75.25 false Twelfth L
Mu 2023-10-17 2023-10-17T02:15 1234.56
+13 1300 65 13000000000 70.0 80.5 true Thirteenth
M Nu 2023-10-18 2023-10-18T03:30 1345.67
+13 402 30 10851194313 74.82481 74.90108005771035
false Random F GEMMK 2023-11-27 2023-12-21T15:03:58 1643.55
+13 696 74 3370487489 84.544014 88.69976219408227
true Random H RTFJI 2023-11-23 2023-11-25T07:32:58 1761.50
+13 745 48 13047949175 51.168613 85.21972389262197
true Random A AYBWQ 2023-12-22 2023-12-22T16:25:58 1192.48
+13 859 65 7433576046 56.136265 34.87823331022725
false Random L CRFUF 2023-12-23 2023-12-12T15:05:58 1037.15
+14 1400 70 14000000000 75.25 85.75 false Fourteenth
N Xi 2023-10-19 2023-10-19T04:45 1456.78
+14 195 17 2370700139 16.777058 64.81793301410002
false Random P IIGRE 2023-12-12 2023-12-14T22:40:58 1678.44
+14 966 65 7828602539 62.430664 68.85873133439297
true Random I VVOQH 2023-12-01 2023-12-06T00:54:58 1300.43
+15 1500 75 15000000000 80.5 90.0 true Fifteenth
O Omicron 2023-10-20 2023-10-20T05:15 1567.89
+16 135 22 7901304568 43.944805 85.16901944253635
true Random K NUQEP 2023-11-29 2023-11-25T23:42:58 1440.74
+16 615 20 12294128025 77.37379 20.42772029677839
true Random U JHPOB 2023-11-30 2023-12-16T14:29:58 1105.33
+17 499 46 11230409207 51.632103 28.811164197154774
false Random V BVLUH 2023-12-13 2023-12-23T17:59:58 1387.62
+18 690 17 1399456103 63.261967 42.964715823771236
true Random R BWSRS 2023-12-13 2023-12-23T08:33:58 1840.02
+18 835 17 14265814864 18.923101 80.53531451138412
true Random V PIKUZ 2023-12-20 2023-12-21T07:39:58 1167.09
+19 917 66 2340946367 89.035675 22.649362455875274
false Random D HWHMU 2023-11-30 2023-12-10T02:36:58 1960.07
+19 993 13 7039833438 79.769066 69.79049291517285
true Random X OFSUV 2023-12-11 2023-12-08T01:46:58 1958.95
+2 921 62 8557914543 78.52379 58.6849882881372
false Random D KBXXS 2023-12-07 2023-12-02T22:24:58 1782.88
+2 925 46 6013180177 41.107002 34.86561026061906
true Random L XLLXY 2023-12-06 2023-12-09T14:04:58 1246.26
+20 248 64 7704906572 35.089928 76.69128821479936
true Random T KQOMS 2023-11-30 2023-12-11T01:35:58 1799.26
+22 200 41 12163439252 64.621254 81.68574929661384
true Random U KGVNU 2023-12-20 2023-11-30T14:56:58 1915.47
+23 192 8 5102667616 54.111057 40.85713971600841
false Random J EBXEB 2023-12-13 2023-12-10T11:32:58 1824.12
+27 866 24 5531365994 72.77447 86.96690821165853
false Random S TZPFJ 2023-11-28 2023-12-13T15:31:58 1274.75
+29 157 34 2302882987 51.924015 20.311140937696468
true Random R MBOXJ 2023-12-02 2023-12-03T14:12:58 1620.80
+29 923 57 1591814253 68.57371 33.342802789892986
true Random Q ZONGC 2023-12-20 2023-12-13T09:11:58 1465.38
+3 259 74 7422478791 22.291426 75.38227773520089
true Random S VWAXJ 2023-12-01 2023-12-05T21:23:58 1970.57
+30 292 71 10308444223 63.039078 76.40649540444898
false Random G DRLHY 2023-12-19 2023-12-14T15:32:58 1165.14
+30 830 65 12624057029 38.791172 59.72899174862661
false Random A LFPWP 2023-12-03 2023-12-17T00:10:58 1760.62
+31 395 22 6141426904 88.37914 52.0655270963123
false Random J DRPJV 2023-12-07 2023-11-29T03:15:58 1076.41
+31 990 5 13678786851 15.762894 85.24173385692956
false Random H THGIM 2023-12-14 2023-12-09T01:24:58 1834.37
+39 726 50 3865644066 26.225628 28.534393094364418
false Random F NIUCS 2023-12-05 2023-12-04T19:31:58 1953.82
+4 122 24 10738473173 81.15482 60.21481394154484
false Random Y PQJRK 2023-12-20 2023-12-09T02:38:58 1467.35
+4 569 72 10560903405 50.255936 47.535145739285184
false Random O NRIRC 2023-12-05 2023-12-01T09:10:58 1986.99
+40 230 34 10824964541 16.929768 53.812277279703366
false Random F YDQHF 2023-12-14 2023-12-03T17:42:58 1623.79
+40 914 7 4902128502 19.442041 33.099787387344406
true Random Q KOCWA 2023-11-28 2023-12-21T09:20:58 1824.80
+41 344 34 14536795918 56.660946 84.15108995619764
false Random Q KYLCH 2023-12-10 2023-12-04T08:25:58 1902.09
+41 697 21 1200243566 12.466168 68.57243624557165
true Random U JZGEG 2023-12-03 2023-12-10T04:51:58 1323.88
+41 708 64 11745827370 72.84812 35.31028363777645
true Random O WGSQC 2023-12-02 2023-11-25T17:07:58 1666.71
+42 178 38 7559404453 69.69449 64.37154501388798
true Random G QUMUN 2023-12-14 2023-12-17T01:37:58 1190.44
+42 192 28 14454791024 35.465202 46.34876515635648
false Random W NQFGR 2023-12-04 2023-11-24T05:02:58 1428.02
+42 355 72 11536856285 74.42886 53.49032479461299
false Random I IQZEI 2023-12-10 2023-12-06T07:17:58 1098.14
+44 219 38 8596488294 73.52956 94.10797854680568
true Random E HMWBI 2023-12-15 2023-12-06T00:51:58 1907.47
+44 694 55 3626514138 62.504086 72.89799265418553
true Random Z JTDVF 2023-12-01 2023-11-29T12:08:58 1769.92
+45 455 25 12639246000 47.011307 26.310712594958694
false Random Z GGEUA 2023-11-27 2023-12-01T20:41:58 1698.21
+45 492 43 3870916386 51.069588 42.652270406300794
true Random H JVZTB 2023-12-04 2023-12-09T21:06:58 1517.83
+47 508 48 1456473942 48.488297 20.377955902326608
false Random B CAOEY 2023-11-29 2023-12-10T14:49:58 1865.52
+47 566 50 1426586688 51.278687 40.47151456873397
true Random F YBOSH 2023-11-26 2023-12-15T03:44:58 1806.35
+47 838 73 14910230294 83.69784 82.28901816600579
true Random L SHXYL 2023-11-24 2023-12-05T22:19:58 1062.15
+48 898 59 12871187130 10.13838 70.19705104611333
true Random J WFXNN 2023-12-23 2023-12-17T02:53:58 1050.21
+49 412 16 8300982793 56.263252 66.07893608061771
false Random K DWWJI 2023-12-08 2023-12-17T11:32:58 1718.54
+49 568 70 2916596630 79.16303 56.114316916863025
false Random T ILLIU 2023-11-23 2023-12-07T11:05:58 1039.03
+5 768 5 4152322228 41.128906 78.60686390712706
false Random J LXKRA 2023-12-05 2023-11-24T18:13:58 1941.98
+5 823 63 13328808917 77.768196 22.87975226738422
false Random F OIYPV 2023-12-11 2023-12-14T06:43:58 1144.38
+52 811 31 14085958816 51.067017 65.01991893789116
true Random A CODYQ 2023-12-03 2023-12-07T23:25:58 1797.21
+54 827 55 7054839267 58.555687 25.891004802115663
false Random O ASMLW 2023-12-13 2023-12-20T16:41:58 1369.32
+54 843 34 9547939940 38.66475 36.370944299232434
true Random P NTVIR 2023-12-12 2023-12-02T06:45:58 1628.37
+55 908 24 13623721787 40.06427 90.85281792731746
false Random B KFZGI 2023-11-27 2023-12-23T18:06:58 1124.95
+55 964 8 14038541765 70.24135 20.034551391620194
false Random J AYXIT 2023-12-13 2023-12-16T19:38:58 1476.73
+59 144 31 6208909394 67.417076 40.59765633709834
true Random D FLWNA 2023-12-12 2023-12-19T06:17:58 1870.24
+59 509 50 5501336408 39.94401 73.35770882761237
true Random I PVZNO 2023-12-04 2023-11-27T04:40:58 1177.33
+60 711 69 1493870104 22.574188 61.30347648465907
false Random E FHKVR 2023-11-27 2023-12-05T11:26:58 1981.61
+62 451 50 12304139502 51.151623 22.46754141558852
false Random C SRRSV 2023-12-08 2023-12-20T02:48:58 1352.65
+63 112 75 12197306353 85.90137 43.48931389222043
false Random C KKAIT 2023-11-27 2023-12-23T04:23:58 1954.90
+63 383 35 5161212745 39.455276 52.33267523851794
false Random X TMYMC 2023-11-29 2023-12-10T09:09:58 1442.54
+63 410 33 1767102777 72.260124 56.971483381024896
false Random B QXNSM 2023-12-12 2023-12-19T22:57:58 1660.73
+64 719 36 1224510454 64.237434 86.05689694804887
true Random E ZVQPU 2023-11-30 2023-12-03T04:56:58 1879.25
+66 306 5 14448160602 44.642223 50.24249889525751
false Random X OASEB 2023-12-11 2023-11-27T00:16:58 1345.69
+68 266 31 8183454755 69.19586 23.139304803938643
false Random S STCBM 2023-11-26 2023-12-22T13:42:58 1722.37
+68 756 63 5416393421 66.41538 76.32820339134415
false Random Y CUNAL 2023-12-23 2023-12-14T22:49:58 1109.25
+68 922 13 11664232196 72.683266 37.9910331525765
false Random W PPWBB 2023-11-26 2023-12-10T22:54:58 1968.89
+69 416 14 7702410607 31.638903 89.5793904314531
true Random C URQMU 2023-11-25 2023-11-30T15:17:58 1379.22
+7 969 62 3451343234 57.17074 56.74513811095188
false Random G OWDSC 2023-12-19 2023-12-11T17:17:58 1874.22
+70 231 67 4547989149 35.103123 51.93622592177748
true Random V ZBCVY 2023-11-29 2023-12-22T11:41:58 1749.60
+70 421 23 3153379289 27.412096 79.32006404438445
false Random L VLJWK 2023-12-04 2023-12-12T05:31:58 1163.35
+70 751 56 7828222634 52.8313 55.7263634552559 true
Random B TFHMH 2023-11-30 2023-12-24T12:22:58 1166.13
+73 866 49 4618070115 46.803646 91.41305051885227
true Random H ROYYF 2023-12-07 2023-12-01T10:28:58 1817.67
+76 504 70 14161652666 58.071503 67.99111956708262
true Random Y HAVCK 2023-11-27 2023-12-14T16:08:58 1864.98
+77 131 19 2964167114 33.23181 53.35246738882714
false Random G AHGFO 2023-12-19 2023-12-01T10:11:58 1837.90
+77 165 36 12887722637 19.729382 45.61157603163882
true Random S OZOLB 2023-12-02 2023-12-03T05:07:58 1576.79
+8 866 37 13672147880 81.28999 67.66548594336737
false Random H QDJIM 2023-12-14 2023-12-17T18:44:58 1112.05
+80 267 57 8797946135 35.604717 80.51381110359165
false Random K KQTEX 2023-12-09 2023-12-13T06:19:58 1769.15
+82 603 60 9083469993 81.24088 44.46228092092543
true Random Y WTQGU 2023-11-30 2023-11-28T13:18:58 1448.45
+84 427 60 9035762847 81.971306 28.37315065501099
true Random L FETYF 2023-12-01 2023-11-24T15:00:58 1267.12
+85 375 63 6797318130 85.47522 58.16330728665678
true Random E UNZLS 2023-12-01 2023-12-04T05:17:58 1949.48
+85 873 18 7233488476 33.83051 31.655950581225508
false Random N RJTIB 2023-11-23 2023-12-11T15:07:58 1249.52
+86 398 27 13222936963 20.387327 44.51255195842424
true Random T ZCRFI 2023-12-21 2023-12-23T12:04:58 1801.53
+86 662 53 8875065706 28.64778 30.6775849729486
false Random N YNQAY 2023-12-15 2023-11-24T21:56:58 1108.35
+86 728 18 13390353484 61.060482 87.44751616093882
false Random J BUCVI 2023-12-07 2023-12-14T23:00:58 1611.17
+86 998 74 11080891106 82.568756 32.0122101203062
true Random K VAAMT 2023-12-23 2023-12-01T10:14:58 1708.39
+87 145 64 9022533179 37.80205 63.26081178595084
true Random T PEOPK 2023-12-08 2023-12-07T17:41:58 1167.05
+87 641 64 4786767059 14.765089 70.8793353664754
false Random W SQHGN 2023-12-12 2023-12-24T01:19:58 1316.61
+88 728 59 8439434199 30.372904 59.410283344764366
false Random F JODWY 2023-12-04 2023-12-01T07:57:58 1753.88
+88 765 69 9753682777 83.42646 25.99260711248508
true Random M MEJAX 2023-11-25 2023-12-20T09:21:58 1647.22
+89 129 64 6400162051 67.910965 80.48074661432221
true Random Y ZXJWQ 2023-12-16 2023-12-19T10:23:58 1882.65
+89 964 41 12706120446 69.484116 32.39048200771184
true Random J IIRNY 2023-12-16 2023-11-29T01:54:58 1298.71
+9 113 7 6162580854 11.346889 46.82839094332704
false Random A SJTAF 2023-12-14 2023-11-23T18:27:58 1610.49
+91 389 11 14784237986 11.174142 27.692284427565397
true Random P DYILB 2023-12-14 2023-12-21T11:07:58 1175.73
+91 528 68 14588592231 77.4651 88.92064181463138 false
Random U JXZUA 2023-12-16 2023-12-21T02:28:58 1834.07
+92 344 29 5182139341 31.653255 44.26814517218887
true Random F NGHOS 2023-12-06 2023-12-09T21:25:58 1291.06
+94 216 49 8773264156 81.617195 43.03983700523827
true Random D VHWYT 2023-12-13 2023-11-30T07:03:58 1178.27
+94 693 60 4818659234 26.04229 83.2975107272106
true Random B ENSQO 2023-12-22 2023-12-12T06:08:58 1283.81
+96 595 72 11506136303 21.917727 74.74561804277158
true Random T SPLKA 2023-12-02 2023-11-30T00:39:58 1693.61
+96 637 39 5516035994 55.90832 60.522041012562816
true Random O YPETL 2023-12-02 2023-11-28T02:47:58 1175.16
+97 415 74 10346322649 21.667427 46.58901867647463
false Random R KWFOF 2023-12-21 2023-11-27T12:18:58 1157.72
+97 839 60 14818779777 46.17389 68.98285340004992
false Random W HMFPU 2023-12-01 2023-12-04T08:41:58 1683.48
+
+-- !q48 --
+1 100 5 1000000000 10.5 20.75 true First A
Alpha 2023-10-06 2023-10-06T14:30 123.45
+10 1000 50 10000000000 55.25 65.75 false Tenth J
Kappa 2023-10-15 2023-10-15T23:30 1012.34
+11 1100 55 11000000000 60.5 70.0 true Eleventh
K Lambda 2023-10-16 2023-10-16T01:45 1123.45
+12 1200 60 12000000000 65.75 75.25 false Twelfth L
Mu 2023-10-17 2023-10-17T02:15 1234.56
+13 1300 65 13000000000 70.0 80.5 true Thirteenth
M Nu 2023-10-18 2023-10-18T03:30 1345.67
+14 1400 70 14000000000 75.25 85.75 false Fourteenth
N Xi 2023-10-19 2023-10-19T04:45 1456.78
+15 1500 75 15000000000 80.5 90.0 true Fifteenth
O Omicron 2023-10-20 2023-10-20T05:15 1567.89
+2 200 10 2000000000 15.75 25.5 false Second B
Beta 2023-10-07 2023-10-07T15:45 234.56
+3 300 15 3000000000 20.25 30.0 true Third C
Gamma 2023-10-08 2023-10-08T16:15 345.67
+4 400 20 4000000000 25.5 35.25 false Fourth D
Delta 2023-10-09 2023-10-09T17:30 456.78
+5 500 25 5000000000 30.75 40.5 true Fifth E
Epsilon 2023-10-10 2023-10-10T18:45 567.89
+6 600 30 6000000000 35.25 45.75 false Sixth F
Zeta 2023-10-11 2023-10-11T19:15 678.90
+7 700 35 7000000000 40.5 50.0 true Seventh G
Eta 2023-10-12 2023-10-12T20:30 789.01
+8 800 40 8000000000 45.75 55.25 false Eighth H
Theta 2023-10-13 2023-10-13T21:45 890.12
+9 900 45 9000000000 50.0 60.5 true Ninth I
Iota 2023-10-14 2023-10-14T22:15 901.23
+
diff --git
a/regression-test/suites/external_table_p2/hive/test_compress_type.groovy
b/regression-test/suites/external_table_p2/hive/test_compress_type.groovy
index d02ff3fbd0c..585e8691690 100644
--- a/regression-test/suites/external_table_p2/hive/test_compress_type.groovy
+++ b/regression-test/suites/external_table_p2/hive/test_compress_type.groovy
@@ -57,5 +57,32 @@ suite("test_compress_type",
"p2,external,hive,external_remote,external_remote_hi
qt_q32 """select count(*) from test_compress_partitioned"""
order_qt_q33 """select * from test_compress_partitioned where
watchid=4611870011201662970"""
sql """set file_split_size=0"""
+
+
+ order_qt_q42 """ select count(*) from parquet_lz4_compression ;
"""
+ order_qt_q43 """ select * from parquet_lz4_compression
+ order by
col_int,col_smallint,col_tinyint,col_bigint,col_float,col_double,col_boolean,col_string,col_char,col_varchar,col_date,col_timestamp,col_decimal
+ """
+
+ order_qt_q44 """ select * from parquet_lz4_compression where col_int =
17
+ order by
col_int,col_smallint,col_tinyint,col_bigint,col_float,col_double,col_boolean,col_string,col_char,col_varchar,col_date,col_timestamp,col_decimal
+ """
+
+ order_qt_q45 """ select * from parquet_lz4_compression where
col_bigint >= 10738473173
+ order by
col_int,col_smallint,col_tinyint,col_bigint,col_float,col_double,col_boolean,col_string,col_char,col_varchar,col_date,col_timestamp,col_decimal
+ """
+
+ order_qt_q46 """ select * from parquet_lz4_compression where
col_boolean = 1 and col_char='C'
+ order by
col_int,col_smallint,col_tinyint,col_bigint,col_float,col_double,col_boolean,col_string,col_char,col_varchar,col_date,col_timestamp,col_decimal
+ """
+
+ order_qt_q47 """ select * from parquet_lz4_compression where
col_decimal >= 1000
+ order by
col_int,col_smallint,col_tinyint,col_bigint,col_float,col_double,col_boolean,col_string,col_char,col_varchar,col_date,col_timestamp,col_decimal
+ """
+
+ order_qt_q48 """ select * from parquet_lz4_compression where
col_string != "Random"
+ order by
col_int,col_smallint,col_tinyint,col_bigint,col_float,col_double,col_boolean,col_string,col_char,col_varchar,col_date,col_timestamp,col_decimal
+ """
+
}
}
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
