[
https://issues.apache.org/jira/browse/SPARK-29896?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Kent Yao resolved SPARK-29896.
------------------------------
Resolution: Won't Fix
> Extend typed literals support for all spark native types
> --------------------------------------------------------
>
> Key: SPARK-29896
> URL: https://issues.apache.org/jira/browse/SPARK-29896
> Project: Spark
> Issue Type: Improvement
> Components: SQL
> Affects Versions: 3.0.0
> Reporter: Kent Yao
> Priority: Major
>
> Currently, Date, Timestamp, Interval, Binary, and INTEGER typed literals are
> supported.
> We should support other native datatypes for this feature.
> {code:sql}
> +-- typed literals
> +-- boolean
> +select boolean 'true';
> +select boolean 'false';
> +select boolean 't';
> +select boolean 'f';
> +select boolean 'yes';
> +select boolean 'no';
> +select -boolean 'true';
> +
> +-- byte
> +select tinyint '1';
> +select tinyint '-1';
> +select tinyint '128';
> +select byte '1';
> +select -tinyint '1';
> +
> +-- short
> +select smallint '1';
> +select smallint '-1';
> +select smallint '32768';
> +select short '1';
> +select -smallint '1';
> +
> +-- long
> +select long '1';
> +select bigint '-1';
> +select -bigint '1';
> +
> +-- float/double
> +select float '1';
> +select -float '-1';
> +select double '1';
> +select -double '1';
> +
> +-- hive string type
> +select char(10) '12345';
> +select varchar(10) '12345';
> +
> +-- binary
> +select binary '12345';
> +
> +-- decimal
> +select decimal '1.000001';
> +select decimal(10, 2) '11.1';
> +select decimal(2, 0) '11.1';
> +select decimal(2, 1) '11.1';
> {code}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org
