[SPARK-27148] Support CURRENT_TIME and LOCALTIME when ANSI mode enabled

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Later
• Affects Version/s: 3.1.0
• Component/s: SQL
• Assignee: Unassigned Assign to me
• Reporter: Takeshi Yamamuro
• Created: 13/Mar/19 07:49
• Updated: 23/Jun/20 01:04
• Resolved: 23/Jun/20 01:04

Description

CURRENT_TIME and LOCALTIME should be supported in the ANSI standard;

postgres=# select CURRENT_TIME;

       timetz       

--------------------

16:45:43.398109+09

(1 row)

postgres=# select LOCALTIME;

      time      

----------------

16:45:48.60969

(1 row)

Before this, we need to support TIME types (java.sql.Time).

Issue Links

• relates to: SPARK-7101 Spark SQL should support java.sql.Time