[SPARK-29848] PostgreSQL dialect: cast to bigint

• Type: Sub-task
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: 3.1.0
• Component/s: SQL
• Assignee: Unassigned
• Reporter: ABHISHEK KUMAR GUPTA
• Created: 11/Nov/19 13:30
• Updated: 29/Mar/20 02:07

Description

Spark:

0: jdbc:hive2://10.18.19.208:23040/default> select CAST('0xcccccccccc' AS bigint);
-------------------------------

CAST(0xcccccccccc AS BIGINT)

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

NULL

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

Postgre SQL

22P02: invalid input syntax for integer: "0xcccccccccc"

Issue Links

• links to: GitHub Pull Request #26545