BigQuery是否支持“立即执行"?命令运行动态查询? [英] Does BigQuery support "execute immediate" command to run dynamic query?

问题描述

我可以在Oracle中这样编码，以使用"执行立即的'sql查询..'"命令动态创建表.

I can code like this in Oracle to create tables dynamically using "execute immediate 'sql query..'" command.

    create or replace function make_a_table1(p_table_name varchar2, p_column_name varchar2, p_data_type varchar2) return varchar2 is
    var varchar2(150);
    sydt varchar2(30);
    pragma autonomous_transaction;
    begin
    select to_char(sysdate,'HH24_MI_SS') into sydt from dual;
    dbms_output.put_line(sydt);
    var :='create table '||p_table_name||'_'||sydt||' ( '||p_column_name||' '||p_data_type||')';
    dbms_output.put_line(var);
      execute immediate var;  
      commit;
      return 'Table Created Successfully';
    end;

是否可以在BigQuery函数中实现这一目标?

Is it possible to Achieve this in BigQuery functions?

推荐答案

是的，BigQuery支持EXECUTE IMMEDIATE命令来运行动态查询.

Yes, BigQuery supports EXECUTE IMMEDIATE command to run dynamic query.

DECLARE p_dataset_name STRING DEFAULT 'mydataset';
DECLARE p_table_name STRING DEFAULT 'demo';
DECLARE p_column_name STRING DEFAULT 'c1';
DECLARE p_data_type STRING DEFAULT 'string';
DECLARE sydt STRING;
DECLARE qry STRING;
SET sydt = CONCAT(EXTRACT(HOUR from CURRENT_TIMESTAMP()),'_',EXTRACT(MINUTE from CURRENT_TIMESTAMP()),'_',EXTRACT(SECOND from CURRENT_TIMESTAMP()));
SET qry = 'create table '||p_dataset_name||'.'||p_table_name||'_'||sydt||' ('||p_column_name||' '||p_data_type||')';
EXECUTE IMMEDIATE qry;

这篇关于BigQuery是否支持“立即执行"?命令运行动态查询?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！