// Copyright 2023 PingCAP, Inc. // // Licensed 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 #include #include #include #include #include #include #include #include #include #include #include #include #include #include #include #include #include namespace DB { namespace ErrorCodes { extern const int NO_SUCH_COLUMN_IN_TABLE; extern const int READONLY; extern const int ILLEGAL_COLUMN; } // namespace ErrorCodes InterpreterInsertQuery::InterpreterInsertQuery( const ASTPtr & query_ptr_, const Context & context_, bool allow_materialized_) : query_ptr(query_ptr_) , context(context_) , allow_materialized(allow_materialized_) {} StoragePtr InterpreterInsertQuery::getTable(const ASTInsertQuery & query) { if (query.table_function) { const auto * table_function = typeid_cast(query.table_function.get()); const auto & factory = TableFunctionFactory::instance(); return factory.get(table_function->name, context)->execute(query.table_function, context); } /// Into what table to write. return context.getTable(query.database, query.table); } Block InterpreterInsertQuery::getSampleBlock(const ASTInsertQuery & query, const StoragePtr & table) // NOLINT { Block table_sample_non_materialized; if (query.is_import) table_sample_non_materialized = table->getSampleBlockNonMaterialized(); else table_sample_non_materialized = table->getSampleBlockNonMaterializedNoHidden(); /// If the query does not include information about columns if (!query.columns) return table_sample_non_materialized; Block table_sample; if (query.is_import) table_sample = table->getSampleBlock(); else table_sample = table->getSampleBlockNoHidden(); /// Form the block based on the column names from the query Block res; for (const auto & identifier : query.columns->children) { std::string current_name = identifier->getColumnName(); /// The table does not have a column with that name if (!table_sample.has(current_name)) throw Exception( "No such column " + current_name + " in table " + query.table, ErrorCodes::NO_SUCH_COLUMN_IN_TABLE); if (!allow_materialized && !table_sample_non_materialized.has(current_name)) throw Exception( "Cannot insert column " + current_name + ", because it is MATERIALIZED column.", ErrorCodes::ILLEGAL_COLUMN); res.insert(ColumnWithTypeAndName(table_sample.getByName(current_name).type, current_name)); } return res; } BlockIO InterpreterInsertQuery::execute() { ASTInsertQuery & query = typeid_cast(*query_ptr); checkAccess(query); StoragePtr table = getTable(query); // if (table->getName() == MutableSupport::txn_storage_name) // throw Exception(MutableSupport::txn_storage_name + " doesn't support Insert", ErrorCodes::LOGICAL_ERROR); auto table_lock = table->lockStructureForShare(context.getCurrentQueryId()); NamesAndTypesList required_columns = table->getColumns().getAllPhysical(); /// We create a pipeline of several streams, into which we will write data. BlockOutputStreamPtr out; out = std::make_shared( query.database, query.table, table, context, query_ptr, query.no_destination); out = std::make_shared( out, getSampleBlock(query, table), required_columns, table->getColumns().defaults, context); /// Do not squash blocks if it is a sync INSERT into Distributed, since it lead to double bufferization on client and server side. /// Client-side bufferization might cause excessive timeouts (especially in case of big blocks). if (table->getName() != "Distributed") { out = std::make_shared( out, context.getSettingsRef().min_insert_block_size_rows, context.getSettingsRef().min_insert_block_size_bytes); } auto out_wrapper = std::make_shared(out); out_wrapper->setProcessListElement(context.getProcessListElement()); out = std::move(out_wrapper); BlockIO res; res.out = std::move(out); /// What type of query: INSERT or INSERT SELECT? if (query.select) { /// Passing 1 as subquery_depth will disable limiting size of intermediate result. InterpreterSelectWithUnionQuery interpreter_select{query.select, context, {}, QueryProcessingStage::Complete, 1}; res.in = interpreter_select.execute().in; res.in = std::make_shared( context, res.in, res.out->getHeader(), ConvertingBlockInputStream::MatchColumnsMode::Position); res.in = std::make_shared(res.in, res.out); res.out = nullptr; if (!allow_materialized) { Block in_header = res.in->getHeader(); for (const auto & name_type : table->getColumns().materialized) if (in_header.has(name_type.name)) throw Exception( "Cannot insert column " + name_type.name + ", because it is MATERIALIZED column.", ErrorCodes::ILLEGAL_COLUMN); } } return res; } void InterpreterInsertQuery::checkAccess(const ASTInsertQuery & query) { const Settings & settings = context.getSettingsRef(); auto readonly = settings.readonly; if (!readonly || (query.database.empty() && context.tryGetExternalTable(query.table) && readonly >= 2)) { return; } throw Exception("Cannot insert into table in readonly mode", ErrorCodes::READONLY); } } // namespace DB