[GitHub] spark issue #14786: [SPARK-17212][SQL] TypeCoercion supports widening conver...
Github user SparkQA commented on the issue: https://github.com/apache/spark/pull/14786 **[Test build #64345 has started](https://amplab.cs.berkeley.edu/jenkins/job/SparkPullRequestBuilder/64345/consoleFull)** for PR 14786 at commit [`d49fbdb`](https://github.com/apache/spark/commit/d49fbdbacd6b3ced5801ff62afc7ec12a8831028). --- If your project is set up for it, you can reply to this email and have your reply appear on GitHub as well. If your project does not have this feature enabled and wishes so, or if the feature is enabled but not working, please contact infrastructure at infrastruct...@apache.org or file a JIRA ticket with INFRA. --- - To unsubscribe, e-mail: reviews-unsubscr...@spark.apache.org For additional commands, e-mail: reviews-h...@spark.apache.org
[GitHub] spark issue #14786: [SPARK-17212][SQL] TypeCoercion supports widening conver...
Github user SparkQA commented on the issue: https://github.com/apache/spark/pull/14786 **[Test build #64345 has finished](https://amplab.cs.berkeley.edu/jenkins/job/SparkPullRequestBuilder/64345/consoleFull)** for PR 14786 at commit [`d49fbdb`](https://github.com/apache/spark/commit/d49fbdbacd6b3ced5801ff62afc7ec12a8831028). * This patch passes all tests. * This patch merges cleanly. * This patch adds no public classes. --- If your project is set up for it, you can reply to this email and have your reply appear on GitHub as well. If your project does not have this feature enabled and wishes so, or if the feature is enabled but not working, please contact infrastructure at infrastruct...@apache.org or file a JIRA ticket with INFRA. --- - To unsubscribe, e-mail: reviews-unsubscr...@spark.apache.org For additional commands, e-mail: reviews-h...@spark.apache.org
[GitHub] spark issue #14786: [SPARK-17212][SQL] TypeCoercion supports widening conver...
Github user AmplabJenkins commented on the issue: https://github.com/apache/spark/pull/14786 Merged build finished. Test PASSed. --- If your project is set up for it, you can reply to this email and have your reply appear on GitHub as well. If your project does not have this feature enabled and wishes so, or if the feature is enabled but not working, please contact infrastructure at infrastruct...@apache.org or file a JIRA ticket with INFRA. --- - To unsubscribe, e-mail: reviews-unsubscr...@spark.apache.org For additional commands, e-mail: reviews-h...@spark.apache.org
[GitHub] spark issue #14786: [SPARK-17212][SQL] TypeCoercion supports widening conver...
Github user AmplabJenkins commented on the issue: https://github.com/apache/spark/pull/14786 Test PASSed. Refer to this link for build results (access rights to CI server needed): https://amplab.cs.berkeley.edu/jenkins//job/SparkPullRequestBuilder/64345/ Test PASSed. --- If your project is set up for it, you can reply to this email and have your reply appear on GitHub as well. If your project does not have this feature enabled and wishes so, or if the feature is enabled but not working, please contact infrastructure at infrastruct...@apache.org or file a JIRA ticket with INFRA. --- - To unsubscribe, e-mail: reviews-unsubscr...@spark.apache.org For additional commands, e-mail: reviews-h...@spark.apache.org
[GitHub] spark issue #14786: [SPARK-17212][SQL] TypeCoercion supports widening conver...
Github user HyukjinKwon commented on the issue: https://github.com/apache/spark/pull/14786 Cc @cloud-fan and @petermaxlee could you please take a look for this one? --- If your project is set up for it, you can reply to this email and have your reply appear on GitHub as well. If your project does not have this feature enabled and wishes so, or if the feature is enabled but not working, please contact infrastructure at infrastruct...@apache.org or file a JIRA ticket with INFRA. --- - To unsubscribe, e-mail: reviews-unsubscr...@spark.apache.org For additional commands, e-mail: reviews-h...@spark.apache.org
[GitHub] spark issue #14786: [SPARK-17212][SQL] TypeCoercion supports widening conver...
Github user cloud-fan commented on the issue: https://github.com/apache/spark/pull/14786 Have you checked with other databases? It looks reasonable to do this but I'd like to know how other databases deal with this case. --- If your project is set up for it, you can reply to this email and have your reply appear on GitHub as well. If your project does not have this feature enabled and wishes so, or if the feature is enabled but not working, please contact infrastructure at infrastruct...@apache.org or file a JIRA ticket with INFRA. --- - To unsubscribe, e-mail: reviews-unsubscr...@spark.apache.org For additional commands, e-mail: reviews-h...@spark.apache.org
[GitHub] spark issue #14786: [SPARK-17212][SQL] TypeCoercion supports widening conver...
Github user HyukjinKwon commented on the issue: https://github.com/apache/spark/pull/14786 I have only checked Hive it seems it does not handle this case. I will check others and be back soon. --- If your project is set up for it, you can reply to this email and have your reply appear on GitHub as well. If your project does not have this feature enabled and wishes so, or if the feature is enabled but not working, please contact infrastructure at infrastruct...@apache.org or file a JIRA ticket with INFRA. --- - To unsubscribe, e-mail: reviews-unsubscr...@spark.apache.org For additional commands, e-mail: reviews-h...@spark.apache.org
[GitHub] spark issue #14786: [SPARK-17212][SQL] TypeCoercion supports widening conver...
Github user HyukjinKwon commented on the issue: https://github.com/apache/spark/pull/14786 MySQL and PostgreSQL support this **MySQL** - Greatest/leastest ```sql mysql> SELECT GREATEST(CAST("1990-02-24 12:00:00" AS DATETIME), CAST("1990-02-25" AS DATE)); +---+ | GREATEST(CAST("1990-02-24 12:00:00" AS DATETIME), CAST("1990-02-25" AS DATE)) | +---+ | 1990-02-25 00:00:00 | +---+ ``` - Union ```sql mysql> SELECT CAST("1990-02-24 12:00:00" AS DATETIME) UNION SELECT CAST("1990-02-24" AS DATE); +-+ | CAST("1990-02-24 12:00:00" AS DATETIME) | +-+ | 1990-02-24 12:00:00 | | 1990-02-24 00:00:00 | +-+ ``` **PostgreSQL** - Greatest/leatest ```sql postgres=# SELECT GREATEST(CAST('1990-02-24 12:00:00' AS TIMESTAMP), CAST('1990-02-25' AS DATE)); greatest - 1990-02-25 00:00:00 (1 row) ``` - Union ```sql postgres=# SELECT CAST('1990-02-24 12:00:00' AS TIMESTAMP) UNION SELECT CAST('1990-02-24' AS DATE); timestamp - 1990-02-24 00:00:00 1990-02-24 12:00:00 (2 rows) ``` --- If your project is set up for it, you can reply to this email and have your reply appear on GitHub as well. If your project does not have this feature enabled and wishes so, or if the feature is enabled but not working, please contact infrastructure at infrastruct...@apache.org or file a JIRA ticket with INFRA. --- - To unsubscribe, e-mail: reviews-unsubscr...@spark.apache.org For additional commands, e-mail: reviews-h...@spark.apache.org
[GitHub] spark issue #14786: [SPARK-17212][SQL] TypeCoercion supports widening conver...
Github user SparkQA commented on the issue: https://github.com/apache/spark/pull/14786 **[Test build #64411 has started](https://amplab.cs.berkeley.edu/jenkins/job/SparkPullRequestBuilder/64411/consoleFull)** for PR 14786 at commit [`ab754fa`](https://github.com/apache/spark/commit/ab754fa8eb537dcd6ce3f4f3b256f0fba2f2fdcd). --- If your project is set up for it, you can reply to this email and have your reply appear on GitHub as well. If your project does not have this feature enabled and wishes so, or if the feature is enabled but not working, please contact infrastructure at infrastruct...@apache.org or file a JIRA ticket with INFRA. --- - To unsubscribe, e-mail: reviews-unsubscr...@spark.apache.org For additional commands, e-mail: reviews-h...@spark.apache.org
[GitHub] spark issue #14786: [SPARK-17212][SQL] TypeCoercion supports widening conver...
Github user SparkQA commented on the issue: https://github.com/apache/spark/pull/14786 **[Test build #64411 has finished](https://amplab.cs.berkeley.edu/jenkins/job/SparkPullRequestBuilder/64411/consoleFull)** for PR 14786 at commit [`ab754fa`](https://github.com/apache/spark/commit/ab754fa8eb537dcd6ce3f4f3b256f0fba2f2fdcd). * This patch passes all tests. * This patch merges cleanly. * This patch adds no public classes. --- If your project is set up for it, you can reply to this email and have your reply appear on GitHub as well. If your project does not have this feature enabled and wishes so, or if the feature is enabled but not working, please contact infrastructure at infrastruct...@apache.org or file a JIRA ticket with INFRA. --- - To unsubscribe, e-mail: reviews-unsubscr...@spark.apache.org For additional commands, e-mail: reviews-h...@spark.apache.org
[GitHub] spark issue #14786: [SPARK-17212][SQL] TypeCoercion supports widening conver...
Github user AmplabJenkins commented on the issue: https://github.com/apache/spark/pull/14786 Merged build finished. Test PASSed. --- If your project is set up for it, you can reply to this email and have your reply appear on GitHub as well. If your project does not have this feature enabled and wishes so, or if the feature is enabled but not working, please contact infrastructure at infrastruct...@apache.org or file a JIRA ticket with INFRA. --- - To unsubscribe, e-mail: reviews-unsubscr...@spark.apache.org For additional commands, e-mail: reviews-h...@spark.apache.org
[GitHub] spark issue #14786: [SPARK-17212][SQL] TypeCoercion supports widening conver...
Github user AmplabJenkins commented on the issue: https://github.com/apache/spark/pull/14786 Test PASSed. Refer to this link for build results (access rights to CI server needed): https://amplab.cs.berkeley.edu/jenkins//job/SparkPullRequestBuilder/64411/ Test PASSed. --- If your project is set up for it, you can reply to this email and have your reply appear on GitHub as well. If your project does not have this feature enabled and wishes so, or if the feature is enabled but not working, please contact infrastructure at infrastruct...@apache.org or file a JIRA ticket with INFRA. --- - To unsubscribe, e-mail: reviews-unsubscr...@spark.apache.org For additional commands, e-mail: reviews-h...@spark.apache.org
[GitHub] spark issue #14786: [SPARK-17212][SQL] TypeCoercion supports widening conver...
Github user SparkQA commented on the issue: https://github.com/apache/spark/pull/14786 **[Test build #64419 has started](https://amplab.cs.berkeley.edu/jenkins/job/SparkPullRequestBuilder/64419/consoleFull)** for PR 14786 at commit [`d035eb3`](https://github.com/apache/spark/commit/d035eb3ba725250f6238a5b8a189b6749065cf95). --- If your project is set up for it, you can reply to this email and have your reply appear on GitHub as well. If your project does not have this feature enabled and wishes so, or if the feature is enabled but not working, please contact infrastructure at infrastruct...@apache.org or file a JIRA ticket with INFRA. --- - To unsubscribe, e-mail: reviews-unsubscr...@spark.apache.org For additional commands, e-mail: reviews-h...@spark.apache.org
[GitHub] spark issue #14786: [SPARK-17212][SQL] TypeCoercion supports widening conver...
Github user SparkQA commented on the issue: https://github.com/apache/spark/pull/14786 **[Test build #64419 has finished](https://amplab.cs.berkeley.edu/jenkins/job/SparkPullRequestBuilder/64419/consoleFull)** for PR 14786 at commit [`d035eb3`](https://github.com/apache/spark/commit/d035eb3ba725250f6238a5b8a189b6749065cf95). * This patch passes all tests. * This patch merges cleanly. * This patch adds no public classes. --- If your project is set up for it, you can reply to this email and have your reply appear on GitHub as well. If your project does not have this feature enabled and wishes so, or if the feature is enabled but not working, please contact infrastructure at infrastruct...@apache.org or file a JIRA ticket with INFRA. --- - To unsubscribe, e-mail: reviews-unsubscr...@spark.apache.org For additional commands, e-mail: reviews-h...@spark.apache.org
[GitHub] spark issue #14786: [SPARK-17212][SQL] TypeCoercion supports widening conver...
Github user AmplabJenkins commented on the issue: https://github.com/apache/spark/pull/14786 Test PASSed. Refer to this link for build results (access rights to CI server needed): https://amplab.cs.berkeley.edu/jenkins//job/SparkPullRequestBuilder/64419/ Test PASSed. --- If your project is set up for it, you can reply to this email and have your reply appear on GitHub as well. If your project does not have this feature enabled and wishes so, or if the feature is enabled but not working, please contact infrastructure at infrastruct...@apache.org or file a JIRA ticket with INFRA. --- - To unsubscribe, e-mail: reviews-unsubscr...@spark.apache.org For additional commands, e-mail: reviews-h...@spark.apache.org
[GitHub] spark issue #14786: [SPARK-17212][SQL] TypeCoercion supports widening conver...
Github user AmplabJenkins commented on the issue: https://github.com/apache/spark/pull/14786 Merged build finished. Test PASSed. --- If your project is set up for it, you can reply to this email and have your reply appear on GitHub as well. If your project does not have this feature enabled and wishes so, or if the feature is enabled but not working, please contact infrastructure at infrastruct...@apache.org or file a JIRA ticket with INFRA. --- - To unsubscribe, e-mail: reviews-unsubscr...@spark.apache.org For additional commands, e-mail: reviews-h...@spark.apache.org
[GitHub] spark issue #14786: [SPARK-17212][SQL] TypeCoercion supports widening conver...
Github user cloud-fan commented on the issue: https://github.com/apache/spark/pull/14786 thanks, merging to master! --- If your project is set up for it, you can reply to this email and have your reply appear on GitHub as well. If your project does not have this feature enabled and wishes so, or if the feature is enabled but not working, please contact infrastructure at infrastruct...@apache.org or file a JIRA ticket with INFRA. --- - To unsubscribe, e-mail: reviews-unsubscr...@spark.apache.org For additional commands, e-mail: reviews-h...@spark.apache.org