[jira] [Commented] (SPARK-12506) Push down WHERE clause arithmetic operator to JDBC layer
[ https://issues.apache.org/jira/browse/SPARK-12506?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15126788#comment-15126788 ] Apache Spark commented on SPARK-12506: -- User 'huaxingao' has created a pull request for this issue: https://github.com/apache/spark/pull/11005 > Push down WHERE clause arithmetic operator to JDBC layer > > > Key: SPARK-12506 > URL: https://issues.apache.org/jira/browse/SPARK-12506 > Project: Spark > Issue Type: Improvement > Components: SQL >Reporter: Huaxin Gao >Assignee: Apache Spark > > For arithmetic operator in WHERE clause such as > select * from table where c1 + c2 > 10 > Currently where c1 + c2 >10 is done at spark layer. > Will push this to JDBC layer so it will be done in database. -- This message was sent by Atlassian JIRA (v6.3.4#6332) - To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org
[jira] [Commented] (SPARK-12506) Push down WHERE clause arithmetic operator to JDBC layer
[ https://issues.apache.org/jira/browse/SPARK-12506?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15097430#comment-15097430 ] Apache Spark commented on SPARK-12506: -- User 'huaxingao' has created a pull request for this issue: https://github.com/apache/spark/pull/10750 > Push down WHERE clause arithmetic operator to JDBC layer > > > Key: SPARK-12506 > URL: https://issues.apache.org/jira/browse/SPARK-12506 > Project: Spark > Issue Type: Improvement > Components: SQL >Reporter: Huaxin Gao >Assignee: Apache Spark > > For arithmetic operator in WHERE clause such as > select * from table where c1 + c2 > 10 > Currently where c1 + c2 >10 is done at spark layer. > Will push this to JDBC layer so it will be done in database. -- This message was sent by Atlassian JIRA (v6.3.4#6332) - To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org
[jira] [Commented] (SPARK-12506) Push down WHERE clause arithmetic operator to JDBC layer
[ https://issues.apache.org/jira/browse/SPARK-12506?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15073658#comment-15073658 ] Huaxin Gao commented on SPARK-12506: https://github.com/apache/spark/pull/10505 > Push down WHERE clause arithmetic operator to JDBC layer > > > Key: SPARK-12506 > URL: https://issues.apache.org/jira/browse/SPARK-12506 > Project: Spark > Issue Type: Improvement > Components: SQL >Reporter: Huaxin Gao >Assignee: Apache Spark > > For arithmetic operator in WHERE clause such as > select * from table where c1 + c2 > 10 > Currently where c1 + c2 >10 is done at spark layer. > Will push this to JDBC layer so it will be done in database. -- This message was sent by Atlassian JIRA (v6.3.4#6332) - To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org
[jira] [Commented] (SPARK-12506) Push down WHERE clause arithmetic operator to JDBC layer
[ https://issues.apache.org/jira/browse/SPARK-12506?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15073653#comment-15073653 ] Huaxin Gao commented on SPARK-12506: Thanks for the comments. Yes, I changed the code at DataSourceStrategy, but the change is independent to the Cast in 9182. > Push down WHERE clause arithmetic operator to JDBC layer > > > Key: SPARK-12506 > URL: https://issues.apache.org/jira/browse/SPARK-12506 > Project: Spark > Issue Type: Improvement > Components: SQL >Reporter: Huaxin Gao >Assignee: Apache Spark > > For arithmetic operator in WHERE clause such as > select * from table where c1 + c2 > 10 > Currently where c1 + c2 >10 is done at spark layer. > Will push this to JDBC layer so it will be done in database. -- This message was sent by Atlassian JIRA (v6.3.4#6332) - To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org
[jira] [Commented] (SPARK-12506) Push down WHERE clause arithmetic operator to JDBC layer
[ https://issues.apache.org/jira/browse/SPARK-12506?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15072575#comment-15072575 ] Hyukjin Kwon commented on SPARK-12506: -- [~huaxing] Maybe we should do this one first https://issues.apache.org/jira/browse/SPARK-9182. I guess you might be thinking of the change of some codes at {{DataSourceStrategy}} or making this with {{CatalystScan}}, right? In case of {{CatalystScan}}, I opened the issue here already, https://issues.apache.org/jira/browse/SPARK-12126. In case of {{DataSourceStrategy}}, We might need to deal with {{Cast}} first. > Push down WHERE clause arithmetic operator to JDBC layer > > > Key: SPARK-12506 > URL: https://issues.apache.org/jira/browse/SPARK-12506 > Project: Spark > Issue Type: Improvement > Components: SQL >Reporter: Huaxin Gao > > For arithmetic operator in WHERE clause such as > select * from table where c1 + c2 > 10 > Currently where c1 + c2 >10 is done at spark layer. > Will push this to JDBC layer so it will be done in database. -- This message was sent by Atlassian JIRA (v6.3.4#6332) - To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org
[jira] [Commented] (SPARK-12506) Push down WHERE clause arithmetic operator to JDBC layer
[ https://issues.apache.org/jira/browse/SPARK-12506?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15070058#comment-15070058 ] Huaxin Gao commented on SPARK-12506: I am working on this and will have a PR soon. > Push down WHERE clause arithmetic operator to JDBC layer > > > Key: SPARK-12506 > URL: https://issues.apache.org/jira/browse/SPARK-12506 > Project: Spark > Issue Type: Improvement > Components: SQL >Reporter: Huaxin Gao > > For arithmetic operator in WHERE clause such as > select * from table where c1 + c2 > 10 > Currently where c1 + c2 >10 is done at spark layer. > Will push this to JDBC layer so it will be done in database. -- This message was sent by Atlassian JIRA (v6.3.4#6332) - To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org