Function createView

src/Interpreters/CnchSystemLogHelper.cpp:312–339

}

bool createView(
    ContextPtr global_context,
    const String & database,
    const String & table,
    Poco::Logger * log)
{
    bool ret = true;

    try
    {
        auto query_context = Context::createCopy(global_context);
        query_context->makeSessionContext();
        query_context->makeQueryContext();

        String create_view_query = "CREATE VIEW IF NOT EXISTS system." + table + " AS SELECT * from " + database + "." + table;
        ParserCreateQuery create_parser;
        ASTPtr create_view_ast = parseQuery(create_parser, create_view_query, 0, DBMS_DEFAULT_MAX_PARSER_DEPTH);
        InterpreterCreateQuery create_interpreter(create_view_ast, query_context);
        create_interpreter.execute();
        LOG_INFO(log, "Create view with query {} successful!", create_view_query);
    }
    catch (Exception & e)
    {
        LOG_DEBUG(log, "Failed to create view for {}.{}, met exception {}", database, table, e.message());
        ret = false;
    }
    return ret;
}

}/// end namespace