从Select BigQuery中创建一个表 [英] Create a table from Select Bigquery

问题描述

  Select * into new_table 
你好我可以在MSSQL或Oracle中使用sql创建一个表，来自old_table; 
  

是否可以在BigQuery中执行此操作？在控制台中输入时出现错误：Error：EncounteredINTOINTOin line 2，column 1. was expected：。

我有一个内联用户定义函数的选择。我喜欢将这个select的输出存储到一个单独的表中。 你不能使用到，但你可以点击显示选项并选择一个表。

Hi i can create a table from an old table using sql in MSSQL or Oracle like this:

Select * into new_table  from  old_table;

Is it possible to do it in BigQuery? I got an error when typing this in the console: "Error: Encountered " "INTO" "INTO "" at line 2, column 1. Was expecting: ".

I have a Select with an inline User Defined Function. I like to take the output of this select and store it in a separate table.

解决方案

You cannot use into, but you can click on "show options" and select a table there.

这篇关于从Select BigQuery中创建一个表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！