[GitHub] spark pull request: [SPARK-6201] [SQL] promote string and do widen...

2015-05-06 Thread yhuai
Github user yhuai commented on the pull request: https://github.com/apache/spark/pull/4945#issuecomment-99545780 Merged in master and branch 1.4. Thanks! --- 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 doe

[GitHub] spark pull request: [SPARK-6201] [SQL] promote string and do widen...

2015-05-06 Thread asfgit
Github user asfgit closed the pull request at: https://github.com/apache/spark/pull/4945 --- 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 enab

[GitHub] spark pull request: [SPARK-6201] [SQL] promote string and do widen...

2015-05-06 Thread rxin
Github user rxin commented on the pull request: https://github.com/apache/spark/pull/4945#issuecomment-99537523 Thanks. I'm going to merge this. --- 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 ha

[GitHub] spark pull request: [SPARK-6201] [SQL] promote string and do widen...

2015-04-27 Thread SparkQA
Github user SparkQA commented on the pull request: https://github.com/apache/spark/pull/4945#issuecomment-96773860 [Test build #31058 has started](https://amplab.cs.berkeley.edu/jenkins/job/SparkPullRequestBuilder/31058/consoleFull) for PR 4945 at commit [`71e05cc`](https://githu

[GitHub] spark pull request: [SPARK-6201] [SQL] promote string and do widen...

2015-04-22 Thread SparkQA
Github user SparkQA commented on the pull request: https://github.com/apache/spark/pull/4945#issuecomment-95069393 [Test build #30734 has finished](https://amplab.cs.berkeley.edu/jenkins/job/SparkPullRequestBuilder/30734/consoleFull) for PR 4945 at commit [`71e05cc`](https://gith

[GitHub] spark pull request: [SPARK-6201] [SQL] promote string and do widen...

2015-04-22 Thread AmplabJenkins
Github user AmplabJenkins commented on the pull request: https://github.com/apache/spark/pull/4945#issuecomment-95069403 Test PASSed. Refer to this link for build results (access rights to CI server needed): https://amplab.cs.berkeley.edu/jenkins//job/SparkPullRequestBuilder/30

[GitHub] spark pull request: [SPARK-6201] [SQL] promote string and do widen...

2015-04-21 Thread SparkQA
Github user SparkQA commented on the pull request: https://github.com/apache/spark/pull/4945#issuecomment-95047309 [Test build #30734 has started](https://amplab.cs.berkeley.edu/jenkins/job/SparkPullRequestBuilder/30734/consoleFull) for PR 4945 at commit [`71e05cc`](https://githu

[GitHub] spark pull request: [SPARK-6201] [SQL] promote string and do widen...

2015-04-21 Thread SparkQA
Github user SparkQA commented on the pull request: https://github.com/apache/spark/pull/4945#issuecomment-95043931 [Test build #30732 has finished](https://amplab.cs.berkeley.edu/jenkins/job/SparkPullRequestBuilder/30732/consoleFull) for PR 4945 at commit [`581fa1c`](https://gith

[GitHub] spark pull request: [SPARK-6201] [SQL] promote string and do widen...

2015-04-21 Thread AmplabJenkins
Github user AmplabJenkins commented on the pull request: https://github.com/apache/spark/pull/4945#issuecomment-95043939 Test FAILed. Refer to this link for build results (access rights to CI server needed): https://amplab.cs.berkeley.edu/jenkins//job/SparkPullRequestBuilder/30

[GitHub] spark pull request: [SPARK-6201] [SQL] promote string and do widen...

2015-04-21 Thread SparkQA
Github user SparkQA commented on the pull request: https://github.com/apache/spark/pull/4945#issuecomment-95042053 [Test build #30732 has started](https://amplab.cs.berkeley.edu/jenkins/job/SparkPullRequestBuilder/30732/consoleFull) for PR 4945 at commit [`581fa1c`](https://githu

[GitHub] spark pull request: [SPARK-6201] [SQL] promote string and do widen...

2015-04-17 Thread liancheng
Github user liancheng commented on the pull request: https://github.com/apache/spark/pull/4945#issuecomment-94008753 @adrian-wang @marmbrus Sorry for the late reply. Yeah, the MySQL way also seems reasonable to me. In both Spark SQL and MySQL, `IN` is treated more like an oper

[GitHub] spark pull request: [SPARK-6201] [SQL] promote string and do widen...

2015-04-16 Thread marmbrus
Github user marmbrus commented on the pull request: https://github.com/apache/spark/pull/4945#issuecomment-93867757 The mysql way seems reasonable to me. @liancheng ? --- If your project is set up for it, you can reply to this email and have your reply appear on GitHub as well. If yo

[GitHub] spark pull request: [SPARK-6201] [SQL] promote string and do widen...

2015-04-16 Thread adrian-wang
Github user adrian-wang commented on the pull request: https://github.com/apache/spark/pull/4945#issuecomment-93671496 If we don't like what hive does here, we can do it in MySQL way: Convert all expressions in the list to the type of left handle of IN. In fact the main differences he

[GitHub] spark pull request: [SPARK-6201] [SQL] promote string and do widen...

2015-04-13 Thread marmbrus
Github user marmbrus commented on the pull request: https://github.com/apache/spark/pull/4945#issuecomment-92554707 Any comments on @liancheng 's suggestion? --- 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

[GitHub] spark pull request: [SPARK-6201] [SQL] promote string and do widen...

2015-04-04 Thread liancheng
Github user liancheng commented on the pull request: https://github.com/apache/spark/pull/4945#issuecomment-89621194 The thing that makes me hesitant here is whether we should stick to Hive, because Hive's behavior is actually error prone and unintuitive. In Hive, `IN` is implemented

[GitHub] spark pull request: [SPARK-6201] [SQL] promote string and do widen...

2015-04-02 Thread marmbrus
Github user marmbrus commented on the pull request: https://github.com/apache/spark/pull/4945#issuecomment-89094024 What is the status here? I haven't looked closely but this seems reasonable to me. However, I'd like to see more hive comparison tests that specifically test edge case

[GitHub] spark pull request: [SPARK-6201] [SQL] promote string and do widen...

2015-03-09 Thread adrian-wang
Github user adrian-wang commented on the pull request: https://github.com/apache/spark/pull/4945#issuecomment-77998513 @liancheng That's reasonable, not every string could be converted into numeric types. Hive specified about this as /** * GenericUDFIn * * Exampl

[GitHub] spark pull request: [SPARK-6201] [SQL] promote string and do widen...

2015-03-09 Thread SparkQA
Github user SparkQA commented on the pull request: https://github.com/apache/spark/pull/4945#issuecomment-77993513 [Test build #28420 has finished](https://amplab.cs.berkeley.edu/jenkins/job/SparkPullRequestBuilder/28420/consoleFull) for PR 4945 at commit [`cd72593`](https://gith

[GitHub] spark pull request: [SPARK-6201] [SQL] promote string and do widen...

2015-03-09 Thread AmplabJenkins
Github user AmplabJenkins commented on the pull request: https://github.com/apache/spark/pull/4945#issuecomment-77993517 Test PASSed. Refer to this link for build results (access rights to CI server needed): https://amplab.cs.berkeley.edu/jenkins//job/SparkPullRequestBuilder/28

[GitHub] spark pull request: [SPARK-6201] [SQL] promote string and do widen...

2015-03-09 Thread SparkQA
Github user SparkQA commented on the pull request: https://github.com/apache/spark/pull/4945#issuecomment-77988265 [Test build #28420 has started](https://amplab.cs.berkeley.edu/jenkins/job/SparkPullRequestBuilder/28420/consoleFull) for PR 4945 at commit [`cd72593`](https://githu

[GitHub] spark pull request: [SPARK-6201] [SQL] promote string and do widen...

2015-03-09 Thread liancheng
Github user liancheng commented on a diff in the pull request: https://github.com/apache/spark/pull/4945#discussion_r26054740 --- Diff: sql/catalyst/src/main/scala/org/apache/spark/sql/catalyst/analysis/HiveTypeCoercion.scala --- @@ -269,6 +285,14 @@ trait HiveTypeCoercion {

[GitHub] spark pull request: [SPARK-6201] [SQL] promote string and do widen...

2015-03-09 Thread liancheng
Github user liancheng commented on a diff in the pull request: https://github.com/apache/spark/pull/4945#discussion_r26054354 --- Diff: sql/catalyst/src/main/scala/org/apache/spark/sql/catalyst/analysis/HiveTypeCoercion.scala --- @@ -269,6 +285,14 @@ trait HiveTypeCoercion {

[GitHub] spark pull request: [SPARK-6201] [SQL] promote string and do widen...

2015-03-09 Thread chenghao-intel
Github user chenghao-intel commented on a diff in the pull request: https://github.com/apache/spark/pull/4945#discussion_r26044965 --- Diff: sql/catalyst/src/main/scala/org/apache/spark/sql/catalyst/analysis/HiveTypeCoercion.scala --- @@ -220,6 +220,22 @@ trait HiveTypeCoercion {

[GitHub] spark pull request: [SPARK-6201] [SQL] promote string and do widen...

2015-03-09 Thread chenghao-intel
Github user chenghao-intel commented on a diff in the pull request: https://github.com/apache/spark/pull/4945#discussion_r26044586 --- Diff: sql/catalyst/src/main/scala/org/apache/spark/sql/catalyst/analysis/HiveTypeCoercion.scala --- @@ -269,6 +285,14 @@ trait HiveTypeCoercion {

[GitHub] spark pull request: [SPARK-6201] [SQL] promote string and do widen...

2015-03-09 Thread AmplabJenkins
Github user AmplabJenkins commented on the pull request: https://github.com/apache/spark/pull/4945#issuecomment-77812220 Test PASSed. Refer to this link for build results (access rights to CI server needed): https://amplab.cs.berkeley.edu/jenkins//job/SparkPullRequestBuilder/28

[GitHub] spark pull request: [SPARK-6201] [SQL] promote string and do widen...

2015-03-09 Thread SparkQA
Github user SparkQA commented on the pull request: https://github.com/apache/spark/pull/4945#issuecomment-77812210 [Test build #28382 has finished](https://amplab.cs.berkeley.edu/jenkins/job/SparkPullRequestBuilder/28382/consoleFull) for PR 4945 at commit [`6c838c4`](https://gith

[GitHub] spark pull request: [SPARK-6201] [SQL] promote string and do widen...

2015-03-08 Thread SparkQA
Github user SparkQA commented on the pull request: https://github.com/apache/spark/pull/4945#issuecomment-77806425 [Test build #28382 has started](https://amplab.cs.berkeley.edu/jenkins/job/SparkPullRequestBuilder/28382/consoleFull) for PR 4945 at commit [`6c838c4`](https://githu

[GitHub] spark pull request: [SPARK-6201] [SQL] promote string and do widen...

2015-03-08 Thread adrian-wang
GitHub user adrian-wang opened a pull request: https://github.com/apache/spark/pull/4945 [SPARK-6201] [SQL] promote string and do widen types for IN @huangjs Acutally spark sql will first go through analysis period, in which we do widen types and promote strings, and then optimi