spark-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Dongjoon Hyun (JIRA)" <j...@apache.org>
Subject [jira] [Comment Edited] (SPARK-17818) Cannot SELECT NULL
Date Fri, 07 Oct 2016 01:37:20 GMT

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

Dongjoon Hyun edited comment on SPARK-17818 at 10/7/16 1:37 AM:
----------------------------------------------------------------

Ur, Todd.
Could you look at your JIRA description again? The following is what I mentioned as `your
example`. I don't believe that is a valid one. What I wanted is answering your request. :)

> When connecting to Spark SQL via JDBC/thriftserver, running `SELECT NULL` returns this
error:
{code}
0: jdbc:hive2://localhost:10016/> select cast(NULL as NULL);
Error: org.apache.spark.sql.catalyst.parser.ParseException: 
DataType null() is not supported.(line 1, pos 20)
{code}


was (Author: dongjoon):
Ur, Todd.
Could you look at your JIRA description again? The following is what I mentioned as `your
example`. I don't believe that is a valid one. What I wanted is answering your request. :)

> When connecting to Spark SQL via JDBC/thriftserver, running `SELECT NULL` returns this
error:
{code}
0: jdbc:hive2://localhost:10016/> select cast(NULL as NULL);
Error: org.apache.spark.sql.catalyst.parser.ParseException: 
DataType null() is not supported.(line 1, pos 20)
{cde}

> Cannot SELECT NULL
> ------------------
>
>                 Key: SPARK-17818
>                 URL: https://issues.apache.org/jira/browse/SPARK-17818
>             Project: Spark
>          Issue Type: Bug
>          Components: SQL
>    Affects Versions: 2.0.0, 2.0.1
>            Reporter: Todd Nemet
>             Fix For: 2.0.2
>
>
> When connecting to Spark SQL via JDBC/thriftserver, running `SELECT NULL` returns this
error:
> {code}
> 0: jdbc:hive2://localhost:10016/> select cast(NULL as NULL);
> Error: org.apache.spark.sql.catalyst.parser.ParseException: 
> DataType null() is not supported.(line 1, pos 20)
> {code}
> This is a regression from Spark 1.x/Hive QL compatibility. In Spark 1.5.2, The same query
returns NULL:
> {code}
> 0: jdbc:hive2://localhost:10015/> select null;
> +-------+--+
> |  _c0  |
> +-------+--+
> | NULL  |
> +-------+--+
> 1 row selected (0.658 seconds)
> {code}
> I can select expressions that evaluate to NULL or CAST NULL to different types:
> {code}
> 0: jdbc:hive2://localhost:10016/> select null=null
> 0: jdbc:hive2://localhost:10016/> ;
> +----------------+--+
> | (NULL = NULL)  |
> +----------------+--+
> | NULL           |
> +----------------+--+
> 1 row selected (0.69 seconds)
> 0: jdbc:hive2://localhost:10016/> select cast (NULL as int);
> +--------------------+--+
> | CAST(NULL AS INT)  |
> +--------------------+--+
> | NULL               |
> +--------------------+--+
> 1 row selected (0.676 seconds)
> 0: jdbc:hive2://localhost:10016/> select cast (NULL as string);
> +-----------------------+--+
> | CAST(NULL AS STRING)  |
> +-----------------------+--+
> | NULL                  |
> +-----------------------+--+
> {code}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

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


Mime
View raw message