尝试使用set操作,但在Athena中似乎不起作用。是不支持它,还是SQL有什么问题?
SELECT DISTINCT cik FROM xbrl
MINUS
SELECT cik FROM xbrl
WHERE year IN (2015,2014,2013,2012,2011,2010)
第3:1行:不匹配的输入"SELECT"。应为:"(",",","CROSS","EXCEPT","FULL","GROUP","HAVING","INNER","INTERSECT","JOIN","LEFT","LIMIT","NATURAL","OFFSET","ORDER","RIGHT","TABLESAMPLE","UNION","WHERE",
看起来Athena不支持MINUS
,但通常我们可以用其他方式表达减号查询。在这种情况下,使用:
SELECT DISTINCT cik
FROM xbrl
WHERE year < 2010 OR year > 2015;
对于在Athena中的设置操作,您可以使用{UNION|INTERSECT|EXCEPT}
选择与xbrl不同的cik除从xbrl选择cik年份(201520142013201220112010(