Details
-
Sub-task
-
Status: Open
-
Major
-
Resolution: Unresolved
-
3.0.0
-
None
-
None
Description
These are valid queries in PostgreSQL, but they don't work in Spark SQL:
values ((select 1)); values ((select c from test1)); select (values(c)) from test10; with cte(foo) as ( values(42) ) values((select foo from cte));
where test1 and test10:
CREATE TABLE test1 (c INTEGER); INSERT INTO test1 VALUES(1); CREATE TABLE test10 (c INTEGER); INSERT INTO test10 SELECT generate_sequence(1, 10);