在Big Query中创建一个表格 [英] Create a table in Big Query

问题描述

我想用SQL语句中指定的值创建一个列。结果应该如下所示：

I would like to create a column with values specified in SQL statement. Result should look like this:

-- +---------+
-- | Title   |
-- +---------+
-- | Title 1 |
-- | Title 2 | 
-- | Title 3 |
-- | Title 4 |
-- +---------+

我知道路使用语法SELECT * FROM（SELECT'Title 1'as Title），（SELECT'Title 2'as Title）...
有没有更简单的方法来做到这一点？我有数百个值，我需要在SQL语句中指定它们。

I know the way with using syntax SELECT * FROM (SELECT 'Title 1' as Title),(SELECT 'Title 2' as Title),... Is there any shorter way how to do that? I have hundreds of the values there and I need specify them in SQL statement.

推荐答案

for BigQuery Legacy SQL

for BigQuery Legacy SQL

#legacySQL
SELECT SPLIT(Titles) AS Title 
FROM (SELECT 'Title 1,Title 2,Title 3,Title 4' AS Titles)

您可以使用 FLATTEN 运算符来压扁SPLIT的结果

查看下面的例子

You can use FLATTEN operator to flatten result of SPLIT
See example below

#legacySQL
SELECT * 
FROM FLATTEN(( 
    SELECT SPLIT(Titles) AS Title 
    FROM (SELECT 'xy,zx' AS Titles)
  ), Title) AS A 
LEFT JOIN ( 
  SELECT Name, Title 
  FROM table.name
) AS Names
ON A.Title=Names.Title

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