CTA的错误-Azure Synapse Analytics

发布于 2025-02-09 07:35:51 字数 1086 浏览 1 评论 0原文

我正在尝试使用CTA在Synapse SQL中创建一个临时表

IF OBJECT_ID('tempdb..#temp') IS NOT NULL DROP TABLE #temp
CREATE TABLE #temp 
AS SELECT [State], LocalizedLabel FROM StateMetadata WHERE EntityName ='incident'

，并获取错误消息

在关键字“ select”附近的错误语法。总执行时间：00：00：00.533

错误消息snip snip

如果我本身单独运行选择语句突出显示它的作品

SELECT [State], LocalizedLabel FROM StateMetadata WHERE EntityName ='incident'

select Seption语句工作正常

，如果我不使用AS来创建temp表，则可以fine也是

IF OBJECT_ID('tempdb..#temp') IS NOT NULL DROP TABLE #temp
CREATE TABLE #temp (
    statecode int,
    statecodename nvarchar(64)
    )
SELECT * FROM #temp

创建temp table而不使用as

我尝试了括号和一切。不知道我可能做错了什么。我是突触分析的新手，对此的任何帮助将不胜感激。

谢谢尼迪

原文

I am trying to create a temp table in Synapse SQL using CTAS

IF OBJECT_ID('tempdb..#temp') IS NOT NULL DROP TABLE #temp
CREATE TABLE #temp 
AS SELECT [State], LocalizedLabel FROM StateMetadata WHERE EntityName ='incident'

and getting an error message

Incorrect syntax near the keyword 'SELECT'.
Total execution time: 00:00:00.533

Error message snip

If I run SELECT statement by itself as highlighted it works

SELECT [State], LocalizedLabel FROM StateMetadata WHERE EntityName ='incident'

Select statement that works fine

and if I create temp table without using AS, it works fine as well

IF OBJECT_ID('tempdb..#temp') IS NOT NULL DROP TABLE #temp
CREATE TABLE #temp (
    statecode int,
    statecodename nvarchar(64)
    )
SELECT * FROM #temp

Create temp table without using AS

I have tried brackets and everything I could. Not sure what I am possibly doing wrong. I am new to Synapse Analytics, Any help on this would be highly appreciated.

Thanks
Nidhi

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

单身情人 2025-02-16 07:35:51

ctas在创建时需要一个分发选项。使用 ctas 。

IF OBJECT_ID('tempdb..#temp') IS NOT NULL DROP TABLE #temp

CREATE TABLE #temp
WITH
(
  DISTRIBUTION = ROUND_ROBIN
)
AS
SELECT StateName, StateCode FROM SP WHERE Region ='US';

select * from #temp

CTAS requires a distribution option while creating. Include distribution options while creating temp tables using CTAS.

IF OBJECT_ID('tempdb..#temp') IS NOT NULL DROP TABLE #temp

CREATE TABLE #temp
WITH
(
  DISTRIBUTION = ROUND_ROBIN
)
AS
SELECT StateName, StateCode FROM SP WHERE Region ='US';

select * from #temp