This is an automated email from the ASF dual-hosted git repository. kxiao pushed a commit to branch branch-2.0 in repository https://gitbox.apache.org/repos/asf/doris.git
commit 96e1d3dbaf31f671a2c3be7cd2bd4708c3797797 Author: amory <[email protected]> AuthorDate: Tue Aug 29 16:18:11 2023 +0800 [FIX](array)update array olapconvertor and support array nested other complex type (#23489) * update array olapconvertor and support array nested other complex type * update for inverted index --- be/src/olap/rowset/segment_v2/column_reader.cpp | 1 + be/src/olap/rowset/segment_v2/column_writer.cpp | 69 +++++------ be/src/olap/rowset/segment_v2/column_writer.h | 1 + .../rowset/segment_v2/inverted_index_writer.cpp | 54 +++++++++ .../olap/rowset/segment_v2/inverted_index_writer.h | 4 + be/src/olap/task/index_builder.cpp | 27 +++++ be/src/olap/types.cpp | 23 ++-- be/src/vec/columns/column_array.h | 9 +- be/src/vec/olap/olap_data_convertor.cpp | 66 ++++------- be/src/vec/olap/olap_data_convertor.h | 20 +++- .../data/external_table_p0/tvf/comp_arr.orc | Bin 0 -> 49148 bytes .../data/external_table_p0/tvf/comp_arr.parquet | Bin 0 -> 45066 bytes ...ocal_tvf_with_complex_type_insertinto_doris.out | 126 +++++++++++++++++++++ ...l_tvf_with_complex_type_insertinto_doris.groovy | 76 ++++++++++++- 14 files changed, 364 insertions(+), 112 deletions(-) diff --git a/be/src/olap/rowset/segment_v2/column_reader.cpp b/be/src/olap/rowset/segment_v2/column_reader.cpp index ae823d76ba..5afdfe6285 100644 --- a/be/src/olap/rowset/segment_v2/column_reader.cpp +++ b/be/src/olap/rowset/segment_v2/column_reader.cpp @@ -822,6 +822,7 @@ Status OffsetFileColumnIterator::_calculate_offsets( auto& offsets_data = column_offsets.get_data(); ordinal_t first_column_offset = offsets_data[start - 1]; // -1 is valid ordinal_t first_storage_offset = offsets_data[start]; + DCHECK(next_storage_offset >= first_storage_offset); for (ssize_t i = start; i < offsets_data.size() - 1; ++i) { offsets_data[i] = first_column_offset + (offsets_data[i + 1] - first_storage_offset); } diff --git a/be/src/olap/rowset/segment_v2/column_writer.cpp b/be/src/olap/rowset/segment_v2/column_writer.cpp index 2f27df779b..ec2baa10f0 100644 --- a/be/src/olap/rowset/segment_v2/column_writer.cpp +++ b/be/src/olap/rowset/segment_v2/column_writer.cpp @@ -905,49 +905,34 @@ size_t ArrayColumnWriter::get_inverted_index_size() { return 0; } -// Now we can only write data one by one. +// batch append data for array Status ArrayColumnWriter::append_data(const uint8_t** ptr, size_t num_rows) { - size_t remaining = num_rows; - const auto* col_cursor = reinterpret_cast<const CollectionValue*>(*ptr); - while (remaining > 0) { - // TODO llj: bulk write - size_t num_written = 1; - ordinal_t next_item_ordinal = _item_writer->get_next_rowid(); - RETURN_IF_ERROR(_offset_writer->append_data_in_current_page( - reinterpret_cast<uint8_t*>(&next_item_ordinal), &num_written)); - if (num_written < - 1) { // page is full, write first item offset and update current length page's start ordinal - RETURN_IF_ERROR(_offset_writer->finish_current_page()); - } else { - // write child item. - if (_item_writer->is_nullable()) { - auto* item_data_ptr = const_cast<CollectionValue*>(col_cursor)->mutable_data(); - for (size_t i = 0; i < col_cursor->length(); ++i) { - RETURN_IF_ERROR(_item_writer->append(col_cursor->is_null_at(i), item_data_ptr)); - item_data_ptr = (uint8_t*)item_data_ptr + _item_writer->get_field()->size(); - } - } else { - const void* data = col_cursor->data(); - RETURN_IF_ERROR(_item_writer->append_data(reinterpret_cast<const uint8_t**>(&data), - col_cursor->length())); - } - if (_opts.inverted_index) { - auto writer = dynamic_cast<ScalarColumnWriter*>(_item_writer.get()); - if (writer != nullptr) { - //NOTE: use array field name as index field, but item_writer size should be used when moving item_data_ptr - RETURN_IF_ERROR(_inverted_index_builder->add_array_values( - _item_writer->get_field()->size(), col_cursor, 1)); - } + // data_ptr contains + // [size, offset_ptr, item_data_ptr, item_nullmap_ptr] + auto data_ptr = reinterpret_cast<const uint64_t*>(*ptr); + // total number length + size_t element_cnt = size_t((unsigned long)(*data_ptr)); + auto offset_data = *(data_ptr + 1); + const uint8_t* offsets_ptr = (const uint8_t*)offset_data; + + if (element_cnt > 0) { + auto data = *(data_ptr + 2); + auto nested_null_map = *(data_ptr + 3); + RETURN_IF_ERROR(_item_writer->append(reinterpret_cast<const uint8_t*>(nested_null_map), + reinterpret_cast<const void*>(data), element_cnt)); + if (_opts.inverted_index) { + auto writer = dynamic_cast<ScalarColumnWriter*>(_item_writer.get()); + // now only support nested type is scala + if (writer != nullptr) { + //NOTE: use array field name as index field, but item_writer size should be used when moving item_data_ptr + _inverted_index_builder->add_array_values( + _item_writer->get_field()->size(), reinterpret_cast<const void*>(data), + reinterpret_cast<const uint8_t*>(nested_null_map), offsets_ptr, num_rows); } } - remaining -= num_written; - col_cursor += num_written; - *ptr += num_written * sizeof(CollectionValue); } - if (is_nullable()) { - return write_null_column(num_rows, false); - } + RETURN_IF_ERROR(_offset_writer->append_data(&offsets_ptr, num_rows)); return Status::OK(); } @@ -957,6 +942,14 @@ uint64_t ArrayColumnWriter::estimate_buffer_size() { _item_writer->estimate_buffer_size(); } +Status ArrayColumnWriter::append_nullable(const uint8_t* null_map, const uint8_t** ptr, + size_t num_rows) { + RETURN_IF_ERROR(append_data(ptr, num_rows)); + if (is_nullable()) { + RETURN_IF_ERROR(_null_writer->append_data(&null_map, num_rows)); + } + return Status::OK(); +} Status ArrayColumnWriter::finish() { RETURN_IF_ERROR(_offset_writer->finish()); if (is_nullable()) { diff --git a/be/src/olap/rowset/segment_v2/column_writer.h b/be/src/olap/rowset/segment_v2/column_writer.h index 120432c3bb..b5aabd4e3a 100644 --- a/be/src/olap/rowset/segment_v2/column_writer.h +++ b/be/src/olap/rowset/segment_v2/column_writer.h @@ -345,6 +345,7 @@ public: Status write_data() override; Status write_ordinal_index() override; Status append_nulls(size_t num_rows) override; + Status append_nullable(const uint8_t* null_map, const uint8_t** ptr, size_t num_rows) override; Status finish_current_page() override; diff --git a/be/src/olap/rowset/segment_v2/inverted_index_writer.cpp b/be/src/olap/rowset/segment_v2/inverted_index_writer.cpp index e779170d03..2194d349a9 100644 --- a/be/src/olap/rowset/segment_v2/inverted_index_writer.cpp +++ b/be/src/olap/rowset/segment_v2/inverted_index_writer.cpp @@ -282,6 +282,60 @@ public: return Status::OK(); } + Status add_array_values(size_t field_size, const void* value_ptr, const uint8_t* null_map, + const uint8_t* offsets_ptr, size_t count) override { + if (count == 0) { + // no values to add inverted index + return Status::OK(); + } + auto offsets = reinterpret_cast<const uint64_t*>(offsets_ptr); + if constexpr (field_is_slice_type(field_type)) { + if (_field == nullptr || _index_writer == nullptr) { + LOG(ERROR) << "field or index writer is null in inverted index writer."; + return Status::InternalError( + "field or index writer is null in inverted index writer"); + } + for (int i = 0; i < count; ++i) { + // offsets[i+1] is now row element count + std::vector<std::string> strings; + // [0, 3, 6] + // [10,20,30] [20,30,40], [30,40,50] + auto start_off = offsets[i]; + auto end_off = offsets[i + 1]; + for (auto j = start_off; j < end_off; ++j) { + if (null_map[j] == 1) { + continue; + } + auto* v = (Slice*)((const uint8_t*)value_ptr + j * field_size); + strings.emplace_back(std::string(v->get_data(), v->get_size())); + } + + auto value = join(strings, " "); + new_fulltext_field(value.c_str(), value.length()); + _rid++; + _index_writer->addDocument(_doc.get()); + } + } else if constexpr (field_is_numeric_type(field_type)) { + for (int i = 0; i < count; ++i) { + auto start_off = offsets[i]; + auto end_off = offsets[i + 1]; + for (size_t j = start_off; j < end_off; ++j) { + if (null_map[j] == 1) { + continue; + } + const CppType* p = &reinterpret_cast<const CppType*>(value_ptr)[j]; + std::string new_value; + size_t value_length = sizeof(CppType); + + _value_key_coder->full_encode_ascending(p, &new_value); + _bkd_writer->add((const uint8_t*)new_value.c_str(), value_length, _rid); + } + _row_ids_seen_for_bkd++; + _rid++; + } + } + return Status::OK(); + } Status add_array_values(size_t field_size, const CollectionValue* values, size_t count) override { if constexpr (field_is_slice_type(field_type)) { diff --git a/be/src/olap/rowset/segment_v2/inverted_index_writer.h b/be/src/olap/rowset/segment_v2/inverted_index_writer.h index 6099f1d373..f9bce40640 100644 --- a/be/src/olap/rowset/segment_v2/inverted_index_writer.h +++ b/be/src/olap/rowset/segment_v2/inverted_index_writer.h @@ -48,6 +48,10 @@ public: virtual Status add_array_values(size_t field_size, const CollectionValue* values, size_t count) = 0; + virtual Status add_array_values(size_t field_size, const void* value_ptr, + const uint8_t* null_map, const uint8_t* offsets_ptr, + size_t count) = 0; + virtual Status add_nulls(uint32_t count) = 0; virtual Status finish() = 0; diff --git a/be/src/olap/task/index_builder.cpp b/be/src/olap/task/index_builder.cpp index 90aeedd931..ade62fdd28 100644 --- a/be/src/olap/task/index_builder.cpp +++ b/be/src/olap/task/index_builder.cpp @@ -298,6 +298,33 @@ Status IndexBuilder::_add_nullable(const std::string& column_name, } return step; }; + if (field->type() == FieldType::OLAP_FIELD_TYPE_ARRAY) { + DCHECK(field->get_sub_field_count() == 1); + BitmapIterator null_iter(null_map, num_rows); + bool is_null = false; + size_t this_run = 0; + while ((this_run = null_iter.Next(&is_null)) > 0) { + if (is_null) { + RETURN_IF_ERROR(_inverted_index_builders[index_writer_sign]->add_nulls(this_run)); + } else { + // [size, offset_ptr, item_data_ptr, item_nullmap_ptr] + auto data_ptr = reinterpret_cast<const uint64_t*>(*ptr); + // total number length + size_t element_cnt = size_t((unsigned long)(*data_ptr)); + auto offset_data = *(data_ptr + 1); + const uint8_t* offsets_ptr = (const uint8_t*)offset_data; + if (element_cnt > 0) { + auto data = *(data_ptr + 2); + auto nested_null_map = *(data_ptr + 3); + RETURN_IF_ERROR(_inverted_index_builders[index_writer_sign]->add_array_values( + field->get_sub_field(0)->size(), reinterpret_cast<const void*>(data), + reinterpret_cast<const uint8_t*>(nested_null_map), offsets_ptr, + num_rows)); + } + } + } + return Status::OK(); + } try { do { diff --git a/be/src/olap/types.cpp b/be/src/olap/types.cpp index e179e59b18..8149dfc832 100644 --- a/be/src/olap/types.cpp +++ b/be/src/olap/types.cpp @@ -200,14 +200,10 @@ TypeInfoPtr get_type_info(segment_v2::ColumnMetaPB* column_meta_pb) { } return create_dynamic_type_info_ptr(get_struct_type_info(field_types)); } else if (UNLIKELY(type == FieldType::OLAP_FIELD_TYPE_ARRAY)) { - int32_t iterations = 0; - const auto* child_column = &column_meta_pb->children_columns(0); - while (child_column->type() == int(FieldType::OLAP_FIELD_TYPE_ARRAY)) { - iterations++; - child_column = &child_column->children_columns(0); - } - return create_static_type_info_ptr( - get_array_type_info((FieldType)child_column->type(), iterations)); + segment_v2::ColumnMetaPB child_column = column_meta_pb->children_columns(0); + TypeInfoPtr child_info = get_type_info(&child_column); + ArrayTypeInfo* array_type_info = new ArrayTypeInfo(std::move(child_info)); + return create_dynamic_type_info_ptr(array_type_info); } else if (UNLIKELY(type == FieldType::OLAP_FIELD_TYPE_MAP)) { segment_v2::ColumnMetaPB key_meta = column_meta_pb->children_columns(0); TypeInfoPtr key_type_info = get_type_info(&key_meta); @@ -216,7 +212,7 @@ TypeInfoPtr get_type_info(segment_v2::ColumnMetaPB* column_meta_pb) { MapTypeInfo* map_type_info = new MapTypeInfo(std::move(key_type_info), std::move(value_type_info)); - return create_static_type_info_ptr(map_type_info); + return create_dynamic_type_info_ptr(map_type_info); } else { return create_static_type_info_ptr(get_scalar_type_info(type)); } @@ -249,13 +245,10 @@ TypeInfoPtr get_type_info(const TabletColumn* col) { } return create_dynamic_type_info_ptr(get_struct_type_info(field_types)); } else if (UNLIKELY(type == FieldType::OLAP_FIELD_TYPE_ARRAY)) { - int32_t iterations = 0; const auto* child_column = &col->get_sub_column(0); - while (child_column->type() == FieldType::OLAP_FIELD_TYPE_ARRAY) { - iterations++; - child_column = &child_column->get_sub_column(0); - } - return create_static_type_info_ptr(get_array_type_info(child_column->type(), iterations)); + TypeInfoPtr item_type = get_type_info(child_column); + ArrayTypeInfo* array_type_info = new ArrayTypeInfo(std::move(item_type)); + return create_dynamic_type_info_ptr(array_type_info); } else if (UNLIKELY(type == FieldType::OLAP_FIELD_TYPE_MAP)) { const auto* key_column = &col->get_sub_column(0); TypeInfoPtr key_type = get_type_info(key_column); diff --git a/be/src/vec/columns/column_array.h b/be/src/vec/columns/column_array.h index 18bdc74bc1..b42800d5b2 100644 --- a/be/src/vec/columns/column_array.h +++ b/be/src/vec/columns/column_array.h @@ -210,6 +210,10 @@ public: return scatter_impl<ColumnArray>(num_columns, selector); } + size_t ALWAYS_INLINE offset_at(ssize_t i) const { return get_offsets()[i - 1]; } + size_t ALWAYS_INLINE size_at(ssize_t i) const { + return get_offsets()[i] - get_offsets()[i - 1]; + } void append_data_by_selector(MutableColumnPtr& res, const IColumn::Selector& selector) const override { return append_data_by_selector_impl<ColumnArray>(res, selector); @@ -258,11 +262,6 @@ private: WrappedPtr data; WrappedPtr offsets; - size_t ALWAYS_INLINE offset_at(ssize_t i) const { return get_offsets()[i - 1]; } - size_t ALWAYS_INLINE size_at(ssize_t i) const { - return get_offsets()[i] - get_offsets()[i - 1]; - } - /// Multiply values if the nested column is ColumnVector<T>. template <typename T> ColumnPtr replicate_number(const IColumn::Offsets& replicate_offsets) const; diff --git a/be/src/vec/olap/olap_data_convertor.cpp b/be/src/vec/olap/olap_data_convertor.cpp index b28bdc76f8..181f1cd477 100644 --- a/be/src/vec/olap/olap_data_convertor.cpp +++ b/be/src/vec/olap/olap_data_convertor.cpp @@ -931,58 +931,34 @@ Status OlapBlockDataConvertor::OlapColumnDataConvertorArray::convert_to_olap() { assert(column_array); assert(data_type_array); - return convert_to_olap(_nullmap, column_array, data_type_array); + return convert_to_olap(column_array, data_type_array); } Status OlapBlockDataConvertor::OlapColumnDataConvertorArray::convert_to_olap( - const UInt8* null_map, const ColumnArray* column_array, - const DataTypeArray* data_type_array) { - const UInt8* item_null_map = nullptr; + const ColumnArray* column_array, const DataTypeArray* data_type_array) { ColumnPtr item_data = column_array->get_data_ptr(); - if (column_array->get_data().is_nullable()) { - const auto& data_nullable_column = - assert_cast<const ColumnNullable&>(column_array->get_data()); - item_null_map = data_nullable_column.get_null_map_data().data(); - item_data = data_nullable_column.get_nested_column_ptr(); - } - - const auto& offsets = column_array->get_offsets(); - int64_t start_index = _row_pos - 1; - int64_t end_index = _row_pos + _num_rows - 1; - auto start = offsets[start_index]; - auto size = offsets[end_index] - start; - - ColumnWithTypeAndName item_typed_column = { - item_data, remove_nullable(data_type_array->get_nested_type()), ""}; - _item_convertor->set_source_column(item_typed_column, start, size); - RETURN_IF_ERROR(_item_convertor->convert_to_olap()); - - CollectionValue* collection_value = _values.data(); - for (size_t i = 0; i < _num_rows; ++i, ++collection_value) { - int64_t cur_pos = _row_pos + i; - int64_t prev_pos = cur_pos - 1; - if (_nullmap && _nullmap[cur_pos]) { - continue; - } - auto offset = offsets[prev_pos]; - auto size = offsets[cur_pos] - offsets[prev_pos]; - new (collection_value) CollectionValue(size); - if (size == 0) { - continue; - } + auto start_offset = column_array->offset_at(_row_pos); + auto end_offset = column_array->offset_at(_row_pos + _num_rows); + auto elem_size = end_offset - start_offset; - if (column_array->get_data().is_nullable()) { - collection_value->set_has_null(true); - collection_value->set_null_signs( - const_cast<bool*>(reinterpret_cast<const bool*>(item_null_map + offset))); - } - // get_data_at should use offset - offsets[start_index] since - // start_index may be changed after OlapColumnDataConvertorArray::set_source_column. - // Using just offset may access the memory out of _item_convertor's data range, - collection_value->set_data( - const_cast<void*>(_item_convertor->get_data_at(offset - offsets[start_index]))); + _offsets.clear(); + _offsets.reserve(_num_rows + 1); + for (int i = 0; i <= _num_rows; ++i) { + _offsets.push_back(column_array->offset_at(i + _row_pos) - start_offset + _base_offset); } + + _base_offset += elem_size; + + ColumnWithTypeAndName item_typed_column = {item_data, data_type_array->get_nested_type(), + "array.item"}; + _item_convertor->set_source_column(item_typed_column, start_offset, elem_size); + RETURN_IF_ERROR(_item_convertor->convert_to_olap()); + + _results[0] = (void*)elem_size; + _results[1] = _offsets.data(); + _results[2] = _item_convertor->get_data(); + _results[3] = _item_convertor->get_nullmap(); return Status::OK(); } diff --git a/be/src/vec/olap/olap_data_convertor.h b/be/src/vec/olap/olap_data_convertor.h index 320e31fa52..3f8e0d497f 100644 --- a/be/src/vec/olap/olap_data_convertor.h +++ b/be/src/vec/olap/olap_data_convertor.h @@ -429,18 +429,30 @@ private: std::vector<const void*> _results; }; - class OlapColumnDataConvertorArray - : public OlapColumnDataConvertorPaddedPODArray<CollectionValue> { + class OlapColumnDataConvertorArray : public OlapColumnDataConvertorBase { public: OlapColumnDataConvertorArray(OlapColumnDataConvertorBaseUPtr item_convertor) - : _item_convertor(std::move(item_convertor)) {} + : _item_convertor(std::move(item_convertor)) { + _base_offset = 0; + _results.resize(4); // size + offset + item_data + item_nullmap + } + const void* get_data() const override { return _results.data(); }; + const void* get_data_at(size_t offset) const override { + LOG(FATAL) << "now not support get_data_at for OlapColumnDataConvertorArray"; + }; Status convert_to_olap() override; private: - Status convert_to_olap(const UInt8* null_map, const ColumnArray* column_array, + // Status convert_to_olap(const UInt8* null_map, const ColumnArray* column_array, + // const DataTypeArray* data_type_array); + Status convert_to_olap(const ColumnArray* column_array, const DataTypeArray* data_type_array); OlapColumnDataConvertorBaseUPtr _item_convertor; + UInt64 _base_offset; + PaddedPODArray<UInt64> _offsets; // array offsets in disk layout + // size + offsets_data + item_data + item_nullmap + std::vector<const void*> _results; }; class OlapColumnDataConvertorMap : public OlapColumnDataConvertorBase { diff --git a/regression-test/data/external_table_p0/tvf/comp_arr.orc b/regression-test/data/external_table_p0/tvf/comp_arr.orc new file mode 100644 index 0000000000..d264c01089 Binary files /dev/null and b/regression-test/data/external_table_p0/tvf/comp_arr.orc differ diff --git a/regression-test/data/external_table_p0/tvf/comp_arr.parquet b/regression-test/data/external_table_p0/tvf/comp_arr.parquet new file mode 100644 index 0000000000..903f393e76 Binary files /dev/null and b/regression-test/data/external_table_p0/tvf/comp_arr.parquet differ diff --git a/regression-test/data/external_table_p0/tvf/test_local_tvf_with_complex_type_insertinto_doris.out b/regression-test/data/external_table_p0/tvf/test_local_tvf_with_complex_type_insertinto_doris.out index 932b27b65c..ee106e32c8 100644 --- a/regression-test/data/external_table_p0/tvf/test_local_tvf_with_complex_type_insertinto_doris.out +++ b/regression-test/data/external_table_p0/tvf/test_local_tvf_with_complex_type_insertinto_doris.out @@ -78,3 +78,129 @@ -- !sql -- 0 +-- !sql -- +0 + +-- !sql_orc_tvf -- +0 [[0.075146018909447831, 0.83184654292916682, 0.48344758887617112, 0.73818042587686938, 0.1157914153224413, 0.010906227661216183, 0.14399412358433106, 0.44089849151182114, 0.57355556205718361, 0.25312517135856316, 0.38150647140194149, 0.070397728596659159, 0.86953536344447424, 0.68971873285317431, 0.43295999037537725, 0.6784883106064814, 0.59748020017550263, 0.701551888426747, 0.59172895985772778, 0.34453720788885822, 0.87415544636692688, 0.32542734889457547, 0.15307756621895752, 0.5967 [...] +1 [[0.36347909454423355, 0.41846626684948152, 0.079114592175514309, 0.66786028640635076, 0.3937097712237253, 0.789970132134358, 0.76656970664847057, 0.33365439648974671, 0.82537818944612018, 0.67177137061591408, 0.27802211322330717, 0.30797446380318649, 0.48919046879622785, 0.026597605734909657, 0.86028930790459013, 0.59862131876428393, 0.63368577900374445, 0.5431679589950682, 0.65036371203785692, 0.44948614963712841, 0.28018625320876811, 0.51570991706205271, 0.025688287032002211, 0.7626 [...] +2 [[0.877221380588093, 0.34747559807707384, 0.3675645915876965, 0.52652201116175712, 0.72002970080866924, 0.56105762000298276, 0.0643113918615007, 0.24286385119102094, 0.93193769482862376, 0.73982672018891238, 0.32241219536777865, 0.23776429755650352, 0.34347912299009942, 0.088746649808589928, 0.87220220991248354, 0.39688406891819517, 0.78830357499627624, 0.14570546857506361, 0.76341782137652059, 0.80827256407163572, 0.26071189588204635, 0.0510259473418454, 0.547961177300181, 0.267102459 [...] +3 [[0.20833707059306106, 0.26596035255300954, 0.63563007761753176, 0.85541770480854418, 0.40115034778714709, 0.9412613207041074, 0.8295909849011508, 0.48000303149949053, 0.6118879191280987, 0.67759497996881635, 0.92409526089492067, 0.84484713127582289, 0.652624205322621, 0.055773066161040386, 0.51631413723903052, 0.70729443705654438, 0.90360969475785524, 0.17993538649176455, 0.94139391471764133, 0.70606291612943428, 0.26768973741783764, 0.39085624648091366, 0.9210279883272956, 0.99311846 [...] +4 [[0.047413350785556418, 0.86115446017354413, 0.52746594712888129, 0.7928220552172901, 0.378383677779879, 0.25869150807878805, 0.881336384872182, 0.43190601429121023, 0.34821786760165918, 0.60939011573389446, 0.57890524957964584, 0.12655679055526281, 0.98326350849592081, 0.4114752881455106, 0.71029502619961726, 0.17406205968209665, 0.4567325446056, 0.90624922448958, 0.375303240937634, 0.0988566852627778, 0.84170079910912943, 0.50945581118823879, 0.45747093315733334, 0.23290494502014036, [...] +5 [[0.81747151151055641, 0.24284083030137293, 0.27264751674096122, 0.68978250796757046, 0.56872724536845309, 0.51449315531515172, 0.053685801305193293, 0.76384965769711222, 0.86742444325808721, 0.17708620392635666, 0.20158720516586492, 0.35341653336535162, 0.37768603540715184, 0.30457216383931474, 0.070651854062912967, 0.66214881379723012, 0.43993158671841415, 0.088312991072720948, 0.55867249478793035, 0.18247298075352136, 0.4324783236970281, 0.1916294092482187, 0.16741542850851077, 0.56 [...] +6 [[0.49869616208884693, 0.55144328654490093, 0.55377729558377009, 0.843431335623911, 0.23244546292038359, 0.911558929830448, 0.49086859023363205, 0.36226223621326314, 0.54370221709055011, 0.22534341652795797, 0.49156762889164018, 0.20495232148794884, 0.44319301722603754, 0.050935552057056244, 0.010168390659369475, 0.28971929477372882, 0.05303204383731619, 0.59729213564733585, 0.21790173337764662, 0.31804983072212933, 0.28812816272877129, 0.86135508638390645, 0.24114369881772757, 0.78738 [...] +7 [[0.3885403004999336, 0.21153443164602725, 0.774279829955582, 0.38300482760961596, 0.43857021473500191, 0.88092208170327913, 0.14180047588093558, 0.71370370179496323, 0.83883388286883254, 0.52333036388707044, 0.64084484459061042, 0.54292690901596208, 0.2899485418945652, 0.24037804499810822, 0.76035846082846215, 0.75291951810081237, 0.15291184942847336, 0.24087319912159233, 0.95160123771273963, 0.58102582686639259, 0.7747184978237498, 0.2966266705076781, 0.55845907896814639, 0.587260205 [...] +8 [[0.23095541823576282, 0.98566778149208711, 0.27275395790578771, 0.75873731923951637, 0.10028729285478444, 0.2559464736048801, 0.28772272775550967, 0.56837815230575883, 0.051161029724324347, 0.13892752805400266, 0.51868974612042618, 0.69435764187724835, 0.883427089389327, 0.69140808027836886, 0.60124850508041028, 0.68588072061700966, 0.91656529819741051, 0.30389467847111196, 0.26237596645547145, 0.994322553771555, 0.10300189155805217, 0.87802175788641978, 0.82823553626372082, 0.4557048 [...] +9 [[0.91932272657574032, 0.59023435137531011, 0.30619619687349853, 0.28849927487716132, 0.45352772432874588, 0.24655194318598372, 0.95006171941862294, 0.52677970703670773, 0.19017305345088664, 0.94864324630010666, 0.79828419865008893, 0.72078967469593136, 0.067926954216678492, 0.57003409487722867, 0.77364650920928346, 0.463415345503996, 0.24460360017602911, 0.2250260541917487, 0.23004676483632003, 0.45501787461780463, 0.78118117224476591, 0.61428816933442332, 0.891863056142934, 0.3481805 [...] +10 [[0.68383567150442692, 0.46201676716472917, 0.69037292452019283, 0.99961567844927268, 0.16449502791842407, 0.27555905654926693, 0.15235547393011295, 0.11476967209432909, 0.068832990208895661, 0.8439681913099778, 0.20260637712199403, 0.55626934703922992, 0.089663151057897017, 0.095733193192900523, 0.660586309210131, 0.0042917259839827526, 0.71207824643690554, 0.9046762692928767, 0.41447050633200266, 0.628729432515436, 0.86259477503332715, 0.248023107143737, 0.36614670864997423, 0.69587 [...] +11 [[0.9486624071469375, 0.45111107550701379, 0.34166552478450252, 0.075296801657753654, 0.91907102480777458, 0.96539452643299128, 0.793899676066837, 0.33109932125166563, 0.34468953382531931, 0.087876614564969757, 0.76920181976769408, 0.90334077262058576, 0.77523257013270075, 0.84896407360246118, 0.44543268511641465, 0.5027209394872445, 0.31382080405006485, 0.43233751686839339, 0.72352293042907212, 0.86615406904184356, 0.64213325871723559, 0.14347875353396433, 0.79003470918577223, 0.9210 [...] +12 [[0.058173649168726693, 0.551773880729322, 0.57321059200671853, 0.26016350610151662, 0.1574344683181309, 0.26284302217925104, 0.044477789530217415, 0.28580780548348328, 0.30861084862821653, 0.5164106170109144, 0.93623389406263968, 0.36984161172004326, 0.72020196597094288, 0.44918890774554188, 0.13904099897852906, 0.083955447505741132, 0.41689989968855878, 0.87366108406305443, 0.22879438213432668, 0.7782130160230053, 0.13749845911267267, 0.39231303237113857, 0.58211536755929838, 0.2901 [...] +13 [[0.089452985160848875, 0.24145592288378026, 0.91129120931446017, 0.13296414413215685, 0.0741821651267025, 0.23983795296183663, 0.83049738874378731, 0.29733913780505616, 0.62421994936966962, 0.37564059775751446, 0.10746463385204752, 0.23260767634931867, 0.550333181036779, 0.62262675190154826, 0.58639853676548848, 0.27594914860221353, 0.8491383732091321, 0.97641469307579987, 0.26025381674438552, 0.1320540318911203, 0.80733606326079155, 0.1765676030816814, 0.077226223567426366, 0.111806 [...] +14 [[0.63221100020486043, 0.66419100187251068, 0.54223407509079147, 0.55614475388159912, 0.62567698285273765, 0.14408921908249051, 0.56632600009444878, 0.98746156764645143, 0.3248061233757219, 0.40763405487584814, 0.958919854781932, 0.88413941373312155, 0.86763180024487319, 0.060569617157883893, 0.15713202624220213, 0.18452066167354397, 0.58431245652517017, 0.94655573283297623, 0.22745176644958731, 0.4239152598710878, 0.15127906689835824, 0.63753249863689077, 0.874850393117698, 0.6983544 [...] +15 [[0.63885556051479053, 0.74535962205844652, 0.67486103922792462, 0.17793005475060286, 0.59375151527306469, 0.12581600279247906, 0.28116095067089286, 0.51338990857530142, 0.72721199812358517, 0.694769409584071, 0.98388721809677948, 0.61233900076897285, 0.81083138973737268, 0.3419476586429343, 0.28120160344629874, 0.38455139677956807, 0.63223240609624642, 0.842531471683803, 0.24496461148998405, 0.035380584800178805, 0.50866799829363474, 0.54379505313084409, 0.85556767354120733, 0.331446 [...] +16 [[0.88314255956027632, 0.79571874738813719, 0.97614372903888258, 0.37526204580470068, 0.494410856072649, 0.18558609496466283, 0.53527235841937837, 0.5038418765180156, 0.11777341444796707, 0.52338620845911255, 0.43109683101318719, 0.580587279361151, 0.75325940279621928, 0.135287423037333, 0.085888492946933792, 0.073282267922493816, 0.68090685035952847, 0.41301815871956771, 0.027978199771674928, 0.90885506087912049, 0.90747424628037965, 0.737383184415786, 0.0005222574143753933, 0.772240 [...] +17 [[0.88177831777895144, 0.38759617346917141, 0.11526365564396113, 0.72043868520836585, 0.61138479638383181, 0.9620115658850783, 0.0084347806470101983, 0.484256749062121, 0.095957799189622328, 0.50705669354063065, 0.28536282230644472, 0.031494876720769782, 0.29391281021556992, 0.88795459111977881, 0.091578864840146212, 0.28793303966902617, 0.96837305368696081, 0.920353399564873, 0.90675818334837543, 0.046597266979181429, 0.26320971953020911, 0.95490229999020537, 0.37673278661768461, 0.7 [...] +18 [[0.8092757084352763, 0.08992259457487628, 0.18569280785172559, 0.75611467712240266, 0.36377485165404111, 0.64078001567212739, 0.097821453818684456, 0.75786548388710884, 0.46809393371445174, 0.77916698053229594, 0.71831147668606887, 0.2558786610182906, 0.65143035479830069, 0.88448044626726907, 0.15510983657522392, 0.10539377936596794, 0.024019638386299502, 0.0038249526301865622, 0.0799957636382671, 0.69475784262231544, 0.01944506732524065, 0.04491472639605254, 0.24990754910401825, 0.2 [...] +19 [[0.19214938505481793, 0.1203246770444657, 0.22682061095121742, 0.60058123359852333, 0.41666223300525729, 0.10859332941909827, 0.46470160831520668, 0.86941153845249852, 0.45663333493050606, 0.51086711252431372, 0.50942562355559862, 0.89459441848345933, 0.41325362721123637, 0.381879330677928, 0.052761983830012515, 0.73072261693733631, 0.4855053961100595, 0.59134011258518315, 0.82286092628847052, 0.30720833022562843, 0.8581933488157647, 0.36446421974453491, 0.52815704589312573, 0.868864 [...] +20 [[0.22723015667366742, 0.40942309462872317, 0.28492576086201182, 0.79017305587450148, 0.24232704437415198, 0.11447196385870251, 0.38825996621023184, 0.43351441214718966, 0.14355702268519221, 0.24975457610358065, 0.91170638842166751, 0.49546179118897504, 0.72433415000646428, 0.20938732646353675, 0.57192029994015869, 0.33054049354602955, 0.54942672554174132, 0.70097306844279772, 0.228089286079883, 0.76484567032571693, 0.33713079989145645, 0.67534215083811167, 0.57934412010664738, 0.1337 [...] +21 [[0.80210647334191454, 0.69884789048694707, 0.67325247016421774, 0.18647318626057185, 0.71527136491642729, 0.96996035465464525, 0.86410361218641141, 0.43629253812037783, 0.1343664366155537, 0.08933635028895226, 0.26242879032691524, 0.96754901252159808, 0.31618543964171286, 0.783798165587592, 0.95305384434963836, 0.547585035257943, 0.0026095191527407691, 0.81746370905381027, 0.7398086347834486, 0.33751581121472762, 0.38505421156561148, 0.68032046740996477, 0.1327005237291784, 0.1470213 [...] +22 [[0.33418430452769021, 0.1571443475012273, 0.87139187590553191, 0.763090618220186, 0.47775193122212678, 0.28389999727885518, 0.60928065723065294, 0.18254287191968643, 0.57947007579527943, 0.72593937626820182, 0.14287710926962827, 0.87271028812930207, 0.77124944454399147, 0.24053102139362426, 0.29016219903811691, 0.80315001498314653, 0.79098402862753814, 0.80971295720380854, 0.20572852915186635, 0.26142880150871572, 0.91710606956334417, 0.66677239944332367, 0.88713410049022545, 0.72340 [...] +23 [[0.21512619243621667, 0.81893079651557932, 0.98440744837687078, 0.53843802238875649, 0.18543355132489914, 0.0815671479746668, 0.35961220433253716, 0.61281807480648465, 0.66739946024083285, 0.78675272573864563, 0.24811238439506289, 0.30348528982686418, 0.30290214563319373, 0.6545970678746591, 0.37749638044505829, 0.72370899826241708, 0.52684526242281526, 0.6285903609383352, 0.89221266061764115, 0.19832330352680139, 0.9205528516890793, 0.11050075973282347, 0.29233630106450381, 0.513656 [...] +24 [[0.86425385615782824, 0.066358100833033951, 0.39543090643651169, 0.59218536318562942, 0.48110900493704556, 0.54672210075400984, 0.39615645246905495, 0.82739896249686617, 0.75606385877500171, 0.79976628493560875, 0.43599710181914531, 0.21265034900894442, 0.52263113184775356, 0.19236548383475505, 0.41860217344219808, 0.18425019002161425, 0.53446873982655274, 0.32346216208001077, 0.42438541143312536, 0.51941549065370329, 0.74634061707991017, 0.72185536105555681, 0.75598395945116814, 0.4 [...] + +-- !sql -- +25 + +-- !sql_orc_inner -- +0 [[0.075146018909447831, 0.83184654292916682, 0.48344758887617112, 0.73818042587686938, 0.1157914153224413, 0.010906227661216183, 0.14399412358433106, 0.44089849151182114, 0.57355556205718361, 0.25312517135856316, 0.38150647140194149, 0.070397728596659159, 0.86953536344447424, 0.68971873285317431, 0.43295999037537725, 0.6784883106064814, 0.59748020017550263, 0.701551888426747, 0.59172895985772778, 0.34453720788885822, 0.87415544636692688, 0.32542734889457547, 0.15307756621895752, 0.5967 [...] +1 [[0.36347909454423355, 0.41846626684948152, 0.079114592175514309, 0.66786028640635076, 0.3937097712237253, 0.789970132134358, 0.76656970664847057, 0.33365439648974671, 0.82537818944612018, 0.67177137061591408, 0.27802211322330717, 0.30797446380318649, 0.48919046879622785, 0.026597605734909657, 0.86028930790459013, 0.59862131876428393, 0.63368577900374445, 0.5431679589950682, 0.65036371203785692, 0.44948614963712841, 0.28018625320876811, 0.51570991706205271, 0.025688287032002211, 0.7626 [...] +2 [[0.877221380588093, 0.34747559807707384, 0.3675645915876965, 0.52652201116175712, 0.72002970080866924, 0.56105762000298276, 0.0643113918615007, 0.24286385119102094, 0.93193769482862376, 0.73982672018891238, 0.32241219536777865, 0.23776429755650352, 0.34347912299009942, 0.088746649808589928, 0.87220220991248354, 0.39688406891819517, 0.78830357499627624, 0.14570546857506361, 0.76341782137652059, 0.80827256407163572, 0.26071189588204635, 0.0510259473418454, 0.547961177300181, 0.267102459 [...] +3 [[0.20833707059306106, 0.26596035255300954, 0.63563007761753176, 0.85541770480854418, 0.40115034778714709, 0.9412613207041074, 0.8295909849011508, 0.48000303149949053, 0.6118879191280987, 0.67759497996881635, 0.92409526089492067, 0.84484713127582289, 0.652624205322621, 0.055773066161040386, 0.51631413723903052, 0.70729443705654438, 0.90360969475785524, 0.17993538649176455, 0.94139391471764133, 0.70606291612943428, 0.26768973741783764, 0.39085624648091366, 0.9210279883272956, 0.99311846 [...] +4 [[0.047413350785556418, 0.86115446017354413, 0.52746594712888129, 0.7928220552172901, 0.378383677779879, 0.25869150807878805, 0.881336384872182, 0.43190601429121023, 0.34821786760165918, 0.60939011573389446, 0.57890524957964584, 0.12655679055526281, 0.98326350849592081, 0.4114752881455106, 0.71029502619961726, 0.17406205968209665, 0.4567325446056, 0.90624922448958, 0.375303240937634, 0.0988566852627778, 0.84170079910912943, 0.50945581118823879, 0.45747093315733334, 0.23290494502014036, [...] +5 [[0.81747151151055641, 0.24284083030137293, 0.27264751674096122, 0.68978250796757046, 0.56872724536845309, 0.51449315531515172, 0.053685801305193293, 0.76384965769711222, 0.86742444325808721, 0.17708620392635666, 0.20158720516586492, 0.35341653336535162, 0.37768603540715184, 0.30457216383931474, 0.070651854062912967, 0.66214881379723012, 0.43993158671841415, 0.088312991072720948, 0.55867249478793035, 0.18247298075352136, 0.4324783236970281, 0.1916294092482187, 0.16741542850851077, 0.56 [...] +6 [[0.49869616208884693, 0.55144328654490093, 0.55377729558377009, 0.843431335623911, 0.23244546292038359, 0.911558929830448, 0.49086859023363205, 0.36226223621326314, 0.54370221709055011, 0.22534341652795797, 0.49156762889164018, 0.20495232148794884, 0.44319301722603754, 0.050935552057056244, 0.010168390659369475, 0.28971929477372882, 0.05303204383731619, 0.59729213564733585, 0.21790173337764662, 0.31804983072212933, 0.28812816272877129, 0.86135508638390645, 0.24114369881772757, 0.78738 [...] +7 [[0.3885403004999336, 0.21153443164602725, 0.774279829955582, 0.38300482760961596, 0.43857021473500191, 0.88092208170327913, 0.14180047588093558, 0.71370370179496323, 0.83883388286883254, 0.52333036388707044, 0.64084484459061042, 0.54292690901596208, 0.2899485418945652, 0.24037804499810822, 0.76035846082846215, 0.75291951810081237, 0.15291184942847336, 0.24087319912159233, 0.95160123771273963, 0.58102582686639259, 0.7747184978237498, 0.2966266705076781, 0.55845907896814639, 0.587260205 [...] +8 [[0.23095541823576282, 0.98566778149208711, 0.27275395790578771, 0.75873731923951637, 0.10028729285478444, 0.2559464736048801, 0.28772272775550967, 0.56837815230575883, 0.051161029724324347, 0.13892752805400266, 0.51868974612042618, 0.69435764187724835, 0.883427089389327, 0.69140808027836886, 0.60124850508041028, 0.68588072061700966, 0.91656529819741051, 0.30389467847111196, 0.26237596645547145, 0.994322553771555, 0.10300189155805217, 0.87802175788641978, 0.82823553626372082, 0.4557048 [...] +9 [[0.91932272657574032, 0.59023435137531011, 0.30619619687349853, 0.28849927487716132, 0.45352772432874588, 0.24655194318598372, 0.95006171941862294, 0.52677970703670773, 0.19017305345088664, 0.94864324630010666, 0.79828419865008893, 0.72078967469593136, 0.067926954216678492, 0.57003409487722867, 0.77364650920928346, 0.463415345503996, 0.24460360017602911, 0.2250260541917487, 0.23004676483632003, 0.45501787461780463, 0.78118117224476591, 0.61428816933442332, 0.891863056142934, 0.3481805 [...] +10 [[0.68383567150442692, 0.46201676716472917, 0.69037292452019283, 0.99961567844927268, 0.16449502791842407, 0.27555905654926693, 0.15235547393011295, 0.11476967209432909, 0.068832990208895661, 0.8439681913099778, 0.20260637712199403, 0.55626934703922992, 0.089663151057897017, 0.095733193192900523, 0.660586309210131, 0.0042917259839827526, 0.71207824643690554, 0.9046762692928767, 0.41447050633200266, 0.628729432515436, 0.86259477503332715, 0.248023107143737, 0.36614670864997423, 0.69587 [...] +11 [[0.9486624071469375, 0.45111107550701379, 0.34166552478450252, 0.075296801657753654, 0.91907102480777458, 0.96539452643299128, 0.793899676066837, 0.33109932125166563, 0.34468953382531931, 0.087876614564969757, 0.76920181976769408, 0.90334077262058576, 0.77523257013270075, 0.84896407360246118, 0.44543268511641465, 0.5027209394872445, 0.31382080405006485, 0.43233751686839339, 0.72352293042907212, 0.86615406904184356, 0.64213325871723559, 0.14347875353396433, 0.79003470918577223, 0.9210 [...] +12 [[0.058173649168726693, 0.551773880729322, 0.57321059200671853, 0.26016350610151662, 0.1574344683181309, 0.26284302217925104, 0.044477789530217415, 0.28580780548348328, 0.30861084862821653, 0.5164106170109144, 0.93623389406263968, 0.36984161172004326, 0.72020196597094288, 0.44918890774554188, 0.13904099897852906, 0.083955447505741132, 0.41689989968855878, 0.87366108406305443, 0.22879438213432668, 0.7782130160230053, 0.13749845911267267, 0.39231303237113857, 0.58211536755929838, 0.2901 [...] +13 [[0.089452985160848875, 0.24145592288378026, 0.91129120931446017, 0.13296414413215685, 0.0741821651267025, 0.23983795296183663, 0.83049738874378731, 0.29733913780505616, 0.62421994936966962, 0.37564059775751446, 0.10746463385204752, 0.23260767634931867, 0.550333181036779, 0.62262675190154826, 0.58639853676548848, 0.27594914860221353, 0.8491383732091321, 0.97641469307579987, 0.26025381674438552, 0.1320540318911203, 0.80733606326079155, 0.1765676030816814, 0.077226223567426366, 0.111806 [...] +14 [[0.63221100020486043, 0.66419100187251068, 0.54223407509079147, 0.55614475388159912, 0.62567698285273765, 0.14408921908249051, 0.56632600009444878, 0.98746156764645143, 0.3248061233757219, 0.40763405487584814, 0.958919854781932, 0.88413941373312155, 0.86763180024487319, 0.060569617157883893, 0.15713202624220213, 0.18452066167354397, 0.58431245652517017, 0.94655573283297623, 0.22745176644958731, 0.4239152598710878, 0.15127906689835824, 0.63753249863689077, 0.874850393117698, 0.6983544 [...] +15 [[0.63885556051479053, 0.74535962205844652, 0.67486103922792462, 0.17793005475060286, 0.59375151527306469, 0.12581600279247906, 0.28116095067089286, 0.51338990857530142, 0.72721199812358517, 0.694769409584071, 0.98388721809677948, 0.61233900076897285, 0.81083138973737268, 0.3419476586429343, 0.28120160344629874, 0.38455139677956807, 0.63223240609624642, 0.842531471683803, 0.24496461148998405, 0.035380584800178805, 0.50866799829363474, 0.54379505313084409, 0.85556767354120733, 0.331446 [...] +16 [[0.88314255956027632, 0.79571874738813719, 0.97614372903888258, 0.37526204580470068, 0.494410856072649, 0.18558609496466283, 0.53527235841937837, 0.5038418765180156, 0.11777341444796707, 0.52338620845911255, 0.43109683101318719, 0.580587279361151, 0.75325940279621928, 0.135287423037333, 0.085888492946933792, 0.073282267922493816, 0.68090685035952847, 0.41301815871956771, 0.027978199771674928, 0.90885506087912049, 0.90747424628037965, 0.737383184415786, 0.0005222574143753933, 0.772240 [...] +17 [[0.88177831777895144, 0.38759617346917141, 0.11526365564396113, 0.72043868520836585, 0.61138479638383181, 0.9620115658850783, 0.0084347806470101983, 0.484256749062121, 0.095957799189622328, 0.50705669354063065, 0.28536282230644472, 0.031494876720769782, 0.29391281021556992, 0.88795459111977881, 0.091578864840146212, 0.28793303966902617, 0.96837305368696081, 0.920353399564873, 0.90675818334837543, 0.046597266979181429, 0.26320971953020911, 0.95490229999020537, 0.37673278661768461, 0.7 [...] +18 [[0.8092757084352763, 0.08992259457487628, 0.18569280785172559, 0.75611467712240266, 0.36377485165404111, 0.64078001567212739, 0.097821453818684456, 0.75786548388710884, 0.46809393371445174, 0.77916698053229594, 0.71831147668606887, 0.2558786610182906, 0.65143035479830069, 0.88448044626726907, 0.15510983657522392, 0.10539377936596794, 0.024019638386299502, 0.0038249526301865622, 0.0799957636382671, 0.69475784262231544, 0.01944506732524065, 0.04491472639605254, 0.24990754910401825, 0.2 [...] +19 [[0.19214938505481793, 0.1203246770444657, 0.22682061095121742, 0.60058123359852333, 0.41666223300525729, 0.10859332941909827, 0.46470160831520668, 0.86941153845249852, 0.45663333493050606, 0.51086711252431372, 0.50942562355559862, 0.89459441848345933, 0.41325362721123637, 0.381879330677928, 0.052761983830012515, 0.73072261693733631, 0.4855053961100595, 0.59134011258518315, 0.82286092628847052, 0.30720833022562843, 0.8581933488157647, 0.36446421974453491, 0.52815704589312573, 0.868864 [...] +20 [[0.22723015667366742, 0.40942309462872317, 0.28492576086201182, 0.79017305587450148, 0.24232704437415198, 0.11447196385870251, 0.38825996621023184, 0.43351441214718966, 0.14355702268519221, 0.24975457610358065, 0.91170638842166751, 0.49546179118897504, 0.72433415000646428, 0.20938732646353675, 0.57192029994015869, 0.33054049354602955, 0.54942672554174132, 0.70097306844279772, 0.228089286079883, 0.76484567032571693, 0.33713079989145645, 0.67534215083811167, 0.57934412010664738, 0.1337 [...] +21 [[0.80210647334191454, 0.69884789048694707, 0.67325247016421774, 0.18647318626057185, 0.71527136491642729, 0.96996035465464525, 0.86410361218641141, 0.43629253812037783, 0.1343664366155537, 0.08933635028895226, 0.26242879032691524, 0.96754901252159808, 0.31618543964171286, 0.783798165587592, 0.95305384434963836, 0.547585035257943, 0.0026095191527407691, 0.81746370905381027, 0.7398086347834486, 0.33751581121472762, 0.38505421156561148, 0.68032046740996477, 0.1327005237291784, 0.1470213 [...] +22 [[0.33418430452769021, 0.1571443475012273, 0.87139187590553191, 0.763090618220186, 0.47775193122212678, 0.28389999727885518, 0.60928065723065294, 0.18254287191968643, 0.57947007579527943, 0.72593937626820182, 0.14287710926962827, 0.87271028812930207, 0.77124944454399147, 0.24053102139362426, 0.29016219903811691, 0.80315001498314653, 0.79098402862753814, 0.80971295720380854, 0.20572852915186635, 0.26142880150871572, 0.91710606956334417, 0.66677239944332367, 0.88713410049022545, 0.72340 [...] +23 [[0.21512619243621667, 0.81893079651557932, 0.98440744837687078, 0.53843802238875649, 0.18543355132489914, 0.0815671479746668, 0.35961220433253716, 0.61281807480648465, 0.66739946024083285, 0.78675272573864563, 0.24811238439506289, 0.30348528982686418, 0.30290214563319373, 0.6545970678746591, 0.37749638044505829, 0.72370899826241708, 0.52684526242281526, 0.6285903609383352, 0.89221266061764115, 0.19832330352680139, 0.9205528516890793, 0.11050075973282347, 0.29233630106450381, 0.513656 [...] +24 [[0.86425385615782824, 0.066358100833033951, 0.39543090643651169, 0.59218536318562942, 0.48110900493704556, 0.54672210075400984, 0.39615645246905495, 0.82739896249686617, 0.75606385877500171, 0.79976628493560875, 0.43599710181914531, 0.21265034900894442, 0.52263113184775356, 0.19236548383475505, 0.41860217344219808, 0.18425019002161425, 0.53446873982655274, 0.32346216208001077, 0.42438541143312536, 0.51941549065370329, 0.74634061707991017, 0.72185536105555681, 0.75598395945116814, 0.4 [...] + +-- !sql -- +0 + +-- !sql_parquet_tvf -- +0 [[0.2434200686509983, 0.24234602011681528, 0.64895448286354074, 0.80656526546697949, 0.33553233191049614, 0.93104045037487582, 0.46082051709757321, 0.53545409981555159, 0.11940161295457363, 0.50894827151143052, 0.82244549745752793, 0.6191370566860076, 0.33453321135998482, 0.075267042138438045, 0.40832636186584292, 0.19376042004217831, 0.46281496989081572, 0.54388378653102276, 0.39025393742796888, 0.39257363676724322, 0.70940372601174673, 0.89336874762060425, 0.35773689855687063, 0.4634 [...] +1 [[0.441213983188219, 0.11829553460573472, 0.33551661881638117, 0.15769240977086962, 0.039896571828509142, 0.84339289915401416, 0.29772970512610364, 0.68175512882934242, 0.13552490402879558, 0.73721186924123583, 0.94628908401158074, 0.71997162119921032, 0.804720529599055, 0.1151729366872013, 0.22392404886137851, 0.68585234720029475, 0.59439613229450683, 0.44486208624901169, 0.34252653767716268, 0.8562974946251527, 0.201746488817938, 0.45932588358867166, 0.1517964539013732, 0.74892856020 [...] +2 [[0.76900112854951785, 0.040707996366250665, 0.73040821209474038, 0.251174093959617, 0.71938437935301336, 0.90000184400502226, 0.29695811719826615, 0.77132447239782309, 0.3364963599585733, 0.22297486715776116, 0.69454649562099435, 0.9551249988985, 0.96884572098791266, 0.17347093634523736, 0.56434207544207449, 0.19757550008890767, 0.44749957994579836, 0.43964797103244158, 0.95970263505113274, 0.47711000474054077, 0.91446112100589083, 0.54755561537061559, 0.21819692563011628, 0.981575589 [...] +3 [[0.19201896280979724, 0.2277157594303113, 0.70696662663421062, 0.79613852089303372, 0.013154619183022187, 0.75111997454023149, 0.88382321644299544, 0.48943459157003355, 0.65226277171827529, 0.013413662629729872, 0.72326802798739775, 0.64237045403012538, 0.50375062994211028, 0.24899579433512853, 0.59781326778245125, 0.25528106793388783, 0.86173075992973081, 0.7486746409719387, 0.099299268038050448, 0.14850151396944167, 0.927790463055653, 0.0028725613850517639, 0.61728786534414593, 0.81 [...] +4 [[0.59645537235209667, 0.60470950911235721, 0.90236107510871155, 0.66714780095213988, 0.95683682493491606, 0.0084652348887768181, 0.44903257208378411, 0.08657419553688217, 0.17840048948389087, 0.024768644008877794, 0.90679260937660666, 0.090295817453005744, 0.81267474389430649, 0.53225725844427452, 0.026670213937739828, 0.38148239227264857, 0.79269793518267984, 0.17868443924478761, 0.97028447888209113, 0.1496567720548948, 0.868275994476362, 0.27988042656300116, 0.47835050846162352, 0.0 [...] +5 [[0.21999856488055747, 0.80106949963414387, 0.37888818235979371, 0.35621115078552767, 0.25905903110594364, 0.071486484085366175, 0.0873221357781595, 0.67747056809382589, 0.82675146444177572, 0.85778986301193283, 0.30961240678283997, 0.53293854613108982, 0.68386730354734, 0.7955796080221551, 0.78574708007062621, 0.28047617531729108, 0.020318084552748306, 0.311024599080163, 0.60445405220301629, 0.32359007828189013, 0.37264965333025513, 0.23379841929490885, 0.6143202190477125, 0.182057930 [...] +6 [[0.74898892346933432, 0.0772671311088804, 0.7484759208893712, 0.5151660040344227, 0.54793263204154052, 0.17860231571322482, 0.45191545547845136, 0.23965009227204648, 0.75616725349983827, 0.65085678938875624, 0.091046660666927348, 0.9603655949205443, 0.22065287928589716, 0.27452040044972426, 0.3514822877984074, 0.34117875302795775, 0.097458775756514959, 0.58830642952170442, 0.73846443555926278, 0.55919580552106707, 0.45037858572707812, 0.13647543794934003, 0.13255920726058945, 0.168716 [...] +7 [[0.81016551924298819, 0.034827311984228504, 0.42584577044060956, 0.65761719473752112, 0.015828067858713157, 0.77104072310432981, 0.32378500814571542, 0.96337227876248355, 0.72757792965145829, 0.5567974933569082, 0.36826830177176606, 0.38974273844483154, 0.57162102356777855, 0.058465386858290835, 0.91864498625008917, 0.31216011334835558, 0.6550489555175163, 0.625780920785453, 0.43187750880489983, 0.83676673245429811, 0.56779250439812456, 0.9354600086277306, 0.62236094937422193, 0.15691 [...] +8 [[0.68849776030513066, 0.3945690554217266, 0.23162958058849181, 0.43005636234695066, 0.957092602038879, 0.91948228885547245, 0.083245187680261234, 0.80924594123290727, 0.59254527549686764, 0.31581885385248487, 0.84179038061634559, 0.48676570699450628, 0.18799174598170176, 0.270641957952527, 0.36534699824927042, 0.60822004432697108, 0.7963198854238247, 0.762516297939034, 0.9005458459567709, 0.19884478242750259, 0.31919896294241079, 0.012712557276409853, 0.73024089460035913, 0.4025197810 [...] +9 [[0.10701536380206866, 0.25884977813910282, 0.7902525709347652, 0.4137897115249527, 0.27238753268880089, 0.54107578240098964, 0.86478988051687966, 0.20059459807190805, 0.33888160879667983, 0.719477324458027, 0.040571298808728229, 0.46250918638629723, 0.31847082537786509, 0.67561422690960515, 0.29156123431457415, 0.8061135009203203, 0.81202731508154768, 0.29049496589672441, 0.44043930814534304, 0.091635859114874707, 0.30524389711018063, 0.26375964174118882, 0.96917096610218034, 0.791492 [...] +10 [[0.046210800798201834, 0.19270931408029479, 0.031476592245683443, 0.8179910428536965, 0.80300002985709384, 0.374844428232911, 0.11473413378304687, 0.67074038967919913, 0.70269264562020894, 0.58458553043632022, 0.24137910691272157, 0.80798996757106778, 0.85186356535586361, 0.94555284981235721, 0.36073980750727719, 0.4308928939064961, 0.98812799047625011, 0.067403918230073523, 0.8970263709298717, 0.78300851419541506, 0.5158575887984499, 0.16702206238978623, 0.1543196468389032, 0.383260 [...] +11 [[0.65327432894692838, 0.32894198092623417, 0.9619307687845664, 0.99539125926505623, 0.53345764975478194, 0.86505853674749433, 0.18498367713182573, 0.11584283599472811, 0.19985143801523308, 0.022159199001309582, 0.606595360826325, 0.64825041300866781, 0.61877978755153007, 0.2018765340783063, 0.69951173647581022, 0.61528678466458853, 0.55314671839668983, 0.0642892129530197, 0.8654015226776085, 0.4606225640448115, 0.11353434062603562, 0.642277842163975, 0.13033174785619572, 0.9286040206 [...] +12 [[0.81185833049958844, 0.30666067502430072, 0.65538831497946615, 0.203106185079865, 0.00078869097953226941, 0.0031811868122340048, 0.265963761865172, 0.35560473239960733, 0.86359735984662778, 0.947279996928223, 0.21334787657408905, 0.86788450171151021, 0.22469454256582055, 0.60451736003698042, 0.97510032079053133, 0.39843263106573423, 0.94130813218741072, 0.0459891766655921, 0.1620075117346309, 0.64544667605197537, 0.67346080605993008, 0.12485844879470631, 0.66225160763659563, 0.74440 [...] +13 [[0.12030761117169952, 0.21550887718555545, 0.49410894070815692, 0.42143467974520266, 0.81946279547105316, 0.45846426055389233, 0.65712742631890353, 0.15314477366832269, 0.41528878608123254, 0.12911772418269263, 0.67926389722739877, 0.93346414159677027, 0.93520902500503, 0.15421306709632598, 0.4625297969625134, 0.59796307240740187, 0.64657805418685965, 0.49975378919957991, 0.95603621000037775, 0.59442924775666361, 0.014895576314810866, 0.24932905647433645, 0.8320104371213185, 0.004921 [...] +14 [[0.56756937645255057, 0.25931061792936327, 0.42232614384641554, 0.85459627004177552, 0.45020684777715936, 0.29767402545492538, 0.080229346108791177, 0.022898418006150334, 0.080332362797224555, 0.32680510799539164, 0.3650687261202672, 0.73586028167479645, 0.8973098989709124, 0.2578144961028338, 0.48980318727312011, 0.58474995051373668, 0.463153911850928, 0.011714371147868552, 0.43605207683782576, 0.63128663585656686, 0.066994296286058352, 0.60624375792077911, 0.030652471942043236, 0.6 [...] +15 [[0.65069461186175015, 0.72665034408710583, 0.77197434126543019, 0.40282943352113187, 0.64552393492322058, 0.765940755594443, 0.22553712288078731, 0.27967614535782626, 0.95223357133615949, 0.54526938922304757, 0.77496235494751209, 0.96470331564816869, 0.23770553340681233, 0.667868020195893, 0.71343109818229344, 0.59255155272705151, 0.15507542962345877, 0.35088308415654912, 0.46178941443891897, 0.24185122040952867, 0.35371780010244869, 0.47385360009386546, 0.69938190468420414, 0.044096 [...] +16 [[0.35441253712880016, 0.74230695184923845, 0.403537363109042, 0.41356457856567996, 0.069869469799674011, 0.26499751959177964, 0.26997623778465574, 0.68996237650176429, 0.68746833941028807, 0.91859472331559722, 0.92932073879157817, 0.68144804533134318, 0.30166772591661484, 0.3655925371376133, 0.33436780641007413, 0.73591415210585975, 0.40855237634638375, 0.70179921551863145, 0.67963263037462351, 0.5740227195464046, 0.23769397114716284, 0.55289746325245326, 0.92133186037084069, 0.73162 [...] +17 [[0.97116668791348648, 0.47225829864239022, 0.48518800874288348, 0.12778390066476486, 0.66738280266453376, 0.69756208231553318, 0.58691193681800757, 0.83726240370669713, 0.6342386538366106, 0.74162195510476436, 0.18754811726602427, 0.72903016794612419, 0.029662560754477374, 0.61507586494668487, 0.81733460175545913, 0.8932036744394557, 0.46655828523063747, 0.82072526286742431, 0.77657049415927248, 0.833949582656972, 0.12484821467354346, 0.88577116031139791, 0.982082275780593, 0.2394438 [...] +18 [[0.3363835250565157, 0.42751606296856792, 0.95909113566627757, 0.015305717549693898, 0.63963346692763268, 0.662206475764985, 0.19265081668227968, 0.36648829855161447, 0.67768234725844145, 0.44679057950003875, 0.94253566163541913, 0.0419972030351593, 0.88215408366970394, 0.63119869767184589, 0.19829737844392692, 0.94022059322342155, 0.82699301653092216, 0.67549611064588866, 0.20717354676738475, 0.73738381032610623, 0.739135700713662, 0.5276357210213487, 0.12251055206492134, 0.87199014 [...] +19 [[0.064110097878604777, 0.20880075639202911, 0.8271834124783779, 0.5409920484990518, 0.970148587111359, 0.8291199604200874, 0.044393498739233261, 0.91190206355989478, 0.19435805338209444, 0.6088772957950721, 0.12166195872864705, 0.7365113753875705, 0.60576251085398969, 0.62022100824175985, 0.74187300322342165, 0.94936690438807747, 0.78426231312474293, 0.31738627446919121, 0.98052773662963755, 0.54906669154999588, 0.7306481551870585, 0.91122866732966346, 0.12487398339355948, 0.76713968 [...] +20 [[0.684257829378934, 0.70388618730619446, 0.91669107239388337, 0.097070795145535627, 0.42518446096791107, 0.32749456014199685, 0.17573416201290015, 0.97077480892428736, 0.22136291388316398, 0.578723728596944, 0.87961023616505507, 0.64923384344922963, 0.17114415678257822, 0.32973463962151495, 0.81838256249274288, 0.88938390395559119, 0.016497830529647928, 0.43662933626524647, 0.70965984643835534, 0.44093262810597977, 0.054137428707956681, 0.075643253405023758, 0.83884039021903234, 0.48 [...] +21 [[0.6282416298019271, 0.86423479871855158, 0.64051640054198133, 0.47154464676809205, 0.22303068332930998, 0.31937323748612734, 0.56317897125316452, 0.25979315710605622, 0.14789328251911638, 0.26376910076159166, 0.40027622345858727, 0.70243539501977659, 0.98536253767324122, 0.82519130249684947, 0.35414858262751348, 0.6894238443029882, 0.093520836477473668, 0.78103127732292077, 0.97859265893645231, 0.02078030359522598, 0.49122472672000439, 0.11970785905635695, 0.26029733668637822, 0.871 [...] +22 [[0.86422759673630334, 0.92679339642157155, 0.039232949953334928, 0.36945170719753029, 0.10445499958631888, 0.6693224249600398, 0.73125389499857574, 0.75744906617478513, 0.71545217427979924, 0.805416660525261, 0.89630901914123173, 0.71948614477196726, 0.93691749542168989, 0.67053738008471653, 0.62821235526745189, 0.89034704938005937, 0.56893543616380793, 0.73804662755730976, 0.96969112113386746, 0.31105666569182355, 0.08005316545771668, 0.83085210167034584, 0.63359136988200426, 0.6296 [...] +23 [[0.014350715683691062, 0.31198088124604328, 0.44919313540445149, 0.69403977782546622, 0.87170873297793683, 0.66908538287752817, 0.92408997060257614, 0.040486850653616457, 0.9018635145076721, 0.0769809553877272, 0.6379446662337267, 0.3287831700120436, 0.54633922249848688, 0.37187021408335308, 0.46124694626748486, 0.26703904141878221, 0.074211030034582182, 0.28004057053656206, 0.35419094952035479, 0.0611746267096257, 0.15039656641669574, 0.35241087496641776, 0.87091663563131516, 0.6556 [...] +24 [[0.61184783339368509, 0.90726494717810446, 0.052551004524158063, 0.68531092865850463, 0.075755468884431854, 0.23243887205627478, 0.016006660882104895, 0.55489866095327578, 0.35372039824367252, 0.21556295384126856, 0.6549740705467787, 0.023472470202435036, 0.59044348569592109, 0.49133437377913369, 0.14329430604691828, 0.19984437254013632, 0.59585062365578012, 0.4471476134147464, 0.00507627405204647, 0.92821258175716037, 0.489854027217573, 0.69896669376449327, 0.001897647243347178, 0.3 [...] + +-- !sql -- +25 + +-- !sql_count -- +25 + +-- !sql_parquet_inner -- +0 [[0.2434200686509983, 0.24234602011681528, 0.64895448286354074, 0.80656526546697949, 0.33553233191049614, 0.93104045037487582, 0.46082051709757321, 0.53545409981555159, 0.11940161295457363, 0.50894827151143052, 0.82244549745752793, 0.6191370566860076, 0.33453321135998482, 0.075267042138438045, 0.40832636186584292, 0.19376042004217831, 0.46281496989081572, 0.54388378653102276, 0.39025393742796888, 0.39257363676724322, 0.70940372601174673, 0.89336874762060425, 0.35773689855687063, 0.4634 [...] +1 [[0.441213983188219, 0.11829553460573472, 0.33551661881638117, 0.15769240977086962, 0.039896571828509142, 0.84339289915401416, 0.29772970512610364, 0.68175512882934242, 0.13552490402879558, 0.73721186924123583, 0.94628908401158074, 0.71997162119921032, 0.804720529599055, 0.1151729366872013, 0.22392404886137851, 0.68585234720029475, 0.59439613229450683, 0.44486208624901169, 0.34252653767716268, 0.8562974946251527, 0.201746488817938, 0.45932588358867166, 0.1517964539013732, 0.74892856020 [...] +2 [[0.76900112854951785, 0.040707996366250665, 0.73040821209474038, 0.251174093959617, 0.71938437935301336, 0.90000184400502226, 0.29695811719826615, 0.77132447239782309, 0.3364963599585733, 0.22297486715776116, 0.69454649562099435, 0.9551249988985, 0.96884572098791266, 0.17347093634523736, 0.56434207544207449, 0.19757550008890767, 0.44749957994579836, 0.43964797103244158, 0.95970263505113274, 0.47711000474054077, 0.91446112100589083, 0.54755561537061559, 0.21819692563011628, 0.981575589 [...] +3 [[0.19201896280979724, 0.2277157594303113, 0.70696662663421062, 0.79613852089303372, 0.013154619183022187, 0.75111997454023149, 0.88382321644299544, 0.48943459157003355, 0.65226277171827529, 0.013413662629729872, 0.72326802798739775, 0.64237045403012538, 0.50375062994211028, 0.24899579433512853, 0.59781326778245125, 0.25528106793388783, 0.86173075992973081, 0.7486746409719387, 0.099299268038050448, 0.14850151396944167, 0.927790463055653, 0.0028725613850517639, 0.61728786534414593, 0.81 [...] +4 [[0.59645537235209667, 0.60470950911235721, 0.90236107510871155, 0.66714780095213988, 0.95683682493491606, 0.0084652348887768181, 0.44903257208378411, 0.08657419553688217, 0.17840048948389087, 0.024768644008877794, 0.90679260937660666, 0.090295817453005744, 0.81267474389430649, 0.53225725844427452, 0.026670213937739828, 0.38148239227264857, 0.79269793518267984, 0.17868443924478761, 0.97028447888209113, 0.1496567720548948, 0.868275994476362, 0.27988042656300116, 0.47835050846162352, 0.0 [...] +5 [[0.21999856488055747, 0.80106949963414387, 0.37888818235979371, 0.35621115078552767, 0.25905903110594364, 0.071486484085366175, 0.0873221357781595, 0.67747056809382589, 0.82675146444177572, 0.85778986301193283, 0.30961240678283997, 0.53293854613108982, 0.68386730354734, 0.7955796080221551, 0.78574708007062621, 0.28047617531729108, 0.020318084552748306, 0.311024599080163, 0.60445405220301629, 0.32359007828189013, 0.37264965333025513, 0.23379841929490885, 0.6143202190477125, 0.182057930 [...] +6 [[0.74898892346933432, 0.0772671311088804, 0.7484759208893712, 0.5151660040344227, 0.54793263204154052, 0.17860231571322482, 0.45191545547845136, 0.23965009227204648, 0.75616725349983827, 0.65085678938875624, 0.091046660666927348, 0.9603655949205443, 0.22065287928589716, 0.27452040044972426, 0.3514822877984074, 0.34117875302795775, 0.097458775756514959, 0.58830642952170442, 0.73846443555926278, 0.55919580552106707, 0.45037858572707812, 0.13647543794934003, 0.13255920726058945, 0.168716 [...] +7 [[0.81016551924298819, 0.034827311984228504, 0.42584577044060956, 0.65761719473752112, 0.015828067858713157, 0.77104072310432981, 0.32378500814571542, 0.96337227876248355, 0.72757792965145829, 0.5567974933569082, 0.36826830177176606, 0.38974273844483154, 0.57162102356777855, 0.058465386858290835, 0.91864498625008917, 0.31216011334835558, 0.6550489555175163, 0.625780920785453, 0.43187750880489983, 0.83676673245429811, 0.56779250439812456, 0.9354600086277306, 0.62236094937422193, 0.15691 [...] +8 [[0.68849776030513066, 0.3945690554217266, 0.23162958058849181, 0.43005636234695066, 0.957092602038879, 0.91948228885547245, 0.083245187680261234, 0.80924594123290727, 0.59254527549686764, 0.31581885385248487, 0.84179038061634559, 0.48676570699450628, 0.18799174598170176, 0.270641957952527, 0.36534699824927042, 0.60822004432697108, 0.7963198854238247, 0.762516297939034, 0.9005458459567709, 0.19884478242750259, 0.31919896294241079, 0.012712557276409853, 0.73024089460035913, 0.4025197810 [...] +9 [[0.10701536380206866, 0.25884977813910282, 0.7902525709347652, 0.4137897115249527, 0.27238753268880089, 0.54107578240098964, 0.86478988051687966, 0.20059459807190805, 0.33888160879667983, 0.719477324458027, 0.040571298808728229, 0.46250918638629723, 0.31847082537786509, 0.67561422690960515, 0.29156123431457415, 0.8061135009203203, 0.81202731508154768, 0.29049496589672441, 0.44043930814534304, 0.091635859114874707, 0.30524389711018063, 0.26375964174118882, 0.96917096610218034, 0.791492 [...] +10 [[0.046210800798201834, 0.19270931408029479, 0.031476592245683443, 0.8179910428536965, 0.80300002985709384, 0.374844428232911, 0.11473413378304687, 0.67074038967919913, 0.70269264562020894, 0.58458553043632022, 0.24137910691272157, 0.80798996757106778, 0.85186356535586361, 0.94555284981235721, 0.36073980750727719, 0.4308928939064961, 0.98812799047625011, 0.067403918230073523, 0.8970263709298717, 0.78300851419541506, 0.5158575887984499, 0.16702206238978623, 0.1543196468389032, 0.383260 [...] +11 [[0.65327432894692838, 0.32894198092623417, 0.9619307687845664, 0.99539125926505623, 0.53345764975478194, 0.86505853674749433, 0.18498367713182573, 0.11584283599472811, 0.19985143801523308, 0.022159199001309582, 0.606595360826325, 0.64825041300866781, 0.61877978755153007, 0.2018765340783063, 0.69951173647581022, 0.61528678466458853, 0.55314671839668983, 0.0642892129530197, 0.8654015226776085, 0.4606225640448115, 0.11353434062603562, 0.642277842163975, 0.13033174785619572, 0.9286040206 [...] +12 [[0.81185833049958844, 0.30666067502430072, 0.65538831497946615, 0.203106185079865, 0.00078869097953226941, 0.0031811868122340048, 0.265963761865172, 0.35560473239960733, 0.86359735984662778, 0.947279996928223, 0.21334787657408905, 0.86788450171151021, 0.22469454256582055, 0.60451736003698042, 0.97510032079053133, 0.39843263106573423, 0.94130813218741072, 0.0459891766655921, 0.1620075117346309, 0.64544667605197537, 0.67346080605993008, 0.12485844879470631, 0.66225160763659563, 0.74440 [...] +13 [[0.12030761117169952, 0.21550887718555545, 0.49410894070815692, 0.42143467974520266, 0.81946279547105316, 0.45846426055389233, 0.65712742631890353, 0.15314477366832269, 0.41528878608123254, 0.12911772418269263, 0.67926389722739877, 0.93346414159677027, 0.93520902500503, 0.15421306709632598, 0.4625297969625134, 0.59796307240740187, 0.64657805418685965, 0.49975378919957991, 0.95603621000037775, 0.59442924775666361, 0.014895576314810866, 0.24932905647433645, 0.8320104371213185, 0.004921 [...] +14 [[0.56756937645255057, 0.25931061792936327, 0.42232614384641554, 0.85459627004177552, 0.45020684777715936, 0.29767402545492538, 0.080229346108791177, 0.022898418006150334, 0.080332362797224555, 0.32680510799539164, 0.3650687261202672, 0.73586028167479645, 0.8973098989709124, 0.2578144961028338, 0.48980318727312011, 0.58474995051373668, 0.463153911850928, 0.011714371147868552, 0.43605207683782576, 0.63128663585656686, 0.066994296286058352, 0.60624375792077911, 0.030652471942043236, 0.6 [...] +15 [[0.65069461186175015, 0.72665034408710583, 0.77197434126543019, 0.40282943352113187, 0.64552393492322058, 0.765940755594443, 0.22553712288078731, 0.27967614535782626, 0.95223357133615949, 0.54526938922304757, 0.77496235494751209, 0.96470331564816869, 0.23770553340681233, 0.667868020195893, 0.71343109818229344, 0.59255155272705151, 0.15507542962345877, 0.35088308415654912, 0.46178941443891897, 0.24185122040952867, 0.35371780010244869, 0.47385360009386546, 0.69938190468420414, 0.044096 [...] +16 [[0.35441253712880016, 0.74230695184923845, 0.403537363109042, 0.41356457856567996, 0.069869469799674011, 0.26499751959177964, 0.26997623778465574, 0.68996237650176429, 0.68746833941028807, 0.91859472331559722, 0.92932073879157817, 0.68144804533134318, 0.30166772591661484, 0.3655925371376133, 0.33436780641007413, 0.73591415210585975, 0.40855237634638375, 0.70179921551863145, 0.67963263037462351, 0.5740227195464046, 0.23769397114716284, 0.55289746325245326, 0.92133186037084069, 0.73162 [...] +17 [[0.97116668791348648, 0.47225829864239022, 0.48518800874288348, 0.12778390066476486, 0.66738280266453376, 0.69756208231553318, 0.58691193681800757, 0.83726240370669713, 0.6342386538366106, 0.74162195510476436, 0.18754811726602427, 0.72903016794612419, 0.029662560754477374, 0.61507586494668487, 0.81733460175545913, 0.8932036744394557, 0.46655828523063747, 0.82072526286742431, 0.77657049415927248, 0.833949582656972, 0.12484821467354346, 0.88577116031139791, 0.982082275780593, 0.2394438 [...] +18 [[0.3363835250565157, 0.42751606296856792, 0.95909113566627757, 0.015305717549693898, 0.63963346692763268, 0.662206475764985, 0.19265081668227968, 0.36648829855161447, 0.67768234725844145, 0.44679057950003875, 0.94253566163541913, 0.0419972030351593, 0.88215408366970394, 0.63119869767184589, 0.19829737844392692, 0.94022059322342155, 0.82699301653092216, 0.67549611064588866, 0.20717354676738475, 0.73738381032610623, 0.739135700713662, 0.5276357210213487, 0.12251055206492134, 0.87199014 [...] +19 [[0.064110097878604777, 0.20880075639202911, 0.8271834124783779, 0.5409920484990518, 0.970148587111359, 0.8291199604200874, 0.044393498739233261, 0.91190206355989478, 0.19435805338209444, 0.6088772957950721, 0.12166195872864705, 0.7365113753875705, 0.60576251085398969, 0.62022100824175985, 0.74187300322342165, 0.94936690438807747, 0.78426231312474293, 0.31738627446919121, 0.98052773662963755, 0.54906669154999588, 0.7306481551870585, 0.91122866732966346, 0.12487398339355948, 0.76713968 [...] +20 [[0.684257829378934, 0.70388618730619446, 0.91669107239388337, 0.097070795145535627, 0.42518446096791107, 0.32749456014199685, 0.17573416201290015, 0.97077480892428736, 0.22136291388316398, 0.578723728596944, 0.87961023616505507, 0.64923384344922963, 0.17114415678257822, 0.32973463962151495, 0.81838256249274288, 0.88938390395559119, 0.016497830529647928, 0.43662933626524647, 0.70965984643835534, 0.44093262810597977, 0.054137428707956681, 0.075643253405023758, 0.83884039021903234, 0.48 [...] +21 [[0.6282416298019271, 0.86423479871855158, 0.64051640054198133, 0.47154464676809205, 0.22303068332930998, 0.31937323748612734, 0.56317897125316452, 0.25979315710605622, 0.14789328251911638, 0.26376910076159166, 0.40027622345858727, 0.70243539501977659, 0.98536253767324122, 0.82519130249684947, 0.35414858262751348, 0.6894238443029882, 0.093520836477473668, 0.78103127732292077, 0.97859265893645231, 0.02078030359522598, 0.49122472672000439, 0.11970785905635695, 0.26029733668637822, 0.871 [...] +22 [[0.86422759673630334, 0.92679339642157155, 0.039232949953334928, 0.36945170719753029, 0.10445499958631888, 0.6693224249600398, 0.73125389499857574, 0.75744906617478513, 0.71545217427979924, 0.805416660525261, 0.89630901914123173, 0.71948614477196726, 0.93691749542168989, 0.67053738008471653, 0.62821235526745189, 0.89034704938005937, 0.56893543616380793, 0.73804662755730976, 0.96969112113386746, 0.31105666569182355, 0.08005316545771668, 0.83085210167034584, 0.63359136988200426, 0.6296 [...] +23 [[0.014350715683691062, 0.31198088124604328, 0.44919313540445149, 0.69403977782546622, 0.87170873297793683, 0.66908538287752817, 0.92408997060257614, 0.040486850653616457, 0.9018635145076721, 0.0769809553877272, 0.6379446662337267, 0.3287831700120436, 0.54633922249848688, 0.37187021408335308, 0.46124694626748486, 0.26703904141878221, 0.074211030034582182, 0.28004057053656206, 0.35419094952035479, 0.0611746267096257, 0.15039656641669574, 0.35241087496641776, 0.87091663563131516, 0.6556 [...] +24 [[0.61184783339368509, 0.90726494717810446, 0.052551004524158063, 0.68531092865850463, 0.075755468884431854, 0.23243887205627478, 0.016006660882104895, 0.55489866095327578, 0.35372039824367252, 0.21556295384126856, 0.6549740705467787, 0.023472470202435036, 0.59044348569592109, 0.49133437377913369, 0.14329430604691828, 0.19984437254013632, 0.59585062365578012, 0.4471476134147464, 0.00507627405204647, 0.92821258175716037, 0.489854027217573, 0.69896669376449327, 0.001897647243347178, 0.3 [...] + +-- !sql -- +0 + diff --git a/regression-test/suites/external_table_p0/tvf/test_local_tvf_with_complex_type_insertinto_doris.groovy b/regression-test/suites/external_table_p0/tvf/test_local_tvf_with_complex_type_insertinto_doris.groovy index fbe8fb5597..04feab78dd 100644 --- a/regression-test/suites/external_table_p0/tvf/test_local_tvf_with_complex_type_insertinto_doris.groovy +++ b/regression-test/suites/external_table_p0/tvf/test_local_tvf_with_complex_type_insertinto_doris.groovy @@ -19,25 +19,34 @@ import org.junit.Assert // This suit test the `backends` tvf suite("test_local_tvf_with_complex_type_insertinto_doris", "p0") { + sql """set enable_nereids_planner=false""" List<List<Object>> backends = sql """ select * from backends(); """ assertTrue(backends.size() > 0) def be_id = backends[0][0] def dataFilePath = context.config.dataPath + "/external_table_p0/tvf/" def table_name = "comp" + def outFilePath= dataFilePath + if (backends.size() > 1) { // cluster mode need to make sure all be has this data - def outFilePath="/" - def transFile01="${dataFilePath}/comp.orc" - def transFile02="${dataFilePath}/comp.parquet" + outFilePath="/" + def transFile01 = "${dataFilePath}/comp.orc" + def transFile02 = "${dataFilePath}/comp.parquet" + def transFile1="${dataFilePath}/comp_arr.orc" + def transFile2="${dataFilePath}/comp_arr.parquet" for (List<Object> backend : backends) { def be_host = backend[1] - scpFiles ("root", be_host, transFile01, outFilePath, false); - scpFiles ("root", be_host, transFile02, outFilePath, false); + scpFiles("root", be_host, transFile01, outFilePath, false) + scpFiles("root", be_host, transFile02, outFilePath, false) + scpFiles ("root", be_host, transFile1, outFilePath, false) + scpFiles ("root", be_host, transFile2, outFilePath, false); } + } qt_sql """ADMIN SET FRONTEND CONFIG ('disable_nested_complex_type' = 'false')""" // create doris table + sql """ DROP TABLE IF EXISTS ${table_name} """ qt_sql """ CREATE TABLE IF NOT EXISTS ${table_name} ( `id` int(11) NULL, @@ -88,4 +97,61 @@ suite("test_local_tvf_with_complex_type_insertinto_doris", "p0") { qt_sql """ drop table ${table_name} """ + // array-map + def table_arr = "comp_arr" + sql """ DROP TABLE IF EXISTS ${table_arr} """ + qt_sql """ + CREATE TABLE IF NOT EXISTS ${table_arr} ( + `id` int(11) NULL, + `aa` ARRAY<ARRAY<double>> NULL, + `am` ARRAY<MAP<text,int>> NULL + ) ENGINE=OLAP + DUPLICATE KEY(`id`) + COMMENT 'OLAP' + DISTRIBUTED BY HASH(`id`) BUCKETS 1 + PROPERTIES ( + "replication_allocation" = "tag.location.default: 1", + "is_being_synced" = "false", + "storage_format" = "V2", + "light_schema_change" = "true", + "disable_auto_compaction" = "false", + "enable_single_replica_compaction" = "false" + ); """ + + + qt_sql_orc_tvf """ + select * from local( + "file_path" = "${outFilePath}/comp_arr.orc", + "backend_id" = "${be_id}", + "format" = "orc");""" + + qt_sql """ + insert into ${table_arr} select * from local ( + "file_path" = "${outFilePath}/comp_arr.orc", + "backend_id" = "${be_id}", + "format" = "orc");""" + + qt_sql_orc_inner """ select * from ${table_arr} order by id; """ + + qt_sql """ truncate table ${table_arr} """ + + qt_sql_parquet_tvf """ + select * from local( + "file_path" = "${outFilePath}/comp_arr.parquet", + "backend_id" = "${be_id}", + "format" = "parquet"); """ + + qt_sql """ + insert into ${table_arr} select * from local( + "file_path" = "${outFilePath}/comp_arr.parquet", + "backend_id" = "${be_id}", + "format" = "parquet"); """ + + qt_sql_count """ select count(*) from ${table_arr} """ + + qt_sql_parquet_inner """ select * from ${table_arr} order by id""" + + qt_sql """ drop table ${table_arr} """ + + } --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
