[jira] [Commented] (SPARK-28284) Convert and port 'join-empty-relation.sql' into UDF test base

2019-07-11 Thread Terry Kim (JIRA) 


[ 
https://issues.apache.org/jira/browse/SPARK-28284?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16883197#comment-16883197
 ] 

Terry Kim commented on SPARK-28284:
---

Yes, I am working on it. You can take up the pivot.sql.

> Convert and port 'join-empty-relation.sql' into UDF test base
> -
>
> Key: SPARK-28284
> URL: https://issues.apache.org/jira/browse/SPARK-28284
> Project: Spark
>  Issue Type: Sub-task
>  Components: PySpark, SQL, Tests
>Affects Versions: 3.0.0
>Reporter: Hyukjin Kwon
>Priority: Major
>




--
This message was sent by Atlassian JIRA
(v7.6.14#76016)

-
To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org

[jira] [Commented] (SPARK-28284) Convert and port 'join-empty-relation.sql' into UDF test base

2019-07-11 Thread Chitral Verma (JIRA) 


[ 
https://issues.apache.org/jira/browse/SPARK-28284?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16883177#comment-16883177
 ] 

Chitral Verma commented on SPARK-28284:
---

Hi, Is some one working on this? I'd like to pick it up.

> Convert and port 'join-empty-relation.sql' into UDF test base
> -
>
> Key: SPARK-28284
> URL: https://issues.apache.org/jira/browse/SPARK-28284
> Project: Spark
>  Issue Type: Sub-task
>  Components: PySpark, SQL, Tests
>Affects Versions: 3.0.0
>Reporter: Hyukjin Kwon
>Priority: Major
>




--
This message was sent by Atlassian JIRA
(v7.6.14#76016)

-
To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org

[jira] [Commented] (SPARK-28284) Convert and port 'join-empty-relation.sql' into UDF test base

2019-07-09 Thread Hyukjin Kwon (JIRA) 


[ 
https://issues.apache.org/jira/browse/SPARK-28284?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16881738#comment-16881738
 ] 

Hyukjin Kwon commented on SPARK-28284:
--

Yea, or we can add some conditions on {{ON}} that returns \{{true}}.

> Convert and port 'join-empty-relation.sql' into UDF test base
> -
>
> Key: SPARK-28284
> URL: https://issues.apache.org/jira/browse/SPARK-28284
> Project: Spark
>  Issue Type: Sub-task
>  Components: PySpark, SQL, Tests
>Affects Versions: 3.0.0
>Reporter: Hyukjin Kwon
>Priority: Major
>




--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

-
To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org

[jira] [Commented] (SPARK-28284) Convert and port 'join-empty-relation.sql' into UDF test base

2019-07-09 Thread Terry Kim (JIRA) 


[ 
https://issues.apache.org/jira/browse/SPARK-28284?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16881731#comment-16881731
 ] 

Terry Kim commented on SPARK-28284:
---

join-empty-relation.sql has the following:

{code:java}
SELECT * FROM t1 INNER JOIN empty_table;
SELECT * FROM t1 CROSS JOIN empty_table;
SELECT * FROM t1 LEFT OUTER JOIN empty_table;
SELECT * FROM t1 RIGHT OUTER JOIN empty_table;
SELECT * FROM t1 FULL OUTER JOIN empty_table;
SELECT * FROM t1 LEFT SEMI JOIN empty_table;
SELECT * FROM t1 LEFT ANTI JOIN empty_table;

SELECT * FROM empty_table INNER JOIN t1;
SELECT * FROM empty_table CROSS JOIN t1;
SELECT * FROM empty_table LEFT OUTER JOIN t1;
SELECT * FROM empty_table RIGHT OUTER JOIN t1;
SELECT * FROM empty_table FULL OUTER JOIN t1;
SELECT * FROM empty_table LEFT SEMI JOIN t1;
SELECT * FROM empty_table LEFT ANTI JOIN t1;

SELECT * FROM empty_table INNER JOIN empty_table;
SELECT * FROM empty_table CROSS JOIN empty_table;
SELECT * FROM empty_table LEFT OUTER JOIN empty_table;
SELECT * FROM empty_table RIGHT OUTER JOIN empty_table;
SELECT * FROM empty_table FULL OUTER JOIN empty_table;
SELECT * FROM empty_table LEFT SEMI JOIN empty_table;
SELECT * FROM empty_table LEFT ANTI JOIN empty_table;
{code}

Where can I put `udf`? Do you want to modify SELECT clause?

> Convert and port 'join-empty-relation.sql' into UDF test base
> -
>
> Key: SPARK-28284
> URL: https://issues.apache.org/jira/browse/SPARK-28284
> Project: Spark
>  Issue Type: Sub-task
>  Components: PySpark, SQL, Tests
>Affects Versions: 3.0.0
>Reporter: Hyukjin Kwon
>Priority: Major
>




--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

-
To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org