github-actions[bot] commented on code in PR #66204:
URL: https://github.com/apache/doris/pull/66204#discussion_r3676409034
##########
regression-test/suites/variant_p0/insert_into_select.groovy:
##########
@@ -16,6 +16,7 @@
// under the License.
suite("regression_test_variant_insert_into_select", "variant_type"){
+ sql "SET enable_variant_v2 = ${new Random().nextBoolean()}"
Review Comment:
[P1] Keep the V2 routing coverage deterministic.
This suite is now the surviving behavior-level check for the enabled `INSERT
... SELECT` guard, but an unseeded random bit means half of runs never exercise
`enable_variant_v2=true`, and a failure cannot be reproduced from the suite
command. The same pattern was added to 50 suites, making RowID/TopN,
schema-change, compaction, MV/MOW, and index paths individually probabilistic.
The deterministic V2 insert suite that previously closed the existing guard
thread is deleted at this head, and the new `*_v2.sql` workloads do not cover
these lifecycle paths.
Please run the relevant shared cases explicitly under both false and true,
or keep a deterministic V2 allowlist. At minimum, add a stable enabled
INSERT-SELECT case (ideally also an FE switch x insert/select x root/subpath
matrix).
##########
be/src/storage/segment/variant/v2/variant_assembler.cpp:
##########
@@ -0,0 +1,863 @@
+// 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.
+
+#include "storage/segment/variant/v2/variant_assembler.h"
+
+#include <algorithm>
+#include <cstring>
+#include <utility>
+#include <vector>
+
+#include "common/exception.h"
+#include "core/column/column_nullable.h"
+#include "core/column/column_vector.h"
+#include "core/column/variant_column_utils.h"
+#include "core/value/variant/variant_batch_builder.h"
+#include "core/value/variant/variant_parquet_encoding.h"
+#include "exprs/function/parse/variant_jsonb_parse.h"
+
+namespace doris::segment_v2::variant_v2 {
+namespace {
+
+bool row_is_outer_null(const VariantAssemblerBatchView& batch, size_t row)
noexcept {
+ return !batch.outer_nulls.empty() && batch.outer_nulls[row] != 0;
+}
+
+Status publish_encoded(VariantBatchBuilder* builder, MutableColumnPtr
outer_nulls,
+ VariantAssembledColumn* output) {
+ VariantBatchBuilder block = builder->finish_batch();
+ VariantAssembledColumn result;
+ result.values = ColumnVariantV2::create();
+ result.values->insert_encoded_batch(block);
+ result.outer_nulls = std::move(outer_nulls);
+ *output = std::move(result);
+ return Status::OK();
+}
+
+size_t common_prefix(std::span<const StringRef> left, std::span<const
StringRef> right) noexcept {
+ const size_t maximum = std::min(left.size(), right.size());
+ size_t result = 0;
+ while (result < maximum && left[result] == right[result]) {
+ ++result;
+ }
+ return result;
+}
+
+struct StorageMapCursor {
+ const VariantStorageMapView* map = nullptr;
+ std::span<const StringRef> requested;
+ std::string_view description;
+ size_t row = 0;
+ size_t index = 0;
+ size_t end = 0;
+ StringRef previous_path;
+ bool have_previous = false;
+ bool available = false;
+ StringRef cell;
+ StringRef sort_key;
+ DorisVector<StringRef> parts;
+
+ Status reset(const VariantStorageMapView* source, size_t row_index,
+ std::span<const StringRef> requested_path, StringRef
requested_raw,
+ std::string_view source_description) {
+ map = source;
+ requested = requested_path;
+ description = source_description;
+ row = row_index;
+ index = map->begin(row);
+ end = map->end(row);
+ if (requested_raw.size != 0) {
+ index = find_variant_sparse_path_lower_bound(requested_raw,
*map->paths, index, end);
+ }
+ previous_path = {};
+ have_previous = false;
+ available = false;
+ return advance(requested_raw);
+ }
+
+ Status advance(StringRef requested_raw = {}) {
+ available = false;
+ while (index < end) {
+ const StringRef path = map->paths->get_data_at(index);
+ if (requested_raw.size != 0 &&
+ (path.size < requested_raw.size ||
+ std::memcmp(path.data, requested_raw.data,
requested_raw.size) != 0)) {
+ index = end;
+ return Status::OK();
+ }
+ cell = map->values->get_data_at(index);
+ ++index;
+ if (have_previous && previous_path.compare(path) >= 0) {
+ return Status::Corruption("Variant {} row {} paths are not
strictly sorted at {}",
+ description, row, path.to_string());
+ }
+ previous_path = path;
+ have_previous = true;
+
+ RETURN_IF_ERROR(split_variant_sparse_path(path, &parts));
+ if (!variant_path_is_prefix(requested, parts)) {
+ continue;
+ }
+ size_t relative_offset = requested_raw.size;
+ if (!requested.empty() && parts.size() > requested.size()) {
+ ++relative_offset;
+ }
+ sort_key = relative_offset == path.size ? StringRef {}
+ : StringRef {path.data +
relative_offset,
+ path.size -
relative_offset};
+ parts.erase(parts.begin(), parts.begin() + requested.size());
+ if (parts.size() > VARIANT_MAX_NESTING_DEPTH) {
+ return Status::Corruption("Variant sparse/doc path exceeds
maximum depth {}",
+ VARIANT_MAX_NESTING_DEPTH);
+ }
+ available = true;
+ return Status::OK();
+ }
+ return Status::OK();
+ }
+};
+
+struct ObjectEmitter {
+ using ObjectScope = VariantBatchBuilder::Row::ObjectScope;
+
+ VariantBatchBuilder::Row* row = nullptr;
+ DorisVector<StringRef>* previous = nullptr;
+ std::vector<ObjectScope>* scopes = nullptr;
+ bool* is_null = nullptr;
+ bool emitted = false;
+
+ void reset(VariantBatchBuilder::Row* output, DorisVector<StringRef>*
previous_parts,
+ std::vector<ObjectScope>* object_scopes, bool* output_is_null) {
+ row = output;
+ previous = previous_parts;
+ scopes = object_scopes;
+ is_null = output_is_null;
+ previous->clear();
+ scopes->clear();
+ emitted = false;
+ }
+
+ Status prepare(std::span<const StringRef> parts) {
+ if (emitted) {
+ if (compare_variant_path_parts(*previous, parts) == 0) {
+ return Status::Corruption("Duplicate Variant path across
assembled input");
+ }
+ }
+ if (parts.empty()) {
+ if (emitted) {
+ return Status::Corruption(
+ "Variant scalar root storage cell cannot coexist with
child paths");
+ }
+ emitted = true;
+ return Status::OK();
+ }
+ if (emitted && previous->empty()) {
+ return Status::Corruption(
+ "Variant scalar root storage cell cannot coexist with
child paths");
+ }
+
+ const size_t lcp = common_prefix(*previous, parts);
+ if (!previous->empty() && lcp == previous->size() && previous->size()
< parts.size()) {
+ return Status::Corruption("Variant assembled path conflicts with
scalar ancestor");
+ }
+ if (!emitted) {
+ scopes->push_back(row->start_object());
+ }
+ while (scopes->size() > lcp + 1) {
+ scopes->back().finish();
+ scopes->pop_back();
+ }
+ for (size_t part = lcp; part + 1 < parts.size(); ++part) {
+ scopes->back().add_key(parts[part]);
+ scopes->push_back(row->start_object());
+ }
+ scopes->back().add_key(parts.back());
+ previous->assign(parts.begin(), parts.end());
+ emitted = true;
+ return Status::OK();
+ }
+
+ Status append_materialized(std::span<const StringRef> parts,
+ const VariantMaterializedColumnView& column,
size_t row_index) {
+ RETURN_IF_ERROR(prepare(parts));
+ return append_variant_materialized_value(column, row_index, *row,
+
static_cast<uint32_t>(parts.size()));
+ }
+
+ // prepare() mutates the emitter state even though all storage is
pointer-owned.
+ // NOLINTNEXTLINE(readability-make-member-function-const)
+ Status append_cell(std::span<const StringRef> parts, StringRef value) {
+ RETURN_IF_ERROR(prepare(parts));
+ return append_variant_storage_cell(value, *row,
static_cast<uint32_t>(parts.size()),
+ parts.empty() ? is_null : nullptr);
+ }
+
+ void finish() const {
+ if (!emitted) {
+ auto object = row->start_object();
+ object.finish();
+ return;
+ }
+ while (!scopes->empty()) {
+ scopes->back().finish();
+ scopes->pop_back();
+ }
+ }
+};
+
+Status validate_no_hierarchical_streams(const VariantAssemblerBatchView& batch,
+ std::string_view mode) {
+ if (!batch.materialized_columns.empty() || batch.sparse_values != nullptr
||
+ batch.doc_values != nullptr) {
+ return Status::InvalidArgument("Variant {} batch supplied a
hierarchical stream", mode);
+ }
+ return Status::OK();
+}
+
+Status validate_no_binary_streams(const VariantAssemblerBatchView& batch,
std::string_view mode) {
+ if (!batch.binary_values.empty() || !batch.binary_missing.empty()) {
+ return Status::InvalidArgument("Variant {} batch supplied a binary
stream", mode);
+ }
+ return Status::OK();
+}
+
+Status validate_common_batch(const VariantAssemblerBatchView& batch) {
+ if (!batch.outer_nulls.empty() && batch.outer_nulls.size() !=
batch.num_rows) {
+ return Status::InvalidArgument("Variant outer-null span has {} rows,
expected {}",
+ batch.outer_nulls.size(),
batch.num_rows);
+ }
+ return Status::OK();
+}
+
+Status assemble_binary(const VariantAssemblerBatchView& batch,
VariantAssembledColumn* output) {
+ RETURN_IF_ERROR(validate_no_hierarchical_streams(batch, "BINARY_EXTRACT"));
+ if (batch.root_jsonb != nullptr) {
+ return Status::InvalidArgument("Variant BINARY_EXTRACT batch supplied
a root stream");
+ }
+ if (batch.binary_values.size() != batch.num_rows) {
+ return Status::Corruption("Variant binary input must contain {} rows",
batch.num_rows);
+ }
+ if (!batch.binary_missing.empty() && batch.binary_missing.size() !=
batch.num_rows) {
+ return Status::InvalidArgument("Variant binary-missing span has {}
rows, expected {}",
+ batch.binary_missing.size(),
batch.num_rows);
+ }
+ bool built_typed = false;
+ RETURN_IF_ERROR(try_build_typed_variant_storage_cells(batch.binary_values,
batch.outer_nulls,
+
batch.binary_missing, batch.num_rows,
+ output,
&built_typed));
+ if (built_typed) {
+ return Status::OK();
+ }
+
+ VariantBatchBuilder builder({.rows = batch.num_rows});
+ auto outer = ColumnUInt8::create();
+ for (size_t row_index = 0; row_index < batch.num_rows; ++row_index) {
+ auto row = builder.begin_row();
+ const bool is_missing =
+ row_is_outer_null(batch, row_index) ||
+ (!batch.binary_missing.empty() &&
batch.binary_missing[row_index] != 0);
+ if (is_missing) {
+ outer->insert_value(1);
+ row.add_null();
+ } else {
+ bool is_null = false;
+ RETURN_IF_ERROR(
+
append_variant_storage_cell(batch.binary_values[row_index], row, 0, &is_null));
+ outer->insert_value(is_null ? 1 : 0);
+ }
+ row.finish();
+ }
+ return publish_encoded(&builder, std::move(outer), output);
+}
+
+struct PreparedHierarchicalBatch {
+ VariantRootColumnView root;
+ DorisVector<VariantMaterializedColumnView> materialized;
+ VariantStorageMapView sparse;
+ VariantStorageMapView doc;
+};
+
+bool has_materialized_value(std::span<const VariantMaterializedColumnView>
materialized,
+ size_t row) {
+ return std::any_of(
+ materialized.begin(), materialized.end(),
+ [row](const VariantMaterializedColumnView& column) { return
!column.is_null_at(row); });
+}
+
+bool has_sparse_value(const VariantStorageMapView& sparse, bool enabled,
size_t row) {
+ return enabled && sparse.begin(row) != sparse.end(row);
+}
+
+Status prepare_hierarchical_batch(
+ bool has_sparse, bool has_root, bool has_doc,
+ std::span<const VariantAssemblerCompiledPath> compiled_materialized,
+ const VariantAssemblerBatchView& batch, PreparedHierarchicalBatch*
output) {
+ RETURN_IF_ERROR(validate_no_binary_streams(batch, "HIERARCHICAL"));
+ if (batch.materialized_columns.size() != compiled_materialized.size()) {
+ return Status::Corruption("Variant batch has {} materialized columns,
expected {}",
+ batch.materialized_columns.size(),
compiled_materialized.size());
+ }
+ if ((batch.sparse_values != nullptr) != has_sparse) {
+ return Status::Corruption("Variant batch sparse stream presence does
not match options");
+ }
+ if (has_root) {
+ RETURN_IF_ERROR(prepare_variant_root(batch.root_jsonb, batch.num_rows,
&output->root));
+ } else if (batch.root_jsonb != nullptr) {
+ return Status::InvalidArgument("Variant batch supplied a disabled root
stream");
+ }
+
+ output->materialized.resize(compiled_materialized.size());
+ for (size_t index = 0; index < output->materialized.size(); ++index) {
+ RETURN_IF_ERROR(prepare_variant_materialized_column(
+ compiled_materialized[index].type,
+
batch.materialized_columns[compiled_materialized[index].source_index],
+ batch.num_rows, &output->materialized[index]));
+ }
+ if (has_sparse) {
+ RETURN_IF_ERROR(prepare_variant_storage_map(batch.sparse_values,
batch.num_rows, "sparse",
+ &output->sparse));
+ }
+ if (has_doc) {
+ RETURN_IF_ERROR(
+ prepare_variant_storage_map(batch.doc_values, batch.num_rows,
"doc", &output->doc));
+ } else if (batch.doc_values != nullptr) {
+ return Status::InvalidArgument("Variant batch supplied a disabled doc
stream");
+ }
+ return Status::OK();
+}
+
+struct MergeSelection {
+ std::span<const StringRef> parts;
+ StringRef raw_path;
+ bool available = false;
+ bool sparse = false;
+};
+
+struct MergeValue {
+ StringRef raw_path;
+ std::span<const StringRef> materialized_parts;
+ const VariantMaterializedColumnView* materialized = nullptr;
+ StringRef cell;
+ bool logical_root = false;
+
+ void set_materialized(std::span<const StringRef> path, StringRef raw,
+ const VariantMaterializedColumnView* column) {
+ raw_path = raw;
+ materialized_parts = path;
+ materialized = column;
+ cell = {};
+ logical_root = path.empty();
+ }
+
+ void set_cell(std::span<const StringRef> path, StringRef raw, StringRef
value) {
+ raw_path = raw;
+ materialized_parts = {};
+ materialized = nullptr;
+ cell = value;
+ logical_root = path.empty();
+ }
+};
+
+Status append_merge_value(const MergeValue& value, size_t row,
DorisVector<StringRef>* scratch,
+ ObjectEmitter* emitter) {
+ if (value.materialized != nullptr) {
+ return emitter->append_materialized(value.materialized_parts,
*value.materialized, row);
+ }
+ if (value.logical_root) {
+ scratch->clear();
+ } else {
+ RETURN_IF_ERROR(split_variant_sparse_path(value.raw_path, scratch));
+ }
+ return emitter->append_cell(*scratch, value.cell);
+}
+
+Status submit_component_merge_value(const MergeValue& current, MergeValue*
pending,
+ bool* has_pending, size_t row,
ObjectEmitter* emitter) {
+ DORIS_CHECK(current.materialized != nullptr);
+ if (!*has_pending) {
+ *pending = current;
+ *has_pending = true;
+ return Status::OK();
+ }
+
+ const int comparison =
+ compare_variant_path_parts(pending->materialized_parts,
current.materialized_parts);
+ if (comparison == 0) {
+ return Status::Corruption("Duplicate Variant path across assembled
input");
+ }
+ if (comparison > 0) {
+ return Status::Corruption("Variant assembled input paths are not
sorted");
+ }
+
+ // Legacy V1 data may contain both a scalar ancestor and descendants in
the same row when
+ // duplicate-path checking keeps the first flattened value. V1 assembly
lets descendants form
+ // the visible object. Keep one pending value so the ancestor can be
discarded without sorting,
+ // hashing, copying its payload, or rescanning the row.
+ if (variant_path_is_prefix(pending->materialized_parts,
current.materialized_parts)) {
+ *pending = current;
+ return Status::OK();
+ }
+
+ RETURN_IF_ERROR(
+ emitter->append_materialized(pending->materialized_parts,
*pending->materialized, row));
+ *pending = current;
+ return Status::OK();
+}
+
+Status finish_component_merge_value(const MergeValue& pending, bool
has_pending, size_t row,
+ ObjectEmitter* emitter) {
+ return has_pending ?
emitter->append_materialized(pending.materialized_parts,
+ *pending.materialized,
row)
+ : Status::OK();
+}
+
+bool raw_path_is_descendant(const MergeValue& ancestor, const MergeValue&
value) noexcept {
+ if (ancestor.logical_root) {
+ return !value.logical_root;
+ }
+ if (value.logical_root || value.raw_path.size <= ancestor.raw_path.size) {
+ return false;
+ }
+ if (ancestor.raw_path.size == 0) {
+ return value.raw_path.data[0] == '.';
+ }
+ return std::memcmp(value.raw_path.data, ancestor.raw_path.data,
ancestor.raw_path.size) == 0 &&
+ value.raw_path.data[ancestor.raw_path.size] == '.';
+}
+
+int compare_with_raw_descendant_start(StringRef value, StringRef ancestor)
noexcept {
+ const size_t common = std::min(value.size, ancestor.size);
+ const int comparison = common == 0 ? 0 : std::memcmp(value.data,
ancestor.data, common);
+ if (comparison != 0) {
+ return comparison;
+ }
+ if (value.size <= ancestor.size) {
+ return -1;
+ }
+ const auto next = static_cast<unsigned char>(value.data[ancestor.size]);
+ return next < static_cast<unsigned char>('.') ? -1
+ : next > static_cast<unsigned char>('.') ? 1
+ : 0;
+}
+
+void push_raw_merge_value(const MergeValue& value, DorisVector<MergeValue>*
pending,
+ size_t* pending_size) {
+ if (*pending_size == pending->size()) {
+ pending->push_back(value);
+ } else {
+ (*pending)[*pending_size] = value;
+ }
+ ++*pending_size;
+}
+
+Status submit_raw_merge_value(const MergeValue& current,
DorisVector<MergeValue>* pending,
+ size_t* pending_size, size_t row,
DorisVector<StringRef>* merge_parts,
+ ObjectEmitter* emitter) {
+ while (*pending_size != 0) {
+ const MergeValue& previous = (*pending)[*pending_size - 1];
+ const int raw_comparison = previous.raw_path.compare(current.raw_path);
+ if (raw_comparison > 0) {
+ return Status::Corruption("Variant assembled input paths are not
sorted");
+ }
+ if (raw_comparison == 0 && previous.logical_root ==
current.logical_root) {
+ return Status::Corruption("Duplicate Variant path across assembled
input");
+ }
+ if (raw_path_is_descendant(previous, current)) {
+ --*pending_size;
+ continue;
+ }
+ if (compare_with_raw_descendant_start(current.raw_path,
previous.raw_path) < 0) {
+ break;
+ }
+ RETURN_IF_ERROR(append_merge_value(previous, row, merge_parts,
emitter));
+ --*pending_size;
+ }
+ push_raw_merge_value(current, pending, pending_size);
+ return Status::OK();
+}
+
+Status finish_raw_merge_values(DorisVector<MergeValue>* pending, size_t
pending_size, size_t row,
+ DorisVector<StringRef>* merge_parts,
ObjectEmitter* emitter) {
+ while (pending_size != 0) {
+ --pending_size;
+ RETURN_IF_ERROR(append_merge_value((*pending)[pending_size], row,
merge_parts, emitter));
+ }
+ return Status::OK();
+}
+
+Status emit_doc_row(const VariantStorageMapView& doc, size_t row,
+ std::span<const StringRef> requested, StringRef
requested_raw,
+ StorageMapCursor* cursor, DorisVector<MergeValue>*
pending_stack,
+ MergeValue* current, DorisVector<StringRef>* merge_parts,
+ ObjectEmitter* emitter) {
+ RETURN_IF_ERROR(cursor->reset(&doc, row, requested, requested_raw, "doc"));
+ size_t pending_size = 0;
+ while (cursor->available) {
+ current->set_cell(cursor->parts, cursor->sort_key, cursor->cell);
+ RETURN_IF_ERROR(cursor->advance(requested_raw));
+ RETURN_IF_ERROR(submit_raw_merge_value(*current, pending_stack,
&pending_size, row,
+ merge_parts, emitter));
+ }
+ return finish_raw_merge_values(pending_stack, pending_size, row,
merge_parts, emitter);
+}
+
+MergeSelection select_next_source(
+ std::span<const VariantAssemblerCompiledPath> compiled_materialized,
+ size_t materialized_index, const StorageMapCursor* sparse_cursor) {
+ MergeSelection selection;
+ if (materialized_index < compiled_materialized.size()) {
+ selection.parts = compiled_materialized[materialized_index].parts;
+ const std::string& path =
compiled_materialized[materialized_index].path.get_path();
+ selection.raw_path = {path.data(), path.size()};
+ selection.available = true;
+ }
+ if (sparse_cursor != nullptr && sparse_cursor->available &&
+ (!selection.available ||
sparse_cursor->sort_key.compare(selection.raw_path) < 0)) {
+ selection.parts = sparse_cursor->parts;
+ selection.raw_path = sparse_cursor->sort_key;
+ selection.available = true;
+ selection.sparse = true;
+ }
+ return selection;
+}
+
+Status emit_merged_row(std::span<const VariantMaterializedColumnView>
materialized,
+ const VariantStorageMapView* sparse,
+ std::span<const VariantAssemblerCompiledPath>
compiled_materialized,
+ size_t row, std::span<const StringRef> requested,
StringRef requested_raw,
+ StorageMapCursor* sparse_cursor, bool raw_path_order,
+ MergeValue* component_pending, DorisVector<MergeValue>*
pending_stack,
+ MergeValue* current, DorisVector<StringRef>*
merge_parts,
+ ObjectEmitter* emitter) {
+ if (sparse != nullptr) {
+ RETURN_IF_ERROR(sparse_cursor->reset(sparse, row, requested,
requested_raw, "sparse"));
+ }
+ size_t materialized_index = 0;
+ bool has_component_pending = false;
+ size_t pending_size = 0;
+ while (true) {
+ while (materialized_index < materialized.size() &&
Review Comment:
[P1] Preserve the legacy visibility rule for empty materialized arrays.
This merge skips only physical `NULL`s, and
`append_variant_materialized_value` emits every other ARRAY, including `[]`,
`[null]`, and recursively empty shells. Legacy V1 deliberately treats those
materialized values as absent through `Subcolumn::is_empty_nested`; its row
serializer and the new V1 outer-null calculation both use that rule.
Consequently a persisted row such as `{"a":[],"b":1}` is read as `{"b":1}`
through V1 but `{"a":[],"b":1}` through V2 (and an otherwise-empty row can also
change outer nullness).
Please apply the same empty-nested predicate before counting/emitting
materialized ARRAY values, and add writer-reader parity cases for `[]`,
`[null]`, `[{}]`, recursive empty shells, JSON null, and SQL NULL for both
whole-column and subtree reads.
##########
regression-test/suites/variant_p0/rqg_v2/rqg1_v2.sql:
##########
@@ -0,0 +1,39 @@
+SET enable_variant_v2 = true;
+CREATE TABLE IF NOT EXISTS
table_24_undef_partitions2_keys3_properties4_distributed_by5 ( pk int, var
VARIANT NULL ) engine=olap DUPLICATE KEY(pk) distributed by hash(pk) buckets 10
properties("replication_num" = "1");
+INSERT INTO
table_24_undef_partitions2_keys3_properties4_distributed_by5(pk,var) VALUES
('0','{\"col_int_undef_signed\": null, \"col_varchar_10__undef_signed\":
\"\"}'),('1','{\"col_int_undef_signed\": 8, \"col_varchar_10__undef_signed\":
\"\"}'),('2','{\"col_int_undef_signed\": null,
\"col_varchar_10__undef_signed\": null}'),('3','{\"col_int_undef_signed\":
null, \"col_varchar_10__undef_signed\":
\"with\"}'),('4','{\"col_int_undef_signed\": null,
\"col_varchar_10__undef_signed\": \"\"}'),('5','{\"col_int_undef_signed\":
null, \"col_varchar_10__undef_signed\":
null}'),('6','{\"col_int_undef_signed\": 4, \"col_varchar_10__undef_signed\":
null}'),('7','{\"col_int_undef_signed\": 6, \"col_varchar_10__undef_signed\":
\"s\"}'),('8','{\"col_int_undef_signed\": null,
\"col_varchar_10__undef_signed\": null}'),('9','{\"col_int_undef_signed\":
null, \"col_varchar_10__undef_signed\":
null}'),('10','{\"col_int_undef_signed\": 4, \"col_varchar_10__undef_signed\":
\"of\"}'),('11','{\"col_int_unde
f_signed\": null, \"col_varchar_10__undef_signed\":
null}'),('12','{\"col_int_undef_signed\": 9, \"col_varchar_10__undef_signed\":
null}'),('13','{\"col_int_undef_signed\": 0, \"col_varchar_10__undef_signed\":
\"k\"}'),('14','{\"col_int_undef_signed\": null,
\"col_varchar_10__undef_signed\": \"can\"}'),('15','{\"col_int_undef_signed\":
2, \"col_varchar_10__undef_signed\": \"x\"}'),('16','{\"col_int_undef_signed\":
9, \"col_varchar_10__undef_signed\": \"\"}'),('17','{\"col_int_undef_signed\":
0, \"col_varchar_10__undef_signed\": \"q\"}'),('18','{\"col_int_undef_signed\":
3, \"col_varchar_10__undef_signed\": \"l\"}'),('19','{\"col_int_undef_signed\":
2, \"col_varchar_10__undef_signed\":
\"that\"}'),('20','{\"col_int_undef_signed\": null,
\"col_varchar_10__undef_signed\": null}'),('21','{\"col_int_undef_signed\":
null, \"col_varchar_10__undef_signed\":
\"\"}'),('22','{\"col_int_undef_signed\": 2, \"col_varchar_10__undef_signed\":
\"yes\"}'),('23','{\"col_int_undef_signed\": null, \"col
_varchar_10__undef_signed\": null}');
+CREATE TABLE IF NOT EXISTS
table_24_undef_partitions2_keys3_properties4_distributed_by5 ( pk int, var
VARIANT NULL ) engine=olap DUPLICATE KEY(pk) distributed by hash(pk) buckets 10
properties("replication_num" = "1");
+INSERT INTO
table_24_undef_partitions2_keys3_properties4_distributed_by5(pk,var) VALUES
('0','{\"col_int_undef_signed\": null, \"col_varchar_10__undef_signed\": \"o\",
\"col_varchar_1024__undef_signed\": \"c\"}'),('1','{\"col_int_undef_signed\":
null, \"col_varchar_10__undef_signed\": \"m\",
\"col_varchar_1024__undef_signed\": \"j\"}'),('2','{\"col_int_undef_signed\":
null, \"col_varchar_10__undef_signed\": \"r\",
\"col_varchar_1024__undef_signed\": \"had\"}'),('3','{\"col_int_undef_signed\":
3, \"col_varchar_10__undef_signed\": \"t\", \"col_varchar_1024__undef_signed\":
\"q\"}'),('4','{\"col_int_undef_signed\": null,
\"col_varchar_10__undef_signed\": \"be\", \"col_varchar_1024__undef_signed\":
\"on\"}'),('5','{\"col_int_undef_signed\": 1, \"col_varchar_10__undef_signed\":
\"but\", \"col_varchar_1024__undef_signed\":
\"d\"}'),('6','{\"col_int_undef_signed\": null,
\"col_varchar_10__undef_signed\": \"w\", \"col_varchar_1024__undef_signed\":
\"could\"}'),('7','{\"col_int_undef_signed\
": null, \"col_varchar_10__undef_signed\": \"p\",
\"col_varchar_1024__undef_signed\":
\"some\"}'),('8','{\"col_int_undef_signed\": null,
\"col_varchar_10__undef_signed\": \"that\'\'s\",
\"col_varchar_1024__undef_signed\":
\"okay\"}'),('9','{\"col_int_undef_signed\": 3,
\"col_varchar_10__undef_signed\": \"t\", \"col_varchar_1024__undef_signed\":
\"you\'\'re\"}'),('10','{\"col_int_undef_signed\": null,
\"col_varchar_10__undef_signed\": \"x\", \"col_varchar_1024__undef_signed\":
\"with\"}'),('11','{\"col_int_undef_signed\": 7,
\"col_varchar_10__undef_signed\": \"h\", \"col_varchar_1024__undef_signed\":
\"the\"}'),('12','{\"col_int_undef_signed\": null,
\"col_varchar_10__undef_signed\": \"c\", \"col_varchar_1024__undef_signed\":
\"you\"}'),('13','{\"col_int_undef_signed\": 4,
\"col_varchar_10__undef_signed\": \"had\", \"col_varchar_1024__undef_signed\":
\"a\"}'),('14','{\"col_int_undef_signed\": 3, \"col_varchar_10__undef_signed\":
\"o\", \"col_varchar_1024__undef_signed\": \"v\"}'),('1
5','{\"col_int_undef_signed\": null, \"col_varchar_10__undef_signed\": \"d\",
\"col_varchar_1024__undef_signed\": \"as\"}'),('16','{\"col_int_undef_signed\":
5, \"col_varchar_10__undef_signed\": \"you\'\'re\",
\"col_varchar_1024__undef_signed\": \"p\"}'),('17','{\"col_int_undef_signed\":
null, \"col_varchar_10__undef_signed\": \"m\",
\"col_varchar_1024__undef_signed\":
\"not\"}'),('18','{\"col_int_undef_signed\": 9,
\"col_varchar_10__undef_signed\": \"f\", \"col_varchar_1024__undef_signed\":
\"n\"}'),('19','{\"col_int_undef_signed\": null,
\"col_varchar_10__undef_signed\": \"what\", \"col_varchar_1024__undef_signed\":
\"of\"}'),('20','{\"col_int_undef_signed\": 1,
\"col_varchar_10__undef_signed\": \"my\", \"col_varchar_1024__undef_signed\":
\"that\'\'s\"}'),('21','{\"col_int_undef_signed\": null,
\"col_varchar_10__undef_signed\": \"p\", \"col_varchar_1024__undef_signed\":
\"a\"}'),('22','{\"col_int_undef_signed\": 0, \"col_varchar_10__undef_signed\":
\"d\", \"col_varchar_1024__undef
_signed\": \"t\"}'),('23','{\"col_int_undef_signed\": 9,
\"col_varchar_10__undef_signed\": \"o\", \"col_varchar_1024__undef_signed\":
\"y\"}');
+CREATE TABLE IF NOT EXISTS
table_24_undef_partitions2_keys3_properties4_distributed_by52 ( pk int, var
VARIANT NULL ) engine=olap DUPLICATE KEY(pk) distributed by hash(pk) buckets 10
properties("replication_num" = "1");
+INSERT INTO
table_24_undef_partitions2_keys3_properties4_distributed_by52(pk,var) VALUES
('0','{\"col_int_undef_signed\": 4, \"col_varchar_10__undef_signed\": \"well\",
\"col_varchar_1024__undef_signed\":
\"well\"}'),('1','{\"col_int_undef_signed\": null,
\"col_varchar_10__undef_signed\": \"b\", \"col_varchar_1024__undef_signed\":
\"how\"}'),('2','{\"col_int_undef_signed\": 9,
\"col_varchar_10__undef_signed\": \"then\", \"col_varchar_1024__undef_signed\":
\"n\"}'),('3','{\"col_int_undef_signed\": 5, \"col_varchar_10__undef_signed\":
\"z\", \"col_varchar_1024__undef_signed\":
\"o\"}'),('4','{\"col_int_undef_signed\": 3, \"col_varchar_10__undef_signed\":
\"w\", \"col_varchar_1024__undef_signed\":
\"i\"}'),('5','{\"col_int_undef_signed\": 7, \"col_varchar_10__undef_signed\":
\"in\", \"col_varchar_1024__undef_signed\":
\"x\"}'),('6','{\"col_int_undef_signed\": null,
\"col_varchar_10__undef_signed\": \"are\", \"col_varchar_1024__undef_signed\":
\"to\"}'),('7','{\"col_int_undef_signed\":
5, \"col_varchar_10__undef_signed\": \"and\",
\"col_varchar_1024__undef_signed\": \"u\"}'),('8','{\"col_int_undef_signed\":
null, \"col_varchar_10__undef_signed\": \"because\",
\"col_varchar_1024__undef_signed\": \"r\"}'),('9','{\"col_int_undef_signed\":
6, \"col_varchar_10__undef_signed\": \"j\", \"col_varchar_1024__undef_signed\":
\"t\"}'),('10','{\"col_int_undef_signed\": null,
\"col_varchar_10__undef_signed\": \"r\", \"col_varchar_1024__undef_signed\":
\"l\"}'),('11','{\"col_int_undef_signed\": null,
\"col_varchar_10__undef_signed\": \"f\", \"col_varchar_1024__undef_signed\":
\"k\"}'),('12','{\"col_int_undef_signed\": 9, \"col_varchar_10__undef_signed\":
\"is\", \"col_varchar_1024__undef_signed\":
\"got\"}'),('13','{\"col_int_undef_signed\": 4,
\"col_varchar_10__undef_signed\": \"a\", \"col_varchar_1024__undef_signed\":
\"a\"}'),('14','{\"col_int_undef_signed\": null,
\"col_varchar_10__undef_signed\": \"did\", \"col_varchar_1024__undef_signed\":
\"from\"}'),('15','{\"col_int_und
ef_signed\": 8, \"col_varchar_10__undef_signed\": \"n\",
\"col_varchar_1024__undef_signed\":
\"come\"}'),('16','{\"col_int_undef_signed\": 8,
\"col_varchar_10__undef_signed\": \"was\", \"col_varchar_1024__undef_signed\":
\"n\"}'),('17','{\"col_int_undef_signed\": null,
\"col_varchar_10__undef_signed\": \"v\", \"col_varchar_1024__undef_signed\":
\"on\"}'),('18','{\"col_int_undef_signed\": 6,
\"col_varchar_10__undef_signed\": \"your\", \"col_varchar_1024__undef_signed\":
\"l\"}'),('19','{\"col_int_undef_signed\": null,
\"col_varchar_10__undef_signed\": \"t\", \"col_varchar_1024__undef_signed\":
\"all\"}'),('20','{\"col_int_undef_signed\": null,
\"col_varchar_10__undef_signed\": \"f\", \"col_varchar_1024__undef_signed\":
\"that\"}'),('21','{\"col_int_undef_signed\": null,
\"col_varchar_10__undef_signed\": \"s\", \"col_varchar_1024__undef_signed\":
\"c\"}'),('22','{\"col_int_undef_signed\": null,
\"col_varchar_10__undef_signed\": \"they\", \"col_varchar_1024__undef_signed\":
\"p\"}'),('
23','{\"col_int_undef_signed\": null, \"col_varchar_10__undef_signed\": \"h\",
\"col_varchar_1024__undef_signed\": \"just\"}');
+CREATE TABLE IF NOT EXISTS
table_24_undef_partitions2_keys3_properties4_distributed_by53 ( pk int, var
VARIANT NULL ) engine=olap DUPLICATE KEY(pk) distributed by hash(pk) buckets 10
properties("replication_num" = "1");
+INSERT INTO
table_24_undef_partitions2_keys3_properties4_distributed_by53(pk,var) VALUES
('0','{\"col_int_undef_signed\": null, \"col_varchar_10__undef_signed\": \"v\",
\"col_varchar_1024__undef_signed\": \"l\"}'),('1','{\"col_int_undef_signed\":
1, \"col_varchar_10__undef_signed\": \"up\",
\"col_varchar_1024__undef_signed\":
\"there\"}'),('2','{\"col_int_undef_signed\": null,
\"col_varchar_10__undef_signed\": \"on\", \"col_varchar_1024__undef_signed\":
\"o\"}'),('3','{\"col_int_undef_signed\": 6, \"col_varchar_10__undef_signed\":
\"x\", \"col_varchar_1024__undef_signed\":
\"s\"}'),('4','{\"col_int_undef_signed\": 4, \"col_varchar_10__undef_signed\":
\"e\", \"col_varchar_1024__undef_signed\":
\"c\"}'),('5','{\"col_int_undef_signed\": null,
\"col_varchar_10__undef_signed\": \"c\", \"col_varchar_1024__undef_signed\":
\"in\"}'),('6','{\"col_int_undef_signed\": 4, \"col_varchar_10__undef_signed\":
\"p\", \"col_varchar_1024__undef_signed\":
\"time\"}'),('7','{\"col_int_undef_signed\": nu
ll, \"col_varchar_10__undef_signed\": \"t\",
\"col_varchar_1024__undef_signed\": \"h\"}'),('8','{\"col_int_undef_signed\":
null, \"col_varchar_10__undef_signed\": \"p\",
\"col_varchar_1024__undef_signed\": \"k\"}'),('9','{\"col_int_undef_signed\":
3, \"col_varchar_10__undef_signed\": \"i\", \"col_varchar_1024__undef_signed\":
\"he\"}'),('10','{\"col_int_undef_signed\": 4,
\"col_varchar_10__undef_signed\": \"i\", \"col_varchar_1024__undef_signed\":
\"i\"}'),('11','{\"col_int_undef_signed\": null,
\"col_varchar_10__undef_signed\": \"come\", \"col_varchar_1024__undef_signed\":
\"she\"}'),('12','{\"col_int_undef_signed\": 4,
\"col_varchar_10__undef_signed\": \"see\", \"col_varchar_1024__undef_signed\":
\"b\"}'),('13','{\"col_int_undef_signed\": null,
\"col_varchar_10__undef_signed\": \"now\", \"col_varchar_1024__undef_signed\":
\"d\"}'),('14','{\"col_int_undef_signed\": 9, \"col_varchar_10__undef_signed\":
\"z\", \"col_varchar_1024__undef_signed\":
\"p\"}'),('15','{\"col_int_undef_signe
d\": 0, \"col_varchar_10__undef_signed\": \"as\",
\"col_varchar_1024__undef_signed\":
\"why\"}'),('16','{\"col_int_undef_signed\": null,
\"col_varchar_10__undef_signed\": \"or\", \"col_varchar_1024__undef_signed\":
\"here\"}'),('17','{\"col_int_undef_signed\": null,
\"col_varchar_10__undef_signed\": \"k\", \"col_varchar_1024__undef_signed\":
\"yes\"}'),('18','{\"col_int_undef_signed\": null,
\"col_varchar_10__undef_signed\": \"look\", \"col_varchar_1024__undef_signed\":
\"why\"}'),('19','{\"col_int_undef_signed\": null,
\"col_varchar_10__undef_signed\": \"he\", \"col_varchar_1024__undef_signed\":
\"from\"}'),('20','{\"col_int_undef_signed\": null,
\"col_varchar_10__undef_signed\": \"had\", \"col_varchar_1024__undef_signed\":
\"well\"}'),('21','{\"col_int_undef_signed\": 8,
\"col_varchar_10__undef_signed\": \"yes\", \"col_varchar_1024__undef_signed\":
\"well\"}'),('22','{\"col_int_undef_signed\": 5,
\"col_varchar_10__undef_signed\": \"c\", \"col_varchar_1024__undef_signed\":
\"see\"}
'),('23','{\"col_int_undef_signed\": null, \"col_varchar_10__undef_signed\":
\"be\", \"col_varchar_1024__undef_signed\": \"v\"}');
+CREATE TABLE IF NOT EXISTS
table_25_undef_partitions2_keys3_properties4_distributed_by52 ( pk int, var
VARIANT NULL ) engine=olap DUPLICATE KEY(pk) distributed by hash(pk) buckets 10
properties("replication_num" = "1");
+INSERT INTO
table_25_undef_partitions2_keys3_properties4_distributed_by52(pk,var) VALUES
('0','{\"col_int_undef_signed\": null, \"col_varchar_10__undef_signed\":
\"she\", \"col_varchar_1024__undef_signed\":
\"his\"}'),('1','{\"col_int_undef_signed\": 7,
\"col_varchar_10__undef_signed\": \"c\", \"col_varchar_1024__undef_signed\":
\"i\"}'),('2','{\"col_int_undef_signed\": null,
\"col_varchar_10__undef_signed\": \"were\", \"col_varchar_1024__undef_signed\":
\"z\"}'),('3','{\"col_int_undef_signed\": null,
\"col_varchar_10__undef_signed\": \"l\", \"col_varchar_1024__undef_signed\":
\"out\"}'),('4','{\"col_int_undef_signed\": null,
\"col_varchar_10__undef_signed\": \"e\", \"col_varchar_1024__undef_signed\":
\"really\"}'),('5','{\"col_int_undef_signed\": null,
\"col_varchar_10__undef_signed\": \"go\", \"col_varchar_1024__undef_signed\":
\"I\'\'m\"}'),('6','{\"col_int_undef_signed\": 6,
\"col_varchar_10__undef_signed\": \"yes\", \"col_varchar_1024__undef_signed\":
\"n\"}'),('7','{\"col_int_
undef_signed\": 9, \"col_varchar_10__undef_signed\": \"one\",
\"col_varchar_1024__undef_signed\": \"y\"}'),('8','{\"col_int_undef_signed\":
9, \"col_varchar_10__undef_signed\": \"do\",
\"col_varchar_1024__undef_signed\": \"for\"}'),('9','{\"col_int_undef_signed\":
1, \"col_varchar_10__undef_signed\": \"t\", \"col_varchar_1024__undef_signed\":
\"how\"}'),('10','{\"col_int_undef_signed\": null,
\"col_varchar_10__undef_signed\": \"r\", \"col_varchar_1024__undef_signed\":
\"okay\"}'),('11','{\"col_int_undef_signed\": null,
\"col_varchar_10__undef_signed\": \"were\", \"col_varchar_1024__undef_signed\":
\"they\"}'),('12','{\"col_int_undef_signed\": 3,
\"col_varchar_10__undef_signed\": \"n\", \"col_varchar_1024__undef_signed\":
\"a\"}'),('13','{\"col_int_undef_signed\": 2, \"col_varchar_10__undef_signed\":
\"n\", \"col_varchar_1024__undef_signed\":
\"e\"}'),('14','{\"col_int_undef_signed\": 6, \"col_varchar_10__undef_signed\":
\"know\", \"col_varchar_1024__undef_signed\": \"are\"}'),('15',
'{\"col_int_undef_signed\": 4, \"col_varchar_10__undef_signed\": \"n\",
\"col_varchar_1024__undef_signed\": \"t\"}'),('16','{\"col_int_undef_signed\":
null, \"col_varchar_10__undef_signed\": \"u\",
\"col_varchar_1024__undef_signed\": \"c\"}'),('17','{\"col_int_undef_signed\":
2, \"col_varchar_10__undef_signed\": \"f\", \"col_varchar_1024__undef_signed\":
\"one\"}'),('18','{\"col_int_undef_signed\": 3,
\"col_varchar_10__undef_signed\": \"this\", \"col_varchar_1024__undef_signed\":
\"be\"}'),('19','{\"col_int_undef_signed\": null,
\"col_varchar_10__undef_signed\": \"if\", \"col_varchar_1024__undef_signed\":
\"will\"}'),('20','{\"col_int_undef_signed\": 2,
\"col_varchar_10__undef_signed\": \"but\", \"col_varchar_1024__undef_signed\":
\"w\"}'),('21','{\"col_int_undef_signed\": 4, \"col_varchar_10__undef_signed\":
\"x\", \"col_varchar_1024__undef_signed\":
\"d\"}'),('22','{\"col_int_undef_signed\": 1, \"col_varchar_10__undef_signed\":
\"that\", \"col_varchar_1024__undef_signed\": \"have\
"}'),('23','{\"col_int_undef_signed\": null, \"col_varchar_10__undef_signed\":
\"not\", \"col_varchar_1024__undef_signed\":
\"o\"}'),('24','{\"col_int_undef_signed\": 3, \"col_varchar_10__undef_signed\":
\"on\", \"col_varchar_1024__undef_signed\": \"oh\"}');
+CREATE TABLE IF NOT EXISTS
table_24_undef_partitions2_keys3_properties4_distributed_by5 (
`col_int_undef_signed` int, `col_varchar_10__undef_signed` varchar(10),
`col_varchar_1024__undef_signed` varchar(1024), `pk` int, var VARIANT NULL )
engine=olap DUPLICATE KEY(`col_int_undef_signed`) distributed by
hash(`col_int_undef_signed`) buckets 10 properties("replication_num" = "1");
+INSERT INTO
table_24_undef_partitions2_keys3_properties4_distributed_by5(pk,var) VALUES
('0','{\"col_int_undef_signed\": 9, \"col_varchar_10__undef_signed\": \"c\",
\"col_varchar_1024__undef_signed\": \"one\"}'),('1','{\"col_int_undef_signed\":
2, \"col_varchar_10__undef_signed\": \"o\", \"col_varchar_1024__undef_signed\":
\"up\"}'),('2','{\"col_int_undef_signed\": null,
\"col_varchar_10__undef_signed\": \"c\", \"col_varchar_1024__undef_signed\":
\"m\"}'),('3','{\"col_int_undef_signed\": 4, \"col_varchar_10__undef_signed\":
\"if\", \"col_varchar_1024__undef_signed\":
\"been\"}'),('4','{\"col_int_undef_signed\": null,
\"col_varchar_10__undef_signed\": \"see\", \"col_varchar_1024__undef_signed\":
\"with\"}'),('5','{\"col_int_undef_signed\": 5,
\"col_varchar_10__undef_signed\": \"v\", \"col_varchar_1024__undef_signed\":
\"h\"}'),('6','{\"col_int_undef_signed\": null,
\"col_varchar_10__undef_signed\": \"u\", \"col_varchar_1024__undef_signed\":
\"m\"}'),('7','{\"col_int_undef_signed\": 6
, \"col_varchar_10__undef_signed\": \"m\", \"col_varchar_1024__undef_signed\":
\"her\"}'),('8','{\"col_int_undef_signed\": 7,
\"col_varchar_10__undef_signed\": \"f\", \"col_varchar_1024__undef_signed\":
\"for\"}'),('9','{\"col_int_undef_signed\": 9,
\"col_varchar_10__undef_signed\": \"then\", \"col_varchar_1024__undef_signed\":
\"if\"}'),('10','{\"col_int_undef_signed\": null,
\"col_varchar_10__undef_signed\": \"at\", \"col_varchar_1024__undef_signed\":
\"of\"}'),('11','{\"col_int_undef_signed\": 1,
\"col_varchar_10__undef_signed\": \"i\", \"col_varchar_1024__undef_signed\":
\"you\'re\"}'),('12','{\"col_int_undef_signed\": 7,
\"col_varchar_10__undef_signed\": \"get\", \"col_varchar_1024__undef_signed\":
\"u\"}'),('13','{\"col_int_undef_signed\": 0, \"col_varchar_10__undef_signed\":
\"z\", \"col_varchar_1024__undef_signed\":
\"there\"}'),('14','{\"col_int_undef_signed\": null,
\"col_varchar_10__undef_signed\": \"b\", \"col_varchar_1024__undef_signed\":
\"but\"}'),('15','{\"col_int_un
def_signed\": 3, \"col_varchar_10__undef_signed\": \"p\",
\"col_varchar_1024__undef_signed\": \"we\"}'),('16','{\"col_int_undef_signed\":
null, \"col_varchar_10__undef_signed\": \"p\",
\"col_varchar_1024__undef_signed\":
\"his\"}'),('17','{\"col_int_undef_signed\": 5,
\"col_varchar_10__undef_signed\": \"a\", \"col_varchar_1024__undef_signed\":
\"go\"}'),('18','{\"col_int_undef_signed\": null,
\"col_varchar_10__undef_signed\": \"z\", \"col_varchar_1024__undef_signed\":
\"going\"}'),('19','{\"col_int_undef_signed\": null,
\"col_varchar_10__undef_signed\": \"see\", \"col_varchar_1024__undef_signed\":
\"v\"}'),('20','{\"col_int_undef_signed\": 7, \"col_varchar_10__undef_signed\":
\"a\", \"col_varchar_1024__undef_signed\":
\"oh\"}'),('21','{\"col_int_undef_signed\": null,
\"col_varchar_10__undef_signed\": \"right\",
\"col_varchar_1024__undef_signed\":
\"mean\"}'),('22','{\"col_int_undef_signed\": null,
\"col_varchar_10__undef_signed\": \"t\", \"col_varchar_1024__undef_signed\":
\"o\"}'),
('23','{\"col_int_undef_signed\": 8, \"col_varchar_10__undef_signed\": \"l\",
\"col_varchar_1024__undef_signed\": \"l\"}');
+CREATE TABLE IF NOT EXISTS
table_24_undef_partitions2_keys3_properties4_distributed_by52 ( `pk` int,
`col_int_undef_signed` int, `col_varchar_10__undef_signed` varchar(10),
`col_varchar_1024__undef_signed` varchar(1024), var VARIANT NULL ) engine=olap
DUPLICATE KEY(`pk`) distributed by hash(`pk`) buckets 10
properties("replication_num" = "1");
+INSERT INTO
table_24_undef_partitions2_keys3_properties4_distributed_by52(pk,var) VALUES
('0','{\"col_int_undef_signed\": 7, \"col_varchar_10__undef_signed\": \"say\",
\"col_varchar_1024__undef_signed\": \"k\"}'),('1','{\"col_int_undef_signed\":
null, \"col_varchar_10__undef_signed\": \"v\",
\"col_varchar_1024__undef_signed\": \"or\"}'),('2','{\"col_int_undef_signed\":
8, \"col_varchar_10__undef_signed\": \"v\", \"col_varchar_1024__undef_signed\":
\"m\"}'),('3','{\"col_int_undef_signed\": 7, \"col_varchar_10__undef_signed\":
\"like\", \"col_varchar_1024__undef_signed\":
\"with\"}'),('4','{\"col_int_undef_signed\": null,
\"col_varchar_10__undef_signed\": \"v\", \"col_varchar_1024__undef_signed\":
\"u\"}'),('5','{\"col_int_undef_signed\": 0, \"col_varchar_10__undef_signed\":
\"are\", \"col_varchar_1024__undef_signed\":
\"look\"}'),('6','{\"col_int_undef_signed\": null,
\"col_varchar_10__undef_signed\": \"a\", \"col_varchar_1024__undef_signed\":
\"back\"}'),('7','{\"col_int_undef_signe
d\": 2, \"col_varchar_10__undef_signed\": \"from\",
\"col_varchar_1024__undef_signed\": \"c\"}'),('8','{\"col_int_undef_signed\":
null, \"col_varchar_10__undef_signed\": \"m\",
\"col_varchar_1024__undef_signed\": \"b\"}'),('9','{\"col_int_undef_signed\":
null, \"col_varchar_10__undef_signed\": \"want\",
\"col_varchar_1024__undef_signed\":
\"know\"}'),('10','{\"col_int_undef_signed\": 9,
\"col_varchar_10__undef_signed\": \"no\", \"col_varchar_1024__undef_signed\":
\"about\"}'),('11','{\"col_int_undef_signed\": 8,
\"col_varchar_10__undef_signed\": \"w\", \"col_varchar_1024__undef_signed\":
\"s\"}'),('12','{\"col_int_undef_signed\": 0, \"col_varchar_10__undef_signed\":
\"c\", \"col_varchar_1024__undef_signed\":
\"got\"}'),('13','{\"col_int_undef_signed\": null,
\"col_varchar_10__undef_signed\": \"t\", \"col_varchar_1024__undef_signed\":
\"up\"}'),('14','{\"col_int_undef_signed\": 0,
\"col_varchar_10__undef_signed\": \"with\", \"col_varchar_1024__undef_signed\":
\"and\"}'),('15','{\"col
_int_undef_signed\": null, \"col_varchar_10__undef_signed\": \"h\",
\"col_varchar_1024__undef_signed\": \"z\"}'),('16','{\"col_int_undef_signed\":
null, \"col_varchar_10__undef_signed\": \"f\",
\"col_varchar_1024__undef_signed\": \"be\"}'),('17','{\"col_int_undef_signed\":
null, \"col_varchar_10__undef_signed\": \"g\",
\"col_varchar_1024__undef_signed\": \"l\"}'),('18','{\"col_int_undef_signed\":
3, \"col_varchar_10__undef_signed\": \"s\", \"col_varchar_1024__undef_signed\":
\"on\"}'),('19','{\"col_int_undef_signed\": null,
\"col_varchar_10__undef_signed\": \"so\", \"col_varchar_1024__undef_signed\":
\"got\"}'),('20','{\"col_int_undef_signed\": null,
\"col_varchar_10__undef_signed\": \"as\", \"col_varchar_1024__undef_signed\":
\"or\"}'),('21','{\"col_int_undef_signed\": 1,
\"col_varchar_10__undef_signed\": \"a\", \"col_varchar_1024__undef_signed\":
\"w\"}'),('22','{\"col_int_undef_signed\": 6, \"col_varchar_10__undef_signed\":
\"x\", \"col_varchar_1024__undef_signed\": \"h\"}'),('23
','{\"col_int_undef_signed\": 7, \"col_varchar_10__undef_signed\": \"e\",
\"col_varchar_1024__undef_signed\": \"when\"}');
+CREATE TABLE IF NOT EXISTS
table_24_undef_partitions2_keys3_properties4_distributed_by53 ( `pk` int,
`col_varchar_10__undef_signed` varchar(10), `col_int_undef_signed` int,
`col_varchar_1024__undef_signed` varchar(1024), var VARIANT NULL ) engine=olap
DUPLICATE KEY(`pk`) distributed by hash(`pk`) buckets 10
properties("replication_num" = "1");
+CREATE TABLE IF NOT EXISTS
table_24_undef_partitions2_keys3_properties4_distributed_by5 (
`col_int_undef_signed` int, `col_varchar_10__undef_signed` varchar(10),
`col_varchar_1024__undef_signed` varchar(1024), `pk` int, var VARIANT NULL )
engine=olap DUPLICATE KEY(`col_int_undef_signed`) distributed by
hash(`col_int_undef_signed`) buckets 10 properties("replication_num" = "1");
+INSERT INTO
table_24_undef_partitions2_keys3_properties4_distributed_by5(pk,var) VALUES
('0','{\"col_int_undef_signed\": null, \"col_varchar_10__undef_signed\": \"g\",
\"col_varchar_1024__undef_signed\": \"in\"}'),('1','{\"col_int_undef_signed\":
2, \"col_varchar_10__undef_signed\": \"not\",
\"col_varchar_1024__undef_signed\": \"a\"}'),('2','{\"col_int_undef_signed\":
0, \"col_varchar_10__undef_signed\": \"q\", \"col_varchar_1024__undef_signed\":
\"z\"}'),('3','{\"col_int_undef_signed\": 7, \"col_varchar_10__undef_signed\":
\"you\", \"col_varchar_1024__undef_signed\":
\"what\"}'),('4','{\"col_int_undef_signed\": 4,
\"col_varchar_10__undef_signed\": \"ok\", \"col_varchar_1024__undef_signed\":
\"go\"}'),('5','{\"col_int_undef_signed\": 3, \"col_varchar_10__undef_signed\":
\"p\", \"col_varchar_1024__undef_signed\":
\"a\"}'),('6','{\"col_int_undef_signed\": 5, \"col_varchar_10__undef_signed\":
\"n\", \"col_varchar_1024__undef_signed\":
\"x\"}'),('7','{\"col_int_undef_signed\": 8, \"col_
varchar_10__undef_signed\": \"g\", \"col_varchar_1024__undef_signed\":
\"p\"}'),('8','{\"col_int_undef_signed\": null,
\"col_varchar_10__undef_signed\": \"i\", \"col_varchar_1024__undef_signed\":
\"z\"}'),('9','{\"col_int_undef_signed\": 8, \"col_varchar_10__undef_signed\":
\"o\", \"col_varchar_1024__undef_signed\":
\"her\"}'),('10','{\"col_int_undef_signed\": null,
\"col_varchar_10__undef_signed\": \"he\'s\",
\"col_varchar_1024__undef_signed\":
\"that\"}'),('11','{\"col_int_undef_signed\": null,
\"col_varchar_10__undef_signed\": \"e\", \"col_varchar_1024__undef_signed\":
\"d\"}'),('12','{\"col_int_undef_signed\": 3, \"col_varchar_10__undef_signed\":
\"really\", \"col_varchar_1024__undef_signed\":
\"i\"}'),('13','{\"col_int_undef_signed\": null,
\"col_varchar_10__undef_signed\": \"her\", \"col_varchar_1024__undef_signed\":
\"w\"}'),('14','{\"col_int_undef_signed\": 5, \"col_varchar_10__undef_signed\":
\"c\", \"col_varchar_1024__undef_signed\":
\"one\"}'),('15','{\"col_int_undef_sign
ed\": null, \"col_varchar_10__undef_signed\": \"y\",
\"col_varchar_1024__undef_signed\":
\"something\"}'),('16','{\"col_int_undef_signed\": null,
\"col_varchar_10__undef_signed\": \"if\", \"col_varchar_1024__undef_signed\":
\"b\"}'),('17','{\"col_int_undef_signed\": null,
\"col_varchar_10__undef_signed\": \"on\", \"col_varchar_1024__undef_signed\":
\"because\"}'),('18','{\"col_int_undef_signed\": 5,
\"col_varchar_10__undef_signed\": \"time\", \"col_varchar_1024__undef_signed\":
\"d\"}'),('19','{\"col_int_undef_signed\": null,
\"col_varchar_10__undef_signed\": \"okay\", \"col_varchar_1024__undef_signed\":
\"of\"}'),('20','{\"col_int_undef_signed\": null,
\"col_varchar_10__undef_signed\": \"d\", \"col_varchar_1024__undef_signed\":
\"j\"}'),('21','{\"col_int_undef_signed\": 6, \"col_varchar_10__undef_signed\":
\"she\", \"col_varchar_1024__undef_signed\":
\"think\"}'),('22','{\"col_int_undef_signed\": 0,
\"col_varchar_10__undef_signed\": \"q\", \"col_varchar_1024__undef_signed\":
\"were
\"}'),('23','{\"col_int_undef_signed\": null,
\"col_varchar_10__undef_signed\": \"x\", \"col_varchar_1024__undef_signed\":
\"we\"}');
+INSERT INTO
table_24_undef_partitions2_keys3_properties4_distributed_by53(pk,var) VALUES
('0','{\"col_int_undef_signed\": null, \"col_varchar_10__undef_signed\": \"k\",
\"col_varchar_1024__undef_signed\": \"q\"}'),('1','{\"col_int_undef_signed\":
1, \"col_varchar_10__undef_signed\": \"j\", \"col_varchar_1024__undef_signed\":
\"this\"}'),('2','{\"col_int_undef_signed\": 1,
\"col_varchar_10__undef_signed\": \"c\", \"col_varchar_1024__undef_signed\":
\"from\"}'),('3','{\"col_int_undef_signed\": 3,
\"col_varchar_10__undef_signed\": \"s\", \"col_varchar_1024__undef_signed\":
\"I\'ll\"}'),('4','{\"col_int_undef_signed\": 7,
\"col_varchar_10__undef_signed\": \"his\", \"col_varchar_1024__undef_signed\":
\"q\"}'),('5','{\"col_int_undef_signed\": null,
\"col_varchar_10__undef_signed\": \"all\", \"col_varchar_1024__undef_signed\":
\"no\"}'),('6','{\"col_int_undef_signed\": null,
\"col_varchar_10__undef_signed\": \"it\'s\",
\"col_varchar_1024__undef_signed\": \"k\"}'),('7','{\"col_int_undef_sig
ned\": 4, \"col_varchar_10__undef_signed\": \"o\",
\"col_varchar_1024__undef_signed\":
\"I\'ll\"}'),('8','{\"col_int_undef_signed\": null,
\"col_varchar_10__undef_signed\": \"q\", \"col_varchar_1024__undef_signed\":
\"a\"}'),('9','{\"col_int_undef_signed\": null,
\"col_varchar_10__undef_signed\": \"q\", \"col_varchar_1024__undef_signed\":
\"y\"}'),('10','{\"col_int_undef_signed\": null,
\"col_varchar_10__undef_signed\": \"p\", \"col_varchar_1024__undef_signed\":
\"can\"}'),('11','{\"col_int_undef_signed\": 0,
\"col_varchar_10__undef_signed\": \"d\", \"col_varchar_1024__undef_signed\":
\"h\"}'),('12','{\"col_int_undef_signed\": 2, \"col_varchar_10__undef_signed\":
\"about\", \"col_varchar_1024__undef_signed\":
\"some\"}'),('13','{\"col_int_undef_signed\": null,
\"col_varchar_10__undef_signed\": \"in\", \"col_varchar_1024__undef_signed\":
\"v\"}'),('14','{\"col_int_undef_signed\": 1, \"col_varchar_10__undef_signed\":
\"u\", \"col_varchar_1024__undef_signed\": \"y\"}'),('15','{\"col_in
t_undef_signed\": 6, \"col_varchar_10__undef_signed\": \"c\",
\"col_varchar_1024__undef_signed\": \"i\"}'),('16','{\"col_int_undef_signed\":
null, \"col_varchar_10__undef_signed\": \"q\",
\"col_varchar_1024__undef_signed\": \"i\"}'),('17','{\"col_int_undef_signed\":
null, \"col_varchar_10__undef_signed\": \"some\",
\"col_varchar_1024__undef_signed\": \"x\"}'),('18','{\"col_int_undef_signed\":
6, \"col_varchar_10__undef_signed\": \"h\", \"col_varchar_1024__undef_signed\":
\"in\"}'),('19','{\"col_int_undef_signed\": null,
\"col_varchar_10__undef_signed\": \"and\", \"col_varchar_1024__undef_signed\":
\"yeah\"}'),('20','{\"col_int_undef_signed\": 1,
\"col_varchar_10__undef_signed\": \"l\", \"col_varchar_1024__undef_signed\":
\"my\"}'),('21','{\"col_int_undef_signed\": null,
\"col_varchar_10__undef_signed\": \"q\", \"col_varchar_1024__undef_signed\":
\"q\"}'),('22','{\"col_int_undef_signed\": 5, \"col_varchar_10__undef_signed\":
\"v\", \"col_varchar_1024__undef_signed\": \"be\"}'),('23',
'{\"col_int_undef_signed\": null, \"col_varchar_10__undef_signed\": \"go\",
\"col_varchar_1024__undef_signed\": \"okay\"}');
+CREATE TABLE IF NOT EXISTS
table_24_undef_partitions2_keys3_properties4_distributed_by52 ( `pk` int,
`col_int_undef_signed` int, `col_varchar_10__undef_signed` varchar(10),
`col_varchar_1024__undef_signed` varchar(1024), var VARIANT NULL ) engine=olap
DUPLICATE KEY(`pk`) distributed by hash(`pk`) buckets 10
properties("replication_num" = "1");
+INSERT INTO
table_24_undef_partitions2_keys3_properties4_distributed_by52(pk,var) VALUES
('0','{\"col_int_undef_signed\": null, \"col_varchar_10__undef_signed\": \"c\",
\"col_varchar_1024__undef_signed\": \"o\"}'),('1','{\"col_int_undef_signed\":
5, \"col_varchar_10__undef_signed\": \"you\",
\"col_varchar_1024__undef_signed\":
\"when\"}'),('2','{\"col_int_undef_signed\": 1,
\"col_varchar_10__undef_signed\": \"q\", \"col_varchar_1024__undef_signed\":
\"r\"}'),('3','{\"col_int_undef_signed\": null,
\"col_varchar_10__undef_signed\": \"can\'t\",
\"col_varchar_1024__undef_signed\": \"so\"}'),('4','{\"col_int_undef_signed\":
9, \"col_varchar_10__undef_signed\": \"not\",
\"col_varchar_1024__undef_signed\": \"at\"}'),('5','{\"col_int_undef_signed\":
null, \"col_varchar_10__undef_signed\": \"say\",
\"col_varchar_1024__undef_signed\": \"y\"}'),('6','{\"col_int_undef_signed\":
null, \"col_varchar_10__undef_signed\": \"tell\",
\"col_varchar_1024__undef_signed\": \"me\"}'),('7','{\"col_int_undef
_signed\": 2, \"col_varchar_10__undef_signed\": \"think\",
\"col_varchar_1024__undef_signed\": \"r\"}'),('8','{\"col_int_undef_signed\":
4, \"col_varchar_10__undef_signed\": \"you\'re\",
\"col_varchar_1024__undef_signed\": \"w\"}'),('9','{\"col_int_undef_signed\":
null, \"col_varchar_10__undef_signed\": \"s\",
\"col_varchar_1024__undef_signed\":
\"was\"}'),('10','{\"col_int_undef_signed\": null,
\"col_varchar_10__undef_signed\": \"no\", \"col_varchar_1024__undef_signed\":
\"yes\"}'),('11','{\"col_int_undef_signed\": 9,
\"col_varchar_10__undef_signed\": \"d\", \"col_varchar_1024__undef_signed\":
\"tell\"}'),('12','{\"col_int_undef_signed\": 3,
\"col_varchar_10__undef_signed\": \"y\", \"col_varchar_1024__undef_signed\":
\"o\"}'),('13','{\"col_int_undef_signed\": 2, \"col_varchar_10__undef_signed\":
\"u\", \"col_varchar_1024__undef_signed\":
\"good\"}'),('14','{\"col_int_undef_signed\": null,
\"col_varchar_10__undef_signed\": \"is\", \"col_varchar_1024__undef_signed\":
\"b\"}'),('15','
{\"col_int_undef_signed\": 3, \"col_varchar_10__undef_signed\": \"w\",
\"col_varchar_1024__undef_signed\":
\"they\"}'),('16','{\"col_int_undef_signed\": 9,
\"col_varchar_10__undef_signed\": \"good\", \"col_varchar_1024__undef_signed\":
\"her\"}'),('17','{\"col_int_undef_signed\": 1,
\"col_varchar_10__undef_signed\": \"time\", \"col_varchar_1024__undef_signed\":
\"a\"}'),('18','{\"col_int_undef_signed\": 9, \"col_varchar_10__undef_signed\":
\"p\", \"col_varchar_1024__undef_signed\":
\"e\"}'),('19','{\"col_int_undef_signed\": 4, \"col_varchar_10__undef_signed\":
\"who\", \"col_varchar_1024__undef_signed\":
\"d\"}'),('20','{\"col_int_undef_signed\": null,
\"col_varchar_10__undef_signed\": \"not\", \"col_varchar_1024__undef_signed\":
\"would\"}'),('21','{\"col_int_undef_signed\": null,
\"col_varchar_10__undef_signed\": \"in\", \"col_varchar_1024__undef_signed\":
\"f\"}'),('22','{\"col_int_undef_signed\": null,
\"col_varchar_10__undef_signed\": \"h\", \"col_varchar_1024__undef_signed\":
\"good\"}'),('23','{\"col_int_undef_signed\": 2,
\"col_varchar_10__undef_signed\": \"you\'re\",
\"col_varchar_1024__undef_signed\": \"think\"}');
+CREATE TABLE IF NOT EXISTS
table_24_undef_partitions2_keys3_properties4_distributed_by53 ( `pk` int,
`col_varchar_10__undef_signed` varchar(10), `col_int_undef_signed` int,
`col_varchar_1024__undef_signed` varchar(1024), var VARIANT NULL ) engine=olap
DUPLICATE KEY(`pk`) distributed by hash(`pk`) buckets 10
properties("replication_num" = "1");
+CREATE TABLE IF NOT EXISTS
table_25_undef_partitions2_keys3_properties4_distributed_by52 ( `pk` int,
`col_int_undef_signed` int, `col_varchar_10__undef_signed` varchar(10),
`col_varchar_1024__undef_signed` varchar(1024), var VARIANT NULL ) engine=olap
DUPLICATE KEY(`pk`) distributed by hash(`pk`) buckets 10
properties("replication_num" = "1");
+INSERT INTO
table_24_undef_partitions2_keys3_properties4_distributed_by53(pk,var) VALUES
('0','{\"col_int_undef_signed\": null, \"col_varchar_10__undef_signed\":
\"he\", \"col_varchar_1024__undef_signed\":
\"good\"}'),('1','{\"col_int_undef_signed\": null,
\"col_varchar_10__undef_signed\": \"was\", \"col_varchar_1024__undef_signed\":
\"how\"}'),('2','{\"col_int_undef_signed\": null,
\"col_varchar_10__undef_signed\": \"t\", \"col_varchar_1024__undef_signed\":
\"p\"}'),('3','{\"col_int_undef_signed\": 9, \"col_varchar_10__undef_signed\":
\"i\", \"col_varchar_1024__undef_signed\":
\"c\"}'),('4','{\"col_int_undef_signed\": null,
\"col_varchar_10__undef_signed\": \"go\", \"col_varchar_1024__undef_signed\":
\"he\"}'),('5','{\"col_int_undef_signed\": 3, \"col_varchar_10__undef_signed\":
\"o\", \"col_varchar_1024__undef_signed\":
\"at\"}'),('6','{\"col_int_undef_signed\": null,
\"col_varchar_10__undef_signed\": \"v\", \"col_varchar_1024__undef_signed\":
\"going\"}'),('7','{\"col_int_undef_s
igned\": 7, \"col_varchar_10__undef_signed\": \"well\",
\"col_varchar_1024__undef_signed\": \"b\"}'),('8','{\"col_int_undef_signed\":
null, \"col_varchar_10__undef_signed\": \"at\",
\"col_varchar_1024__undef_signed\": \"r\"}'),('9','{\"col_int_undef_signed\":
null, \"col_varchar_10__undef_signed\": \"why\",
\"col_varchar_1024__undef_signed\":
\"she\"}'),('10','{\"col_int_undef_signed\": 5,
\"col_varchar_10__undef_signed\": \"u\", \"col_varchar_1024__undef_signed\":
\"c\"}'),('11','{\"col_int_undef_signed\": 2, \"col_varchar_10__undef_signed\":
\"it\'s\", \"col_varchar_1024__undef_signed\":
\"had\"}'),('12','{\"col_int_undef_signed\": null,
\"col_varchar_10__undef_signed\": \"his\", \"col_varchar_1024__undef_signed\":
\"m\"}'),('13','{\"col_int_undef_signed\": null,
\"col_varchar_10__undef_signed\": \"m\", \"col_varchar_1024__undef_signed\":
\"x\"}'),('14','{\"col_int_undef_signed\": null,
\"col_varchar_10__undef_signed\": \"k\", \"col_varchar_1024__undef_signed\":
\"who\"}'),('15','
{\"col_int_undef_signed\": null, \"col_varchar_10__undef_signed\": \"been\",
\"col_varchar_1024__undef_signed\":
\"will\"}'),('16','{\"col_int_undef_signed\": 8,
\"col_varchar_10__undef_signed\": \"what\", \"col_varchar_1024__undef_signed\":
\"m\"}'),('17','{\"col_int_undef_signed\": null,
\"col_varchar_10__undef_signed\": \"him\", \"col_varchar_1024__undef_signed\":
\"her\"}'),('18','{\"col_int_undef_signed\": 4,
\"col_varchar_10__undef_signed\": \"or\", \"col_varchar_1024__undef_signed\":
\"out\"}'),('19','{\"col_int_undef_signed\": 3,
\"col_varchar_10__undef_signed\": \"who\", \"col_varchar_1024__undef_signed\":
\"r\"}'),('20','{\"col_int_undef_signed\": 1, \"col_varchar_10__undef_signed\":
\"as\", \"col_varchar_1024__undef_signed\":
\"the\"}'),('21','{\"col_int_undef_signed\": null,
\"col_varchar_10__undef_signed\": \"are\", \"col_varchar_1024__undef_signed\":
\"didn\'t\"}'),('22','{\"col_int_undef_signed\": null,
\"col_varchar_10__undef_signed\": \"just\", \"col_varchar_1024__u
ndef_signed\": \"this\"}'),('23','{\"col_int_undef_signed\": 0,
\"col_varchar_10__undef_signed\": \"m\", \"col_varchar_1024__undef_signed\":
\"I\'ll\"}');
+INSERT INTO
table_25_undef_partitions2_keys3_properties4_distributed_by52(pk,var) VALUES
('0','{\"col_int_undef_signed\": null, \"col_varchar_10__undef_signed\":
\"look\", \"col_varchar_1024__undef_signed\":
\"x\"}'),('1','{\"col_int_undef_signed\": 0, \"col_varchar_10__undef_signed\":
\"k\", \"col_varchar_1024__undef_signed\":
\"r\"}'),('2','{\"col_int_undef_signed\": null,
\"col_varchar_10__undef_signed\": \"e\", \"col_varchar_1024__undef_signed\":
\"b\"}'),('3','{\"col_int_undef_signed\": 8, \"col_varchar_10__undef_signed\":
\"in\", \"col_varchar_1024__undef_signed\":
\"v\"}'),('4','{\"col_int_undef_signed\": 0, \"col_varchar_10__undef_signed\":
\"u\", \"col_varchar_1024__undef_signed\":
\"s\"}'),('5','{\"col_int_undef_signed\": 0, \"col_varchar_10__undef_signed\":
\"z\", \"col_varchar_1024__undef_signed\":
\"q\"}'),('6','{\"col_int_undef_signed\": null,
\"col_varchar_10__undef_signed\": \"y\", \"col_varchar_1024__undef_signed\":
\"did\"}'),('7','{\"col_int_undef_signed\": null,
\"col_varchar_10__undef_signed\": \"h\", \"col_varchar_1024__undef_signed\":
\"one\"}'),('8','{\"col_int_undef_signed\": 7,
\"col_varchar_10__undef_signed\": \"been\", \"col_varchar_1024__undef_signed\":
\"m\"}'),('9','{\"col_int_undef_signed\": 7, \"col_varchar_10__undef_signed\":
\"c\", \"col_varchar_1024__undef_signed\":
\"e\"}'),('10','{\"col_int_undef_signed\": 7, \"col_varchar_10__undef_signed\":
\"could\", \"col_varchar_1024__undef_signed\":
\"then\"}'),('11','{\"col_int_undef_signed\": null,
\"col_varchar_10__undef_signed\": \"oh\", \"col_varchar_1024__undef_signed\":
\"it\"}'),('12','{\"col_int_undef_signed\": 4,
\"col_varchar_10__undef_signed\": \"I\'ll\",
\"col_varchar_1024__undef_signed\":
\"him\"}'),('13','{\"col_int_undef_signed\": null,
\"col_varchar_10__undef_signed\": \"don\'t\",
\"col_varchar_1024__undef_signed\": \"y\"}'),('14','{\"col_int_undef_signed\":
2, \"col_varchar_10__undef_signed\": \"what\",
\"col_varchar_1024__undef_signed\": \"oh\"}'),('15','{\"col_int
_undef_signed\": 6, \"col_varchar_10__undef_signed\": \"out\",
\"col_varchar_1024__undef_signed\": \"oh\"}'),('16','{\"col_int_undef_signed\":
null, \"col_varchar_10__undef_signed\": \"e\",
\"col_varchar_1024__undef_signed\": \"n\"}'),('17','{\"col_int_undef_signed\":
0, \"col_varchar_10__undef_signed\": \"z\", \"col_varchar_1024__undef_signed\":
\"get\"}'),('18','{\"col_int_undef_signed\": 7,
\"col_varchar_10__undef_signed\": \"c\", \"col_varchar_1024__undef_signed\":
\"m\"}'),('19','{\"col_int_undef_signed\": 2, \"col_varchar_10__undef_signed\":
\"they\", \"col_varchar_1024__undef_signed\":
\"going\"}'),('20','{\"col_int_undef_signed\": 3,
\"col_varchar_10__undef_signed\": \"here\", \"col_varchar_1024__undef_signed\":
\"why\"}'),('21','{\"col_int_undef_signed\": 8,
\"col_varchar_10__undef_signed\": \"l\", \"col_varchar_1024__undef_signed\":
\"l\"}'),('22','{\"col_int_undef_signed\": 0, \"col_varchar_10__undef_signed\":
\"n\", \"col_varchar_1024__undef_signed\": \"z\"}'),('23','{\"
col_int_undef_signed\": null, \"col_varchar_10__undef_signed\": \"a\",
\"col_varchar_1024__undef_signed\": \"it\"}'),('24','{\"col_int_undef_signed\":
null, \"col_varchar_10__undef_signed\": \"w\",
\"col_varchar_1024__undef_signed\": \"o\"}');
+CREATE TABLE IF NOT EXISTS
table_25_undef_partitions2_keys3_properties4_distributed_by52 ( `pk` int,
`col_int_undef_signed` int, `col_varchar_10__undef_signed` varchar(10),
`col_varchar_1024__undef_signed` varchar(1024), var VARIANT NULL ) engine=olap
DUPLICATE KEY(`pk`) distributed by hash(`pk`) buckets 10
properties("replication_num" = "1");
+INSERT INTO
table_25_undef_partitions2_keys3_properties4_distributed_by52(pk,var) VALUES
('0','{\"col_int_undef_signed\": null, \"col_varchar_10__undef_signed\":
\"some\", \"col_varchar_1024__undef_signed\":
\"some\"}'),('1','{\"col_int_undef_signed\": null,
\"col_varchar_10__undef_signed\": \"x\", \"col_varchar_1024__undef_signed\":
\"so\"}'),('2','{\"col_int_undef_signed\": null,
\"col_varchar_10__undef_signed\": \"say\", \"col_varchar_1024__undef_signed\":
\"f\"}'),('3','{\"col_int_undef_signed\": null,
\"col_varchar_10__undef_signed\": \"v\", \"col_varchar_1024__undef_signed\":
\"p\"}'),('4','{\"col_int_undef_signed\": 5, \"col_varchar_10__undef_signed\":
\"back\", \"col_varchar_1024__undef_signed\":
\"her\"}'),('5','{\"col_int_undef_signed\": null,
\"col_varchar_10__undef_signed\": \"a\", \"col_varchar_1024__undef_signed\":
\"s\"}'),('6','{\"col_int_undef_signed\": 7, \"col_varchar_10__undef_signed\":
\"you\", \"col_varchar_1024__undef_signed\": \"when\"}'),('7','{\"col_int_und
ef_signed\": 3, \"col_varchar_10__undef_signed\": \"didn\'t\",
\"col_varchar_1024__undef_signed\": \"g\"}'),('8','{\"col_int_undef_signed\":
null, \"col_varchar_10__undef_signed\": \"he\'s\",
\"col_varchar_1024__undef_signed\": \"b\"}'),('9','{\"col_int_undef_signed\":
4, \"col_varchar_10__undef_signed\": \"p\", \"col_varchar_1024__undef_signed\":
\"k\"}'),('10','{\"col_int_undef_signed\": null,
\"col_varchar_10__undef_signed\": \"p\", \"col_varchar_1024__undef_signed\":
\"n\"}'),('11','{\"col_int_undef_signed\": null,
\"col_varchar_10__undef_signed\": \"k\", \"col_varchar_1024__undef_signed\":
\"g\"}'),('12','{\"col_int_undef_signed\": 3, \"col_varchar_10__undef_signed\":
\"would\", \"col_varchar_1024__undef_signed\":
\"x\"}'),('13','{\"col_int_undef_signed\": 3, \"col_varchar_10__undef_signed\":
\"i\", \"col_varchar_1024__undef_signed\":
\"from\"}'),('14','{\"col_int_undef_signed\": null,
\"col_varchar_10__undef_signed\": \"for\", \"col_varchar_1024__undef_signed\":
\"some\"}'),('
15','{\"col_int_undef_signed\": 9, \"col_varchar_10__undef_signed\": \"f\",
\"col_varchar_1024__undef_signed\": \"g\"}'),('16','{\"col_int_undef_signed\":
null, \"col_varchar_10__undef_signed\": \"x\",
\"col_varchar_1024__undef_signed\": \"n\"}'),('17','{\"col_int_undef_signed\":
7, \"col_varchar_10__undef_signed\": \"then\",
\"col_varchar_1024__undef_signed\": \"at\"}'),('18','{\"col_int_undef_signed\":
null, \"col_varchar_10__undef_signed\": \"now\",
\"col_varchar_1024__undef_signed\": \"k\"}'),('19','{\"col_int_undef_signed\":
null, \"col_varchar_10__undef_signed\": \"of\",
\"col_varchar_1024__undef_signed\": \"a\"}'),('20','{\"col_int_undef_signed\":
0, \"col_varchar_10__undef_signed\": \"will\",
\"col_varchar_1024__undef_signed\": \"be\"}'),('21','{\"col_int_undef_signed\":
8, \"col_varchar_10__undef_signed\": \"q\", \"col_varchar_1024__undef_signed\":
\"c\"}'),('22','{\"col_int_undef_signed\": null,
\"col_varchar_10__undef_signed\": \"p\", \"col_varchar_1024__undef_signed\": \
"hey\"}'),('23','{\"col_int_undef_signed\": null,
\"col_varchar_10__undef_signed\": \"d\", \"col_varchar_1024__undef_signed\":
\"j\"}'),('24','{\"col_int_undef_signed\": 5, \"col_varchar_10__undef_signed\":
\"o\", \"col_varchar_1024__undef_signed\": \"j\"}');
+CREATE TABLE IF NOT EXISTS
table_24_undef_partitions2_keys3_properties4_distributed_by5 ( pk int, var
VARIANT NULL ) engine=olap DUPLICATE KEY(pk) distributed by hash(pk) buckets 10
properties("replication_num" = "1");
+INSERT INTO
table_24_undef_partitions2_keys3_properties4_distributed_by5(pk,var) VALUES
('0','{\"col_int_undef_signed\": null, \"col_int_undef_signed_not_null\": 7,
\"col_date_undef_signed\": \"2023-12-12\", \"col_date_undef_signed_not_null\":
\"2023-12-19\", \"col_varchar_10__undef_signed\": \"i\",
\"col_varchar_10__undef_signed_not_null\": \"been\",
\"col_varchar_1024__undef_signed\": \"s\",
\"col_varchar_1024__undef_signed_not_null\":
\"i\"}'),('1','{\"col_int_undef_signed\": 5, \"col_int_undef_signed_not_null\":
3, \"col_date_undef_signed\": \"2023-12-12\",
\"col_date_undef_signed_not_null\": \"2023-12-13\",
\"col_varchar_10__undef_signed\": \"b\",
\"col_varchar_10__undef_signed_not_null\": \"see\",
\"col_varchar_1024__undef_signed\": \"k\",
\"col_varchar_1024__undef_signed_not_null\":
\"didn\'\'t\"}'),('2','{\"col_int_undef_signed\": null,
\"col_int_undef_signed_not_null\": 2, \"col_date_undef_signed\":
\"2023-12-13\", \"col_date_undef_signed_not_null\": \"2023-12-16\", \"col_v
archar_10__undef_signed\": \"could\",
\"col_varchar_10__undef_signed_not_null\": \"did\",
\"col_varchar_1024__undef_signed\": \"all\",
\"col_varchar_1024__undef_signed_not_null\":
\"j\"}'),('3','{\"col_int_undef_signed\": 2, \"col_int_undef_signed_not_null\":
7, \"col_date_undef_signed\": \"2023-12-20\",
\"col_date_undef_signed_not_null\": \"2023-12-20\",
\"col_varchar_10__undef_signed\": \"look\",
\"col_varchar_10__undef_signed_not_null\": \"like\",
\"col_varchar_1024__undef_signed\": \"f\",
\"col_varchar_1024__undef_signed_not_null\":
\"him\"}'),('4','{\"col_int_undef_signed\": 0,
\"col_int_undef_signed_not_null\": 2, \"col_date_undef_signed\":
\"2023-12-18\", \"col_date_undef_signed_not_null\": \"2023-12-09\",
\"col_varchar_10__undef_signed\": \"k\",
\"col_varchar_10__undef_signed_not_null\": \"c\",
\"col_varchar_1024__undef_signed\": \"b\",
\"col_varchar_1024__undef_signed_not_null\":
\"u\"}'),('5','{\"col_int_undef_signed\": 6, \"col_int_undef_signed_not_null\":
1, \"col_date_u
ndef_signed\": \"2023-12-14\", \"col_date_undef_signed_not_null\":
\"2023-12-09\", \"col_varchar_10__undef_signed\": \"hey\",
\"col_varchar_10__undef_signed_not_null\": \"z\",
\"col_varchar_1024__undef_signed\": \"r\",
\"col_varchar_1024__undef_signed_not_null\":
\"like\"}'),('6','{\"col_int_undef_signed\": null,
\"col_int_undef_signed_not_null\": 0, \"col_date_undef_signed\":
\"2023-12-11\", \"col_date_undef_signed_not_null\": \"2023-12-12\",
\"col_varchar_10__undef_signed\": \"i\",
\"col_varchar_10__undef_signed_not_null\": \"you\",
\"col_varchar_1024__undef_signed\": \"d\",
\"col_varchar_1024__undef_signed_not_null\":
\"will\"}'),('7','{\"col_int_undef_signed\": 3,
\"col_int_undef_signed_not_null\": 5, \"col_date_undef_signed\":
\"2023-12-14\", \"col_date_undef_signed_not_null\": \"2023-12-12\",
\"col_varchar_10__undef_signed\": \"be\",
\"col_varchar_10__undef_signed_not_null\": \"p\",
\"col_varchar_1024__undef_signed\": \"think\",
\"col_varchar_1024__undef_signed_not_null\": \"d
id\"}'),('8','{\"col_int_undef_signed\": 1, \"col_int_undef_signed_not_null\":
1, \"col_date_undef_signed\": \"2023-12-11\",
\"col_date_undef_signed_not_null\": \"2023-12-13\",
\"col_varchar_10__undef_signed\": \"d\",
\"col_varchar_10__undef_signed_not_null\": \"really\",
\"col_varchar_1024__undef_signed\": \"l\",
\"col_varchar_1024__undef_signed_not_null\":
\"you\'\'re\"}'),('9','{\"col_int_undef_signed\": null,
\"col_int_undef_signed_not_null\": 3, \"col_date_undef_signed\":
\"2023-12-18\", \"col_date_undef_signed_not_null\": \"2023-12-13\",
\"col_varchar_10__undef_signed\": \"x\",
\"col_varchar_10__undef_signed_not_null\": \"k\",
\"col_varchar_1024__undef_signed\": \"m\",
\"col_varchar_1024__undef_signed_not_null\":
\"o\"}'),('10','{\"col_int_undef_signed\": null,
\"col_int_undef_signed_not_null\": 7, \"col_date_undef_signed\":
\"2023-12-14\", \"col_date_undef_signed_not_null\": \"2023-12-14\",
\"col_varchar_10__undef_signed\": \"p\",
\"col_varchar_10__undef_signed_not_null\": \"
h\", \"col_varchar_1024__undef_signed\": \"q\",
\"col_varchar_1024__undef_signed_not_null\":
\"going\"}'),('11','{\"col_int_undef_signed\": null,
\"col_int_undef_signed_not_null\": 9, \"col_date_undef_signed\":
\"2023-12-20\", \"col_date_undef_signed_not_null\": \"2023-12-11\",
\"col_varchar_10__undef_signed\": \"b\",
\"col_varchar_10__undef_signed_not_null\": \"r\",
\"col_varchar_1024__undef_signed\": \"yeah\",
\"col_varchar_1024__undef_signed_not_null\":
\"about\"}'),('12','{\"col_int_undef_signed\": 8,
\"col_int_undef_signed_not_null\": 9, \"col_date_undef_signed\":
\"2023-12-19\", \"col_date_undef_signed_not_null\": \"2023-12-15\",
\"col_varchar_10__undef_signed\": \"f\",
\"col_varchar_10__undef_signed_not_null\": \"good\",
\"col_varchar_1024__undef_signed\": \"t\",
\"col_varchar_1024__undef_signed_not_null\":
\"o\"}'),('13','{\"col_int_undef_signed\": null,
\"col_int_undef_signed_not_null\": 6, \"col_date_undef_signed\":
\"2023-12-09\", \"col_date_undef_signed_not_null\": \"202
3-12-19\", \"col_varchar_10__undef_signed\": \"when\",
\"col_varchar_10__undef_signed_not_null\": \"from\",
\"col_varchar_1024__undef_signed\": \"get\",
\"col_varchar_1024__undef_signed_not_null\":
\"your\"}'),('14','{\"col_int_undef_signed\": 4,
\"col_int_undef_signed_not_null\": 2, \"col_date_undef_signed\":
\"2023-12-13\", \"col_date_undef_signed_not_null\": \"2023-12-16\",
\"col_varchar_10__undef_signed\": \"in\",
\"col_varchar_10__undef_signed_not_null\": \"I\'\'m\",
\"col_varchar_1024__undef_signed\": \"your\",
\"col_varchar_1024__undef_signed_not_null\":
\"come\"}'),('15','{\"col_int_undef_signed\": 5,
\"col_int_undef_signed_not_null\": 8, \"col_date_undef_signed\":
\"2023-12-18\", \"col_date_undef_signed_not_null\": \"2023-12-19\",
\"col_varchar_10__undef_signed\": \"c\",
\"col_varchar_10__undef_signed_not_null\": \"r\",
\"col_varchar_1024__undef_signed\": \"g\",
\"col_varchar_1024__undef_signed_not_null\":
\"j\"}'),('16','{\"col_int_undef_signed\": null, \"col_int_undef_sig
ned_not_null\": 1, \"col_date_undef_signed\": \"2023-12-18\",
\"col_date_undef_signed_not_null\": \"2023-12-14\",
\"col_varchar_10__undef_signed\": \"c\",
\"col_varchar_10__undef_signed_not_null\": \"why\",
\"col_varchar_1024__undef_signed\": \"up\",
\"col_varchar_1024__undef_signed_not_null\":
\"p\"}'),('17','{\"col_int_undef_signed\": 4,
\"col_int_undef_signed_not_null\": 4, \"col_date_undef_signed\":
\"2023-12-16\", \"col_date_undef_signed_not_null\": \"2023-12-14\",
\"col_varchar_10__undef_signed\": \"good\",
\"col_varchar_10__undef_signed_not_null\": \"I\'\'m\",
\"col_varchar_1024__undef_signed\": \"j\",
\"col_varchar_1024__undef_signed_not_null\":
\"was\"}'),('18','{\"col_int_undef_signed\": null,
\"col_int_undef_signed_not_null\": 5, \"col_date_undef_signed\":
\"2023-12-15\", \"col_date_undef_signed_not_null\": \"2023-12-18\",
\"col_varchar_10__undef_signed\": \"c\",
\"col_varchar_10__undef_signed_not_null\": \"o\",
\"col_varchar_1024__undef_signed\": \"u\", \"col_varchar_102
4__undef_signed_not_null\": \"k\"}'),('19','{\"col_int_undef_signed\": 9,
\"col_int_undef_signed_not_null\": 3, \"col_date_undef_signed\":
\"2023-12-16\", \"col_date_undef_signed_not_null\": \"2023-12-16\",
\"col_varchar_10__undef_signed\": \"go\",
\"col_varchar_10__undef_signed_not_null\": \"k\",
\"col_varchar_1024__undef_signed\": \"y\",
\"col_varchar_1024__undef_signed_not_null\":
\"all\"}'),('20','{\"col_int_undef_signed\": 7,
\"col_int_undef_signed_not_null\": 2, \"col_date_undef_signed\":
\"2023-12-11\", \"col_date_undef_signed_not_null\": \"2023-12-14\",
\"col_varchar_10__undef_signed\": \"you\'\'re\",
\"col_varchar_10__undef_signed_not_null\": \"w\",
\"col_varchar_1024__undef_signed\": \"all\",
\"col_varchar_1024__undef_signed_not_null\":
\"they\"}'),('21','{\"col_int_undef_signed\": 0,
\"col_int_undef_signed_not_null\": 1, \"col_date_undef_signed\":
\"2023-12-15\", \"col_date_undef_signed_not_null\": \"2023-12-14\",
\"col_varchar_10__undef_signed\": \"but\", \"col_varchar_1
0__undef_signed_not_null\": \"just\", \"col_varchar_1024__undef_signed\":
\"p\", \"col_varchar_1024__undef_signed_not_null\":
\"have\"}'),('22','{\"col_int_undef_signed\": null,
\"col_int_undef_signed_not_null\": 4, \"col_date_undef_signed\":
\"2023-12-19\", \"col_date_undef_signed_not_null\": \"2023-12-11\",
\"col_varchar_10__undef_signed\": \"a\",
\"col_varchar_10__undef_signed_not_null\": \"know\",
\"col_varchar_1024__undef_signed\": \"my\",
\"col_varchar_1024__undef_signed_not_null\":
\"ok\"}'),('23','{\"col_int_undef_signed\": null,
\"col_int_undef_signed_not_null\": 7, \"col_date_undef_signed\":
\"2023-12-14\", \"col_date_undef_signed_not_null\": \"2023-12-10\",
\"col_varchar_10__undef_signed\": \"l\",
\"col_varchar_10__undef_signed_not_null\": \"it\",
\"col_varchar_1024__undef_signed\": \"did\",
\"col_varchar_1024__undef_signed_not_null\": \"n\"}');
+CREATE TABLE IF NOT EXISTS
table_24_undef_partitions2_keys3_properties4_distributed_by52 ( pk int, var
VARIANT NULL ) engine=olap DUPLICATE KEY(pk) distributed by hash(pk) buckets 10
properties("replication_num" = "1");
+INSERT INTO
table_24_undef_partitions2_keys3_properties4_distributed_by52(pk,var) VALUES
('0','{\"col_int_undef_signed\": 1, \"col_int_undef_signed_not_null\": 8,
\"col_date_undef_signed\": \"2023-12-15\", \"col_date_undef_signed_not_null\":
\"2023-12-19\", \"col_varchar_10__undef_signed\": \"he\",
\"col_varchar_10__undef_signed_not_null\": \"it\",
\"col_varchar_1024__undef_signed\": \"can\",
\"col_varchar_1024__undef_signed_not_null\":
\"r\"}'),('1','{\"col_int_undef_signed\": null,
\"col_int_undef_signed_not_null\": 1, \"col_date_undef_signed\":
\"2023-12-16\", \"col_date_undef_signed_not_null\": \"2023-12-14\",
\"col_varchar_10__undef_signed\": \"e\",
\"col_varchar_10__undef_signed_not_null\": \"ok\",
\"col_varchar_1024__undef_signed\": \"don\'\'t\",
\"col_varchar_1024__undef_signed_not_null\":
\"l\"}'),('2','{\"col_int_undef_signed\": 9, \"col_int_undef_signed_not_null\":
5, \"col_date_undef_signed\": \"2023-12-19\",
\"col_date_undef_signed_not_null\": \"2023-12-17\", \"col_varc
har_10__undef_signed\": \"k\", \"col_varchar_10__undef_signed_not_null\":
\"we\", \"col_varchar_1024__undef_signed\": \"and\",
\"col_varchar_1024__undef_signed_not_null\":
\"s\"}'),('3','{\"col_int_undef_signed\": null,
\"col_int_undef_signed_not_null\": 1, \"col_date_undef_signed\":
\"2023-12-11\", \"col_date_undef_signed_not_null\": \"2023-12-19\",
\"col_varchar_10__undef_signed\": \"don\'\'t\",
\"col_varchar_10__undef_signed_not_null\": \"u\",
\"col_varchar_1024__undef_signed\": \"s\",
\"col_varchar_1024__undef_signed_not_null\":
\"i\"}'),('4','{\"col_int_undef_signed\": 4, \"col_int_undef_signed_not_null\":
1, \"col_date_undef_signed\": \"2023-12-12\",
\"col_date_undef_signed_not_null\": \"2023-12-17\",
\"col_varchar_10__undef_signed\": \"k\",
\"col_varchar_10__undef_signed_not_null\": \"b\",
\"col_varchar_1024__undef_signed\": \"k\",
\"col_varchar_1024__undef_signed_not_null\":
\"be\"}'),('5','{\"col_int_undef_signed\": 2,
\"col_int_undef_signed_not_null\": 6, \"col_date_undef_
signed\": \"2023-12-15\", \"col_date_undef_signed_not_null\": \"2023-12-11\",
\"col_varchar_10__undef_signed\": \"something\",
\"col_varchar_10__undef_signed_not_null\": \"are\",
\"col_varchar_1024__undef_signed\": \"f\",
\"col_varchar_1024__undef_signed_not_null\":
\"well\"}'),('6','{\"col_int_undef_signed\": 1,
\"col_int_undef_signed_not_null\": 9, \"col_date_undef_signed\":
\"2023-12-09\", \"col_date_undef_signed_not_null\": \"2023-12-14\",
\"col_varchar_10__undef_signed\": \"see\",
\"col_varchar_10__undef_signed_not_null\": \"him\",
\"col_varchar_1024__undef_signed\": \"your\",
\"col_varchar_1024__undef_signed_not_null\":
\"q\"}'),('7','{\"col_int_undef_signed\": 6, \"col_int_undef_signed_not_null\":
4, \"col_date_undef_signed\": \"2023-12-12\",
\"col_date_undef_signed_not_null\": \"2023-12-17\",
\"col_varchar_10__undef_signed\": \"g\",
\"col_varchar_10__undef_signed_not_null\": \"I\'\'ll\",
\"col_varchar_1024__undef_signed\": \"l\",
\"col_varchar_1024__undef_signed_not_null\":
\"w\"}'),('8','{\"col_int_undef_signed\": 0,
\"col_int_undef_signed_not_null\": 2, \"col_date_undef_signed\":
\"2023-12-09\", \"col_date_undef_signed_not_null\": \"2023-12-12\",
\"col_varchar_10__undef_signed\": \"and\",
\"col_varchar_10__undef_signed_not_null\": \"are\",
\"col_varchar_1024__undef_signed\": \"back\",
\"col_varchar_1024__undef_signed_not_null\":
\"ok\"}'),('9','{\"col_int_undef_signed\": 9,
\"col_int_undef_signed_not_null\": 3, \"col_date_undef_signed\":
\"2023-12-14\", \"col_date_undef_signed_not_null\": \"2023-12-14\",
\"col_varchar_10__undef_signed\": \"y\",
\"col_varchar_10__undef_signed_not_null\": \"a\",
\"col_varchar_1024__undef_signed\": \"will\",
\"col_varchar_1024__undef_signed_not_null\":
\"she\"}'),('10','{\"col_int_undef_signed\": 9,
\"col_int_undef_signed_not_null\": 6, \"col_date_undef_signed\":
\"2023-12-19\", \"col_date_undef_signed_not_null\": \"2023-12-15\",
\"col_varchar_10__undef_signed\": \"i\",
\"col_varchar_10__undef_signed_not_null\": \"were\
", \"col_varchar_1024__undef_signed\": \"e\",
\"col_varchar_1024__undef_signed_not_null\":
\"yeah\"}'),('11','{\"col_int_undef_signed\": null,
\"col_int_undef_signed_not_null\": 5, \"col_date_undef_signed\":
\"2023-12-12\", \"col_date_undef_signed_not_null\": \"2023-12-16\",
\"col_varchar_10__undef_signed\": \"had\",
\"col_varchar_10__undef_signed_not_null\": \"this\",
\"col_varchar_1024__undef_signed\": \"would\",
\"col_varchar_1024__undef_signed_not_null\":
\"b\"}'),('12','{\"col_int_undef_signed\": null,
\"col_int_undef_signed_not_null\": 2, \"col_date_undef_signed\":
\"2023-12-11\", \"col_date_undef_signed_not_null\": \"2023-12-10\",
\"col_varchar_10__undef_signed\": \"he\'\'s\",
\"col_varchar_10__undef_signed_not_null\": \"o\",
\"col_varchar_1024__undef_signed\": \"s\",
\"col_varchar_1024__undef_signed_not_null\":
\"at\"}'),('13','{\"col_int_undef_signed\": null,
\"col_int_undef_signed_not_null\": 2, \"col_date_undef_signed\":
\"2023-12-19\", \"col_date_undef_signed_not_null\":
\"2023-12-15\", \"col_varchar_10__undef_signed\": \"look\",
\"col_varchar_10__undef_signed_not_null\": \"don\'\'t\",
\"col_varchar_1024__undef_signed\": \"t\",
\"col_varchar_1024__undef_signed_not_null\":
\"u\"}'),('14','{\"col_int_undef_signed\": null,
\"col_int_undef_signed_not_null\": 0, \"col_date_undef_signed\":
\"2023-12-10\", \"col_date_undef_signed_not_null\": \"2023-12-19\",
\"col_varchar_10__undef_signed\": \"and\",
\"col_varchar_10__undef_signed_not_null\": \"he\'\'s\",
\"col_varchar_1024__undef_signed\": \"a\",
\"col_varchar_1024__undef_signed_not_null\":
\"l\"}'),('15','{\"col_int_undef_signed\": 5,
\"col_int_undef_signed_not_null\": 7, \"col_date_undef_signed\":
\"2023-12-09\", \"col_date_undef_signed_not_null\": \"2023-12-17\",
\"col_varchar_10__undef_signed\": \"t\",
\"col_varchar_10__undef_signed_not_null\": \"know\",
\"col_varchar_1024__undef_signed\": \"t\",
\"col_varchar_1024__undef_signed_not_null\":
\"s\"}'),('16','{\"col_int_undef_signed\": 7, \"col_int_undef
_signed_not_null\": 3, \"col_date_undef_signed\": \"2023-12-12\",
\"col_date_undef_signed_not_null\": \"2023-12-12\",
\"col_varchar_10__undef_signed\": \"j\",
\"col_varchar_10__undef_signed_not_null\": \"from\",
\"col_varchar_1024__undef_signed\": \"u\",
\"col_varchar_1024__undef_signed_not_null\":
\"e\"}'),('17','{\"col_int_undef_signed\": 3,
\"col_int_undef_signed_not_null\": 4, \"col_date_undef_signed\":
\"2023-12-17\", \"col_date_undef_signed_not_null\": \"2023-12-11\",
\"col_varchar_10__undef_signed\": \"could\",
\"col_varchar_10__undef_signed_not_null\": \"g\",
\"col_varchar_1024__undef_signed\": \"this\",
\"col_varchar_1024__undef_signed_not_null\":
\"ok\"}'),('18','{\"col_int_undef_signed\": 4,
\"col_int_undef_signed_not_null\": 0, \"col_date_undef_signed\":
\"2023-12-19\", \"col_date_undef_signed_not_null\": \"2023-12-18\",
\"col_varchar_10__undef_signed\": \"time\",
\"col_varchar_10__undef_signed_not_null\": \"he\",
\"col_varchar_1024__undef_signed\": \"oh\", \"col_varchar
_1024__undef_signed_not_null\": \"did\"}'),('19','{\"col_int_undef_signed\":
3, \"col_int_undef_signed_not_null\": 2, \"col_date_undef_signed\":
\"2023-12-14\", \"col_date_undef_signed_not_null\": \"2023-12-12\",
\"col_varchar_10__undef_signed\": \"then\",
\"col_varchar_10__undef_signed_not_null\": \"now\",
\"col_varchar_1024__undef_signed\": \"d\",
\"col_varchar_1024__undef_signed_not_null\":
\"o\"}'),('20','{\"col_int_undef_signed\": null,
\"col_int_undef_signed_not_null\": 2, \"col_date_undef_signed\":
\"2023-12-19\", \"col_date_undef_signed_not_null\": \"2023-12-13\",
\"col_varchar_10__undef_signed\": \"was\",
\"col_varchar_10__undef_signed_not_null\": \"or\",
\"col_varchar_1024__undef_signed\": \"b\",
\"col_varchar_1024__undef_signed_not_null\":
\"a\"}'),('21','{\"col_int_undef_signed\": 2,
\"col_int_undef_signed_not_null\": 4, \"col_date_undef_signed\":
\"2023-12-10\", \"col_date_undef_signed_not_null\": \"2023-12-17\",
\"col_varchar_10__undef_signed\": \"come\", \"col_varchar
_10__undef_signed_not_null\": \"e\", \"col_varchar_1024__undef_signed\":
\"z\", \"col_varchar_1024__undef_signed_not_null\":
\"u\"}'),('22','{\"col_int_undef_signed\": null,
\"col_int_undef_signed_not_null\": 2, \"col_date_undef_signed\":
\"2023-12-19\", \"col_date_undef_signed_not_null\": \"2023-12-11\",
\"col_varchar_10__undef_signed\": \"s\",
\"col_varchar_10__undef_signed_not_null\": \"he\'\'s\",
\"col_varchar_1024__undef_signed\": \"a\",
\"col_varchar_1024__undef_signed_not_null\":
\"know\"}'),('23','{\"col_int_undef_signed\": null,
\"col_int_undef_signed_not_null\": 9, \"col_date_undef_signed\":
\"2023-12-18\", \"col_date_undef_signed_not_null\": \"2023-12-15\",
\"col_varchar_10__undef_signed\": \"c\",
\"col_varchar_10__undef_signed_not_null\": \"up\",
\"col_varchar_1024__undef_signed\": \"come\",
\"col_varchar_1024__undef_signed_not_null\": \"b\"}');
+CREATE TABLE IF NOT EXISTS
table_24_undef_partitions2_keys3_properties4_distributed_by53 ( pk int, var
VARIANT NULL ) engine=olap DUPLICATE KEY(pk) distributed by hash(pk) buckets 10
properties("replication_num" = "1");
+INSERT INTO
table_24_undef_partitions2_keys3_properties4_distributed_by53(pk,var) VALUES
('0','{\"col_int_undef_signed\": null, \"col_int_undef_signed_not_null\": 0,
\"col_date_undef_signed\": \"2023-12-20\", \"col_date_undef_signed_not_null\":
\"2023-12-19\", \"col_varchar_10__undef_signed\": \"or\",
\"col_varchar_10__undef_signed_not_null\": \"I\'\'m\",
\"col_varchar_1024__undef_signed\": \"o\",
\"col_varchar_1024__undef_signed_not_null\":
\"b\"}'),('1','{\"col_int_undef_signed\": 0, \"col_int_undef_signed_not_null\":
1, \"col_date_undef_signed\": \"2023-12-09\",
\"col_date_undef_signed_not_null\": \"2023-12-19\",
\"col_varchar_10__undef_signed\": \"what\",
\"col_varchar_10__undef_signed_not_null\": \"o\",
\"col_varchar_1024__undef_signed\": \"c\",
\"col_varchar_1024__undef_signed_not_null\":
\"n\"}'),('2','{\"col_int_undef_signed\": null,
\"col_int_undef_signed_not_null\": 2, \"col_date_undef_signed\":
\"2023-12-10\", \"col_date_undef_signed_not_null\": \"2023-12-14\", \"col_varc
har_10__undef_signed\": \"m\", \"col_varchar_10__undef_signed_not_null\":
\"so\", \"col_varchar_1024__undef_signed\": \"my\",
\"col_varchar_1024__undef_signed_not_null\":
\"it\"}'),('3','{\"col_int_undef_signed\": 7,
\"col_int_undef_signed_not_null\": 8, \"col_date_undef_signed\":
\"2023-12-11\", \"col_date_undef_signed_not_null\": \"2023-12-09\",
\"col_varchar_10__undef_signed\": \"the\",
\"col_varchar_10__undef_signed_not_null\": \"g\",
\"col_varchar_1024__undef_signed\": \"can\'\'t\",
\"col_varchar_1024__undef_signed_not_null\":
\"c\"}'),('4','{\"col_int_undef_signed\": 9, \"col_int_undef_signed_not_null\":
2, \"col_date_undef_signed\": \"2023-12-18\",
\"col_date_undef_signed_not_null\": \"2023-12-19\",
\"col_varchar_10__undef_signed\": \"be\",
\"col_varchar_10__undef_signed_not_null\": \"say\",
\"col_varchar_1024__undef_signed\": \"z\",
\"col_varchar_1024__undef_signed_not_null\":
\"y\"}'),('5','{\"col_int_undef_signed\": 9, \"col_int_undef_signed_not_null\":
7, \"col_date_undef
_signed\": \"2023-12-13\", \"col_date_undef_signed_not_null\": \"2023-12-14\",
\"col_varchar_10__undef_signed\": \"look\",
\"col_varchar_10__undef_signed_not_null\": \"g\",
\"col_varchar_1024__undef_signed\": \"my\",
\"col_varchar_1024__undef_signed_not_null\":
\"d\"}'),('6','{\"col_int_undef_signed\": null,
\"col_int_undef_signed_not_null\": 4, \"col_date_undef_signed\":
\"2023-12-17\", \"col_date_undef_signed_not_null\": \"2023-12-10\",
\"col_varchar_10__undef_signed\": \"like\",
\"col_varchar_10__undef_signed_not_null\": \"back\",
\"col_varchar_1024__undef_signed\": \"f\",
\"col_varchar_1024__undef_signed_not_null\":
\"know\"}'),('7','{\"col_int_undef_signed\": null,
\"col_int_undef_signed_not_null\": 6, \"col_date_undef_signed\":
\"2023-12-14\", \"col_date_undef_signed_not_null\": \"2023-12-10\",
\"col_varchar_10__undef_signed\": \"now\",
\"col_varchar_10__undef_signed_not_null\": \"this\",
\"col_varchar_1024__undef_signed\": \"w\",
\"col_varchar_1024__undef_signed_not_null\": \
"n\"}'),('8','{\"col_int_undef_signed\": null,
\"col_int_undef_signed_not_null\": 1, \"col_date_undef_signed\":
\"2023-12-17\", \"col_date_undef_signed_not_null\": \"2023-12-13\",
\"col_varchar_10__undef_signed\": \"l\",
\"col_varchar_10__undef_signed_not_null\": \"would\",
\"col_varchar_1024__undef_signed\": \"a\",
\"col_varchar_1024__undef_signed_not_null\":
\"h\"}'),('9','{\"col_int_undef_signed\": null,
\"col_int_undef_signed_not_null\": 6, \"col_date_undef_signed\":
\"2023-12-20\", \"col_date_undef_signed_not_null\": \"2023-12-13\",
\"col_varchar_10__undef_signed\": \"r\",
\"col_varchar_10__undef_signed_not_null\": \"e\",
\"col_varchar_1024__undef_signed\": \"n\",
\"col_varchar_1024__undef_signed_not_null\":
\"h\"}'),('10','{\"col_int_undef_signed\": 9,
\"col_int_undef_signed_not_null\": 8, \"col_date_undef_signed\":
\"2023-12-15\", \"col_date_undef_signed_not_null\": \"2023-12-12\",
\"col_varchar_10__undef_signed\": \"but\",
\"col_varchar_10__undef_signed_not_null\": \"could\"
, \"col_varchar_1024__undef_signed\": \"f\",
\"col_varchar_1024__undef_signed_not_null\":
\"is\"}'),('11','{\"col_int_undef_signed\": null,
\"col_int_undef_signed_not_null\": 5, \"col_date_undef_signed\":
\"2023-12-19\", \"col_date_undef_signed_not_null\": \"2023-12-19\",
\"col_varchar_10__undef_signed\": \"r\",
\"col_varchar_10__undef_signed_not_null\": \"k\",
\"col_varchar_1024__undef_signed\": \"are\",
\"col_varchar_1024__undef_signed_not_null\":
\"up\"}'),('12','{\"col_int_undef_signed\": 9,
\"col_int_undef_signed_not_null\": 7, \"col_date_undef_signed\":
\"2023-12-18\", \"col_date_undef_signed_not_null\": \"2023-12-09\",
\"col_varchar_10__undef_signed\": \"l\",
\"col_varchar_10__undef_signed_not_null\": \"what\",
\"col_varchar_1024__undef_signed\": \"s\",
\"col_varchar_1024__undef_signed_not_null\":
\"m\"}'),('13','{\"col_int_undef_signed\": 8,
\"col_int_undef_signed_not_null\": 1, \"col_date_undef_signed\":
\"2023-12-18\", \"col_date_undef_signed_not_null\": \"2023-12-12\", \"
col_varchar_10__undef_signed\": \"v\",
\"col_varchar_10__undef_signed_not_null\": \"of\",
\"col_varchar_1024__undef_signed\": \"did\",
\"col_varchar_1024__undef_signed_not_null\":
\"did\"}'),('14','{\"col_int_undef_signed\": 9,
\"col_int_undef_signed_not_null\": 6, \"col_date_undef_signed\":
\"2023-12-12\", \"col_date_undef_signed_not_null\": \"2023-12-15\",
\"col_varchar_10__undef_signed\": \"a\",
\"col_varchar_10__undef_signed_not_null\": \"can\",
\"col_varchar_1024__undef_signed\": \"when\",
\"col_varchar_1024__undef_signed_not_null\":
\"she\"}'),('15','{\"col_int_undef_signed\": null,
\"col_int_undef_signed_not_null\": 9, \"col_date_undef_signed\":
\"2023-12-15\", \"col_date_undef_signed_not_null\": \"2023-12-14\",
\"col_varchar_10__undef_signed\": \"I\'\'ll\",
\"col_varchar_10__undef_signed_not_null\": \"is\",
\"col_varchar_1024__undef_signed\": \"q\",
\"col_varchar_1024__undef_signed_not_null\":
\"v\"}'),('16','{\"col_int_undef_signed\": 9,
\"col_int_undef_signed_not_null\": 4
, \"col_date_undef_signed\": \"2023-12-19\",
\"col_date_undef_signed_not_null\": \"2023-12-14\",
\"col_varchar_10__undef_signed\": \"here\",
\"col_varchar_10__undef_signed_not_null\": \"up\",
\"col_varchar_1024__undef_signed\": \"some\",
\"col_varchar_1024__undef_signed_not_null\":
\"think\"}'),('17','{\"col_int_undef_signed\": 0,
\"col_int_undef_signed_not_null\": 8, \"col_date_undef_signed\":
\"2023-12-10\", \"col_date_undef_signed_not_null\": \"2023-12-09\",
\"col_varchar_10__undef_signed\": \"say\",
\"col_varchar_10__undef_signed_not_null\": \"u\",
\"col_varchar_1024__undef_signed\": \"up\",
\"col_varchar_1024__undef_signed_not_null\":
\"didn\'\'t\"}'),('18','{\"col_int_undef_signed\": 7,
\"col_int_undef_signed_not_null\": 1, \"col_date_undef_signed\":
\"2023-12-11\", \"col_date_undef_signed_not_null\": \"2023-12-11\",
\"col_varchar_10__undef_signed\": \"t\",
\"col_varchar_10__undef_signed_not_null\": \"v\",
\"col_varchar_1024__undef_signed\": \"s\", \"col_varchar_1024__undef_si
gned_not_null\": \"w\"}'),('19','{\"col_int_undef_signed\": null,
\"col_int_undef_signed_not_null\": 0, \"col_date_undef_signed\":
\"2023-12-17\", \"col_date_undef_signed_not_null\": \"2023-12-20\",
\"col_varchar_10__undef_signed\": \"t\",
\"col_varchar_10__undef_signed_not_null\": \"o\",
\"col_varchar_1024__undef_signed\": \"w\",
\"col_varchar_1024__undef_signed_not_null\":
\"that\"}'),('20','{\"col_int_undef_signed\": 8,
\"col_int_undef_signed_not_null\": 3, \"col_date_undef_signed\":
\"2023-12-12\", \"col_date_undef_signed_not_null\": \"2023-12-12\",
\"col_varchar_10__undef_signed\": \"because\",
\"col_varchar_10__undef_signed_not_null\": \"f\",
\"col_varchar_1024__undef_signed\": \"e\",
\"col_varchar_1024__undef_signed_not_null\":
\"want\"}'),('21','{\"col_int_undef_signed\": 8,
\"col_int_undef_signed_not_null\": 8, \"col_date_undef_signed\":
\"2023-12-19\", \"col_date_undef_signed_not_null\": \"2023-12-17\",
\"col_varchar_10__undef_signed\": \"have\", \"col_varchar_10__undef_si
gned_not_null\": \"f\", \"col_varchar_1024__undef_signed\": \"it\'\'s\",
\"col_varchar_1024__undef_signed_not_null\":
\"m\"}'),('22','{\"col_int_undef_signed\": null,
\"col_int_undef_signed_not_null\": 6, \"col_date_undef_signed\":
\"2023-12-11\", \"col_date_undef_signed_not_null\": \"2023-12-14\",
\"col_varchar_10__undef_signed\": \"to\",
\"col_varchar_10__undef_signed_not_null\": \"u\",
\"col_varchar_1024__undef_signed\": \"who\",
\"col_varchar_1024__undef_signed_not_null\":
\"y\"}'),('23','{\"col_int_undef_signed\": 6,
\"col_int_undef_signed_not_null\": 8, \"col_date_undef_signed\":
\"2023-12-20\", \"col_date_undef_signed_not_null\": \"2023-12-16\",
\"col_varchar_10__undef_signed\": \"u\",
\"col_varchar_10__undef_signed_not_null\": \"how\",
\"col_varchar_1024__undef_signed\": \"r\",
\"col_varchar_1024__undef_signed_not_null\": \"of\"}');
+CREATE TABLE IF NOT EXISTS
table_24_undef_partitions2_keys3_properties4_distributed_by54 ( pk int, var
VARIANT NULL ) engine=olap DUPLICATE KEY(pk) distributed by hash(pk) buckets 10
properties("replication_num" = "1");
+INSERT INTO
table_24_undef_partitions2_keys3_properties4_distributed_by54(pk,var) VALUES
('0','{\"col_int_undef_signed\": 2, \"col_int_undef_signed_not_null\": 0,
\"col_date_undef_signed\": \"2023-12-09\", \"col_date_undef_signed_not_null\":
\"2023-12-20\", \"col_varchar_10__undef_signed\": \"we\",
\"col_varchar_10__undef_signed_not_null\": \"k\",
\"col_varchar_1024__undef_signed\": \"m\",
\"col_varchar_1024__undef_signed_not_null\":
\"your\"}'),('1','{\"col_int_undef_signed\": null,
\"col_int_undef_signed_not_null\": 8, \"col_date_undef_signed\":
\"2023-12-20\", \"col_date_undef_signed_not_null\": \"2023-12-17\",
\"col_varchar_10__undef_signed\": \"his\",
\"col_varchar_10__undef_signed_not_null\": \"q\",
\"col_varchar_1024__undef_signed\": \"well\",
\"col_varchar_1024__undef_signed_not_null\":
\"yes\"}'),('2','{\"col_int_undef_signed\": 2,
\"col_int_undef_signed_not_null\": 8, \"col_date_undef_signed\":
\"2023-12-17\", \"col_date_undef_signed_not_null\": \"2023-12-15\", \"col_varch
ar_10__undef_signed\": \"w\", \"col_varchar_10__undef_signed_not_null\":
\"g\", \"col_varchar_1024__undef_signed\": \"g\",
\"col_varchar_1024__undef_signed_not_null\":
\"didn\'\'t\"}'),('3','{\"col_int_undef_signed\": null,
\"col_int_undef_signed_not_null\": 7, \"col_date_undef_signed\":
\"2023-12-17\", \"col_date_undef_signed_not_null\": \"2023-12-18\",
\"col_varchar_10__undef_signed\": \"oh\",
\"col_varchar_10__undef_signed_not_null\": \"n\",
\"col_varchar_1024__undef_signed\": \"could\",
\"col_varchar_1024__undef_signed_not_null\":
\"like\"}'),('4','{\"col_int_undef_signed\": null,
\"col_int_undef_signed_not_null\": 3, \"col_date_undef_signed\":
\"2023-12-15\", \"col_date_undef_signed_not_null\": \"2023-12-20\",
\"col_varchar_10__undef_signed\": \"g\",
\"col_varchar_10__undef_signed_not_null\": \"d\",
\"col_varchar_1024__undef_signed\": \"this\",
\"col_varchar_1024__undef_signed_not_null\":
\"p\"}'),('5','{\"col_int_undef_signed\": 3, \"col_int_undef_signed_not_null\":
2, \"col_d
ate_undef_signed\": \"2023-12-19\", \"col_date_undef_signed_not_null\":
\"2023-12-13\", \"col_varchar_10__undef_signed\": \"oh\",
\"col_varchar_10__undef_signed_not_null\": \"z\",
\"col_varchar_1024__undef_signed\": \"like\",
\"col_varchar_1024__undef_signed_not_null\":
\"that\'\'s\"}'),('6','{\"col_int_undef_signed\": null,
\"col_int_undef_signed_not_null\": 8, \"col_date_undef_signed\":
\"2023-12-09\", \"col_date_undef_signed_not_null\": \"2023-12-09\",
\"col_varchar_10__undef_signed\": \"will\",
\"col_varchar_10__undef_signed_not_null\": \"n\",
\"col_varchar_1024__undef_signed\": \"a\",
\"col_varchar_1024__undef_signed_not_null\":
\"o\"}'),('7','{\"col_int_undef_signed\": 7, \"col_int_undef_signed_not_null\":
4, \"col_date_undef_signed\": \"2023-12-15\",
\"col_date_undef_signed_not_null\": \"2023-12-13\",
\"col_varchar_10__undef_signed\": \"have\",
\"col_varchar_10__undef_signed_not_null\": \"just\",
\"col_varchar_1024__undef_signed\": \"n\", \"col_varchar_1024__undef_signed_not_
null\": \"t\"}'),('8','{\"col_int_undef_signed\": null,
\"col_int_undef_signed_not_null\": 9, \"col_date_undef_signed\":
\"2023-12-17\", \"col_date_undef_signed_not_null\": \"2023-12-14\",
\"col_varchar_10__undef_signed\": \"here\",
\"col_varchar_10__undef_signed_not_null\": \"he\'\'s\",
\"col_varchar_1024__undef_signed\": \"for\",
\"col_varchar_1024__undef_signed_not_null\":
\"f\"}'),('9','{\"col_int_undef_signed\": null,
\"col_int_undef_signed_not_null\": 2, \"col_date_undef_signed\":
\"2023-12-09\", \"col_date_undef_signed_not_null\": \"2023-12-16\",
\"col_varchar_10__undef_signed\": \"c\",
\"col_varchar_10__undef_signed_not_null\": \"yes\",
\"col_varchar_1024__undef_signed\": \"can\'\'t\",
\"col_varchar_1024__undef_signed_not_null\":
\"see\"}'),('10','{\"col_int_undef_signed\": 9,
\"col_int_undef_signed_not_null\": 7, \"col_date_undef_signed\":
\"2023-12-15\", \"col_date_undef_signed_not_null\": \"2023-12-12\",
\"col_varchar_10__undef_signed\": \"a\", \"col_varchar_10__undef_sig
ned_not_null\": \"if\", \"col_varchar_1024__undef_signed\": \"e\",
\"col_varchar_1024__undef_signed_not_null\":
\"d\"}'),('11','{\"col_int_undef_signed\": 9,
\"col_int_undef_signed_not_null\": 2, \"col_date_undef_signed\":
\"2023-12-19\", \"col_date_undef_signed_not_null\": \"2023-12-09\",
\"col_varchar_10__undef_signed\": \"out\",
\"col_varchar_10__undef_signed_not_null\": \"in\",
\"col_varchar_1024__undef_signed\": \"k\",
\"col_varchar_1024__undef_signed_not_null\":
\"e\"}'),('12','{\"col_int_undef_signed\": null,
\"col_int_undef_signed_not_null\": 9, \"col_date_undef_signed\":
\"2023-12-11\", \"col_date_undef_signed_not_null\": \"2023-12-11\",
\"col_varchar_10__undef_signed\": \"with\",
\"col_varchar_10__undef_signed_not_null\": \"z\",
\"col_varchar_1024__undef_signed\": \"n\",
\"col_varchar_1024__undef_signed_not_null\":
\"r\"}'),('13','{\"col_int_undef_signed\": null,
\"col_int_undef_signed_not_null\": 3, \"col_date_undef_signed\":
\"2023-12-12\", \"col_date_undef_signed_not_nu
ll\": \"2023-12-17\", \"col_varchar_10__undef_signed\": \"v\",
\"col_varchar_10__undef_signed_not_null\": \"have\",
\"col_varchar_1024__undef_signed\": \"p\",
\"col_varchar_1024__undef_signed_not_null\":
\"p\"}'),('14','{\"col_int_undef_signed\": null,
\"col_int_undef_signed_not_null\": 9, \"col_date_undef_signed\":
\"2023-12-20\", \"col_date_undef_signed_not_null\": \"2023-12-14\",
\"col_varchar_10__undef_signed\": \"m\",
\"col_varchar_10__undef_signed_not_null\": \"o\",
\"col_varchar_1024__undef_signed\": \"see\",
\"col_varchar_1024__undef_signed_not_null\":
\"i\"}'),('15','{\"col_int_undef_signed\": null,
\"col_int_undef_signed_not_null\": 5, \"col_date_undef_signed\":
\"2023-12-12\", \"col_date_undef_signed_not_null\": \"2023-12-10\",
\"col_varchar_10__undef_signed\": \"c\",
\"col_varchar_10__undef_signed_not_null\": \"j\",
\"col_varchar_1024__undef_signed\": \"l\",
\"col_varchar_1024__undef_signed_not_null\":
\"y\"}'),('16','{\"col_int_undef_signed\": 3, \"col_int_undef_signed_
not_null\": 6, \"col_date_undef_signed\": \"2023-12-12\",
\"col_date_undef_signed_not_null\": \"2023-12-19\",
\"col_varchar_10__undef_signed\": \"think\",
\"col_varchar_10__undef_signed_not_null\": \"so\",
\"col_varchar_1024__undef_signed\": \"hey\",
\"col_varchar_1024__undef_signed_not_null\":
\"want\"}'),('17','{\"col_int_undef_signed\": 7,
\"col_int_undef_signed_not_null\": 7, \"col_date_undef_signed\":
\"2023-12-17\", \"col_date_undef_signed_not_null\": \"2023-12-18\",
\"col_varchar_10__undef_signed\": \"because\",
\"col_varchar_10__undef_signed_not_null\": \"h\",
\"col_varchar_1024__undef_signed\": \"t\",
\"col_varchar_1024__undef_signed_not_null\":
\"e\"}'),('18','{\"col_int_undef_signed\": 2,
\"col_int_undef_signed_not_null\": 4, \"col_date_undef_signed\":
\"2023-12-11\", \"col_date_undef_signed_not_null\": \"2023-12-10\",
\"col_varchar_10__undef_signed\": \"I\'\'ll\",
\"col_varchar_10__undef_signed_not_null\": \"w\",
\"col_varchar_1024__undef_signed\": \"o\", \"col_varchar_1
024__undef_signed_not_null\":
\"that\'\'s\"}'),('19','{\"col_int_undef_signed\": null,
\"col_int_undef_signed_not_null\": 4, \"col_date_undef_signed\":
\"2023-12-12\", \"col_date_undef_signed_not_null\": \"2023-12-19\",
\"col_varchar_10__undef_signed\": \"b\",
\"col_varchar_10__undef_signed_not_null\": \"t\",
\"col_varchar_1024__undef_signed\": \"m\",
\"col_varchar_1024__undef_signed_not_null\":
\"then\"}'),('20','{\"col_int_undef_signed\": null,
\"col_int_undef_signed_not_null\": 6, \"col_date_undef_signed\":
\"2023-12-18\", \"col_date_undef_signed_not_null\": \"2023-12-19\",
\"col_varchar_10__undef_signed\": \"x\",
\"col_varchar_10__undef_signed_not_null\": \"there\",
\"col_varchar_1024__undef_signed\": \"as\",
\"col_varchar_1024__undef_signed_not_null\":
\"how\"}'),('21','{\"col_int_undef_signed\": null,
\"col_int_undef_signed_not_null\": 9, \"col_date_undef_signed\":
\"2023-12-16\", \"col_date_undef_signed_not_null\": \"2023-12-17\",
\"col_varchar_10__undef_signed\": \"w\", \"co
l_varchar_10__undef_signed_not_null\": \"how\",
\"col_varchar_1024__undef_signed\": \"he\",
\"col_varchar_1024__undef_signed_not_null\":
\"she\"}'),('22','{\"col_int_undef_signed\": null,
\"col_int_undef_signed_not_null\": 0, \"col_date_undef_signed\":
\"2023-12-09\", \"col_date_undef_signed_not_null\": \"2023-12-18\",
\"col_varchar_10__undef_signed\": \"m\",
\"col_varchar_10__undef_signed_not_null\": \"w\",
\"col_varchar_1024__undef_signed\": \"i\",
\"col_varchar_1024__undef_signed_not_null\":
\"p\"}'),('23','{\"col_int_undef_signed\": 4,
\"col_int_undef_signed_not_null\": 6, \"col_date_undef_signed\":
\"2023-12-13\", \"col_date_undef_signed_not_null\": \"2023-12-14\",
\"col_varchar_10__undef_signed\": \"did\",
\"col_varchar_10__undef_signed_not_null\": \"c\",
\"col_varchar_1024__undef_signed\": \"f\",
\"col_varchar_1024__undef_signed_not_null\": \"h\"}');
+CREATE TABLE IF NOT EXISTS
table_25_undef_partitions2_keys3_properties4_distributed_by52 ( pk int, var
VARIANT NULL ) engine=olap DUPLICATE KEY(pk) distributed by hash(pk) buckets 10
properties("replication_num" = "1");
+INSERT INTO
table_25_undef_partitions2_keys3_properties4_distributed_by52(pk,var) VALUES
('0','{\"col_int_undef_signed\": 9, \"col_int_undef_signed_not_null\": 7,
\"col_date_undef_signed\": \"2023-12-11\", \"col_date_undef_signed_not_null\":
\"2023-12-09\", \"col_varchar_10__undef_signed\": \"x\",
\"col_varchar_10__undef_signed_not_null\": \"and\",
\"col_varchar_1024__undef_signed\": \"see\",
\"col_varchar_1024__undef_signed_not_null\":
\"h\"}'),('1','{\"col_int_undef_signed\": 5, \"col_int_undef_signed_not_null\":
1, \"col_date_undef_signed\": \"2023-12-09\",
\"col_date_undef_signed_not_null\": \"2023-12-20\",
\"col_varchar_10__undef_signed\": \"about\",
\"col_varchar_10__undef_signed_not_null\": \"p\",
\"col_varchar_1024__undef_signed\": \"z\",
\"col_varchar_1024__undef_signed_not_null\":
\"f\"}'),('2','{\"col_int_undef_signed\": 3, \"col_int_undef_signed_not_null\":
2, \"col_date_undef_signed\": \"2023-12-13\",
\"col_date_undef_signed_not_null\": \"2023-12-11\", \"col_varchar_10_
_undef_signed\": \"not\", \"col_varchar_10__undef_signed_not_null\": \"d\",
\"col_varchar_1024__undef_signed\": \"him\",
\"col_varchar_1024__undef_signed_not_null\":
\"r\"}'),('3','{\"col_int_undef_signed\": null,
\"col_int_undef_signed_not_null\": 3, \"col_date_undef_signed\":
\"2023-12-17\", \"col_date_undef_signed_not_null\": \"2023-12-14\",
\"col_varchar_10__undef_signed\": \"me\",
\"col_varchar_10__undef_signed_not_null\": \"c\",
\"col_varchar_1024__undef_signed\": \"k\",
\"col_varchar_1024__undef_signed_not_null\":
\"y\"}'),('4','{\"col_int_undef_signed\": null,
\"col_int_undef_signed_not_null\": 5, \"col_date_undef_signed\":
\"2023-12-11\", \"col_date_undef_signed_not_null\": \"2023-12-20\",
\"col_varchar_10__undef_signed\": \"got\",
\"col_varchar_10__undef_signed_not_null\": \"had\",
\"col_varchar_1024__undef_signed\": \"d\",
\"col_varchar_1024__undef_signed_not_null\":
\"you\"}'),('5','{\"col_int_undef_signed\": null,
\"col_int_undef_signed_not_null\": 0, \"col_date_undef_s
igned\": \"2023-12-10\", \"col_date_undef_signed_not_null\": \"2023-12-12\",
\"col_varchar_10__undef_signed\": \"t\",
\"col_varchar_10__undef_signed_not_null\": \"your\",
\"col_varchar_1024__undef_signed\": \"that\",
\"col_varchar_1024__undef_signed_not_null\":
\"g\"}'),('6','{\"col_int_undef_signed\": 8, \"col_int_undef_signed_not_null\":
4, \"col_date_undef_signed\": \"2023-12-11\",
\"col_date_undef_signed_not_null\": \"2023-12-14\",
\"col_varchar_10__undef_signed\": \"that\",
\"col_varchar_10__undef_signed_not_null\": \"they\",
\"col_varchar_1024__undef_signed\": \"b\",
\"col_varchar_1024__undef_signed_not_null\":
\"back\"}'),('7','{\"col_int_undef_signed\": 3,
\"col_int_undef_signed_not_null\": 4, \"col_date_undef_signed\":
\"2023-12-12\", \"col_date_undef_signed_not_null\": \"2023-12-16\",
\"col_varchar_10__undef_signed\": \"b\",
\"col_varchar_10__undef_signed_not_null\": \"okay\",
\"col_varchar_1024__undef_signed\": \"then\",
\"col_varchar_1024__undef_signed_not_null\": \"woul
d\"}'),('8','{\"col_int_undef_signed\": 3, \"col_int_undef_signed_not_null\":
6, \"col_date_undef_signed\": \"2023-12-10\",
\"col_date_undef_signed_not_null\": \"2023-12-18\",
\"col_varchar_10__undef_signed\": \"they\",
\"col_varchar_10__undef_signed_not_null\": \"w\",
\"col_varchar_1024__undef_signed\": \"o\",
\"col_varchar_1024__undef_signed_not_null\":
\"could\"}'),('9','{\"col_int_undef_signed\": 9,
\"col_int_undef_signed_not_null\": 4, \"col_date_undef_signed\":
\"2023-12-16\", \"col_date_undef_signed_not_null\": \"2023-12-19\",
\"col_varchar_10__undef_signed\": \"b\",
\"col_varchar_10__undef_signed_not_null\": \"y\",
\"col_varchar_1024__undef_signed\": \"like\",
\"col_varchar_1024__undef_signed_not_null\":
\"your\"}'),('10','{\"col_int_undef_signed\": 7,
\"col_int_undef_signed_not_null\": 3, \"col_date_undef_signed\":
\"2023-12-09\", \"col_date_undef_signed_not_null\": \"2023-12-13\",
\"col_varchar_10__undef_signed\": \"x\",
\"col_varchar_10__undef_signed_not_null\": \"good\",
\"col_varchar_1024__undef_signed\": \"r\",
\"col_varchar_1024__undef_signed_not_null\":
\"oh\"}'),('11','{\"col_int_undef_signed\": 9,
\"col_int_undef_signed_not_null\": 4, \"col_date_undef_signed\":
\"2023-12-13\", \"col_date_undef_signed_not_null\": \"2023-12-13\",
\"col_varchar_10__undef_signed\": \"will\",
\"col_varchar_10__undef_signed_not_null\": \"a\",
\"col_varchar_1024__undef_signed\": \"m\",
\"col_varchar_1024__undef_signed_not_null\":
\"his\"}'),('12','{\"col_int_undef_signed\": null,
\"col_int_undef_signed_not_null\": 3, \"col_date_undef_signed\":
\"2023-12-19\", \"col_date_undef_signed_not_null\": \"2023-12-17\",
\"col_varchar_10__undef_signed\": \"his\",
\"col_varchar_10__undef_signed_not_null\": \"when\",
\"col_varchar_1024__undef_signed\": \"not\",
\"col_varchar_1024__undef_signed_not_null\":
\"q\"}'),('13','{\"col_int_undef_signed\": null,
\"col_int_undef_signed_not_null\": 8, \"col_date_undef_signed\":
\"2023-12-19\", \"col_date_undef_signed_not_null\": \"2023-12-
18\", \"col_varchar_10__undef_signed\": \"good\",
\"col_varchar_10__undef_signed_not_null\": \"q\",
\"col_varchar_1024__undef_signed\": \"x\",
\"col_varchar_1024__undef_signed_not_null\":
\"say\"}'),('14','{\"col_int_undef_signed\": 6,
\"col_int_undef_signed_not_null\": 4, \"col_date_undef_signed\":
\"2023-12-15\", \"col_date_undef_signed_not_null\": \"2023-12-19\",
\"col_varchar_10__undef_signed\": \"oh\",
\"col_varchar_10__undef_signed_not_null\": \"me\",
\"col_varchar_1024__undef_signed\": \"z\",
\"col_varchar_1024__undef_signed_not_null\":
\"out\"}'),('15','{\"col_int_undef_signed\": 1,
\"col_int_undef_signed_not_null\": 2, \"col_date_undef_signed\":
\"2023-12-13\", \"col_date_undef_signed_not_null\": \"2023-12-17\",
\"col_varchar_10__undef_signed\": \"i\",
\"col_varchar_10__undef_signed_not_null\": \"what\",
\"col_varchar_1024__undef_signed\": \"go\",
\"col_varchar_1024__undef_signed_not_null\":
\"are\"}'),('16','{\"col_int_undef_signed\": 8,
\"col_int_undef_signed_not_null\":
2, \"col_date_undef_signed\": \"2023-12-15\",
\"col_date_undef_signed_not_null\": \"2023-12-15\",
\"col_varchar_10__undef_signed\": \"v\",
\"col_varchar_10__undef_signed_not_null\": \"here\",
\"col_varchar_1024__undef_signed\": \"p\",
\"col_varchar_1024__undef_signed_not_null\":
\"v\"}'),('17','{\"col_int_undef_signed\": 9,
\"col_int_undef_signed_not_null\": 7, \"col_date_undef_signed\":
\"2023-12-10\", \"col_date_undef_signed_not_null\": \"2023-12-14\",
\"col_varchar_10__undef_signed\": \"hey\",
\"col_varchar_10__undef_signed_not_null\": \"b\",
\"col_varchar_1024__undef_signed\": \"r\",
\"col_varchar_1024__undef_signed_not_null\":
\"m\"}'),('18','{\"col_int_undef_signed\": 5,
\"col_int_undef_signed_not_null\": 1, \"col_date_undef_signed\":
\"2023-12-18\", \"col_date_undef_signed_not_null\": \"2023-12-14\",
\"col_varchar_10__undef_signed\": \"g\",
\"col_varchar_10__undef_signed_not_null\": \"been\",
\"col_varchar_1024__undef_signed\": \"o\",
\"col_varchar_1024__undef_signed_not_null
\": \"I\'\'ll\"}'),('19','{\"col_int_undef_signed\": null,
\"col_int_undef_signed_not_null\": 0, \"col_date_undef_signed\":
\"2023-12-11\", \"col_date_undef_signed_not_null\": \"2023-12-16\",
\"col_varchar_10__undef_signed\": \"i\",
\"col_varchar_10__undef_signed_not_null\": \"d\",
\"col_varchar_1024__undef_signed\": \"look\",
\"col_varchar_1024__undef_signed_not_null\":
\"w\"}'),('20','{\"col_int_undef_signed\": null,
\"col_int_undef_signed_not_null\": 4, \"col_date_undef_signed\":
\"2023-12-18\", \"col_date_undef_signed_not_null\": \"2023-12-13\",
\"col_varchar_10__undef_signed\": \"mean\",
\"col_varchar_10__undef_signed_not_null\": \"n\",
\"col_varchar_1024__undef_signed\": \"him\",
\"col_varchar_1024__undef_signed_not_null\":
\"k\"}'),('21','{\"col_int_undef_signed\": null,
\"col_int_undef_signed_not_null\": 8, \"col_date_undef_signed\":
\"2023-12-10\", \"col_date_undef_signed_not_null\": \"2023-12-20\",
\"col_varchar_10__undef_signed\": \"w\", \"col_varchar_10__undef_signed_not
_null\": \"r\", \"col_varchar_1024__undef_signed\": \"d\",
\"col_varchar_1024__undef_signed_not_null\":
\"because\"}'),('22','{\"col_int_undef_signed\": null,
\"col_int_undef_signed_not_null\": 4, \"col_date_undef_signed\":
\"2023-12-13\", \"col_date_undef_signed_not_null\": \"2023-12-15\",
\"col_varchar_10__undef_signed\": \"z\",
\"col_varchar_10__undef_signed_not_null\": \"with\",
\"col_varchar_1024__undef_signed\": \"s\",
\"col_varchar_1024__undef_signed_not_null\":
\"got\"}'),('23','{\"col_int_undef_signed\": null,
\"col_int_undef_signed_not_null\": 8, \"col_date_undef_signed\":
\"2023-12-12\", \"col_date_undef_signed_not_null\": \"2023-12-12\",
\"col_varchar_10__undef_signed\": \"how\",
\"col_varchar_10__undef_signed_not_null\": \"j\",
\"col_varchar_1024__undef_signed\": \"s\",
\"col_varchar_1024__undef_signed_not_null\":
\"they\"}'),('24','{\"col_int_undef_signed\": null,
\"col_int_undef_signed_not_null\": 8, \"col_date_undef_signed\":
\"2023-12-19\", \"col_date_undef_signed_n
ot_null\": \"2023-12-16\", \"col_varchar_10__undef_signed\": \"h\",
\"col_varchar_10__undef_signed_not_null\": \"this\",
\"col_varchar_1024__undef_signed\": \"from\",
\"col_varchar_1024__undef_signed_not_null\": \"d\"}');
+SELECT CAST(alias2 . var['col_int_undef_signed'] AS int) AS field1 FROM
regression_test_variant_p0_rqg.table_25_undef_partitions2_keys3_properties4_distributed_by52
AS alias1 LEFT OUTER JOIN
regression_test_variant_p0_rqg.table_24_undef_partitions2_keys3_properties4_distributed_by5
AS alias2 ON (alias2 . `pk` = alias1 . `pk` ) HAVING field1 < 4 ORDER BY
field1 ;
Review Comment:
[P1] Make this V2 RQG case read the fixture it prepares.
The unqualified DDL/DML above runs in `regression_test_variant_p0_rqg_v2`
(the framework derives the database from this file's parent directory), but
this SELECT reads `regression_test_variant_p0_rqg`. A focused run therefore
fails unless the separate `rqg` suite happened to populate that database, and
in a full run it can silently validate stale data while all setup in this file
is unused.
Query the unqualified tables created here. If reading the legacy suite's
segments is intentional, create/load that qualified fixture explicitly so the
dependency and storage provenance are deterministic.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
