This is an automated email from the ASF dual-hosted git repository.
morningman pushed a commit to branch branch-2.1
in repository https://gitbox.apache.org/repos/asf/doris.git
The following commit(s) were added to refs/heads/branch-2.1 by this push:
new fcc26cc6713 [test](migrate) move some cases from p2 to p0
(#36750)(#36787) (#36922)
fcc26cc6713 is described below
commit fcc26cc6713a1a0a1eb4c8533d7c7f7038dc4e77
Author: Mingyu Chen <morning...@163.com>
AuthorDate: Thu Jun 27 20:59:50 2024 +0800
[test](migrate) move some cases from p2 to p0 (#36750)(#36787) (#36922)
bp #36750 and #36787
---
.licenserc.yaml | 1 +
.../data/multi_catalog/datev2_csv/create_table.hql | 20 +
.../data/multi_catalog/datev2_csv/data.tar.gz | Bin 0 -> 184 bytes
.../scripts/data/multi_catalog/datev2_csv/run.sh | 13 +
.../data/multi_catalog/datev2_orc/create_table.hql | 20 +
.../data/multi_catalog/datev2_orc/data.tar.gz | Bin 0 -> 459 bytes
.../scripts/data/multi_catalog/datev2_orc/run.sh | 13 +
.../multi_catalog/datev2_parquet/create_table.hql | 20 +
.../data/multi_catalog/datev2_parquet/data.tar.gz | Bin 0 -> 384 bytes
.../data/multi_catalog/datev2_parquet/run.sh | 13 +
.../hive_upper_case_orc/create_table.hql | 21 +
.../multi_catalog/hive_upper_case_orc/data.tar.gz | Bin 0 -> 521 bytes
.../data/multi_catalog/hive_upper_case_orc/run.sh | 13 +
.../hive_upper_case_parquet/create_table.hql | 21 +
.../hive_upper_case_parquet/data.tar.gz | Bin 0 -> 690 bytes
.../multi_catalog/hive_upper_case_parquet/run.sh | 13 +
.../parquet_lz4_compression/create_table.hql | 31 ++
.../parquet_lz4_compression/data.tar.gz | Bin 0 -> 11375 bytes
.../multi_catalog/parquet_lz4_compression/run.sh | 13 +
.../parquet_lzo_compression/create_table.hql | 31 ++
.../parquet_lzo_compression/data.tar.gz | Bin 0 -> 28433 bytes
.../multi_catalog/parquet_lzo_compression/run.sh | 13 +
.../test_compress_partitioned/create_table.hql | 152 ++++++
.../multi_catalog/test_compress_partitioned/run.sh | 22 +
.../data/regression/crdmm_data/create_table.hql | 162 ++++++
.../scripts/data/regression/crdmm_data/data.tar.gz | Bin 0 -> 2035 bytes
.../hive/scripts/data/regression/crdmm_data/run.sh | 14 +
.../docker-compose/hive/scripts/hive-metastore.sh | 23 +-
docker/thirdparties/run-thirdparties-docker.sh | 24 +
.../hive/test_external_credit_data.out | 12 +
.../hive/test_hive_compress_type.out} | 572 +++++++++++++++++++++
.../hive/test_hive_to_date.out | 24 +
.../hive/test_upper_case_column_name.out | 89 ++++
.../hive/hive_tpch_sf1_orc.groovy | 4 +-
.../hive/hive_tpch_sf1_parquet.groovy | 4 +-
.../hive/test_external_credit_data.groovy | 29 +-
.../hive/test_hive_compress_type.groovy} | 39 +-
.../hive/test_hive_to_date.groovy | 37 +-
.../hive/test_upper_case_column_name.groovy | 103 ++++
39 files changed, 1497 insertions(+), 69 deletions(-)
diff --git a/.licenserc.yaml b/.licenserc.yaml
index 3f41200df2e..7412436a9c1 100644
--- a/.licenserc.yaml
+++ b/.licenserc.yaml
@@ -82,6 +82,7 @@ header:
- "docker/thirdparties/docker-compose/hive/scripts/create_tpch1_orc.hql"
-
"docker/thirdparties/docker-compose/hive/scripts/create_tpch1_parquet.hql"
- "docker/thirdparties/docker-compose/hive/scripts/preinstalled_data/"
+ - "docker/thirdparties/docker-compose/hive/scripts/data/**"
- "docker/thirdparties/docker-compose/iceberg/spark-defaults.conf.tpl"
- "conf/mysql_ssl_default_certificate/*"
- "conf/mysql_ssl_default_certificate/client_certificate/ca.pem"
diff --git
a/docker/thirdparties/docker-compose/hive/scripts/data/multi_catalog/datev2_csv/create_table.hql
b/docker/thirdparties/docker-compose/hive/scripts/data/multi_catalog/datev2_csv/create_table.hql
new file mode 100644
index 00000000000..2fb4b46dec4
--- /dev/null
+++
b/docker/thirdparties/docker-compose/hive/scripts/data/multi_catalog/datev2_csv/create_table.hql
@@ -0,0 +1,20 @@
+create database if not exists multi_catalog;
+
+use multi_catalog;
+
+CREATE external TABLE `datev2_csv`(
+ `id` int,
+ `day` date)
+ROW FORMAT SERDE
+ 'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'
+STORED AS INPUTFORMAT
+ 'org.apache.hadoop.mapred.TextInputFormat'
+OUTPUTFORMAT
+ 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'
+LOCATION
+ '/user/doris/suites/multi_catalog/datev2_csv'
+TBLPROPERTIES (
+ 'transient_lastDdlTime'='1688118691');
+
+msck repair table datev2_csv;
+
diff --git
a/docker/thirdparties/docker-compose/hive/scripts/data/multi_catalog/datev2_csv/data.tar.gz
b/docker/thirdparties/docker-compose/hive/scripts/data/multi_catalog/datev2_csv/data.tar.gz
new file mode 100644
index 00000000000..2c0bff2d8d1
Binary files /dev/null and
b/docker/thirdparties/docker-compose/hive/scripts/data/multi_catalog/datev2_csv/data.tar.gz
differ
diff --git
a/docker/thirdparties/docker-compose/hive/scripts/data/multi_catalog/datev2_csv/run.sh
b/docker/thirdparties/docker-compose/hive/scripts/data/multi_catalog/datev2_csv/run.sh
new file mode 100755
index 00000000000..cc8392b9baa
--- /dev/null
+++
b/docker/thirdparties/docker-compose/hive/scripts/data/multi_catalog/datev2_csv/run.sh
@@ -0,0 +1,13 @@
+#!/bin/bash
+set -x
+
+CUR_DIR="$(cd "$(dirname "${BASH_SOURCE[0]}")" &>/dev/null && pwd)"
+
+## mkdir and put data to hdfs
+cd "${CUR_DIR}" && rm -rf data/ && tar xzf data.tar.gz
+hadoop fs -mkdir -p /user/doris/suites/multi_catalog/
+hadoop fs -put "${CUR_DIR}"/data/* /user/doris/suites/multi_catalog/
+
+# create table
+hive -f "${CUR_DIR}/create_table.hql"
+
diff --git
a/docker/thirdparties/docker-compose/hive/scripts/data/multi_catalog/datev2_orc/create_table.hql
b/docker/thirdparties/docker-compose/hive/scripts/data/multi_catalog/datev2_orc/create_table.hql
new file mode 100644
index 00000000000..8d42608b213
--- /dev/null
+++
b/docker/thirdparties/docker-compose/hive/scripts/data/multi_catalog/datev2_orc/create_table.hql
@@ -0,0 +1,20 @@
+create database if not exists multi_catalog;
+
+use multi_catalog;
+
+CREATE external TABLE `datev2_orc`(
+ `id` int,
+ `day` date)
+ROW FORMAT SERDE
+ 'org.apache.hadoop.hive.ql.io.orc.OrcSerde'
+STORED AS INPUTFORMAT
+ 'org.apache.hadoop.hive.ql.io.orc.OrcInputFormat'
+OUTPUTFORMAT
+ 'org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat'
+LOCATION
+ '/user/doris/suites/multi_catalog/datev2_orc'
+TBLPROPERTIES (
+ 'transient_lastDdlTime'='1688118707');
+
+msck repair table datev2_orc;
+
diff --git
a/docker/thirdparties/docker-compose/hive/scripts/data/multi_catalog/datev2_orc/data.tar.gz
b/docker/thirdparties/docker-compose/hive/scripts/data/multi_catalog/datev2_orc/data.tar.gz
new file mode 100644
index 00000000000..ff541e10c10
Binary files /dev/null and
b/docker/thirdparties/docker-compose/hive/scripts/data/multi_catalog/datev2_orc/data.tar.gz
differ
diff --git
a/docker/thirdparties/docker-compose/hive/scripts/data/multi_catalog/datev2_orc/run.sh
b/docker/thirdparties/docker-compose/hive/scripts/data/multi_catalog/datev2_orc/run.sh
new file mode 100755
index 00000000000..7c2e7e7aed2
--- /dev/null
+++
b/docker/thirdparties/docker-compose/hive/scripts/data/multi_catalog/datev2_orc/run.sh
@@ -0,0 +1,13 @@
+#!/bin/bash
+set -x
+
+CUR_DIR="$(cd "$(dirname "${BASH_SOURCE[0]}")" &>/dev/null && pwd)"
+
+## mkdir and put data to hdfs
+cd "${CUR_DIR}" && rm -rf data/ && tar xzf data.tar.gz
+hadoop fs -mkdir -p /user/doris/suites/multi_catalog/
+hadoop fs -put "${CUR_DIR}"/data/* /user/doris/suites/multi_catalog/
+
+# create table
+hive -f "${CUR_DIR}"/create_table.hql
+
diff --git
a/docker/thirdparties/docker-compose/hive/scripts/data/multi_catalog/datev2_parquet/create_table.hql
b/docker/thirdparties/docker-compose/hive/scripts/data/multi_catalog/datev2_parquet/create_table.hql
new file mode 100644
index 00000000000..c0932f2dfbc
--- /dev/null
+++
b/docker/thirdparties/docker-compose/hive/scripts/data/multi_catalog/datev2_parquet/create_table.hql
@@ -0,0 +1,20 @@
+create database if not exists multi_catalog;
+
+use multi_catalog;
+
+CREATE external TABLE `datev2_parquet`(
+ `id` int,
+ `day` date)
+ROW FORMAT SERDE
+ 'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'
+STORED AS INPUTFORMAT
+ 'org.apache.hadoop.hive.ql.io.parquet.MapredParquetInputFormat'
+OUTPUTFORMAT
+ 'org.apache.hadoop.hive.ql.io.parquet.MapredParquetOutputFormat'
+LOCATION
+ '/user/doris/suites/multi_catalog/datev2_parquet'
+TBLPROPERTIES (
+ 'transient_lastDdlTime'='1688118725');
+
+msck repair table datev2_parquet;
+
diff --git
a/docker/thirdparties/docker-compose/hive/scripts/data/multi_catalog/datev2_parquet/data.tar.gz
b/docker/thirdparties/docker-compose/hive/scripts/data/multi_catalog/datev2_parquet/data.tar.gz
new file mode 100644
index 00000000000..4bfa877a527
Binary files /dev/null and
b/docker/thirdparties/docker-compose/hive/scripts/data/multi_catalog/datev2_parquet/data.tar.gz
differ
diff --git
a/docker/thirdparties/docker-compose/hive/scripts/data/multi_catalog/datev2_parquet/run.sh
b/docker/thirdparties/docker-compose/hive/scripts/data/multi_catalog/datev2_parquet/run.sh
new file mode 100755
index 00000000000..7c2e7e7aed2
--- /dev/null
+++
b/docker/thirdparties/docker-compose/hive/scripts/data/multi_catalog/datev2_parquet/run.sh
@@ -0,0 +1,13 @@
+#!/bin/bash
+set -x
+
+CUR_DIR="$(cd "$(dirname "${BASH_SOURCE[0]}")" &>/dev/null && pwd)"
+
+## mkdir and put data to hdfs
+cd "${CUR_DIR}" && rm -rf data/ && tar xzf data.tar.gz
+hadoop fs -mkdir -p /user/doris/suites/multi_catalog/
+hadoop fs -put "${CUR_DIR}"/data/* /user/doris/suites/multi_catalog/
+
+# create table
+hive -f "${CUR_DIR}"/create_table.hql
+
diff --git
a/docker/thirdparties/docker-compose/hive/scripts/data/multi_catalog/hive_upper_case_orc/create_table.hql
b/docker/thirdparties/docker-compose/hive/scripts/data/multi_catalog/hive_upper_case_orc/create_table.hql
new file mode 100644
index 00000000000..033d8cde3e3
--- /dev/null
+++
b/docker/thirdparties/docker-compose/hive/scripts/data/multi_catalog/hive_upper_case_orc/create_table.hql
@@ -0,0 +1,21 @@
+create database if not exists multi_catalog;
+use multi_catalog;
+
+CREATE TABLE `hive_upper_case_orc`(
+ `id` int,
+ `name` string)
+ROW FORMAT SERDE
+ 'org.apache.hadoop.hive.ql.io.orc.OrcSerde'
+STORED AS INPUTFORMAT
+ 'org.apache.hadoop.hive.ql.io.orc.OrcInputFormat'
+OUTPUTFORMAT
+ 'org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat'
+LOCATION
+ '/user/doris/suites/multi_catalog/hive_upper_case_orc'
+TBLPROPERTIES (
+ 'spark.sql.create.version'='3.2.1',
+
'spark.sql.sources.schema'='{"type":"struct","fields":[{"name":"ID","type":"integer","nullable":true,"metadata":{}},{"name":"NAME","type":"string","nullable":true,"metadata":{}}]}',
+ 'transient_lastDdlTime'='1674189057');
+
+msck repair table hive_upper_case_orc;
+
diff --git
a/docker/thirdparties/docker-compose/hive/scripts/data/multi_catalog/hive_upper_case_orc/data.tar.gz
b/docker/thirdparties/docker-compose/hive/scripts/data/multi_catalog/hive_upper_case_orc/data.tar.gz
new file mode 100644
index 00000000000..a8a4deb2ac9
Binary files /dev/null and
b/docker/thirdparties/docker-compose/hive/scripts/data/multi_catalog/hive_upper_case_orc/data.tar.gz
differ
diff --git
a/docker/thirdparties/docker-compose/hive/scripts/data/multi_catalog/hive_upper_case_orc/run.sh
b/docker/thirdparties/docker-compose/hive/scripts/data/multi_catalog/hive_upper_case_orc/run.sh
new file mode 100755
index 00000000000..7c2e7e7aed2
--- /dev/null
+++
b/docker/thirdparties/docker-compose/hive/scripts/data/multi_catalog/hive_upper_case_orc/run.sh
@@ -0,0 +1,13 @@
+#!/bin/bash
+set -x
+
+CUR_DIR="$(cd "$(dirname "${BASH_SOURCE[0]}")" &>/dev/null && pwd)"
+
+## mkdir and put data to hdfs
+cd "${CUR_DIR}" && rm -rf data/ && tar xzf data.tar.gz
+hadoop fs -mkdir -p /user/doris/suites/multi_catalog/
+hadoop fs -put "${CUR_DIR}"/data/* /user/doris/suites/multi_catalog/
+
+# create table
+hive -f "${CUR_DIR}"/create_table.hql
+
diff --git
a/docker/thirdparties/docker-compose/hive/scripts/data/multi_catalog/hive_upper_case_parquet/create_table.hql
b/docker/thirdparties/docker-compose/hive/scripts/data/multi_catalog/hive_upper_case_parquet/create_table.hql
new file mode 100644
index 00000000000..9ae91fd9c50
--- /dev/null
+++
b/docker/thirdparties/docker-compose/hive/scripts/data/multi_catalog/hive_upper_case_parquet/create_table.hql
@@ -0,0 +1,21 @@
+create database if not exists multi_catalog;
+use multi_catalog;
+
+CREATE TABLE `hive_upper_case_parquet`(
+ `id` int,
+ `name` string)
+ROW FORMAT SERDE
+ 'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'
+STORED AS INPUTFORMAT
+ 'org.apache.hadoop.hive.ql.io.parquet.MapredParquetInputFormat'
+OUTPUTFORMAT
+ 'org.apache.hadoop.hive.ql.io.parquet.MapredParquetOutputFormat'
+LOCATION
+ '/user/doris/suites/multi_catalog/hive_upper_case_parquet'
+TBLPROPERTIES (
+ 'spark.sql.create.version'='3.2.1',
+
'spark.sql.sources.schema'='{"type":"struct","fields":[{"name":"ID","type":"integer","nullable":true,"metadata":{}},{"name":"NAME","type":"string","nullable":true,"metadata":{}}]}',
+ 'transient_lastDdlTime'='1674189051');
+
+msck repair table hive_upper_case_parquet;
+
diff --git
a/docker/thirdparties/docker-compose/hive/scripts/data/multi_catalog/hive_upper_case_parquet/data.tar.gz
b/docker/thirdparties/docker-compose/hive/scripts/data/multi_catalog/hive_upper_case_parquet/data.tar.gz
new file mode 100644
index 00000000000..91616a35e94
Binary files /dev/null and
b/docker/thirdparties/docker-compose/hive/scripts/data/multi_catalog/hive_upper_case_parquet/data.tar.gz
differ
diff --git
a/docker/thirdparties/docker-compose/hive/scripts/data/multi_catalog/hive_upper_case_parquet/run.sh
b/docker/thirdparties/docker-compose/hive/scripts/data/multi_catalog/hive_upper_case_parquet/run.sh
new file mode 100755
index 00000000000..7c2e7e7aed2
--- /dev/null
+++
b/docker/thirdparties/docker-compose/hive/scripts/data/multi_catalog/hive_upper_case_parquet/run.sh
@@ -0,0 +1,13 @@
+#!/bin/bash
+set -x
+
+CUR_DIR="$(cd "$(dirname "${BASH_SOURCE[0]}")" &>/dev/null && pwd)"
+
+## mkdir and put data to hdfs
+cd "${CUR_DIR}" && rm -rf data/ && tar xzf data.tar.gz
+hadoop fs -mkdir -p /user/doris/suites/multi_catalog/
+hadoop fs -put "${CUR_DIR}"/data/* /user/doris/suites/multi_catalog/
+
+# create table
+hive -f "${CUR_DIR}"/create_table.hql
+
diff --git
a/docker/thirdparties/docker-compose/hive/scripts/data/multi_catalog/parquet_lz4_compression/create_table.hql
b/docker/thirdparties/docker-compose/hive/scripts/data/multi_catalog/parquet_lz4_compression/create_table.hql
new file mode 100644
index 00000000000..0e18e0b5465
--- /dev/null
+++
b/docker/thirdparties/docker-compose/hive/scripts/data/multi_catalog/parquet_lz4_compression/create_table.hql
@@ -0,0 +1,31 @@
+create database if not exists multi_catalog;
+use multi_catalog;
+
+CREATE TABLE `parquet_lz4_compression`(
+ `col_int` int,
+ `col_smallint` smallint,
+ `col_tinyint` tinyint,
+ `col_bigint` bigint,
+ `col_float` float,
+ `col_double` double,
+ `col_boolean` boolean,
+ `col_string` string,
+ `col_char` char(10),
+ `col_varchar` varchar(25),
+ `col_date` date,
+ `col_timestamp` timestamp,
+ `col_decimal` decimal(10,2))
+ROW FORMAT SERDE
+ 'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'
+STORED AS INPUTFORMAT
+ 'org.apache.hadoop.hive.ql.io.parquet.MapredParquetInputFormat'
+OUTPUTFORMAT
+ 'org.apache.hadoop.hive.ql.io.parquet.MapredParquetOutputFormat'
+LOCATION
+ '/user/doris/suites/multi_catalog/parquet_lz4_compression'
+TBLPROPERTIES (
+ 'parquet.compression'='LZ4',
+ 'transient_lastDdlTime'='1700723950');
+
+msck repair table parquet_lz4_compression;
+
diff --git
a/docker/thirdparties/docker-compose/hive/scripts/data/multi_catalog/parquet_lz4_compression/data.tar.gz
b/docker/thirdparties/docker-compose/hive/scripts/data/multi_catalog/parquet_lz4_compression/data.tar.gz
new file mode 100644
index 00000000000..bb26e0f45d2
Binary files /dev/null and
b/docker/thirdparties/docker-compose/hive/scripts/data/multi_catalog/parquet_lz4_compression/data.tar.gz
differ
diff --git
a/docker/thirdparties/docker-compose/hive/scripts/data/multi_catalog/parquet_lz4_compression/run.sh
b/docker/thirdparties/docker-compose/hive/scripts/data/multi_catalog/parquet_lz4_compression/run.sh
new file mode 100755
index 00000000000..7c2e7e7aed2
--- /dev/null
+++
b/docker/thirdparties/docker-compose/hive/scripts/data/multi_catalog/parquet_lz4_compression/run.sh
@@ -0,0 +1,13 @@
+#!/bin/bash
+set -x
+
+CUR_DIR="$(cd "$(dirname "${BASH_SOURCE[0]}")" &>/dev/null && pwd)"
+
+## mkdir and put data to hdfs
+cd "${CUR_DIR}" && rm -rf data/ && tar xzf data.tar.gz
+hadoop fs -mkdir -p /user/doris/suites/multi_catalog/
+hadoop fs -put "${CUR_DIR}"/data/* /user/doris/suites/multi_catalog/
+
+# create table
+hive -f "${CUR_DIR}"/create_table.hql
+
diff --git
a/docker/thirdparties/docker-compose/hive/scripts/data/multi_catalog/parquet_lzo_compression/create_table.hql
b/docker/thirdparties/docker-compose/hive/scripts/data/multi_catalog/parquet_lzo_compression/create_table.hql
new file mode 100644
index 00000000000..7c0921692d2
--- /dev/null
+++
b/docker/thirdparties/docker-compose/hive/scripts/data/multi_catalog/parquet_lzo_compression/create_table.hql
@@ -0,0 +1,31 @@
+create database if not exists multi_catalog;
+use multi_catalog;
+
+CREATE TABLE `parquet_lzo_compression`(
+ `col_int` int,
+ `col_smallint` smallint,
+ `col_tinyint` tinyint,
+ `col_bigint` bigint,
+ `col_float` float,
+ `col_double` double,
+ `col_boolean` boolean,
+ `col_string` string,
+ `col_char` char(10),
+ `col_varchar` varchar(25),
+ `col_date` date,
+ `col_timestamp` timestamp,
+ `col_decimal` decimal(10,2))
+ROW FORMAT SERDE
+ 'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'
+STORED AS INPUTFORMAT
+ 'org.apache.hadoop.hive.ql.io.parquet.MapredParquetInputFormat'
+OUTPUTFORMAT
+ 'org.apache.hadoop.hive.ql.io.parquet.MapredParquetOutputFormat'
+LOCATION
+ '/user/doris/suites/multi_catalog/parquet_lzo_compression'
+TBLPROPERTIES (
+ 'parquet.compression'='LZO',
+ 'transient_lastDdlTime'='1701173147');
+
+msck repair table parquet_lzo_compression;
+
diff --git
a/docker/thirdparties/docker-compose/hive/scripts/data/multi_catalog/parquet_lzo_compression/data.tar.gz
b/docker/thirdparties/docker-compose/hive/scripts/data/multi_catalog/parquet_lzo_compression/data.tar.gz
new file mode 100644
index 00000000000..5396e792dac
Binary files /dev/null and
b/docker/thirdparties/docker-compose/hive/scripts/data/multi_catalog/parquet_lzo_compression/data.tar.gz
differ
diff --git
a/docker/thirdparties/docker-compose/hive/scripts/data/multi_catalog/parquet_lzo_compression/run.sh
b/docker/thirdparties/docker-compose/hive/scripts/data/multi_catalog/parquet_lzo_compression/run.sh
new file mode 100755
index 00000000000..7c2e7e7aed2
--- /dev/null
+++
b/docker/thirdparties/docker-compose/hive/scripts/data/multi_catalog/parquet_lzo_compression/run.sh
@@ -0,0 +1,13 @@
+#!/bin/bash
+set -x
+
+CUR_DIR="$(cd "$(dirname "${BASH_SOURCE[0]}")" &>/dev/null && pwd)"
+
+## mkdir and put data to hdfs
+cd "${CUR_DIR}" && rm -rf data/ && tar xzf data.tar.gz
+hadoop fs -mkdir -p /user/doris/suites/multi_catalog/
+hadoop fs -put "${CUR_DIR}"/data/* /user/doris/suites/multi_catalog/
+
+# create table
+hive -f "${CUR_DIR}"/create_table.hql
+
diff --git
a/docker/thirdparties/docker-compose/hive/scripts/data/multi_catalog/test_compress_partitioned/create_table.hql
b/docker/thirdparties/docker-compose/hive/scripts/data/multi_catalog/test_compress_partitioned/create_table.hql
new file mode 100644
index 00000000000..559119059a7
--- /dev/null
+++
b/docker/thirdparties/docker-compose/hive/scripts/data/multi_catalog/test_compress_partitioned/create_table.hql
@@ -0,0 +1,152 @@
+create database if not exists multi_catalog;
+use multi_catalog;
+
+CREATE TABLE `test_compress_partitioned`(
+ `watchid` string,
+ `javaenable` smallint,
+ `title` string,
+ `goodevent` smallint,
+ `eventtime` timestamp,
+ `eventdate` date,
+ `counterid` bigint,
+ `clientip` bigint,
+ `clientip6` char(50),
+ `regionid` bigint,
+ `userid` string,
+ `counterclass` tinyint,
+ `os` smallint,
+ `useragent` smallint,
+ `url` string,
+ `referer` string,
+ `urldomain` string,
+ `refererdomain` string,
+ `refresh` smallint,
+ `isrobot` smallint,
+ `referercategories` string,
+ `urlcategories` string,
+ `urlregions` string,
+ `refererregions` string,
+ `resolutionwidth` int,
+ `resolutionheight` int,
+ `resolutiondepth` smallint,
+ `flashmajor` smallint,
+ `flashminor` smallint,
+ `flashminor2` string,
+ `netmajor` smallint,
+ `netminor` smallint,
+ `useragentmajor` int,
+ `useragentminor` char(4),
+ `cookieenable` smallint,
+ `javascriptenable` smallint,
+ `ismobile` smallint,
+ `mobilephone` smallint,
+ `mobilephonemodel` string,
+ `params` string,
+ `ipnetworkid` bigint,
+ `traficsourceid` tinyint,
+ `searchengineid` int,
+ `searchphrase` string,
+ `advengineid` smallint,
+ `isartifical` smallint,
+ `windowclientwidth` int,
+ `windowclientheight` int,
+ `clienttimezone` smallint,
+ `clienteventtime` timestamp,
+ `silverlightversion1` smallint,
+ `silverlightversion2` smallint,
+ `silverlightversion3` bigint,
+ `silverlightversion4` int,
+ `pagecharset` string,
+ `codeversion` bigint,
+ `islink` smallint,
+ `isdownload` smallint,
+ `isnotbounce` smallint,
+ `funiqid` string,
+ `hid` bigint,
+ `isoldcounter` smallint,
+ `isevent` smallint,
+ `isparameter` smallint,
+ `dontcounthits` smallint,
+ `withhash` smallint,
+ `hitcolor` char(2),
+ `utceventtime` timestamp,
+ `age` smallint,
+ `sex` smallint,
+ `income` smallint,
+ `interests` int,
+ `robotness` smallint,
+ `generalinterests` string,
+ `remoteip` bigint,
+ `remoteip6` char(50),
+ `windowname` int,
+ `openername` int,
+ `historylength` smallint,
+ `browserlanguage` char(4),
+ `browsercountry` char(4),
+ `socialnetwork` string,
+ `socialaction` string,
+ `httperror` int,
+ `sendtiming` int,
+ `dnstiming` int,
+ `connecttiming` int,
+ `responsestarttiming` int,
+ `responseendtiming` int,
+ `fetchtiming` int,
+ `redirecttiming` int,
+ `dominteractivetiming` int,
+ `domcontentloadedtiming` int,
+ `domcompletetiming` int,
+ `loadeventstarttiming` int,
+ `loadeventendtiming` int,
+ `nstodomcontentloadedtiming` int,
+ `firstpainttiming` int,
+ `redirectcount` tinyint,
+ `socialsourcenetworkid` smallint,
+ `socialsourcepage` string,
+ `paramprice` bigint,
+ `paramorderid` string,
+ `paramcurrency` char(6),
+ `paramcurrencyid` int,
+ `goalsreached` string,
+ `openstatservicename` string,
+ `openstatcampaignid` string,
+ `openstatadid` string,
+ `openstatsourceid` string,
+ `utmsource` string,
+ `utmmedium` string,
+ `utmcampaign` string,
+ `utmcontent` string,
+ `utmterm` string,
+ `fromtag` string,
+ `hasgclid` smallint,
+ `refererhash` string,
+ `urlhash` string,
+ `clid` bigint,
+ `yclid` string,
+ `shareservice` string,
+ `shareurl` string,
+ `sharetitle` string,
+ `parsedparamskey1` string,
+ `parsedparamskey2` string,
+ `parsedparamskey3` string,
+ `parsedparamskey4` string,
+ `parsedparamskey5` string,
+ `parsedparamsvaluedouble` double,
+ `islandid` char(40),
+ `requestnum` bigint,
+ `requesttry` smallint)
+PARTITIONED BY (
+ `dt` string)
+ROW FORMAT SERDE
+ 'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'
+STORED AS INPUTFORMAT
+ 'org.apache.hadoop.mapred.TextInputFormat'
+OUTPUTFORMAT
+ 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'
+LOCATION
+ '/user/doris/suites/multi_catalog/test_compress_partitioned'
+TBLPROPERTIES (
+ 'transient_lastDdlTime'='1692589095');
+
+msck repair table test_compress_partitioned;
+
diff --git
a/docker/thirdparties/docker-compose/hive/scripts/data/multi_catalog/test_compress_partitioned/run.sh
b/docker/thirdparties/docker-compose/hive/scripts/data/multi_catalog/test_compress_partitioned/run.sh
new file mode 100755
index 00000000000..cacb898598a
--- /dev/null
+++
b/docker/thirdparties/docker-compose/hive/scripts/data/multi_catalog/test_compress_partitioned/run.sh
@@ -0,0 +1,22 @@
+#!/bin/bash
+set -x
+
+CUR_DIR="$(cd "$(dirname "${BASH_SOURCE[0]}")" &>/dev/null && pwd)"
+
+if [[ ! -d "${CUR_DIR}/data" ]]; then
+ echo "${CUR_DIR}/data does not exist"
+ cd "${CUR_DIR}" && rm -f data.tar.gz \
+ && curl -O
https://s3BucketName.s3Endpoint/regression/datalake/pipeline_data/multi_catalog/test_compress_partitioned/data.tar.gz
\
+ && tar xzf data.tar.gz
+ cd -
+else
+ echo "${CUR_DIR}/data exist, continue !"
+fi
+
+## mkdir and put data to hdfs
+hadoop fs -mkdir -p /user/doris/suites/multi_catalog/
+hadoop fs -put "${CUR_DIR}"/data/* /user/doris/suites/multi_catalog/
+
+# create table
+hive -f "${CUR_DIR}"/create_table.hql
+
diff --git
a/docker/thirdparties/docker-compose/hive/scripts/data/regression/crdmm_data/create_table.hql
b/docker/thirdparties/docker-compose/hive/scripts/data/regression/crdmm_data/create_table.hql
new file mode 100644
index 00000000000..0abba278308
--- /dev/null
+++
b/docker/thirdparties/docker-compose/hive/scripts/data/regression/crdmm_data/create_table.hql
@@ -0,0 +1,162 @@
+create database if not exists regression;
+use regression;
+
+CREATE TABLE `crdmm_data`(
+ `apply_dt` string,
+ `session_id` string,
+ `apply_id` string,
+ `biz_type` string,
+ `begin_time` string,
+ `out_finaldecision` string,
+ `out_hit_refused_rule` string,
+ `out_lending_rate` string,
+ `out_creditlimit` string,
+ `amt_seg` string,
+ `oott_ppddtt_group1` string,
+ `oott_ppddtt_group2` string,
+ `oott_ppddtt_group3` string,
+ `oott_ppddtt_group15` string,
+ `oott_ppddtt_group5` string,
+ `oott_ppddtt_group6` string,
+ `oott_ppddtt_group7` string,
+ `oott_ppddtt_group8` string,
+ `oott_ppddtt_group9` string,
+ `oott_ppddtt_group10` string,
+ `oott_ppddtt_group11` string,
+ `oott_ppddtt_group12` string,
+ `oott_ppddtt_group13` string,
+ `oott_ppddtt_group14` string,
+ `t01_age` string,
+ `age_seg` string,
+ `t01_sex` string,
+ `t01_mobile_field0` string,
+ `t01_mobile_field1` string,
+ `t01_origin_field0` string,
+ `t01_origin_field1` string,
+ `t07_yhdd_field0` string,
+ `t07_yhdd_field1` string,
+ `t07_yhdd_field2` string,
+ `t07_yhdd_field3` string,
+ `t06_rh_status` string,
+ `had_something` int,
+ `t06_rh_gender` string,
+ `t06_rh_age` string,
+ `t06_rh_marital_state` string,
+ `t06_rh_employer_industry` string,
+ `t06_rh_current_testxx_overdue_money` string,
+ `ttxx_test_field_crdyy_current_overdue_money` string,
+ `ttxx_test_field_current_overdue_count` string,
+ `ttxx_test_field_crdyy_current_overdue_count` string,
+ `ttxx_test_field_crdyy_latest_3_month_overdue_count` string,
+ `ttxx_test_field_latest_3_month_overdue_count` string,
+ `ttxx_test_field_crdyy_latest_6_month_overdue_count` string,
+ `ttxx_test_field_latest_6_month_overdue_count` string,
+ `ttxx_test_field_crdyy_latest_12_month_overdue_count` string,
+ `ttxx_test_field_latest_12_month_overdue_count` string,
+ `ttxx_test_field_crdyy_latest_24_month_overdue_count` string,
+ `ttxx_test_field_latest_24_month_overdue_count` string,
+ `ttxx_test_field_latest_3_month_max_overdue_count` string,
+ `ttxx_test_field_latest_6_month_max_overdue_count` string,
+ `ttxx_test_field_latest_12_month_max_overdue_count` string,
+ `ttxx_test_field_latest_24_month_max_overdue_count` string,
+ `ttxx_test_field_crdyy_latest_3_month_max_overdue_count` string,
+ `ttxx_test_field_crdyy_latest_6_month_max_overdue_count` string,
+ `ttxx_test_field_crdyy_latest_12_month_max_overdue_count` string,
+ `ttxx_test_field_crdyy_latest_24_month_max_overdue_count` string,
+ `t06_rh_latest_1_month_cdyy_crdyy_approval_query_count` string,
+ `t06_rh_latest_1_month_testxx_approval_query_count` string,
+ `t06_rh_latest_3_month_cdyy_crdyy_approval_query_count` string,
+ `t06_rh_latest_3_month_testxx_approval_query_count` string,
+ `t06_rh_latest_6_month_cdyy_crdyy_approval_query_count` string,
+ `t06_rh_latest_6_month_testxx_approval_query_count` string,
+ `ttxx_test_field_latest_1_month_hairpin_count` string,
+ `ttxx_test_field_latest_3_month_hairpin_count` string,
+ `ttxx_test_field_latest_6_month_hairpin_count` string,
+ `ttxx_test_field_latest_12_month_hairpin_count` string,
+ `month_ffzzhh` double,
+ `t06_rh_per_hhoossuu_testxx_count` string,
+ `t06_rh_per_business_hhoossuu_testxx_count` string,
+ `t06_rh_per_hhoossuu_testxx_current_repayment` string,
+ `t06_rh_per_hhoossuu_testxx_max_limit_amount` string,
+ `t06_rh_per_hhoossuu_testxx_limit_amount_sum` string,
+ `t06_rh_per_hhoossuu_testxx_balance_sum` string,
+ `t06_rh_per_ccrr_testxx_count` string,
+ `t06_rh_per_ccrr_testxx_balance_sum` string,
+ `t06_rh_per_ccrr_testxx_max_limit_amount` string,
+ `t06_rh_per_ccrr_testxx_limit_amount_sum` string,
+ `t06_rh_per_ccrr_testxx_current_repayment` string,
+ `t06_rh_per_business_testxx_limit_amount_sum` string,
+ `t06_rh_per_business_testxx_balance_sum` string,
+ `t06_rh_per_business_testxx_count` string,
+ `t06_rh_per_business_testxx_current_repayment` string,
+ `t06_rh_edu_level` string,
+ `t06_rh_accumulation_fund_state` string,
+ `t06_rh_accumulation_fund_own_percent` string,
+ `t06_rh_accumulation_fund_com_percent` string,
+ `t06_rh_accumulation_fund_pay` string,
+ `t06_rh_accumulation_fund_deposit_base` string,
+ `t06_rh_not_destroy_testxx_crdyy_account_count` string,
+ `t06_rh_not_destroy_testxx_crdyy_cdyy_limit` string,
+ `t06_rh_not_destroy_testxx_crdyy_used_cdyy_limit` string,
+ `t06_rh_not_destroy_testxx_crdyy_cdyy_limit_ratio` string,
+ `t06_rh_not_destroy_testxx_crdyy_latest_6_month_used_avg_amount` string,
+ `t06_rh_not_destroy_testxx_crdyy_min_cdyy_limit_per_org` string,
+ `t06_rh_not_destroy_testxx_crdyy_max_cdyy_limit_per_org` string,
+ `ttxx_test_field_crdyy_amount_use_exceed_75_percent_num` string,
+ `ttxx_test_field_crdyy_amount_use_exceed_90_percent_num` string,
+ `t06_rh_standard_testxx_crdyy_amount_use_exceed_75_percent_ratio` string,
+ `t06_rh_standard_testxx_crdyy_amount_use_exceed_90_percent_ratio` string,
+ `ttxx_test_field_crdyy_latest_1_month_total_repayment` string,
+ `t06_rh_per_ccxx_testxx_current_repayment` string,
+ `t06_rh_per_ccxx_testxx_max_limit_amount` string,
+ `t06_rh_per_ccxx_testxx_limit_amount_sum` string,
+ `t06_rh_per_ccxx_testxx_balance_sum` string,
+ `t06_rh_per_ccxx_testxx_count` string,
+ `t06_rh_per_ccxx_testxx_max_account_age` string,
+ `t06_rh_per_ccxx_testxx_min_account_age` string,
+ `t06_rh_per_ccxx_testxx_uncleared_max_account_age` string,
+ `t06_rh_per_ccxx_testxx_uncleared_min_account_age` string,
+ `t06_rh_cdyy_testxx_last_1_month_launch_count` string,
+ `t06_rh_cdyy_testxx_last_3_month_launch_count` string,
+ `t06_rh_cdyy_testxx_last_6_month_launch_count` string,
+ `t06_rh_cdyy_testxx_last_12_month_launch_count` string,
+ `t06_rh_cdyy_testxx_last_1_month_launch_cdyy_limit` string,
+ `t06_rh_cdyy_testxx_last_3_month_launch_cdyy_limit` string,
+ `t06_rh_cdyy_testxx_last_6_month_launch_cdyy_limit` string,
+ `t06_rh_cdyy_testxx_last_12_month_launch_cdyy_limit` string,
+ `t06_rh_unpaid_testxx_cdyy_limit` string,
+ `t06_rh_unpaid_testxx_balance` string,
+ `t06_rh_unpaid_testxx_latest_6_month_used_avg_amount` string,
+ `t06_rh_cdyy_white_grade` string,
+ `t06_rh_first_testxx_open_ago_months` string,
+ `t06_rh_first_testxx_crdyy_open_ago_months` string,
+ `t06_rh_cdyy_testxx_limit_amount_sum` string,
+ `t06_rh_cdyy_testxx_count` string,
+ `t06_rh_uncleared_cdyy_testxx_count` string,
+ `t06_rh_uncleared_cdyy_testxx_balance_sum` string,
+ `t06_rh_uncleared_cdyy_testxx_limit_amount_sum` string,
+ `crdmm_testxx_sum_grp` string,
+ `pd_prl_cnt_grp` string,
+ `upd_prl_pct_grp` string,
+ `ttxx_test_field_average_surplus_repay_count` string,
+ `t06_rh_d1_testxx_24_overdue_month_count` string,
+ `t06_rh_clear_testxx_cnt_l3m` string,
+ `t06_rh_last_60d_query_cnt` string,
+ `t06_rh_last_0d_testxx_query_cnt` string)
+ROW FORMAT SERDE
+ 'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'
+WITH SERDEPROPERTIES (
+ 'field.delim'=',',
+ 'line.delim'='\n',
+ 'serialization.format'=',')
+STORED AS INPUTFORMAT
+ 'org.apache.hadoop.mapred.TextInputFormat'
+OUTPUTFORMAT
+ 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'
+LOCATION
+ '/user/doris/suites/regression/crdmm_data/'
+TBLPROPERTIES (
+ 'transient_lastDdlTime'='1685331029');
+
+msck repair crdmm_data;
+
diff --git
a/docker/thirdparties/docker-compose/hive/scripts/data/regression/crdmm_data/data.tar.gz
b/docker/thirdparties/docker-compose/hive/scripts/data/regression/crdmm_data/data.tar.gz
new file mode 100644
index 00000000000..9dcacd763e1
Binary files /dev/null and
b/docker/thirdparties/docker-compose/hive/scripts/data/regression/crdmm_data/data.tar.gz
differ
diff --git
a/docker/thirdparties/docker-compose/hive/scripts/data/regression/crdmm_data/run.sh
b/docker/thirdparties/docker-compose/hive/scripts/data/regression/crdmm_data/run.sh
new file mode 100755
index 00000000000..1c6603db3be
--- /dev/null
+++
b/docker/thirdparties/docker-compose/hive/scripts/data/regression/crdmm_data/run.sh
@@ -0,0 +1,14 @@
+#!/bin/bash
+set -x
+
+CUR_DIR="$(cd "$(dirname "${BASH_SOURCE[0]}")" &>/dev/null && pwd)"
+
+## mkdir and put data to hdfs
+cd "${CUR_DIR}" && rm -rf data/ && tar xzf data.tar.gz
+hadoop fs -mkdir -p /user/doris/suites/regression/
+hadoop fs -put "${CUR_DIR}"/data/* /user/doris/suites/regression/
+
+# create table
+hive -f "${CUR_DIR}"/create_table.hql
+
+
diff --git a/docker/thirdparties/docker-compose/hive/scripts/hive-metastore.sh
b/docker/thirdparties/docker-compose/hive/scripts/hive-metastore.sh
index 0157dc26d40..abf4ef86958 100755
--- a/docker/thirdparties/docker-compose/hive/scripts/hive-metastore.sh
+++ b/docker/thirdparties/docker-compose/hive/scripts/hive-metastore.sh
@@ -16,17 +16,24 @@
# specific language governing permissions and limitations
# under the License.
+set -x
+
nohup /opt/hive/bin/hive --service metastore &
# wait metastore start
sleep 10s
+# create tables for other cases
+# new cases should use separate dir
+hadoop fs -mkdir -p /user/doris/suites/
+
+DATA_DIR="/mnt/scripts/data/"
+find "${DATA_DIR}" -type f -name "run.sh" -exec chmod +x {} \; -exec {} \;
+
# if you test in your local，better use # to annotation section about tpch1.db
if [[ ! -d "/mnt/scripts/tpch1.db" ]]; then
echo "/mnt/scripts/tpch1.db does not exist"
cd /mnt/scripts/
- #curl -O /mnt/scripts
https://doris-build-hk-1308700295.cos.ap-hongkong.myqcloud.com/regression/load/tpch1_parquet/tpch1.db.tar.gz
- echo "curl -O
s3BucketName.s3Endpoint/regression/datalake/pipeline_data/tpch1.db.tar.gz"
curl -O
https://s3BucketName.s3Endpoint/regression/datalake/pipeline_data/tpch1.db.tar.gz
tar -zxf tpch1.db.tar.gz
rm -rf tpch1.db.tar.gz
@@ -37,9 +44,7 @@ fi
# put data file
## put tpch1
-echo "hadoop fs -mkdir /user/doris/"
hadoop fs -mkdir -p /user/doris/
-echo "hadoop fs -put /mnt/scripts/tpch1.db /user/doris/"
hadoop fs -put /mnt/scripts/tpch1.db /user/doris/
@@ -47,8 +52,6 @@ hadoop fs -put /mnt/scripts/tpch1.db /user/doris/
if [[ ! -d "/mnt/scripts/paimon1" ]]; then
echo "/mnt/scripts/paimon1 does not exist"
cd /mnt/scripts/
- #curl -O
https://doris-build-hk-1308700295.cos.ap-hongkong.myqcloud.com/regression/paimon/paimon1.tar.gz
- echo "curl -O
s3BucketName.s3Endpoint/regression/datalake/pipeline_data/paimon1.tar.gz"
curl -O
https://s3BucketName.s3Endpoint/regression/datalake/pipeline_data/paimon1.tar.gz
tar -zxf paimon1.tar.gz
rm -rf paimon1.tar.gz
@@ -58,24 +61,16 @@ else
fi
## put paimon1
-echo "hadoop fs -put /mnt/scripts/paimon1 /user/doris/"
hadoop fs -put /mnt/scripts/paimon1 /user/doris/
## put other preinstalled data
-echo "hadoop fs -put /mnt/scripts/preinstalled_data /user/doris/"
hadoop fs -put /mnt/scripts/preinstalled_data /user/doris/
# create table
-echo "hive -f /mnt/scripts/create_tpch1_orc.hql"
hive -f /mnt/scripts/create_tpch1_orc.hql
-
-echo "hive -f /mnt/scripts/create_tpch1_parquet.hql"
hive -f /mnt/scripts/create_tpch1_parquet.hql
-
-echo "hive -f /mnt/scripts/create_preinstalled_table.hql"
hive -f /mnt/scripts/create_preinstalled_table.hql
-echo "touch /mnt/SUCCESS"
touch /mnt/SUCCESS
# Avoid container exit
diff --git a/docker/thirdparties/run-thirdparties-docker.sh
b/docker/thirdparties/run-thirdparties-docker.sh
index cbf85a02cdf..1fb7c69536b 100755
--- a/docker/thirdparties/run-thirdparties-docker.sh
+++ b/docker/thirdparties/run-thirdparties-docker.sh
@@ -314,6 +314,18 @@ if [[ "${RUN_HIVE2}" -eq 1 ]]; then
# before start it, you need to download parquet file package, see "README"
in "docker-compose/hive/scripts/"
sed -i "s/s3Endpoint/${s3Endpoint}/g"
"${ROOT}"/docker-compose/hive/scripts/hive-metastore.sh
sed -i "s/s3BucketName/${s3BucketName}/g"
"${ROOT}"/docker-compose/hive/scripts/hive-metastore.sh
+
+ # sed all s3 info in run.sh of each suite
+ find "${ROOT}/docker-compose/hive/scripts/data/" -type f -name "run.sh" |
while read -r file; do
+ if [ -f "$file" ]; then
+ echo "Processing $file"
+ sed -i "s/s3Endpoint/${s3Endpoint}/g" "${file}"
+ sed -i "s/s3BucketName/${s3BucketName}/g" "${file}"
+ else
+ echo "File not found: $file"
+ fi
+ done
+
# generate hive-2x.yaml
export IP_HOST=${IP_HOST}
export CONTAINER_UID=${CONTAINER_UID}
@@ -340,6 +352,18 @@ if [[ "${RUN_HIVE3}" -eq 1 ]]; then
# before start it, you need to download parquet file package, see "README"
in "docker-compose/hive/scripts/"
sed -i "s/s3Endpoint/${s3Endpoint}/g"
"${ROOT}"/docker-compose/hive/scripts/hive-metastore.sh
sed -i "s/s3BucketName/${s3BucketName}/g"
"${ROOT}"/docker-compose/hive/scripts/hive-metastore.sh
+
+ # sed all s3 info in run.sh of each suite
+ find "${ROOT}/docker-compose/hive/scripts/data" -type f -name "run.sh" |
while read -r file; do
+ if [ -f "$file" ]; then
+ echo "Processing $file"
+ sed -i "s/s3Endpoint/${s3Endpoint}/g" "${file}"
+ sed -i "s/s3BucketName/${s3BucketName}/g" "${file}"
+ else
+ echo "File not found: $file"
+ fi
+ done
+
# generate hive-3x.yaml
export IP_HOST=${IP_HOST}
export CONTAINER_UID=${CONTAINER_UID}
diff --git
a/regression-test/data/external_table_p2/hive/test_external_credit_data.out
b/regression-test/data/external_table_p0/hive/test_external_credit_data.out
similarity index 55%
rename from
regression-test/data/external_table_p2/hive/test_external_credit_data.out
rename to
regression-test/data/external_table_p0/hive/test_external_credit_data.out
index a80520330f6..6753378f4a8 100644
--- a/regression-test/data/external_table_p2/hive/test_external_credit_data.out
+++ b/regression-test/data/external_table_p0/hive/test_external_credit_data.out
@@ -11,3 +11,15 @@
2023-05 0 0 4 0 2 2 25%-50% 0
1
2023-05 1 0 3 1 0 0 No Loan bal
0 1
+-- !credit_data --
+2023-03 0 0 4 0 0 0 No Loan bal
0 1
+2023-03 0 0 4 0 3 3 25%-50% 0
1
+2023-03 0 0 4 2 3 3 80%-90% 6
1
+2023-04 0 0 3 1 0 0 No Loan bal
2 1
+2023-04 0 1 4 0 2 3 25%-50% 0
1
+2023-05 0 0 4 0 1 1 0%-10% 0
1
+2023-05 0 0 4 0 1 1 25%-50% 0
1
+2023-05 0 0 4 0 1 1 50%-80% 0
1
+2023-05 0 0 4 0 2 2 25%-50% 0
1
+2023-05 1 0 3 1 0 0 No Loan bal
0 1
+
diff --git a/regression-test/data/external_table_p2/hive/test_compress_type.out
b/regression-test/data/external_table_p0/hive/test_hive_compress_type.out
similarity index 50%
rename from regression-test/data/external_table_p2/hive/test_compress_type.out
rename to
regression-test/data/external_table_p0/hive/test_hive_compress_type.out
index ca9ca885c5b..306d2613ff2 100644
--- a/regression-test/data/external_table_p2/hive/test_compress_type.out
+++ b/regression-test/data/external_table_p0/hive/test_hive_compress_type.out
@@ -571,3 +571,575 @@
-- !lzo_8 --
+-- !q21 --
+600005
+
+-- !q22 --
+1510010
+
+-- !q23 --
+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 [...]
+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 [...]
+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 [...]
+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 [...]
+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 [...]
+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 [...]
+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 [...]
+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 [...]
+
+-- !q31 --
+600005
+
+-- !q32 --
+1510010
+
+-- !q33 --
+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 [...]
+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 [...]
+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 [...]
+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 [...]
+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 [...]
+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 [...]
+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 [...]
+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
+
+-- !lzo_1 --
+127 317 22 139027217294 5.8534396E7 1.097115615520323E10
true NxvCOVAHCAzWEFOs VdEf vXxekmctPmPmmbecHgf 2023-12-15
2023-12-28T23:15:48 147638.24
+135 194 7 57894842960 1.3718646E7 2.1169820465574505E10
true aseqfHnnrtaL HwV IqXKe 2023-12-28 2023-12-19T06:14:48
32041.77
+139 146 4 149816593644 4.9618156E7 1.3744723380110355E10
false sreHCjYoJoBOjUJMMBSQ dD iBaixPwGysIVgkomhg 2023-12-27
2023-12-19T15:51:48 191090.57
+167 275 28 46739421643 2.790689E7 5.638235691917528E8
false BDX iY pOrAYVd 2023-12-01 2023-12-09T12:59:48
105181.01
+241 496 63 26957970271 3.7214888E7 1.2043262506506804E10
true VJPXXigvP wfZp cwyoMdOxN 2023-12-10
2023-12-18T05:33:48 105023.30
+285 43 47 124246184718 2162507.5 1.6279579779299034E10
false gXIEVQzqfokBv raxj NbGVRlQeotLBDWbDqP 2023-12-17
2023-12-24T03:36:48 75425.14
+311 44 67 79901279497 3.0787934E7 1.5853816694193293E10
false LTsSxeetbYKCwcJvg BCrf XkuC 2023-12-11
2023-12-05T13:16:48 103792.88
+333 390 29 61080978873 2916969.0 1.053228375816898E10
true HcZnbf Wp iHqLLiPhgZ 2023-12-01 2023-12-10T11:31:48
68471.38
+36 369 2 24371701950 5.54394E7 8.576150848699297E9
false uQpDcwEZT sd SwzJInNDb 2023-12-05
2023-12-08T15:00:40 8954.61
+363 375 1 20494251127 8.9166856E7 2.2005002173871223E10
false hkHvijevoRfHhK szl hwHUAjwqTQOmLEPDFbt 2023-12-05
2023-12-08T05:28:48 96630.28
+368 37 42 60649320592 2.3388714E7 1.81031191987985E9
true yXoDmKpjjRsVV Hq MbWlyi 2023-12-19 2023-12-06T00:45:48
197736.91
+414 301 63 87524210634 1.2944316E7 3.5428357192711325E9
true piECj tGM pkOyUdxLBFCw 2023-12-19 2023-12-10T15:28:48
112255.75
+42 132 39 128076453206 3.1733946E7 2.001312160047691E9
false kzviLgVNqxrDQ kr YhdXGtPun 2023-12-15
2023-12-10T01:42:48 189135.64
+427 286 67 78312070726 3.1794338E7 1.7713252925472687E10
true lHoUCBbY LTkc CgMrDWTGppMIaZPk 2023-12-13
2023-12-08T16:02:48 75175.71
+438 491 21 66065079309 6.6624016E7 1.5542114222539822E10
false CEbvKZRdvMHxzVOIejq wJ eoTkUlht 2023-12-08
2023-12-17T19:49:48 86666.80
+469 156 25 41259191749 6.2344956E7 1.5674967382662376E10
true dfyMUJYNppBDDD az lVofKt 2023-12-19 2023-12-09T10:37:48
15427.43
+540 416 70 110655654086 4.9027904E7 1.1345965638449787E10
true gZF oPNx kDYTiiCPhyQqnmPLd 2023-12-26
2023-12-20T22:47:48 177628.27
+563 327 1 86402793406 1.4668673E7 2.1932020019521263E10
false uEPywVtgb IN HCcPuRYlwlezseie 2023-12-27
2023-12-01T09:02:48 12840.38
+585 423 69 141894410515 1.7955736E7 8.784239710423233E9
false IsWEZJsPRXIFqapTTb yO qRAEvl 2023-11-29
2023-12-26T04:50:48 46733.25
+618 390 70 40611757422 4.9496784E7 1.90943138552761E9
true cuqniQE dxKv KlxZsrJad 2023-12-05 2023-11-30T13:41:48
13904.80
+
+-- !lzo_2 --
+1078 229 63 79026532317 1.4363472E7 1.193746461651589E10
true znYrIGhEXITIdyiifBPZ BBh klhSDtg 2023-12-14
2023-12-02T06:34:48 80402.53
+1105 186 31 129159878912 1.3102703E7 1.6989058048889019E10
false OxhcUomBMLjVjdwgOI Qa eJoODDnkdDd 2023-12-20
2023-12-25T03:33:48 83174.73
+1108 223 24 64158736405 1.3341401E7 2.0128416779917E10
false rLXbarkH xU ggGSZGxLwT 2023-11-28
2023-12-23T01:43:48 17986.48
+1126 178 38 137633520558 9.6421152E7 1.2075476530488207E10
true vHgghYPQNpzTmYx EKhO Pg 2023-12-03 2023-12-03T18:17:48
119990.49
+1215 20 18 15934394806 9.6266544E7 3.303291140952643E8
true zzkAwmKNf RKO VzyGx 2023-12-26 2023-12-14T02:36:48
59236.59
+1225 131 17 119517491015 7.868396E7 1.2812171639342154E10
true maOgXoCzsrPVZqxaeS vm AJNnbqdEzk 2023-12-28
2023-12-22T23:18:48 85523.88
+1252 142 68 92511639613 5.2273456E7 2.0197789593796345E10
true zFl Avwm Yi 2023-12-24 2023-12-01T22:31:48
181634.60
+1262 279 57 63627626380 2.3360408E7 6.674186807593108E9
true wjuW ueO tOWuzwJj 2023-12-24 2023-12-04T17:27:48
112884.97
+1266 253 10 139941604087 2.5471874E7 2.6004794480891223E9
true YBx MqsR sLu 2023-12-03 2023-12-23T10:00:48 83930.38
+1267 155 54 38456715756 4.2582072E7 3.350085153856542E9
true qFXXKbhqXfSYFXteGF WMH CWZwGCkmg 2023-12-17
2023-12-20T19:06:48 13843.42
+
+-- !lzo_3 --
+127 317 22 139027217294 5.8534396E7 1.097115615520323E10
true NxvCOVAHCAzWEFOs VdEf vXxekmctPmPmmbecHgf 2023-12-15
2023-12-28T23:15:48 147638.24
+135 194 7 57894842960 1.3718646E7 2.1169820465574505E10
true aseqfHnnrtaL HwV IqXKe 2023-12-28 2023-12-19T06:14:48
32041.77
+241 496 63 26957970271 3.7214888E7 1.2043262506506804E10
true VJPXXigvP wfZp cwyoMdOxN 2023-12-10
2023-12-18T05:33:48 105023.30
+333 390 29 61080978873 2916969.0 1.053228375816898E10
true HcZnbf Wp iHqLLiPhgZ 2023-12-01 2023-12-10T11:31:48
68471.38
+368 37 42 60649320592 2.3388714E7 1.81031191987985E9
true yXoDmKpjjRsVV Hq MbWlyi 2023-12-19 2023-12-06T00:45:48
197736.91
+414 301 63 87524210634 1.2944316E7 3.5428357192711325E9
true piECj tGM pkOyUdxLBFCw 2023-12-19 2023-12-10T15:28:48
112255.75
+427 286 67 78312070726 3.1794338E7 1.7713252925472687E10
true lHoUCBbY LTkc CgMrDWTGppMIaZPk 2023-12-13
2023-12-08T16:02:48 75175.71
+469 156 25 41259191749 6.2344956E7 1.5674967382662376E10
true dfyMUJYNppBDDD az lVofKt 2023-12-19 2023-12-09T10:37:48
15427.43
+540 416 70 110655654086 4.9027904E7 1.1345965638449787E10
true gZF oPNx kDYTiiCPhyQqnmPLd 2023-12-26
2023-12-20T22:47:48 177628.27
+618 390 70 40611757422 4.9496784E7 1.90943138552761E9
true cuqniQE dxKv KlxZsrJad 2023-12-05 2023-11-30T13:41:48
13904.80
+
+-- !lzo_4 --
+139 146 4 149816593644 4.9618156E7 1.3744723380110355E10
false sreHCjYoJoBOjUJMMBSQ dD iBaixPwGysIVgkomhg 2023-12-27
2023-12-19T15:51:48 191090.57
+167 275 28 46739421643 2.790689E7 5.638235691917528E8
false BDX iY pOrAYVd 2023-12-01 2023-12-09T12:59:48
105181.01
+285 43 47 124246184718 2162507.5 1.6279579779299034E10
false gXIEVQzqfokBv raxj NbGVRlQeotLBDWbDqP 2023-12-17
2023-12-24T03:36:48 75425.14
+311 44 67 79901279497 3.0787934E7 1.5853816694193293E10
false LTsSxeetbYKCwcJvg BCrf XkuC 2023-12-11
2023-12-05T13:16:48 103792.88
+36 369 2 24371701950 5.54394E7 8.576150848699297E9
false uQpDcwEZT sd SwzJInNDb 2023-12-05
2023-12-08T15:00:40 8954.61
+363 375 1 20494251127 8.9166856E7 2.2005002173871223E10
false hkHvijevoRfHhK szl hwHUAjwqTQOmLEPDFbt 2023-12-05
2023-12-08T05:28:48 96630.28
+42 132 39 128076453206 3.1733946E7 2.001312160047691E9
false kzviLgVNqxrDQ kr YhdXGtPun 2023-12-15
2023-12-10T01:42:48 189135.64
+438 491 21 66065079309 6.6624016E7 1.5542114222539822E10
false CEbvKZRdvMHxzVOIejq wJ eoTkUlht 2023-12-08
2023-12-17T19:49:48 86666.80
+563 327 1 86402793406 1.4668673E7 2.1932020019521263E10
false uEPywVtgb IN HCcPuRYlwlezseie 2023-12-27
2023-12-01T09:02:48 12840.38
+585 423 69 141894410515 1.7955736E7 8.784239710423233E9
false IsWEZJsPRXIFqapTTb yO qRAEvl 2023-11-29
2023-12-26T04:50:48 46733.25
+
+-- !lzo_5 --
+127 317 22 139027217294 5.8534396E7 1.097115615520323E10
true NxvCOVAHCAzWEFOs VdEf vXxekmctPmPmmbecHgf 2023-12-15
2023-12-28T23:15:48 147638.24
+139 146 4 149816593644 4.9618156E7 1.3744723380110355E10
false sreHCjYoJoBOjUJMMBSQ dD iBaixPwGysIVgkomhg 2023-12-27
2023-12-19T15:51:48 191090.57
+167 275 28 46739421643 2.790689E7 5.638235691917528E8
false BDX iY pOrAYVd 2023-12-01 2023-12-09T12:59:48
105181.01
+241 496 63 26957970271 3.7214888E7 1.2043262506506804E10
true VJPXXigvP wfZp cwyoMdOxN 2023-12-10
2023-12-18T05:33:48 105023.30
+285 43 47 124246184718 2162507.5 1.6279579779299034E10
false gXIEVQzqfokBv raxj NbGVRlQeotLBDWbDqP 2023-12-17
2023-12-24T03:36:48 75425.14
+311 44 67 79901279497 3.0787934E7 1.5853816694193293E10
false LTsSxeetbYKCwcJvg BCrf XkuC 2023-12-11
2023-12-05T13:16:48 103792.88
+333 390 29 61080978873 2916969.0 1.053228375816898E10
true HcZnbf Wp iHqLLiPhgZ 2023-12-01 2023-12-10T11:31:48
68471.38
+36 369 2 24371701950 5.54394E7 8.576150848699297E9
false uQpDcwEZT sd SwzJInNDb 2023-12-05
2023-12-08T15:00:40 8954.61
+368 37 42 60649320592 2.3388714E7 1.81031191987985E9
true yXoDmKpjjRsVV Hq MbWlyi 2023-12-19 2023-12-06T00:45:48
197736.91
+42 132 39 128076453206 3.1733946E7 2.001312160047691E9
false kzviLgVNqxrDQ kr YhdXGtPun 2023-12-15
2023-12-10T01:42:48 189135.64
+
+-- !lzo_6 --
+9379 258 6 31310350438 3.1661348E7 8.857541516631796E8
false nuXBDInOfoaWz AKyn ggtgZNvWuC 2023-11-28
2023-12-06T03:40:40 50071.94
+
+-- !lzo_7 --
+127 317 22 139027217294 5.8534396E7 1.097115615520323E10
true NxvCOVAHCAzWEFOs VdEf vXxekmctPmPmmbecHgf 2023-12-15
2023-12-28T23:15:48 147638.24
+139 146 4 149816593644 4.9618156E7 1.3744723380110355E10
false sreHCjYoJoBOjUJMMBSQ dD iBaixPwGysIVgkomhg 2023-12-27
2023-12-19T15:51:48 191090.57
+167 275 28 46739421643 2.790689E7 5.638235691917528E8
false BDX iY pOrAYVd 2023-12-01 2023-12-09T12:59:48
105181.01
+241 496 63 26957970271 3.7214888E7 1.2043262506506804E10
true VJPXXigvP wfZp cwyoMdOxN 2023-12-10
2023-12-18T05:33:48 105023.30
+311 44 67 79901279497 3.0787934E7 1.5853816694193293E10
false LTsSxeetbYKCwcJvg BCrf XkuC 2023-12-11
2023-12-05T13:16:48 103792.88
+363 375 1 20494251127 8.9166856E7 2.2005002173871223E10
false hkHvijevoRfHhK szl hwHUAjwqTQOmLEPDFbt 2023-12-05
2023-12-08T05:28:48 96630.28
+368 37 42 60649320592 2.3388714E7 1.81031191987985E9
true yXoDmKpjjRsVV Hq MbWlyi 2023-12-19 2023-12-06T00:45:48
197736.91
+414 301 63 87524210634 1.2944316E7 3.5428357192711325E9
true piECj tGM pkOyUdxLBFCw 2023-12-19 2023-12-10T15:28:48
112255.75
+42 132 39 128076453206 3.1733946E7 2.001312160047691E9
false kzviLgVNqxrDQ kr YhdXGtPun 2023-12-15
2023-12-10T01:42:48 189135.64
+438 491 21 66065079309 6.6624016E7 1.5542114222539822E10
false CEbvKZRdvMHxzVOIejq wJ eoTkUlht 2023-12-08
2023-12-17T19:49:48 86666.80
+
+-- !lzo_8 --
+
diff --git a/regression-test/data/external_table_p2/hive/test_hive_to_date.out
b/regression-test/data/external_table_p0/hive/test_hive_to_date.out
similarity index 61%
rename from regression-test/data/external_table_p2/hive/test_hive_to_date.out
rename to regression-test/data/external_table_p0/hive/test_hive_to_date.out
index 97df0227560..a08e6515548 100644
--- a/regression-test/data/external_table_p2/hive/test_hive_to_date.out
+++ b/regression-test/data/external_table_p0/hive/test_hive_to_date.out
@@ -23,3 +23,27 @@
-- !9 --
+-- !1 --
+1 2000-01-01
+
+-- !2 --
+1 2000-01-01
+
+-- !3 --
+1 2000-01-01
+
+-- !4 --
+1 2000-01-01
+
+-- !5 --
+1 2000-01-01
+
+-- !6 --
+1 2000-01-01
+
+-- !7 --
+
+-- !8 --
+
+-- !9 --
+
diff --git
a/regression-test/data/external_table_p0/hive/test_upper_case_column_name.out
b/regression-test/data/external_table_p0/hive/test_upper_case_column_name.out
new file mode 100644
index 00000000000..b6ad7683464
--- /dev/null
+++
b/regression-test/data/external_table_p0/hive/test_upper_case_column_name.out
@@ -0,0 +1,89 @@
+-- This file is automatically generated. You should know what you did if you
want to edit this
+-- !hiveParquet1 --
+1 name
+
+-- !hiveParquet2 --
+1 name
+
+-- !hiveParquet3 --
+
+-- !hiveParquet4 --
+1 name
+
+-- !hiveParquet5 --
+
+-- !hiveParquet6 --
+1
+
+-- !hiveParquet7 --
+name
+
+-- !hiveParquet8 --
+1 name
+
+-- !hiveOrc1 --
+1 name
+
+-- !hiveOrc2 --
+1 name
+
+-- !hiveOrc3 --
+
+-- !hiveOrc4 --
+1 name
+
+-- !hiveOrc5 --
+
+-- !hiveOrc6 --
+1
+
+-- !hiveOrc7 --
+name
+
+-- !hiveOrc8 --
+1 name
+
+-- !hiveParquet1 --
+1 name
+
+-- !hiveParquet2 --
+1 name
+
+-- !hiveParquet3 --
+
+-- !hiveParquet4 --
+1 name
+
+-- !hiveParquet5 --
+
+-- !hiveParquet6 --
+1
+
+-- !hiveParquet7 --
+name
+
+-- !hiveParquet8 --
+1 name
+
+-- !hiveOrc1 --
+1 name
+
+-- !hiveOrc2 --
+1 name
+
+-- !hiveOrc3 --
+
+-- !hiveOrc4 --
+1 name
+
+-- !hiveOrc5 --
+
+-- !hiveOrc6 --
+1
+
+-- !hiveOrc7 --
+name
+
+-- !hiveOrc8 --
+1 name
+
diff --git
a/regression-test/suites/external_table_p0/hive/hive_tpch_sf1_orc.groovy
b/regression-test/suites/external_table_p0/hive/hive_tpch_sf1_orc.groovy
index 2d8ece4b922..be8007c3016 100644
--- a/regression-test/suites/external_table_p0/hive/hive_tpch_sf1_orc.groovy
+++ b/regression-test/suites/external_table_p0/hive/hive_tpch_sf1_orc.groovy
@@ -846,7 +846,9 @@ order by
q22()
}
- String enabled = context.config.otherConfigs.get("enableHiveTest")
+ // String enabled = context.config.otherConfigs.get("enableHiveTest")
+ // cost too much time in p0, disable it temporary
+ String enabled = "false";
if (enabled == null || !enabled.equalsIgnoreCase("true")) {
logger.info("diable Hive test.")
return;
diff --git
a/regression-test/suites/external_table_p0/hive/hive_tpch_sf1_parquet.groovy
b/regression-test/suites/external_table_p0/hive/hive_tpch_sf1_parquet.groovy
index 3209bd9ae67..6750e57319f 100644
--- a/regression-test/suites/external_table_p0/hive/hive_tpch_sf1_parquet.groovy
+++ b/regression-test/suites/external_table_p0/hive/hive_tpch_sf1_parquet.groovy
@@ -846,7 +846,9 @@ order by
q22()
}
- String enabled = context.config.otherConfigs.get("enableHiveTest")
+ // String enabled = context.config.otherConfigs.get("enableHiveTest")
+ // cost too much time in p0, disable it temporary
+ String enabled = "false";
if (enabled == null || !enabled.equalsIgnoreCase("true")) {
logger.info("diable Hive test.")
return;
diff --git
a/regression-test/suites/external_table_p2/hive/test_external_credit_data.groovy
b/regression-test/suites/external_table_p0/hive/test_external_credit_data.groovy
similarity index 88%
rename from
regression-test/suites/external_table_p2/hive/test_external_credit_data.groovy
rename to
regression-test/suites/external_table_p0/hive/test_external_credit_data.groovy
index 00f379c2228..2be0ab2920f 100644
---
a/regression-test/suites/external_table_p2/hive/test_external_credit_data.groovy
+++
b/regression-test/suites/external_table_p0/hive/test_external_credit_data.groovy
@@ -15,21 +15,22 @@
// specific language governing permissions and limitations
// under the License.
-suite("test_external_credit_data",
"p2,external,hive,external_remote,external_remote_hive") {
- String enabled = context.config.otherConfigs.get("enableExternalHiveTest")
- if (enabled != null && enabled.equalsIgnoreCase("true")) {
- String extHiveHmsHost =
context.config.otherConfigs.get("extHiveHmsHost")
- String extHiveHmsPort =
context.config.otherConfigs.get("extHiveHmsPort")
- String catalog_name = "test_external_credit_data"
-
- sql """drop catalog if exists ${catalog_name};"""
+suite("test_external_credit_data",
"p0,external,hive,external_docker,external_docker_hive") {
+ String enabled = context.config.otherConfigs.get("enableHiveTest")
+ if (enabled == null || !enabled.equalsIgnoreCase("true")) {
+ logger.info("diable Hive test.")
+ return;
+ }
+ for (String hivePrefix : ["hive2", "hive3"]) {
+ String hms_port = context.config.otherConfigs.get(hivePrefix +
"HmsPort")
+ String catalog_name = "${hivePrefix}_test_external_credit_data"
+ String externalEnvIp = context.config.otherConfigs.get("externalEnvIp")
- sql """
- create catalog if not exists ${catalog_name} properties (
- 'type'='hms',
- 'hive.metastore.uris' =
'thrift://${extHiveHmsHost}:${extHiveHmsPort}'
- );
- """
+ sql """drop catalog if exists ${catalog_name}"""
+ sql """create catalog if not exists ${catalog_name} properties (
+ "type"="hms",
+ 'hive.metastore.uris' = 'thrift://${externalEnvIp}:${hms_port}'
+ );"""
sql """switch ${catalog_name};"""
sql """use regression;"""
diff --git
a/regression-test/suites/external_table_p2/hive/test_compress_type.groovy
b/regression-test/suites/external_table_p0/hive/test_hive_compress_type.groovy
similarity index 86%
rename from
regression-test/suites/external_table_p2/hive/test_compress_type.groovy
rename to
regression-test/suites/external_table_p0/hive/test_hive_compress_type.groovy
index 268db352722..4117501eff2 100644
--- a/regression-test/suites/external_table_p2/hive/test_compress_type.groovy
+++
b/regression-test/suites/external_table_p0/hive/test_hive_compress_type.groovy
@@ -15,25 +15,24 @@
// specific language governing permissions and limitations
// under the License.
-suite("test_compress_type",
"p2,external,hive,external_remote,external_remote_hive") {
- String enabled = context.config.otherConfigs.get("enableExternalHiveTest")
- if (enabled != null && enabled.equalsIgnoreCase("true")) {
- String extHiveHmsHost =
context.config.otherConfigs.get("extHiveHmsHost")
- String extHiveHmsPort =
context.config.otherConfigs.get("extHiveHmsPort")
- String catalog_name = "test_compress_type"
- sql """drop catalog if exists ${catalog_name};"""
- sql """
- create catalog if not exists ${catalog_name} properties (
- 'type'='hms',
- 'hadoop.username' = 'hadoop',
- 'hive.metastore.uris' =
'thrift://${extHiveHmsHost}:${extHiveHmsPort}'
- );
- """
- logger.info("catalog " + catalog_name + " created")
- sql """switch ${catalog_name};"""
- logger.info("switched to catalog " + catalog_name)
-
- sql """ use multi_catalog """
+suite("test_hive_compress_type",
"p0,external,hive,external_docker,external_docker_hive") {
+ String enabled = context.config.otherConfigs.get("enableHiveTest")
+ if (enabled == null || !enabled.equalsIgnoreCase("true")) {
+ logger.info("diable Hive test.")
+ return;
+ }
+
+ for (String hivePrefix : ["hive2", "hive3"]) {
+ String hms_port = context.config.otherConfigs.get(hivePrefix +
"HmsPort")
+ String catalog_name = "${hivePrefix}_test_hive_compress_type"
+ String externalEnvIp = context.config.otherConfigs.get("externalEnvIp")
+
+ sql """drop catalog if exists ${catalog_name}"""
+ sql """create catalog if not exists ${catalog_name} properties (
+ "type"="hms",
+ 'hive.metastore.uris' = 'thrift://${externalEnvIp}:${hms_port}'
+ );"""
+ sql """use `${catalog_name}`.`multi_catalog`"""
// table test_compress_partitioned has 6 partitions with different
compressed file: plain, gzip, bzip2, deflate
sql """set file_split_size=0"""
@@ -128,7 +127,5 @@ suite("test_compress_type",
"p2,external,hive,external_remote,external_remote_hi
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
limit 10;
"""
-
-
}
}
diff --git
a/regression-test/suites/external_table_p2/hive/test_hive_to_date.groovy
b/regression-test/suites/external_table_p0/hive/test_hive_to_date.groovy
similarity index 60%
rename from
regression-test/suites/external_table_p2/hive/test_hive_to_date.groovy
rename to regression-test/suites/external_table_p0/hive/test_hive_to_date.groovy
index 30edf2c8110..c6ba99e9412 100644
--- a/regression-test/suites/external_table_p2/hive/test_hive_to_date.groovy
+++ b/regression-test/suites/external_table_p0/hive/test_hive_to_date.groovy
@@ -15,24 +15,25 @@
// specific language governing permissions and limitations
// under the License.
-suite("test_hive_to_date",
"p2,external,hive,external_remote,external_remote_hive") {
- String enabled = context.config.otherConfigs.get("enableExternalHiveTest")
- if (enabled != null && enabled.equalsIgnoreCase("true")) {
- String extHiveHmsHost =
context.config.otherConfigs.get("extHiveHmsHost")
- String extHiveHmsPort =
context.config.otherConfigs.get("extHiveHmsPort")
- String catalog_name = "test_hive_to_date"
- sql """drop catalog if exists ${catalog_name};"""
- sql """
- create catalog if not exists ${catalog_name} properties (
- 'type'='hms',
- 'hadoop.username' = 'hadoop',
- 'hive.metastore.uris' =
'thrift://${extHiveHmsHost}:${extHiveHmsPort}'
- );
- """
- logger.info("catalog " + catalog_name + " created")
- sql """switch ${catalog_name};"""
- logger.info("switched to catalog " + catalog_name)
- sql """use multi_catalog;"""
+suite("test_hive_to_date",
"p0,external,hive,external_docker,external_docker_hive") {
+ String enabled = context.config.otherConfigs.get("enableHiveTest")
+ if (enabled == null || !enabled.equalsIgnoreCase("true")) {
+ logger.info("diable Hive test.")
+ return;
+ }
+
+ for (String hivePrefix : ["hive2", "hive3"]) {
+ String hms_port = context.config.otherConfigs.get(hivePrefix +
"HmsPort")
+ String catalog_name = "${hivePrefix}_test_hive_to_date"
+ String externalEnvIp = context.config.otherConfigs.get("externalEnvIp")
+
+ sql """drop catalog if exists ${catalog_name}"""
+ sql """create catalog if not exists ${catalog_name} properties (
+ "type"="hms",
+ 'hive.metastore.uris' = 'thrift://${externalEnvIp}:${hms_port}'
+ );"""
+ sql """use `${catalog_name}`.`multi_catalog`"""
+
sql """set enable_nereids_planner=true;"""
sql """set enable_fallback_to_original_planner=false"""
qt_1 "select * from datev2_csv"
diff --git
a/regression-test/suites/external_table_p0/hive/test_upper_case_column_name.groovy
b/regression-test/suites/external_table_p0/hive/test_upper_case_column_name.groovy
new file mode 100644
index 00000000000..76246398613
--- /dev/null
+++
b/regression-test/suites/external_table_p0/hive/test_upper_case_column_name.groovy
@@ -0,0 +1,103 @@
+// Licensed to the Apache Software Foundation (ASF) under one
+// or more contributor license agreements. See the NOTICE file
+// distributed with this work for additional information
+// regarding copyright ownership. The ASF licenses this file
+// to you under the Apache License, Version 2.0 (the
+// "License"); you may not use this file except in compliance
+// with the License. You may obtain a copy of the License at
+//
+// http://www.apache.org/licenses/LICENSE-2.0
+//
+// Unless required by applicable law or agreed to in writing,
+// software distributed under the License is distributed on an
+// "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+// KIND, either express or implied. See the License for the
+// specific language governing permissions and limitations
+// under the License.
+
+suite("test_upper_case_column_name",
"p0,external,hive,external_docker,external_docker_hive") {
+ def hiveParquet1 = """select * from hive_upper_case_parquet;"""
+ def hiveParquet2 = """select * from hive_upper_case_parquet where id=1;"""
+ def hiveParquet3 = """select * from hive_upper_case_parquet where id>1;"""
+ def hiveParquet4 = """select * from hive_upper_case_parquet where
name='name';"""
+ def hiveParquet5 = """select * from hive_upper_case_parquet where
name!='name';"""
+ def hiveParquet6 = """select id from hive_upper_case_parquet where id=1;"""
+ def hiveParquet7 = """select name from hive_upper_case_parquet where
id=1;"""
+ def hiveParquet8 = """select id, name from hive_upper_case_parquet where
id=1;"""
+ def hiveOrc1 = """select * from hive_upper_case_orc;"""
+ def hiveOrc2 = """select * from hive_upper_case_orc where id=1;"""
+ def hiveOrc3 = """select * from hive_upper_case_orc where id>1;"""
+ def hiveOrc4 = """select * from hive_upper_case_orc where name='name';"""
+ def hiveOrc5 = """select * from hive_upper_case_orc where name!='name';"""
+ def hiveOrc6 = """select id from hive_upper_case_orc where id=1;"""
+ def hiveOrc7 = """select name from hive_upper_case_orc where id=1;"""
+ def hiveOrc8 = """select id, name from hive_upper_case_orc where id=1;"""
+ def icebergParquet1 = """select * from iceberg_upper_case_parquet;"""
+ def icebergParquet2 = """select * from iceberg_upper_case_parquet where
id=1;"""
+ def icebergParquet3 = """select * from iceberg_upper_case_parquet where
id>1;"""
+ def icebergParquet4 = """select * from iceberg_upper_case_parquet where
name='name';"""
+ def icebergParquet5 = """select * from iceberg_upper_case_parquet where
name!='name';"""
+ def icebergParquet6 = """select id from iceberg_upper_case_parquet where
id=1;"""
+ def icebergParquet7 = """select name from iceberg_upper_case_parquet where
id=1;"""
+ def icebergParquet8 = """select id, name from iceberg_upper_case_parquet
where id=1;"""
+ def icebergOrc1 = """select * from iceberg_upper_case_orc;"""
+ def icebergOrc2 = """select * from iceberg_upper_case_orc where id=1;"""
+ def icebergOrc3 = """select * from iceberg_upper_case_orc where id>1;"""
+ def icebergOrc4 = """select * from iceberg_upper_case_orc where
name='name';"""
+ def icebergOrc5 = """select * from iceberg_upper_case_orc where
name!='name';"""
+ def icebergOrc6 = """select id from iceberg_upper_case_orc where id=1;"""
+ def icebergOrc7 = """select name from iceberg_upper_case_orc where id=1;"""
+ def icebergOrc8 = """select id, name from iceberg_upper_case_orc where
id=1;"""
+
+ String enabled = context.config.otherConfigs.get("enableHiveTest")
+ if (enabled == null || !enabled.equalsIgnoreCase("true")) {
+ logger.info("diable Hive test.")
+ return;
+ }
+ for (String hivePrefix : ["hive2", "hive3"]) {
+ String hms_port = context.config.otherConfigs.get(hivePrefix +
"HmsPort")
+ String catalog_name = "${hivePrefix}_test_upper_case_column_name"
+ String externalEnvIp = context.config.otherConfigs.get("externalEnvIp")
+
+ sql """drop catalog if exists ${catalog_name}"""
+ sql """create catalog if not exists ${catalog_name} properties (
+ "type"="hms",
+ 'hive.metastore.uris' = 'thrift://${externalEnvIp}:${hms_port}'
+ );"""
+ sql """use `${catalog_name}`.`multi_catalog`"""
+
+ qt_hiveParquet1 hiveParquet1
+ qt_hiveParquet2 hiveParquet2
+ qt_hiveParquet3 hiveParquet3
+ qt_hiveParquet4 hiveParquet4
+ qt_hiveParquet5 hiveParquet5
+ qt_hiveParquet6 hiveParquet6
+ qt_hiveParquet7 hiveParquet7
+ qt_hiveParquet8 hiveParquet8
+ qt_hiveOrc1 hiveOrc1
+ qt_hiveOrc2 hiveOrc2
+ qt_hiveOrc3 hiveOrc3
+ qt_hiveOrc4 hiveOrc4
+ qt_hiveOrc5 hiveOrc5
+ qt_hiveOrc6 hiveOrc6
+ qt_hiveOrc7 hiveOrc7
+ qt_hiveOrc8 hiveOrc8
+ // qt_icebergParquet1 icebergParquet1
+ // qt_icebergParquet2 icebergParquet2
+ // qt_icebergParquet3 icebergParquet3
+ // qt_icebergParquet4 icebergParquet4
+ // qt_icebergParquet5 icebergParquet5
+ // qt_icebergParquet6 icebergParquet6
+ // qt_icebergParquet7 icebergParquet7
+ // qt_icebergParquet8 icebergParquet8
+ // qt_icebergOrc1 icebergOrc1
+ // qt_icebergOrc2 icebergOrc2
+ // qt_icebergOrc3 icebergOrc3
+ // qt_icebergOrc4 icebergOrc4
+ // qt_icebergOrc5 icebergOrc5
+ // qt_icebergOrc6 icebergOrc6
+ // qt_icebergOrc7 icebergOrc7
+ // qt_icebergOrc8 icebergOrc8
+ }
+}
+
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
